we are using BaaN -IV package, there is no such feature to display the output in a device like excel.

My query is is there any software available to convert ascii formated baan report to excel format?

Hi,
Baan report output in Ascii format can be converted to Excel directly. You don't need any other software as such.

From Excel, File -> Open -> select the Baan Output file. A sef guided Text Import Wizard is opened, which converts the data to Excel format.

Normally, the delimiter for Baan reports is the pile key "|".


regards
Sriks

Hi ,

in Baan VI add an "EXCEL" device with following properties:

Device Type: write to file
Locale: ISO-8859-1
Driver:
Conv.program: ttstpconv
Argument: ASCII:EXCEL.exe %s
Path: ${HOME}/${LOGNAME}.csv
page length: 1 for reports woth just one detail line (or 9999 vor normal reports)

Also, for much more robust functionallity, such as you can set up templates and work out the formatting problems of the more complicated reports, without modifying them, you can look at Nazdaq's B2Win product, which includes B2Excel (as well as others).

You can search this site on B2Win, or check their website at http://www.nazdaq.co.il

Hi

ErpJewels (www.erpjewels.com)
is a product which you may find useful for this.

It uses Baan reports/tables for input and the output can be had in Excel Summary/Pivottable formats with graphs too.

There is another feature which you may find useful, data grouping and classification, that ADDS value to your output

The best part is that using Baan Jobs you can FULLY automate the process, so that users can get appropriate Excel reports on their desktop or on the network, effortlessly.

The website will give you very elaborate details on the utility

Hi,

Yes, I have created the new Device called Excel according to the above mentioned way. But the separator "|" is there and the data is not ported into columns.

I know some of you suggested to get a third party software but is there any way to export the report to Excel and having the data placed into columns without the separator.

Thanks and regards,

we are using BaaN -IV package, there is no such feature to display the output in a device like excel.

My query is is there any software available to convert ascii formated baan report to excel format?

We're using "MONARCH" to analyce ASCII BaaN Reports and convert them to XLS.

Information available at :

www.datawatch.com

Regards

Hello,

See the converter published under my name (richard).
It's a simple awk and excel launch.

Regards

Hi,

I am on windows server and not unix. Can your method be used, ie. is awk available in windows.


thanks and rgds

Hi Richard,

I cannot find your method. Could you please give me a link to it.

thanks and regards

link (http://www.baanboard.com/baanboard/showthread.php?t=6662)

Sorry, I didn't care of windows.
But I know, awk exists on windows. Bull France has converted my script to windows.

Regards

Hi

Do one thing after creating the file open your excel then file open & give the path of the file. Dont open the file directly. Try this & reply

Anish
Hi,

Yes, I have created the new Device called Excel according to the above mentioned way. But the separator "|" is there and the data is not ported into columns.

I know some of you suggested to get a third party software but is there any way to export the report to Excel and having the data placed into columns without the separator.

Thanks and regards,

Hi,

I am on windows server and not unix. Can your method be used, ie. is awk available in windows.


thanks and rgds

Hello Kingsto88,

with the MKS toolkit you are able to use UNIX functions on MS-Platform.

Regards

Hi Kingsto88!

You have to change Windows country settings : Change list separator from Semicolon ";" to Pipe "|"

I am on windows server and not unix. Can your method be used, ie. is awk available in windows.

Cygwin? www.cygwin.com (its Open Source)

Regards
csecgn