OrgPro can import the latest USEF electronic results format but to get the most out of it you should set up mappings of the USEF section codes to the sections that your organization recognizes. Once you have this set up you can import the USEF electronic format very easily. You can also enter in the USEF numbers for your members and horses. If you have USEF numbers entered they will be mapped to your organization numbers and the members and horses will be recognized and points will be assigned appropriately. Members and horses that do not have USEF numbers entered will be have to be resolved using the Update Show Points function.
To set up your section code mappings select Map USEF Section Codes from the Data menu, the following dialog is displayed...
It is just a matter of setting the appropriate section from your organization for each USEF section code. Above a straight forward direct match for Regular Working Hunter is being specified.
The other important thing you can have in place is the USEF numbers of the members and the horses. These are mapped to the membership and recording numbers of your organization and allow points to be directly assigned when the USEF electronic results are imported. If you don't have USEF numbers for all your members and horses the Update Show Points feature can be used to assign the points but it will make your job a little easier if you have these USEF numbers in place.
On the Members and Horses menus there are items to set the USEF numbers, when selected the following dialog is displayed...
To the left is Set USEF Numbers dialog as selected from the Members menu, There is a corresponding item on the Horses menu for setting the Horse USEF numbers.
You simply type in the USEF numbers. You can type in names into the box at the bottom to quickly search for a particular member.
To import the the USEF electronic results simply select Import USEF Electronic Results from the Data menu and navigate to and open the file. You should definitely always make a backup of your OrgPro database before importing USEF electronic results, a file that is not in the correct format could potentially damage your data. OrgPro can open comma delimited (CSV) or tab delimited files. If you receive an Excel (XLS) file you should open it in Excel and save the file as a tab delimited text file. If you do not have the Excel program you should request the sender of the file to resend it as a tab delimited text file.
When you open the file it will be displayed in a table as show below. This gives you an opportunity to access the validity of the file and to make some corrections if they are required.
The rows below that are highlighted in green are championships. OrgPro has recognized them as championships because the class number is greater than 10000 and because the word "Championship" appears in the class name. These are two methods that USEF uses to recognize championships. A couple other variations are also recognized by OrgPro - the word "Division" in the class name or and X appearing in the class number, i.e. 101X - we have seen files that use these conventions.
You can use the Toggle Championship button to change whether a line in the file represents a championship or not, this give you the ability to control what is interpreted as a championship.
If you click Ok the results will be imported into OrgPro, if you click Cancel they will not be imported.