When I try to import a csv and change delimiter on the fly (i.e. at last minute when choose a file to upload) it doesn't work.

I'm trying to update thousands of nodes with a newly added field values, as I didn't prepare the csv compatible with the old one (used a different delimiter) I've tried to change delimiter on page. Feeds created exact number of new and empty nodes instead of updating the old ones as it couldn't parse...

As there were no error reporting and instead it created nodes and finished the task as if everything normal I was surprised.

Minutes later I've reformatted the csv and there were no problems... I'm familiar with wrong delimiter problems with my previous actions but I was sure that it wasn't the issue as I've chosen the correct delimiter on page...

So either it should be fixed or documentation should be better I guess... (maybe not using a dropdown menu in the import page at all? Just showing which delimiter is chosen?)

Comments

MegaChriz’s picture

MegaChriz CreditAttribution: MegaChriz as a volunteer commented
Status: Active » Closed (cannot reproduce)

I cannot reproduce the issue.

I tried to reproduce it in the following way on the latest dev of Feeds:

  1. On the importer settings, parser settings, set delimiter to ",". On the node processor settings, set to update existing nodes.
  2. On the import page, imported a file with a CSV using "," as separator. Items were imported successfully.
  3. On the same import page, changed the delimiter to "+". In the file to upload replaced "," to "+" and changed titles of items. Imported this file. Items were updated successfully.
  4. Repeated step 3, but instead of "+" I now used "|". Items were updated successfully.