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
3%
FP7
4%
10.2 (incl. 10.2.1)
3%
10.3
6%
10.4
18%
10.5
30%
Other
2%
Total votes: 98

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #16  
Old 3rd March 2003, 08:50
MihaiC MihaiC is offline
Newbie
 
Join Date: Feb 2003
Location: Bucharest
Posts: 1
MihaiC is on a distinguished road
Baan: BaanIVc4 -
Domains?

Nice work!
I'd like to use this feature for my users.
But I can not find anyware the definitions for
- domain zusfw.dtyp
- question zusfw1400.1.
I am using BaanIV c4.
Thanks in advance.

Mihai
Reply With Quote
  #17  
Old 4th March 2003, 18:49
~Vamsi's Avatar
~Vamsi ~Vamsi is offline
Guru
 
Join Date: Aug 2001
Location: San Diego CA, USA
Posts: 590
~Vamsi will become famous soon enough
Baan: ~*~ - DB: ~*~ - OS: ~*~
zusfw.dtyp
10 num Number
20 str String
30 date Date

zusfw1400.1
Defaults already exist for the report.\nOverwrite?
__________________
~Vamsi
Vamsi Potluru
Baan XL Yet another tool to format Baan output in Excel from Baan Board
This one just happens to be free :)

Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #18  
Old 13th June 2003, 14:27
robertvg's Avatar
robertvg robertvg is offline
Senior Member
 
Join Date: Nov 2002
Location: Hoofddorp / The Netherlands
Posts: 164
robertvg is on a distinguished road
Baan: BaaN IVc4, 5.0c - DB: Oracle 8.1.7 - OS: HP-UX 11.11
There is a demo prog on the Microsoft web that creates a BIFF file:
http://support.microsoft.com/default...b;en-us;150447

Problem is: it is in c++ for the Windows platform.
Anyone willing to cooperate on porting this / building this into BaaNXL ?

regards,
Robert
Reply With Quote
  #19  
Old 13th June 2003, 20:16
~Vamsi's Avatar
~Vamsi ~Vamsi is offline
Guru
 
Join Date: Aug 2001
Location: San Diego CA, USA
Posts: 590
~Vamsi will become famous soon enough
Baan: ~*~ - DB: ~*~ - OS: ~*~
Count me in!

Robert,

Please let me know what direction you want to take. From first looks at the Microsoft website and the program that you quoted, it is Windows specific. Especially in its use of OLE. I have in the past looked at complete standalone programs written in Perl that do this.

The idea of keeping BaanXL completely in Baan is extremely tempting to me. This is the reason why I had in the past chosen not to use the Perl program I quoted. If we can find a program written in C completely without using any APIs specific to a platform, our job of creating the BIFF in Baan would be easy.
__________________
~Vamsi
Vamsi Potluru
Baan XL Yet another tool to format Baan output in Excel from Baan Board
This one just happens to be free :)

Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #20  
Old 13th June 2003, 22:47
~Vamsi's Avatar
~Vamsi ~Vamsi is offline
Guru
 
Join Date: Aug 2001
Location: San Diego CA, USA
Posts: 590
~Vamsi will become famous soon enough
Baan: ~*~ - DB: ~*~ - OS: ~*~
After I wrote the above, went looking for other options. Here is what seemed a simple but elegant solution. To write HTML output, but have an .xls extension. This is described here.

The caveat is that it *may* only work with Excel and not any other spreadsheet program.
__________________
~Vamsi
Vamsi Potluru
Baan XL Yet another tool to format Baan output in Excel from Baan Board
This one just happens to be free :)

Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #21  
Old 14th February 2005, 05:55
juvenile juvenile is offline
Member
 
Join Date: Jul 2004
Posts: 38
juvenile is on a distinguished road
Baan: Baan IVc - DB: SqlServer - OS: Windows
pls clear my doubt

Hai
I have one basic doubt regarding this product.
with out writing any code we can take the report inot excel by creating
a device with attaching monarch excel.exe.
or else any text file u can open in excel.
what is the advantage of this product above the standard excel devise?
pls clear my doubt.

regards
Juvenile
Reply With Quote
  #22  
Old 16th March 2005, 18:31
~Vamsi's Avatar
~Vamsi ~Vamsi is offline
Guru
 
Join Date: Aug 2001
Location: San Diego CA, USA
Posts: 590
~Vamsi will become famous soon enough
Baan: ~*~ - DB: ~*~ - OS: ~*~
Received an email from maurixgr:
Hi:

I want to know if need I some kind of permision from you to use the product?


Thanks


No you do not need any permission. Make sure that the copyright statement is not stripped. Also if you distribute the binaries, you will have to have the copyright statement made available in plain text.
__________________
~Vamsi
Vamsi Potluru
Baan XL Yet another tool to format Baan output in Excel from Baan Board
This one just happens to be free :)

Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #23  
Old 23rd September 2005, 05:09
cuiwenyuan's Avatar
cuiwenyuan cuiwenyuan is offline
Member
 
Join Date: Sep 2005
Location: Shanghai
Posts: 45
cuiwenyuan is on a distinguished road
Baan: B50/B/C,LN - DB: oracle 8i/10g - OS: HP UNIX
about the domain zusfw.dtyp

hi,anybody can help me?
BaaNXL is a nice application for my company,i like it!
but i have some problem in it:
1.how to define the domain zusfw.dtyp?
2.what is zusfw.dtyp.num,zusfw.dtyp.str in the zusfw1400.bc?
3.may i replace all the zusfw.dtyp domain,and create a new domain in package TC(tcmcs.dtyp)?

thank you very much.
__________________
Troy Cui
BaaN V/LN Developer in Shanghai,China
Homepage: http://www.cuiwenyuan.com/baan/
BBS: http://www.xihome.com/ http://www.baanerp.com/
Reply With Quote
  #24  
