3 Replies Latest reply on Dec 24, 2013 8:39 AM by philmodjunk

    FM 13 WebDirect CSV Export of Unicode text does not work

    gregdc

      Summary

      FM 13 WebDirect CSV Export of Unicode text does not work

      Product

      FileMaker Pro

      Version

      13

      Operating system version

      Window 7

      Description of the issue

      When using the export option in WebDirect with tables containing Unicode data the output is not correct

      Steps to reproduce the problem

      Create a table with a field that contains Unicode data such as a with an ' or a n with a ~. 

      Export the table using CSV or TSV.

      Examine Excel out put

      Expected result

      Data should retain Unicode form

      Actual result

      Data puts garbage characters in place of Unicode test

      Exact text of any error message(s) that appear

      None

      Configuration information

      None

      Workaround

      Export data in HTML, then copy and edit

      Unicode_example_2.PNG

        • 1. Re: FM 13 WebDirect CSV Export of Unicode text does not work
          TSGal

               Greg DC:

               Thank you for your post.

               I am unable to replicate the issue.  Here are the steps I took:

               1. In FileMaker Pro 13, I created a Text field and entered the data:  España Détail

               2. I created a script that exports this field to a CSV file File8.csv using UTF-8.

               3. I duplicated the script, renamed it to File16.csv, changed the file name to File16.csv, and used UTF-16.

               4. I created two buttons that export File8.csv and File16.csv

               5. I clicked both buttons to verify both files were created with the data.

               6. On a Windows 7 machine, I launched Chrome, and accessed the hosted file via WebDirect.

               7. I clicked both both buttons, and both files are created, and when opened in Notepad, the data appears as expected.

               Let me know what I'm doing differently than you so I can replicate the issue.

               TSGal
               FileMaker, Inc.

          • 2. Re: FM 13 WebDirect CSV Export of Unicode text does not work
            gregdc

                 I think I can see one difference right off, you are most likely using the client version of FM13, not the webdirect version.  Could you see if that makes a difference in your results?

                  

            • 3. Re: FM 13 WebDirect CSV Export of Unicode text does not work
              philmodjunk

                   given this line:

                   

                        6. On a Windows 7 machine, I launched Chrome, and accessed the hosted file via WebDirect.

                   TSGal is using a database hosted by WebDirect.

                   You might try creating a small test file from scratch, hosting it and exporting from it to see if you get the same results. If you don't, then you may need to take a closer look at your file to see if you can isolate a cause for this behavior.