I'm using FMP Advanced 14.0.6 on a mac OSX 10.11.16.
I created a text calculation for export as tab separated.
I'm exporting with UTF-8 encoding.
However, when I look at the octal dump of the file, I don't see the encoding bit.
0000000 < ? x m l v e r s i o n = " 1
0000020 . 0 " e n c o d i n g = " U T
0000040 F - 8 " s t a n d a l o n e =
0000060 " y e s " ? >
Yes, I am exporting this to look like XML, but actually, due to filemakers limitation to only supporting xslt 1.0, I had to create my xml file as a calculation instead.
When I look at the encoding of the file that I'm attempting to emulate for import, there is an encoding bit "357 273 277" at the beginning. I found online that this is the UTF-8 encoding bit.
0000000 357 273 277 < ? x m l v e r s i o n
0000020 = " 1 . 0 " e n c o d i n g =
0000040 " U T F - 8 " s t a n d a l o
0000060 n e = " y e s " ? >
I tried to just stick that number into the beginning of my calculation, but that didn't work for obvious reasons. Does anyone know if this even matters? Is the UTF-8 encoding out of a filemaker export actually doing anything on tab separated?
The error I'm getting when I try to import into HotDocs is "Error opening the answer file". If I try to put in the encoding bit, I get file corrupt, so I know that I'm at least close.