• Hi,

    I’m trying to import a CSV with the data, but it fails. The error message is the following:

    “Incorrect column name found in CSV: composer___score_name,cover,list_of_contents

    Cannot import data. Make sure all field names are correct in the CSV header.”

    HOWEVER, I do it using exactly the previously downloaded blank CSV file with the “original” columns and names.

    Have an idea of what may be happening? Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author xnau webdesign

    (@xnau)

    The problem is exactly what the message says it is, you need to check the CSV to make sure it has all the field names in the headers correct. Use a plain text editor for this so you can see exactly what is there. Most likely the CSV file was unintentionally altered at some point in the process.

    Thread Starter jordiparera

    (@jordiparera)

    Thanks for your quick reply. I appreciate it. The problem, as I said, is that I used the downloaded file with the headers names with no change at all, just copy and pasting some contents below the headers. Is there a limit of the number of rows?

    Plugin Author xnau webdesign

    (@xnau)

    Well, something is wrong, so the way to figure it out is to eliminate the most likely issue…that the header of the CSV you’re trying to import is incorrect…to do that you have to actually verify that it is correct.

    The issue is not related to the number of rows, the error you’re seeing is very specific to help you find the problem.

    The number of rows is limited by your server configuration, the plugin does not impose a limit. If you’re importing in the background (the default) the only limit is the file size that php will allow you to upload. If you’re importing in the foreground, a large import could hit the php execution time limit.

    Thread Starter jordiparera

    (@jordiparera)

    Hi, it finally worked fine. Many thanks for your assistance. Just for your informaton, I marked the Enclosure character to ” and the Delimiter character to ,(coma) instead of leaving to Auto (default), and then it correctly imported the file.

    However, I think that the option of Duplicate Record Preference (updated in my case) does not work, and it just duplicates the double rows.

    Finally, I see that a field with Text Area form do not use the full width of its column when displayed in a list, but the text just occupies about 50% of the field. Is there a way to make it fulfil all the width of the field with the text (CSS?)?

    Thank you!

    Plugin Author xnau webdesign

    (@xnau)

    Glad you got it working, yes, the auto enclosure detect doesn’t work in all cases, the manual selections are there for such cases.

    To update duplicate records, it’s necessary to use a matching field that is unique to each record. If a record import comes in that matches mutiple records, it will import the record as a new record.

    Since it has already created duplicate records, you may need to search for those duplicates and clear them out before the feature will work properly.

    The formatting issue you’re seeing possibly can be fixed with CSS, but I can’t tell you how to do that, so much depends on the exact circumstances, and any other CSS that might be affecting the display.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Import CSV file not workng at all’ is closed to new replies.