maybe42

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.

Thank you, this works like a charm. I did not remember the string combine field.

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()]:<code>ship_name</code> = %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()]:<code>vega</code> = %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()]:<code>year_built</code> = %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()]:<code>private_id</code> = %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  <code>date_recorded</code> = "2022-03-18 21:25:42",  <code>date_updated</code> = "2022-03-18 21:25:42", <code>ship_name</code> = 'Rigoletto', <code>vega</code> = '1751', <code>year_built</code> = '1973', <code>private_id</code> = '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()]:<code>ship_name</code> = %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()]:<code>vega</code> = %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()]:<code>year_built</code> = %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()]:<code>private_id</code> = %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  <code>date_recorded</code> = "2022-03-18 21:25:42",  <code>date_updated</code> = "2022-03-18 21:25:42", <code>ship_name</code> = 'Las Vegas', <code>vega</code> = '1002', <code>year_built</code> = '1970', <code>private_id</code> = '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 🙂

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?

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