Great suggestion Bev. I hadn't thought about the XML method.
I don't usually need to recreate a file, I use an adaption of the method
I described when first creating table from the ERD. I build my ERDs
using OmniGraffle.
Jeff
Beverly Voth wrote:
On 8/15/07 11:40 AM, "Jeff Hough" <[EMAIL PROTECTED]> wrote in whole or in
part:
Hi Peter,
If you are trying to completely remove the possibility of corruption,
then you don't want to copy and paste tables from one file to the next
using FileMaker Advanced.
I figured out a cleaver way, in my mind of course, of quickly creating
tables using a text file. The technique works with FMP 5 and later.
1) Make a list of the fields for a specific table. There is a function
that will help you with this. In FMP 8/8.5/9 you can use the
'FieldNames()' function found in the design function list. Point the
function at a layout that contains all of the fields for a the table
(even the calcs). This will return a <CR> delimited list of the field names.
2) Copy the list of field names to the clipboard and paste them into a
text document.
3) Replace the <CR> with <TAB>. This make the field list on one line. BE
SURE TO HAVE A <CR> AT THE END OF THE FIELD LIST.
4) Save the document.
5) Go into the new solution and import the text document. Select the
option to use the first line as field names.
That's it. It seems like a lot, but once you have done it a couple of
times, you'll get the hang of it.
Yep! It does seem like a lot. Why not just export as .mer (this is CSV with
field names in the first row)? You can create a new FMP files with this kind
of information and as Jeff says, copy/paste the calcs field definitions.
Better yet, export as XML, which gives you the filed TYPES. You can create a
new FMP file with the XML.
--
Jeff Hough * Sitecraft * 503.525.1084 * www.sitecraft.com
Certified FileMaker 7/8 Developer
