I'm exporting an excel spreadsheet as CSV and when I go through the steps, the sample data just shows all my data in one long line. The field mapping seems to work fine and I can go through all the steps, but at the end I just get 0 rows imported, 0 row errors.

Any help would be greatly appreciated as this is a fairly basic import only using CCK fields (only one node reference).

Thanks a lot.

CommentFileSizeAuthor
#2 Partner_Search_Networks_10.csv_.zip4.44 KBadshill
debug.txt112.59 KBadshill

Comments

Robrecht Jacques’s picture

Robrecht Jacques commented

Can you attach the CSV file (first 5 rows or so)?

adshill’s picture

adshill commented
StatusFileSize
new Partner_Search_Networks_10.csv_.zip4.44 KB
caver456’s picture

caver456 commented

Great module. I'm getting this too. If you insert the ctrl-v-ctrl-m with vi (text editor) or such, then it breaks rows correctly. Dos vs unix I think. On a linux box that has it, I think the unix2dos program might do all the conversion for you.
Thanks

adshill’s picture

adshill commented
Priority: Critical » Normal
Status: Active » Fixed

Thanks caver456,

It appears this was the problem. I opened my csv file in my text editor (skEdit) and re-saved and I then got it to work... I guess Microsoft CSV is not possible. And I agree - a great module :)

Thanks Robrecht for your help!

Adam

caver456’s picture

caver456 commented

Hi - noticed the status for this has been changed to 'fixed', but, I think all we really found was a valid work-around - are there plans to actually incorporate this as a fix into the module, so that ctrl-v ctrl-m is not necessary in the csv? I know openoffice on linux saves without ctrl-v-ctrl-m and apparently the other user had the same problem from some microsoft app.
Thanks

adshill’s picture

adshill commented
Title: Not recognising Newline for new rows » Compatibility with Open Office and Excel CSV files (recognising newlines)
Category: support » feature
Status: Fixed » Active

Actually you probably have a point... I changed the priority from critical to normal and at the same time considered it "fixed" in the theory that it was originally a support request and on that level my support was granted :)

I've changed status and title to reflect more what we are asking as I think you're valid in your request! Feel free to change it if you think I'm mis-representing!

frank ralf’s picture

frank ralf commented

Just for the record some theoretical background: http://en.wikipedia.org/wiki/Newline#Common_problems

For us Windows users Notepad++ (http://notepad-plus.sourceforge.net) is a great text editor which can convert to and from Windows, Unix, and Mac formats (among many other things).

wilgrace’s picture

wilgrace commented

I'm aiming to have my client (on a Mac) use Excel to bulk import products in a csv file, and am having the same problem. Is there nothing within the Excel settings that can be done to allow the export/import of csv files through Excel?

wilgrace’s picture

wilgrace commented

Ah just found it, there's an option to save out the format as Windows Comma Seperated (csv). Works fine now

frank ralf’s picture

frank ralf commented

Only another workaround but one that I found working in most similar situations:

Open your Excel table, mark everything you want to save, and then use copy & paste to paste the content in a text editor of your choice. That way you get rid of all the strange extra characters some spreadsheet programs insert to mark content as text.

hth
Frank

Robrecht Jacques’s picture

Robrecht Jacques commented
Status: Active » Closed (duplicate)

Duplicate of http://drupal.org/node/493980 which is fixed in the -dev version and will be included in -rc5.