Sunday, July 19, 2015

RE: SiteManager & EPRS unavailable this weekend for server migrations

 

All,

 

The migration of SiteManager and EPRS has been successfully completed.

 

For any issues please contact the service desk.

 

TXDOT Service Desk | 512.302.HELP (4357) | http://ITHELP

 

Thanks,

 

Danit

 

Justine McGrady | NTT DATA, Inc. | Project Manager | w. 512.465.3699 | c. 972.467.8148 | Justine.McGrady@nttdata.com

 

From: CST_SITEMANAGER [mailto:CST_SITEMANAGER@txdot.gov]
Sent: Tuesday, July 14, 2015 12:25 PM
To: Tier 1 notifications; Cindy Hurta; Crystal Woodruff; Cullen Pfeiffer; Michael Underwood; Stewart DeWitt; Cliff Hallford; Debbie Paylor; Paul Norman; Saundra Collins; Sendy Bolin; Brad Buchanan; Darrell Caldwell; Joey Cordova; Kelli Navarrette; Kit Black; Laura Alwan; Mike Fowler; Ofelia Garbalena; Radina Turner; Roxanne Jennings; Shannon Glenn; Buddy Williams; Charlotte Aslin; Donna Barnes; Jason Dupree; Lance Simmons; Rickie Shields; Thomas Young; Donna Roberts; Barbara Davenport; Elizabeth Lukefahr; Loren Rice; Lori Wagner; Miguel Arellano; Steven Hay; Sylvia Bockholt; Tad Nichols-C; Tammy Hilbig; Tim Wilhelm; Tommy Blackmore; Tracy Cooper; Andrea Murry; Linda Korns; Michael Skiles; Patrick Ryan; Preston Cooper; Susan Will; Andy Berlan; Cassandra McKibben; Chris Cowen; Jennifer Trowbridge; PJ Vargas Jr; Sandy Perry; Shannon Aultman; Sheryl Petroski-C; Stephen Kasberg; Terry Paholek; Zyna Polansky; Carl Johnson; Eric Lykins; Paula King; Rocky Roberts; Tina Crelia; Tonya Shaw; Darwin Lankford; Gene Garcia; Shari Thomason; Alice Garcia; Cordy Diaz; David Chapa; Deborah Shults; Joseph Briones; Karla Moczygemba; Lester Lindley; MaryAlice Hernandez; Mitzie Gibson; Orlando Carrillo; Ruben Garcia; Sandy Harris-C; Steve Orchard; David Henke; Frank Mayfield; Jay Tarwater; Jesus Valdez; John Obr; Johnny Johnson Jr; Juan Ortega; Melissa Daniels; Noe Cabazos; Roxana Garcia; Scott Starkjohann; Carol Berry; Chris Briggs; David Morren; Debbie Burgess-C; Leann Kemp; Noraima Perez; Rhonda Schmid; Robert Delaney; Sherry Perkins; Terry Bruce; Trena Brand; Valarie Ashmore; Aldo Madrid; Frank Guzman; Ken Barnett; Letty Delira; Lorena Soriano; Margarita Montes; Margie Cedillo; Maria Chavez; Susan Freres-C; Bruce Matusek; Fernando Hernandez; Alan Easterling; Allen Shelley-C; Annette Cuevas; Brad Tate; Dora Soto; Glynis Rodriguez; Jackie Broussard; Kristie Woods; Richard Williammee Jr; Steve Bone; Andrus Harris; Carolyn Fink; Emmanuel Isonguyo; HopMing Tang; Ilona O'Blenis; Lee Hamberry; Lovey Reynolds; Marian Jamandre; Oleta Dick; Tim Medrano; Todd Hannah; Amy Nieman; Blythe Jowers; Darral Bryant; Jeremy Dearing; Kami Wilbanks; Linda King; Doug Y'Barbo; George Wilson Jr; Missy Lowe; Phyllis Clark; Sam Hankla; Vivian Harrison; Cynthia Saldana; David Salazar; Nelda Martinez; Sergio Reyna; Claudia Kern; Gisel Carrasco; Greg Jones; Jana Buck; Jerry Peterson Jr; Michael Dawidczik; Richard Izzo; Richard Knowles; Robert Lee; Travis Patton; Keith Buckley; Kelly Jones; Timothy West; Chad Windham; David Alvarez; Donnie McNatt; Kathy Schlegel; KC Evans; Mike Stroope; James Hutchison III; Karen Jackson; Leisha Hopkins; Patty Dykes; Renee Coston; Ricky Daniels; Armando Rodriguez; Bruce Gutierrez; Daniel Garcia; Humberto Uresti; Jennifer Beltran; Jesus Limon Jr; John Ramirez; Rosendo Garcia III; Sergio Cantu; Yvonne Hernandez; Charlie Haggerton III; Cindy Adami; Crystal King; Dan Stacks; Michelle Barton; Samuel Lopez III; Cathey Galbreath; Diane Weishuhn; James Gilbert Jr; Linda Bilbrey; Ricky Moore; Rebecca Petty; Rheatia Gandy; Stacie Holcomb; Wendy Simmons; Alisha Wickens; Kay Pigg; Rendy Drews; Rhonda Dietrich; Scott Gallman; Thomas Polansky; Cymantha Cato; Donna Porter; Jeff Parker; Mark Smith; Susie Slayden; David Stephens; Jeffery Vinklarek; Jonathan Rogers-C; Kendra Shows; Pete Rocha; Rene Soto
Cc: #Construction Engineers; Mcgrady, Justine; #Maintenance Contract Staff; #Lab Supervisors
Subject: SiteManager & EPRS unavailable this weekend for server migrations

 

 


