[FX.php List] Any body ever use pyfilemaker?

Mon Mar 5 12:11:14 MST 2012

As a summary to this thread:
I now have a PHP script that inserts records from a txt data file, line by
line (replacing importing), run a nested FileMaker script on the records and
report results to a txt file. An the best part is that this whole process
take 19 seconds where doing the same on a FileMaker Client took about 2-3
mins. This is even with my clunky code.
Thanks for all your help.
John

On 1/13/12 4:10 PM, "Steve Winter" <steve at bluecrocodile.co.nz> wrote:

> Hi John
> 
> Passing variables to a command line application is done using -x xxxxxxx, look
> at the PHP function getopt (http://php.net/manual/en/function.getopt.php)
> 
> Cheers
> Steve
> 
>> Re: [FX.php List] Any body ever use pyfilemaker?
>> Hi,
>> I set up a script to edit records in my FM database, ran if from the terminal
>> command line and it worked!
>> Now on the real task of making a few modular scripts that I can pass
>> variables to. No web server! This is cool stuff!
>> Thanks for the help!
>> John
>> 
>> 
>> On 1/12/12 8:10 PM, "Dale Bengston" <dale.bengston at gmail.com
>> <x-msg://1959/dale.bengston@gmail.com> > wrote:
>> 
>>> John, it's been a long time, but you handle including FX.php in the same way
>>> you would in php from the web. Here's a very-simple example: Create a php
>>> script called my_test.php. In it, put this:
>>> 
>>> <?php
>>> echo 'Hello world!';
>>> ?>
>>> 
>>> Then go to Terminal and type
>>> 
>>> php path/to/my_test.php
>>> 
>>> Š substituting the real path to your php script. You should see Hello World!
>>> in your Terminal window. From there, you can branch out into adapting FX.php
>>> calls to run the same way. All the rules apply - includes, function calls,
>>> instantiating FX objectsŠ. it's all the same. It's just being run separate
>>> from Apache.
>>> 
>>> Dale
>>> 
>>> 
>>> On Jan 12, 2012, at 5:40 PM, John Funk wrote:
>>> 
>>>> Re: [FX.php List] Any body ever use pyfilemaker?
>>>> Dale,
>>>> I forgot to ask, where to I start? Where do I put the FX folder? Anybody
>>>> else run PHP/FX from the command line?
>>>> Thanks
>>>> John
>>>> 
>>>> 
>>>> On 1/12/12 3:34 PM, "Dale Bengston" <dale.bengston at gmail.com
>>>> <x-msg://1959/dale.bengston@gmail.com>
>>>> <x-msg://424/dale.bengston@gmail.com <x-msg://424/dale.bengston@gmail.com>
>>>> > > wrote:
>>>> 
>>>>> Nope. PHP is just another application on your computer, and you can access
>>>>> it from the command line independent of Apache or the www user. That means
>>>>> you can access files and folders outside of your web server root as well.
>>>>> And no permissions headaches!
>>>>> 
>>>>> Dale
>>>>> 
>>>>> On Jan 12, 2012, at 1:32 PM, John Funk wrote:
>>>>> 
>>>>>> Re: [FX.php List] Any body ever use pyfilemaker?
>>>>>> Thanks, Dale but don¹t I need a web server  to host the scripts for FX?.
>>>>>> John
>>>>>> 
>>>>>> 
>>>>>> On 1/12/12 10:58 AM, "Dale Bengston" <dale.bengston at gmail.com
>>>>>> <x-msg://1959/dale.bengston@gmail.com>
>>>>>> <x-msg://424/dale.bengston@gmail.com
>>>>>> <x-msg://424/dale.bengston@gmail.com> >
>>>>>> <x-msg://274/dale.bengston@gmail.com
>>>>>> <x-msg://274/dale.bengston@gmail.com>
>>>>>> <x-msg://274/dale.bengston@gmail.com
>>>>>> <x-msg://274/dale.bengston@gmail.com> > > > wrote:
>>>>>> 
>>>>>>> Hi John,
>>>>>>> 
>>>>>>> Do you know PHP? You can run PHP scripts (including FX.php calls) from
>>>>>>> the command line to get data in and out of FileMaker.
>>>>>>> 
>>>>>>> Hope this helps,
>>>>>>> Dale
>>>>>>> 
>>>>>>> 
>>>>>>> 
>>>>>>> 
>>>>>>>  --
>>>>>>> Dale Bengston
>>>>>>> Streamline Studio, LLC
>>>>>>> www.streamline-studio.com <http://www.streamline-studio.com>
>>>>>>> <http://www.streamline-studio.com <http://www.streamline-studio.com/> >
>>>>>>> <http://www.streamline-studio.com <http://www.streamline-studio.com/>
>>>>>>> <http://www.streamline-studio.com/> >  <http://www.streamline-studio.com
>>>>>>> <http://www.streamline-studio.com/>  <http://www.streamline-studio.com/>
>>>>>>> <http://www.streamline-studio.com/> >
>>>>>>> 
>>>>>>> On Jan 12, 2012, at 9:06 AM, John Funk wrote:
>>>>>>> 
Any body ever use pyfilemaker?
My client is looking for command line access to FileMaker data in batch
modes in and out. I found the page below...
It seems this will work. It is similar to FX in as far as it uses the XML
result method, but no web server needed.
I am not a Python guy so how easy it it to learn?

http://code.google.com/p/pyfilemaker/

Thanks,
John 
_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org <x-msg://1959/FX.php_List@mail.iviking.org>
<x-msg://424/FX.php_List@mail.iviking.org
<x-msg://424/FX.php_List@mail.iviking.org> >
<x-msg://274/FX.php_List@mail.iviking.org
<x-msg://274/FX.php_List@mail.iviking.org>
<x-msg://274/FX.php_List@mail.iviking.org
<x-msg://274/FX.php_List@mail.iviking.org> > >
http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>>> 
>>>>>>> 
>>>>>>> 
>>>>>>> _______________________________________________
>>>>>>> FX.php_List mailing list
>>>>>>> FX.php_List at mail.iviking.org <x-msg://1959/FX.php_List@mail.iviking.org>
>>>>>>> <x-msg://424/FX.php_List@mail.iviking.org
>>>>>>> <x-msg://424/FX.php_List@mail.iviking.org> >
>>>>>>> <x-msg://274/FX.php_List@mail.iviking.org
>>>>>>> <x-msg://274/FX.php_List@mail.iviking.org>
>>>>>>> <x-msg://274/FX.php_List@mail.iviking.org
>>>>>>> <x-msg://274/FX.php_List@mail.iviking.org> > >
>>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>> _______________________________________________
>>>>>> FX.php_List mailing list
>>>>>> FX.php_List at mail.iviking.org <x-msg://1959/FX.php_List@mail.iviking.org>
>>>>>> <x-msg://424/FX.php_List@mail.iviking.org
>>>>>> <x-msg://424/FX.php_List@mail.iviking.org> >
>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>> 
>>>>> 
>>>>> 
>>>>> _______________________________________________
>>>>> FX.php_List mailing list
>>>>> FX.php_List at mail.iviking.org <x-msg://1959/FX.php_List@mail.iviking.org>
>>>>> <x-msg://424/FX.php_List@mail.iviking.org
>>>>> <x-msg://424/FX.php_List@mail.iviking.org> >
>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>> 
>>>> Critical Solution
>>>> Business and Workflow
>>>> Database Consulting
>>>> ph: 612-819-5168
>>>> P  please don't print this e-mail unless you really need to.
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org <x-msg://1959/FX.php_List@mail.iviking.org>
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>> 
>>> 
>>> 
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org <x-msg://1959/FX.php_List@mail.iviking.org>
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>> 
>> Critical Solution
>> Business and Workflow
>> Database Consulting
>> ph: 612-819-5168
>> P  please don't print this e-mail unless you really need to.
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> Steve Winter
> +44 777 852 4776
> steve at bluecrocodile.co.nz
> 
> 
> 
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20120305/6e653e4f/attachment-0001.html