karlfk Posted September 14, 2011 Posted September 14, 2011 Hi all Any one worked with MyMob in exporting cvs, when we export and import into osCommerce we get dollars signs ? Anyone know of a easier way, we are working on the import and export into osCommerce now karl
MrPhil Posted September 18, 2011 Posted September 18, 2011 By "CVS", do you mean "Comma Separated Values" (CSV) format? Assuming you do... while I'm not familiar with MyMob, I would guess that it's exporting a price or value as "$nnn.nn" string, and when osC tries to import this string data, it's not happy with the "$" sign (it wants "nnn.nn"). Look at the CSV file and see if that's the case. If you can't get MyMob to stop using "$" in such values, you might have to preprocess the CSV file to strip out the $ signs. There are scripts and utilities available for all platforms, such as "sed", which can easily convert all "$ into ". That might do the job for you.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.