3 Replies Latest reply on Jan 23, 2013 9:43 AM by philmodjunk

    Problem by exporting data in xml

      Title

      Problem by exporting data in xml

      Post

           Hello to All!

           We experience a problem by exporting data to xml format in our project. We have a complex layout structure that contains events-related records. These records are by export to xml in wrong sequence.

           You can see what i mean in the uploaded picture. The sequences in <c_functiontoshow>, <datefrom> and <dateto> are different from the table in FileMaker.

           Came the problem by someone cross too? How can we solve it? It's impossible to edit the export result manual after export operation because of  the large amount of data.

           Thanks in advance!

           Ray Ger

      FM-Error.png

        • 1. Re: Problem by exporting data in xml
          philmodjunk

               Your layout shows a portal--which may have a specified sort order.

               Could you export this data from the context of the portal's table instead of the layout's?

               See if you have a portal sort order specified. If so, temporarily remove that sort order and see if what you see in the portal matches your exported order. If so, try specifying the sort order on the relationship instead of in portal setup...

          • 2. Re: Problem by exporting data in xml

                 Hello PhilModJunk, thank you for your answer! The problem is solved after unchecking the "sort" option in the table setup dialog box.

                 There is another problem that i forgot to mention in my post above. I just uploaded a new picture. Please look at it. The second and third data records in <c_names> are in wrong order whether i check or uncheck the "sort" option of the table. The feature of this "c_names" column is that a new layout is opened after clicking a name data.

                 What caused this problem? Has anyone experiences about it?

            • 3. Re: Problem by exporting data in xml
              philmodjunk

                   I am not sufficiently familiar with xml exports to offer a suggestion. If no one else chimes in, you may want to try this question in TechNet.