I have added an SQL file containing the database changes to allow for automatic Timezone detection of sample files when in the USA (database/queXS_US.sql). Please note that this will remove any other timezone information from the database, so please backup first.
These changes will allow for queXS to automatically detect the appropriate timezone for each record in the sample file based on either:
- The prefix of the telephone number
- The state (if provided)
- The zipcode (if provided)