Weird thing happening with dataflow export

[deadgoodundies]

For the first time i've been having a play around with product export and import to make it easier for me to update details in bulk (for example price changes, moving categories etc.) and i've got a couple of problems which I don't quite understand so hopefully someone else can enlighten me.

I'm using open office calc for editing the csv files as excel seems to have some problem with some of the html in a attribute.

If I export via dataflow it's adding on extra 00 to the prices for example 10.00 becomes 10.0000

Also (and this isn't a problem with the export directly) but when I open the csv in open office some of the category id's are coming in fine for example

30,39,12,14

but on other it's missing the commas so looks like 30391214

If I select the option of Quoted fields as text when opening the csv it does then break it up like 30,39,12,14 BUT it also puts a ' before it so it becomes '30,39,12,14
I've opened the csv in a text editor and it's in the csv file correctly so it looks like some sort of opening issue in open office

Anyone got any clues?

 

[JamesSco]

I would say the issue is with open office and not Magento its self. I have certainly experienced issued such as the ones you mention when using open office.

Best bet it to see if you can get access to a computer with office on it to see if it solves the problem. I suspect it will be an issue with Open Office reading the files incorrectly and there is not much that can be done about it.

With the prices being to 4 digits, its actually reading this correctly. If you look at the Magento backend database, all prices are set to 4 decimal places. However, excel will automatically remove them to 2 decimal places if they are not being removed.

 

[deadgoodundies]

Yeah i've got office as well and excel imports then in the cells as 30,39,12,14 but if you click in the cell on the input bar (not sure what you call it) it's listed as 30391214 , also excel doesn't like the html in one of our attributes so where we have bullet points its only showing the <ul> part of the html.

Strange about the actual export of the prices though as 10.0000 instead of 10.00

 

[deadgoodundies]

Ok just tried it in google sheets as well and the prices come up as for example instead of 36.8000 as it would in open office it comes up as 36.8 BUT still the same issue with the category id's