CSV file import

[xbootnek]

I am unable to import my 2 row CSV file that I am testing using either Browser or WP import.

CSV import says the file is not a valid CSV file in red at the top of the screen and doesn’t show the column count.

Here’s my file:

member_id,user_name,first_name,last_name,password,member_since,membership_level,more_membership_levels,account_state,last_accessed,last_accessed_from_ip,email,phone,address_street,address_city,address_state,address_zipcode,home_page,country,gender,referrer,extra_info,reg_code,subscription_starts,initial_membership_level,txn_id,subscr_id,company_name,notes,flags,profile_image
462,462,John,Murphy,,1/1/2016,1,,Active,,,johnxmurphy@gmail.com,415-515-3022,”2130 Cactus Ct, #4, E5″,,,,,,P,483,1,,,,,,,,,
484,484,Nan,Warren,,1/1/2016,1,,Active,,,nanw90@gmail.com,415-601-8240,”2130 Cactus Ct, #4, E5″,,,,,,P,462,1,,,,,,,,,

Any suggestions?

[mbrsolution]

Hi, are you using the following documentation to import your files?

[xbootnek]

Yes and exactly.

I am using a ChromeBox and the CSV file is in my Download folder. Your dialog sees the file but cannot read it.

[mbrsolution]

Hi, what if you put your CSV file in your computer? Simply upload it from your computer? Let me know if that works.

[xbootnek]

I tried from a Win 10 machine. I get the same result. The file name is displayed but nothing is saved anywhere.

[mbrsolution]

Hi, do you get any error messages?

[xbootnek]

No errors except the big red warning at the screen top that says the csv file was not found.

[mbrsolution]

Can you confirm that the fields are in the same order as per the instructions above? I have tested this myself and it works for me. You might want to read the following thread. Their issue might be related to yours. They were able to resolved the issue.

Thank you

[xbootnek]

Fields are the same and I am following the procedure. I get the same results on Win 10 and on my ChromeBox.

I note that after Upload the next page shows the csv file name at the top correctly but below it adds “-x” to the name where x is a sequential number that increments each time I upload. At no time does any file appear under the tab “From Computer” tab.

I have tried both browser and multi-file uploads. No difference.

[mbrsolution]

Hi, did you disable the following option in the plugin Disable “auto_increment” Column:

[xbootnek]

Remind me again. Am I supposed to using the 25 or 31 column csv layout?

[mbrsolution]

Hi, you should not be going beyond the number of columns specified in the sample file in the documentation I shared above.

[xbootnek]

Your documentation has one csv layout with 25 columns and another with 31. Which is correct?

[mbrsolution]

Hi, use the text file sample as a guide without adding more tables.

[Author]

Posts