View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Import not loading CSV data - ProjeQtOr

Prochaines Sessions

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

Import not loading CSV data

More
30 Juil 2018 12:53 #1 by CarlC
Having some problems while loading a CSV file containing our project tasks - all of the column names exist but the error suggests they don't or are empty.

An example of the CSV file is:
Item ID,Name,Task Type,Project,External reference,Created Date,last update,Description,Parent task,Status,Closed date,planned start date,real start date,Requested Start Date,planned end date,real end date,Progress,Planning Mode
116,Change Management,Cutover,TestProject,,11/07/2018,11/07/2018 17:23,,GO Live - Support,Logged (No Activity),,01/01/2018,,,22/03/2018,,0,as soon as possible

And the Import result says:

Invalid controls.
the field 'Name' is mandatory
the field 'Task Type' is mandatory
the field 'Project' is mandatory
the field 'Status' is mandatory
the field 'Planning Mode' is mandatory

Please Connexion or Create an account to join the conversation.

More
30 Juil 2018 13:36 #2 by babynus
Replied by babynus on topic Import not loading CSV data
The case of your column names is wrong.
You must use either the displayed name of the field on the sceen either the field name in the object class.
Try an export to get the correct format.
Remind that case is important.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
30 Juil 2018 13:41 #3 by CarlC
Replied by CarlC on topic Import not loading CSV data
I've tried and unfortunately it didn't work.

First i tried the example spreadsheet from the Downloads page of this website - it failed
Exported some sample data from our system, changed the values in row 2 and tried to import (this was the CSV data from my previous post) - it also failed.
From the Import page i clicked the ? to show the actual column names, tried those in my CSV file and these also failed.

Please Connexion or Create an account to join the conversation.

More
30 Juil 2018 14:14 #4 by babynus
Replied by babynus on topic Import not loading CSV data
First i tried the example spreadsheet from the Downloads page of this website - it failed
It is quite old, bot surprised it's not working anymore.

Exported some sample data from our system, changed the values in row 2 and tried to import (this was the CSV data from my previous post) - it also failed.

IT should have worked. Please post example.

From the Import page i clicked the ? to show the actual column names, tried those in my CSV file and these also failed.

This should also work.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
30 Juil 2018 15:36 #5 by CarlC
Replied by CarlC on topic Import not loading CSV data
Tried again and this time used a tiny CSV barebones file containing the DB names and the displayed names (i've made a few changes in the lang.js file, would this cause a problem with the import?)

Some examples of the data i've tried loading are:

Name,TaskType,Project,Status,Planning Mode
Change Management,1,3,1,1

name,idActivityType,idProject,idStatus,idActivityPlanningMode
Change Management,1,3,1,1

These didn't work either - screenshots attached.
Attachments:

Please Connexion or Create an account to join the conversation.

More
30 Juil 2018 15:58 #6 by babynus
Replied by babynus on topic Import not loading CSV data
Hi,

The delimiter is not the expected one.
You use "," buty ";" is expected.
Try and change this on global parameters

Babynus
Administrator of ProjeQtOr web site
Attachments:

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.066 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.