JessAskin

I figured it out. My Excel file has double-quotes around text fields and tabs between records. If I import using double-quotes for “enclosure character”, and tab for “delimiter character”, it fails every time. I thought it should work since double-quotes and tabs are common delimiters in CSV files.

When I selected Auto for the delimiters, it works every time. Same data with double-quotes and tabs, and Auto works.

FYI for anyone reading this, foreign characters in a record also caused some records not to be imported. Eg, if you have the name Ramírez, you have to Anglicize it to Ramirez. This includes characters like ?, ?, a, ê and so on.

Thanks for the response, but I guess I wasn’t clear.

My test data has 5 fields and 1 record entered manually. I have tried exporting a blank CVS of field names and entering data, then importing new data, does not work. I have tried exporting existing dataset of 1 record with 5 fields and then importing without change,does not work. I had tried splitting the “real” data into 300 records per dataset, failed.

I’ll keep trying things, hopefully I’ll get it to work and then implement the two add-ons I purchased.

Yeah! I get an entirely new menu option. Can’t wait to start using it. Thank you very much

Thanks, will try.

Update: 44 minutes of conversation later: they don’t know. The CS Rep (in all fairness, she was pretty smart, unlike my snotty comment above) thinks “system” is a chron job, and it’s deleting stuff automatically. She checked and discovered that post #s 8833-8837 were all missing/deleted, and they all dated to March 2015. I checked my audit logs a little more thoroughly, and found that “system” is what shows up when I schedule a post for publication later, and it publishes (in which case, it reads private to published, instead of deleted) She’s never seen anything like it before, but vaguely similar issues were raised where it turned out to be a plugin using “system” to automate jobs.

Seems the solution is to deactivate each plugin one at a time, then wait check, as each “system” entry is almost a week apart. If I find an answer, I will post it here.

Honestly I am trying to avoid that 30 minute phone call or chat window with a Customer Service rep on a Sunday, who is very likely not going to have a clue.

Yesssssss! Hardeep, you are fantastic! It had been set to TRUE by a security plugin (it even said so in the wp-config.pho file), so I set it to false, FTP’d it back and voila! Theme editor is an option. Thanks!

I had not found a solution yet. Thank you, I’ll consider your suggestion.