2 Replies Latest reply on Dec 28, 2010 4:41 AM by LeonMartin

    Help req to exports csv



      Help req to exports csv


      Hi I have been stuck on this for ages would like to to know how to script an export to csv when i have 20 sets of fields in one record like ... bob1,bob2,bob3,bob4 and tom1,tom2,tom3,tom4 etc and need to get them into individual columns (not rows) a1,b1,c1,d1 and a2,b2,c2,d2  and then the next record to continue down the spreadsheet column. I almost can do it but have problem with carriage returns. Any help appreciated.

        • 1. Re: Help req to exports csv

          I think there have been no answers to this because no one really knows what you have in FileMaker exactly, nor what you want in the csv exactly. We could guess, but likely incorrectly. 

          I'm pretty sure (tho without knowing) this will need another table, to temporarily hold the rearranged values, which you could then Export, then delete. With a script to go thru your existing values to create the temp records, and populate the fields.

          Or just calculations to assemble the values. But I somehow doubt that. When you say "problem with carriage returns", do you mean "I have fields with internal carriage returns which get changed when I Export CSV"? or "The output has too many or too few carriage returns (too many or too few rows)"?

          • 2. Re: Help req to exports csv

            Made another table pasted the fields with script loops into a single record and it exports perfectly and gives me greater control over sorting and re-numbering.

            Works well now.