Importing Data

[Helper]

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?

[Raybaudi]

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 !

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

[Helper]

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.

[Raybaudi]

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

[Helper]

And what does this script do and how does this join the data from 6 fields into one field?

[Raybaudi]

You have to try !

This script loops between all records and sets the firts repetition of your repeating field to the contents of Field1 and so on with the other fields into the other repetitions !

[Helper]

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

[Helper]

Have it all figured out.

Thanks for your help