C# app to fill word template placeholders, based on data from excel datafiles
Budget: $750 – $1,500 USD
We do some datalogging of etc. temperature and humidity, and we need to present this data in a report.
Today we have an excel sheet, with some macro/VBS programming (Attached for coding reference Rapportgenerator 1.5.xlsm), to pull data from one excel file per logger (See attached logger data example E708020006E6-20220103104950.xls and E70802000606-20220103102335.xls), process it, generate graphs and insert the data, using placeholders, in a word template (See attached Rapportskabelon 1.1.docx).
That results in a final report in wordfile that we will save as PDF and send to the customer (can be sent to the developer that win the project)
This solution is not good for large amounts of data from large amount of loggers, since excel seem to stall out.
For his reason we would like to have a new solution made.
Requirenments:
- Should be able to do all the things our current excel solution does, but better, faster and more stable. Etc. select what template to use, set the period of data to use for the report etc.
- There should be exception handling on ALL functions, and error messages that make sence.
- Programmed in C# (Sourcecode will be handed over to us)
- Should be able to handle data from 200 loggers, each with up to millions of dataentries (Excel limit is 1.000.000 rows (Maybe store the data from each excel file in a local database for performance/Stability, should preferable be included in the install of the app created, so we dont need to install etc. mySql seperately. Database can be any, as long as it does not require a licens and seperate install and tweak by us. Please ovoid a solution using flat file DB solution etc.)
Future requirenments:
These features are NOT for now, but should be considered, as we will have these features developed by the selected coder at a later time.
- Create and handle multiple projects, etc. put in location, and do mapping for what fields in the file should be used for what placeholder in the word template. Headlines, customer name and address, project name etc.
- Pull data directly from a cloud solution via API
- For now we only use this solution for mapping temperatures, but it could also later on be used to map other things, such as humidity or other things.
Today we have an excel sheet, with some macro/VBS programming (Attached for coding reference Rapportgenerator 1.5.xlsm), to pull data from one excel file per logger (See attached logger data example E708020006E6-20220103104950.xls and E70802000606-20220103102335.xls), process it, generate graphs and insert the data, using placeholders, in a word template (See attached Rapportskabelon 1.1.docx).
That results in a final report in wordfile that we will save as PDF and send to the customer (can be sent to the developer that win the project)
This solution is not good for large amounts of data from large amount of loggers, since excel seem to stall out.
For his reason we would like to have a new solution made.
Requirenments:
- Should be able to do all the things our current excel solution does, but better, faster and more stable. Etc. select what template to use, set the period of data to use for the report etc.
- There should be exception handling on ALL functions, and error messages that make sence.
- Programmed in C# (Sourcecode will be handed over to us)
- Should be able to handle data from 200 loggers, each with up to millions of dataentries (Excel limit is 1.000.000 rows (Maybe store the data from each excel file in a local database for performance/Stability, should preferable be included in the install of the app created, so we dont need to install etc. mySql seperately. Database can be any, as long as it does not require a licens and seperate install and tweak by us. Please ovoid a solution using flat file DB solution etc.)
Future requirenments:
These features are NOT for now, but should be considered, as we will have these features developed by the selected coder at a later time.
- Create and handle multiple projects, etc. put in location, and do mapping for what fields in the file should be used for what placeholder in the word template. Headlines, customer name and address, project name etc.
- Pull data directly from a cloud solution via API
- For now we only use this solution for mapping temperatures, but it could also later on be used to map other things, such as humidity or other things.