Jump to content

Exporting Field names & Defs


ljm
 Share

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

Recommended Posts

Is there a way to export fields and definitions to another FMP database? I am working with a large flat file and converting it to about 6 tables. I would like to use the fields, types and defs in a format similar to what 8 will provide at HTML, but want it in a db. It will help to manage the mapping of the data from the flat file to table.

Thanks

Link to comment
Share on other sites

if you mean "creating" the fields in the the other files, then you can do it natively in 8, or with FMrobot in 7. You'll need to import the data after the fields are created.

If you just want the info from the DDR to be in a FM file, then you need to write an XSLT to transform the DDR XML grammar into FM import grammar and import that.

Link to comment
Share on other sites

Any programming language that can parse XML (and all of them do now) are good.

You'd have to write a little app that reads the XML DDR, outputs some format (CSV,...) that FM can understand and then you instruct your FM file to import that info.

An XSLT does the same thing: transforming the DDR XML into something FM can import.

This is a good project to either learn XSLT or to fiddle with a programming language that can work with XML...

Analyzer is an off-the-shelf product you can buy if you don't want to do it yourself.

If you're still in FM6 you can also use MetaDataMagic from New Millennium.

Link to comment
Share on other sites

  • 3 weeks later...

if you mean "creating" the fields in the the other files, then you can do it natively in 8, or with FMrobot in 7. You'll need to import the data after the fields are created.

How can I do this natively in FM8? Here's the scenario: I have fields defined in file 1 and want to define them (just their names, no attributes) in file 2, which already has some other fields that I don't want to lose. So how can I import the field names from file 1 to file 2? Is there an easy way to bring in the field definitions (i.e. type, etc) as well? Thanks!

Link to comment
Share on other sites

This topic is 5743 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.