www.spansoft.org

SpanSoft help and discussion forums.
It is currently Wed May 24, 2017 1:31 am

All times are UTC [ DST ]




Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: 'merge' problem
PostPosted: Fri Dec 05, 2014 1:43 pm 
Offline

Joined: Thu May 13, 2010 7:11 pm
Posts: 6
Nick, I am having a problem merging databases. I've done it before without issues but now instead of adding the second db to the target, it merely duplicates the target on top of itself. Any suggestions please?

Regards
Philip


Top
 Profile  
 
 Post subject: Re: 'merge' problem
PostPosted: Fri Dec 05, 2014 3:58 pm 
Offline

Joined: Sun Dec 18, 2005 10:36 am
Posts: 639
Location: SpanSoft, Scotland
Hi,

The only thing I can think of is that the incoming database contains the same data as the target.


Top
 Profile  
 
 Post subject: Re: 'merge' problem
PostPosted: Fri Dec 05, 2014 4:39 pm 
Offline

Joined: Thu May 13, 2010 7:11 pm
Posts: 6
Hi, Yes, I thought of that but I've checked and rechecked and tried it with 2 or 3 different db's.


Top
 Profile  
 
 Post subject: Re: 'merge' problem
PostPosted: Fri Dec 05, 2014 6:29 pm 
Offline

Joined: Sun Dec 18, 2005 10:36 am
Posts: 639
Location: SpanSoft, Scotland
Hi,

Please upload the two databases to us and we will try to reproduce the problem. Please use "Help | Upload data to support" and indicate which is the target database.


Top
 Profile  
 
 Post subject: Re: 'merge' problem
PostPosted: Tue Dec 09, 2014 10:53 am 
Offline

Joined: Thu May 13, 2010 7:11 pm
Posts: 6
Nick,
I think I might know where the problem lies. When I went into Remove duplicate people, i found that there were quite few for most people, from when it had copied itself. Many of them I could condense back into the original record, but those that have a picture attached wont cooperate. i get two error messages. The original person record comes up with:
DBISAM Engine Error #10258 Cannot lock record in table 'Pictures'

An the duplicates say:
DBSIM Engine Error #9729 Duplicate Key found in the index 'Order Idx' of the table 'Pictures'

I've tried going into the record and deleting pictures but tht simply freezes the whole thing and I have to use Ctl/alt/del to get out.

I've also deleted K &K and reinstalled, but it makes no difference.


Top
 Profile  
 
 Post subject: Re: 'merge' problem
PostPosted: Tue Dec 09, 2014 1:31 pm 
Offline

Joined: Sun Dec 18, 2005 10:36 am
Posts: 639
Location: SpanSoft, Scotland
Hi,
It sounds like there may be corruption in the database. Please try using "File | Database | Repair" and then "File | Database | Pack".


Top
 Profile  
 
 Post subject: Re: 'merge' problem
PostPosted: Fri Dec 12, 2014 12:10 pm 
Offline

Joined: Thu May 13, 2010 7:11 pm
Posts: 6
Nick, I had tried that before, but I've done it again with no effect I'm afraid.


Top
 Profile  
 
 Post subject: Re: 'merge' problem
PostPosted: Fri Dec 12, 2014 12:59 pm 
Offline

Joined: Sun Dec 18, 2005 10:36 am
Posts: 639
Location: SpanSoft, Scotland
Hi,

Thank you for sending us your databases. My apologies for the delay, I did not realise that you had uploaded them.

The Jackman database already includes two copies of all the families in the Piddington database which is why you are seeing duplication when you merge the Piddington database. The family groups are well spread out on the main view and you can use "Search | Go to family" to find the groups as follows:

F132 (57 families)
F186 (46)
F195 (36)
F295 (16 - duplicates from Piddington)
F334 (16 - duplicates from Piddington)

Total number of families = 171 and confirmed by "Tools | Statistics".

If you are having problems removing the duplicates, try selecting a duplicated group on the main view and using "Edit | Delete families" and select both "Delete parents" and "Delete children". We tried this with your database and did not get any error messages.

You also have a large number of people in limbo, ie. people who do not appear in any of your families. You can check this list by using "Tools | People in limbo". Several of these also appear in your Piddington database.

Hope this helps.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group