Records not visible in front end until edited

What is the exact shortcode you are using to display your records?

The default would display all the records, of course.

Are you using page caching? If so, turn it off for this page.

You prompted me to look in the right place. It was related to the shortcode, which had this element:

filter=”delete_record!=Yes”

That simply hides anything with delete_record set to Yes in the front end list. Of course it doesn’t actually result in a delete, but it appears to from the user’s perspective.

The problem was that the CSV import file did not set any value for that field, so even though it was never “Yes” the filter was not picking out the records. I simply put a value of “No” (although it could have been anything) in the appropriate column of the spreadsheet and re-imported. Problem solved.

Thanks for letting us know how you resolved this!

Unfortunately, I am running into the same issue. We recently changed domains and I exported all records from the old domain and imported them in the new one. The total record count matched and I then exported all records from the new domain to cross-check against the old export CSV. Everything matched so tested a few records and everything was working properly. I initiated the redirect and not even 24 hours later I am notified of missing records. I look on the backend and was able to find the missing records but not able to view them on the frontend. Per the above thread, I checked my export CSV and sure enough, the “Delete” field was blank. I isolated those records, added the same text that was in the rest of the non-deleted records (Which happened to be “delete record from database?”). I uploaded just the records with the delete field filled in but those records are still not showing up. I cleared my cache and made sure that page wasn’t caching. Any other ideas?

Sorry, I figured this out by following Xnau’s recommendation for moving records to a new domain using phpmyadmin. I previously exported all records to a CSV and imported using the plugin. While all the records were transferred properly, not all of them were not displaying on the frontend. After looking at the database, I could see not all the records were in the Participants Database table. I followed his tutorial on xnau.com and everything is working properly. Thank you again Xnau for a great plugin and support. A link to his tutorial is below for those in need.

https://xnau.com/copying-a-participants-database-setup-to-another-site/