Hello,
I am using the Import from MS-Project to ProjeQtOr XLSM file that was contributed for importing activities from Project to ProjeQtOr. Durring import of the activities I am receiving an error. The log shows the error is due to:
cause = date() expects parameter 2 to be long, string given
I tried changing the format of the column for the dates but that did not have any impact. Any other suggestions on how to correct this?
Best Regards,
Ron
Could you poste the complete error log.
I am attaching the log. As you will see in the log this is a fresh install.
I am also attaching a sample import that causes the error.
Hi,
It is becaus "Mon 6/15/15" is stored as a string, not as a date.
Change values so that excel stored them as real dates.
NB : a fix will be included in V5.2.3 to avoid the error, just let a non valid date.
Thank you babynus, that solved my initial problem.
I ran into a few other import problems and thought I would share in case it helps others.
When using the Project Import template that is available in the download section there are a couple of steps that need to be done:
- In Project make sure you delete an blank lines before importing and insert the % Column prior to the Task Name column
- Once you copy the tasks into the Import template, you will need to do the following:
- First remove the day of the week ("Mon", "Tue", etc.) from the dates
- Second remove the text in the duration columns, thus must only be a number
Once you generate the import file there is one final step before importing it. Open the file and if row 2 contains headings from MS Project you will need to delete that row. Do not delete the first row that contains the column headings for ProjeQt)r.
Hope this helps others.