User Options after Import

[Jacqueline]

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?

[Marco van Herwaarden]

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:

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:

UPDATE user SET autosubscribe = 1 WHERE importuserid > 0;

PM Popup:

UPDATE user SET pmpopup = 1 WHERE importuserid > 0;

Time Zone:

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. ;)

[Jacqueline]

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

Thank you very much!

[Marco van Herwaarden]

This got 3 settings:
- Automatic
- Always on
- Always off

Which one you need, and what is the current setting?

[Jacqueline]

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.

[Marco van Herwaarden]

In most cases leaving it set to "Automatically detect" should work fine.

[Jacqueline]

I'll do that. Thanks.