Will do. This Thursday is not good due to an interview and a school function but maybe next week.

>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