AnsweredAssumed Answered

Automate SQL query import

Question asked by yodavish on Aug 24, 2018
Latest reply on Sep 10, 2018 by wimdecorte

Hello FM community,


I have some remaining data that I need to import into my solution. I have a query that I use from the Import Records > ODBC Data Source that connects to SQL Server but since the query is so large I run it in batches based on either year or between dates. Is there a way that I can automate this process to go do a list of years(?) or dates(?) so that FileMaker can import the data a bit more efficiently, rather than having me alter the query each time it completes?


Additional information: the SQL server query performs a concatenation on two columns into one field and is able to concatenate multiple of these, delimited by a comma for each unique id.


Thanks in advance!