2 Replies Latest reply on Jun 23, 2011 2:37 PM by philmodjunk

    Automation

    MatthewMackay

      Title

      Automation

      Post

      So.

      We have created a database solution that runs on the iPad 2 with FMGO. The solution allows us to visit places and collect data on the iPad with no internet connection required. 
      At present the people collecting the information return home and when connected to a WiFi signal use the email facility to email the entire database (usually 5-8mb containing 50-80 photos) to us. We then open the database, preview the information in a report format that we have prepared and save it as a PDF. 
      As FMGO does not support preview mode we have come to the conclusion that for us to get the information into a nice PDF we need the databases to be sent to us. 
      What we would like to do is automate the process. If they could press email and from there the process is automated it would be great. Not sure how we would do this though!
      Suggestions?

        • 1. Re: Automation
          TSGal

          Matthew Mackay:

          Thank you for your post.

          Create a script with the following commands:

          Set Variable [ $File ; Value: Get (DocumentsPath) & <filename.fp7> ]
          Send Mail [ Send via E-mail Client; No dialog ; To: <email address> ; (Subject and Message optional) ; $File ]

          In FileMaker Go, the database file is stored in the DocumentsPath.  Therefore, the first line creates a variable ($File) that contains the database file in the DocumentsPath.  In the second step, an email is created that attaches the database file.  The mail application will display, and you must tap "Send".

          Let me know if you need additional clarification.

          TSGal
          FileMaker, Inc.

          • 2. Re: Automation
            philmodjunk

            I think the key question here is how to automate this on the receiving end. I think you'll hit a problem with trying to set up the system to automatically receive and download emailed attachments. This could even be very hazardous to system security as you wouldn't want your system to open/download just any emailed attachment as that could download one type of Malware or another into your system.

            Once you have safely downloaded the attachment, a script could periodically check for the presence of such a file, import the data and then either close and delete or (better practice) move the file to another directory for archival purposes. A file manipulation plug in (Several are offered by third parties) would be needed to make this work.