Jump to content
Sign in to follow this  
LVA

column names

Recommended Posts

I use windows 2000 and filemaker 5.5

I would like to know if someone knows how do I export records from filemaker to a txt file (this txt file could be excel, for example) and I would like to choose the columns names.

For example: I have a filemaker file with vehicle data. The fields I would like to export are called: VIN, date, _c24closed, _c48closed, _cOpen

When I export records from these fields and when I open using excel the column names are the same as in filemaker. The problem is that I would like to change the column name the the TXT file. Does someone know how to do it using filemaker , or is there a plug-in I could use to change the column name when exporting the records ?

Share this post


Link to post
Share on other sites

I'm not sure I followed what you are trying to do. If this isn't wat you want, maybe a little different approach to the question would be in order.

If you use the merge format for exporting a file, the field names will also be exported.

HTH

Lee

smile.gif

Share this post


Link to post
Share on other sites

I make this as follows:

- export format: tab text

- found records are sorted by serial number

fist I do a (scripted) find

now I add a record by script. serial number -1 (or 0)

Each collumn of this record will be set to eport field name by script

sort by serial number

export records

delete first record (with serial number -1 [or 0] )

Share this post


Link to post
Share on other sites

I make this as follows:

- export format: tab text

- found records are sorted by serial number

fist I do a (scripted) find

now I add a record by script. serial number -1

Each collumn of this record will be set to eport field name by script

sort by serial number

export records

delete first record (with serial number -1)

Share this post


Link to post
Share on other sites

Lee Smith ,

Thanks.

I would like to export the records and the field names, but not the names as they are but instead of the names in filemaker I would like to change them while exporting. The names in filemaker are good for programmers to understand. The TXT files are going to be sent to some users and the names aren't so good for their understanding.

Share this post


Link to post
Share on other sites

Well, that was the way I understood it the first time, but It make a little more sense when I read the two of them.

You could do this in a couple of ways.

1). Create a second database for import/export where you can match the current database names up with the new field names and then export that as a merge file, or

2) Create a second field for each existing field you will be exporting and use those for your export as a merge file. BTW, you can populate these new fields with your existing data by using calculations, or a looping script.

Does that make sense to you.

HTH

Lee cool.gif

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.