Import

A network and its equipment can be completely modeled in CYME 5.02. It is also possible to import the network(s) and equipment information from another application into a CYME database by using the ‘Import’ command.

The Database > Import command displays the Import Data section of the CYME Database Utilities Wizard with which you can import data into an existing database or into a new one that you will create in the process. You may also use the Import Data button of the Database toolbar (see 2.5.10) or click on the “Import” item in the Databases Tab (see 2.3.1) of the Explorer Bar.

The databases will be imported into a supported CYME 5.02 database type from the following supported data sources and formats. For each option, the wizard guides you through the steps of selecting the source and the target databases.

The following sections describe the import formats supported in CYME.

Note that the application will indicate in a report the errors encountered in the process.

This report is automatically displayed at the bottom of the CYME application window once the process has ended. The type of error is briefly described, along with the file name of where the error was encountered.

6.6.1 ASCII Files

This is the most widely used import format. It allows you to import information from another application, a GIS for example, into a CYME database.

Note: CYME Import is backward compatible, i.e. any old import format is still supported. You don’t have to modify your data converter if you still want to use the same format.

When the source are ASCII files, you also have the options to import the Equipment, Network, Load, Maps data, etc. separately, which allows you to maintain seasonal load information (summer/winter, for example). Additional details about the import files syntax and structure with a description for each field of each element that can be imported, as well as the possible values for these fields are found in the CYME Import/Export Manual.

For other database types, you can still import equipment by type and networks, but the

CYME 5.02 – Reference Manual

You can select the one or several files to import in your database. It is possible to import a file containing equipment, network(s), loads, maps, reliability, capacitor status or meter demands, or any combination of these files.

You also have to indicate the database into which you want to import the information contained in the import files.

From the dialog box, select the appropriate database from the To combo.

Note: By default, CYME will select the active database in the combo box.

As for any import format, CYME allows erasing the information contained in the database when importing by selecting Clear options.

Note: The ‘Maps’ import file does not contain the map itself. It is a text file containing the full paths of all background map files (‘.dxf’ files) and the coordinates necessary for positioning the map on the network.

Refer to the CYME Import-Export manual for more information about importing files..Refer to the CYME Import-Export manual for more information about importing files.

Note: The import process does not delete or change your existing ASCII files (the data is imported into a new / separate database).

6.6.2 XML Files

If that option is selected, you will have to indicate the name and location of the XML (or SXST) file in the Import Database data from file(s) dialog box. Multiple selections are supported.

CYME 5.02 – Reference Manual

6.6.3 Previous Version of CYMDIST (prior to 4.1)

From the Import Data dialog box, select “CYMDIST Database (Previous Version)”. Click Next to display the Import Database data from file(s) dialog box.

Indicate the equipment and the network directories containing the equipment and network database from a version of CYMDIST prior to 4.1. Then, select the database into which you want to import the data. The Clear in Destination Database options allows to delete the tables related to the option(s) selected and replace them with the information that that is being imported.

Note: CYME does not allow multiple sections to have the same Id, even if they are located in different networks.

Click Next to start the import process.

6.6.4 CYME Database

Select the “CYME Database” option in the Import Data dialog box to display the Import Database dialog box. The only information to give are the database from which information is to be extracted and the database in which the information has to be written. Use the ‘From’ combo box and the ‘To’ combo box respectively.

The databases created by version 4.1 of CYMDIST or later are of the MDB format, CYME will create a backup copy of the original file, upgrade this copy to CYME 5.02 and then proceed with the process. In the case of an SQL or an Oracle file, the process will halt requesting the user to upgrade the file to 5.02. To do so, go to the Databases Tab of the Explorer Bar (see 2.3.1), right click on the database name and select Connect. The software will present the user with the dialog box from which the upgrade can be made. Once done, return to the Import Database dialog box to proceed with the import.

CYME 5.02 – Reference Manual

6.6.5 Custom File(s)

This feature uses a custom-made DLL file that lists the necessary files for the import process, as well as their type (extension) and their content.

The ‘.dll’ files containing the converter and the descriptions of the required files need to be installed in the same folder as the CYME program. These DLL files will be detected automatically by CYME and displayed in the ‘Custom File(s)’ combo box.

First select the Custom File(s) option in the Import Data dialog box. Then select the appropriate import name the drop down list, and click Next. Enter the different file names required by this custom import option, click Next. The converter contained in the ‘.dll’ file will then do the conversion.