Normal Topic Copying selected records to a similar Database (Read 944 times)
etejeira
Junior Member
**
Offline


No personal text

Posts: 60
Joined: Aug 6th, 2005
Copying selected records to a similar Database
Aug 6th, 2005 at 1:38pm
Print Post Print Post  
If I want to make a new database with a selected number of records of my original database, it seems that the only way of doing it is by making a backup of the original database then change all the names of all the forms and reports, then marge the backup with the original, then copy the records, then trim one of the databases.
żIs there a simpler and shorter way of donig this? ???
  
Back to top
 
IP Logged
 
Alec
Lanticans
*****
Offline



Posts: 200
Location: Ascot, England, UK
Joined: Nov 22nd, 2002
Re: Copying selected records to a similar Database
Reply #1 - Aug 7th, 2005 at 11:49am
Print Post Print Post  
I'm probably missing something here, but from what you've described it looks to me like you just want the same database but with fewer records. A mass delete does that.
If I'm wrong (very likely) could you describe again what you want to do.
  

Alec
Back to top
IP Logged
 
etejeira
Junior Member
**
Offline


No personal text

Posts: 60
Joined: Aug 6th, 2005
Re: Copying selected records to a similar Database
Reply #2 - Aug 8th, 2005 at 12:31am
Print Post Print Post  
I am going to try to explain in detail what I want to do.
1. I have a mother database where I introduce information every day.
2. I also have many similar databases (one for each client) and every day I have to distribute the information from the mother database to each of the clients databases. Some records go to a client and some others to another. All databases are similar.
3. I do not want to erase any records from the mother database because I use that database for searching globally.
4. In other words all I need to do is copy selected records from a database to another similar one.
5. This was very easily done in Q&A but with Sesame I face the problem that I cannot merge two similar  databases and therefore cannot copy the records without having to change the names of ALL forms and reports!
6. There must be an easer way
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Copying selected records to a similar Database
Reply #3 - Aug 8th, 2005 at 4:05am
Print Post Print Post  
It sounds like you may have done a translation from Q&A using your old "flat-file" structure, and have not gained the advantages that Sesame can bring to you with new tools and a new design.

I wonder about a new design that has only one database to receive records from "Mother". 

==================
1.  Add a field for the Client ID to the existing receiving database.

2.  Make sure that Mother has a unique ClientID for every record. 

3.  Send all records from Mother.
===================================
(Actually, the same type of new design could have been done in Q&A).



  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
etejeira
Junior Member
**
Offline


No personal text

Posts: 60
Joined: Aug 6th, 2005
Re: Copying selected records to a similar Database
Reply #4 - Aug 8th, 2005 at 12:22pm
Print Post Print Post  
It seems that we are still no talking about the same thing.
I am going to go in more detail.
I am rendering now a new service that I did not offer with Q&A.
My new database is relational but with only two tables.
However, the first table is similar to the old flat Q&A database.
So now my mother database is relational and similar to all the receiving databases.
And I do have a new Client field in the new database.
So every day after feeding the new information to the mother database I perform one search for each client and get a group of records for each client that I need to copy into each client receiving databases.
To do that it seems that I have to merge each of the client databases with the mother in order to perform the copying operations.
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Copying selected records to a similar Database
Reply #5 - Aug 8th, 2005 at 12:29pm
Print Post Print Post  
If you really need to have a separate application for each client, you can export the data from the master database and import it into the client databases.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
etejeira
Junior Member
**
Offline


No personal text

Posts: 60
Joined: Aug 6th, 2005
Re: Copying selected records to a similar Database
Reply #6 - Aug 8th, 2005 at 1:05pm
Print Post Print Post  
I definitely need to have separate client databases because the clients demand it.
Export/import is not a bad idea.
I looked into Sesame´s export facilities and liked what I saw.
The idea is a little "special" since export/import was designed to pass information from non-sesame databases. But I see no reason not to use it between Sesame databases.
This looks specially easy because the information that I have to copy does not include the information on the subform.
I will go into comma separated export/import.
Maybe I can write a Macro for each client.
However, I still think this means a lot of trouble for an operation that should be straightforward.
I suggest Sesame comes up with a utility that let users copy records between Sesame databases without having to merge them.
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Copying selected records to a similar Database
Reply #7 - Aug 8th, 2005 at 1:23pm
Print Post Print Post  
Quote:
I looked into Sesame's export facilities and liked what I saw.
The idea is a little "special" since export/import was designed to pass information from non-sesame databases.


Actually, Export and Import were both designed to also pass information between Sesame applications. There really isn't anything "special" or kludgy about doing it this way.

BTW, Version 2 will allow you to write records into an external database in code, so you'll be able to do this whole distribution of master records thing with a single Mass Update.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged