Last updated January 25, 2009. Created by marcus7777 on November 7, 2008.
Edited by LeeHunter. Log in to edit this page.
When I imported 3000 or so nodes from my ACT! database into a local Drupal site it all worked well but because all the dates were in dd/mm/yy format they would not import using Node import .
I opened the .csv file in Excel and added two columns:
'(unix) Create Date' for Create Date
and
'(unix) Edit Date' for Edit Date
I then used this formula to make the Unix timestamp
=IF(A1, (A1-25569-(-5/24))*86400,"")
Note:
A1 is the cell that contains the dd/mm/yy or mm/dd/yy (your computer knows about the way you format dates in your country) and the 5 is to set the time to 5am.
Comments
Act migration notes
From the way you described the data, it sounds like you imported ACT! ver6 or earlier. As I recall the date formate it was YYYYMMDD:HH:MM:SS. So its actually easier to parse the date in your spreadsheet using "text to columns" and then save it as a text file.
ACT 7 or greater its better to use the contact list and the "export to excel" tool.