Data Conversion Tool's user guide and functionality.
Contents
1. 22 Error Reports 23 DCT TUTORIAL Sra 24 INSTALLING A UNINSTALLING DOT ere Sea tea 29 System Requirements e eee2222eemeeeaaae ne aaeemaneneaaeeaaaaeneeaeeemeneneaaemeaemeneeaeeeaameneaaeeemeaeneeemememeneeaeeememenemee 29 Installing DCT 222 222 n nnn n nnn nn nnn nnn nnn nnn nnn nnn nnn nnn cnn n ene 29 Uninstalling DCT 2 2 2222 22 nn nnn nnn nnn nn nnn nnn nnn nnn nner nnn nnn n nnn 34 DOT WORKFLOW et aa Sse 38 Data Conversion Tool Internal Architecture 0 0 00 00 000eeencneee nn neeeee nn eeeeenneeeenen 38 APPENDIX A ROAD LIFE CYCLE EVENTS 40 APPENDIX B BRIDGE LIFE CYCLE EVENTS emeemeemememmeanamanmeammenamamemnenmenmeaee APPENDIX C REMAINDER LIFE CYCLE EVENTS 0 0 200 Navigating the Data Conversion Tool When logging into the DCT the following screen will be displayed la bel eS Open Save SaveAs Close C Documents and Settings karenl My Document 1 Template Categories allows users to setup folders through Windows file system to help locate templates easily by their category Clicking a template categor2. 6 Data Tab 6 Diagram Tab 7 Conversion Tab nnn nas 7 Setting the DCT Screen Color 2 2 2 n n ne nn nnn nnn nner nnn nnn nnn nnn cen nnn cen nee n nee 8 Styles 8 USING THE DCT DATA CONVERSION TOOL 9 Opening and Closing DCT Project 2 2 2222 2 enn nnn n nner n nner n nnn n nee n nee n nce nneee nes 9 Creating a New Project 9 Saving a Project nnn 10 Opening an Existing Project 11 Closing the C
3. User Guide MDW Data Conversion Tool Data Conversion Tool DCT Overview The MDW Data Conversion Tool DCT is a user friendly tool which will allow users to move data from their existing database into MDW It will provide the user the ability to select which data they would like to move map the data to MDW and then provide feedback if the transfer of data was successfully moved or produce an error list report for items that need to be fixed before the upload of data to MDW will proceed Requirements e A stable or high speed internet connection Login to MDW with Asset Manager Access Connection and or password for the Data Destination if required Access administrator permissions on the computer to install the DCT If you need to install DCT follow Installing DCT Style Data Destination EH Data Providers Tasks Location_Ref_Type Classification Existing Road Cla Maintenance Class Mumber Lanes Special Designatior Speed_Limit Traffic_Status Leng 4 gt BLOCK Local 400 5 2 NSD 50 E eze i MSD 50 Fi 53 2 2 TO way m El BLOCK Local 6 as lt Table of Contents NAVIGATING THE DATA CONVERSION TOOL 5 DCT Work Area 22 2222 2n nnn n 6 File Tab
4. ASSM CONS ESTM REP MAINT REPLACE SUBCONS SUPRCONS CDR CDS CSS IAG LMC OTH OWP PWP RCN CMITED RCN CMPED RCS RH CMITED RH CMPED RIR RSB RSP SPI TJR TJS VCI WAP VVSO VVSR VVSS APPRV BNNLINSP BR INSP BRDGMSTR CNDSRVY EVL TRAFCNT TRAFCNTAC TRAFCNTES Year Assumption Installation Estimated Replacement Maintenance Year Replace Substructure Construction Superstructure Re Construction Complete Deck Replacement CDS Coating Structural Steel Install Approach Guiderail Latex Modified Concrete Overlay Other Overlay waterproof Pav Patch Waterproof Pave Reconstruction Committed Reconstruction Completed Rehabilitation Replacement Rehabilitation Committed Rehabilitation Completed Railing Improvement Replacement Rehabilitate Substructure Rehabilitate Superstructure SPI Transverse Exp Joint Seal Replacement Transverse Exp Joint Seal Replacement VCI Waterproof and Pave Widen Superstructure Only Wearing Surface Rehabilitation Widen Superstruture and Substructure Approvals Biennial Inspection Bridge Inspection Bridge Master Inspection Condition Survey Evaluation Traffic Count Actual Traffic Count Estimated Traffic Count AT DESCR LCECatCode LCECatDesc LCETypeCode LCEDesc Bridge INSP Inspection UNDWTR Underwater Inspection 42 Condition Inspection Deck Condition Survey Load capacity evaluation Routine Detailed Inspection Rehabilitation
5. Completed Rehabilitation Committed Rehabilitation Completed Road Inspection Traffic Count Actual Traffic Count Estimated Traffic Count Carry Over Cold in place recycling rural overlay Grind and Overlay Major Urban Rehab 90mm HCB 5 20 spot Proposed Road Construction Pulverizing and Resurfacing single lift Pulverizing and Resurfacing double lift Resurfacing single lift Resurfacing double lift LCEDesc Reconstruction 40 RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section REHAB REHAB REHAB REHAB REHAB REHAB REHAB REHAB REHAB REHAB REHAB REHAB REHAB REHAB REHAB Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation RECIMPR REHAB RM RMU ROLV RUPG RW SD SI SR UGO UOL WRSC WURB WUSC Recommended Improvement Rehabilitation or Reconstruction performed Major Resurfacing Rural Major Upgrade Rural Overlay Leveling Course Rural Upgrade Resurface and Widen Spot Drainage Spot Road Intersection Spot Road Urban Grind Overlay Urban Overlay incl mill along curb Widening Rural Salvage Base
6. Reconstruction Installation Estimated Replacement FL VC Vehicle CONS Construction PURCH DT FL VC Vehicle CONS Construction REPLACE FL VC Vehicle CONS Construction YBUILT FL VC Vehicle REHAB Rehabilitation RCONS Flshng Bcn Flashing Beacon CONS Construction CONS Flshng Bcn Flashing Beacon REHAB Rehabilitation RCONS GA Grass Area CONS Construction CONS GA Grass Area CONS Construction ESTM REP GA Grass Area REHAB Rehabilitation RCONS HY Hydrant CONS Construction CONS HY Hydrant CONS Construction ESTM REP HY Hydrant CONS Construction REPLACE HY Hydrant INSP Inspection FLOWTEST HY Hydrant REHAB Rehabilitation RCONS Informational amp InfoDirctn Directional Sign CONS Construction CONS Informational amp InfoDirctn Directional Sign REHAB Rehabilitation RCONS lO Inlet CONS Construction CONS lO Inlet CONS Construction ESTM REP lO Inlet CONS Construction REPLACE lO Inlet REHAB Rehabilitation RCONS LAG Lagoon CONS Construction CONS LAG Lagoon CONS Construction ESTM REP LAG Lagoon CONS Construction REPLACE LAG Lagoon REHAB Rehabilitation RCONS LN Waterline CONS Construction CONS LN Waterline CONS Construction ESTM REP LN Waterline CONS Construction REPLACE LN Waterline INSP Inspection INSP LN Waterline REHAB Rehabilitation RCONS Mdn Median CONS Construction CONS Mdn Median REHAB Rehabilitation RCONS MH Manhole Waste Water CONS Construction CONS MH Manhole Waste Water CONS Construction ESTM REP MH Manhole Wast
7. Replacement Analysis Reconstruction Recommended Improvement Rehabilitation or Reconstruction performed Year Assumption Installation Estimated Replacement Maintenance Year Replace Substructure Construction Superstructure Re Construction Reconstruction Committed Reconstruction Completed Rehabilitation Committed Rehabilitation Completed Approvals Biennial Inspection Bridge Master Inspection Condition Survey Culvert Inspection Evaluation Traffic Count Actual Traffic Count Estimated Traffic Count Underwater Inspection Reconstruction Recommended Improvement Rehabilitation or Reconstruction performed Installation Estimated Replacement Replace Reconstruction Year Assumption Installation Estimated Replacement Maintenance Year Replace Substructure Construction Superstructure Re Construction BR Bridge INVEST Investigation Cl BR Bridge INVEST Investigation DCS BR Bridge INVEST Investigation LCE BR Bridge INVEST Investigation RDI BR Bridge INVEST Investigation RRA BR Bridge REHAB Rehabilitation RCONS BR Bridge REHAB Rehabilitation RECIMPR BR Bridge REHAB Rehabilitation REHAB BR CUL Culvert CONS Construction ASSM BR CUL Culvert CONS Construction CONS BR CUL Culvert CONS Construction ESTM REP BR CUL Culvert CONS Construction MAINT BR CUL Culvert CONS Construction REPLACE BR CUL Culvert CONS Construction SUBCONS BR CUL Culvert CONS Construction SUPRCONS BR CUL Culvert IMPROVE Improvement
8. Tab The diagram provides the ability to hide show objects zoom add tasks and draw connectors these commands are necessary to map the data to MDW E File BE Diagram Bee ey Ses S25 EbuideTable E TE Fa f d Xd Align Objeds I Show Hide Zoom Fitto le Settings Genera Text get Tables Tables Window i ma T PE a i ea T T ea f Es K i Table Provides the ability to Show all tables Hide a Table and Arrange the Data Provider tables Data Destination Tables and Tasks associated to the tables Zoom Gives the ability to select the desired view of the mapping from 10 to 400 and to fit all mappings into 1 screen view Tasks Connects the data to the desired location in MDW Text changes can be made before the data moves to MDW e g Change all asset status to upper case only data with certain criteria can be selected to be moved and other general basic mapping tasks can be created Conversion Tab Contains commands for performing the conversion Bnew aL en Li NS Lle me Conversion Run Completes the conversion into MDW or provides an error report if the conversion fails Setting the DCT Screen Color Provides the ability to select the color you would like to work in within the Data Conversion Tool Styles Clicking on Style will provide the user the ability to change the color of DCT There are 4 Office 2007 colors e Black e Blue e Red Click Custom Scheme for more color se
9. Widening Urban Rehab Base Widening Urban Salvage Base 41 Appendix B Bridge Life Cycle Events eee SSC EE eee ees eee ee BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR H Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge Bridge CONS CONS CONS CONS CONS CONS CONS IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE IMPROVE INSP INSP INSP INSP INSP INSP INSP INSP INSP Construction Construction Construction Construction Construction Construction Construction Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Improvement Inspection Inspection Inspection Inspection Inspection Inspection Inspection Inspection Inspection
10. click Next i Data Conversion Tool InstallShield Wizard Program Maintenance Modify repair or remove the program O Modify Change which program Features are installed This option displays the Custom Selection dialog in which you can change the way Features are installed Repair installation errors in the program This option Fixes missing or corrupt files shortcuts and registry entries Remove Data Conversion Tool From your computer Dr ae Step 4 Click Remove The Data Conversion Tool will be removed i Data Conversion Tool InstallShield Wizard Remove the Program You have chosen to remove the program From your system Click Remove to remove Data Conversion Tool From your computer After removal this program will no longer be available For use TF you want to review or change any settings click Back Remove i Step 5 Click Finish 37 DCT Workflow The DCT process for data transfer is to connect the DCT to an input plug in which can be in Text Excel Relational etc and then the data structure will be displayed to the user Here the user will be able to create mapping tasks and then load the data in MDW using the MDW Web Services plug in T Hierarchical Data Source 0 Relational Data Source T Flat Data Source 0 Other Data Source DCT Process Diagram 1 g gO Data Migration MDW Tool Web Services MDW Data Conversion Tool Internal Architect
11. eld zarah Name zarah supe B dUniqueld D7098454 F5F7 4167 9237 691230954568 45 tatus Code gt ALT s ra E Uniqueld 6261 53E 1 466 4276 B694 460D0 8C66CB dF Attibubes gt lt Businesshroups gt Conditions Wen all export data in your selected application Continue Exporting Stop Exporting If the conversion completes successfully you will see the following message ASI Data Conversion Tool La 1 a Ly Data conversion to data destination succeeded 22 To ensure the Data has been converted correctly you will now need to login to MDW perform the search and verify the data is correct e g Search Display mer Search Results our search for Asset ID 85 returned the 2 records Click Refine Search to change your search criteria Type Asset Id Asset Name Status Location Railing System Hand Railing a563 Asset 63 Active On 5 From Ta 7 Barriers 8564 Asset 64 Active Error Reports Clicking the Run icon and you receive the following Message Box that your Data Conversion has failed ASI Data Conversion Tool xi a N 1 Data convert bo data destination Failed Once you click OK you will see an error report located at the bottom of Mapping Work Space Validation Error Message Asset ID is duplicated within the specified asset Type You will now need to fix the error the error message will explain the problem with the data to help resolve Doub
12. installed Data Conversion Tool Click Finish to exit the wizard LI Launch Data Conversion Tool 7 Enter the License Key information to activate the Data Conversion Tool If a serial key was not provided or was lost please contact ASI for a new key Please enter following information to activate the product 5 Seewired fale Activate A Data Conversion Tool icon will be added to the desk top for future use Double Click the icon to open the DCT 33 ih un AST OT Uninstalling DCT There are two ways to remove the Data Conversion Tool Application Please ensure the Data Conversion Tool program is closed prior to beginning the uninstall process 1 Remove the Data Conversion Tool Application from the Windows s Control Panel Step 1 Click Start gt Control Panel LS Add or Remove Programs Step 2 Select Data Conversion Tool from the installed program list B Add or Remove Programs ci Currently installed programs Change or Remove Programs Click here For support information Used occasionally Last Used On 6 3 2010 p 3 To change this program or remove it From your computer click Change or Remove Add Hew Programs fa Microsoft WET Framework 1 1 Size F7 Data Conversion Tool ao 11MB c if Microsoft NET Framework 2 0 Service Pack 2 Size 185 00MB Add Remove Windows Components o Set Program Access
13. B CONS CONS CONS REHAB CONS CONS CONS REHAB CONS CONS CONS Rehabilitation Construction Construction Construction Rehabilitation Construction Construction Construction Inspection Inspection Rehabilitation Construction Rehabilitation Construction Rehabilitation Construction Construction Construction Rehabilitation Construction Construction Construction Rehabilitation Construction Construction Construction RCONS CONS ESTM REP REPLACE RCONS CONS ESTM REP REPLACE CNDSRVY INSP RCONS CONS RCONS CONS RCONS CONS ESTM REP REPLACE RCONS CONS ESTM REP REPLACE RCONS CONS ESTM REP REPLACE Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace Condition Survey Inspection Reconstruction Installation Reconstruction Installation Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace 48 AssetT yoeCode DESCR LCECatCode LCECatDesc LCETypeCode LCEDesc Sewer Device SD_COMB Combined REHAB Rehabilitation RCONS Reconstruction SD_ST Sewer Device Storm CONS Construction CONS Installation SD_ST Sewer Device Storm CONS Construction ESTM REP Estimated Replacement SD_ST Sewer Device Storm CONS Construction REPLACE Replace SD_ST Sewer Device Storm REHA
14. B Rehabilitation RCONS Reconstruction SDK Sidewalk CONS Construction CONS Installation SDK Sidewalk CONS Construction ESTM REP Estimated Replacement SDK Sidewalk CONS Construction REPLACE Replace SDK Sidewalk REHAB Rehabilitation RCONS Reconstruction Shrb Shrub CONS Construction CONS Installation Shrb Shrub REHAB Rehabilitation RCONS Reconstruction SJ Sewer Junction CONS Construction CONS Installation SJ Sewer Junction CONS Construction ESTM REP Estimated Replacement SJ Sewer Junction CONS Construction REPLACE Replace SJ Sewer Junction REHAB Rehabilitation RCONS Reconstruction SL Sewerline Waste Water CONS Construction CONS Installation SL Sewerline Waste Water CONS Construction ESTM REP Estimated Replacement SL Sewerline Waste Water CONS Construction REPLACE Replace SL Sewerline Waste Water INSP Inspection INSP Inspection SL Sewerline Waste Water NEEDSTUDY Needs Study NEEDSTUDY Need Study SL Sewerline Waste Water REHAB Rehabilitation RCONS Reconstruction SL Sevverline Waste Water REHAB Rehabilitation REHAB Rehabilitation or Reconstr SL_COMB Sewerline Combined CONS Construction CONS Installation SL_COMB Sewerline Combined CONS Construction ESTM REP Estimated Replacement SL_COMB Sewerline Combined CONS Construction REPLACE Replace SL_COMB Sewerline Combined INSP Inspection INSP Inspection SL_COMB Sewerline Combined NEEDSTUDY Needs Study NEEDSTUDY Need Study SL COMB Sevverline Combined REHAB Rehabilitation RCO
15. DP Detention Pond INSP Inspection CNDSRVY Condition Survey DP Detention Pond INSP Inspection INSP Inspection DP Detention Pond REHAB Rehabilitation RCONS Reconstruction FL EQ Equipment CONS Construction CONS Installation FL EQ Equipment CONS Construction COVER BG Coverage Begin FL EQ Equipment CONS Construction LEASE ST Lease Start FL EQ Equipment CONS Construction LIC EXP Lic Expires LCEDesc FL EQ Equipment CONS Construction PURCH DT Purch Date FL EQ Equipment CONS Construction REPLACE Replace FL EQ Equipment CONS Construction YBUILT Year built FL EQ Equipment REHAB Rehabilitation RCONS Reconstruction FL VC Vehicle CONS Construction CONS Installation FL VC Vehicle CONS Construction COVER BG Coverage Begin FL VC Vehicle CONS Construction LEASE ST Lease Start FL VC Vehicle CONS Construction LIC EXP Lic Expires 45 Purch Date Replace Year built Reconstruction Installation Reconstruction Installation Estimated Replacement Reconstruction Installation Estimated Replacement Replace Flow Test Reconstruction Installation Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace Inspection Reconstruction Installation Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace
16. MDW 3 Password Will be the same as your MDW password 4 Area Will be the same as MDW When you click the drop down it will display the list of areas you have access too Asset Type Each Asset Type will need to have a separate data upload and project created Select from the drop down list the Asset Type you will be uploading Step 3 Once the information has been entered click OK Step 4 Select the Data Destination Tables you wish to be displayed to map your data and select Show to connect to MDW 14 Show Table d Data Destination vw Asset lattribute Business Group _ Condition z Surrounding Geometry Lifecycle Event Lifecycle Event Detail Condition Detail Block L Location Linear Reference Location Point Reference L Location Description El Location Coordinate Road Name 15 Mapping Your Data To begin mapping your data in MDW click on the Diagram Tab and you will see the mapping tasks and the mapping work space to begin your process to moving you data into MDW E E ka 4 File Data Conversion ere ge Ls eh ec 7J aj i 5 Align Objeds Saag Zoom Fitto Edit Settings Text Logicl General Table E Data Destination ie MDW amp ian GEOMETRY El Data Providers eb Excel Signalized Intersectionst La Asset ID Tasks IE Asset Type Asset Name Auxiliars Head Controller Type Cycle Length Cycle Vanes
17. MPROVE Improvement IAG Install Approach Guiderail Latex Modified Concrete BR TUN Tunnel IMPROVE Improvement LMC Overlay BR TUN Tunnel IMPROVE Improvement OTH Other BR TUN Tunnel IMPROVE Improvement OWP Overlay waterproof Pav BR TUN Tunnel IMPROVE Improvement PWP Patch Waterproof Pave BR TUN Tunnel IMPROVE Improvement RCS Rehabilitation Replacement Railin BR TUN Tunnel IMPROVE Improvement RIR adie menitetemet BR TUN Tunnel IMPROVE Improvement RSB Rehabilitate Substructure BR TUN Tunnel IMPROVE Improvement RSP Rehabilitate Superstructure BR TUN Tunnel IMPROVE Improvement SPI SPI Transverse Exp Joint Seal BR TUN Tunnel IMPROVE Improvement TJR Replacement Transverse Exp Joint Seal BR TUN Tunnel IMPROVE Improvement TJS Replacement BR TUN Tunnel IMPROVE Improvement VCI VCI BR TUN Tunnel IMPROVE Improvement WAP Waterproof and Pave BR TUN Tunnel IMPROVE Improvement WSO Widen Superstructure Only Wearing Surface BR TUN Tunnel IMPROVE Improvement WSR Rehabilitation Widen Superstruture and BR TUN Tunnel IMPROVE Improvement WSS Substructure BR TUN Tunnel INSP Inspection APPRV Approvals BR TUN Tunnel INSP Inspection BNNLINSP Biennial Inspection BR TUN Tunnel INSP Inspection BR INSP Bridge Inspection BR TUN Tunnel INSP Inspection BRDGMSTR Bridge Master Inspection BR TUN Tunnel INSP Inspection CNDSRVY Condition Survey BR TUN Tunnel INSP Inspection EVL Evaluation BR TUN Tunnel INSP Inspection UNDWTR Underwater I
18. NS Reconstruction SL COMB Sewerline Combined REHAB Rehabilitation REHAB Rehabilitation or Reconstr SL_FM Sanitary Forcemain CONS Construction CONS Installation SL_FM Sanitary Forcemain CONS Construction ESTM REP Estimated Replacement SL_FM Sanitary Forcemain CONS Construction REPLACE Replace SL_FM Sanitary Forcemain REHAB Rehabilitation RCONS Reconstruction SL_ST Sewerline Storm CONS Construction CONS Installation SL_ST Sewerline Storm CONS Construction ESTM REP Estimated Replacement SL_ST Sewerline Storm CONS Construction REPLACE Replace SL_ST Sewerline Storm INSP Inspection INSP Inspection SL_ST Sewerline Storm NEEDSTUDY Needs Study NEEDSTUDY Need Study SL_ST Sewerline Storm REHAB Rehabilitation RCONS Reconstruction SL_ST Sewerline Storm REHAB Rehabilitation REHAB Rehabilitation or Reconstr SMCULVERT Sewer Culvert CONS Construction CONS Installation SMCULVERT Sewer Culvert CONS Construction ESTM REP Estimated Replacement SMCULVERT Sewer Culvert CONS Construction REPLACE Replace SMCULVERT Sewer Culvert REHAB Rehabilitation RCONS Reconstruction SN Traffic Sign CONS Construction CONS Installation SN Traffic Sign CONS Construction ESTM REP Estimated Replacement SN Traffic Sign REHAB Rehabilitation RCONS Reconstruction AssetT ypeCode DESCR LCECatCode LCECatDesc LCETypeCode LCEDesc SS Sewer Service Waste CONS Construction CONNECT Service Connected 49 SS SS SS SS SS SS ST SS ST SS ST SS ST SS ST SS ST S
19. NS Reconstruction TRRAIL Subway Streetcar CONS Construction CONS Installation TRRAIL Subvvay Streetcar CONS Construction MFR YEAR Year of Manufacture TRRAIL Subvvay Streetcar CONS Construction REPLACE Replace TRRAIL Subvvay Streetcar REHAB Rehabilitation MOH Major Overhaul TRRAIL Subvvay Streetcar REHAB Rehabilitation RCONS Reconstruction TRSHELTER Bus Shelter CONS Construction CONS Installation TRSHELTER Bus Shelter CONS Construction REPLACE Replace TRSHELTER Bus Shelter REHAB Rehabilitation RCONS Reconstruction TrSigDsply Traffic Signal Display CONS Construction CONS Installation TrSigDsply Traffic Signal Display REHAB Rehabilitation RCONS Reconstruction TRIERM Bus Terminal CONS Construction CONS Installation TRIERM Bus Terminal CONS Construction REPLACE Replace TRTERM Bus Terminal REHAB Rehabilitation RCONS Reconstruction LCEDesc TS Traffic Signal CONS Construction CONS Installation 5I TS TS TSCB TSCB VehDetSys VehDetSys WA WA WA WasteRcptc WasteRcptc WC WC WC WC WD WD WD WD WJ WJ WJ WJ WL WL WL WL WS WS WS WS WS WS WV WV WV WV Traffic Signal Traffic Signal Traffic Signal Control Box Traffic Signal Control Box Vehicle Detection System Vehicle Detection System Warning Light Warning Light Warning Light Waste Receptacle Waste Receptacle Watercourse Structure Watercourse Structure Watercourse Structure Watercourse Structure Water Device Water Device W
20. Once the user has made their mapping selection they will move data into MDW using Web Services Validation of the data moved and error messages will be returned to the user via the User Interface 39 Appendix A Road Life Cycle Events Es RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD ATT RD Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section Road Section DESCR Road Section CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS IMPROVE IMPROVE IMPROVE IMPROVE INSP INSP INSP INSP REHAB REHAB REHAB REHAB REHAB REHAB REHAB REHAB REHAB Category REHAB Construction Construction Construction Construction Construction Construction Construction Construction Construction Construction Const
21. RCN_CMITED BR CUL Culvert IMPROVE Improvement RCN_CMPED BR CUL Culvert IMPROVE Improvement RH_CMITED BR CUL Culvert IMPROVE Improvement RH_CMPED BR CUL Culvert INSP Inspection APPRV BR CUL Culvert INSP Inspection BNNLINSP BR CUL Culvert INSP Inspection BRDGMSTR BR CUL Culvert INSP Inspection CNDSRVY BR CUL Culvert INSP Inspection CULV INSP BR CUL Culvert INSP Inspection EVL BR CUL Culvert INSP Inspection TRAFCNT BR CUL Culvert INSP Inspection TRAFCNTAC BR CUL Culvert INSP Inspection TRAFCNTES BR CUL Culvert INSP Inspection UNDWTR BR CUL Culvert REHAB Rehabilitation RCONS BR CUL Culvert REHAB Rehabilitation RECIMPR BR CUL Culvert REHAB Rehabilitation REHAB BR RET Retaining WLL Wall CONS Construction CONS BR RET Retaining WLL Wall CONS Construction ESTM REP BR RET Retaining WLL Wall CONS Construction REPLACE BR RET Retaining WLL Wall REHAB Rehabilitation RCONS BR TUN Tunnel CONS Construction ASSM BR TUN Tunnel CONS Construction CONS BR TUN Tunnel CONS Construction ESTM REP BR TUN Tunnel CONS Construction MAINT BR TUN Tunnel CONS Construction REPLACE BR TUN Tunnel CONS Construction SUBCONS ATC DESCR LCECatCode LCECatDesc LCETypeCode LCEDesc BR TUN Tunnel CONS Construction SUPRCONS BR TUN Tunnel IMPROVE Improvement CDR Complete Deck Replacement 43 BR TUN Tunnel IMPROVE Improvement CDS CDS BR TUN Tunnel IMPROVE Improvement CSS Coating Structural Steel BR TUN Tunnel I
22. T ST ST SUMP SUMP SUMP SURFVVATER SURFVVATER SURFVVATER SVVMF SVVMF SVVMF SVVMF COMB SVVMF COMB SVVMF COMB SVVMF ST SVVMF ST VVater Sevver Service VVaste Water Sewer Service Waste Water Sewer Service Waste Water Sewer Service Waste Water Sewer Service Waste Water Sewer Service Storm Sewer Service Storm Sewer Service Storm Sewer Service Storm Sewer Service Storm Sewer Service Storm Street Light Street Light Street Light Sump Sump Sump Surface Water Surface Water Surface Water Storm Water Management Facility Waste Water Storm Water Management Facility Waste Water Storm Water Management Facility Waste Water Storm Water Management Facility Combined Storm Water Management Facility Combined Storm Water Management Facility Combined Storm Water Management Facility Storm Storm Water Management Facility Storm CONS CONS CONS REHAB REHAB CONS CONS CONS CONS REHAB REHAB CONS CONS REHAB CONS CONS REHAB CONS CONS REHAB CONS CONS REHAB CONS CONS REHAB CONS CONS Construction Construction Construction Rehabilitation Rehabilitation Construction Construction Construction Construction Rehabilitation Rehabilitation Construction Construction Rehabilitation Construction Construction Rehabilitation Construction Construction Rehabilitation Construction C
23. and Defaults Step 3 Click the Remove button Step 4 Select Yes to begin uninstalling Add or Remove Programs 2 j Are yau sure vou want to remove Data Conversion Tool From your computer Step 5 The Data Conversion Tool will be removed Data Conversion Tool Please wait while Windows configures Data Conversion Tool Gathering required information SSRRRRRRRREERRRRERRRREREEEEREEE Cancel Step 6 The Data Conversion Tool is removed and no longer appears in the Add or Remove Programs Dialogue box Er Add or Remove Programs Currently installed programs C Show updates pala a Microsoft NET Framework 1 1 Size 35 11MB Programs Click here for support information lead sere ds Ta remove this program From your computer click Remove T Add New is Microsoft NET Framework 2 0 Service Pack z 195 00MB Programs m Add Remove Windows Components o Set Program Access and Defaults 2 Remove the Data Conversion Tool Application from Data Conversion Tool CD Step 1 Run setup exe Step 2 Click Next on Welcome screen i Data Conversion Tool InstallShield Wizard Welcome to the InstallShield Wizard for Data Conversion Tool The InstallShield Ri Wizard will allow you bo modify repair or remove Data Conversion Tool To continue click Hext PE cans J 36 Step 3 Select Remove option and
24. ask certeses gats 18 MAD DING ic ti 15 19 21 Navisat acte ee neue eaana eae 5 IN OF eo cim neteges ie Ei 18 N t CUA Let enmasantt deia eesi s 18 Operations perisai anent 17 18 19 Dietes Ge atacat eta ea ere 18 DOL OE e tota rr Amen irae tere Mary en ert 33 34 DEOJC CU editar 5 6 9 10 11 14 PU OVIGCIS estat cana el 12 Recent Files ee ee a 5 Show Table uu ccc ceccescccesscessceesseenes 16 DOULCES ces A 34 SD ectsiicamttetteumelsdcomteetdesmii 17 SU VICS repra E 8 OAS EO ES REN ROR Ne EPI EE eR Tel 3S Template Categories o o ee 5 Templates its Ra 5 34 Text LAS Kode toes ee dost ans aes 17 To Lower Case ccccccceecceseccsscessceesscenes 17 To UNDG CISen 17 TUO e E AE 22 Unique d ncia demes ee 19 Work Afea mecioieattmecnmta tetes 6 12 13 WOK SPACO Get EE 15 16 21 LOO Mie R CEE 7 53
25. ater Device Water Device Water Junction Water Junction Water Junction Water Junction Water Well Water Well Water Well Water Well Water Service Water Service Water Service Water Service Water Service Water Service Water Valve Water Valve Water Valve Water Valve CONS REHAB CONS REHAB CONS REHAB CONS CONS REHAB CONS REHAB CONS CONS CONS REHAB CONS CONS CONS REHAB CONS CONS CONS REHAB CONS CONS CONS REHAB CONS CONS CONS CONS REHAB REHAB CONS CONS CONS REHAB Construction Rehabilitation Construction Rehabilitation Construction Rehabilitation Construction Construction Rehabilitation Construction Rehabilitation Construction Construction Construction Rehabilitation Construction Construction Construction Rehabilitation Construction Construction Construction Rehabilitation Construction Construction Construction Rehabilitation Construction Construction Construction Construction Rehabilitation Rehabilitation Construction Construction Construction Rehabilitation ESTM REP RCONS CONS RCONS CONS RCONS CONS ESTM REP RCONS CONS RCONS CONS ESTM REP REPLACE RCONS CONS ESTM REP REPLACE RCONS CONS ESTM REP REPLACE RCONS CONS ESTM REP REPLACE RCONS ACTIVE CONS ESTM REP REPLACE RCONS REPAIR CONS ESTM REP REPLACE RCONS Estimated Replacement Reconstruction Installation Reconstruction Installation Reconstruction Installation Estimated Repla
26. ay be required Navigate and Run setup exe from either the provided CD DVD or URL O DISK1 Fie Edit View Favorites Tools Help sek leg wi po Search gt Folders EER Address Wi InstallSet 1 0 DISK1 aaa eA CI DotNetFramework o File and Folder Tasks amp B autorun inf un ustallatian 1 0 doc cl Make a new Folder e 7 setup exe a Publish this Folder to the web Other Places ES 1 0 My Documents i My Computer a My Network Places Details 29 1 Ifthe Net Framework 2 0 is not installed on the computer you will be prompted to install it at this point Please follow the on screen instructions to install Net Framework 2 0 When prompted select Run the software dotnetfx exe dotnetix Module Security Warning Do you want to run this software Mame dotnetlx exe Publisher Microsoft Corporation More options F Dont Run While Files From the Internet can be useful this File type can potentially harm vour computer Only run software From publishers you trust What s the risk 2 If required reboot your computer The InstallShield Wizard will continue the install upon restart Data Conversion Tool InstallShield Wizard Preparing to Install Data Conversion Tool Setup is preparing the InstallShield Wizard which will guide you through the program setup process Please wait Decompressing Data Conversion Tool msi Cancel 3 Click NEXT on the Welcome to InstallShiel
27. bined CONS Construction CONS Installation CB COMB Catchbasin Combined REHAB Rehabilitation RCONS Reconstruction CB ST Catchbasin Storm CONS Construction CONS Installation CB ST Catchbasin Storm CONS Construction ESTM REP Estimated Replacement CB ST Catchbasin Storm CONS Construction REPLACE Replace CB ST Catchbasin Storm REHAB Rehabilitation RCONS Reconstruction CH Water Chamber CONS Construction CONS Installation CH Water Chamber CONS Construction ESTM REP Estimated Replacement CH Water Chamber CONS Construction REPLACE Replace CH Water Chamber REHAB Rehabilitation RCONS Reconstruction CONTRO Controller CONS Construction CONS Installation CONTRO Controller CONS Construction ESTM REP Estimated Replacement CONTRO Controller REHAB Rehabilitation RCONS Reconstruction CPROT Cathodic Protection CONS Construction CONS Installation CPROT Cathodic Protection CONS Construction ESTM REP Estimated Replacement CPROT Cathodic Protection REHAB Rehabilitation RCONS Reconstruction CRB Curb CONS Construction CONS Installation CRB Curb CONS Construction ESTM REP Estimated Replacement CRB Curb CONS Construction REPLACE Replace CRB Curb REHAB Rehabilitation RCONS Reconstruction Crsswlk Crosswalk CONS Construction CONS Installation Crsswlk Crosswalk REHAB Rehabilitation RCONS Reconstruction DP Detention Pond CONS Construction CONS Installation DP Detention Pond CONS Construction ESTM REP Estimated Replacement DP Detention Pond CONS Construction REPLACE Replace
28. by Actryation Flashing Advance Green 1 Mapping Work Space Provides the ability to link the Data Provider and Data Destination using tasks You will see Open Data Provider tables Data Destination tables and the mapping tasks associated in linking these together 2 Panel View Displays the open Data Destination tables Data Provider tables and Tasks in a panel view 3 Diagram Size Currently the diagram is set 100 this can be changes from 10 400 depending on how many tables need to be viewed 4 Pointer Location Displays screen size and mouse pointer location 16 Tables Actions Provides ways for you to manipulate your view of tables to make it easier to see your diagram and map your data You are able to select multiple Data Provider Tables and multiple Data Destination tables as required Show Table a Show Click provides a text box displaying all hidden tables Show Table Data Destination Attribute Business Group _ Condition Surrounding Geometry Lifecycle Event Lifecycle Event Detail _ Condition Detail Block Location Linear Reference Location Point Reference Location Description Location Coordinate Road Name Data Provider To display a hidden table on the Mapping Work Space select the table in the text box and click Show The table now appears on the Mapping Work Space Hide a Single Table Select a Table and Click ide Table and the
29. cement Reconstruction Installation Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace Reconstruction Service Activation Installation Estimated Replacement Replace Reconstruction Repair Maint Installation Estimated Replacement Replace Reconstruction 52 Index Access Database uueeii 13 NN ee eM ee a et at 18 AT CHIVCCII Css eta site al 33 Arrange Objects eeeeeuu ee 16 C OLOF etat teca tt de i tetetai tica ota 8 Concatenate estimen dedica 17 COS CAG ae titol ae 19 Conversion 2 5 7 8 9 20 21 27 28 29 30 31 32 33 CONV 6 Mle ee taller 20 GES UMA NOM tecles ee tonsteman 28 Destination oo o o e 6 7 14 15 16 DIAG AM ie tem mci Ne 7 15 16 17 33 EE QUAL TO iii a 18 Equal To or Less Than 18 SO Gee an EP MS aT Een en Rn EN 2d DAE OF ECO tt Ree nae ee a Se en nS Pe ne Saran ie 21 EE XC A E A E E A EA 6 12 13 33 34 Format DAlC i icitdeeitmmtetetidil cas 17 Generate Globally Unique Identifier 19 Greater Thanea 18 Hide Ta DI ci tieta ee 16 DOR ee tmteg temes sumen 19 34 TASCAM AION ee eco tetes 10 28 lats Ue aci Le EEES SERRES 27 Less IA Nati 18 Otto netes etatealil 33 Logical T
30. d Wizard for Data Conversion Tool 30 4 TA Data Conversion Tool Installshield Wizard Welcome to the InstallShield Wizard for Data Conversion Tool The InstallShield Ry Wizard will install Data Conversion Tool on your computer To continue click Next WARMING This program is protected by copyright law and international treaties Cancel Enter the Users Name and Organization Click NEXT i Data Conversion Tool InstallShield Wizard Customer Information Please enter your information User Name Organization EE l InstallShield TE 31 5 Click Install to start the Data Conversion Tool Installation i Data Conversion Tool InstallShield Wizard Ready to Install the Program The wizard is ready to begin installation Click Install to begin the installation TF you wank to review or change any oF your installation settings click Back Click Cancel to exit the wizard InstallShield The Status of the Installation i Data Conversion Tool InstallShield Wizard Installing Data Conversion Tool The program Features you selected are being installed Please wait while the InstallShield Wizard installs Data Conversion Tool This ma take several minutes Status Installshield Cancel 32 6 Click Finish to complete installation i Data Conversion Tool InstallShield Wizard InstallShield Wizard Completed B 7 The InstallShield Wizard has successfully
31. e Water CONS Construction REPLACE MH Manhole Waste Water REHAB Rehabilitation RCONS MH COMB Manhole Combined CONS Construction CONS MH COMB Manhole Combined CONS Construction ESTM REP MH COMB Manhole Combined CONS Construction REPLACE MH COMB Manhole Combined REHAB Rehabilitation RCONS LCEDesc Sanitary Forcemain MH FM Manhole CONS Construction CONS Sanitary Forcemain MH FM Manhole CONS Construction ESTM REP Sanitary Forcemain MH FM Manhole CONS Construction REPLACE Sanitary Forcemain MH FM Manhole REHAB Rehabilitation RCONS MH ST Manhole Storm CONS Construction CONS MH ST Manhole Storm CONS Construction ESTM REP MH ST Manhole Storm CONS Construction REPLACE Replace 46 Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Replace Reconstruction Installation Estimated Replacement Reconstruction Installation Estimated Replacement Reconstruction Installation Reconstruction Installation Reconstruction Installation Reconstruction Installation Reconstruction Installation Reconstruction Installation Estimated Replacement Replace Condition Survey MH_ST Manhole Storm REHAB Rehabilitation RCONS MT Water Meter CONS Construction CONS MT Wat
32. ed together and To tice Case inserted in one location in MDW Converts a value to lower case Splits a value into two values Conjunction To Lower Case Changes all text in the column to Lower Case before importing it to MDW The source will be from the Data Source Information and linked Value it will then be all changed to an lower case and then updated to MDW The result will be mapped to MDW Data Schema R E XL Split Split a colomn using an identifing spliter to 2 locations in MDW Split Settings Split By Position 81 Split By Characteris Split Characteris Remove Delimiting Character s Logical Task Operations Not Equal To Will compare value 1 and Value 2 and will load the value that do now equals each other 19 Equal To or Less Than Will compare value 1 and Value 2 and will load the lesser of the two data values and the value that equals each other Or Value 1 or Value 2 could be loaded depend on validity of the data that exists in the value Equal To Two data sources will be checked to see if they are equal and if they are they will be loaded to MDW Not All information that does not contain the enter value will not be added to MDW Equal To or Greater Than Will compare value 1 and Value 2 and will load the values that are equal or greater then the other Less Than Will compare value 1 and Value 2 and will load the lesser of the two data values And Both data sourc
33. er Meter CONS Construction ESTM REP MT Water Meter CONS Construction REPLACE MT Water Meter REHAB Rehabilitation RCONS OC Watercourse CONS Construction CONS OC Watercourse CONS Construction ESTM REP OC Watercourse CONS Construction REPLACE OC Watercourse REHAB Rehabilitation RCONS Sewer Structure Waste OF Water CONS Construction CONS Sewer Structure Waste OF Water CONS Construction ESTM REP Sewer Structure Waste OF Water CONS Construction REPLACE Sewer Structure Waste OF Water REHAB Rehabilitation RCONS Sewer Structure OF COMB Combined CONS Construction CONS Sewer Structure OF COMB Combined CONS Construction ESTM REP Sewer Structure OF COMB Combined CONS Construction REPLACE Sewer Structure OF COMB Combined REHAB Rehabilitation RCONS OF_ST Sewer Structure Storm CONS Construction CONS OF ST Sewer Structure Storm CONS Construction ESTM REP OF ST Sewer Structure Storm CONS Construction REPLACE OF_ST Sewer Structure Storm REHAB Rehabilitation RCONS OUT Outfall CONS Construction CONS OUT Outfall CONS Construction ESTM REP OUT Outfall REHAB Rehabilitation RCONS PA Paved Area CONS Construction CONS PA Paved Area CONS Construction ESTM REP PA Paved Area REHAB Rehabilitation RCONS PdstrnSgnl Pedestrian Signal CONS Construction CONS PdstrnSgnl Pedestrian Signal REHAB Rehabilitation RCONS PedXngLght Pedestrian Crossing Light CONS Construction CONS PedXngLght Pedestrian Crossing Light REHAB Rehabilita
34. es will be added to the MDW data The will be connected Greater Than Will compare value 1 and Value 2 and will load the greater of the two data values General Task Operations Not Equal To Performs a logical NOT ona single value Equal To Or Less Than Determines whether the first value is less than or equal to the second value Or Performs a logical OR on two values Equal To Determines whether two values are equal Not Performs a logical NOT ona single value Equal To Or Greater Than Determines whether the first value is greater than or equal to the second value Less Than Determines whether the first value is less than the second value And Performs a logical AND on two values Greater Than Determines whether the first value is greater than the second value 20 l Constant Provides the ability to insert the same value into a column in MDW eg ACTV for Active Assets Generate Globally Unique Identifier Every Asset requires a Unique Identifier this will ensure information imported as a primary key This will need to exist 1f the Data is mapped for these schemas in MDW Road Names Life Cycle Details Geometry Attribute Asset Surrounding Life Cycle Event and Block Mapping Creates a one to one mapping task from the Data Provider to MDW This can also be achieve by just click on the Data Provider and the Data Destination Consta
35. h the following screen AS Data Conversion Tool 4 2 Do you mant to save the changes you made to the Filer 11 e Click Yes so your changes will be included e Click No if the changes you made should not be captured e Click Cancel if you would like to continue working with this project and would not like to close it at this time Opening Data Providers amp Data Destinations Currently the application will open Excel multi tabular spreadsheets and Access Databases To see more Data Providers that will be added in the future click HF 7 to view this list Each table in Access or each Worksheet in the Excel will be displayed as a table in DCT with the same name Opening a Data Provider The Data Provider in the DCT is where the data is currently stored Ensure the data has been cleaned up and is ready for the migration process before connecting it to the DCT Currently the DCT application is able to open Access Databases and Multi Tabular Excel Workbooks Excel EE Step 1 Click on ExcEl icon Step 2 Click the File Folder and find the location of the Excel Workbook Excel Excel File Path File Has Headers Step 3 If the Excel Document has a title row Select File Has Headers These will then be displayed on the DCT Work Area This row will also be ignored during the conversion process Step 4 Click OK to open the Excel Data Provider Step 5 Select the Sheet in the Excel Da
36. le Click the error to locate the error in the data You will now need to resolve the before completing the Conversion 23 DCT Tutorial To help in your data load here is a tutorial that will provide step by step instruction on performing a Data Conversion to MDW with an Excel Data Source Step 1 Step 2 Step 3 Step 4 Step 5 Step 6 Step 7 Nh ab Double Click the DCT Icon e ETI to launch the Data Conversion Tool On the File Tab Click On the Data Tab Click to open the connection information Locate the Data Provider File Select File has Headers if required Excel File Path Desktop TEST RD Data xls C Documents and Settings karen Desktop File Has Headers Click OK Select the Data Provider worksheet the information is found in 24 Show Table E l IME EES llSheetit Step Click on Step 9 Enter the information all fields are required to make your connection to MDW Web Service Url User Name Password Area Asset Type e Web Services URL Please enter the path to your MDW Web Service e User Name Will be your email address and it would be the same as the one you use to access MDW e Password Will be the same as your MDW password 25 Step 10 Step 11 e Area Will be the same as MDW When you click the drop down it will display the list of areas you have access too e Asset Type Each Asset Type will need to have a sepa
37. lections office2007 Black Office2007 Office2007 Red Office2007 Blue EE EHOEREE 72 More Colors Click More Colors to select a color from a color pallet ox EZE Using the DCT Data Conversion Tool To begin using each area of the application we will now explain in full detail each tab and the steps required to complete the task to ensure your conversion is successful Opening and Closing DCT Project Users will be able to create a new project open an existing project save a project and close the current project Creating a New Project Every data migration using the Data Conversion Tool will require a new project To create a new Project Click i Saving a Project Saving a New Project will allow you to begin the mapping process save the project and then close the project This will allow you to continue the mapping process make changes to the mapping and update the mappings when required i Clicking 78Y will automatically save your project to the default location that was setup during installation Most Default location will be C Program Files ASNDCT xxxxx adct Using Save As Step 1 To select or change the location of where the project should be saved to click 23 amp 45 Gavein L DCT a 3 i gt E 3 451 DCT ASIL OCT DataDbestinations Pb vy Mu Recent Qjen ca Documents en US C Templates 3 F Intersections adct Desktop My Documents gs My Co
38. mputer w sl Mu Network Save as type ADET Files adct w Step 2 Select the file location for your project Step 3 Enter the project name in the File Name text box Step 4 Click the save button and the project will be save to the selected location All project will be stored with a adct file extension 10 Opening an Existing Project Step 1 Step 2 Step 3 Note Note Click EEES Locate and select your xxxx adet file My Recent Documents B Desktop My Documents ga hy Computer My Network DCT TESTING LL Clients Mow Clients My eBooks Amy Music Aimy Pictures My Received Files My Shapes Me Videos Report For Meil CI SQL Server Management Studio Express visual Studio 2005 Visual Studio 2008 ls Intersection adet FA My Sharing Folders Fie name o Omen Files of type Click Open and the selected xxxx adct file will open to continue the conversion process When opening an existing project if any changes have been made to the source data the data provider diagram will be automatically updated When opening an exiting project if any changes have been made to the MDW data the data destination diagram will be automatically updated Closing the Current Project ri Click and if the project was saved or no changes were made to the project from when it was opened the project will close If the project was changed you will presented wit
39. nspection BR TUN Tunnel INVEST Investigation Cl Condition Inspection BR TUN Tunnel INVEST Investigation DCS Deck Condition Survey BR TUN Tunnel INVEST Investigation LCE Load capacity evaluation BR TUN Tunnel INVEST Investigation RDI Routine Detailed Inspection Rehabilitation Replacement BR TUN Tunnel INVEST Investigation RRA Analysis BR TUN Tunnel REHAB Rehabilitation RCONS Reconstruction BR TUN Tunnel REHAB Rehabilitation RECIMPR Recommended Improvement Rehabilitation or BR TUN Tunnel REHAB Rehabilitation REHAB Reconstruction performed Appendix C Remainder Life Cycle Events LCEDesc BcyclStnd Bicycle Stand CONS Construction CONS Installation BcyclStnd Bicycle Stand REHAB Rehabilitation RCONS Reconstruction BFPRE Backflow Preventor CONS Construction CONS Installation BFPRE Backflow Preventor CONS Construction ESTM REP Estimated Replacement BFPRE Backflow Preventor CONS Construction REPLACE Replace 44 BFPRE Backflow Preventor REHAB Rehabilitation RCONS Reconstruction Bldg Building CONS Construction CONS Installation Bldg Building REHAB Rehabilitation RCONS Reconstruction Bnch Bench CONS Construction CONS Installation Bnch Bench REHAB Rehabilitation RCONS Reconstruction Brm Berm CONS Construction CONS Installation Brm Berm REHAB Rehabilitation RCONS Reconstruction Catchbasin Waste CB Water CONS Construction CONS Installation Catchbasin Waste CB Water REHAB Rehabilitation RCONS Reconstruction CB COMB Catchbasin Com
40. nt Specifies a constant or static value Generate Globally Unique Identifier Generates a globally unique identifier GUID Mapping Maps a column in a source table to a column in a destination table or to a task Things to Remember When Using DCT 1 Connection to Web Services must be established 2 Required Information a Asset ID b Asset Description c Status of the Asset to setup the asset as active ACTV should be entered as a constant 3 When entering Life Cycle Events you will need to define the category of the Life Cycle Event a For Roads see Appendix A Road Life Cycle Events b For Bridges see Appendix B Bridge Life Cycle Events c For Remainder Asser Types see 4 All Unique Identifier will require a Appendix C Remainder Life Cycle Events erate Glob Ily Uniqu dentifie J task to be created for it 21 Conversion to MDW Municipal Data Works Once all mapping has been completed and you are ready to perform your Data Conversion Running the Conversion on Go to the Conversion Tab and click Run to run the conversion A Data Export Table will appear If you are satisfied with the summary in the table select Continue If you need to edit an item select stop exporting Display Export Data Following data is going to be exported ES E sport Assets Data Total Hows 2 El Assets El Assets B lt Uniqueld DAA S056 65 76 4E 34 6 C28 000628F DE 556 El
41. on INSP Inspection TR Treatment Plant REHAB Rehabilitation RCONS Reconstruction TRACKAGE Trackage CONS Construction CONS Installation TRACKAGE Trackage CONS Construction REPLACE Replace TRACKAGE Trackage REHAB Rehabilitation RCONS Reconstruction TrafSigCab Traffic Signal Cabinet CONS Construction CONS Installation TrafSigCab Traffic Signal Cabinet REHAB Rehabilitation RCONS Reconstruction TRBUS Transit Vehicle CONS Construction CONS Installation TRBUS Transit Vehicle CONS Construction MFR YEAR Year of Manufacture TRBUS Transit Vehicle CONS Construction PREPARE Prepare TRBUS Transit Vehicle CONS Construction PURCHASE Purchase TRBUS Transit Vehicle CONS Construction REPLACE Replace TRBUS Transit Vehicle REHAB Rehabilitation MOH Major Overhaul TRBUS Transit Vehicle REHAB Rehabilitation RCONS Reconstruction TRBUS Transit Vehicle REHAB Rehabilitation REFURBISH Refurbish TREE Tree CONS Construction CONS Installation TREE Tree REHAB Rehabilitation RCONS Reconstruction TRGARG Garage CONS Construction CONS Installation TRGARG Garage CONS Construction REPLACE Replace TRGARG Garage REHAB Rehabilitation RCONS Reconstruction TRGARG Garage REHAB Rehabilitation REHAB Rehabilitation or Reconstr TRPARKING Commuter Parking Lot CONS Construction CONS Installation TRPARKING Commuter Parking Lot CONS Construction REPLACE Replace TRPARKING Commuter Parking Lot CONS Construction YBUILT Year built TRPARKING Commuter Parking Lot REHAB Rehabilitation RCO
42. onstruction Rehabilitation Construction Construction Rehabilitation Construction Construction CONS ESTM REP REPLACE RCONS REPAIR CONNECT CONS ESTM REP REPLACE RCONS REPAIR CONS ESTM REP RCONS CONS ESTM REP RCONS CONS ESTM REP RCONS CONS ESTM REP RCONS CONS ESTM REP RCONS CONS ESTM REP Installation Estimated Replacement Replace Reconstruction Repair Maint Service Connected Installation Estimated Replacement Replace Reconstruction Repair Maint Installation Estimated Replacement Reconstruction Installation Estimated Replacement Reconstruction Installation Estimated Replacement Reconstruction Installation Estimated Replacement Reconstruction Installation Estimated Replacement Reconstruction Installation Estimated Replacement 50 AssetT yoeCode DESCR LCECatCode LCECatDesc LCETypeCode LCEDesc Storm Water Management Facility SWMF_ST Storm REHAB Rehabilitation RCONS Reconstruction TI Traffic Island CONS Construction CONS Installation TI Traffic Island CONS Construction ESTM REP Estimated Replacement TI Traffic Island REHAB Rehabilitation RCONS Reconstruction TR Treatment Plant CONS Construction CONS Installation TR Treatment Plant CONS Construction ESTM REP Estimated Replacement TR Treatment Plant CONS Construction REPLACE Replace TR Treatment Plant INSP Inspection CNDSRVY Condition Survey TR Treatment Plant INSP Inspecti
43. rate data upload and project created Select from the drop down list the Asset Type you will be uploading Click OK Select the Data Destination Tables you want to appear on the Mapping Area and click Show Show Table CM Cata Destination Asset Attribute Business Group Condition Surrounding Geometry Lifecycle Event Lifecycle Event Detail _ Condition Detail Block Location Linear Reference Location Point Reference Location Description ll Location Coordinate Road Name 26 Step 12 Click on Asset Id on the Data Provider table Draw a line directly to Asset ID on the Data Destination table to automatically create the mapping Continue this until all Data has been mapped to the MDW Tables 1 To remove a mapping right DiagramExample click on the mapping and select remove Data Destination Data Providers Tasks Location Ref Tvpe Classification Existing Road Cla Maintenance Class Number_Lanes Special Designatior Speed Limit Traffic_Status Leng 2 626 ow 53 2 ay 858 6 E BLOCK Local 400 NSD 50 BLOCK Local BLOCK Local 300 Step 13 Right click on the Blue Data Provider Box and Select Show Data Your Data will be displayed 21 Step 14 On the Conversion Tab Click to run the conversion Step 15 Select Continue Exporting on the Display Export Data text box if data is correct See E l 7 ASI Data Conve
44. rsion Tool File Data Eee Conversion Data Destination Data Providers Tasks Test Road Data ASI Data Conversion Tool x a Road Section ID x E Asset Status J Data convert to data destination successfully Asset Mame Boundary Road Asset function GIS ID Road Section Length Em Roadside Environment Number of Lanes Surface Type Plattorm Width rn Curb Type Odd L ell frit Asset GIS ID Road Section Roadside Mumber of Surface T Platform Curb Type Function Length Em Environment Lanes pee ag Width im Odd Local I 77552 0 5 5 2 H E 5 6 ME hd Es us 04 E 373 Step 16 Click OK if your conversion has successfully processed If it has failed see the Error Report and walk through resolving error Step 17 Login to MDW and view Data to ensure conversion was successfully processed Search Display Refine Search Search Results our search for Asset ID 85 returned the 2 records Click Refine Search to change your search criteria Type Asset Id Asset Mame Location Railing System Hand Railing 563 Asset 63 n 5 From Ta 7 Barriers 8564 Asset 64 28 Installing amp Uninstalling DCT System Requirements 1 Windows 2000 Server Windows XP or Windows Server 2003 2 Net Framework version 2 0 installed 3 WSE 2 0 sp2 4 Connection to the Internet Installing DCT Before installing DCT please ensure all work is saved and close any open programs A computer restart m
45. ruction Construction Construction Construction Construction Construction Construction Construction Construction Construction Construction Construction Construction Construction Improvement Improvement Improvement Improvement Inspection Inspection Inspection Inspection Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation LCECatDesc Rehabilitation ASSM BS CONS DHF DHF SS DHF SST DST ESTM REP MAINT REC REPLACE RNS ROREC RREC RSS SRR SS SST STUP UMU UREC WRRB WRRC WURC RCN_CMITED RCN CMPED RH_CMITED RH CMPED RD INSP TRAFCNT TRAFCNTAC TRAFCNTES CO CRRO GRUO MURH NC PR1 PR2 R1 R2 LCETypeCode RCONS Year Assumption Base and Surface Installation Double High Float Double High Float Slurry Seal Double High Float Single Surface Treatment Double Surface Treatment Estimated Replacement Maintenance Year Reconstruction Nominal Storm Sewers Rural Replace Reconstruction Nominal Storm Sewers Urban Reconstruct Rural Reconstruction Reconstruction including installation of Storm Sewers Storm Sewer Installation and Road Reinstatement Slurry Seal Single Surface Treatment Surface Treatment on unpaved surfaces Urban Major Upgrade Urban Reconstruction Widening Rural Rehab Base Widening Rural Reconstruction Widening Urban Reconstruction Reconstruction Committed Reconstruction
46. ta Provider where the data is located and click Show to open the Excel Data Provider 12 Access Database Step 1 Step 2 Step 3 Step 4 Click on SF icon Click the File Folder and find the location of the Access Database Access Access Database Path If the Excel Document has a title row select File Has Headers The headers will then be displayed on the DCT Work Area This row will also be ignored during the conversion process Click OK to open the Excel Data Provider 13 Opening a Data Destination The DCT application is currently connecting to the MDW Municipal Data Works Database for users to upload Municipal Assets information into MDW like roads data facilities data sewer amp water data equipment data and many other asset types To create the connection to MDW you will need to have an existing account to MDW and Asset Manager security access to your area upload information to MDW To open your connection to MDW Step 1 Click MDBW icon Step 2 Now you will need to enter your data Web Service Url User Mame Password Area DCT Testing Asset Type Signalized Intersection Wr Shrub Sidewalk Sidewalk Approaches Sidewalk Curbs Sidewalk and Medians Sign Signalized Intersection Signs 1 Web Services URL Please enter the path to your MDW Web Service 2 User Name Will be your email address and it would be the same as the one you use to access
47. table will be hidden from the Diagram Work Space Hide Multiple Tables Hide Click provides a text box displaying all tables on the Mapping Work Space 17 To hide a table on the Mapping Work Space select the table in the text box and click Hide The table is now removed from the Mapping Work Space TER Es Sele a Cata Destination Asset Business Group Data Provider Sheetl Align Objects EB 1 1 5 e e e e e e e Click Ba des blade to arrange the Data Provider Tables in vertical line then the Tasks in a vertical line and then Data Destination Tables in a vertical line Zooming within the Diagram Zooming Clicking 92m will allow you to expand you diagram work space to 400 or reduce your workspace to 10 Fit to Window p ED Fit to Clicking 1000 will shrink the Diagram Work Space so you will see all mappings Diagram Operations Text Task Operations 18 Format Date Provides the ability to format the Data from current way to the accepted requirement for MDW Date Format String vyw MM dd To Upper Case Changes all text in the column to Upper Case before importing it to MDW The source will be from the Data Source Information and linked Value it will then be all changed to an upper case and then updated to MDW Format Date Formats a date To Upper Case Converts a value to upper case Concatenate Combines two values Concatenate Allow to columns to be join
48. tion RCONS PI Pole CONS Construction CONS LCEDesc PI Pole REHAB Rehabilitation RCONS PintArea Planted Area CONS Construction CONS PintArea Planted Area REHAB Rehabilitation RCONS PrkgAr Parking Area CONS Construction CONS PrkgAr Parking Area REHAB Rehabilitation RCONS Pumpstation Waste PS Water CONS Construction CONS Pumpstation Waste PS Water CONS Construction ESTM REP Pumpstation Waste PS Water CONS Construction REPLACE Pumpstation Waste PS Water INSP Inspection CNDSRVY PS Pumpstation Waste INSP Inspection INSP Inspection 47 PS PS COMB PS COMB PS COMB PS COMB PS_ST PS Sl PS SI PS SI PS ST PS ST RecArea RecArea Rndbt Rndbt RS RS RS RS SD SD SD SD SD COMB SD COMB SD COMB Water Pumpstation Waste Water Pumpstation Combined Pumpstation Combined Pumpstation Combined Pumpstation Combined Pumpstation Storm Pumpstation Storm Pumpstation Storm Pumpstation Storm Pumpstation Storm Pumpstation Storm Recreation Area Recreation Area Roundabout Traffic Circle Roundabout Traffic Circle Water Reservoir Water Reservoir Water Reservoir Water Reservoir Sewer Device Waste Water Sewer Device Waste Water Sewer Device Waste Water Sewer Device Waste Water Sewer Device Combined Sewer Device Combined Sewer Device Combined REHAB CONS CONS CONS REHAB CONS CONS CONS INSP INSP REHAB CONS REHAB CONS REHA
49. ure The migration process may be saved and will be repeatable to provide a means for future asset updates pe Transformation Extraction MDWSystem Pugin MDWSystem Pugin Plug In MDW Data Source Other System Plug In Common Data Import Validation and Exception Interface Windows Forms Graphical User i Interface GUI Data Conversion Tool Engine Common Data Provider Interface Settings Data Store _ Relational Data Provider Plug In Hierarchical Data Provider Plug In Flat Data Provider Plug In Other Data Provider Plug In oe CE C Relatonal Data Source Hierarchical Data Source Other Data Source 1 Data will be imported from a variety of Data Sources These will include d SQL Server 38 b Oracle c Excel d Text e XML f Top Speed g Access Plug ins will be created for each type of Data Source we will be pulling data from A user interface will be created for each type which will allow the user to locate the type of plug in where the data 1s located and which tables or columns will be used The Data format will be changed in XML As the data needs to be changed over it will perform this change in this step before the user will start working with it within the DCT The User interface will give the user the ability to map the data to where they want it in MDW Templates will be created for mappings which could be used on an ongoing basis for any other database structure
50. urrent Project I Opening Data Providers amp Data Destinations 2 2 0 2222 2 nnn nene nena ee 12 Opening a Data Provider 12 Opening a Data Destination 14 Mapping Your Data 22 2222 n nnn nnn nnn nn nnn nnn nnn nnn nnn nnn cnn nnn nnn n nes 16 Tables Actions n 2 2 2 a nn nn nnn nn nnn nnn nnn nnn nnn nnn nnn nnn nnn a ee ee nena 17 Zooming within the Diagram 18 Diagram Operations 18 Things to Remember When Using DCT 21 Conversion to MDW Municipal Data Works 22 22 2222 nn nnn nnn a ee nena 22 Running the Conversion
51. y will display all templates associated to the selected template category 2 Recent Files displays latest projects opened or used by the DCT application The list is arranged in order by most recent to least recent used project files Double Clicking on the recent file will open the selected project 3 Templates belonging to the selected category will be displayed here If no category is selected i e when the application first opens this section will not be displayed Template Displays the Name of the selected template This area does not display if no templates are selected DCT Work Area File Tab Contains commands for creating opening closing and saving a projects Data Diagram Conversion FHN Save As Close New Creates new data conversion project New Open Save Open Opens existing data conversion project e g roads adet Save Newly created and existing project changes can be saved Save As Saving a project to a new location or saving the project under a new name Close Closes the current project Data Tab User will make the connection to the Data Provider and Data Destination for the project Diagram Conversion MDW Access Excel 1 si More v a a ee Access Excel Data Source or More Provides the ability to locate and create a connection to the data MDW Data Destination Creates a secured connection to the selected Area MDW Database for Data Load Diagram
Download Pdf Manuals
Related Search