Old 23rd September 2005, 10:13
cuiwenyuan's Avatar
cuiwenyuan cuiwenyuan is offline
Member
 
Join Date: Sep 2005
Location: Shanghai
Posts: 45
cuiwenyuan is on a distinguished road
Baan: B50/B/C,LN - DB: oracle 8i/10g - OS: HP UNIX
compile error

compile error below images,any body can help me?
thanks
Attached Images
File Type: gif error2.gif (36.1 KB, 66 views)
__________________
Troy Cui
BaaN V/LN Developer in Shanghai,China
Homepage: http://www.cuiwenyuan.com/baan/
BBS: http://www.xihome.com/ http://www.baanerp.com/
Reply With Quote
Sponsored Links
  #25  
Old 23rd September 2005, 18:53
~Vamsi's Avatar
~Vamsi ~Vamsi is offline
Guru
 
Join Date: Aug 2001
Location: San Diego CA, USA
Posts: 590
~Vamsi will become famous soon enough
Baan: ~*~ - DB: ~*~ - OS: ~*~
Quote:
Originally Posted by cuiwenyuan
1.how to define the domain zusfw.dtyp?
2.what is zusfw.dtyp.num,zusfw.dtyp.str in the zusfw1400.bc?
3.may i replace all the zusfw.dtyp domain,and create a new domain in package TC(tcmcs.dtyp)?
1. The definition is a few posts above.
2. Those are specific enum values of the domain defined in 1.
3. Yes you can create the domain in any package of your choice.
__________________
~Vamsi
Vamsi Potluru
Baan XL Yet another tool to format Baan output in Excel from Baan Board
This one just happens to be free :)

Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #26  
Old 23rd September 2005, 18:55
~Vamsi's Avatar
~Vamsi ~Vamsi is offline
Guru
 
Join Date: Aug 2001
Location: San Diego CA, USA
Posts: 590
~Vamsi will become famous soon enough
Baan: ~*~ - DB: ~*~ - OS: ~*~
If there is a compile error I do not see it. Warnings are ok - it indicates that the author was lazy to not have paid attention to things that may come back and bite him some day. Hopefully that day is not today :-).

The short story - if you see lines that say "warning" those are ok. If you see any lines with "error" then you have a problem.
__________________
~Vamsi
Vamsi Potluru
Baan XL Yet another tool to format Baan output in Excel from Baan Board
This one just happens to be free :)

Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #27  
Old 28th September 2005, 11:07
cuiwenyuan's Avatar
cuiwenyuan cuiwenyuan is offline
Member
 
Join Date: Sep 2005
Location: Shanghai
Posts: 45
cuiwenyuan is on a distinguished road
Baan: B50/B/C,LN - DB: oracle 8i/10g - OS: HP UNIX
can not get the report date?

thank you very much for your help.but another 2 problems on this session.

when i use printer "BaaNXL",why i can not get the date?
please see the attachment file 1 and 2.

when select printer "BaaNXL",there is no data in the form fields.

by the way,there are 4 forms is this session.when i click the form one by one,like this form1>form2>form3>form4 or form4>form3>form2>form1, no message. but when click like this step:form1>form3(or form4), the error message display ( picture 3).

thank you in advance.
Attached Images
File Type: gif print_1.gif (11.5 KB, 55 views)
File Type: gif print_2.gif (22.7 KB, 90 views)
File Type: gif print_3.gif (4.8 KB, 39 views)
__________________
Troy Cui
BaaN V/LN Developer in Shanghai,China
Homepage: http://www.cuiwenyuan.com/baan/
BBS: http://www.xihome.com/ http://www.baanerp.com/

Last edited by cuiwenyuan : 28th September 2005 at 11:41.
Reply With Quote
  #28  
Old 28th September 2005, 11:12
en@frrom en@frrom is offline
Guru
 
Join Date: Aug 2003
Location: Belgium
Posts: 1,219
en@frrom will become famous soon enough
Baan: B50B - DB: Oracle 8.0 - OS: Win2k AS
I have actually never looked into this utility, so am not giving you advice specifically for this utility, but more in general...

You mean why the fields are greyed out? Did you define them maybe as display fields? Or maybe you only have read authorization? It is something to do with the definitions... Oh, and I see you have an error "can not reach form"; did you compile all the forms..? And are they linked to the session?

Hope this helps,
En
Reply With Quote
  #29  
Old 28th September 2005, 12:00
cuiwenyuan's Avatar
cuiwenyuan cuiwenyuan is offline
Member
 
Join Date: Sep 2005
Location: Shanghai
Posts: 45
cuiwenyuan is on a distinguished road
Baan: B50/B/C,LN - DB: oracle 8i/10g - OS: HP UNIX
dear en@frrom,thank you for you advice.
I defined them as input fields according to the readme file.
I compiled all the forms.and all the forms were linked to the session?
__________________
Troy Cui
BaaN V/LN Developer in Shanghai,China
Homepage: http://www.cuiwenyuan.com/baan/
BBS: http://www.xihome.com/ http://www.baanerp.com/
Reply With Quote
  #30  
Old 28th September 2005, 12:05
en@frrom en@frrom is offline
Guru
 
Join Date: Aug 2003
Location: Belgium
Posts: 1,219
en@frrom will become famous soon enough
Baan: B50B - DB: Oracle 8.0 - OS: Win2k AS
You also have to make sure that the form standard commands are alright:
the commands like modify record, and list of forms, first, next, last, previous should be on when there are multiple forms. This shall resolve your problem. Add the necessary standard commands to the relevant forms, compile forms and session, and let us know if it's all working fine now...

Good luck!
En
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 08:11.


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