I want to copy the list of all my fields into an Excel or Word file.
How may I copy the list of my 4,000 field names from the File ->Manage ->Data list?
OMG! You have a single table with 4000 fields? Why?
Anyway... there are Design Function calculations such as
which can help, but you are likely to hit some limits when trying to create a layout and move all fields to it in the layout wizard.
A more round-about approach might be to select all fields in the Define Fields dialog, and use Print (but output to PDF if your OS allows that). Then open the PDF, copy all, paste into a text document, and import that text doc as Tab-separated text back into a FM file. You can then go through the records removing the lines/records which are not actual field names, and use a calc to return LeftWord (field1 ; 1 ) to get the field names, assuming they were properly formatted without spaces. Export that to Excel if you still need it in Excel once you have it in FM.
Not simple, but for 4000 fields, the fastest way I can think of to do it.
Another idea would be to run a Database Design Report (DDR) if you hae FileMaker Advanced. Just do the fields, and then you have an HTML list of fields. Don't know if that will serve your needs or not, just a thought.
Run the DDR (If you have FMAdvanced) and choose XML for the export. You can run the report for just the fields.
You can also apply an XSLT to import this back into FileMaker. I believe this is what BaseElements does. http://www.goya.com.au/baseelements
I create my own XSLT.
Why do I have so many? They are mostly Calculation fields. I am researching textbooks and have downloaded them in a text fields. I am counting occurances of certain terms.
I tried your idea. and got a list of the fields in Excel. but each field takes up about 10 fields. I am trying now to condence them intoo one field and get them alphabetized. Any idea about excel?
Thank you so much for your help. wowl
Thank you I figured it out. Thank you so much.
I just thought of another way to get the field names. Export (from the table -TO) all the fields and one record (can even be blank). Choose the MERGE format. this gives you a Comma-separted Values file with the added bonus of the FIELD NAMES in the first row. Change the .mer to .csv for the docuement and open in Excel.
How'd you do it?
David, I did great. I ran a Database Design Report (DDR) and got an HTML list of fields. then I copied and pasted in excel and finagled excel to get it right.
Thanks to all.
Thanks Beverly. Wht is table-TO?
Table is the structure of the data (fields/columns). When placed on the relationship graph it's typically called Table Occurrence (aka "TO"). Since you are getting the field names, either applies. Rather than using field on a layout tied to a TO, select all the fields from that table/TO.
-- sent from my iPhone4 --
The merge file option works well but Excel has a 256 column limit. What I do is select 1 record, or a blank record and then export all fields to a merger file format. You can save time by specifying a filename with a .txt extension if you are working in Windows even though you select the merge file export format. Then open the text file in your favorite word processor or text editing file and use the "replace" menu option (generally under the edit menu) to replace all commas with paragraph designators. You can see these latter symbols in Word, for example, by turning on the show format option. Then copy and paste the paragraph symbol into the replace box The resulting file will be a list of field names, each in its own paragraph (you will have to delete any rows of data that you exported - these will occur below the list field names. You can then use the sort option in your word processor, which should sort the paragraphs in alphaberical order. Better yet, import the text file back into a new FileMaker file and sort it there. No need to use Excel for something FileMaker does better.
I recommend to take a look at
You will get a tab-delimited list with field name, field type, and number of repetitions, or just the name.
Karl is correct. The post was for Excel or Word format. The Merge is CSV with the field names in the first "row" (return-delimited). 400 fields would certainly exceed this limit for Excel!
If the file is saved and the extension changed to .txt (as another reply suggested), the values would be comma-separated, but in a text-editor (or Word), would just display without the "columns".
field1, field2, field3, ... , field400
<<empty data goes here>>
Perhaps that's the trick needed: export as merge format (one dummy record), change extension to .txt and open with Word.
In the FileMaker export options, you can specify a merge file format but explicitly add the .txt extension to the name of the export file (filename.txt). FileMaker will then export the file as a merge file (which is one of many "text" file formats) but automatically uses a .txt extension. The advantage of this is that you do not have to manually change the file extension from .mer to .txt. Word and other text-processing programs will generally automatically recognize the .txt extension as a valid format that can be read but do not always recognize .tab or .mer, files as text tiles unless you explicitly tell them to show all file types in the Open File dialog box. Again, once in Word, you can use the replace option to replace commas with paragraph returns to get a list of names. You will also have to do another sweep through the file to replace quotations with a null character. You should be able to process a 4,000 record file in a few minutes. Some bare-bone text editors will do this much faster as they are not bloated with the overhead of fancy word-processors such as Word.
Retrieving data ...