What is the exact message you are getting when you attempt the upload?
Hi,
This is the message I get:
‘The file blank_record3.csv has been uploaded.
File upload complete: 144 lines received.
The data is importing in the background, refresh the page to get the current status of the import.’
But the upload doesn’t work.
OK, how do you know the upload didn’t work? Did you refresh the page to check the progress? What message was displayed?
because there are no new records, I refreshed and I didn’t get any messages
OK, you’ll need to turn plugin debugging on and see what is happening with the import. I suggest you try it with just a few records at first.
Also, make sure the format of the CSV matches the preferences selected on the CSV import page and that the CSV file is the correct format, especially make sure the header row is correct.
I have used a template I exported for this, so the header should be ok.
Here is what it shows on plugin debugging, I don’t think there are any relevant errors:
[02/23/22 2:47pm UTC]
PDb_List_Admin::initialize list query: SELECT * FROM wp_participants_database p ORDER BY date_recorded DESC LIMIT 0,100
[02/23/22 2:49pm UTC]
PDb_List_Admin::initialize list query: SELECT * FROM wp_participants_database p ORDER BY date_recorded DESC LIMIT 0,100
[02/23/22 2:49pm UTC]
PDb_List_Admin::initialize list query: SELECT * FROM wp_participants_database p ORDER BY date_recorded DESC LIMIT 0,100
[02/23/22 2:52pm UTC]
PDb_List_Admin::initialize list query: SELECT * FROM wp_participants_database p ORDER BY date_recorded DESC LIMIT 0,100
OK, there’s nothing in the log about the import. What you need to do is clear the debugging log, then attempt an upload and look at the debugging log after that.
Try it with a small import at first.
We can see on a successful load there is a PDb_submission\main_query\base_query::execute_query storing record: (…) for each record uploaded but when unsuccessful, despite saying File upload complete: 11 lines received, there is no corresponding records in the debugging log.
We are at a loss as to why some of the records go in but the majority don’t.
OK, so, when you upload the CSV file, is the number of lines (records) in the file correct?
Also, I’m not clear on whether the problem is that sometimes the whole upload fails and sometimes is is successful, or when you upload a file, some records import OK and some don’t?
What is the final report you get after the plugin is done processing the import?
