Here’s an example of one of the source text files. In this case, the input file contained the data “crosstab style”, meaning inventory quantities for each branch were listed in columns going across to the right, but each of these columns would need to be translated into rows in the final format that would be ready to be appended to the database. Because of our history in MS Excel, we nail these kind of data transformation projects. Very easy for us. We’ve done it hundreds of times.
Here’s a look at the user interface for manually modifying data. The client was cost focused, so we put together in MS Access. The back end was stored in MS SQL. To keep costs down, we installed the free version SQL Express and linked it to MS Access. Zero software costs.
The last piece was the Ebay integration. We have experience in many different API’s, including Ebay. For this project, we simply needed to manipulate the database using SQL queries to get the data in the correct format. Then automate the transfer of that query on a nightly basis to Ebay. Fully automated solution.
Our client, wishes to remain confidential, a used auto parts reseller. They contracted with us to build a system that would do the following:
- Crawl FTP sites of their suppliers nightly to get new input files
- Import new files into a database
- Each of the supplier import files would vary, so the system would need to detect which import module should be used to import the file
- Manipulate the data based on mapping tables containing special logic and exceptions
- User interface to manually search, edit, delete or add new parts
Create a file in Ebay’s preferred output and push to ebay.com.