I’m new to this forum, so, hello everyone!
There is something I need to achieve but I am not sure how to do it.
We are a small hotel/b&B. We use a property management system to manage our bookings in house, the problem is that some of the reports it produces are very basic. There is an export feature that produces a csv file based on date criteria. I have no control on the export criteria other than that. I cant rename the file during export or where it is saved, there is now dialogue in-between hitting the export button and the file being saved.
What I would like to be able to do is to have a script which recognises the naming convention of the exported file and automatically appends new file data to a different CSV file, so i can then set up a recurring import into Filemaker and do what what I need to do with it.
I see it as 3 different areas:
- Monitor a folder for changes
- Identify the right file name
- Append the file, there will need to be a check for duplicates somewhere, I think I could do this in Filemaker
If anyone has any suggestions it would be appreciated. I have done a bit of scripting, I understand the basics but I’m still at the lower end of the learning curve.
Thanks for any help.
Model: Mac mini
Browser: Safari 536.30.1
Operating System: Mac OS X (10.8)