The following assumptions are integral to the successful operation of the data validation routines:
· The import data must be a flat file – all the data must be in one file
· The data must be orthogonal (or normalized)
· The field names must be in the first row of the file
· The actual names used for column headings is not important in the source file. One of the steps involved in loading a file includes mapping where the data should go.
· There can be no spaces between the top of the file (or spreadsheet) and the heading row or the heading row and the data
· If you suspect that some or all of the data you are loading into the database is already in your database, you can specify that SiteFX check for and exclude and duplicate records by placing check marks beside the destination field names.