3 Replies Latest reply on Jun 5, 2012 2:55 PM by philmodjunk

    Inserting records via automated email processing

    user16619

      Title

      Inserting records via automated email processing

      Post

      I'm pretty new to filemaker.

      I need to automate the insertion of records into a filemaker table.

      Unfortunately, the only means of receiving the data is via email.

      I've tried using the Automatic Email Processing applications out there and all are allowing me to see the email, and extract fields very well. Where they fall down is trying to use an ODBC connection to add the record to the Filemaker table. All of them see filemaker fine, but the SQL Insert statement doesn't get pass Filemaker. (I can specifiy the database name but the Table isn't mentioned.)

      Also, some won't see the 64 bit ODBC driver ... sigh ... and others seem to want to use OLE to get to the DSN name I created with ODBC??

      The alternative is to dump a text file to the network of the extracted fields and import manually from within filemaker. I was hoping to bypass the user intervention.Wink

      Has anyone done something similiar or know of the product that works nicely with Filemaker. Or perhaps it's just my ODBC knowledge that is lacking.

      I am using Filemaker 12 Advanced with Filemaker 12 Server on a Windows 7 64 bit box.

      Many Thanks