I think this is an unusual problem. I have an elaborate FM database with multiple tables, relationships, scripts, layouts, etc. It is on a classified system, but it is not classified. Security will not let me move it to an unclassified system because the tools they use can not verify that it is unclassified. Their tools only allow for ascii text scanning.

So, I am hoping to create an xml file with the DDR in FM Advanced and move the XML file to the unclassified system. Security's tools can read that. I have experimented with it on the classified side, and after I create the XML file, I can not open it with FM Advanced. I would have thought that FM Advanced could read back in a file that it has created with DDR.

Does anyone have any ideas? Do I have to create a style sheet (which I don't know how to do) or is there something I just am missing?

Try saving the DDR as HTML, then it can be read with a web browser.

Vaughan,

Thanks for the response.

If I save is as HTML, though, can I then read it into another unclassified system, or are you just saying that it will be easier to follow when I put it in again by hand? What I am looking for is a way to port the database into another system.

There are several things I can do to make it a little easier to move the data. For example, I could paste field definitions into excel, and then copy past them, etc., but I am looking for a way to preserve all my layouts, scripts, definitions without having to type them in again.

I don't know of a tool that would take a DDR and reconstruct the actual file/s out of it. The closest thing (I think, haven't used it myself) may be myFMbutler Clip Manager:

http://www.myfmbutler.com/index.lasso?p=422

I am not sure what your security requirements are (why would they allow you to take the same thing out in one form, but not in another?) - perhaps you could simply encode your .fp7 file to plain text (as in a mail attachment) and decode it back on another system.