• Resolved antonios31

    (@antonios31)


    Dear staff i’m exporting all the reviews (about 350 reviews) from my site to import them to a new site: the difference is only the id of products. So in the excel that i download i switch from the old id to the new id. But it gives to me error
    “Line 2 >> Error: incorrect file format. Only 1 column(s) found. Please open the input file in a text editor (e.g., in Notepad on Windows) and verify that columns are correctly separated by commas.”

    how to fix it? i repeat i substitute only the old id with the new one and save again the file in csv format.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Hi,

    Thank you for using CusRev.

    Can you please share the CSV file here? I will help you to check the issue.

    Thread Starter antonios31

    (@antonios31)

    hi, here the file https://easyupload.io/z4geol
    meanwhile i tell you that i create a new site so the id of products are changed (but i can change them on another time replacing in the csv).

    Thread Starter antonios31

    (@antonios31)

    however i’ve to say that i use also a plugin to create bundle so there are strange row maybe?!?

    Neo WhiteRabbit

    (@longnguyen89)

    Hi,

    Thanks for your additional information.

    You can open the CSV file with the Text editor on your computer and see the wrong double-quotes.
    Before: https://monosnap.com/file/uSqcQ7hXndVexbnSpiMPBU5V4zGxkv
    After: https://monosnap.com/file/8IZE2yjvSzhThFHrRREd8okXD1nKnh

    The correct content should be

    review_content,review_score,date,product_id,display_name,email,order_id
    "Ho 65 anni e ho provato migliaia di questi prodotti. Questo funziona davvero. Ci sono voluti 2 mesi di utilizzo, è vero non lo uso costantemente, ma ho notato un certo turgore a livello del collo. Consigliato e lo ricomprerò a breve! GRAZIE Armida",5,"2020-12-07 15:23:39",16902,Armida,[email protected],
    "L'ho comprato per mia figlia, ha subito un intervento e il collo tende a scendere. Da quando lo usa (3 mesi circa) si sente NUOVA, rimodellata.Ed è vero l'ho notato anche io e mio marito. Consigliato",5,"2020-12-07 15:24:26",16902,Giluia,[email protected],

    We haven’t heard from you for more than two weeks. For this reason, I’ll assume that either you are not interested in this question/problem anymore or it has been resolved. If you still require any help, please start a new forum topic.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Import error’ is closed to new replies.