While InfoAsset Planner may be designed to import Standard Exchange PACP data, other non-standard databases may also be imported.
To import non-standard databases as survey imports, follow the same initial steps as a Standard Exchange import.
- Create a new CCTV dataset, give it an ID and description, choose the import from standard database option, and select the non-standard database(s) with the ellipsis
You may select more than one non-standard database so long as all the databases have the exact same schema and structure. All databases in this import will have the same table and field mapping. .
- Alternatively, you may also select the WinCan option if the selected database(s) are in proprietary WinCan format. WinCan databases can often be recognized by having table names of S_T, SI_T, O_T, etc. After selecting the WinCan databases(s), simply clicking Next will run a customized script and import all the information into InfoAsset Planner's standardized Inspections/Conditions table.
Innovyze is always open to more collaboration with other CCTV software companies.
- If the non-standard databases are not WinCan, after selecting the database(s), you must click Next and manually perform the table and field mapping.
Tables must be selected to match the inspection and conditions tables expected by InfoAsset Planner. Inspections relate to the individual surveys performed while Conditions relate to the observations and defects found during an individual survey. The screenshot above shows the six required fields for each survey inspection. Whatever table selected within the non-standard database to be imported to InfoAsset Planner's Inspections table must have these six fields. These fields help to not only differentiate inspections and remove duplicates, but also assign inspections to GIS pipes. See the Innovyze Knowledge Base on more special fields to pay attention to while working in InfoAsset Planner.
Whatever values are found in the field mapped as the Direction field will be shown in the left panel. You can then use the arrow buttons to organize which values indicate an upstream inspections vs. which fields indicate a downstream one.
- Inspection and Conditions tables are perhaps the most important of the four tables, but you can import tabular information to Media_Inspections and Media_Conditions tables as well. These tables link Survey Import media such as CCTV picture and videos to the respective inspection or condition. These tables look for the unique Inspection or Condition ID which should match the Inspection/Condition tables, the media location on the network, and the media file name. You must have a table within the database which can map to these InfoAsset Planner tables appropriately.
- Once the field mapping is complete, it is good practice to save the custom mapping as a .csv file using the toolbar
- Click Import to add the Survey Import data. The non-standard CCTV data has now been 'standardized' by InfoAsset Planner. All survey imports of the same type should all have the same dataset of tables and fields.