This is the first step in a two-step project aimed at integrating payment information from a payment gateway into an online accounting system.
The following represents the scenario required
* A daily CSV report is sent as an attachment from the payment gateway to a single-purpose email address.
* This CSV attachment is to be extracted from the email on a daily basis (email parsing tool?) and the data is loaded into a basic MySQL database
* Once in the database (or on entry), a currency exchange routine is to be applied to the payments according to the currency API of our online accounting system (links with [url removed, login to view] API)
* Once conversion has taken place, the database should automatically send a daily attachment to an email address of our choosing
The is a brief overview of the first step of the project. If you require more information, please feel free to message me.
12 freelancers are bidding on average $183 for this job
We are a team of dedicated, serious and highly experienced developers, 24x7 available, highly interested in your project. Please kindly check your PMB for more details. Thanks