FMquestions Posted November 2, 2011 Posted November 2, 2011 Hi, I have a database that is storing people, object, and measurement information. The people's information are actually extracted from a non-FM file via a Perl code. The information is temporarily stored in a .csv file and then imported into the database. I was wondering if it is possible to integrate this Perl code with my FM database. I would like to have the user select the non-FM file and the file path will be send to my Perl code, which will then go ahead and run its course. It seems like you can only select FM file through the database. Any suggestions or help will be greatly appreciated. Thank you.
Bailey Kessing Posted November 3, 2011 Posted November 3, 2011 There are Filemaker plugins for PHP and JAVA, but I don’t know of any for Perl…although a Perl or Python plugin would sure be great. I wish Filemaker would include built in support for JAVA, Perl, or Python. Sure would make Filemaker nearly limitless. What about applescript support executing Perl?
comment Posted November 3, 2011 Posted November 3, 2011 I would like to have the user select the non-FM file and the file path will be send to my Perl code, which will then go ahead and run its course. I believe this can be accomplished using OS-level scripting. Look at the Send Event script step, and also in the Windows Automation section here: http://fmforums.com/forum/forum/30-windows-automation/
FMquestions Posted November 4, 2011 Author Posted November 4, 2011 Thank you for all the suggestions. I am not quite familiar with OS scripting and was not too successful with the Send Event script step. What I did instead was to get the file path and export that information into a text file. I then directed the Perl code to get the file path from the text file. I believe this should work. Thanks.
Recommended Posts
This topic is 4766 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now