This site will look much better in a browser that supports web standards, but it is accessible to any browser or Internet device.

Skip Navigation skip menu and banner
University of Wyoming

FairPlus!
Data Export

[pdf version]

The data export utility allows item and exhibitor data to be exported from FairPlus! into a .csv (comma separated value) file.  Comma separated value files can be imported into Excel, Word, or most commercial software that understands .csv files.

  Check information can be exported from the Financial section.  See the Export Check Data tip sheet for more information.

  1. Click Go to > Utilities > Data Export.  See Figure 1.

Figure 1. Data Export

Figure 1.  Data Export

 

1st Step

  • Select the desired class or classes from the selection box on the left-hand side of the screen.  The classes can be multi-selected.  See the Select Multiple Items tip sheet for more information.

2nd Step

  • There are three methods of exporting data.
    • Items Unique - This means an export is requested that will contain all the items n each selected class.  Select the information from the middle column for those items.  There is no third step option available when this option is chosen.
    • Exhibitor Unique - This option means that an exhibitor is listed once.  This is regardless of how many items the exhibitor has entered items in the selected classes.
    • Exhibitor/Item (one record per exhibitor) - One record on one line with all exhibitors for that exhibitor included.  This is not a recommended method of export.  If members have many, many items, the 256-column limitation of Excel and Access will probably be exceeded.  This method of export works well in states where they limit the number of items that can be exhibited and thus tend to stay within usable limits.

3rd Step

  • These options are only available when Exhibitor Unique is selected in the second step.  With these options, the contents of various fields are exported on a "canned" basis.  If more information is exported than needed, remove the columns in Excel or Word.  Another option is to not include those columns in a merged document.

4th Step

  • A file can be exported with the generic name of Export.txt or a file name can be designated.  When several different types of files are being exported with different information, give them specific names that provide a reminder of the information they contains.
  • A file exported generically with the name of Export.txt will be overwritten the next time information is exported.  A file with a specific informational name generally will not be overwritten.  However, be certain that the source data has not changed since the export in order to get the latest, most complete set of information.
  • Either type of file is saved to the C:\CKV\dataxfer folder.  Be sure when the application is opened that the type of file is changed to All files rather than just the application specific files.  Otherwise, it may appear that the exported file is not there.  See Figure 2 and Figure 3.

Figure 2. Application Specific Files

Figure 2.  Application Specific Files

 

Figure 3. All Files

Figure 3.  All Files

 

Ed.  07/11/06

• Home • Up • Next •

[top]

Updated on 07/11/2006