Go Back > Forum > Baan SIGs > Code & Utilities

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 65

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 11th September 2015, 15:05
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Join Date: Sep 2012
Location: India
Posts: 2,371
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
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.

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!
Attached Images
File Type: jpg Snapshot1.JPG (51.2 KB, 36 views)
Attached Files
File Type: pdf my_graph.pdf (97.0 KB, 54 views)
File Type: zip (2.05 MB, 62 views)


Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Utility to get current Dollar Rate for Indian Rupees!! bhushanchanda Code & Utilities 16 13th June 2017 14:07
Utility to convert ERPLN reports into CSV file format patwanirav Code & Utilities 3 23rd July 2015 11:56
Progress Bar in Baan IVc4 Ruskin Code & Utilities 1 9th September 2003 01:42

All times are GMT +2. The time now is 20:40.

©2001-2018 - -