Jump to content
Sign in to follow this  
oilman

not importing all data

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

hi slstrother

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

Share this post


Link to post
Share on other sites

hi paulage77

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Hi all

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

Thanks all

Lionel

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. 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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Quito 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.