Subject: SiteManager & EPRS unavailable this weekend for server migrations

 

The SiteManager application and EPRS website will be unavailable this weekend. These database servers are being migrated this weekend to the Austin Data Center (ADC) as part of the TxDOT server consolidation (SCON) project.

 

Starting Friday evening @ 6:00 pm through Sunday the 19th @ 6:00 pm (all times central) the following will be unavailable:


DSS (database only)

EPRS website

LIMS

SiteManager

·         Non Inspector

·         Terminal Servers

·         Citrix Servers

SiteManager Reporting

·         Custom Report Server

·         ADHOC Reporting

·         CMISD Website Reports

 

 

 

From: ServerConsolidation
Sent: Tuesday, July 14, 2015 11:58 AM

Subject: RE: Comms For SiteManger Move 7/17/15

 

 

The applications listed below reside on a servers scheduled for migration to the Austin Data Center (ADC).

 The migration will start on Friday, July 17, beginning at 6PM.  The servers will be unavailable while the migration takes place (usually overnight).  A separate communication will be sent to points-of-contact for testing/validation of the applications after the migration.

 

Start Date/Time

End Date/Time

Activity

7/17/15 – 6:00 PM

7/17/15 – 7:00 PM

Prevent Access to affected applications

7/17/15 – 7:00 PM

7/17/15 – 12:00 AM

Validation of and Cutover to new applications servers

7/17/15 – 7:00 PM

7/18/15 – 12:00 PM

Data loads and validations

7/18/15 – 12:00PM

7/19/15 – 12:00 AM

TxDOT and NTT application testing

7/19/15 – 12:00 AM

7/19/15 –   6:00 PM

Completion of any testing and/or mitigate any issues found

7/19/15 –   6:00 PM

 

All applications are in production

 

All times are best estimates.  Any of the activities can take more or less time. A status email will be sent periodically throughout the process to insure you are aware of the progress.  Justine will send an email to you and the others involved as soon as the applications are ready for testing.

 Note that there are no changes or updates to any application or its associated data.  The migrations are basically “copies” of the existing server contents.

In the event of inclement weather, the migration might be postponed.

 

Send any questions to ServerConsolidation@txdot.gov  and Justine.McGrady@nttdata.com  You will receive a reply within 24 hours.

 

Thanks,

 

The SCON Team

 

Affected Applications:

SiteManager, LIMS, EPRS, DSS (database only) and FHWA1391

Talk. Text. Crash.

Talk. Text. Crash.

 


______________________________________________________________________
Disclaimer: This email and any attachments are sent in strictest confidence
for the sole use of the addressee and may contain legally privileged,
confidential, and proprietary data. If you are not the intended recipient,
please advise the sender by replying promptly to this email and then delete
and destroy this email and any attachments without any further use, copying
or forwarding.

Friday, July 17, 2015

