Hi,
Le 17/01/2020 à 13:24, Laurent Destailleur (aka Eldy) a écrit :
If you set a comma, a price should be "89,40" (with the double quote)
in the text file. So when opening the file, there is no confusion
between the comma as field separator and comma as price separator.
Take a look into file with a text reader. If you don't have the ", it is
a bug in export.
ah. I dont have it, indeed. Here is an example line:
963,01092019,FA1909-0397,UI... - FA1909-0397 - Compte
auxiliaire,411000,4110971,89,40,0,00,89,40,VT
963,01092019,FA1909-0397,UI... - FA1909-0397 - Prestations de
services,706000,,0,00,74,50,74,50,VT
963,01092019,FA1909-0397,UI... - FA1909-0397 - TVA 20
%,445000,,0,00,14,90,14,90,VT
I am with 9.0.4
Regards
Le ven. 17 janv. 2020 à 12:17, MENGUAL Jean-Philippe
<[email protected] <mailto:[email protected]>> a écrit :
HI,
How can I set the csv to separathe the columns with another thing
than a comma? If I set a comma, the result is that 89,40 is
considered as two columns intead of a decimal one. Or should I
change the decimal mark of prices? How?
Thanks
Regards
--
Logo Hypra JEAN-PHILIPPE MENGUAL
DIRECTEUR TECHNIQUE ET QUALITÉ
102, rue des poissonniers, 75018, Paris
Tel : +331 84 73 06 61 <tel:+33184730661> Mob : +336 76 34 93 37
<tel:+33676349337>
[email protected] <mailto:[email protected]>
www.hypra.fr <http://www.hypra.fr/>
Facebook Hypra <https://www.facebook.com/hyprasoftware/> Twitter
Hypra <https://twitter.com/Hypra_> Linkedin Jean-Philippe
<https://fr.linkedin.com/in/jean-philippe-mengual-800133135>
_______________________________________________
Dolibarr-user mailing list
[email protected] <mailto:[email protected]>
https://lists.nongnu.org/mailman/listinfo/dolibarr-user
<https://lists.nongnu.org/mailman/listinfo/dolibarr-user>
--
EMail: [email protected] <mailto:[email protected]>
Web: https://www.destailleur.fr <https://www.destailleur.fr>
Twitter: http://www.twitter.com/eldy10 <http://www.twitter.com/eldy10>
------------------------------------------------------------------------------------
* Dolibarr (Project leader): https://www.dolibarr.org
<https://www.dolibarr.org> (make a donation for Dolibarr project via
Paypal: [email protected] <mailto:[email protected]>)
* AWStats (Author) : http://awstats.sourceforge.net
<http://awstats.sourceforge.net> (make a donation for AWStats project
via Paypal: [email protected] <mailto:[email protected]>)
* AWBot (Author) : http://awbot.sourceforge.net
<http://awbot.sourceforge.net>
* CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net
<http://cvschangelogb.sourceforge.net>
_______________________________________________
Dolibarr-user mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/dolibarr-user
_______________________________________________
Dolibarr-user mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/dolibarr-user
