RPNE2

  • rogerpearce

    (@rogerpearce)


    3 years, 8 months ago

    Hi

    I have seen the correspondence at https://wordpress.org/support/topic/csv-import-problems/

    I have a similar problem. My host has just updated to PHP 7.4. I now find that items I have uploaded before are showing in List Participants without a Private ID. However, in Participants Record, the Private ID is there, and shows as RPNE2, the same as @maybe42 found. What is more, apart from a couple of strays, the next block of items also has Private ID of RPNE2, but now visible in List Participants.

    In my case, the problems is less serious, because all the relevant data has been uploaded and is valid.

    But it’s still curious.

    • This topic was modified 3 years, 8 months ago by rogerpearce.
Viewing 1 replies (of 1 total)
  • Plugin Author xnau webdesign

    (@xnau)

    3 years, 8 months ago

    Participants Database has not used “RPNE2” for years, so this is probably something that has been in your data for a long time.

    First, make sure you’re using the latest version of Participants Database. Then, you’ll want to take a look at your database directly using phpMyAdmin so you can get a complete picture of what’s going on. (the table will be named wp_participants_database) If you’ve got a bunch of records with “RPNE2” as the private_id value (or missing a private id value), you will need to rebuild those records with valid private ID values.

    There are two ways to do that: first export all the data in the records that need a new private ID. Delete those records from the database, then re-import them with a setting that will create new records with the import. This will generate new private IDs for the imported records.

    The second way to do this is to export just the id and the private_id of the records. In the exported file, give each record a new private ID. Make sure this value matches the length of your existing private IDs. Import the modified CSV, using a setting to update the records that match the ID of the importing records. This will give you new private IDs.

    I hope this is helpful.

Viewing 1 replies (of 1 total)

The topic ‘RPNE2’ is closed to new replies.