Error importing contacts from csv file

  • Resolved ozonia

    (@ozonia)


    2 years ago

    When I try to import contacts to a previously created list and I do it by uploading the test CSV that the plugin itself offers as a demo, it does not allow the three data columns to be identified and therefore the import process is not completed. Even if I edit the CSV file and remove the “Name” and “Surname” columns leaving only the Email column, the import of the three demo CSV file records is not completed either. I will appreciate your help on this, since I need to import a list with 350 contacts and the process of entering records manually will be very tedious. Thank you

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor kishanranawat

    (@kishanranawat)

    Hello @ozonia ,

    If the CSV file has?First Name?and?Last Name?columns, then the plugin will automatically detect them. If the CSV file doesn’t have these two columns, then you might need manually map those columns. We have attached a screen recording here for a reference.

    For Email column to be detected correctly, the plugin needs a valid email address for the first subscriber(screenshot attached) otherwise the plugin won’t be able to detect the Email column and you might need to manually map the Email column as well.

    Can you let us know the error you are getting while importing subscribers? That will be helpful in understanding the issue further.

    Thank you.

    • This reply was modified 2 years ago by kishanranawat. Reason: changed subscriber to subscribers
    Thread Starter ozonia

    (@ozonia)

    Hi kishanranawat !

    Thank you for your attention and response.
    What you tell me was clear to me and this is how I try to carry out the import.
    I leave you a link to a video capture so you can see the bug that occurs.
    https://bit.ly/41LgtMw

    Thank you very much for your attention.

    Plugin Contributor kishanranawat

    (@kishanranawat)

    Hi @ozonia ,

    Thank you for giving us some more information related to the issue.

    Can you please also share the sample CSV file which you are using during the import? That would be helpful in debugging the issue further. You can upload the CSV file to Dropbox or Google drive and share the link with us.

    Thank you.

    Thread Starter ozonia

    (@ozonia)

    Thank you kishanranawat?

    I indicate you link with the CSV that I have tried.
    First of all I did download the sample (original) CSV and tried to import it getting the same error.
    After I downloaded the CSV file of the list that I created manually and deleting certain rows of the registry I tried to do the import again with error result. Then I changed the sample file again changing the name of the columns (fields) to Spanish as shown in the exported file that I obtained. It also gave an error. Lastly, based on how the CSV exported from the subscriber list is encoded, I saw that the record values ??are separated by double quotes, so I tried again with the demo CSV with the double quotes and I couldn’t get the import either.

    https://bit.ly/3muY3zm


    Thinking that it could be a conflict between plugins, I deactivated the rest of the plugins leaving only yours active and I couldn’t do the import either.
    The WP version I use is 5.6.1 and the installed plugin version is 5.5.13.
    I await your analysis of the situation.

    Plugin Contributor kishanranawat

    (@kishanranawat)

    Hi @ozonia,

    Thank you for providing the CSV files. We checked them at our end but couldn’t replicate the issue. We have attached a screen recording here for a reference.

    From above testing, it looks like there isn’t any issue CSV files. Therefore the issue might be with one or more database tables which are used during import.

    If you are familiar with database management tools like phpMyAdmin, can you please check if following tables are present in the site’s database?
    1. wp_ig_temp_import
    2. wp_ig_contacts
    3. wp_ig_lists_contacts

    Note: wp_ prefix in table name might be different on your site depending on the configuration.

    You can install plugin like phpMyAdmin which will allow you to check the tables directly from your WordPress dashboard.

    If you want us to look into the issue then you can contact us on our private support channel here mentioning this thread URL for a reference.

    Hope this helps you. Let us know what comes out in your testing or in you have any further queries.

    Thank you.

    Plugin Contributor Shubhanshu Kandani

    (@shubhanshukandani)

    Hello @ozonia,

    Hope you’re doing great.

    I wanted to check in with you regarding the inquiry you had the other day. Was it resolved? Do you need any additional help? I’d be happy to assist you in any case.

    Thank you!
    Have a great day ahead.

    Plugin Contributor Shubhanshu Kandani

    (@shubhanshukandani)

    Hello?@ozonia,

    We haven’t heard from you in a while. We hope our previous replies were helpful in resolving your issues.

    I am closing this thread for now. Feel free to reopen it in case if you are still having issues or inquiries related to the plugin.

    Also if you have any other queries, you can open a new thread from here. We will be happy to assist you further.

    Thank you.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Error importing contacts from csv file’ is closed to new replies.