Recurring CSV Import - Best method for automation and dupe detection?
Not sure where to start, any help appreciated.
I have a web csv I'll be downloading again and again to add records to Filemaker. Currently I:
1. download the csv
2. open it in numbers,
3. delete all the records I've previously added
4. save this as a new csv
5. then import as new records.
With FMP being so advanced, I'm guessing there must be a better way to do this? At the very least, I'd like to avoid re-editing the csv file every time I download it. Best case, I'd love to simply download this file to some kind of watch folder, and have FMP automatically check the file and pull in only the new records.
Am I on the right track with my thinking? Is this doable?
Thanks so much for pointing me in the right direction.