cjcain Posted April 9, 2021 Report Share Posted April 9, 2021 I recently updated to StampManage2021 (from 2007) it imported my collection. I have been making some updates on and off, but I just noticed that I have 2 collections both named exactly the same: "Chris' Collections" (one has 2621 items and the other has 2542) Not sure where the 2nd one came from or which one is the one I have been updating. Is there a way to compare the differences between two collections? or a way to merge them (skipping duplicates)? Quote Link to comment Share on other sites More sharing options...
Guest Colin Pattrick Posted April 10, 2021 Report Share Posted April 10, 2021 cjvain. You do inded have two collections, but they have different names. The first one named Chris collection has NO Apostrophe whilst the second one has an Apostrophe between Chris and Collection. The collection with 2621 items looks like the one you have been doing additions to. Hope this helps Colin Quote Link to comment Share on other sites More sharing options...
cjcain Posted April 11, 2021 Author Report Share Posted April 11, 2021 The problem is, I am not sure when the 2nd one showed up, so I may have been updating the other one as well. I know I had changed some information in addition to adding some stamps. Is there a way to export the list of Scott numbers and locations to a text file or spreadsheet, so I could do a comparison? I was thinking the report feature, but it seems to produce pdfs. Quote Link to comment Share on other sites More sharing options...
cjcain Posted April 11, 2021 Author Report Share Posted April 11, 2021 I found the export in the print options. I can export to txt/spreadsheets and try to compare. Quote Link to comment Share on other sites More sharing options...
Guest from colin Posted April 12, 2021 Report Share Posted April 12, 2021 cjcain. The database uses its own id number for each Scott numbered stamp within the database. It is in fact a Microsoft Access Database and Stamp Manage(SM) have developed it further. The id numbers run concurrently (you will find missing id numbers e.g. deletions). The stamps that you have added to the program will all have higher id numbers. Also the SM program adds the date that you added a new stamp record. If you can export this to a txt/spreadsheet it makes comparisons easy. This info is held in a Data Program File Table called varieties. email direct if you still have a problem colin@colinpattrick.com Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.