[SOLVED] Import from MS-Project to ProjeQtOr XLSM - error

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: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

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.

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:

1. In Project make sure you delete an blank lines before importing and insert the % Column prior to the Task Name column
2. 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.