in the InterSystems management portal, I am in the lookup table viewer (interoperability>lookup Tables, I would like to use import function to convert our existing table from other system to intersystems lookup table.

so I converted our existing one like below and saved it as xxx.xml file locally. when I try to import, it says it is not a valid export file.

my question is " what's the valid format for a file to be valid to use to import for lookup table?"

1 5
0 174

We are using the IRIS cloud. and I am working on a DTL .

so the source side timestamp is local time for example 20240110134740, I know it is a local time. so the requirement is I need to append the UTC at the end, like -0400 or -0500 depending on if it is daylight saving time.

so is there function to return if current day is at daylight saving time, so I can decide if I need to append the -400 or -500? or a function to return the current UTC by location?

0 3
0 130