specifying what i want to export

[RadioactiveFrog]

hey,

sorry if this is a stupid questions but from what i have been reading the only way to specify what i want to export is by creating a specific layout for it, is there not a quicker way?

as i said sorry if this is a silly question !!

cheers,

RF

[Toni]

Create a specific layout? Don't get this. Why should you create a specific layout.

When I want to export I just choose export from the FileMenu and then I do select the fields which I want to export. If the exporting it's gonna be a repeated job, then it is conventional to create a script for that. You also need to choose in which format you are going to export. I usually prefer the .mer files and tab-seperated text files.

Toni

[Wim Decorte]

No, you certainly don't need to create a layout for exporting. All you need is a script in the file you want to export from, specify an output file & format and pick the fields you want exported. Done.

[LaRetta]

All you need is a script in the file you want to export from.

Getting it in and out isn't always that easy.

It is possible that RadioactiveFrog had read about an export from vs. 7 and applied the thinking to vs. 6. In vs. 7, you DO need a layout based upon the table or you can't export from (or import into) that table. This is a small but important distinction between versions. Vs. 7 needs a layout based upon the table OR a layout based upon a table RELATED to the one you wish to export (but the record-set would be based upon the existing table). There must also be an occurrence of the table in the graph or you can't even create a layout for it.

I'm unsure whether it still applies to vs. 8 but I would think it does.

LaRetta

[RadioactiveFrog]

Thanks everyone for your replies. This will just eb a one off as i need to export all the products into a file to import into Sage. If we choose to go that route from here!!

If you have read my other posts you will know the probs we are having with our DB created in FM.,

Thanks all

RF

[RadioactiveFrog]

The onlything here i can't see how to do is pick the fields i want and order them as i want. I can dop this if i mauanlly export using File>Export but how do i do this using a script..? Sorry if this is a stupid question.

Thanks

RF

[Lee Smith]

If I'm understanding you correctly, then this is easily done.

In the export records, you can choose the fields you want to export selecting them one at a time, several at a, or all at a time. Once they appear in the export list, you can then sort them by hand to suit.

If this isn't what you need, then let me know where I went wrong.

HTH

Lee

[LaRetta]

"...but how do i do this using a script.."

When you select Export[] script step, you have the option of specifying your export right within the script - which will stick and repeat each time the script is fired.

[Lee Smith]

Hi LaRetta,

Good catch. I read over that part three times.

And this after my Starbucks too.

Lee