Newbie question re: exporting

[amccallum]

Hi

Does it have to be tab separated ?

If it can be comma separated you can export to a .mer file and the first row will be the field names. Otherwise you may have to use an itermediate program (like Excel) to convert from comma to tab delimited.

Or what about entering the field names as the first record in your FMP file.... just thinking outside the box a bit.

quote:

---

Originally posted by jcsmonogram:

I've been trying for days to figure this one out, maybe someone here can help.

I've got a button to export data from FMP to a tab-separated text file. I need the field names to be the first line of the exported document so the program that imports the data knows where to put it. I can't figure a way out to do this.

A little more info, if that will help: My database stores video clips of an episode of a TV show. It stores the name of the clip, the timecode numbers, the reel numbers, etc. I'm exporting this information so that the text file can be imported into an Avid editing system. The Avid needs to know where to put the raw data, so that's why I need the first line to tell it "name, tape, in, out, duration, etc."

Any help would be appreciated.

Thanks,

Jeffrey Smith

[email protected]

---

------------------

Andrew McCallum

McCALLUM CONSULTING P/L

Sydney, Australia

61 2 9585 8775

61 407 482 609

[email protected]

[This message has been edited by amccallum (edited July 17, 2000).]

[jcsmonogram]

I've been trying for days to figure this one out, maybe someone here can help.

I've got a button to export data from FMP to a tab-separated text file. I need the field names to be the first line of the exported document so the program that imports the data knows where to put it. I can't figure a way out to do this.

A little more info, if that will help: My database stores video clips of an episode of a TV show. It stores the name of the clip, the timecode numbers, the reel numbers, etc. I'm exporting this information so that the text file can be imported into an Avid editing system. The Avid needs to know where to put the raw data, so that's why I need the first line to tell it "name, tape, in, out, duration, etc."

Any help would be appreciated.

Thanks,

Jeffrey Smith

[email protected]

[ZuperZZ]

The record with the field names must be created just before run the import step and then erase it. That way it doesn't affect the rest of your data.

To create the field names record within a script use set field commands:

New record Request[]

set field[Name,"Name"]

.

.

. Etc

ZZ

[amccallum]

... and sort the found set on a field that will always put the field names in first position before you export

... only problem with this set field technique is if you have calc fields you will not be able to name them... likewise with anyhting other than a text field come to think of it... so it might not work as well as expected

------------------

Andrew McCallum

McCALLUM CONSULTING P/L

Sydney, Australia

61 2 9585 8775

61 407 482 609

[email protected]

[jcsmonogram]

Thanks for the reply. It's a good idea about creating a record with the field names. But is there a way to make sure that record is always in the number 1 spot even after users have done searches in the database?

Jeff

[email protected]