Hi Colin - and thanks again for the help with that other matter, they're making progress with it - the index on the panel was the ::I field, there was nothing imported into that field on the original import, it created it's own number. When I created an incrementing number separately on the spread sheet and removed the ::I from that field the import worked fine. That's what is making me think that the ::I can't keep up with the speed of the import.
2011/3/3 Colin Roberts <[email protected]> > Your Incremental field would need to be in the index used to import > wasn't it? > > ----- Original Message ----- > *From:* Don Friedman <[email protected]> > *To:* Dataperfect Users Discussion Group <[email protected]> > *Sent:* Friday, March 04, 2011 8:53 AM > *Subject:* [Dataperf] Problem with incrementing number > > I was working with a small database today (a county with only about 91,000 > voters) and at a certain point I attempted to create a new panel and import > a .csv file with about 17,000 lines of data using an incrementing GZZZZZ > field as an index. Every attempt to import the data failed before completion > so I tried creating the panel again, exporting and importing the .ste file > and re-creating indexes. No luck. > > Inspected raw data. Looked fine. > > Created a stand-alone database with a single panel for this application. > Again, import kept failing. > > Failing to come up with a credible reason why it wasn't working I added an > index number to the data set so that rather than depending on the > incrementing number, the data would have its own unique number. That did the > trick. > > Any ideas as to why? > > Don Friedman > > > -- > Don Friedman > ProfessionalRecords.Com LLC > PRS Data Systems > 205 S Main Street > Pittsburgh, PA 15215 > 412-784-1600 - 1-800-PRS-FILE > 412-784-1615 Fax > > ------------------------------ > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > > -- Don Friedman ProfessionalRecords.Com LLC PRS Data Systems 205 S Main Street Pittsburgh, PA 15215 412-784-1600 - 1-800-PRS-FILE 412-784-1615 Fax
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
