Script for importing and sorting data
Hello, my department gets about 100 tickets per week for various support issues (IT and Maintenance, etc). Tickets come in a form of regular text/html emails and they are always formatted the same and have same keywords, e.g. date, issue, priority, comments, owner etc etc. It's very tiring to enter them manually into our databse. I was wondering if there any way (or if a script could be written) which would just import this information from emails directly into our Filemaker Pro databse? Unfortunately, we can not allow users to enter this information into our database - that's not an option for at this moment.
Thank you very much in advance for your advice.