RE: SiteManager & EPRS unavailable this weekend for server migrations

This is a reminder of this weekend’s outage. Please share this with employees that are scheduled to work this weekend. This would include your CEI contract people. They rely on you for this information.

 

Thank you

 

From: CST_SITEMANAGER
Sent: Tuesday, July 14, 2015 12:25 PM
To: Tier 1 notifications; Cindy Hurta; Crystal Woodruff; Cullen Pfeiffer; Michael Underwood; Stewart DeWitt; Cliff Hallford; Debbie Paylor; Paul Norman; Saundra Collins; Sendy Bolin; Brad Buchanan; Darrell Caldwell; Joey Cordova; Kelli Navarrette; Kit Black; Laura Alwan; Mike Fowler; Ofelia Garbalena; Radina Turner; Roxanne Jennings; Shannon Glenn; Buddy Williams; Charlotte Aslin; Donna Barnes; Jason Dupree; Lance Simmons; Rickie Shields; Thomas Young; Donna Roberts; Barbara Davenport; Elizabeth Lukefahr; Loren Rice; Lori Wagner; Miguel Arellano; Steven Hay; Sylvia Bockholt; Tad Nichols-C; Tammy Hilbig; Tim Wilhelm; Tommy Blackmore; Tracy Cooper; Andrea Murry; Linda Korns; Michael Skiles; Patrick Ryan; Preston Cooper; Susan Will; Andy Berlan; Cassandra McKibben; Chris Cowen; Jennifer Trowbridge; PJ Vargas Jr; Sandy Perry; Shannon Aultman; Sheryl Petroski-C; Stephen Kasberg; Terry Paholek; Zyna Polansky; Carl Johnson; Eric Lykins; Paula King; Rocky Roberts; Tina Crelia; Tonya Shaw; Darwin Lankford; Gene Garcia; Shari Thomason; Alice Garcia; Cordy Diaz; David Chapa; Deborah Shults; Joseph Briones; Karla Moczygemba; Lester Lindley; MaryAlice Hernandez; Mitzie Gibson; Orlando Carrillo; Ruben Garcia; Sandy Harris-C; Steve Orchard; David Henke; Frank Mayfield; Jay Tarwater; Jesus Valdez; John Obr; Johnny Johnson Jr; Juan Ortega; Melissa Daniels; Noe Cabazos; Roxana Garcia; Scott Starkjohann; Carol Berry; Chris Briggs; David Morren; Debbie Burgess-C; Leann Kemp; Noraima Perez; 'Rhonda Schmid'; Robert Delaney; Sherry Perkins; Terry Bruce; Trena Brand; Valarie Ashmore; Aldo Madrid; Frank Guzman; Ken Barnett; Letty Delira; Lorena Soriano; Margarita Montes; Margie Cedillo; Maria Chavez; Susan Freres-C; Bruce Matusek; Fernando Hernandez; Alan Easterling; Allen Shelley-C; Annette Cuevas; 'Brad Tate'; Dora Soto; Glynis Rodriguez; Jackie Broussard; Kristie Woods; Richard Williammee Jr; 'Steve Bone'; Andrus Harris; Carolyn Fink; Emmanuel Isonguyo; HopMing Tang; Ilona O'Blenis; Lee Hamberry; Lovey Reynolds; Marian Jamandre; Oleta Dick; Tim Medrano; Todd Hannah; Amy Nieman; Blythe Jowers; Darral Bryant; Jeremy Dearing; Kami Wilbanks; Linda King; Doug Y'Barbo; George Wilson Jr; Missy Lowe; Phyllis Clark; Sam Hankla; Vivian Harrison; Cynthia Saldana; David Salazar; Nelda Martinez; Sergio Reyna; Claudia Kern; Gisel Carrasco; Greg Jones; Jana Buck; Jerry Peterson Jr; Michael Dawidczik; Richard Izzo; Richard Knowles; Robert Lee; Travis Patton; Keith Buckley; Kelly Jones; Timothy West; Chad Windham; David Alvarez; Donnie McNatt; Kathy Schlegel; KC Evans; Mike Stroope; James Hutchison III; Karen Jackson; Leisha Hopkins; Patty Dykes; Renee Coston; Ricky Daniels; Armando Rodriguez; Bruce Gutierrez; Daniel Garcia; Humberto Uresti; Jennifer Beltran; Jesus Limon Jr; John Ramirez; Rosendo Garcia III; Sergio Cantu; Yvonne Hernandez; Charlie Haggerton III; Cindy Adami; Crystal King; Dan Stacks; Michelle Barton; Samuel Lopez III; Cathey Galbreath; Diane Weishuhn; James Gilbert Jr; Linda Bilbrey; Ricky Moore; Rebecca Petty; Rheatia Gandy; Stacie Holcomb; Wendy Simmons; Alisha Wickens; Kay Pigg; Rendy Drews; Rhonda Dietrich; Scott Gallman; Thomas Polansky; Cymantha Cato; Donna Porter; Jeff Parker; Mark Smith; Susie Slayden; David Stephens; Jeffery Vinklarek; Jonathan Rogers-C; Kendra Shows; Pete Rocha; Rene Soto
Cc: #Construction Engineers; 'Mcgrady, Justine'; #Maintenance Contract Staff; #Lab Supervisors
Subject: SiteManager & EPRS unavailable this weekend for server migrations

 

 


