Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Code & Utilities

User login

Frontpage Sponsor

Main

Google search


Poll
What version of Baan have you installed
Baan IV
30%
FP3
3%
FP4
0%
FP5
1%
FP6
2%
FP7
4%
10.2 (incl. 10.2.1)
3%
10.3
6%
10.4
19%
10.5
29%
Other
2%
Total votes: 94

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #31  
Old 10th November 2005, 12:18
mjpedreira1 mjpedreira1 is offline
Member
 
Join Date: Jan 2005
Posts: 98
mjpedreira1 is on a distinguished road
Baan: B40c4 - DB: Oracle - OS: aix 5.3
Question Probando BaanXL

¿Cómo funciona la función argv$()?

¿Si en la definición del dispositivo, en el campo "4GL program" introducimos ozusfwexcel, por qué pasamos como primer argumento de la función wait.and.activate "ttstpconv"?

FUNCTION MAIN
"input.file = creat.tmp.file$(bse.tmp.dir$())
argument = argv$(3)
wait.and.activate("ttstpconv", argv$(1), input.file, "ASCII", argv$(4))"


Muchas gracias
Reply With Quote
  #32  
Old 10th November 2005, 15:58
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,965
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Sorry, but please post in english in this forum. From just glancing at what ~Vamsi set-up this looks like a device driver. When this script gets called the arguments that are passed from the Baan spooler are as follows:
1 = Name of input (temporary) file containing report - argv$(1)
2 = Name of output file - argv$(2)
3 = Additional arguments (from Device data) - argv$(3)
4 = Specilar parm for ttstpconv (unknown reason) - argv$(4)

Not sure what the "argument = argv$(3)" is for, but the wait.and.activate launches ttstpconv converts filename argv$(1) into a plain ascii format and places the output into the input.file file. Does this answer your question?
__________________
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
  #33  
Old 11th January 2006, 09:32
Kingsto88 Kingsto88 is offline
Senior Member
 
Join Date: Oct 2004
Posts: 208
Kingsto88 is an unknown quantity at this point
Baan: Baan 4, Baan 5 - DB: SQL server, Informix - OS: Windows 2000, HP Unix
question

Hi Mr Vamsi,

Using your program, when i print a report to Excel, does it launch Excel first?
I need a program that just prints report to Excel format without lauching the Excel application and then user have to "save as" into a file.

Best regards and thanks in advance
Reply With Quote
  #34  
Old 16th December 2008, 10:18
kop_son kop_son is offline
Junior Member
 
Join Date: Dec 2008
Posts: 5
kop_son is on a distinguished road
Baan: Baan 4c4 - DB: Oracle10g - OS: sunsolaris
Question Script Problem

Dear Friends,

I have created a session with all 4 forms and copied the script but.

how to/ where to callthe function save.default.values()


Regards
kopson
Reply With Quote
  #35  
Old 16th December 2008, 22:12
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,965
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Check forms.txt file on about 3rd post. These are user defined on the forms. For example:

Code:
Form Commands
------------------------------------------------------------------------------------------------------------------------------------
Bind Type  ¦ Seq. ¦ Activate a           ¦ Menu/Session/Function        ¦ Short ¦ Label             ¦ Sep.  ¦ Button ¦ Execute Save
           ¦      ¦                      ¦                              ¦  Cut  ¦                   ¦       ¦        ¦
-----------+------+----------------------+------------------------------+-------+-------------------+-------+--------+-------------
Form       ¦    1 ¦ Function             ¦ exec.cont.process            ¦  Y    ¦ Continue          ¦ Yes   ¦ Yes    ¦ No
Form       ¦    4 ¦ Function             ¦ preview.report               ¦       ¦ Preview Report    ¦ No    ¦ Yes    ¦ No
Form       ¦    5 ¦ Function             ¦ display.ruler                ¦       ¦ Display Ruler     ¦ Yes   ¦ Yes    ¦ No
Form       ¦    2 ¦ Function             ¦ save.default.values          ¦       ¦ Save Defaults     ¦ No    ¦ Yes    ¦ No
Form       ¦    3 ¦ Function             ¦ load.default.values          ¦       ¦ Get Defaults      ¦ Yes   ¦ Yes    ¦ No
__________________
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.

Last edited by ~Vamsi : 11th November 2009 at 18:31. Reason: Added code tag around the "Form Commands" section
Reply With Quote
  #36  
Old 18th December 2008, 10:11
kop_son kop_son is offline
Junior Member
 
Join Date: Dec 2008
Posts: 5
kop_son is on a distinguished road
Baan: Baan 4c4 - DB: Oracle10g - OS: sunsolaris
Hi, Mark,

have B40c4 but i don't know how to use functions as button
or is it available in B40c4, if yes how to use it, Pls. help.

