Skip navigation
All Places > Discussions > Discussions
Log in to create and rate content, and to follow, bookmark, and share content with other members. Not a member? Join Now!
AnsweredAssumed Answered

Exporting a list

Question asked by AlastairMcInnes on Jul 4, 2013
Latest reply on Jul 5, 2013 by AlastairMcInnes

Title

Exporting a list

Post

     I have a field defined as:

 ValueListItems ( Get ( FileName ) ; "Upsells" )

     The ValueList itself is defined in the database and takes its values from related fields.

     When I look at the results in a list layout, everything is exactly as I would expect - there is a little list of the related records in the field.

     When I try to export it, Filemaker is running all the values together so that I just get a long string of numbers in the Upsells column of the export.

     I tried redefining the field to replace the line breaks in the list with something else:

     Substitute ( ValueListItems ( Get ( FileName ) ; "Upsells" ) ; "¶"; "|" ) 

     And, again, the list is now separated by pipes when I look at it on screen, but, again, when I export it, Filemaker is running all the list items together.

     I've tried exorting as tab-delimited, comma-separated and Excel with the same results each time. I've attached a little picture - the upper bit is a screen shot from Filemaker and the lower bit, the same records by the time they've made their way to Excel (I didn't export the middle column of the Filemaker bit).

     I'm sure I'm doing something obvioulsy wrong, but, whilst I still have some hair left, could someone point it out to me?

     Thanks in advance,
     Alastair

Filemaker.jpg

Outcomes

    • davidanders

           From another website - you want a list

                Re: Exporting Value Lists

                          Set the Value List Items into a variable, copy and pasted into a text file. Then copy and pasted into the value list in the new file.
                          
                          Set Variable [ $file; Get( FileName ) ]
                          Set Variable [ $names; ValueListNames ( $file ) ]
                          Set Variable [ $count; ValueCount( $names ) ]
                          #
                          Loop
                          Set Variable [ $i; Value:$i+1 ]
                          Exit Loop If [ $i>$count ]
                          #
                          Set Variable [ $$result;
                          List(
                          $$result ;
                          GetValue ( $names ; $i ) ; ¶ ;
                          ValueListItems ( $file ; GetValue ( $names ; $i ) ) ; ¶ ; ¶
                          ) ]
                          End Loop

            

      • AlastairMcInnes

             Sorry, I'm not entirely clear, but it looks as if that's going to form a long list of all the value list items from the file which is rather more than I'm after. I'm far from a Filemaker expert, but I don't see the place where it's copied to a text file.

             To be honest, and I don't want to seem ungrateful, but that seems like a lot of work just to get Filemaker to export what it seems happy to admit are the actual field contents.

             BUT, many thanks for the response.

        • AlastairMcInnes

               I figured it out.

               The field I was using was a calculation field whose result was defined as a number. Although FIlemaker will display this as text, it won't export it. I changed the type to text and all is well.

               Thanks again, for the suggestion, though.