ForumsSearch
Search results for "Posted by Swannej"
| Author | Message |
|---|---|
|
Swannej |
Posted Nov 10, 2010 in: Wrong date format after importing tasks from Outlook
Score: 0
Just had a reply to my Support Ticket on this subject. The answer is I need to export from Outlook into a CSV file, then open the CSV file in Excel and convert the date column to the MM-DD-YYYY format in the CSV file. Then I can import into Toodledo from the edited CSV file.
|
|
Swannej |
Posted Nov 10, 2010 in: Wrong date format after importing tasks from Outlook
Score: 0
Before trying PeterW's suggestion, I've persevered with manually removing the apostrophe in the date cells in the spreadsheet and then I've converted those dates into US date format. I've now reached the stage where I want to import the spraedsheet data into Toodledo.
On the 'Tools & Services' Page on the Toodledo website there are four ways to Import Data. These are CSV, XML, Text & Palm PDA. Which of these works for an Excel Spreadsheet? In order to complete the Toodledo Administrators's instructions of 2 days ago, I how need to import the Data from the spreadsheet into Toodledo, but how? |
|
Swannej |
Posted Nov 10, 2010 in: Wrong date format after importing tasks from Outlook
Score: 0
Hi PeterW
Good idea - I'll try that. Thanks. |
|
Swannej |
Posted Nov 08, 2010 in: Wrong date format after importing tasks from Outlook
Score: 0
Thanks for your advice.
I've exported some of my Outlook Tasks to an Excel file. I've converted a few of the dates into US date format within the Excel file, but I had to manually remove the leading apostrophe in each date cell before the re-formating would work. It seems that during the exporting, each date cell has had an apostrophe inserted at the start of the date. To change the date format of all the cells in the Start Date and Due Date columns, I will have to delete each individual apostrophe first. This will be a lengthy and repetative exercise. Do you know of a way to get around this 'apostrophe' problem? Thanks. Swannej |
|
Swannej |
Posted Nov 07, 2010 in: Wrong date format after importing tasks from Outlook
Score: 0
Thanks, I'll open a support ticket as you recommend.
Kind regards, Swannej |
|
Swannej |
Posted Nov 07, 2010 in: Wrong date format after importing tasks from Outlook
Score: 0
Thanks for your suggestion PeterW.
I went to the link you gave me and I found the format set there was already 'D/M/Y', so it must have been set like that when I imported my tasks from Outlook. So my tasks have the wrong dates despite the Toodledo Regional Settings apparently being set correctly. Any further ideas? Thanks again. Swannej, |
|
Swannej |
Posted Nov 06, 2010 in: Wrong date format after importing tasks from Outlook
Score: 0
I use the standard 'UK date format' of DD-MM-YYYY. I've imported my existing tasks from Outlook via the CSV file format. The dates of all my tasks when they've arrived in Toodledo is wrong.
Two examples:- A task I created in Outlook is dated 05-06-2010 (05 June 2010) but it's become 06-05-2010 (06 May 2010) in Toodledo. Another task in Outlook is dated 15-06-2010 (15 June 2010) but it's become 'undated' in Toodledo because it translates to the 6th Day of the 15th Month of 2010, which isn't a valid date, hence it ends up with no date. Can someone tell me please, is there a setting somewhere that I need to re-set so my tasks import into Toodledo correctly or do I have to go through each of my tasks in Toodledo individually after they've been imported and manually correct the dates? Hope someone can help me. Thanks. Swannej. |