custom Exporting, need help

[solarpunk]

I am runnnig FM6. Basically i am want to create script that will automatically will export records to tab file with out a user selecting what field to choose to export.

what i did, i create two fields one is call g_delimiter which hold the "," as the delimiter and calc a field call c_custom_delimiter_export which has in it:

Last Name & g_delimiter &

First Name & g_delimiter &

SSN & g_delimiter &

Location & g_delimiter &

Session & g_delimiter &

Year & g_delimiter &

StudentWithDrawDate & g_delimiter &

Status & g_delimiter

than i have button to run the script. the problem that i am having with it is that it is not selecting the field c_custom_delimiter_export to export. i am just want to automate the process in which the user dont have to select what field to export.

this is what i have for the script:

Enter Browse Mode []

Export Recors [Restore, "CustomDelimiter.TAB"

i found example in a book, it works fine in that example but not in mine.

any help would be appreciate.

thanks

victor

[BobWeaver]

You need to do an export manually once to set the export order (selectinng the field c_custom_delimiter), then edit your script, and when exiting it will ask if you want to replace the export order. Click yes. Now, it should always use that order whenever the script is run.

[comment]

Perhaps you can save yourself a lot of unnecessary work, by exporting the actual fields. IOW, select File > Export Records... and in the ensuing dialog select these fields:

Last Name

First Name

SSN

Location

Session

Year

StudentWithDrawDate

Status

Do the export once. Then edit your script as per Bob's post.

[solarpunk]

addict,

i notice that too. i am did the way you mention and it works.

thank you all for the help. i really appreciate it.

thanks

victor