I want import transactions into PM vouchers using eConnect. I have for simplicity divided this into 3 phases.
1) Generate an XML file in the format required by GP for each transaction. (Not sure on how this will work, hoping to get some help from the 3rd party software's developers to generate this custom file but I'm sure the 'next voucher number' will be an issue)
2) Save the XML to a folder or queue or something it can wait in until a service can pick it up
3) A service of some sort moves the file to eConnect where it is read and imported into GP.
Is this a fair (though simple) representation of this process? Am I missing some fundamental understanding of how eConnect works?
How can I get eConnect to automatically detect a file for import and import it? I have read the manual for eConnect, most of Web Serivce's manual and some of MSMQ's manual, but nothing shows me how to tie them all together. I even created a windows service (XMLwatcher) based on documentation from CustomerSource (it was meant for VS2005, I'm using 2015 so that could be part of it) however, the file just sits there (yes the service was started). I have sent a message to the MSMQ and I can see it in the control screen, in a queue but still, it just sits there.
I know generating the proper file will be trouble too but I don't even know what to do with the file once it is generated, and I need to start somewhere so I was trying to sort of reverse engineer to figure it out. Attached is a sample of the file I generated, I can include the code if necessary though I'm not sure that would help. If I'm not mistaken, the creation of the XML is just that and doesn't affect what happens to the XML file.
<?xml version="1.0" encoding="utf-8"?>
<PMTransactionType>
<eConnectProcessInfo xsi:nil="true"/>
<taRequesterTrxDisabler_Items xsi:nil="true"/>
<taUpdateCreateVendorRcd xsi:nil="true"/>
<taCreateVendorAddress_Items xsi:nil="true"/>
<taPMTransactionTaxInsert_Items xsi:nil="true"/>
<taPMDistribution_Items xsi:nil="true"/>
<taAnalyticsDistribution_Items xsi:nil="true"/>
<taPMTransactionInsert>
<BACHNUMB>TMS</BACHNUMB>
<VCHNUMWK>00000000000185685</VCHNUMWK>
<VENDORID>KENJAC</VENDORID>
<DOCNUMBR>123TEST</DOCNUMBR>
<DOCTYPE>1</DOCTYPE>
<DOCAMNT>5</DOCAMNT>
<DOCDATE>2015-10-01</DOCDATE>
<PRCHAMNT>5</PRCHAMNT>
<CHRGAMNT>5</CHRGAMNT>
<TRXDSCRN>TEST</TRXDSCRN>
<PORDNMBR>Test</PORDNMBR>
</taPMTransactionInsert>
<taMdaUpdate_Items xsi:nil="true"/>
</PMTransactionType>
</eConnect>