Email to Read and Parse
I'm wanting to pass info from one database to another and thought email would be a likely candidate to do the message passing.
There are remote users who would be creating records in a database that would pass a message to the main data file and add them to a queue for verification and processing. Some of my users are the source for new records, but they aren't always connected to the internet.
I'm thinking PHP and Smartpill would be just the right tools.... Is there a facility for doing this?
any help is appreciated!
bill
sequel to the support request
yeah.... i figured that since I paid for the software, I'd get faster answers from the dedicated support feature instead of the forum.
(btw.... I was correct)
:-)
Thanks for the help... you guys (and this software) RAWK!!
Email to Read and Parse
Hello Bill,
I'm not quite sure I understand exactly what you're trying to do. Are you saying that the remote users would create records in a queue that would wait until an internet connection is available and then send the new records back to the main system?
You can certainly send and receive email with PHP but I'm not sure if this would be the best solution for data syncing. If you can share some more specifics, perhaps I will have some ideas.
Regards,
Micah
final details on getting it working....
i can certainly see how you'd think it's not a great idea..... but I disagree.
;-)
I've almost finished making it all work. A combination of creating an sql statement remotely and transferring it via email to move the ORDER into the database quicker than it's currently being done and reducing the current (manual and tedious) system with an automagic one.
the only problem i'm having now is making the php work in the real database, after having it work just fine in the TestBed. Is there anything I need to know about moving the code to my database? I'm getting parse errors and notices that I wasn't getting when running it in the testbed file.
thanks for the help,
bill
Curly quotes
Hello Bill,
I'm guessing this is the same issue you submitted as a support request?
I thought I'd post the solution here for anyone else that runs into this issue.
FileMaker has a file option to "Use smart quotes" which will make single and double quotes "curly" and this causes a problem for PHP which is expecting straight quotes. The best solution is to turn smart quotes off (at least while you're coding) or you can do your coding in our testbed file and then copy/paste.
Regards,
Micah