View Full Version : Paying Affiliates with PayPal - Exporting CSV Error
Gugel
2nd March 2008, 03:29 AM
I am trying to generate a .csv file to pay affiliates in PayPal.
I export a .csv file and it ends up looking something like this:
test@test.com (tab) 1,00 (tab) USD
Everything is great EXCEPT in the Affiliate_amount, it has a comma instead of a period. Basically, it looks like 1,00 instead of 1.00. I need to make it look like 1.00! How can I do this?
Thanks!
drakeman
4th March 2008, 09:50 PM
Export format can not be changed. If you want to replace , with . you can open your exported file in any editor and replace , with .
There is no way how to do it.
We can add this option to the future versions.
tomfra
1st August 2008, 12:58 AM
What source file controls this? I am having the very same problem and would like to change it in the source file if there is no other way. Moneybookers needs dots instead of commas too.
Tomas
drakeman
17th August 2008, 11:52 PM
This function is contained in the some files and therefore manual find and replace is better, faster and easier way.
We will try to add a switch ability to the future versions
tomfra
18th August 2008, 07:48 PM
Drakeman: zkusim to najit. Duvod proc chci tu carku zmenit na tecku primo ve zdrojaku je ten, ze jestli jednou omylem zapomenu nahradit carku teckou v tom .csv souboru a pouziju ho tak jak je, muzu omylem misto 1 USD/EUR poslat 100 USD/EUR.
Podle standardniho zapadniho formatovani (coz pouziva napr. Moneybookers, asi i PayPal) je "1.00" jedna a "1,00" je jedno sto.
Je to sice malickost, ale nasledky mohou by znacne...
Tomas
Oprava: myslim ze s tou jednickou to neni tak docela pravda, dost mozna je ten problem az od cisla 100 - "100,00" je hadam deset tisic ale ted uz sam nevim ;)
drakeman
19th August 2008, 10:10 PM
Drakeman: zkusim to najit. Duvod proc chci tu carku zmenit na tecku primo ve zdrojaku je ten, ze jestli jednou omylem zapomenu nahradit carku teckou v tom .csv souboru a pouziju ho tak jak je, muzu omylem misto 1 USD/EUR poslat 100 USD/EUR.
Podle standardniho zapadniho formatovani (coz pouziva napr. Moneybookers, asi i PayPal) je "1.00" jedna a "1,00" je jedno sto.
Je to sice malickost, ale nasledky mohou by znacne...
Tomas
Oprava: myslim ze s tou jednickou to neni tak docela pravda, dost mozna je ten problem az od cisla 100 - "100,00" je hadam deset tisic ale ted uz sam nevim ;)
Problem to moze byt, ale treba si davat pozor a bude to dobre ;) Tak ci tak posuniem funkciu oddelovania cisel programatorom a uvidime, co s tym spravia. Snad budu schopni vyhoviet vam
scanreg
4th December 2008, 02:27 PM
Which file should the fix be applied to?
Thanks
vBulletin® v3.7.2, Copyright ©2000-2009, Jelsoft Enterprises Ltd.