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

XF 1.5 Why do I want to reuse IDs?

Discussion in 'Installation, Upgrade, and Import Support' started by CrispinP, Apr 12, 2016.

  1. CrispinP

    CrispinP Active Member

    Hi folks,

    Busy setting up the switch over from VB4 to XF1.5.

    Why do I want to keep the IDs? What's the benefit?

    I would like to run the importer, get everything setup and then clear down the posts and users and run the importer just before switch-over. It seems crazy to drop the DB to restart the importer.

    Do I car about IDs or not?


    thanks
    Crispin
     
  2. CrispinP

    CrispinP Active Member

    I should have added -

    I will have a url rewrite from old forum links to new with a perm redirect. This will get around the problem of inward links.

    When I switched from phpBB to VB4 I did that without hassle. Simple lookup code on my side to bounce them to the new place. (Assuming XF keeps a link. Busy looking)
     
  3. CrispinP

    CrispinP Active Member

    so, it looks this this would be quite simple using the xf_import_log table. I'll build a redirect based off that. :) (will add it here when done)
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Reusing IDs is primarily for aesthetic purposes - a lot of people like to keep the same member ID they have with other software, but it is also related to redirection.

    If IDs are the same then the scripts aren't required as it's a direct map from original forum ID to XF ID.
    If the IDs are different though, the scripts and log table would be required.
     
    CrispinP likes this.
  5. CrispinP

    CrispinP Active Member

    Thanks for the confirmation.

    So if I run the importer now and want to run it again is the following enough to clear down the posts and uses? (forum structure will not change)

    lol @ list below - pretty much everything :) It's all tables with post_id or user_id in.


    xf_admin
    xf_admin_log
    xf_admin_permission_entry
    xf_attachment_data
    xf_conversation_master
    xf_conversation_message
    xf_conversation_recipient
    xf_draft
    xf_email_bounce_log
    xf_email_bounce_soft
    xf_error_log
    xf_feed
    xf_flood_check
    xf_forum_read
    xf_forum_watch
    xf_ip
    xf_moderator
    xf_moderator_content
    xf_moderator_log
    xf_news_feed
    xf_notice_dismissed
    xf_permission_combination
    xf_permission_entry
    xf_permission_entry_content
    xf_poll_vote
    xf_post
    xf_profile_post
    xf_profile_post_comment
    xf_report_comment
    xf_search
    xf_search_index
    xf_session_activity
    xf_spam_cleaner_log
    xf_spam_trigger_log
    xf_tag_result_cache
    xf_tfa_attempt
    xf_thread
    xf_thread_read
    xf_thread_reply_ban
    xf_thread_user_post
    xf_thread_watch
    xf_upgrade_log
    xf_user
    xf_user_alert
    xf_user_alert_optout
    xf_user_authenticate
    xf_user_ban
    xf_user_change_log
    xf_user_change_temp
    xf_user_confirmation
    xf_user_external_auth
    xf_user_field_value
    xf_user_follow
    xf_user_group_change
    xf_user_group_promotion_log
    xf_user_group_relation
    xf_user_ignored
    xf_user_news_feed_cache
    xf_user_option
    xf_user_privacy
    xf_user_profile
    xf_user_status
    xf_user_tfa
    xf_user_tfa_trusted
    xf_user_trophy
    xf_user_upgrade_active
    xf_user_upgrade_expired
    xf_warning
    xf_warning_action_trigger
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    That's not an approach we would recommend.
     

Share This Page