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

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

2 décembre 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

10 et 11 décembre 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

16 et 17 décembre 2025 (9h-12h30)

 

 

 

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

More
13 Juil 2017 08:59 - 13 Juil 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 Juil 2017 09:04 by NarayanAras.

Please Connexion or Create an account to join the conversation.

More
14 Juil 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 Connexion or Create an account to join the conversation.

More
15 Juil 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 Connexion or Create an account to join the conversation.

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

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.034 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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