Dear SiteManager Material User,
Your TxDOT SiteManager Excel test files have been updated and are available now on your TxDOT website. Most notably this update includes a migration of all files to the newer Microsoft 2007+ macro enabled file extension .xlsm.
The request to distribute these updated files was sent through the IT distribution labyrinth at the first of May. The files were quickly distributed to the txdot website, but they have yet to be distributed to your statewide x:\apps\smgr\sm3x\msexceltemplates\ directory. Instead of retracting the web files until a time when IT can push the files to your servers, we have decided to continue moving forward.
What does this means for you? The impact can be summarized in one word – Importing. If you frequently import into SiteManager test data from a saved file, you’ll want to read the exceptions below. These exceptions are linked to the new XLSM files only*. The older XLS files will continue without error to import today and after these updated XLSM files are distributed to your x:\APPS directory.
When or if a contractor or commercial lab begins using the xlsm files you’ll want to read and understand these exceptions for importing the test data:
· Terminal Server for SiteManager
· This is the recommended option. Currently there are no issues with this platform.
· Non-Inspector SiteManager
· Importing: Pending an update to your network APPS directory, the new XLSM files will not import into the client Non-Inspector SiteManager version. The workaround is to use the Terminal Servers for SiteManager.
· SiteManager Citrix
· Importing: Pending an update to the actual Citrix servers which is slated for July, the new XLSM files will not import on the SiteManager Citrix. The workaround is to email the files to be imported to CST_SITEMANAGER@txdot.gov. We’ll revert them to a version acceptable to the Citrix server and return them to you.
These exceptions are linked to the new XLSM files only.
A follow-up will be sent when the distribution to your local X:\APPS directory is complete. As of right now we do not have an estimated distribution date.
*Note – Reverting a newer XLSM file to a previous version by saving it as a 97-2003 XLS file type will not resolve the import error.
Thank you,
STEWART DEWITT | SENIOR SITEMANAGER SUCCOR™ | TxDOT | 512.416.2462 |stewart.dewitt@txdot.gov
| Talk. Text. Crash. |
| |
