digimadre

Once again, I appreciate your help with this. I took your advice and checked the enclosure and delimiter character, but it still uploaded empty rows.

Here is the google doc with the dubug log:

https://docs.google.com/document/d/1qyBjF3ytSaP5KBV7MFbHPiydSXCAMlGE2-P72qK5uT0/edit?usp=sharing

I included a snapshot of how I set up the fields.

Thanks for replying so quickly! I appreciate it very much.

I cleared the debug log and attempted another upload. I have double quotes around each item and saved as a CSV UTF-8. The only cells that do not have the double quotes are the empty cells. The ID cell is also empty.

I have set the enclosure character to Auto and the Delimiter character to Auto as well. The Duplicate Record Preference is set to “Don’t import the record” and the Duplicate Record Check Field is the Record ID.

I have also tried to upload with the cells not enclosed in double quotes because I noticed that when I have done a download of the manually entered file, it doesn’t seem to have any quotes when I look at it in notepad.

I have even deleted the plugin and reactivated it so I knew that I had a clean area to work with, but I’m still having the same issue.

I have an empty line that has been added with only the private ID and the Date Recorded filled in.

The list is working fine on our website using the data I have manually entered. I have set it up to Search the Last Names and only show results for that filter. It is a database of Indiana Pioneer ancestors and we like to be able to allow potential applicants to Search to see if their Indiana pioneer ancestor has been approved in our lineage society.

[07/13/22 8:40pm UTC]
PDb_submission\main_query\base_query::execute_query storing record: INSERT INTO wp_participants_database SET date_recorded = “2022-07-13 20:40:27”, date_updated = “2022-07-13 20:40:27”, private_id = ‘296F9NA’