Subject: SiteManager & EPRS unavailable this weekend for server migrations

 

The SiteManager application and EPRS website will be unavailable this weekend. These database servers are being migrated this weekend to the Austin Data Center (ADC) as part of the TxDOT server consolidation (SCON) project.

 

Starting Friday evening @ 6:00 pm through Sunday the 19th @ 6:00 pm (all times central) the following will be unavailable:


DSS (database only)

EPRS website

LIMS

SiteManager

·         Non Inspector

·         Terminal Servers

·         Citrix Servers

SiteManager Reporting

·         Custom Report Server

·         ADHOC Reporting

·         CMISD Website Reports

 

 

 

From: ServerConsolidation
Sent: Tuesday, July 14, 2015 11:58 AM

Subject: RE: Comms For SiteManger Move 7/17/15

 

 

The applications listed below reside on a servers scheduled for migration to the Austin Data Center (ADC).

 The migration will start on Friday, July 17, beginning at 6PM.  The servers will be unavailable while the migration takes place (usually overnight).  A separate communication will be sent to points-of-contact for testing/validation of the applications after the migration.

 

Start Date/Time

End Date/Time

Activity

7/17/15 – 6:00 PM

7/17/15 – 7:00 PM

Prevent Access to affected applications

7/17/15 – 7:00 PM

7/17/15 – 12:00 AM

Validation of and Cutover to new applications servers

7/17/15 – 7:00 PM

7/18/15 – 12:00 PM

Data loads and validations

7/18/15 – 12:00PM

7/19/15 – 12:00 AM

TxDOT and NTT application testing

7/19/15 – 12:00 AM

7/19/15 –   6:00 PM

Completion of any testing and/or mitigate any issues found

7/19/15 –   6:00 PM

 

All applications are in production

 

All times are best estimates.  Any of the activities can take more or less time. A status email will be sent periodically throughout the process to insure you are aware of the progress.  Justine will send an email to you and the others involved as soon as the applications are ready for testing.

 Note that there are no changes or updates to any application or its associated data.  The migrations are basically “copies” of the existing server contents.

In the event of inclement weather, the migration might be postponed.

 

Send any questions to ServerConsolidation@txdot.gov  and Justine.McGrady@nttdata.com  You will receive a reply within 24 hours.

 

Thanks,

 

The SCON Team

 

Affected Applications:

SiteManager, LIMS, EPRS, DSS (database only) and FHWA1391

Talk. Text. Crash.

Talk. Text. Crash.

Tuesday, July 14, 2015

SiteManager & EPRS unavailable this weekend for server migrations

 


Subject: SiteManager & EPRS unavailable this weekend for server migrations

 

The SiteManager application and EPRS website will be unavailable this weekend. These database servers are being migrated this weekend to the Austin Data Center (ADC) as part of the TxDOT server consolidation (SCON) project.

 

Starting Friday evening @ 6:00 pm through Sunday the 19th @ 6:00 pm (all times central) the following will be unavailable:


DSS (database only)

EPRS website

LIMS

SiteManager

·         Non Inspector

·         Terminal Servers

·         Citrix Servers

SiteManager Reporting

·         Custom Report Server

·         ADHOC Reporting

