I have an Excel sheet which contains several different data sheets.
I need this data to be parsed and then documents (invoices) created from this data.
The documents should use different templates I can provide. They are currently in Word however they can be provided in HTML / CSS.
It can either run as a batch process and create lots of documents or have some type of admin where it can be selected which documents to create.
The desired output is PDF's for each document.
This could lead into further work.
I'm looking for someone:
* Advanced PHP experience
* Strong understanding on frontend technologies
* Very savvy with APIs
* Has document conversion experience
* Has worked with Google Doc APIs
* Has experience building finance applications
* Has worked with LDAP
On request I've attached some sample files.
example_data_source.csv shows an example data source. I've highlighted fields in yellow where the data needs to be captured. NOTE: to generate the output you may ideally need read two separate data source files. The other would be a simple one for getting the name, quote of the person. BONUS: connect directly to the API rather than needing to be supplied with data source files.
example_export_template.pdf shows an example template. There are various templates. It'll be necessary to choose which data should be exported using what template type. Ideally it'd be exported as a PDF but also a WORD version.
How do I imagine using this?
A very simple interface where I can easily say which data to point to and it'll generate the reports. BONUS: A review process using the API where it can then also upload the attachment back to the main program.
Thanks! Let me know any questions.
I'm attaching the data source saved as Excel so that the yellow cells I highlighted can be seen.
NOTE: currently this data comes from Saasu.com which does have an API. It would be time saving to connect to this API directly rather than me uploading the CVS files. However if this is the case it would need some type of admin screen where it could select the Biller to pull API data from and generate the reports from.