Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
33%
Installation Wizard into new VRC
39%
Manual into existing VRC
6%
Manual into new VRC
22%
Total votes: 49

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #31  
Old 13th January 2006, 05:26
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
does not launch excel at all

Hi Mark,

Sorry, but i do not understand you.

I just want a version that does not launch excel at all. But I want it to save the file in excel format. I will email this file to user and the user can just open it with excel without needing to go to Open file wizard to set the delimiter.
ie. it should already be in xls format.

thanks and regards
Reply With Quote
  #32  
Old 12th March 2008, 04:22
jeffersyuan jeffersyuan is offline
Senior Member
 
Join Date: Jan 2006
Posts: 279
jeffersyuan is on a distinguished road
Baan: B4,B50C, LN FP1-FP10 - DB: SQL Server , Oracle - OS: Window , Unix , AIX
"XML" Parameter cannot works!

Hi, Mark,
I found a very strange problem,
If add a "XML" parameter, then the convert problem cannot work.

And if we don't use parameter, then it works.

What's the problem?
__________________
The Simply is The Best
Reply With Quote
  #33  
Old 12th March 2008, 18:18
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,112
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Not sure about your system, but on mine it gives me a message - "Conversion to XML is not support yet." I am on 4c4 and I do not know what is supported on 5 and LN, so I will not be much help.
__________________
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
  #34  
Old 10th November 2009, 03:53
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
any update on this..

i want the export file to open with excel and the delimiter will auto split into cell.
Reply With Quote
  #35  
Old 21st May 2011, 06:09
baan999's Avatar
baan999 baan999 is offline
Senior Member
 
Join Date: Jan 2009
Posts: 248
baan999 is on a distinguished road
Baan: INFOR LN 6.1 FP5/FP7 - DB: SQL 2005 /2008 - OS: WIN 2008
all,

i am using windows operating system.

please send me script for the same.
Reply With Quote
  #36  
Old 4th June 2011, 12:42
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,721
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Script is located at the post from Mark

Quote:
Originally Posted by baan999 View Post
all,

i am using windows operating system.

please send me script for the same.
Hello,
the script is located in the ZIP-File from Mark.

Download and install the file.
Modify for your use as necessary.

Regards
__________________
//Bernd
Reply With Quote
  #37  
Old 18th April 2012, 11:19
RameshS RameshS is offline
Junior Member
 
Join Date: May 2005
Posts: 26
RameshS is on a distinguished road
Baan: SSA LN 6.1 - DB: Oracle 9.1 - OS: Windows 2003
Thumbs down name of the temp file in report.

How to capture the temp report file name. like "tmp055915121_20972.bpf" whether any body tried it successfully.

spooler.fileout etc... not giving any output file name.

thanks
Reply With Quote
  #38  
Old 18th April 2012, 14:27
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,112
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Do you mean spool.fileout - not spooler.fileout? Of course if this is ln then I really cannot help since I am on 4c4.
__________________
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
  #39  
Old 18th April 2012, 17:02
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,721
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
From LN proguide 7.6.0

Quote:
Originally Posted by mark_h View Post
Do you mean spool.fileout - not spooler.fileout? Of course if this is ln then I really cannot help since I am on 4c4.

in LN it's
string spool.fileout(100) Path name for spooler output file.
also.

Regards
__________________
//Bernd
Reply With Quote
Sponsored Links
  #40  
Old 9th January 2013, 15:16
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,355
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi Mark, I am unable to download your attachment. Can you post it back?
Reply With Quote
  #41  
Old 9th January 2013, 21:47
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,112
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
I did not have a problem with downloading the original attachment zip file, but here are the two files it contains.
Attached Files
File Type: doc Sample Device.doc (29.0 KB, 76 views)
File Type: bc tuddcconv2.bc (3.7 KB, 52 views)
__________________
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
  #42  
Old 10th January 2013, 08:08
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,355
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Thanks

Thanks Mark. I will try it
Reply With Quote
  #43  
Old 10th April 2013, 16:15
baanspider baanspider is offline
Member
 
Join Date: Jul 2007
Posts: 69
baanspider is on a distinguished road
Baan: Baan LN - DB: Oracle - OS: HP UNIX
error

Hi experts

After using the script in this thread, i am getting this error
Error -2 during seq.open

Does anyone know how to resolve this?

thanks n regards,
Reply With Quote
  #44  
Old 10th April 2013, 16:23
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,112
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
It means that the file does not exist. Which seq.open - make sure that the file on the client is not in a path with spaces in it.
__________________
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 10th April 2013, 17:13
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,721
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
-2 cannot open the master pty

Quote:
Originally Posted by baanspider View Post
Hi experts

After using the script in this thread, i am getting this error
Error -2 during seq.open

Does anyone know how to resolve this?

thanks n regards,
Hello,

it's a indicator for OS error !
-2 cannot open the master pty

Check directory rights, spaces in filenames, .......

Regards
__________________
//Bernd
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: Sample Qkey Script mark_h Code & Utilities 7 9th December 2013 14:33
Sample AFS code for Baan V DStroud AFS/DDC/OLE: Function servers 2 29th September 2004 16:59
I need to Change the Item Code after creating the production order baanlegend Distribution, Transportation & Warehousing 5 23rd July 2004 11:42
NEW: vbcode CODE extensions patvdv About Baanboard.com 3 13th March 2003 11:19
need sample code for API / AFS rohan_rege AFS/DDC/OLE: Function servers 4 9th September 2002 16:58


All times are GMT +2. The time now is 08:24.


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