loteoo / icsp Goto Github PK

Hey loteoo,

in my usecase I have one big ics file and I'd like to filter certain events and/or save them in separate files. For example:

# Show me all events with the word "fish" in the summary field
icsp -k summary -f fish foo.ics

# Split the events by summary
icsp -s -k summary -o file_prefix_

What do you think?

Hey, first of all, thank you for your work and this useful tool. I've ran into a Problem where Fields that aren't required, but used by an entry are ''spread" across the following entries. For Example: I've created a very simple personal Calendar in Nextcloud, filled it with basic events, downloaded and exported it to csv. Everything is fine:
icsp -d ';' -c 'dtstart,dtend,duration,summary,location,description,uid,rrule' downloads/statistik.ics dtstart;dtend;duration;summary;location;description;uid;rrule 2023-08-20 00:00:00;2023-08-21 00:00:00;24h;Urlaub HalB;;;7efbfd4c-26c0-49a0-a313-46289a704939; 2023-08-17 09:15:00;2023-08-17 09:30:00;15m;BANANE;;;deda4219-57d2-4f99-a355-f45f85809e9f; 2023-08-17 00:00:00;2023-08-18 00:00:00;24h;Urlaub;;;5010453c-180b-43d4-b180-127c33516cd3; 2023-08-16 07:45:00;2023-08-16 08:00:00;15m;Test Mi;;;05f7aea8-1f33-46fc-bf3c-682a3ddca010; 2023-08-15 11:45:00;2023-08-15 12:00:00;15m;Test Di;;;5cb9f2ec-9627-49e8-a2c0-60f7e61388ff; 2023-08-24 00:00:00;2023-08-25 00:00:00;24h;Test Di;;;a7ec67e1-e365-4def-8e09-c14b3432c038; 2023-08-19 10:00:00;2023-08-19 10:15:00;15m;Test Fr;;;c203f653-95ba-4332-9d27-3ba7eeeeb5e9; 2023-08-19 07:00:00;2023-08-19 08:45:00;1h45m;Test Fr;;;47f13a33-028e-4226-9506-577638a3d139; 2023-08-20 08:15:00;2023-08-20 08:30:00;15m;HALLO;;;77f44a2a-79db-4b68-a095-18484d27a977; 2023-08-17 07:00:00;2023-08-17 07:15:00;15m;BLABLA;;;0d07c308-2f9b-4943-8f30-f5defa647795; 2023-08-18 00:00:00;2023-08-19 00:00:00;24h;Test Ganztag;;;19693894-8a66-42b9-b7dc-7c18486181bc;

But when i add an repeating entry, redownload and reexport, suddenly all entries are repeating:
icsp -d ';' -c 'dtstart,dtend,duration,summary,location,description,uid,rrule' downloads/statistik.ics dtstart;dtend;duration;summary;location;description;uid;rrule 2023-08-14 09:30:00;2023-08-14 09:45:00;15m;RepeatingMonday;;;2b78084d-f32d-4b64-b71e-f2e940e8a835;"FREQ=WEEKLY;BYDAY=WE;UNTIL=20230816T072959Z" 2023-08-20 00:00:00;2023-08-21 00:00:00;24h;Urlaub HalB;;;7efbfd4c-26c0-49a0-a313-46289a704939;"FREQ=WEEKLY;BYDAY=WE;UNTIL=20230816T072959Z" 2023-08-17 09:15:00;2023-08-17 09:30:00;15m;BANANE;;;deda4219-57d2-4f99-a355-f45f85809e9f;"FREQ=WEEKLY;BYDAY=WE;UNTIL=20230816T072959Z" 2023-08-17 00:00:00;2023-08-18 00:00:00;24h;Urlaub;;;5010453c-180b-43d4-b180-127c33516cd3;"FREQ=WEEKLY;BYDAY=WE;UNTIL=20230816T072959Z" 2023-08-16 07:45:00;2023-08-16 08:00:00;15m;Test Mi;;;05f7aea8-1f33-46fc-bf3c-682a3ddca010;"FREQ=WEEKLY;BYDAY=WE;UNTIL=20230816T072959Z" 2023-08-14 08:45:00;2023-08-14 09:00:00;15m;Test Mi;;;d933a700-e247-444d-9653-04687037647a;"FREQ=WEEKLY;BYDAY=MO" 2023-08-15 11:45:00;2023-08-15 12:00:00;15m;Test Di;;;5cb9f2ec-9627-49e8-a2c0-60f7e61388ff;"FREQ=WEEKLY;BYDAY=MO" 2023-08-24 00:00:00;2023-08-25 00:00:00;24h;Test Di;;;a7ec67e1-e365-4def-8e09-c14b3432c038;"FREQ=WEEKLY;BYDAY=MO" 2023-08-19 10:00:00;2023-08-19 10:15:00;15m;Test Fr;;;c203f653-95ba-4332-9d27-3ba7eeeeb5e9;"FREQ=WEEKLY;BYDAY=MO" 2023-08-19 07:00:00;2023-08-19 08:45:00;1h45m;Test Fr;;;47f13a33-028e-4226-9506-577638a3d139;"FREQ=WEEKLY;BYDAY=MO" 2023-08-20 08:15:00;2023-08-20 08:30:00;15m;HALLO;;;77f44a2a-79db-4b68-a095-18484d27a977;"FREQ=WEEKLY;BYDAY=MO" 2023-08-17 07:00:00;2023-08-17 07:15:00;15m;BLABLA;;;0d07c308-2f9b-4943-8f30-f5defa647795;"FREQ=WEEKLY;BYDAY=MO" 2023-08-16 09:30:00;2023-08-16 09:45:00;15m;RepeatingMonday;;;cdab18a8-7c2d-4d11-98a1-58edfcbc7a6e;"FREQ=WEEKLY;BYDAY=MO" 2023-08-18 00:00:00;2023-08-19 00:00:00;24h;Test Ganztag;;;19693894-8a66-42b9-b7dc-7c18486181bc;"FREQ=WEEKLY;BYDAY=MO"

The same works with color or seemingly every Field that's not required. It seems like the Variables that contain these Fields are not getting emptied after each entry, hence the "sticking" behavior. If the Following Entry has a Value in this field, for example another Color, the Value is Updated, but if its not populated, the value from the last entry is used.

I've tried to fix this in the code, but frankly, i lack the understanding of your script (or skill) to do so.

EDIT: my example with the "rrule" field breaks the output csv because the value contains semicolons. But this does not alter the behavior of the script