Jump to content

Import of Images forces error


This topic is 6565 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have adapted the FM7 Document Library template to store images (as references), however when I import using:

Show all records

Set error capture off

import records, update existing records

perform find to show imported records

constrain found set

the pictures imported replace existing records meaning i have to find the new pictures manually change the details and then re-enter the details for the misplaced records.

Apologies if this is not particularly clear however i am not entirley sure how this can be happening.

I have included a sample of the database to illustrate my problems.

I am wondering if it is something to do with only importing a reference to the file.

If anybody could help then you would make a very confused person happy. :D

Equipment_Check_Sheet_Clone.zip

Link to comment
Share on other sites

A few things. First, you have selected the "Update existing records" option. This means "import into the current found set, replacing current images", ie., new image file 1 goes into record 1, 2 into 2, etc., regardless of anything except the record position.

What you may want is "Update Matching records" instead. You have to choose a match field, which would likely be either File Name or File Path (the latter best in case of duplicate names). After choosing "Update Matching records" you click again on the match field, and the -> turns into =

Also, after an Import the found set is automatically the records imported (or matched in this case), including new records added (which you have checked). You don't need the Finds if that's all you're doing.

Also, minor point, your Find and your Constrain Find seem to the same.

Link to comment
Share on other sites

So obvious when i look at the options!!!

That will certainly save a lot of time and confusion when importing records in the future.

Along the same lines is it possible to get the file size of the file you are importing, have looked in the options but cant seem to find this one. even thought i may be able to use the get file size option pointed at the container, but no go. Is there an easy way to do this. It's just because i know that any files imported under a certain size will be scan errors so i will find these records and tell the user to delete the records and rescan images.

Many thanks,

It certainly makes a difference having a forum like this to bounce ideas around and hopefully i may be able to help someone in turn (might take a while though!!) :P

Link to comment
Share on other sites

This topic is 6565 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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