For an upcoming project with Indesign, I am looking for a freelancer or company who can provide a set of solutions.
I have created a Template that has certain fixed elements but a lot of placeholders for variables. These variables will need to be populated from a database, an image folder and an XML file.
In fact, I will be receiving the automatically generated XML files which when imported will populate some placeholders. One of the placeholders that will be populated from the XML file is country. Depending on which country has been chosen, the rest of the placeholders will need to be populated from the database and image folder. For example, if the XML file as the country tag as France, the text of France from the database and the images of France will need to automatically populate the template.
So what I need:
1) MySQL database with an Easy to use GUI. It has to work for both Mac and PC so that is the reason for choosing MySQL. if you have other solutions that can work for both, you are welcome to suggest them.
2)A script or solution that will interact between the database, Indesign and probably the XML file too. I am looking for a solution from the freelancer which will work for both PC and Mac and will automate the process described before.
3)An HTML page with a form that will generate an XML file as a result. I am not sure if this is entirely possible so again I am open to solutions. I will need the generated XML file to have the same tags as the XML file that I already get.
I hope that I have explained myself clearly. I need the project ASAP so I will choose provider on Skill level,Time taken and Price. Please provide examples of previous work wherever possible.