Kind of development: New program from scratch
Description of requirements/functionality: I have medium to large sized spreadsheet of about 500 rows, each containing product information where each row represents a separate product. There is the basic information like, title, image URL, main description, bullet point description (1,2,3 etc) as separate columns.
The data in this sheet needs to be entered into a website page - I already have prepared the bare bones of the HTML template, all that's left to fill in is the product information in its respective positions in the template. I will supply the HTML template code to the programmer.
Of course, copying and pasting each piece of information into the template will take weeks and I've thought of a few ideas, but hit a wall when I remind myself the data will be unique for each cell, that is, for each template!
The HTML code will also be in a cell in the same spreadsheet so it's all within Excel.
So, I need to 'inject' the title, product URL, description columns 1 to 5 in specific places within the HTML code.
I will supply the first batch of product data so it can be tested with the HTML code output. There will be many more thousands to do, so I need something robust to allow me to use independently in the future.
I should also add the the output should be able to be copied and pasted into another file (I tried one particular method in the past where this strangely wasn't possible).
Here is an example of what the HTML template might looks like. This code will go into one of the cells, and the information from the spreadsheet (which is held in their respective columns) will be injected into the right places in the HTML code. So once the program has run, the output should have the template will all the required information.
EDIT *Please contact me and I will send the template you will be working with.
OS requirements: Windows, Mac OS
Jamaal S.100% (8)
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
Please, can you attach the template ? And also, a xls with input data tab and another tab with the rules to be followed on the data processing and HTML generation ?
To save you lots of time you can just use MySQL, PHP and HTML, it'll autogenerate your HTML templates whenever you upload your new Excels to MySQL. it"s that simple
you need to import the data to a store or any other html file..Jamaal S.03 Nov 2016
Please drop me a line and I can send the actual template that will be involved with the project.