Importing subscriptions

  • Jennie Dawson
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
2 months 1 week ago #125984 by Jennie Dawson
Importing subscriptions was created by Jennie Dawson
Hello
We need to import current subscriptions into an older version of the site, restored from backup. This is due to problem on current server.
Have exported the subscriptions and saved from Excel on my mac to Windows comma separated csv file.
Have tried to import both the csv file and the excel file into the recreated site, but get this error:

Warning
OSM_INVALID_SUBSCRIPTION_ID
OSM_NEED_PLAN_FOR_SUBSCRIPTION

and the import fails. What do I need to do to fix this?

Many thanks
Jennie

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

  • Jennie Dawson
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
2 months 1 week ago #125985 by Jennie Dawson
Replied by Jennie Dawson on topic Importing subscriptions
I think I have sussed this. I deleted the ID column on the left of the spreadsheet and it seems to have worked. Just checking it now.

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

More
2 months 1 week ago #126014 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Importing subscriptions
Don't import and export. Better move database tables from old site o new site, see membershipprodoc.joomservices.com/gettin...e-site-to-a-new-site

Regards,

Tuan

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

  • Jennie Dawson
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
2 months 1 week ago #126015 by Jennie Dawson
Replied by Jennie Dawson on topic Importing subscriptions
Hi Tuan, old vps server compromised at root level due to recent exploit, so can't use database files, my host strictly forbade it!
The import seems to have worked OK now
Thanks for your help
Best regards
Jennie

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

More
2 months 1 week ago #126025 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Importing subscriptions
As long as it's imported properly, you will be fine. So don't worry about it for now

Tuan

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