·         CMISD Website Reports

 

 

 

From: ServerConsolidation
Sent: Tuesday, July 14, 2015 11:58 AM

Subject: RE: Comms For SiteManger Move 7/17/15

 

 

The applications listed below reside on a servers scheduled for migration to the Austin Data Center (ADC).

 The migration will start on Friday, July 17, beginning at 6PM.  The servers will be unavailable while the migration takes place (usually overnight).  A separate communication will be sent to points-of-contact for testing/validation of the applications after the migration.

 

Start Date/Time

End Date/Time

Activity

7/17/15 – 6:00 PM

7/17/15 – 7:00 PM

Prevent Access to affected applications

7/17/15 – 7:00 PM

7/17/15 – 12:00 AM

Validation of and Cutover to new applications servers

7/17/15 – 7:00 PM

7/18/15 – 12:00 PM

Data loads and validations

7/18/15 – 12:00PM

7/19/15 – 12:00 AM

TxDOT and NTT application testing

7/19/15 – 12:00 AM

7/19/15 –   6:00 PM

Completion of any testing and/or mitigate any issues found

7/19/15 –   6:00 PM

 

All applications are in production

 

All times are best estimates.  Any of the activities can take more or less time. A status email will be sent periodically throughout the process to insure you are aware of the progress.  Justine will send an email to you and the others involved as soon as the applications are ready for testing.

 Note that there are no changes or updates to any application or its associated data.  The migrations are basically “copies” of the existing server contents.

In the event of inclement weather, the migration might be postponed.

 

Send any questions to ServerConsolidation@txdot.gov  and Justine.McGrady@nttdata.com  You will receive a reply within 24 hours.

 

Thanks,

 

The SCON Team

 

Affected Applications:

SiteManager, LIMS, EPRS, DSS (database only) and FHWA1391

Talk. Text. Crash.

Talk. Text. Crash.

Friday, June 5, 2015

Resolved: Sitemanager XiteReport Errror

Users may resume using the XiteReport to determine material testing deficiencies. Yesterday’s issue with the XiteReport should now be resolved.

 

IT updated your file server overnight. To verify that your server has been included with the update Navigate to your X:\SMGR\SM3x\msexceltemplates directory using windows explorer. When sorted by descending date, the latest file dates should be from the last week of May. If your directory does not fit this description please notify us at CST_SITEMANAGER@txdot.gov. Please include your file server’s UNC address. An example would be similar to “APPS(\\TXDOT4AVHQ48\DATA12\APPS\CH_X)(X:)”.

 

Thank you

 

 

 

From: Stewart DeWitt
Sent: Thursday, June 04, 2015 12:23 PM
Subject: Sitemanager XiteReport Errror

 

Greetings,

This morning I learned that IT distributed the wrong set of files to your directories this past Tuesday. In short, the set included among other things a known error with the XiteReport. Users will receive an error, pictured below, when attempting to request a material testing deficiency report using the XiteReport. The issue is related to the Excel ribbon (toolbar) and is known to crash Excel. We discovered this with our testing and corrected it, but unfortunately an earlier copy of the file was distributed.

 

I asked IT to schedule a new distribution, but as of right now I do not have a date/time. In the meantime, I suggest having your users use the Sampling Checklist report to track material testing compliance.

 

There may be other items that will pop-up as I have not taken a complete inventory of what is missing. So, forgive me for not sending you future message about each new error that may arise while we wait on the correct distribution set.

 

A follow-up message will be sent when the distribution is complete. I apologize for the inconvenience.

 

 

 

 

 

Thank you,

 

STEWART DEWITT | SENIOR SITEMANAGER SUCCOR™ | TxDOT | 512.416.2462 |stewart.dewitt@txdot.gov

 

Talk. Text. Crash.

Talk. Text. Crash.

Thursday, June 4, 2015

Sitemanager XiteReport Errror

Greetings,

This morning I learned that IT distributed the wrong set of files to your directories this past Tuesday. In short, the set included among other things a known error with the XiteReport. Users will receive an error, pictured below, when attempting to request a material testing deficiency report using the XiteReport. The issue is related to the Excel ribbon (toolbar) and is known to crash Excel. We discovered this with our testing and corrected it, but unfortunately an earlier copy of the file was distributed.

 

