Perhaps using the data tab in Excel to import your exported data could be a part of your solution.
After exporting your MLO data open a new Excel file workbook, click on the "data" tab and choose to get external data from "other sources". Choose XML format and select your XML file. (I just hit "ok" in the next two dialogues) Then your data should appear in the sheet as expected. You could build your dashboard, graphs etc. on a new sheet in this workbook (not directly in the exported file!). Whenever you replace the previous XML export file contents by overwriting the old file with a new export (keep the location and filename exactly the same), you just need to click the "refresh" button in the data tab to refresh the data in your workbook. This semi-automatically replaces the data in the data sheet,but does not modify your other sheets. Unfortunately I did not see a kind of unique task ID in the export, that could be very useful for further database operations. The "task name" column could contain unique identifiers, but in my case I modify the task names rather often. -- You received this message because you are subscribed to the Google Groups "MyLifeOrganized" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/mylifeorganized. To view this discussion on the web visit https://groups.google.com/d/msgid/mylifeorganized/5448599e-f865-44c0-a4d3-ecfab5646942%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
