AnsweredAssumed Answered

Import data to modify existing posts

Question asked by ErikO on Apr 30, 2009
Latest reply on May 4, 2009 by ErikO


Import data to modify existing posts


I would like to import data to modify posts. I get a file from my bank with details about paid invoices. Predefined rows in this file include a refernce number which is my Filemaker invoice number. For those matching invoices I want to set stats to "Paid" and write current date. Here is an example of the file. Rows starting with "20" contains Invoice number in positions marked with red. Is it possible to do this? Maybe I have to pre-process the file fisrt?


01BGMAX               0120040525173035010331P                                  
050009912346          SEK                                                      
20000378351165598                    000000000000010000320000000000010         
25Här är betalning från mig till dig                                           
26Kalles Plåt AB                                                               
27Storgatan 2                        12345                                     
200097012333524963                   000000000000020000320000000000020         


Kind regards

Erik O