Jump to content

Importing Data


Helper
 Share

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

Recommended Posts

  • Newbies

Have a old filemaker 5 file that converted fine to 8. The question I have is the old file was setup wrong and I am correcting it in the new file but using the import data from file does not update in the new repeating field correct. So I must be incorrect in the way I am trying to fix it. The old file had 6 sets of exact fields Qty. 1,2,3,4,5,6 and description 1,2,3,4,5,6. The new file has just 1 of each field, formatted as a repeating field. Importing the file the first time works fine but when I try to import again using the next field #2 and putting it in the new file field as a update it overwrites it and does not add it in the repeating field, the old file and the new file has a job number that I use as a match field. Any help?

Link to comment
Share on other sites

Hi, Helper

and welcome to the FMForums !

So you want to correct your .fp5 that had real fields with repeating fields in FMP8...

sssss...Soren may hear you ! :P

BTW: don't import, but convert as it was...and make your corrections on the converted file.

Link to comment
Share on other sites

  • Newbies

Let me explain a little more:

The old file has a job number and on it it has 6 spots for 6 different qtys and descriptions of products per order(job number). The new file has 1 qty and 1 description field (repeating). How do I put the old data into the new fields. ( 6 old fields into a new repeating field in order). The problem with the old file is you could not search the decription field without putting the info into one of the six old fields and to be able to have more than 6 items per order.

Thanks for your time.

Link to comment
Share on other sites

In the converted file make a script like this:

Show All Records

Go to Record/request/page [First]

Loop

Set Field [repeating;field1]

Set Field [repeating[2];field2]

Set Field [repeating[3];field3]

Set Field [repeating[4];field4]

Set Field [repeating[5];field5]

Set Field [repeating[6];field6]

Go to Record/request/page [Next; Exit after Last]

End Loop

Link to comment
Share on other sites

  • Newbies

Ok I did try it and nothing changed, here's my script.

Show All Records

Go to Record/Request/Page [First]

Loop

Set Field [Job Ticket::Qty1[6]]

Set Field [Job Ticket::Qty2[6]]

Set Field [Job Ticket::Qty3[6]]

Set Field [Job Ticket::Qty4[6]]

Set Field [Job Ticket::Qty5[6]]

Set Field [Job Ticket::Qty6[6]]

Go to Record/Request/Page [Next; Exit after last]

End Loop

Link to comment
Share on other sites

This topic is 5763 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.