I asked IT to schedule a new distribution, but as of right now I do not have a date/time. In the meantime, I suggest having your users use the Sampling Checklist report to track material testing compliance.

 

There may be other items that will pop-up as I have not taken a complete inventory of what is missing. So, forgive me for not sending you future message about each new error that may arise while we wait on the correct distribution set.

 

A follow-up message will be sent when the distribution is complete. I apologize for the inconvenience.

 

 

 

 

Thank you,

 

STEWART DEWITT | SENIOR SITEMANAGER SUCCOR™ | TxDOT | 512.416.2462 |stewart.dewitt@txdot.gov

 

Talk. Text. Crash.

Talk. Text. Crash.

Tuesday, June 2, 2015

Tonight: Updated SiteManager Material Excel Test files

 

Dear SiteManager Material User,

 

The SiteManager Excel  test files mention previously with the May 27th email below are scheduled for distribution to your X:\APPS directories this evening Tuesday , June 2nd.

 

Benefits associated to these files are listed here.

                Bug fixes:

·         Outlook Excel viewer compatibility -  This issue prevented users from both viewing an Excel attachment in Outlook while simultaneously opening an Excel test file from SiteManager.

·         Enable sample authorization – Excel erroneously offered samples for authorization with only a single individual listed as tester, reviewer, and authorizer. This has been corrected.

·         Excel right click menu – Should Excel and the XiteReport close unexpectedly, the application will no longer strand the user without the use of the right click menu.

·         Close Error Message  - The message “Object is invalid or not set” error will no longer display when closing the XiteManager.

 

Enhancements:

·         No more ADDIN tab necessary- The XiteManager, XiteReport, and Assistant toolbar options have been incorporated into the newer Excel “Ribbon”. Users no longer have to navigate to the ADDIN tab to locate these options (however they can if they choose).

·         User search forms have been increased in width and height to make it slightly easier to search and selected records.

·         Excel Focus – Excel will take the focus whenever a test from SiteManager is requested. Previously when Excel was minimized it would remain minimized until the user selected the application from the task bar.

·         ADDIN - The XiteManager file has been changed to an AddIn file type. Now when requesting a SiteManager test only one excel file will be visible whereas, before two files udm.xls and the requested test file would open.

·         Tester Names – Tester drop downs now sort by tester name/tester id.

 

 

 

How will you recognize the files have been delivered Wednesday morning?

If the enhancements mentioned above are present  obviously this is a good sign that the updates were delivered, but alternatively you could navigate to the X:\SMGR\SM3x\msexceltemplates folder and check the file extensions and dates. File extensions should be .xlsm and the file dates should almost exclusively be from this year. If you learn that the directory did not update, please contact us at CST_SITEMANAGER@TXDOT.GOV and include the name of the directory if possible. An example would be similar to “APPS(\\TXDOT4AVHQ48\DATA12\APPS\CH_X)(X:)”.

 

 

From: Stewart DeWitt
Sent: Wednesday, May 27, 2015 11:55 AM
To: Subject: Updated SiteManager Material Excel Test files

 

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.

Talk. Text. Crash.

RE: Updated SiteManager Material Excel Test files

In terminal server we have no way to import the templates. Does this mean that we would have to type in all the information as the system stands now?

We have no ability to save local template copies to send to contractors.

 

Zyna Polansky – Geologist - Laboratory Supervisor

TxDOT - Bryan District Lab

979-778-9648 – office

zyna.polansky@txdot.gov

 

