[FX.php List] Re: FX.php_List Digest, Vol 129, Issue 1
Gary Frieders
gfried at sonic.net
Thu Jul 9 15:49:51 MDT 2015
Is there a version of FX.php that works with FMP 13 and/or 14?
Thanks
Gary Frieders
> On Jul 9, 2015, at 12:54 PM, fx.php_list-request at mail.iviking.org wrote:
>
> Send FX.php_List mailing list submissions to
> fx.php_list at mail.iviking.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://www.iviking.org/mailman/listinfo/fx.php_list
> or, via email, send a message with subject or body 'help' to
> fx.php_list-request at mail.iviking.org
>
> You can reach the person managing the list at
> fx.php_list-owner at mail.iviking.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of FX.php_List digest..."
>
>
> Today's Topics:
>
> 1. Re: [REMINDER] CWP User Group at DevCon 2015 (Bob Patin)
> 2. Search Results To Text File (VanBuskirk, Patricia)
> 3. Re: Search Results To Text File (Joel Shapiro)
> 4. Re: Search Results To Text File (Steve Winter)
> 5. RE: Search Results To Text File (VanBuskirk, Patricia)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 29 Jun 2015 16:10:19 -0500
> From: Bob Patin <bob at patin.com>
> Subject: Re: [FX.php List] [REMINDER] CWP User Group at DevCon 2015
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Message-ID: <2BDBDB76-8CCB-4666-A7EF-9921DFA50121 at patin.com>
> Content-Type: text/plain; charset=utf-8
>
> You'll be missed, Chris; know that you'll be well-represented, at least programmatically if not vertically!
>
> (Chris is VERY tall)...
>
>
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> FileMaker 9, 10, 11, 12 & 13 Certified Developer
> http://www.longtermsolutions.com
> -
> iChat: bobpatin at me.com
> Twitter: bobpatin
> —
> FileMaker Consulting
> FileMaker Hosting for all versions of FileMaker
> PHP • Full email services • Free DNS hosting • Colocation • Consulting
>
>> On Jun 29, 2015, at 4:09 PM, Chris Hansen <chris at iViking.org> wrote:
>>
>> Thanks, but I won't be at DevCon this year.
>>
>> That said, the current changes won't affect your existing code, and they're still in the development branch (there's a pulldown for the desired branch on github.) I did just add a feature today -- all script-related functions functions (there are three) now have an optional second parameter for passing a script parameter to FileMaker. I would really like some feedback on whether people encounter problems with this development release, and ON THE DOCS. The Documentation directory can easily be opened without installing anything on your server -- it's just HTML/CSS/JS. I think it's a huge step up, but I'd really like some feedback from some impartial third parties. =)
>>
>> Next year, I AM hoping to be at DevCon. My plan is to have FX.php 7.1 ready by then (this will be a modernized version that requires a 5-something version of PHP.) I'll add some functionality, including configuration of object defaults via .ini files (no more having to tweak default values inside FX.php).
>>
>> Also next year, I'm planning to have my MVC framework ready. The view part of this framework is pure HTML -- i.e. NO embedded PHP in the files, AT ALL. (This means that even web browsers will render them beautifully.) I'm really excited about KeenMVC.
>>
>> Anyway, enjoy DevCon this year!
>>
>> Best,
>>
>> --Chris Hansen
>>
>>> On Jun 29, 2015, at 12:30 PM, Ness, David <dness at bondedbuilders.com> wrote:
>>>
>>> Perhaps we can have Chris Hansen fill this time with a description of his latest efforts he mentioned in his post of 6/22/2015 to this list.
>>>
>>>
>>> David Ness
>>> FileMaker & Web Applications Developer
>>>
>>> Bonded Builders Warranty Group
>>> St. Petersburg, Florida USA
>>> 800-749-0381 x4923
>>>
>>> -----Original Message-----
>>> From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Joel Shapiro
>>> Sent: Monday, June 29, 2015 2:09 PM
>>> To: FX.php Discussion List
>>> Subject: [FX.php List] [REMINDER] CWP User Group at DevCon 2015
>>>
>>> Hi All
>>>
>>> Just a reminder that the CWP User Group is coming up -- three weeks from today(!)
>>>
>>> We may have an open spot so please let me know if you have anything you'd like to share.
>>>
>>> Monday, July 20 (keynote is Tues a.m.)
>>> 4:00 - 6:00 p.m.
>>> Room: Mont-Royal 2
>>>
>>> Looking forward to seeing (some of) you soon!
>>>
>>> Best,
>>> -Joel
>>>
>>> http://jsfmp.com/cwp-user-group
>>>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
>
> ------------------------------
>
> Message: 2
> Date: Thu, 9 Jul 2015 19:21:01 +0000
> From: "VanBuskirk, Patricia" <pvanbuskirk at fsu.edu>
> Subject: [FX.php List] Search Results To Text File
> To: "FX.php_List at mail.iviking.org" <FX.php_List at mail.iviking.org>
> Message-ID:
> <7731A5AA5FC88D48831221524FB9D8901C460E1D at fsu-exch-nwr03.fsu.edu>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi Group!
>
> Is there a way, using fx.php to create a csv text file of search results on the FM or web publishing server?
>
> Example of how we need the results,
>
> "FSU01","TSR0002216","Information Technology Services (ITS) - ","TSR","OTC","OTC","2","OPEN","","07/06/2015","07/06/2016"
> "FSU01","TSR0002316","Arts & Sciences College of - ","TSR","OTC","OTC","2","OPEN","","07/08/2015","07/08/2016"
> "FSU01","TSR0002916","Information Technology Services (ITS) - ","TSR","OTC","OTC","2","OPEN","","07/09/2015","07/09/2016"
> "FSU01","TSR0003016","Alumni Association - ","TSR","OTC","OTC","2","OPEN","","07/09/2015","07/09/2016"
>
> We presently have a "script robot" set up that exports a file every 1/2 hour within a FM client. We are trying to get rid of that FM installation and automate it through php. I was actually trying to run a FM script through FM Server, but it seems export is not a permitted script step for server script scheduling.
>
> Any assistance would be greatly appreciated!
>
> Trish
>
>
> ------------------------------
>
> Message: 3
> Date: Thu, 9 Jul 2015 12:35:36 -0700
> From: Joel Shapiro <mail at jsfmp.com>
> Subject: Re: [FX.php List] Search Results To Text File
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Message-ID: <CA70D175-CF19-40C5-93F7-16E7D30E7700 at jsfmp.com>
> Content-Type: text/plain; charset=us-ascii
>
> Hi Trish
>
> Have a look at PHP's fputcsv function:
>
> http://php.net/manual/en/function.fputcsv.php
>
> HTH,
> -Joel
>
>
> On Jul 9, 2015, at 12:21 PM, VanBuskirk, Patricia <pvanbuskirk at fsu.edu> wrote:
>
>> Hi Group!
>>
>> Is there a way, using fx.php to create a csv text file of search results on the FM or web publishing server?
>>
>> Example of how we need the results,
>>
>> "FSU01","TSR0002216","Information Technology Services (ITS) - ","TSR","OTC","OTC","2","OPEN","","07/06/2015","07/06/2016"
>> "FSU01","TSR0002316","Arts & Sciences College of - ","TSR","OTC","OTC","2","OPEN","","07/08/2015","07/08/2016"
>> "FSU01","TSR0002916","Information Technology Services (ITS) - ","TSR","OTC","OTC","2","OPEN","","07/09/2015","07/09/2016"
>> "FSU01","TSR0003016","Alumni Association - ","TSR","OTC","OTC","2","OPEN","","07/09/2015","07/09/2016"
>>
>> We presently have a "script robot" set up that exports a file every 1/2 hour within a FM client. We are trying to get rid of that FM installation and automate it through php. I was actually trying to run a FM script through FM Server, but it seems export is not a permitted script step for server script scheduling.
>>
>> Any assistance would be greatly appreciated!
>>
>> Trish
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
>
> ------------------------------
>
> Message: 4
> Date: Thu, 9 Jul 2015 20:36:14 +0100
> From: Steve Winter <steve at bluecrocodile.co.nz>
> Subject: Re: [FX.php List] Search Results To Text File
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Message-ID: <E19CDDDA-CA3E-4AC9-9B44-9981BCFFFEFF at bluecrocodile.co.nz>
> Content-Type: text/plain; charset=utf-8
>
> Hi Patricia
>
> There are many different ways to solve this problem ;-)
>
> Which version of FM server are you using…? it’s certainly possible with both 13 and 14 to export records to csv with a server-side script, so this is going to be the simplest way to go about it.
>
> Otherwise either FX or the PHP API could also be used with a scheduled task.
>
> Cheers
> Steve
>
>
>> Hi Group!
>>
>> Is there a way, using fx.php to create a csv text file of search results on the FM or web publishing server?
>>
>> Example of how we need the results,
>>
>> "FSU01","TSR0002216","Information Technology Services (ITS) - ","TSR","OTC","OTC","2","OPEN","","07/06/2015","07/06/2016"
>> "FSU01","TSR0002316","Arts & Sciences College of - ","TSR","OTC","OTC","2","OPEN","","07/08/2015","07/08/2016"
>> "FSU01","TSR0002916","Information Technology Services (ITS) - ","TSR","OTC","OTC","2","OPEN","","07/09/2015","07/09/2016"
>> "FSU01","TSR0003016","Alumni Association - ","TSR","OTC","OTC","2","OPEN","","07/09/2015","07/09/2016"
>>
>> We presently have a "script robot" set up that exports a file every 1/2 hour within a FM client. We are trying to get rid of that FM installation and automate it through php. I was actually trying to run a FM script through FM Server, but it seems export is not a permitted script step for server script scheduling.
>>
>> Any assistance would be greatly appreciated!
>>
>> Trish
>> _______________________________________________
>> 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
>
>
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Thu, 9 Jul 2015 19:54:39 +0000
> From: "VanBuskirk, Patricia" <pvanbuskirk at fsu.edu>
> Subject: RE: [FX.php List] Search Results To Text File
> To: FX.php Discussion List <fx.php_list at mail.iviking.org>
> Message-ID:
> <7731A5AA5FC88D48831221524FB9D8901C460F10 at fsu-exch-nwr03.fsu.edu>
> Content-Type: text/plain; charset="utf-8"
>
> Hi Steve (and Joel),
>
> We are currently using FMS 11Adv, but have plans to upgrade to 14 as soon as budget is approved (as fast a herd of turtles around here).
>
> That robot has been in use using a script running plug-in for years, importing orders from the web, then creating a csv of certain info for our PeopleSoft folks to import into their inventory system (which is why ODBC is not an option). They have very specific formatting that they must have or their import will fail.
>
> Anywho.... I have replaced the import portion of it through FX, but haven’t yet figured out how to do the export part.
>
> Thanks again for your responses!
>
> Trish
>
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Steve Winter
> Sent: Thursday, July 9, 2015 3:36 PM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Search Results To Text File
>
> Hi Patricia
>
> There are many different ways to solve this problem ;-)
>
> Which version of FM server are you using…? it’s certainly possible with both 13 and 14 to export records to csv with a server-side script, so this is going to be the simplest way to go about it.
>
> Otherwise either FX or the PHP API could also be used with a scheduled task.
>
> Cheers
> Steve
>
>
>> Hi Group!
>>
>> Is there a way, using fx.php to create a csv text file of search results on the FM or web publishing server?
>>
>> Example of how we need the results,
>>
>> "FSU01","TSR0002216","Information Technology Services (ITS) - ","TSR","OTC","OTC","2","OPEN","","07/06/2015","07/06/2016"
>> "FSU01","TSR0002316","Arts & Sciences College of - ","TSR","OTC","OTC","2","OPEN","","07/08/2015","07/08/2016"
>> "FSU01","TSR0002916","Information Technology Services (ITS) - ","TSR","OTC","OTC","2","OPEN","","07/09/2015","07/09/2016"
>> "FSU01","TSR0003016","Alumni Association - ","TSR","OTC","OTC","2","OPEN","","07/09/2015","07/09/2016"
>>
>> We presently have a "script robot" set up that exports a file every 1/2 hour within a FM client. We are trying to get rid of that FM installation and automate it through php. I was actually trying to run a FM script through FM Server, but it seems export is not a permitted script step for server script scheduling.
>>
>> Any assistance would be greatly appreciated!
>>
>> Trish
>> _______________________________________________
>> 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
>
> ------------------------------
>
> _______________________________________________
> FX.php_List
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> End of FX.php_List Digest, Vol 129, Issue 1
> *******************************************
>
More information about the FX.php_List
mailing list