[FX.php List] Search Results To Text File

[Steve Winter]

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