import registrants

  • p.barg
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
1 year 1 month ago #156878 by p.barg
import registrants was created by p.barg
Hi,
I'm trying to import registrants from a J3 installation to a J4 installation.
The export of the registrants is fine, but for the import the message is always:
"There are total 0 registrants code imported" and no registrants are imported.
What could be the problem here?

Petra

Please Log in or Create an account to join the conversation.

More
1 year 1 month ago #156884 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic import registrants
Hi Petra

Do not export and import. Better move data via database, see eventbookingdoc.joomservices.com/getting...e-site-to-a-new-site

Regards,

Tuan

Please Log in or Create an account to join the conversation.

More
7 months 2 weeks ago #160561 by Lon Czarnecki
Replied by Lon Czarnecki on topic import registrants
I also tried the Export/Import feature and it did not import the registrants. Is the database the only way to get this done? Most of us that use Events Booking are not very comfortable messing around with the database. I did try to export the prefix eb tables and import them into the new database. I got an error that the tables already exist. When I went into the Registrants list on the new site, I see that all registrants after 2018 were erased. This seems a little involved when EB has an export/import feature. Is there another way?

Please Log in or Create an account to join the conversation.

More
7 months 2 weeks ago #160563 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic import registrants
Hello Lon

If you want to import registrants, please remove id column from the exported file (otherwise, the system will try to find the existing registrants and update instead of instead of inserting new registrant)

After that, try to import it. It should work

Tuan

Please Log in or Create an account to join the conversation.

More
7 months 2 weeks ago #160624 by Lon Czarnecki
Replied by Lon Czarnecki on topic import registrants
I removed the ID column and uploaded it. It did not work. It seems to stop at registrants from 2019. No more after that show up. I had to upload it as a CSV because the system only accepts xls not xlsx.

Please Log in or Create an account to join the conversation.