Hi Don, I only use incrementing using recursive panel links and I have not had any problems with importing of data from a WP Merge file eg when I am making changes to the panel. Almost everyone of my panels uses this form of numbering as I always use this as a non data loaded Primary Key.
Over the years I have had the odd problem of importing but I have always found it was something I had overlooked somewhere else. In reference to Pat's comment though the renumber on import should only be relevant if you have ::I fields and not the recursive link. The thought however got me thinking about this, and how you would initiate renumbering or not on an import. I think the answer is in the formula on the ID field which should be IF HiddenField=0 THEN etc etc and that the formula is triggered on the SAVE of a newly created record. Consequently if you did not export the hidden field you would get renumbering, but if you do export it you do not. I am not sure if this helps you or not, but perhaps looking at when your formulae are triggered to occur might shed some light on it By the way, I am not sure if this is germane or not, probably not, but in terms of edit orders I ALWAYS have my recursively-linked-autonumber Primary Key as my first field in the edit order, and the reverse hidden field as the second. Happy hunting Don. Brian -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Don Codling Sent: Thursday, 18 November 2010 1:38 PM To: DataPerfect Users Discussion Group Subject: [Dataperf] importing from WP merge 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
