Unity 4.0.3, How can I export the time zone settings?

[Randall White]

Hi All,

I'm migrating some subscribers from a Unity 4.0.3 server to Unity 4.0.5.

I noticed that the Subscriber Dump tool doesn't seem to list the time zone setting.

Is there any way to automatically retrieve this setting (other than looking up 650 subscribers)? Maybe a SQL table? It's on the Subscriber Profile page.

Once I have this in a CSV file, I'll use the bulk edit tool to change the subscribers on the new server.

Thanks, Randy

[lindborg]

Unfortunatly the time zone info in Unity is a reference into an internal data structure used by the DOH libraries to pull the time zone offsets/names for client needs (or NULL in the case of using the local default) - it's not stored in the DB as a simple minute offset from GMT or the like. This is one of the reasons I didn't stick it in sub info dump in the first place. There's no easy way to dump the time zone assingment out into a human-readable table easily at this point.