AnsweredAssumed Answered

Import data to modify existing posts

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

Title

Import data to modify existing posts

Post

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                                     
28Storåker                                                                     
29005500001234                                                                 
200097012333524963                   000000000000020000320000000000020         

 

Kind regards

Erik O

 

 




Outcomes