Announcement

Collapse
No announcement yet.

User Options after Import

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • User Options after Import

    Prior to doing the import, I set all of my User Registration Options to what I wanted them to be for the users, and in checking my users after import and doing the "end game," it looks like they imported with default options instead of the ones I set.

    Some options I set that are not changed:
    User Reputation Options:
    Should be set to Yes, with 10 repution. It is set to No with 0 reputation.

    User Registration Options:
    Automatic thread subscription mode should be Instant e-mail notification, and instead is set to Subscribe with no notification, and "Yes" was checked for Popup Notification Box When a Private Message Recieved, but for the imported users it is not checked.

    Date and Time Options:
    Default Time Zone offset is set to GMT-5 Eastern with daylight enabled, but the imported users all are set to GMT Western Europe with no DST.

    Did I miss something in the import? If not, how do I fix all the options?
    ~ Jacqueline

    Baby Talk Zone

  • #2
    I don't know if the Import would retrieve default vB settings if the value can not be determined from the userprofile in the source database.

    You could "repair" things with the following queries:

    Reputation:
    Code:
    UPDATE user SET reputation = reputation + 10 WHERE importuserid > 0;
    This will add 10 points to each imported (but also merged) user.

    Show reputation:
    AdminCP->Import & Maintenance->Execute SQL Query->Automatic Query: On - Display Reputation

    Subscription:
    Code:
    UPDATE user SET autosubscribe = 1 WHERE importuserid > 0;
    PM Popup:
    Code:
    UPDATE user SET pmpopup = 1 WHERE importuserid > 0;
    Time Zone:
    Code:
    UPDATE user SET timezoneoffset = -5 WHERE importuserid > 0;
    Think this will fix you. Mind you this is not tested, so run on a test board first.
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

    Comment


    • #3
      That looks like it will work fine. Do you know the query to turn on daylight savings time too?

      Thank you very much!
      ~ Jacqueline

      Baby Talk Zone

      Comment


      • #4
        This got 3 settings:
        - Automatic
        - Always on
        - Always off

        Which one you need, and what is the current setting?
        Want to take your board beyond the standard vBulletin features?
        Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

        Comment


        • #5
          I am trying to change "Is DST currently in effect" to yes. Perhaps I am trying to change something I shouldn't? Automatically detect DST settings is already set to Yes.
          ~ Jacqueline

          Baby Talk Zone

          Comment


          • #6
            In most cases leaving it set to "Automatically detect" should work fine.
            Want to take your board beyond the standard vBulletin features?
            Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

            Comment


            • #7
              I'll do that. Thanks.
              ~ Jacqueline

              Baby Talk Zone

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X