This Job is to help and simplify a user issuing or adding value to a Gift-Card-Server via letting the user adding all the cards, names, values into an Excel sheet.
The Excel sheet would have 4 buttons on it at the top.
1- Issue Selected (This would send XML for each row in the Excel file that is selected with )
2- Issue To All
3- Reload Selected
4- Reload To All
When pressing the buttons the selected rows would be translated to XML and send to the server and then the response would be parsed to other columns and addeed to the rows.
All variables in the VBA should be variables and not hard coded (Server Address, Port, Location)
This excel file would be used as a template and should be able to be copied.
Include the word BlueMagic in your offer.
This should be a simple project for any one that knows VBA and dont bid above $100.00
Each Row is a seprate send to server
using INET API, InetConnect + InetSend + InetDataReady + InetRecvLine
<ACTION>ISSUE</ACTION> //This value depends on what button is pressed
<LOC>CDR</LOC> //This value is not one of the columns in the excel file and should be a variable in setup page
<TType>Gift</TType> //This value is not one of the columns in the excel file and should be a variable in setup page
<?xml version="1.0" encoding="Windows-1252" standalone="no"?><XML_FILE><RESPONSE><CARDID>8551742002223090</CARDID><RESULT>APPROVED</RESULT><AUTH_CODE>[dac49ae2-98ec-9949-9c35-3549c6b78f55]</AUTH_CODE><AMOUNT>250.00</AMOUNT><BALANCE>250.00</BALANCE><ILOC>CDR</ILOC></RESPONSE></XML_FILE>