<< Click to Display Table of Contents >> Navigation:  EDP > Reference Values > Creating a Reference Value File from Professional EDP

The Reference Value File (RVF) is created as an export from reference tables in EQuIS Professional so that it may be used in EDP Standalone since it is not linked to a specific EQuIS database.

 

 

Create Reference Value File

a.Launch EQuIS Professional.

b.Connect to the desired database and facility where the reference values are stored.

c.Open EDP.

d.The last format may automatically load. To use a different format, click the Format button in the Open section of the Home ribbon. The exported RVF will contain reference values specific to the format that is loaded at the time of export. (The images in this article are taken from the EQEDD format.)

e.Click on the Reference Values tab located in the lower-left corner to view the Reference Values tables
 

f.The RVF can be created using either the application backstage or a button on the Professional ribbon:

•Application Backstage – Select File to open the application backstage. Click the Save As option and Reference Values (*.rvf).

•Professional Ribbon – Select the Professional ribbon and click on Reference Values (*.rvf) from the Package section.

6.Enter the folder path and descriptive file name when prompted. EarthSoft recommends using the Company/Organization name, in addition to the date exported.

7.Click Save.

 

 

Filter and Export Selected Reference Values from Professional EDP

 

In some cases, users may wish to limit the output of reference values in an RVF. These instructions explain how to manually edit the *.rvf file before sending it to the data submitter. Depending on the RT_ table in question and how many records it contains, this may or may not be a tedious process. Alternatively, users can use a view of the RT_ table instead of the RT_ table directly. With this change in place, the created RVF will only include the columns choosen to be in the view.

1.Follow Steps 1 through 3 in the Create Reference Value File section above.

2.Load the desired format and compatible EDD to activate the Filter Column(s) tool; a blank EDD will suffice. Click on the Reference Values tab and select Filter Column(s).

3.Add appropriate values to the Filter Row so that the displayed records are limited to only those that are NOT to be included in the RVF. These records will be removed before saving the RVF. For example, filter RT_ANALYTE to display only records that have remark = "metal".

 

 

Highlight all resulting lines of the values that are to be excluded, and delete the rows.

 

 

4.Remove the filter to ensure that only the desired values are included in the export. Save the reference values as normal.