From: Stewart DeWitt
Sent: Wednesday, May 27, 2015 11:55 AM
To: #Maintenance Contract Staff; #Lab Supervisors; Tier 1 notifications; Cindy Hurta; Crystal Woodruff; Cullen Pfeiffer; Michael Underwood; Stewart DeWitt; Cliff Hallford; Debbie Paylor; Paul Norman; Saundra Collins; Sendy Bolin; Brad Buchanan; Darrell Caldwell; Joey Cordova; Kelli Navarrette; Kit Black; Laura Alwan; Mike Fowler; Ofelia Garbalena; Radina Turner; Roxanne Jennings; Shannon Glenn; Buddy Williams; Charlotte Aslin; Donna Barnes; Jason Dupree; Lance Simmons; Rickie Shields; Thomas Young; Donna Roberts; Barbara Davenport; Elizabeth Lukefahr; Loren Rice; Lori Wagner; Miguel Arellano; Steven Hay; Sylvia Bockholt; Tad Nichols-C; Tammy Hilbig; Tim Wilhelm; Tommy Blackmore; Tracy Cooper; Andrea Murry; Linda Korns; Michael Skiles; Patrick Ryan; Preston Cooper; Susan Will; Andy Berlan; Cassandra McKibben; Chris Cowen; Jennifer Trowbridge; PJ Vargas Jr; Sandy Perry; Shannon Aultman; Sheryl Petroski-C; Stephen Kasberg; Terry Paholek; Zyna Polansky; Carl Johnson; Eric Lykins; Paula King; Rocky Roberts; Tina Crelia; Tonya Shaw; Darwin Lankford; Gene Garcia; Shari Thomason; Alice Garcia; Cordy Diaz; David Chapa; Deborah Shults; Joseph Briones; Karla Moczygemba; Lester Lindley; MaryAlice Hernandez; Mitzie Gibson; Orlando Carrillo; Ruben Garcia; Sandy Harris-C; Steve Orchard; David Henke; Frank Mayfield; Jay Tarwater; Jesus Valdez; John Obr; Johnny Johnson Jr; Juan Ortega; Melissa Daniels; Noe Cabazos; Roxana Garcia; Scott Starkjohann; Carol Berry; Chris Briggs; David Morren; Debbie Burgess-C; Leann Kemp; Noraima Perez; Rhonda Schmid; Robert Delaney; Sherry Perkins; Terry Bruce; Trena Brand; Valarie Ashmore; Aldo Madrid; Frank Guzman; Ken Barnett; Letty Delira; Lorena Soriano; Margarita Montes; Margie Cedillo; Maria Chavez; Susan Freres-C; Bruce Matusek; Fernando Hernandez; Alan Easterling; Allen Shelley-C; Annette Cuevas; Brad Tate; Dora Soto; Glynis Rodriguez; Jackie Broussard; Kristie Woods; Richard Williammee Jr; Steve Bone-C; Andrus Harris; Carolyn Fink; Emmanuel Isonguyo; HopMing Tang; Ilona O'Blenis; Lee Hamberry; Lovey Reynolds; Marian Jamandre; Oleta Dick; Tim Medrano; Todd Hannah; Amy Nieman; Blythe Jowers; Darral Bryant; Jeremy Dearing; Kami Wilbanks; Linda King; Doug Y'Barbo; George Wilson Jr; Missy Lowe; Phyllis Clark; Sam Hankla; Vivian Harrison; Cynthia Saldana; David Salazar; Nelda Martinez; Sergio Reyna; Claudia Kern; Gisel Carrasco; Greg Jones; Jana Buck; Jerry Peterson Jr; Michael Dawidczik; Richard Izzo; Richard Knowles; Robert Lee; Travis Patton; Keith Buckley; Kelly Jones; Timothy West; Chad Windham; David Alvarez; Donnie McNatt; Kathy Schlegel; KC Evans; Mike Stroope; James Hutchison III; Karen Jackson; Leisha Hopkins; Patty Dykes; Renee Coston; Ricky Daniels; Armando Rodriguez; Bruce Gutierrez; Daniel Garcia; Jennifer Beltran; Jesus Limon Jr; John Ramirez; Rosendo Garcia III; Sergio Cantu; Yvonne Hernandez; Charlie Haggerton III; Cindy Adami; Crystal King; Dan Stacks; Michelle Barton; Samuel Lopez III; Cathey Galbreath; Diane Weishuhn; James Gilbert Jr; Linda Bilbrey; Ricky Moore; Rebecca Petty; Rheatia Gandy; Stacie Holcomb; Wendy Simmons; Alisha Wickens; Kay Pigg; Rendy Drews; Rhonda Dietrich; Scott Gallman; Thomas Polansky; Cymantha Cato; Donna Porter; Jeff Parker; Mark Smith; Susie Slayden; David Stephens; Jeffery Vinklarek; Jonathan Rogers-C; Kendra Shows; Pete Rocha; Rene Soto; Sherry Hutchinson
Cc: #Construction Engineers
Subject: Updated SiteManager Material Excel Test files

 

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.

Talk. Text. Crash.