Hello All:

I would like to have two or three scripts that would export different
sets of predetermined fields to csv files.

What I have now is the following script for one of the exports:

Go to Lagout["ExportLayout" (returns)]
Enter Find mode [Pause]
Perform find[]
Export Records[]
Goto Layout["StartLayout"(returns)]

As it stands now Export Records[] brings up first a dialogue box and
asks for a file name. Then brings up the list of fields for the user.

How would I auomatically specify a set of fields at this step?

Thanks!

Sam

SamMc wrote:

Fill in all of the blanks and check all of the boxes.

In the Export Records script step, there's a checkbox to "Perform without
Dialog". Check that.

THere's another to "Specify Output File". CHeck that and name the file.

There's another to "Specify Export Order". Check that, and in the next
dialog click and drag the fields you want to the order you want.

Done.

Matt

In article <1122059226.508541.6560 (AT) g44g2000cwa (DOT) googlegroups.com>,
"SamMc" <FMP_account (AT) hotmail (DOT) com> wrote:

Similar to the Find, Sort and Page Set-up commands, the Export Records
command can store the current export fields and order with the script
and restore that when the script is run.

Unfortunately it's nowhere near as easy as it SHOULD be, but to store
the Export fields / order:

- Export some records manaully using the option from the
File making sure you set the fields and order you want.
(The actual record data is irrelevant.)

- Create a new script and add the Export Records command
OR edit an existing script and add the Export Records
command. If you've already got a script that has the
Export Records command in it, then simply open that
script as though you were going to edit it.

- Make sure the Restore option is turned on for the
Export Records command.

- At this stage you may want to turn on the Perform
Without Dialog option for the Export Records command
so that the user doesn't ever see that "Choose fields
to export" window. You can also specifiy a filename if
you want to.

- Close and save the script with the OK button.

- If you added a new Export Records command then nothing
happens, but the script now has an export fields list
and order stored with it that will be restored and used
whenever the script is run.

- If you modified a script that already had the Export
Records command, then you'll get a window asking if
you want to Keep or Replace various stored options
(Find Request, Sort Orders, Export lists, etc.)
- the FIRST time you edit the script you
have to use the Replace option for the
Export command
- whenever you later edit the script you
need to use the Keep option (unless you
want to replace the stored Export list
with the manual one you last performed).

All done. Repeat this process for each different Export field list /
order that you need, but make sure to store each in a separate script -
you can only have one stored.



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Thank you Matt and Harry!

It is working like a charm.

Sam