Tuesday, June 2, 2015

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.