Exporting and Importing RTs

<< Click to Display Table of Contents >>

Navigation:  Professional > Tables and Forms > Reference Value (RT) Tables >

Exporting and Importing RTs

The refvals.xsd EDP format is useful for importing reference values into an EQuIS Database.


Export Reference Values into *.xls


To export a set of reference values into an *.xls that you can later import using refvals.xsd, complete the following.


1.Open EQuIS Professional.

2.Open Reports.

3.Select the Reference Values Report.

4.Select the Status Flag(s) you would like.

5.Run the report.

6.The report will be saved into your my EQuIS Work Folder for your database as an Excel file.


Import Reference Values


To import a set of reference values using refvals.xsd, complete the following.


1.Open Professional EDP.

2.Open the refvals.xsd format file.

3.Open your saved *.xls (or *.xml) file containing the reference values.

4.Fix any errors. (note the STATUS_FLAG, E_BATCH, and DISPLAY_ORDER columns should have been removed previously).

5.Commit your data to the database.


An alternative way to export reference values is explained in the rest of this article.


Export Reference Values into *.rvf


Complete the following to export a set of reference values into an *.rvf through EQuIS Professional EDP.


1.Open EQuIS Professional EDP.

2.Click on Format and open the desired Format file.

3.Click on EDD and open the corresponding Data File.

4.Click on the Professional Tab at the top.

5.Click on Reference Values (*.rvf) in the Package Group.

6.Navigate to the desired save location.

7.Name your file.

8.Select Save.

9.Close Professional EDP.