2 Replies Latest reply on Mar 25, 2011 6:42 PM by JeremyReddick

    Export: Combine fields?

    JeremyReddick

      Title

      Export: Combine fields?

      Post

      Hello,

      I recently began a new job and I have never used FileMaker before. My employer uses FileMaker Pro 6, so it is an older version. I have begun familiarizing myself with it, as I am the web developer here and make use of databases integration. Unfortunately, the person who set up scripts originally is no longer here and no one here is too knowledgable about them.

      The situation I have come into is that we are exporting data into an XML file. The export is combining fields to make compact ones, but on a manual export for testing purposes, I cannot for the life of me figure out how they are combining fields in the export options. For example, they are combing the fields of StartDay, StartMonth, StartYear, EndDay, EndMonth, and EndYear all into one field called "Date_List" states the range between the combined start date and the combined end date (i.e.: "Sept 17th, 2010 - Oct 10th, 2010"). I have looked around in preferences for application and document, as well as many other areas and I am just not finding anything related to export options.

      In the actual export screen just before exporting it allows me to change the file from which I select fields as well as define the relationships between those files, to choose the character set, whether or not to format the output (radio buttons), and there is a summarize button that when clicked pops up a window that allows me to check or uncheck whether it is summarized by title.

      The main reason I am asking about this is because I do not want the dates combined into one range, but rather a StartDate and EndDate, so I can query the records much more easily for display on our website.

      Thank you for spending the time read this post, I really appreciate it. If any additional info is required, I will try to respond ASAP.

        • 1. Re: Export: Combine fields?
          philmodjunk

          Check for calculation fields defined in the table that combine the data in the form you are seeing. Most likely with FMP 6, these calculation fields are being exported instead of the individual fields. If so, you can open up the script that exports the data and simply update the Export Records script step to export the individual fields instead of the calculation fields that combine the data in this fashion.

          • 2. Re: Export: Combine fields?
            JeremyReddick

            I will have to look into this when I get back to the office on Monday. As far as I can recall though, the Date_List field that I was refercing exists only in the export and no where else. I will check again and look among the databases to be certain. Thank you for a prompt response. I really appreciate it.