Import, edit, and delete formats

Import file formats

For all file types other than Mainframe, you can import the file format via the + File Format button, located in the Files tab. This will import the file directly into the Continuous Compliance Engine.

1. From Home, navigate to the Settings page and click into the Data Formats section on the left, then click the Files tab at the top.

2. Click the + File Format button on the top-right, a window with the same name will appear.

3. Select a Format Type and click Next.

   

Formatting Examples are shown in the wizard, based on each format type.

4. Import a format by clicking Choose File. The name of the file will be the name of the file format.

5. Browse for the file from which the fields will be imported, then click Next.

   1. The contents of the imported file vary for delimited, fixed-width, copybook (Mainframe), XML, and JSON file types.

      

Removing a selected file

If you accidentally selected an incorrect file, simply click the x button to the right of the file name and repeat the selection steps above.

6. Optionally, for only the delimited or fixed-width formats, users will see a step to configure the number of header or footer records for the file. Click Next with or without setting the header or footer, as needed.

   

7. View the summary on the last step to confirm the changes.

8. Click Save at any point after importing the format.

Import Mainframe formats

For Mainframe data sets, you can import the file format via the + Mainframe Format button, located in the Mainframe tab. This will import the copybook directly into the Continuous Compliance Engine.

1. From Home, navigate to the Settings page and click into the Data Formats section on the left, then click the Mainframe tab at the top.

2. Click the + Mainframe Format button on the top-right, a window with the same name will appear.

   

3. The Format Type will be preselected with Copybook, click Next to continue.

   

Formatting Examples is shown in the wizard for copybook. Duplicate field names in copybook files are not supported.

4. Import a format by clicking Choose File.

5. Browse for the format file and click Next.

   

Removing a selected file

If you accidentally selected an incorrect file, simply click the :cancel: button to the right of the file name and repeat the selection steps above.

6. View the summary on the last step to confirm the changes.

7. Click Save at any point after importing the format.

Edit a file format

Selecting the hyperlinked Name of a format in the corresponding column will initiate the file formats edit screen.

The file inventory relies on the file format it represents. As a result, any changes to the file inventory affect all data files using that file format. Thus, altering the file inventory impacts all files conforming to that format across the application. This is applicable to all the file types Fixed-Width, Delimited, Mainframe, JSON & XML.

Delete a file format

Click the Delete icon under the Actions columns to the right of the corresponding format name in the list. The user will be prompted for confirmation.