dolibarr-user
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Dolibarr-user] csv of ledget


From: MENGUAL Jean-Philippe
Subject: Re: [Dolibarr-user] csv of ledget
Date: Fri, 17 Jan 2020 13:31:10 +0100
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:74.0) Gecko/20100101 Thunderbird/74.0a1

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 <address@hidden <mailto:address@hidden>> 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>
    address@hidden <mailto:address@hidden>
    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
    address@hidden <mailto:address@hidden>
    https://lists.nongnu.org/mailman/listinfo/dolibarr-user
    <https://lists.nongnu.org/mailman/listinfo/dolibarr-user>



--
EMail: address@hidden <mailto:address@hidden>
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: address@hidden <mailto:address@hidden>) * AWStats (Author) : http://awstats.sourceforge.net <http://awstats.sourceforge.net> (make a donation for AWStats project via Paypal: address@hidden <mailto:address@hidden>) * AWBot (Author) : http://awbot.sourceforge.net <http://awbot.sourceforge.net> * CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net <http://cvschangelogb.sourceforge.net>


_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user




reply via email to

[Prev in Thread] Current Thread [Next in Thread]