ascdev

OK, problem sorted.

The issue was caused by residual data in the database from a deleted plugin.
All the redundant data now deleted and the problem has gone away.

For interest, the CSV file being generated contained an additional copy of “display_name” field in the middle of the old plugin fields. There were no corresponding fields in the data rows.
I assume having duplicate column names was the issue.

Ah, this appears to be an issue with Excel.

If I use a regular comma separated file – Excel handles embedded return chars correctly. If I use an alternative delimiter – it breaks the lines at the return chars.

LibreOffice works just fine.

Many thanks for your time and clarification.

.. also Line 238/239 for a similar alert.

OK, I have found the problem.

I have found that a key alert (user will be skipped) is not being shown.
Line 230/231 of Importer.php
The quotes around the “%s” in the error string means the final alert string is malformed and so fails to display the alert.

It appears that my import is failing because it does not handle having an empty ‘role’.
But that’s a problem for another day ..

I can now at least import my data and move forward.

Well this is even more strange.

I have tried to use the plugin on both a single site (fresh installation of WP and the plugin) and my multisite.
Different browsers.
These sites are on different hosting platforms.
I have tried 3 different CSV files with different column names.
I have tried adding new users and updating existing users.

None seem to update existing user data nor create any new users.

Perhaps this could be an issue with my local system?? Are there are any specific debugging/checks I can make to track this down? I am very happy to work within the code.

No. I have the setting to Update existing users = Yes. &? Update roles = No.

See options settings here

I have even tried turning this off and back on again.

Snapshot of the results screen.

The row of headers matches the CSV file OK.

Nothing is being imported.
None of the users, none of the metadata.

OK, thanks for that. I read the documentation, but I took it to mean it only applied to creating new users, where of course you’d need to allocate a site id.

Anyway, I’ve added an extra column ‘blogs’ to my CSV file and populated with the blog_id.
But, the metadata for an existing user is still not being imported and updated.

Any other suggestions?

Thanks for this suggestion.

Everything is up-to-date.
Installed WP Safe Mode, switched to TwentyTwenty theme – EM is working perfectly. I can add locations. Great.
Switched back to my normal theme – all OK.
Removed WP Safe Mode and back to original config. All is now working fine!

WHatever happened, the problem is resolved.

I’ve found a workaround.

If I duplicate an existing location and edit the location details. It works OK.
If I try to Add New , it fails.

Yes, I’ve added the required billing information.

Yes, I’ve tried with a new address and checked Chrome console. No errors reported.

One thing Google Cloud Console shows a warning about OAuth ==> “Remember to configure the OAuth consent screen with information about your application.”
I didn’t think API credentials needed this.

• This reply was modified 3 years, 11 months ago by ascdev.
• This reply was modified 3 years, 11 months ago by ascdev.

The problem was related somehow to my Chrome browser caching. Switching to Edge, did not replicate the the problem.
This dev work was done on a staging site online. I am still not entirely sure where Pods was reading the post type data from. I thought I had cleared all possible caches in browser and server, but clearly missed something in Chrome.

Problem solved.

I found the source of the rogue post types.

..
and tried to unregister these rogue post types. I am using add_action(‘init’,’xxx’,10,2) . Is this the correct timing to run the unregister??