Bidding is currently closed for this Project as the Buyer has accepted the bid below.

The Buyer can still choose to reopen the bidding prior to the project listing end date.

Details of the accepted bid

Amount: £ 117.50 Fixed Fee

Proposal:
Hi Derick,

While your project could probably be achieved by macros in MS Word and Excel, I gather you require an application which will read the data file for the [make] and [model] and replace the field name in the template file and save according to the naming convention.

As I understand it, your template file will be a plain text file in html format. Would you require some other management of the generated files (eg selection of records beginning with.. or prices less than..) and/or separation into new directories to help control the number of files. (12500 files to populate in one directory may be a bit inconvenient for the human interaction after the event - obviously not for the computer.)

I would propose a bid of £100 plus VAT to create a simple application (to run on MS Windows 2000/XP/Vista) which will:
1) ask for the source file location in csv format - if you give me a default name it can have that prepopulated to look for that name in the current directory where you're running the merge application.
2) ask for the template file in txt (or html) format - if you give me a default name it can have that prepopulated to look for that name in the current directory where you're running the merge application.
3) ask for basic filter information (ie all, or only those beginning with.. or only those in the range A-C etc) - defaulting to "all"
4) ask for the destination directory (defaulting to the directory where the application is being run) and whether to separate the files generated into new directories A through to Z (or other criteria) and create appropriate folders as subfolders from the specified destination directory if appropriate.
5) replace the [make] and [model] fields in the template file and save under a new name according to the convention you specified.
6) Report final total of files created.

That way you can generically apply new or different templates without being locked into only one option.

If you want to have a vbscript api to automate the reading of the MS Excel file and return the data to the application for processing, I can also add this for an additional £50 plus VAT. Given that you have a very basic (two field) data source and MS Excel's ability to save as csv, it seems a bit unnecessary though, but is an option if you require.

Thanks for your consideration of this bid,
Kind regards,
Simon


Estimated Start Date: Within 1 Business Day