Importing from Excel or CSV - To Do List, Organizer, Checklist, PIM, Time and Task Management software for better personal and business productivity

Rowan Sylvester-Bradley

Guest

10/03/2007 10:29:51

Just downloaded and trying VIP Organizer. It looks as if it's got pretty well all the features I need, but I've got a huge number of tasks currently in Excel that I'd like to import. Can I do this? How do I have to format the Excel or CSV file so it will correctly import new tasks from file? In particular what do I have to put in the ID field, or is there a way of leaving this blank, for a new task, and having VIP Organizer create an ID on import?

Thanks - Rowan

Serge

Administrator

Posts: 206 Points: 167 Joined: 08/19/2006

10/04/2007 02:55:33

Dear Rowan,

You can leave some columns blank like ID, Date Completed, etc., but you need to preserve the order of the format. The format is the following:

"id","name","priority","due_date","estimated_time","actual_time","done","category","reminder_datetime","reminder_file","complete","daysLeft","status","reminder_msgbox","link_file","note","note_rtf","date_created","date_opened","date_modified","date_completed"

So you will have something like this:

"","Send news","High","2007-01-23 15:10:00","0","0","False","Project","","","0","-254","Created","True","","","{\rtf1\ansi\deff0{\fonttbl{\f0\fnil MS Sans Serif;}}
\viewkind4\uc1\pard\lang1049\f0\fs16\par}","2006-11-15 09:41:29","2006-11-15 09:41:29","2007-01-23 14:52:31","2006-11-15 09:41:29"

Regards,
Serge

Rowan Sylvester-Bradley

Guest

10/04/2007 12:03:16

Thanks for your reply. I can't get this to work. I copied your exact text from your message into a CSV file, and imported it into VIP Organizer. It said it had completed the task successfully but the new task did not appear.

I then tried exporting the database to a new CSV file (in case the new task was there but not showing for some reason), but it wasn't there in the exported CSV file either. What might I be doing wrong?

Thanks - Rowan

Serge Administrator Posts: 206 Points: 167 Joined: 08/19/2006	#4 10/05/2007 03:00:25 Dear Rowan, The CSV file shoul contain this part in the beginning: "id","name","priority","due_date","estimated_time","actual_time","done","category","reminder_datetime","reminder_file","complete","daysLeft","status","reminder_msgbox","link_file","note","note_rtf","date_created","date_opened","date_modified","date_completed" And then actual tasks. I will send you the sample by email. Regards, Serge