Abstract: Further precautions users should observe concerning this product.
Full Disclosure: Additional notes on usage of ITSM Data Management Tool (DMT), as used in ARS7x/ITSM7y/CMDB2.z - Handling of individual sheets relies on an Excel function to find indefinite limit of user-entered data (colloquially, lower-right corner). Most individual sheets require a 'status' field as the far-right column: an integer '1' is required for entry to be regarded as 'Enabled'. Functionality has mis-behaved on my destkop if this is text rather than integer-function to find 'lower-right' corner allowed individual rows to be duplicated or deleted non-compliant with user input - 'Location' spreadsheet requires user data inputs those specifically identified in workbook directions. Any company to be mentioned on sheet 5 SIT:SiteCompany Association, must also be listed in 04:Sit:SiteGroup AND 03: CTM:Region for region- and site-group to be considered valid for that site:company relationship. - Holiday Dates: ITSM-target form expects date as mm/dd/yy only-no four-digit year, and all months/dates must have TWO digits. Excel often truncates the leading zeros for month and day; import of the resulting *csv could leave six-digit dates which will validate in staging form-but not promote to underlying target (potentially filling arerror.log with 'data error'-type entires!) Again-user beware!! Don W. McClure, P.E. Data Administrator & System Engineer University of North Texas Computing & IT Center dwmac_at_unt.edu 940.565.3287 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
