View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - ProjeQtor fails to import Activity data (as Excel or as CSV) - ProjeQtOr
 

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

More
13 Jul 2017 08:59 - 13 Jul 2017 09:04 #1 by NarayanAras
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:\Users\njaras\Documents folder.
Attachments:
Last edit: 13 Jul 2017 09:04 by NarayanAras.

Please Log in or Create an account to join the conversation.

More
14 Jul 2017 09:59 #2 by NarayanAras
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.)
Attachments:
The following user(s) said Thank You: babynus

Please Log in or Create an account to join the conversation.

More
15 Jul 2017 10:13 #3 by babynus

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 ","

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
15 Jul 2017 10:14 #4 by babynus
Thanks for sharing your help file.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.036 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.