View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Import customer - ProjeQtOr
 

[SOLVED] Import customer

More
18 Aug 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 Log in or Create an account to join the conversation.

More
18 Aug 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 Log in or Create an account to join the conversation.

More
18 Aug 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 Log in or Create an account to join the conversation.

More
18 Aug 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 Log in or Create an account to join the conversation.

More
18 Aug 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 Log in or Create an account to join the conversation.

More
18 Aug 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 Log in or Create an account to join the conversation.

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