-   Code & Utilities (
-   -   CSV to Bar-Graph Converter Utility (

bhushanchanda 11th September 2015 15:05

CSV to Bar-Graph Converter Utility
3 Attachment(s)
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.

Basic Working

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!

Minimum Requirements

Java Version
Java Version 6 Update 6 or higher.
Baan/LN Version
Should work on any versions of Baan/LN with right functions
i.e. app_start(worktop)/start.application.local(webtop)/ 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.

Have fun!

All times are GMT +2. The time now is 08:11.

©2001-2017 - -