Jump to content

Exporting single record to text


pubdss
 Share

This topic is 7371 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi,

I'm fairly new to FMP so please bear with me. We have a database that has a large amount of records linked to it. We would like to be able to export info from specific records to text. When I try exporting it now, it exports the field information for all the records. Can I have it do the fields of my choice and do only 1 record? Also, is it possible to export the field name as well as the data within the field? Thanks in advance.

- Greg

Link to comment
Share on other sites

quote:

Originally posted by Gregory Firestone:

Hi,

I'm fairly new to FMP so please bear with me. We have a database that has a large amount of records linked to it. We would like to be able to export info from specific records to text. When I try exporting it now, it exports the field information for all the records. Can I have it do the fields of my choice and do only 1 record? Also, is it possible to export the field name as well as the data within the field? Thanks in advance.

- Greg

Greg, here is what to do

1. Find the record you want to import and isolate it.

I use Isolate so often I created a script and set it as the first displayed script so that I could use a Command-1 keyboard shortcut. The script is simple:

Find All

Omit

Find Omitted

Go to the record and execute the script and now only that record is in the found set.

2. When you execute the Export command, select Merge Text as the export format. This will give you the field names in the first paragraph and the field contents themselves next.

3. In the dialog box with the field selections, move the field names of what you want to the right side box. You can re-order the list of fields if you wish. Then export.

The export will collect the field data you specified in the export dialog from the single record you isolated, and export a text field with two tab-separated paragraphs. The first paragraph holds the field names, the second holds the respective data.

That's it.

If you do this a lot, you can easily script the whole process.

Link to comment
Share on other sites

Moon,

Thank you very much for the very clear and concise how to. It worked like a charm. Suppose you had a database with different 10 records. Is it possible to export several records but not all?

There are three fields that we need. Name, Job Number, and Billing amount. We usually search the records by Job Number. Is there a way I can add multiple records to an export. The workaround is to export each to a different file and then copy and paste text when its all done.

Thanks again for the help.

- Greg

Link to comment
Share on other sites

This topic is 7371 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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