copying portal data

[merkaba22]

I need to export telephone numbers contained in a portal from a related table, Telephone, along with the rest of the data for each given record in the main table, Raedbase; since the Export function does not provide for this, I have decided to copy data from each portal row into a series of fields, T1, T2, etc. so that these field contents can then be exported to a .csv file.

I am building a script to copy the telephone::telephone for each portal row to T1, T2, ..., T8 (since the maximum number of rows holding data in any one record is never higher than 8) -- first portal row, telephone, would be copied to T1, next portal row, telephone, would be copied to T2, and so on.

FileMaker 10 Help states: "When a related field in a portal is selected, you can use this step to move to the same field in another portal row. For example, if the third field in the second portal row is selected, Go to Portal Row [Next] goes to the third field in the third portal row."

However, the following script is not copying data from the "next" row -- its pasting Telephone::Telephone from the first row to T2 and I do not understand why:

Go to Record/Request/Page [First]

Go to Portal Row [select; First]

Copy [select, Telephone::Telephone]

Paste [select; Raedbase::T1]

Go to Portal Row [select; Next]

Copy [select, Telephone::Telephone]

Paste [select; Raedbase::T2]

Further, there is another portal on this layout, I would also like to know how to run a similar script there as well and do not know how to delineate the two portals.

Any help here would be greatly appreciated.

[mr_vodka]

You should really go to the related child records and export those.

[merkaba22]

OK -- that was my first thought but I know of a schema to merge the parent and child exports by record ID since the one-to-many were not consistent for each record; any ideas?

Thanks:)

[mr_vodka]

See this other post that is going on right now. You should sub-summarize by the foreign ID. This will group the child information under each parent information section.

http://www.fmforums.com/forum/showtopic.php?tid/202545

Edited April 3, 2009 by Guest
updated link

[Lee Smith]

Hi John,

Your link didn't work, it looks to be incomplete. Try using the URL Link button instead.

Lee

[mr_vodka]

lol. it didnt work anymore because I merged the topic into the other... lmao.

[Lee Smith]

Good Job!

:goodpost:

[merkaba22]

What's the link to the merged topic, please:)

[mr_vodka]

In my post a few up