Not importing .csv

Resolved DCDawg
(@dcdawg)

10 years, 5 months ago
Carefully crafted a 20-line import for words. Two columns with word and definition. No submitter. Sample lines are as follows:
```
"abrasions","Areas of a coin that were scratched by another coin or object that wears the metal of a coin."
"acetone","A neutral solvent that can be used to clean a coin."
"adjustment marks","Scratches or file markes on a silver of coin coin made by the Mint to reduce the weight of the coin so that the amount of metal does not exceed its value. This usually can be seen in pre-1807 coins."
```
Claims it imported the file (tells me successfully imported them) but does not show in dictionary either from the WP admin panel or when I looked at the database through myPHPadmin. When I look using myPHPadmin, only the two sample lines exist.

Tried a file with just those three lines with same result.
Tried re-installing plugin with same result
Went into myPHPadmin and dropped the tables, reinstalled plugin with the same result

Any suggestions?.

https://ww.wp.xz.cn/plugins/name-directory/

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

Thread Starter DCDawg
(@dcdawg)

10 years, 5 months ago

Just to follow up, after looking at the schema of the table, I rewrote my list of words to do an SQL INSERT for each line. I was able to load the table with the words.

I added a word through the admin panel form with success. I was also successful in editing entries through the admin panel. The only thing that appears to not be working is the import of a .csv file.

Other than that, so far so good. The rest of it might be what I am looking for!!

Plugin Author Jeroen Peters
(@jeroenpeters1986)

10 years, 5 months ago

Hi DCDawg! Thanks for reporting this. I have been offline a few days because of Christmas, I’m sorry te reply a little late.

I will investigate this. Is there any chance you can e-mail me your file? That way I can check if there characters in there that my plugin tries to filter or something like that. My mail address is this username (jeroenpeters1986 here on wp-forums) @ gmail.com.
I’m sorry I’m not writing it out, I hope to prevent spam 🙂

Also, do you use Windows, Mac or maybe Linux? And what program did you use to construct the file? These answers might come in handy when I need to check the line-endings on the file.

Kind regards, Jeroen

Sarah Tebo
(@sarahtebo)

10 years, 5 months ago

I am having the same problem. I created a large CSV (360 lines) from your sample. When I import, I get a message stating that 360 entries were created (“Imported 360 entries in this directory”), but they are not reflected on the site. I used Numbers on Mac to edit the spreadsheet, and exported as a CSV.

It may be worth noting that the import worked fine a couple weeks ago when I first tested it with a sample of my data (about 50 lines).

Plugin Author Jeroen Peters
(@jeroenpeters1986)

10 years, 5 months ago

Hi Sarah,

thanks for reporting. Would you mind sending the file to me so I can investigate and test with your situation too?

Kind regards,

Jeroen

Sarah Tebo
(@sarahtebo)

10 years, 5 months ago

Thank you Jeroen! I’ve sent it to the email you referenced above.

Plugin Author Jeroen Peters
(@jeroenpeters1986)

10 years, 5 months ago

Thank you both for sending your files. I’ll investigate and keep in touch 🙂

Sarah Tebo
(@sarahtebo)

10 years, 5 months ago

FYI I ended up doing an import directly into the database so my issue is no longer urgent. But hopefully the file will help you pinpoint any potential quirks in the plugin, if they exist.

Plugin Author Jeroen Peters
(@jeroenpeters1986)

10 years, 3 months ago

Hi guys. Everyone, thanks for reporting bug to me.

It has just been fixed. Within an hour you should be able to update to WordPress 1.7.8 which contains the import fix.

Thanks again for all your input (sample csv files).

Kind regards, Jeroen

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

The topic ‘Not importing .csv’ is closed to new replies.