Steps to find out what is in the Corridor tables, cobol files and the Unique Record Identifiers are:
1. Click the Start button, select Programs, select FundWare, select Corridor, and select Data Dictionary. (or find the Corridor folder if installed elsewhere)
2. Doubleclick on MViewer2.exe.
3. Go to File, Open and Select the module you are inquiring about.
4. Select Detail Data Model.
5. If you are unsure what each field represents in the Detail Data Model you can just click it for a definition.
6. The Red arrows indicate the fields linked between tables.
7. Table Definitions will show which cobol files are connected with a Corridor Table definition.
Steps to use Liant Relativity to link your Division Files for Access use.
1. Insure you have division 95 loaded into FundWare.
2. Click Start,Programs,Liant,Relativity,DBA
3. Select the Existing radio button and select a group to view.(i.e. AP70 ) Click OK
4. Login username is DBA, there is no password.
5. Click Edit, Connections
6. Select the Global Add icon (Third button from the left).
7. Enter the following information in the prompted boxes:
a. Match Table Name: 95*.*
b. Match Path Name: 95*.*
c. Table Name: Replace: 95
d. Table Name: with: <<Enter your division number>>
e. Path Name: Replace: 95
f. Path Name: with: <<Enter your division number>>
8. Click Add Connections
9. You will see “Relativity Global Add Results”. Insure there are no
lines in red in this file.
10.Close this screen
11. Close Edit Connections screen and save changes.
Steps use tables in Access. There will be variations depending on your version of Access.
1. Open MS Access.
2. The Microsoft Access dialog box comes up. Select open and click OK.
3. The Open dialog box opens. Select the Fundware\data folder. In the Files of type drop down box select ODBC Databases () (last one in the list).
4. The Select Data Source dialog box comes up. Click the tab that says Machine Data Source.
5. Select the Module youwant to link (i.e. AP 70).
6. The Login screen comes up. Type dba for the Login and leave the Password blank.
7. You will see all of the tables associated with the module selected.
8. Click on the Tables you would like to link. Hold the shift key down to select more than 1 table or select all. The D## is the division number.
9. A Select Unique Record Identifier dialog box may come up. You will need to select the unique identifier for each of the fields. For example, an Obligation or Vendor. It generally works fine if clicking OK and accepting the tables as they come up.
Note: You may get an error message that D##_Vnd_Itm_Inv is not found. Click okay to bypass this. The associated cobol file no longer exists in FundWare.
10. Under Objects, if you click on Tables the green globes to the right mean they are ODBC tables.
11. You can double click the green globes to see what is in each table.
The use of Access itself after this point is up to the client, as we are unable to support Access features as part of the FundWare Product.
In addition to opening the tables you may find query features within Access useful.