To convert data, specify the format of the converted file and other parameters.
Convert the Source File to a Business Objects (CSV) file, which can then be opened in a text editor or imported into a spreadsheet or database application. If you are converting to a Business Objects (CSV), the name of the Destination File cannot match the name of the Source File. When Business Objects (CSV) is selected, the request adds the suffix “.csv” to the Destination File if a suffix is not specified.
When you convert to this file format, you can select the columns from each joined table that are to be included in the file. The rows in file are not grouped by table name. Instead, the rows are presented as a joined view with all selected columns listed as a single ‘table'. Thus, a parent row is repeated for each child row.
Select this value to convert the Source File to a Comma Separated Values (.csv) file, which can then be opened in a text editor or imported into a spreadsheet or database application. When Comma Separated Value (CSV) is selected, the request adds the suffix “.csv” to the Destination File if a suffix is not specified. If you are converting to a Comma Separated Value (CSV) file, the name of the Destination File cannot match the name of the Source File.
You can also create separate .csv files for each table or view.
The name of the Extract File or Archive File that contains the data to convert. You can convert an Archive File to any file format. Extract Files can be converted to any file format except Enterprise Content Management (CSV). If you enter an Extract File and select Enterprise Content Management (CSV) , an error is displayed, and you will not be able to save or run the Convert Request.
Enter the name of a Control File. This file is used to track the success or failure of processing for each row in the Source File. Control Files are given a .cf extension by default.
If you specify the name of a Control File that already exists, a dialog prompts you to confirm that you want to overwrite the file when you run the Convert Request. To disable this confirmation feature, you can change a setting in Personal Options.
Enter the name of the Destination File for the converted data. To save converted data to the original Source File, specify the path and name of the Source File, or leave blank.
A converted file does not include any object definitions present in the Extract File. Therefore, if the Destination File is also the Source Extract File, object definitions in the Source File are discarded. If you want to write the Extract File to removable media, specify the path to the desired device.
If you do not specify a path for file names, the request uses the drive and directory defined in Personal Options as the default Data Directory.
If you are converting an Extract or Archive File to a Business Objects (CSV) or Comma Separated Value (CSV), the request adds the suffix .csv if one is not specified. Additionally, if you are converting to a Business Objects (CSV), Comma Separated Value (CSV), Business Object (XML), XML or Enterprise Content Management (CSM), the name of the Destination File cannot match the name of the Source File.
Specify a Table Map to match tables in the Source File with destination tables or to exclude tables in the Source File from the request. You cannot save or process a Convert Request without a valid Table Map.
Within a Table Map, specify a Column Map for any pair of tables to:
Click from the Convert Request Editor to open the Table Map Editor. For details on how to create, edit, or merge Table Maps, see the Common Elements Manual.
Rows that cannot be processed are discarded. For example, in an insert process, a row is discarded if source data is not compatible with the data type of the destination column. Enter 0 or leave blank to impose no limit or enter a number from 1 to 99999999 to stop processing after the specified number of rows are discarded and all rows in the array processed. You can Restart or Retry a process that stops because the limit is reached.