Import time records from .71-TT?
Page: 1
Recent posts in this topic
Pro
michelangelo
on Nov 6. 2007. 5:00 pm
hello all, before i start rolling my own solution, has anyone written anything to import time records from the version of .71 that had the time tab?
Pro
michelangelo
on Nov 8. 2007. 2:44 pm
hey there again, ok, spent a few hours on this and have a very rudimentary time record importer if you used the EXP TT .71 version of activeCollab.
this replaces the application.zip of the importer, so unzip it and replace 'activecollab_importer' activecollab/application/modules/ folder after you have installed the importer located here: http://www.activecollab.com/support/index.php?pg=kb.page&id=21
there were some things i thought were missing from the original importer, like users getting imported as email addresses (no first and last names) and their contact information other than email not getting imported, so i added that.
there are a lot of places where i have tweaked some things, mainly printing record IDs out, because i was getting import errors and wasnt sure why. in general, the importer could be more helpful in telling us why certain things didnt import, but it never does so i had a DB filled a some of a project that was imported, then it would cut out and not import after a certain point and never offer feedback as to which record or why but in other cases i would get a message title. also, there should really be no reason why i had to delete several records to get the projects to import and the project_object class could return more helpful information as to why a save() didnt work, other than just a false. in many cases a single null value in the wrong place would still validate() but would error out on the SQL insert.
in any case, here is a modified version that adds time tracking as an option after you import a project. its super rough and uses the project name to find the correct project to attach the time record to, so do this right after importing your users and projects so names haven't changed. also, since the new timerecord doesnt have all the fields we did before, i had to come up with a way to organize the records so i put the task list name in the body if it exists. so if "Concept Development" was a task list you assigned a time record to in .71, and the description field was "Worked on Comps", then the body of the new time record will be "Concept Development: Worked on Comps". Hope that makes sense. I had to ditch the Milestone name unfortunately.
BE AWARE: this worked for my setup but may not work for others so if anything goes wrong, i cant really help you so USE AT YOUR OWN RISK.
http://tinlion.com/downloads/application_with_time_tracking.zip
this replaces the application.zip of the importer, so unzip it and replace 'activecollab_importer' activecollab/application/modules/ folder after you have installed the importer located here: http://www.activecollab.com/support/index.php?pg=kb.page&id=21
there were some things i thought were missing from the original importer, like users getting imported as email addresses (no first and last names) and their contact information other than email not getting imported, so i added that.
there are a lot of places where i have tweaked some things, mainly printing record IDs out, because i was getting import errors and wasnt sure why. in general, the importer could be more helpful in telling us why certain things didnt import, but it never does so i had a DB filled a some of a project that was imported, then it would cut out and not import after a certain point and never offer feedback as to which record or why but in other cases i would get a message title. also, there should really be no reason why i had to delete several records to get the projects to import and the project_object class could return more helpful information as to why a save() didnt work, other than just a false. in many cases a single null value in the wrong place would still validate() but would error out on the SQL insert.
in any case, here is a modified version that adds time tracking as an option after you import a project. its super rough and uses the project name to find the correct project to attach the time record to, so do this right after importing your users and projects so names haven't changed. also, since the new timerecord doesnt have all the fields we did before, i had to come up with a way to organize the records so i put the task list name in the body if it exists. so if "Concept Development" was a task list you assigned a time record to in .71, and the description field was "Worked on Comps", then the body of the new time record will be "Concept Development: Worked on Comps". Hope that makes sense. I had to ditch the Milestone name unfortunately.
BE AWARE: this worked for my setup but may not work for others so if anything goes wrong, i cant really help you so USE AT YOUR OWN RISK.
http://tinlion.com/downloads/application_with_time_tracking.zip
