Sounds cool, my contact info on http://www.special-orders.com any day but Mon or Thur.

>I don't know the answer to your question but the Wonder Lake byline grabbed my attention. I am in Round Lake, probably 10 miles northeast of you. It's always fun to meet other VFP folks and I would be up for lunch some day.
>
>>I think the answer is a SOAP API. Info here http://www.magentocommerce.com/support/magento_core_api its all new to me.
>>
>>>I'm confused. Is this a web service or a binary API. If it's a web service, the data will come as XML and it won't matter.
>>>
>>>>I am attempting to integrate my VFP P.O.S. with Magento an open source web cart. So far I have mee accessing the MySql database directly but I know the API functions should be quicker and safer. My current issue is with trying to translate the following example code :-S into something usable in VFP.
>>>>
>>>>$proxy = new SoapClient('http://magentohost/api/soap/?wsdl');
>>>>$sessionId = $proxy->login('apiUser', 'apiKey');
>>>>
>>>>$newImage = array(
>>>> 'file' => array(
>>>> 'name' => 'file_name',
>>>> 'content' => base64_encode(file_get_contents('product.jpg')),
>>>> 'mime' => 'image/jpeg'
>>>> ),
>>>> 'label' => 'Cool Image Through Soap',
>>>> 'position' => 2,
>>>> 'types' => array('small_image'),
>>>> 'exclude' => 0
>>>>);
>>>>
>>>>$imageFilename = $proxy->call($sessionId, 'product_media.create', array('Sku', $newImage));
>>>>
>>>>
>>>>var_dump($imageFilename);
>>>>
>>>>
>>>>My attempt
>>>>
>>>>

>>>>local cBitMap, cBitMap1
>>>>cBitMap1=FILETOSTR(STORE.cpicdir-"\product\"-alltrim(positems.mainimage))
>>>>cBitMap=STRCONV(cBitMap1,13)
>>>>
>>>>dimension picfile(3,2)AS ARRAY
>>>>store "name" to picfile(1,1)
>>>>store "aatestpicture.png" to picfile(1,2)
>>>>store "content" to picfile(2,1)
>>>>store cBitMap to picfile(2,2)
>>>>store "mime" to picfile(3,1)
>>>>store "image/png" to picfile(3,2)
>>>>
>>>>dimension typefile(1)
>>>>store "small_image" to typefile
>>>>
>>>>dimension picarray(5,2)AS ARRAY
>>>>store "file" to picarray(1,1)
>>>>store picfile to picarray(1,2)
>>>>store "label" to picarray(2,1)
>>>>store "this is my test image" to picarray(2,2)
>>>>store "position" to picarray(3,1)
>>>>store 2 to picarray(3,2)
>>>>store "types" to picarray(4,1)
>>>>store typefile to picarray(4,2)
>>>>store "exclude" to picarray(5,1)
>>>>store 0 to picarray(5,2)
>>>>
>>>>dimension oArray(1,2) AS ARRAY
>>>>store positems.cupcnumber to oArray(1,1)
>>>>store picarray to oArray(1,2)
>>>>
>>>>
>>>>LOCAL loMage_Api_Model_Server_HandlerPort AS "XML Web Service"
>>>>* LOCAL loMage_Api_Model_Server_HandlerPort AS "MSSOAP.SoapClient30"
>>>>* Do not remove or alter following line. It is used to support IntelliSense for your XML Web service.
>>>>*__VFPWSDef__: loMage_Api_Model_Server_HandlerPort = http://www.fantasyfestival.com/api/soap/?wsdl , MagentoService , Mage_Api_Model_Server_HandlerPort
>>>>LOCAL loException, lcErrorMsg, loWSHandler
>>>>TRY
>>>>	loWSHandler = NEWOBJECT("WSHandler",IIF(VERSION(2)=0,"",HOME()+"FFC\")+"_ws3client.vcx")
>>>>	loMage_Api_Model_Server_HandlerPort = loWSHandler.SetupClient("http://www.fantasyfestival.com/api/soap/?wsdl", "MagentoService", "Mage_Api_Model_Server_HandlerPort")
>>>>* Call your XML Web service here.  ex: leResult = loMage_Api_Model_Server_HandlerPort.SomeMethod()
>>>>	sessionid = loMage_Api_Model_Server_HandlerPort.login("fanfest", "sk1ppy")
>>>>	leResult2 = loMage_Api_Model_Server_HandlerPort.CALL(sessionid, "product_media.create", oArray)
>>>>
>>>>CATCH TO loException
>>>>	lcErrorMsg="Error: "+TRANSFORM(loException.ERRORNO)+" - "+loException.MESSAGE
>>>>	DO CASE
>>>>	CASE VARTYPE(loMage_Api_Model_Server_HandlerPort)#"O"
>>>>* Handle SOAP error connecting to web service
>>>>	CASE !EMPTY(loMage_Api_Model_Server_HandlerPort.FaultCode)
>>>>* Handle SOAP error calling method
>>>>		lcErrorMsg=lcErrorMsg+CHR(13)+loMage_Api_Model_Server_HandlerPort.DETAIL
>>>>	OTHERWISE
>>>>* Handle other error
>>>>	ENDCASE
>>>>* Use for debugging purposes
>>>>	MESSAGEBOX(lcErrorMsg)
>>>>FINALLY
>>>>ENDTRY
>>>>

>>>>
>>>>It logs in just fine the I get the error box with "Error: 1429 - OLE IDispatch exception code 0 from ? : image is not specified.."
>>>>All help would be greatly appreciated. :-U