Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
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.
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.
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.
Could you post template file ?
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
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.
Ok.
Thx.