AnsweredAssumed Answered

Need to be smarter with data import

Question asked by rickaltman on Dec 14, 2012
Latest reply on Dec 15, 2012 by philmodjunk


Need to be smarter with data import


     I think I have a fundamental misunderstanding of the finer points of importing data. I am constantly frustrated when I try to automate imports of data that cross tables. For instance, if Customer A purchases Widget B and a Wufoo form provides a worksheet with the essential information, I don't know what to do.

  •           Customers and Widgets are stored in separate tables
  •           Even when I succeeded in writing an elaborate script that found Cust A and stored Widg B in a related record, I was confounded if Cust A already had purchased from me (in which case Widg B replaced whatever the most recent product is that was purchased).

     I have had to resort to writing a script with an external macro program that performs an elaborate copy and paste to and from each field in the Wufoo worksheet and in FM.

     As you can see, I just don't get it. What am I missing?? I'm using FMPA12. Many thanks...



     Rick A.
     Pleasanton CA