r2d2r01
-
Posts
9 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by r2d2r01
-
-
Hi when i try to import file from csv (comma separator) I have a pb with number which has format 707,70€which is parsed as 70770,00€ (oups).
If i try to change in settings decimal character from ',' by '.' this one impact only view and not value imported.
How I can ask to parser to make difference from "field1, field2, field3, number,dec, field4, etc..." where "number,dec" is ONE value 707,11€ and NOT 2 VALUES
Thanks for helping
Frederic
-
Very bad simple expression parser.
It appears you can set a constant value but cannot use or do reference to it in other expression simple, only a function (roundup, ..)
Typically:
A -> expr simple -> 1000 => OK
B -> expr simple -> 500 => OK
C -> expr simple -> A-B => KO -> unrecognized field ERROR
C -> expr simple -> A-1 => KO -> unrecognized field ERROR
C -> expr simple -> Field5-1 => OK due to type of field5
Oups -
Through EA ?
-
Right, I agree & think i am learning how EA works. The starts of new adventure ....
-
Thank's, i skip all taxes values. I have tried all these values (10, 10% tva(10) tva(10%), etc ..) and have not all time to test all others. It(s the responsability of developpers to set right doc and samples for end user, if values provided don't match, bye bye columns import. For date I set basically DD/MM/YYYY and it imports fine.
-
Hi , thank's for answer I know where is the option and i use it and precise my request.
In the import csv file for "devis" in french or "quote" there 2 columns named "Taux de taxe" and "Taux de taxe de l'article" .
For each column (article, description, ..) i set a value exported from excel, but what value set in file for taxe ?
Regards
Frederic
-
Hi, in import csv file, what value to insert for "valeur/défaut" and TVA(20%) ?
Thank's
Regards
Frederic
csv quote import number decimal separator ambiguity with field separator
in Express Accounts
Posted
Pb resolved by changing decimal separator comma (',') by dot ('.')