• 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?

CrispinP

Well-known member
#1
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
 

CrispinP

Well-known member
#2
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)
 

CrispinP

Well-known member
#3
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)
 

Brogan

XenForo moderator
Staff member
#4
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

Well-known member
#5
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