Dear All,

I'm looking for the solutions which will enable export data from Baan IV c4 to MS Excel.
Do you have any info about companies, trial verisons, prices and so one?
Maybe there are some companies in Europe offering such solutions..?

Thanks
Ar-cik

Arcik,

Please have a look in this thread:

http://www.baanboard.com/baanboard/showthread.php?s=&threadid=697&highlight=baan+excel

Parsing reports is nice, but how about an Excel spreadsheet application that allows you to query any tables in Baan? XQL (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=371)

Originally posted by Ar-cik
Dear All,

I'm looking for the solutions which will enable export data from Baan IV c4 to MS Excel.
Do you have any info about companies, trial verisons, prices and so one?
Maybe there are some companies in Europe offering such solutions..?

Thanks
Ar-cik

Document styler from Macroscope allows export from Baan into MS Word and Excel, also allowing formatting options :cool:

I've seen this product working well with MS Word and Excel
more info at http://www.macroscope.co.uk/DocumentStyler1.asp

Hi,
The change required is on the report side. All ur report have to be created using COMMA "," as the seperator between fields, whether header or detail or before.field part.

Next use the standard baan dll i.e. ttstpconv in the Device management. Parameters are as follows:
Device : EXCL
Description: Excel report from BaaN
Device type: Rewrite file
Locale : ISO - 8859-1 (can be different)
4GL Program: ttstpconv
Argument: ascii:\office\excel.exe %s
(Argument) is the path from where ur excel or any MS product starts executing , %s will attach the OUTPUT of ur report to excel.
Once user executes baan report session and selects this device, EXCEL will start and the report will directly displayed in the respective columns
Path: <File path>\<File name>.csv
Note: .csv is important because the deliminter used is , and is recognized by Excel
Change Allowed: Yes
Page length: 9999 (to avoid any row gaps)

Hope this works out and also check out whether u have ttstpconv file

Thnx

We made a simple awk which transform every standard BaaN report in a .csv file with 1 to 3 header and the lines.
The file is created in a shared directory unix/windows. The user has only to clic on the file or open it thru excel.

Regards

hmm....ic....

You can export data in excel ..
Device field argument... monarch \excel.exe
report will be open directly in excel..

You can export data in excel ..
Device field argument... monarch \excel.exe
report will be open directly in excel..

how to do that?

Hi,
You can also try ERP Jewels which is a wonderfull analytics tool developed in baan tools. It not only transforms ur reports to Excel, it can generate useful analysis.

More to this, now this is an open source tool. This works in conjuction with MS office 2000/2003/2007.

Give it a try and you will be amazed how marvelous this tool is.

Vishal

Hi guys,

This is very discussion about pushing data from baan to excel.

But

i have a question, how to pull data from baan while you are in excel. In there any API to get data from baan in excel.

Thanks.