View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Import customer - 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)

 

 

 

[SOLVED] Import customer

More
18 Aoû 2015 15:18 #1 by Lee
Import customer was created by Lee
Hi,
When I want to import to update clientcode with a 0 at the left, update is not dectted.
example :
old code 4
new code 04
I change manually, so not important for me.

Please Connexion or Create an account to join the conversation.

More
18 Aoû 2015 17:41 #2 by babynus
Replied by babynus on topic Import customer
Could not reproduce.
Did you import from csv or xlsx ?
Maybe, when editing the file (for instance with Excel) the leading zeros were removed.
On Excel, you must preceed your numéric values with a quote ' to keep leading zeros.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
18 Aoû 2015 17:54 #3 by Lee
Replied by Lee on topic Import customer
CSV File.
When I import, Column "Code client" contains 0, but in the column "Result", it appears "Aucune modification à sauver pour l'élément ...".
This time, there is only the code update.

Please Connexion or Create an account to join the conversation.

More
18 Aoû 2015 18:13 #4 by babynus
Replied by babynus on topic Import customer
Could you post template file ?

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
18 Aoû 2015 18:19 #5 by Lee
Replied by Lee on topic Import customer
Here the first line.

id;name;idClientType;clientCode;paymentDelay;tax;idle;description;designation;street;complement;zip;city;state;country
1;S.D.I.S. de l'Ain;98;01;;;0;;;200 avenue du Capitaine Dhonne;BP 33;1001;BOURG-EN-BRESSE Cedex;;France

Please Connexion or Create an account to join the conversation.

More
18 Aoû 2015 18:33 #6 by babynus
Replied by babynus on topic Import customer
I found the reason : in PHP '01' equals '1'
(yes, even if field is a string, numeric values are compared)
So trying to update '1' to '01' gives no result.
You can try manually : it is not linked to the import function, nor to the field.
For instance create an item (any, customer, ticket project); with name = '1'.
Try and change name to '01' => no change :silly:
To have a change, you must change you must chamge name to '2' (or anything else different from 1) then to '01'.

It is strange nobody reported this issue before.
But

There is no quick fix for this.
Ticket #1788 recorded to think about a fix.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

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