Jump to content

importing one record at the time to....


pinkabou
 Share

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

Recommended Posts

  • Newbies

Hello every body, tx in advance to your help !!!

source ;) .txt file with some field (#tape, number of gig, date of backup)

filemaker file : filemaker database with some field (#tape, number of gig, date backup, expiration date) . The filemaker database countain many record with the same #tape, to see the "life of the tape", so when I perform a find on the #tape, I found many record, sort in descending order on expiration date, so the last record I see, tell me if the tape was recycle or not(if not recycle the expiration date is empty)

i would like to be able to perfom this task

selct a .txt file for import

If not cancel

read ONE record from the source

if record read

loop

find in the FM database if these record are find(base on #tape)

if the result return NO record

continu

else

show the result in descending order expiration date

end if

ask if i want to ADD a record for tape #tape

if YES

add the record with the info and put in date of day the today date

else

show message with " Take the number -#tape- in note to resolve conflict

end if

read ONE record from the source

continu until the last record of the source file is reach

endi if

in the filemaker database, find all record where date of day is today

print

stop

Link to comment
Share on other sites

I do not believe it is possible to import a single record at a time. However, you could use another fp5 file to temporarily hold all the imported records, then loop through it, pulling the data into your original file one record at a time, as desired.

Link to comment
Share on other sites

This topic is 5700 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
 Share

×
×
  • Create New...

Important Information

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