We are having problems with PHP reading an xls file created via a kronos cllient. Something wierd is happening and causing us fits. We've added a plugin for reading xls files, which works on some files, but not on the one we need.

I have written a quick and easy VFP program to upload and read the same xls file and process it. It works. I am wondering if anyone out there has any experience calling a VFP com object or executable from a php script?

My goal with this. Run a php program that calls the Visual Foxpro com or exe. This will pop up the upload script in foxpro, read the xls file and process it into a file PHP can then continue with.

I've searched the web, but I've found little.
Thanks in advance if anyone has any tips.

jdc44--

    I get errors when I try to do this.
    I've basically tried this by cutting and pasting from the manual as a test script and by trying to create a COM object for Visual FoxPro freehand. Each gives me the same error:

    Error Msg: Non Fatal PHP Error: (2) (null)(): Invalid ProgID, GUID string, or Moniker: Invalid syntax at D:\inetpub\wwwroot\test\jdctest.html line 4

    Line 4 would be:
    $word = new COM("word.application") or die("Unable to instanciate Word");

    I've looked in the registry tree for Word and Visual FoxPro. Each has a CLSID directory with a default entry as the ID. This is the GUID refered to in the error above.

    We are windows 2000 running IIS and php 4. Is there something in our php config file that needs setting up?

      Moving to a more appropriate forum...

        Write a Reply...