Hi In general I agree that failing for a whole file is appropriate, however there is at least one table where partial completion would be advantageous, and this feature would make it far easier to find and fix importing errors in the future.
A while back I ran into this with one table in particular, I think it was the product category table. The table is self referencing creating a hierarchy, so even though all of the entries were in the file to be imported, the import function choked on the first item that didn't have a valid parent and causing the whole file to fail. Although it was possible to turn off referential integrity to import the file, it could have also worked to extend the cyclical import function to "write out" a new xml data file with only the rows that fail during each pass. If I understand correctly, the current cyclical import function will load xml data files atomically, deleting those files that work and retrying any files that are left again again until the number of files does not decrease in a pass. A revised system would perform the same process, but instead of working on the file level, work on the level of the row. For each file, if a row is not accepted, write a new import xml file with that row that could not be imported. Rather than stopping when a pass results in no fewer files, stop when a pass was unsuccessful at adding any additional rows to the database. I think the best part of this scheme is that it separates the needle from the hay when importing data sets with errors. After running it on a data set that has real referential integrity issue (the needle), all of the good records (the hay) are removed. This helps the developer to quickly find and fix the problems. Thanks -- Daniel *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*- Have a GREAT Day! Daniel Kunkel [EMAIL PROTECTED] BioWaves, LLC http://www.BioWaves.com 14150 NE 20th St. Suite F1 Bellevue, WA 98007 800-734-3588 425-895-0050 http://www.Apartment-Pets.com http://www.SatelliteRadioZone.com http://www.Cards-Visa.com http://www.ColorGlasses.com *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
