Import CSV to new timeline
Hey, i'd like to have a function to import a CSV file to a new timeline.
For example one could export all emails from one folder of thunderbird to a CSV file. This file would include subject, from, to, date time. After import to ManicTime each emails would be shown in an additional timeline with a configurable duration of x min.
Another example: Export the call log from your phone / PBX, with phone numbers, date, start, end time and import it to ManicTime.
Would be very helpful :-)
port119
shared this idea
CSV timeline is available in ManicTime v2023.1 or later
https://docs.manictime.com/win-client/plugins/timeline-plugins#custom-file-source-timeline-csv
-
J.
commented
The emails and phone call parts of this should be separate I think. The phone calls part should be merged (or at least counted with) the Cisco Phones request linked below.
Keep in mind this would also work for Google Voice (via Google Takeout) and I think pretty much every VOIP/SIP provides a CSV export (8x8, Vonage, Anveo, voip.ms, ....)
A CSV import with a field mapper would open this up for all of them.
Granted I'd much rather see a proper plug-in/helper but I don't have the skills to put that together and obviously it's a lot of work because all the different services. A CSV import, with a way to map fields can kill many many birds with one stone.
-
J.
commented
Just gonna add this suggestion link here for Cisco phones http://support.manictime.com/forums/222041-feature-requests/suggestions/12415989-cisco-pbx-call-tracking-timeline
There's a bit of support asking for phones and phone systems to be pulled into MT. I'd like to see it and it makes it more useful for businesses.
-
J.
commented
@imanuel What script are you using for this? Do you have a link or would you share it?
I'd like to use/adapt it for Asterisk
(FreePBX specifically but should be generic enough for all Asterisk I think)thanks.
-
Anonymous
commented
I like this idea especially for importing phone logs
-
Edward Sullivan
commented
Another workaround would be to format the CSVs as a Google calendar import files, import them into dedicated Google Calendars snd use the AddTimeline settings to link the GCs into ManicTime. See also https://it.stonybrook.edu/help/kb/importing-calendar-events-from-csv-to-google-calendar
-
port119
commented
@Imanuel: Thanks for the hint. Do you use a PHP script? Could you make it public? Is this custom timeline available in the timesheet?
-
Imanuel
commented
If you have access to a webserver, you can use a custom timeline as a workaround. You'd need to have a script accessible via http that return the csv data in ManicTime format: http://support.manictime.com/knowledgebase/articles/686418-custom-timeline
I use this solution for calls. All call logs are imported to a database that ManicTime can acces via a php script.