oilman Posted June 13, 2003 Share Posted June 13, 2003 Hi all Read a thread about keeping your information in a different db then the input db and thought i would try this. I made a clone of my db and deleted all records in the clone and tried to import the information back in from the orginal. I removed all relationships in the clone db. About a quarter of the data is not import. Since the db is an exact clone, any ideas why this is happening. Using FM6. The import is done manually. Thanks Lionel Link to comment Share on other sites More sharing options...
slstrother Posted June 13, 2003 Share Posted June 13, 2003 About a quarter of the data is not import. By this do you mean that not all of the records are importing? In the source db (your input db) are all records found? When importing from one FM db to another, only the records in the found set in the source db will be imported. Link to comment Share on other sites More sharing options...
paulage77 Posted June 14, 2003 Share Posted June 14, 2003 I made a clone of my db and deleted all records in the clone There were records in the clone to delete? Link to comment Share on other sites More sharing options...
oilman Posted June 14, 2003 Author Share Posted June 14, 2003 hi slstrother All the records come in but about two thirds of the data for each record is imported. Link to comment Share on other sites More sharing options...
oilman Posted June 14, 2003 Author Share Posted June 14, 2003 hi paulage77 Yes the clone had records since i copy the orginal db then delete the data then tried to import it back in. Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted June 14, 2003 Share Posted June 14, 2003 Hi, I removed all relationships in the clone db Were the records losts related ? i copy the orginal db then delete the data then tried to import it back in. Serials ? What happened Link to comment Share on other sites More sharing options...
oilman Posted June 14, 2003 Author Share Posted June 14, 2003 hi Ugo No records were lost just data. Example A Record in the original db would have Twenty fields. only Fifteen fields will import the data into the clone db leaving the other five fields empty. Yet all twenty fields in the original has data in it. Any ideas why this is happening. thanks lionel Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted June 14, 2003 Share Posted June 14, 2003 Hi Lionel, I understood that. But were the 5 fields somehow "related" to other files ? Link to comment Share on other sites More sharing options...
oilman Posted June 14, 2003 Author Share Posted June 14, 2003 Hi Ugo When i said i detele all of the relationship, I meant in the db where i want to just storage the data. A lot of information in the original db is install through a value list with relationships with others db. These relationships still exit. thanks lionel Link to comment Share on other sites More sharing options...
cjaeger Posted June 14, 2003 Share Posted June 14, 2003 try exporting as Filemaker. This gives you a db without interface or scripts or relations with all fields, all calcs are converted to data fields. Then import from there. Link to comment Share on other sites More sharing options...
oilman Posted June 14, 2003 Author Share Posted June 14, 2003 Hi Cjaeger Thanks for the suggest but it did not export the five fields or data. This is the only db that it does this with. I have two other db that i do this with and they work like a charm. Guess i will have to recontruct this data base from scratch again. thanks Lionel Link to comment Share on other sites More sharing options...
cjaeger Posted June 14, 2003 Share Posted June 14, 2003 that's what I guessed. the problem is not IMPORT, but EXPORTing from the original database. Link to comment Share on other sites More sharing options...
SteveB Posted June 14, 2003 Share Posted June 14, 2003 Try recovering both of the files. I've found that when no logical reason exists for a file's behavior, it's usually corrupted. Steve Link to comment Share on other sites More sharing options...
oilman Posted June 14, 2003 Author Share Posted June 14, 2003 Hi all Did the recover part and export it and it work perfectly. Thanks all Lionel Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7612 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now