CSV to Bar-Graph Converter Utility
Watching a lot of posts regarding Bar-Graph creation in Baan/LN, I thought to develop a generic utility which will be available in any version of Baan/LN.
So, this utility is based on Java but is easily integrated with Baan/LN.
1. A jar file is placed on the server
2. CSV file is created using Baan/LN tools functions
3. Jar file is called with parameter as CSV file name
4. That's it!
I have attached 2 versions of JAR file with this post. One can use whichever required, based on the requirements.
Version 1: (BarGraphGenerator1.jar)
The Bar-Graph is displayed in a window. (Check-Snapshot1.jpeg)
Version 2: (BarGraphGenerator2.jar)
The Bar-Graph can be placed in a PDF file or can be displayed in a window depending upon an additional parameter (Check-my_graph.pdf)
The scripts will explain it pretty well!
Java Version 6 Update 6 or higher.
Should work on any versions of Baan/LN with right functions
i.e. app_start(worktop)/start.application.local(webtop)/client.download.file(HTML UI)
I am generating a CSV with 10 items from whinr100 table with inventory on hand less than 1000 in descending order. The Item Code is 1st column and is considered as X-Axis. On hand is 2nd column and is considered as Y-Axis.
Note that, the separator should be a comma(,). You can modify the jar in case you want another separator or you can even make it a parameter.
All the files are attached as zip. The java source is attached as well.
Any questions, changes, modifications, advancements, improvements are welcomed.
|All times are GMT +2. The time now is 11:26.|
©2001-2018 - Baanboard.com - Baanforums.com