not importing all data

[oilman]

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

[slstrother]

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.

[paulage77]

I made a clone of my db and deleted all records in the clone

There were records in the clone to delete?

[oilman]

hi slstrother

All the records come in but about two thirds of the data for each record is imported.

[oilman]

hi paulage77

Yes the clone had records since i copy the orginal db then delete the data then tried to import it back in.

[Ugo DI LUCA]

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

[oilman]

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

[Ugo DI LUCA]

Hi Lionel,

I understood that.

But were the 5 fields somehow "related" to other files ?

[oilman]

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

[cjaeger]

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.

[oilman]

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

[cjaeger]

that's what I guessed. the problem is not IMPORT, but EXPORTing from the original database.

[SteveB]

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

[oilman]

Hi all

Did the recover part and export it and it work perfectly.

Thanks all

Lionel