Title: maybe42's Replies | WordPress.org --- # maybe42 [ ](https://wordpress.org/support/users/maybe42/) * [Profile](https://wordpress.org/support/users/maybe42/) * [Topics Started](https://wordpress.org/support/users/maybe42/topics/) * [Replies Created](https://wordpress.org/support/users/maybe42/replies/) * [Reviews Written](https://wordpress.org/support/users/maybe42/reviews/) * [Topics Replied To](https://wordpress.org/support/users/maybe42/replied-to/) * [Engagements](https://wordpress.org/support/users/maybe42/engagements/) * [Favorites](https://wordpress.org/support/users/maybe42/favorites/) Search replies: ## Forum Replies Created Viewing 10 replies - 1 through 10 (of 10 total) * Forum: [Reviews](https://wordpress.org/support/forum/reviews/) In reply to: [[Nimble Page Builder] Disappointed](https://wordpress.org/support/topic/disappointed-119/) * Thread Starter [maybe42](https://wordpress.org/support/users/maybe42/) * (@maybe42) * [2 years, 4 months ago](https://wordpress.org/support/topic/disappointed-119/#post-17416339) * It might be operational, but for how long? Actually there’s errors on the demo pages of presscustomizr.com, I wish this would happened several weeks ago cause it would prevent me for wasting a lot of money.If you look at other page builders documentation, you will see the difference.I will now move to Divi as soon as possible, there you have guaranteed support and a vast amount of documentation and guides and examples and so on. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Participants Database] How to count the number of images (Image Expansion Kit)](https://wordpress.org/support/topic/how-to-count-the-number-of-images-image-expansion-kit/) * Thread Starter [maybe42](https://wordpress.org/support/users/maybe42/) * (@maybe42) * [4 years, 3 months ago](https://wordpress.org/support/topic/how-to-count-the-number-of-images-image-expansion-kit/#post-15522470) * Oh, sorry, I was not aware of that. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Participants Database] How to display date_updated?](https://wordpress.org/support/topic/how-to-display-date_updated/) * Thread Starter [maybe42](https://wordpress.org/support/users/maybe42/) * (@maybe42) * [4 years, 3 months ago](https://wordpress.org/support/topic/how-to-display-date_updated/#post-15522426) * Thank you, this works like a charm. I did not remember the string combine field. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Participants Database] CSV import problems](https://wordpress.org/support/topic/csv-import-problems/) * Thread Starter [maybe42](https://wordpress.org/support/users/maybe42/) * (@maybe42) * [4 years, 3 months ago](https://wordpress.org/support/topic/csv-import-problems/#post-15476786) * Hi Roland, * I have found the following workaround(s): I set up a new temporary column for the hull number (not read-only, of course), so now it will be imported in every row. After the import I simply copy the values over using SQL. That’s works around problem #1. * For the private ID I generate one into my CSV file, because it gets generated itself using Java this is very simple. On that the duplicate check and skip works well. That works around problem #2. * I will try your suggestion by removing the default value, this maybe would be easier than my solution. * On the other hand I have set up a debugging environment using Netbeans with xdebug, but I have to find time to dig into it. It will take some time, sorry. * brgds, Peter * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Participants Database] CSV import problems](https://wordpress.org/support/topic/csv-import-problems/) * Thread Starter [maybe42](https://wordpress.org/support/users/maybe42/) * (@maybe42) * [4 years, 3 months ago](https://wordpress.org/support/topic/csv-import-problems/#post-15473684) * Hi Roland, * I have found out a thing at least. The column “hull_number”, which were imported only sometimes and sometimes not, had a flag of being read-only. Same applies to the column email_address. But it won’t help to change that flag, I had to delete the column and create a completely new one, and now the import do it right every time. So there might be a problem with any kind of caching. * A second problem arises as I mentioned before, the private ID will either be empty or it always have the same value. I do not import it and moreover I have set the private ID as duplicate record check field… even it should not be necessary, because it must be always unique. I suppose that this is really a bug. * I have inserted some own debug infos and here is the output of my test case ( I reduced it to a minimum): * ``` xnau_CSV_Import::insert_from_csv columns:ship_name, vega, year_built csv line= Array ( [ship_name] => Rigoletto [vega] => 1751 [year_built] => 1973 ) xnau_CSV_Import::insert_from_csv columns:ship_name, vega, year_built csv line= Array ( [ship_name] => Las Vegas [vega] => 1002 [year_built] => 1970 ) [pbe] after do_action [column_name]:ship_name [pbe][column_object->import_value()]:Rigoletto [pbe][$column_object->query_clause()]:ship_name = %s [pbe][$column_object->add_to_query($action)]:1 [pbe] after do_action [column_name]:vega [pbe][column_object->import_value()]:1751 [pbe][$column_object->query_clause()]:vega = %s [pbe][$column_object->add_to_query($action)]:1 [pbe] after do_action [column_name]:year_built [pbe][column_object->import_value()]:1973 [pbe][$column_object->query_clause()]:year_built = %s [pbe][$column_object->add_to_query($action)]:1 [pbe] after do_action [column_name]:private_id [pbe][column_object->import_value()]:RPNE2 [pbe][$column_object->query_clause()]:private_id = %s [pbe][$column_object->add_to_query($action)]:1 PDb_submission\main_query\base_query::execute_query storing record: INSERT INTO wp_participants_database SET date_recorded = "2022-03-18 21:25:42", date_updated = "2022-03-18 21:25:42", ship_name = 'Rigoletto', vega = '1751', year_built = '1973', private_id = 'RPNE2' PDb_Participant_Cache::refresh_cache: Refreshing Participants Database cache for cache group 2 [pbe] after do_action [column_name]:ship_name [pbe][column_object->import_value()]:Las Vegas [pbe][$column_object->query_clause()]:ship_name = %s [pbe][$column_object->add_to_query($action)]:1 [pbe] after do_action [column_name]:vega [pbe][column_object->import_value()]:1002 [pbe][$column_object->query_clause()]:vega = %s [pbe][$column_object->add_to_query($action)]:1 [pbe] after do_action [column_name]:year_built [pbe][column_object->import_value()]:1970 [pbe][$column_object->query_clause()]:year_built = %s [pbe][$column_object->add_to_query($action)]:1 [pbe] after do_action [column_name]:private_id [pbe][column_object->import_value()]:RPNE2 [pbe][$column_object->query_clause()]:private_id = %s [pbe][$column_object->add_to_query($action)]:1 PDb_submission\main_query\base_query::execute_query storing record: INSERT INTO wp_participants_database SET date_recorded = "2022-03-18 21:25:42", date_updated = "2022-03-18 21:25:42", ship_name = 'Las Vegas', vega = '1002', year_built = '1970', private_id = 'RPNE2' PDb_Participant_Cache::refresh_cache: Refreshing Participants Database cache for cache group 2 ``` * I think I will try to generate an own private ID in my CSV file, that maybe would help me to import my data 🙂 * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Participants Database] CSV import problems](https://wordpress.org/support/topic/csv-import-problems/) * Thread Starter [maybe42](https://wordpress.org/support/users/maybe42/) * (@maybe42) * [4 years, 3 months ago](https://wordpress.org/support/topic/csv-import-problems/#post-15469785) * I am very sorry by not being clear with my description 🙁 * I do not import private IDs, I expected that they were generated as it is the case when I register a single entry using the registration form. In my CSV file are just the columns I mentioned before, i.e hull_number, owner_name, year_built, email_address and so on. * A few weeks ago these private IDs have been generated as expected, but now they all have the same value. When I find the time I will set up another test case on my own server so I can better look into it and maybe extend the debug output a bit. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Participants Database] CSV import problems](https://wordpress.org/support/topic/csv-import-problems/) * Thread Starter [maybe42](https://wordpress.org/support/users/maybe42/) * (@maybe42) * [4 years, 3 months ago](https://wordpress.org/support/topic/csv-import-problems/#post-15466260) * Hi Roland, my problem still persists, but as I mentioned before I was able to delete the corrupt entries and try the import again until all columns are imported correctly. * I just updated to 2.0.8, but I have still a second error that is more than ugly: The imported private IDs are all the same (in my case “RPNE2”). I use the addition to expand the private ID to 9 characters, so normal registration IDs look like“ IS5T1U0F4”. * Even if I say that private ID is the duplicate record check field and the preference is not to import these records, the import creates duplicates, all with private ID “RPNE2” 🙁 * Do you have any idea where I could look after this? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Participants Database] CSV import problems](https://wordpress.org/support/topic/csv-import-problems/) * Thread Starter [maybe42](https://wordpress.org/support/users/maybe42/) * (@maybe42) * [4 years, 4 months ago](https://wordpress.org/support/topic/csv-import-problems/#post-15432827) * Hi Roland, I have installed a transient plug-in to see anything that I wanted never to see 🙂 After removing all non-persistent transients I imported again, with no success. BTW, I changed all my test changes back to the prevoius state as mentioned in my first posting. * So here again is my test record, settings are Auto/Auto, duplicate record preference =dont import the record, duplicate record check field=email * ``` hull_number;ship_name;year_built;location___city;country;owner;description;data_source;status;email 1751;Rigoletto;1973;Down Cruising Club;United Kingdom;Michael McDermott;RIGOLETTO (formerly Elkedor) moved from Fareham to Strangford;VEGADB;imported;mjmcd1@btinternet.com ``` * Now two things are interesting. * 1. The import imported all columns except “hull number” and “email”, and in the list view there is no “private ID”. But when I dive into the edit view, there is a “private ID” – which is already in the database and used by another older record. * (cant’t attach screenshots here, but I have some) * 2. After the failed import there is a transient called ‘participant_cache_4’. This is the content (I formatted it a bit to be more readable, its one long string) * ``` a:1:{i:446;O:8:"stdClass":30:{ s:2:"id";s:3:"446"; s:10:"private_id";N; s:7:"country";s:14:"United Kingdom"; s:5:"email";N; s:12:"mailing_list";s:2:"No"; s:5:"photo";N; s:7:"website";N; s:9:"interests";N; s:8:"approved";s:2:"no"; s:13:"date_recorded";s:19:"2022-03-07 08:55:57"; s:12:"date_updated";s:19:"2022-03-07 08:55:57"; s:13:"last_accessed";N; s:16:"last_update_user";N; s:11:"hull_number";N; s:5:"owner";s:17:"Michael McDermott"; s:9:"ship_name";s:9:"Rigoletto"; s:15:"location___city";s:18:"Down Cruising Club"; s:15:"location___area";N; s:11:"data_source";s:6:"VEGADB"; s:6:"status";s:8:"imported"; s:10:"year_built";s:4:"1973"; s:14:"more_equipment";N; s:13:"delete_record";N; s:6:"engine";N; s:11:"description";s:61:"RIGOLETTO (formerly Elkedor) moved from Fareham to Strangford"; s:11:"hide_record";s:3:"Yes"; s:14:"previous_names";N; s:12:"current_flag";N; s:14:"owner_imported";N; s:14:"email_imported";N; }} ``` * If I see it right, it says the following: private id, email and hull number are treated as ‘not in CSV list’, which of course is not true. The last two colums, owner_imported and email_imported, are no longer in the database, I added it for testing and removed it afterwards. They will surely be in the column table but are not active anymore. * This points into a direction where caching comes into mind? * I hope my findings are of some help, if needed you can have access to my site, it’s just a testbed for the time being. Another thing I will try is to set up a quick test environment on my personal linux server where I have more control than on my provider’s server. * best regards, Peter * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Participants Database] CSV import problems](https://wordpress.org/support/topic/csv-import-problems/) * Thread Starter [maybe42](https://wordpress.org/support/users/maybe42/) * (@maybe42) * [4 years, 4 months ago](https://wordpress.org/support/topic/csv-import-problems/#post-15430800) * Well, I am through a lot of tests, still no luck. * 1. I streamlined the header line and removed a unused column 2. I changed the delimiter from semicolon to comma 3. I added double quotes as delimiter 4. I tried with ‘Auto’ settings but also with dedicated specification 5. I removed the email addresses 6. Finally I removed even any spaces 🙂 * Sometimes it works fine a few times in a row, then it doesn’t work again. Now I’m a bit clueless. * regards, Peter * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Participants Database] CSV import problems](https://wordpress.org/support/topic/csv-import-problems/) * Thread Starter [maybe42](https://wordpress.org/support/users/maybe42/) * (@maybe42) * [4 years, 4 months ago](https://wordpress.org/support/topic/csv-import-problems/#post-15430478) * Hi Roland, many thanks for your effort. * As a software developer I understand very well that you want to fix the problem, it should either ALWAYS work or ALWAYS print an error. I did a few runs but as soon as I thought I’d spotted a pattern, it just couldn’t be reproduced. * This is what the result looks like without changing anything in between – I just delete the two imported records again and again before a new import: * 1 okay 2 okay 3 NOK 4 okay 5 NOK 6 okay 7 okay 8 NOK 9 okay 10 NOK 11 okay 12 NOK 13 okay 14 NOK 15 okay * Can the whole thing have something to do with “session status” or “caching”? * I can do a workaround by breaking the import into smaller chunks (I have about 600 records to import in total) and if a run doesn’t work, I delete the records without “Private ID” and keep trying until it works . * Unfortunately I don’t have the time to set up a private development environment to debug, but I’ll do some more test runs later to help troubleshoot. * Best regards Peter Viewing 10 replies - 1 through 10 (of 10 total)