Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

ProjeQtor fails to ...
 
Notifications
Clear all

ProjeQtor fails to import Activity data (as Excel or as CSV)

4 Posts
2 Users
0 Reactions
3,322 Views
(@narayanaras)
Posts: 150
Active Member
Topic starter
 
[#4505]

ProjeQtor does not allow us to open an mpp file. Neither does it allows us to import the basic WBS data.

So, as a workaround I created an xls (excel 97-2003) file that contains only two fields: Id number and task name.
The rest of the fields are left blank.
But the structure of the file meets the template structure (in fact, I copied the header line from the template).

But I am unable to import this data as "Activity":
1. If I try to import Excel, it reports "ERROR - Provided file type and selected file format do not match" and aborts the import.
2. If I try to import using CSV, it reports specific fields are mandatory.

I am enclosing all the files (Excel, CSV, error screenshots).
Please let me know what is wrong.

Note: I just noticed that the screenshot shows "fakepath" in the file path field.
This is because the xls and CSV files are in C:UsersnjarasDocuments folder.


 
Posted : 13 Jul 2017 10H59
(@narayanaras)
Posts: 150
Active Member
Topic starter
 

I resolved the issue through trial-and-error, and found that this process is complicated, but does not have adequate help text.

I have prepared a help file (attached). I hope that the other users will find it useful.
(Please feel free to copy this into the main help file.)


 
Posted : 14 Jul 2017 11H59
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

1. If I try to import Excel, it reports "ERROR - Provided file type and selected file format do not match" and aborts the import.

IF you want to import from Excel files, you must use XLSX format (not old XLS format)

2. If I try to import using CSV, it reports specific fields are mandatory.

Issue is due to separator : change parameter "separator for csv files" in global parameters to ","


 
Posted : 15 Jul 2017 12H13
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Thanks for sharing your help file.


 
Posted : 15 Jul 2017 12H14
Share:

Scroll to Top