Export to CSV

[grubin]

i'd like to be able to export batch files to a CSV format rather than the default .dat file


our fulfillment house requires comma-delimited CSV files. up until now, i've been renaming the text file orders.csv, however with a recent order we encountered a problem.


because the required CSV file is comma-delimited, and because MIVA does not export a true CSV file, if someone uses a comma in their company name, i.e.


Company name: Pet Smart, Inc.


the comma in the company name is not escaped properly, and when orders.csv gets imported into the fulfillment house's database, it sees this comma and thinks it is starting a new category.


my question is: how can i export a batch of orders to a true CSV file format?

thanks very much for your help! :)

[grubin]

anyone have any ideas or suggestions? the client is kind of freaking out over here on us :(

[erichar11]

I would recommend stoneedge order manager or maybe one of the other third party fullfilment tools. Stoneedge may be a little overkill and pricy if this is the only issue you have. But with order manager you can export the data out in any format you want.

Another thought would be to use a different delimineter. The comma deliminator just causes to many problems because of the exact issue you stated above. Use a pipe symbol instead, I think miva can do this, but it would require your fullfilment center to recognize it.

Just thinking outloud.

[Gazungle]

A bunch of our clients use Shipworks as a 3rd party order manager .. and they all have only great things to say about it.

[JSebastian]

Shipworks is decent, but it wont solve the problem if you're using a fulfillment center.

Changing the delimiter to a pipe (|) or similar may work if the fulfillment center can recognize the format. The other choice would be for you to do an export then a "find-and-replace" in notepad or similar and change all of the "|" symbols to "," but it may still glitch out and would be a serious pain if you have to do it every time you process...

[lbdesign]

Export the DAT file using tabs for delimiters. In Excel, search and replace all commas to periods. Then export with comma delimiters. Now the only commas will be the delimiters you added.

[cdelarte]

Is it possible to create an orders file which ONLY contains processed orders so that the fulfillment company doesnt ship goods whihc havent been paid for?

[Bruce - PhosphorMedia]

i'd like to be able to export batch files to a CSV format rather than the default .dat file


our fulfillment house requires comma-delimited CSV files. up until now, i've been renaming the text file orders.csv, however with a recent order we encountered a problem.


because the required CSV file is comma-delimited, and because MIVA does not export a true CSV file, if someone uses a comma in their company name, i.e.


Company name: Pet Smart, Inc.


the comma in the company name is not escaped properly, and when orders.csv gets imported into the fulfillment house's database, it sees this comma and thinks it is starting a new category.


my question is: how can i export a batch of orders to a true CSV file format?

thanks very much for your help! :)

You could have a custom export module created that escape the commas in the Merchant data fields...but I'd wonder about a fulfillment house that uses such an old style of file import.