Import donors to new Joomla site

  • Jonas Clark
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 1 week ago #157186 by Jonas Clark
Import donors to new Joomla site was created by Jonas Clark
Hello
We have recently developed a new Joomla site and now we want to import-export the donor list to the new site. We tried CSV import-export but it didn't work. Now we are trying to import the donors from the database but we see only 81 entries on the donor list. We have 1661 entries on the old donor list. When I checked the database import status, I got this errorErrorSQL query:


MySQL said:#1050 - Table 'gbcmb_jd_donors' already exists

Please guide me in importing the entries.

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

More
1 year 1 week ago #157188 by Mr. Dam
Replied by Mr. Dam on topic Import donors to new Joomla site
Hi Jonas,
OK, you can follow below steps to migrate data of Joom Donation from old site to new site
1. Using PHPMyAdmin to export all Joom Donation tables of old version to .sql file. The Joom Donation DB table will have the prefix (#__jd...). For example: jos_jd_donors.
2. Open .sql file by Notepad and replace the prefix of old database by prefix of new database.
3. Import modified .sql file into new Joomla database site. Because in .sql file, you add option "Drop tables if exists", so even in new site, you already installed Joom Donation. You won't have any issue in this step.
4. Re-install new Joom Donation version in new site.
Good luck
Dam

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

  • Jonas Clark
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 1 week ago #157189 by Jonas Clark
Replied by Jonas Clark on topic Import donors to new Joomla site
Thanks, Dam for the quick response.
I actually did all these steps except for the option "Drop tables if exists",
Please guide me on where to add this option

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

More
1 year 1 week ago #157195 by Mr. Dam
Replied by Mr. Dam on topic Import donors to new Joomla site
Hi,
Please see my screenshot.
Thanks
Dam
 
Attachments:

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

  • Jonas Clark
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 1 week ago #157209 by Jonas Clark
Replied by Jonas Clark on topic Import donors to new Joomla site
Thank you for sharing. I have been trying to import the database file for 2 days, and a new issue has come up each time. I have been able to import about 662 records. Now I am facing a new problem with permission.

error in processing request error code 500

Please help me in importing the donor list.
It should be very simple like csv import.

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

More
1 year 1 week ago #157247 by Mr. Dam
Replied by Mr. Dam on topic Import donors to new Joomla site
Hi Jonas,
With this kind of issue, please submit ticket on category: Joom Donation and we will help you to solve the problem
Thanks
Dam

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

Moderators: Mr. DamDũng Nguyễn Việt