I have 12 text fields that I would like to export as as single txt document with one click, is this possible? I seem to be only be able to do this one field at a time that would give me 12 separate txt documents.
Hi Andreas, Im not sure if I am missing something, but the Export option allows all fields to be exported in whatever format you select. If you mean you want them concatenated into one field then exported as a single field - thats different. In the second case, make a new calc field that combines the text from your fileds and then export that. If its the first, File>Export and make sure you move all fields into the export list.
I would indeed like to have the contents of 12 fields exported as a single txt document. I tried this by creating a field and as calculation in this field I added GetField ( StoryCreatonStepOne ), GetField ( StoryCreatonStepTwo ) etc,up till 12.
In a script step I then run the single field that has this calculation, but the exported txt document is empty.
Hi; please look at this thread - it covers much of what you need I think.Exporting Field Contents to a txt file that is pipe delimited issue It also sounds like you are a writer, so maybe the text fields are "longish"? Not sure if container fileds would help you.
Yes! Great thread. An update on versions >= 16
The use of GetField() in the concatenation may be the source of the blank for OP. Just use (example):
Field1 & Field2 & ....
Place delimiter between as desired.
Then “convert” to container and use Export Field Contents on that container. Conversion by any of the methods in my article should work x-plat. I prefer the TextEncode() function for this.
Sent from miPhone
p.s. (edit) the use of List() would put the CR (return - ASCII 13) between the "values":
List ( Field 1 ; Field 2 ; Field 3 ; ...)
Field 1 ;
Field 2 ;
Field 3 ;
Thanks all, but this is all going over my head, I don’t understand most of what I’m reading in those articles. I will leave it by pdf and print exports only for now. Plus I only really need 12 text field contents in case a user wants to copy paste them to another program, and from what I understand are a lot of users doing this anyway. It’s very easy to copy text from the txt fields although not that elegant as having it as an rtf file.
This is a super simple task, but you do need to do a little programming (but not very much).
The challenge is that FMP doesn't give you (still, in version 17) low level file functions where you can manipulate text files. But you have good options:
1. Use a plug-in like MBS. That's a good solution for those who don't have time to learn programming. MBS has done the heavy lifting for you. The Cons of using MBS is that it's FMP only and is not free, but neither might matter.
2. Use a micro-service you write. From FileMaker, just pass the fields you want to write to a file in a return-delimited list to the service. The service logic could then "split" this passed list and quickly write it to any file anywhere on your system. The service could basically do anything you want.
I can help answer any questions you might have.
If you decide to go with option 2, I could even help you write the code in the micro-service (for free).
The beauty of a micro-service is that it works anywhere, with any operating system, on any computer, at any location, with virtually unlimited users. All for free. A micro-service is NOT a plug-in, so ....FileMaker or no FileMaker....a micro-service is totally independent so you can use it with any HTTP-enabled application (an application that can issue HTTP verbs like GET, POST, etc. Terminal, Browser? No problem.). What's not to love?! You Write and Control The Code! (not some third party).
Check out my two micro-service tutorials in the App Innovations Area:
Create Micro-Services Using Java and the Spark Java Framework
The Simplest Micro-Service! (Python and Flask)
So sorry. It sound more like you need the Rich Text Format perserved anyway and most of the exports are going to be plain text from FileMaker.
Maybe I'm misunderstanding your goal, but if the goal is to allow users to copy 12 formatted text fields at once, and iIf you have a calculated text field like the following:
FormattedText = List ( TextField1 ; TextField2 ; TextField3 )
Can you not just have a button with a single step: Copy [ FormattedText ]?
This also would be very helpful, at least Ic an do a paste of all the 12 fields at once. I created a new field in the table and entered this formula as calculation, but nothing is being coped. Is there something I should change still? Thanks!
AllStoryStepsFields = List ( StoryCreatonStepOne ; StoryCreatonStepTwo ; StoryCreatonStepThree ; StoryCreatonStepFour ; StoryCreatonStepFive ; StoryCreatonStepSix ; StoryCreatonStepSeven ; StoryCreatonStepEight ; StoryCreatonStepNine ; StoryCreatonStepTen ; StoryCreatonStepEleven ; StoryCreatonStepTwelve )
Button script: Copy [ Select ; AllStoryStepsFields ]
Is the caluculation showing the correct information? For example: Is the calculation result as TEXT? and is the calculation unstored?
Retrieving data ...