Don, Can you specify: a). How the data is constructed? With "Field","Field" or are some fields without quotes etc.? Importantly, are spaces being trimmed? b). Options used to import (Dos Import) etc. c). How you answered the two questiond DP asks when you import? My memory is that the import will fail if you use the numbers. Was the CSV generated wtih excel? Excel varies a bit in generation and importation of CSV lists.
Date: Thu, 3 Mar 2011 23:23:27 -0500 From: [email protected] To: [email protected] Subject: Re: [Dataperf] Problem with incrementing number 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 To: Dataperfect Users Discussion Group 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
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
