1 2 Previous Next 17 Replies Latest reply on May 2, 2017 6:58 AM by siplus

    Export tab separated with UTF-8 encoding

    tackermax

      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.

        1 2 Previous Next