Regards
kopson
Reply With Quote
  #37  
Old 18th December 2008, 16:04
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,965
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
What you do is put a user defined button on the form. Something like choice.user.x. Then in the on.choice section just put a call to those two funtions.
__________________
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
  #38  
Old 24th June 2009, 10:45
formyvn formyvn is offline
Newbie
 
Join Date: Jun 2009
Posts: 1
formyvn is on a distinguished road
Baan: 5 - DB: SQL - OS: XP
BaaN 5 to Excel

Quote:
Originally Posted by ~Vamsi View Post
Attached is the file for creating the forms. Couple of them are painful :).
Hi Vamsi,

As an user, I have no access into the BaaN server to make any installation nor modification previlige. But I have to do my report in Exel format by downloading data from BaaN 5.

The IT department either shortage manpower or don't care/no what todo. Leaving me suffer with the report in Excel format.

After downloading from BaaN 5 to Excel, I had experienced the following issues:

1. Two coluum from BaaN5 are merged into one coluum of Excel after the downloading from BaaN 5 to XL completed.

2. The order of each coluum from BaaN 5 are changed at XL.

3. Word wrap will not work correctly when I tried to do "auto coluum size"

Please give me a hint of how to do a one time set up on EXCEL side, to save alot of "time consuming" correction in manual mode.

4. I am currently using BaaN 2 Excel software, however, how do I active the "user configuration mode"

5. After downloading files from BaaN5 to Excel, the coluum order were different with the original file from BaaN5

6. There are spacing in the coluum which I can eliminate. Because it will make the characters in the coluum disappear.

7. Alot more of the problem which I wanted to make job more simplerer.

Please help

Million of thanks Vamsi,

formyvn

Last edited by formyvn : 25th June 2009 at 08:56.
Reply With Quote
  #39  
Old 24th June 2009, 12:18
dheerendra_gosw dheerendra_gosw is offline
Member
 
Join Date: Jan 2009
Location: Noida
Posts: 82
dheerendra_gosw is on a distinguished road
Baan: Baan IVc4, Baan 5.0c - DB: Oracle - OS: Window 2003 Server
are u able to export data into excel from baan ???
__________________
Thx,
Dheerendra Goswami
Reply With Quote
  #40  
Old 24th June 2009, 14:14
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,965
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
That is what this complete thread is about - exporting data from baan into excel. Start on the first thread and work your way through.
__________________
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
  #41  
Old 10th November 2009, 04:28
steventay steventay is offline
Senior Member
 
Join Date: Jul 2007
Posts: 173
steventay is on a distinguished road
Baan: Baan IVC4 SP10 - DB: SQL 2005 SP2 - OS: Windows 2003 SP2
can it be use in Baan IV?

what about print to excel?
Reply With Quote
Sponsored Links
  #42  
Old 10th November 2009, 15:06
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,965
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Yes it can be used with baan 4.
__________________
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
  #43  
Old 11th November 2009, 02:48
steventay steventay is offline
Senior Member
 
Join Date: Jul 2007
Posts: 173
steventay is on a distinguished road
Baan: Baan IVC4 SP10 - DB: SQL 2005 SP2 - OS: Windows 2003 SP2
Quote:
Originally Posted by mark_h View Post
Yes it can be used with baan 4.
how to able to use?

can guide me?

thank you.
Reply With Quote
  #44  
Old 11th November 2009, 16:57
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,965
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
I have not used this method so I cannot really help. The only thing I can recommend is starting and post 1 and working your way down following each step.
__________________
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
  #45  
Old 17th November 2009, 10:48
ysovva's Avatar
ysovva ysovva is offline
Junior Member
 
Join Date: Feb 2008
Posts: 22
ysovva is on a distinguished road
Baan: BaaN V - DB: Oracle 10 - OS: NT
BaaN V to Excel

I'm creating EXCEL Multi Sheets reports from BaaN V by using standart BaaN XML functionality. The file can be opened by simple click on it with MS EXCEL.
Create a simple XML spreadsheet within EXCEL.
Use BaaN XML functionality without writing
"<?mso-application progid="Excel.Sheet"?>"
and save the file with xmlWritePretty as *.xls file. It will be opened with MS EXCEL.
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 Off
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Code Management in BaaN IV migramir Tools Administration & Installation 9 6th February 2003 22:20
Baan World Users conference in Orlando chadwickh General Discussion & Chat 7 3rd November 2001 22:55
Availability of Web-Based DEM (Baan Press Release) Pierre B. General Discussion & Chat 0 5th September 2001 06:59
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 20:44


All times are GMT +2. The time now is 22:53.


©2001-2017 - Baanboard.com - Baanforums.com