We have a set of dialup numbers in a comma separated file. New numbers are added, area codes change and soon we will be removing a block of phone numbers. Once every 24 hours, I have a script that checks the file to see if there has been any modifications. However, if there are, the new numbers would have to be extracted from the file and modified to be in a format Optigold understands and then manually imported through the Maintainence page. The only way I can see to get rid of numbers no longer used would be to go through the list and delete them. I would like to know if there is any automated way to sync this file with the numbers in Optigold without having to manually import the information. We have nearly 4000 dialup numbers, so manual maintainence of these numbers would tend to be rather cumbersome.
You could setup to allow access to the data via XML... then you could have a script that does the synching for you.
Well that is easier that what I was trying to do. I was actually working with the FMFMP50.dll ODBC Interface. I'm looking into the XML documentation on filemaker.com. Is there any good examples of using XML with optigold or filemaker pro?