1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.1 Best way to Import VB Subscriptions

Discussion in 'Installation, Upgrade, and Import Support' started by Moddis, May 10, 2013.

  1. Moddis

    Moddis Active Member

    I just went though a test import/migrations and noticed that the subscriptions did not imports.

    Since there is no default import for this, and tyhere is no way I will manually be adding those users, I guess I can do a simple CSV import into the correct tables.

    Please let me know which are all of the tables used by XenoForo's "User Upgrades" system so that I can do this import correctly and know which field to look for and map them.

    Im sure this will nto fix the problem with reoccurring payments because paypal will be sending payment IPN's to different url but I would at least like the users to keep the "Upgraded user" status and for that secondary usergroup to be removed once the subscription is over.

    BTW, will the secondary usergroup be removed if they had that usergroup before they "subscribed"?

    I would appreciate anyone's experience with this.

  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  3. Moddis

    Moddis Active Member

    Thanks Jake. After reading that thread I do see a a few problems, especially since im on vb3 so the best route route for me to be to just import the data.

    All I would need to do is map the Vb table fields: vb_paymentinfo, vb_paymenttransaction and vb_subscriptionlog
    to the Xf table field: xf_user_upgrade_expired and xf_user_upgrade_log (Am I missing any other tables where payment, upgraded user info would be registered)

    Some fields look obvious look obvious but some (transaction_details) I would need to figure out what to put in there. I would need to make some payments to see how things get registered int he database. Is there a way to use a test paypal email for this?

  4. 0ptima

    0ptima Well-Known Member

    I need this too. Maybe we can split the cost have this addon converted to import VB3 subscriptions?
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    AFAIK it's just the four tables starting with xf_user_upgrade.

    vB3 subs are probably identical to vB4 subs in the database. vB4 was based on vB3 and many systems have the same schema.
  6. Slavik

    Slavik XenForo Moderator Staff Member

    Yup, they are the same.

Share This Page