Various data integration
With this website users can easily grab data from various places including
- .TXT files
- .CSV Files
- SQL Data (Requires SQLCMD or other modules)
- EXCEL Data (Requires module)
- SharePoint Data (Probably requires modules too) a csv file, sql, excel file (requires module) and other kind of data to enable easy label printing
To create a .csv file on a server that triggers a label print job
Easy to customize
PWSH-LabelWebInterface is an example that shows how easy it is using powershell and DOT NET to create a frontend for users to print labels
Use any web enabled device
Print labels on any device with a web interface, e.g iPads, Chromebooks, Windows, other benefits include centralised management and quick PC setup
Why use this?
Benefits include
- Centralised label print management
- Use print servers, no need to install print drivers on every line operater PC
- Extra redundancy, in case a PC goes down, employee's can print from any web enabled device
- Easy customizeable, the company may have add ons or tracking, integrating should probably be easier from a centralised server rather than installing on every PC
- A langauge IT workers understand, No need to use software from the early 2000's that takes hours to setup
- Uses dot net, powershell, html
Windows
- Windows 10 or later
- Label software that support file triggers
Linux
I would recommend you use Universal Dashboard as setting something like this project up in UD is way faster, and probably a way more secure and centralised way
If the label software used is paid, please read the license agreements, for some software the license may be based on number of computers and not number of printers or users
cd 'PathTo\MainFolder'
Start 'Start-LabelWebServer.ps1
# In Start-LabelWebserver.ps1 change the line below to the ip that should be listened on, and remember to open the port on the firewall
# $WebServerIP = 'http://localhost:8080'
Make sure to read up on security, this method might need to be protected by things like sign in, firewall rules, IP rules or a reverse proxy server
CSV Example shown here, it loads data from a folder, the user inputs basically the name of the csv file SQL Example here, using sqlcmd it graps the id of the table that has the correct data, pwsh then creates a csv file from that data Be noticed, that the gif is outdated, it shows ordernumber instead of print amount. it has been fixed.
Jacob Ochoa for giving a great example on how to start a webserver using pwsh, some of the code has been modified in this project https://gist.github.com/jakobii/429dcef1bacacfa1da254a5353bbeac7
Adam Driscoll for inspiration
W3Schools for all the amazing HTML examples
Reddit, spiceworks and other places where amazing people that share their work, suggestions and examples