Import and Export

The need arose to export queried data from an Oracle Forms application in to a CSV (Comma Separated Values) format.

A Basic Export/Import facility has been developed that will allow a user to query data in an application, and then export the data to a CSV file.  A User can manipulate the data and import the data back into the ITS system.

The export facility takes all the queried data and saves it in a user defined file name and location. This must be a CSV file.

A list of all programs that have Import and Export facilities.

The Import facility needs an user defined CSV file from an user defined destination.

As per setting of primary key on the form, a select will be done on the base table of this form.  If the record exists, the record will be queried and the UPDATABLE field will be over written with the value on the CSV file.

If the record does not exist as per primary key settings, a new record will be inserted.

1. Go to PACS-26 {Qualification Codes}
2. Query the data Block Description
   

3. Select Export. Determine the destination to where the file will be saved. Note that the Import facility is not available when records was queried.
   

4. The user can now view this data via MS Office. 
5. Note that the first record will always be a header, identifying the object id the data was exported from. ROW 1 COL A, B C, etc.    
6. Change existing data and/or add new record to the CSV file and save the changes.
   

1. Go to PACS-26 {Qualification Codes}
2. Right click on the canvas.  A popup menu will appear.  Import will be available but Export not.
3. Select Import. The following screen will appear where user must specify from where the CSV file must be select from. 
   

4. Select our CSV file and click on ‘Save’.  Existing records will be changed and new records will be inserted on the screen.
5. User can now commit, and if there are any form validation errors, user must correct them. See the NQF levels have changed.
   

• Procedures:
• None