Hi Team,
I have requirement to run on scheduler to create case based on configuration and export some transactional data in the excel file, send an email. In the excel there is one column with datetime type is one of the columns and in the excel always it is exporting as the usertimezone. Example: This scheduler PM always run around 01:00 AM CST and last published designer time zone is GMT.As this user is administrator across platform level, so don't want to change user time zone to CST. Please find below items for reference.
1. I have run the PM in the CST timezone,Stil in the exported excel file taking the last published Administrator account time zone (GMT).
2. I can do it in data base, but i don't see any dynamic function to convert automatically handle daylight savings (Without hardcoding +06:00 hours..etc).
Can you please help me out to export excel the column data datetime as CST timzone.
Thanks and Regards
Venkatesh Suram
Discussion posts and replies are publicly visible
You can run your model in any timezone you want, independent of the timezone of the last published account. Just configure it in the model properties and disable the "Override with Initiator's Time Zone" checkbox.
docs.appian.com/.../process-model-object.html
Yes Stefan. As i mentioned in the #1 I, run the CST time zone and in the process model all the nodes running under the defined time zone (CST) but export datastore entity to excel file exporting the datetime column data as last published user time zone (Administrator Account GMT).
I am not sure this is connected to any user account. The database stores the data always in UTC, and the export function just queries the data without any transformation.
What evidence do you have that the export is observing the user's time zone (or any other time zone) at all? It sounds to me like it's just exporting the value found in the DB which will always be GMT/UTC.
Whenever i run the PM model to export the data, tried to change the last published user account time zone and it is exporting the datetime as user time zone instead of the Process model time zone (CST) which is defined in the process model and unchecked the "Override with Initiator's Time Zone" checkbox. Example: First time last published administrator account in the GMT, after run and export data showing in excel as GMT. Another scenario changed the last published user account time zone to IST and exported data in excel as IST date time value.
Thanks for clarifying. I'm not sure whether there are any easy workarounds then, if you're not able to change the user time zone for the Administrator/Publisher account to your local time zone (then again, there might not be any good reasons NOT to do that, or at least try it in your Dev environment and see if it works).