AnsweredAssumed Answered

Export tab separated with UTF-8 encoding

Question asked by tackermax on Apr 14, 2017
Latest reply on May 2, 2017 by siplus

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.

Outcomes