Steve, that was me asking what form.
Barb,
I think your problem may not be design related.
If you are exporting a related field AND only get the first portal
row, then you are probably only selecting the field from the list of
fields as it is shown on the layout. However, if you first select the
RELATIONSHIP and the field as it is listed there, you will find that
all related portal rows will be exported.
As Steve pointed out and I said, the export from parent is very
different from the child. I'll give some examples:
PARENT:
Mr. Jones, class1, info
, class2, info
, class3, info
Ms. Smith, class2, info
, class4, info
...
CHILD:
Mr. Jones, class1, info
Mr. Jones, class2, info
Mr. Jones, class3, info
Ms. Smith, class2, info
Ms. Smith, class4, info
...
Notice that only the first row gets the parent fields' data, if the
export is from the parent. Each suceeding row will have "place
holders" (see the commas?) From the child perspective, the same
relationship. Can look back at the parent fields. The export will pull
the parent fields into each child record.
One assumes that you have a relationship like this:
STUDENTS-> JOIN_TABLE-> CLASSES
and the JOIN_TABLE has both studentID and classID. The relationship is
two-way, so you can see the students in a portal from the classses
perspective.
This is what we mean when we ask what do you expected the data to look
like and then tell you it depends on from which side of the
relationship you export.
Beverly
Earlier in this thread, someone asked what form you want your export
to appear in. I think this question remains pertinent and lack of an
answer maybe blocking the path to a solution...
So you have one record for Mr Jones and 10 course records for him.
How do you expect this to appear in Excel?
I assume that 10 Excel rows, each giving Mr Jones' demographic
information and one of his courses will not work for you. Obviously,
if it does, you simply export from the child file.
If you want one Mr Jones row in your export, giving demographic
information and then his courses in a, say, comma delimited form,
then you can use the List function to get all of the courses into a
single calculated field in the parent table. Export that along with
the demographic data, and you are done.
The third option is probably more tricky. Maybe this is the one you
want. A single Excel row for Mr Jones, including his first course.
Then rows with blank demographic data, each giving one of his other
courses. Is that your requirement? It should probably be considered
'poorly designed' data -- since sorting the rows would obliterate
their meaning -- but I can understand that such a requirement
exists; I've dealt with it at least once.
So what kind of format is it that you are looking for? If we knew,
I'm sure someone would come up with some kind of solution.
Steve
On 31 Aug 2008, at 05:47, barbpassman wrote:
When I export my FMP records to Excel.
Excel only picks up the first course listed in the uppermost row in
the portal.
I had hoped there was something I could do in FMP so that all the
values in the portal get exported but it seems that is not feasible
