problem with product export

hello,

I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated

Tanya

ok thanks for getting back to me - i've tried that but it still won't work. i've attached a pic of what the text import wizard looks like on my end. I've also tried it on my home computer (newer version of excel on it) but it still mixes up the data.

hi,

yes i can give you the csv - just warning you though that its very large so you can't just click on it to open it. i had to import it manually using the data import options in excel (fits over more than one worksheet). its still set at semi colon for the separator.

Tanya

hi,

yes i can give you the csv - just warning you though that its very large so you can't just click on it to open it. i had to import it manually using the data import options in excel (fits over more than one worksheet). its still set at semi colon for the separator.

Tanya

sorry i can't get it to attach - maybe its too large...the page just keeps loading and as you can see it didn't attach to the message. can i send it to you in an email?

ok I'll try that, if that doesn't work I'll try using the open office calc (I have that on my computer too).
thanks,
Tanya

I am also having problems with the export function.
I am using semicolon as the CSV separator but can see on a single product export test that the field order in the file is disturbed when I read it back into Excel.

The problem appears to be connected to the product description field, where I think that a character or string in the product description is causing a a new line to be started.

In the attached file, if I do the following:
1. Import the csv file into Excel
2. Take all the data on the line after the field "xxTest_Product_Top" (which is the text product code)
3. Move that data so that it starts in the correct field (product_code)

then the remaining data items will then be placed in the correct fields.
I have attached the data file so that you can see the problem.

My original objective was simply to check product names, codes, prices, tax status etc. I do not need the product description in order to do this. Is there any way to select which data items I want to appear in the exported CSV file (without using a SQL query?) so that I do not export the product description?

Regards
PhilP

Ok Nicolas - thanks. I'll try that.

PhilP