Easy project here. We have a database all set up in Access. We have been having trouble exporting our data table into the correct format. Using Access 2007 but I believe the database is saved in 2003 format.
Our database houses orders and we are trying to export a table then upload them via an xml file.
The entire data/table needs to be enclosed in a <DAZzle> [url removed, login to view] order should be enclosed in a <Package> tag with a counter: Then within each package the follow tags are processed for each order. Status and Description are required, the others should be optional
* Status - Valid values are Success or Rejected
* PIC - Tracking number
* Final Postage - [url removed, login to view] dollar amount
* TransactionDateTime - YYYYMMDDhhmmss
* Description - the order id as specified in AOB. Format should be 'AOB' a space and then the order id.
So this project requires one to simply export our current table in access into the correct xml file. No further database development is needed, most likely a VBA script to export the table to correct format.
Must be quality work completed in a timely manner. More information will be available via Private Chat. Testing during development is highly preferred. Payment will NOT be provided under the assumption of progress.
We will not pay hourly rates and are looking for price-per-job quotes. Pricing can be negotiated based on additional requirements.
Please post your estimate and timeline based on the information above.
38 freelancers are bidding on average $84 for this job
Send me sample XML file and the table format format in Access 2007, so that we can discuss in inbox to set up a time-line and cost of data export. Also let me know the exact volume of data. Thanks and Regards : TUHIN