Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
17%
500 - 800 GB
6%
800 - 1200 GB
6%
1200 - 1500 GB
17%
1500 - 2000 GB
17%
> 2000 GB
22%
Total votes: 18

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 6th August 2008, 09:06
gdwathare gdwathare is offline
Member
 
Join Date: Sep 2006
Posts: 57
gdwathare is on a distinguished road
Baan: BaaN4 - DB: oracle - OS: Unix
Unhappy Baan Report in .csv format
Baan: iBaanERP 5.0b
C/S: None/Unknown

The baan report output is in excel format. I just want it in .csv format.
How to configure baan report in comma separated format?
plz reply asap
Reply With Quote
Sponsored Links
  #2  
Old 6th August 2008, 10:07
abattoir abattoir is offline
Senior Member
 
Join Date: May 2008
Location: Milwaukee
Posts: 116
abattoir is on a distinguished road
Baan: baan4c4 - DB: Oracle 9i - OS: Unix
all u have to do is save the excel file in CSV Fromat(comma delimited).
This option will come when u will "save as" the one excel file u have, there it will ask u for "save as type" here u will have to select CSV Format.
Reply With Quote
  #3  
Old 6th August 2008, 11:03
gdwathare gdwathare is offline
Member
 
Join Date: Sep 2006
Posts: 57
gdwathare is on a distinguished road
Baan: BaaN4 - DB: oracle - OS: Unix
I know that option but I want directly the output in .csv format without using that excel's option. My requirement is whenever you will run the report output should be in notepad and comma separated format.

Thank you so much for ur quick reply
Reply With Quote
  #4  
Old 6th August 2008, 11:48
pconde pconde is offline
Senior Member
 
Join Date: May 2002
Location: Belgium
Posts: 161
pconde is on a distinguished road
Baan: BaanIVc4, BaanERP 5.0, ERP LN6.1 - DB: Oracle, informix, DB400 - OS: unix, As400, windows 2003
Hi,

you have two options

1) create a report with only detail and put therein different field needed with a comma as separator, output report to ascii file (Device ASCIF) and save it. Potential problem some blank characters in the fields

2) create a session where you read the data and create an ASCII file: see commands seq.open, seq.puts and seq.close. ==> here you can have full control to remove the blank characters.

Regards
Philippe
Reply With Quote
  #5  
Old 18th June 2018, 11:51
AnuKass AnuKass is offline
Member
 
Join Date: May 2018
Posts: 37
AnuKass is on a distinguished road
Baan: 9.2 - DB: sql - OS: windows10
hii..
is there any possible for save the report as txt file using program ??
without using device i want save the report as text file????
Reply With Quote
  #6  
Old 18th June 2018, 13:48
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,122
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Just because you have a report does not mean you have to ask the user to input the device. Just set the device yourself and use one of the options to not prompt the user for the device. One thing you could do is just create an excel report using comma's instead of pipes - open the report as ascif and write it straight to a file.

This http://www.baanboard.com/baanboard/s...ighlight=excel is one example of how to create and excel file. I think there are other options if you search for excel also.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Reply


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 On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Invitation to SSA Global's BaaN User Group Meeting in Bangkok nopadon ไทยฟอรัม 0 12th January 2005 19:25
Urgent help needed in Baan srivatsrs Miscellaneous 0 7th January 2005 15:04
How can I print baan report in XML format? DDQING Tools Administration & Installation 1 12th May 2003 06:56
Segregating tools company 000 vanwinkle Operating Systems & Databases 7 5th February 2002 14:22
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 19:44


All times are GMT +2. The time now is 12:00.


©2001-2018 - Baanboard.com - Baanforums.com