If not, depending on your file list options, the second record on may have been
a duplicate.
Pat Riley
At 07:38 PM 11/17/2010, you wrote:
November 17, 2010
I ran into a problem importing a number of records from a WP merge file
into one of my databases. The panel uses absolute incrementation of its
record number through a recursive panel link. A change to that from an
autoincrementing field is the only change to this panel since I last
imported a merge file.
This time, the first record in the merge file imported, and all
successive records were discarded as duplicates. Since there were only a
few, I entered them manually (only one field required in each case),
with no problems. The question is, why did DP reject the last ten
records in the file as duplicates.
I exported the affected records in that panel to a WP merge file, and
compared the exported file to my import file. The only differences were
two empty fields at the end of each record, followed by the record
number and the negative record number from the autoincrementing
recursive link.
3 indexes.
1: Bk #, Author title, page numbers, etc, and record number
2: subject, record number
3: Hidden negative record number for the autoincrement.
In the first two indexes there would be duplicates except for the record
number, which is supposed to increment automatically and so prevent
duplicates.
One record for you to see what I mean
Import file
03951^E
Letham^E
R.^E
Westminster Assembly: ... in historical context^E
^E
52^E
2^E
53^E
Q^E
Church of England^E
^R
Export file
03951^E
Letham^E
R.^E
Westminster Assembly: ... in historical context^E
^E
52^E
2^E
53^E
Q^E
Church of England^E
^E
^E
8484^E
-8484^E
^R
Every record had either different page numbers or different subject line
(Here "Church of England"), and that was sufficient
As I read Ralph Alvy's book, there does not seem to be anything that
would prevent the successive records being imported from incrementing,
but it seems that failure to do that would be the only reason for
calling the records duplicates and rejecting them.
Any help?
Don Codling
DP 2.6y
Windows XP home, SP3
2 GBytes RAM
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
