Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
I gave up on this, but I'm not happy about it, and my client is even less happy. There should definitely be a way to import a subscription history. If I had known this earlier, I might not have gone with CBSubs for our memberships.
We've plans for more import/export features with a future release once CB has the API for it. Currently we don't have a generic and functional import/export API.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The only way to do such an import at this time would be to do it through an SQL import using an SQL query tool such as phpMyAdmin and populating all fields of the corresponding SQL tables of CBSubs.
Not a trivial task, CBSubs doesn't have only one table like your screenshot shows, but registers subscription, and order/invoice in full details in multiple SQL tables.
It would require to import probably more than what is available to re-create the complete invoice displays that CBSubs does in its history.
Additionally as a non-technical heads-up, re-creating old invoices in a new form is not allowed in most countries either by laws or by accounting regulations. Of course a simple table is ok, but CBSubs does more than the simple table.
2 solutions suggestions:
1) Maybe a freelance developer could do the programming needed to do that particular SQL import for you?
2) If there are not too much users, maybe just do a screenshot for each user's past history in your previous system and attach it to his CB user profile into an image field ?
Like I said, I've given up on this for this site. Even if I had the time to try to generate all the inserts for the tables you mentioned, the odds of it being messed up seem really high. Also, I have 1500 users, so the screen shot solution isn't going to work. What I was trying to say in my last post was just that, if you hope to convert people over from other systems, then I think you need to find a way for them to import their subscription history.
krileon
