AnsweredAssumed Answered

Importing Data into a record with Portal

Question asked by Mitch on Jun 26, 2010
Latest reply on Jun 27, 2010 by S W

Title

Importing Data into a record with Portal

Post

I have a issue regarding importing data for a single record that contains and large number of related portal records.

 

I have a Database created on Filemaker Pro 11, MAC OSX that records the receipts of awards.  The main record has fields that list the <Award_Name> <Award_Type> and the like.   The related portal records lists the recipient details, such as <Surname> <First_Name> <Occupation> <Date>  <Reference> <Page_Number> etc.  

 

As you can see I have any given number of awards within the database, but each award can have a large number of recipients.

 

An export function works well and a single award record can be exported along with all its related recipients  -  within the one spreadsheet. Obviously the <Award_Name> and <Award_Type> are repeated cells for each recipient within the spreadsheet.

 

However, I am stuck when it comes to writing a script and setting up to import  a single award record along with its recipients.....

 

 

Outcomes