Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 2nd January 2002, 15:28
Stephen Ruger's Avatar
Stephen Ruger Stephen Ruger is offline
Member
 
Join Date: Nov 2001
Location: Levittown
Posts: 83
Stephen Ruger is on a distinguished road
Baan: Triton, Baan IV and Baan V - DB: SQL, Oracle, DB2, Informix - OS: Windows 2000, UNIX
Launching Excel from Baan

We can launce Word from Baan. How do we launch Excel?
Reply With Quote
  #2  
Old 2nd January 2002, 16:25
Han Brinkman's Avatar
Han Brinkman Han Brinkman is offline
Guru
 
Join Date: Aug 2001
Location: The Netherlands
Posts: 1,155
Han Brinkman has a spectacular aura aboutHan Brinkman has a spectacular aura about
Baan: All - DB: Oracle/ms-sql/db2 - OS: *nix/windows
More info

Steve,

First best wishes for 2002.

Can you be a bit more specific? Basicly it's the same setup. Do you start it from DEM or do you mean printing to excel?

Kind regards,
Han
Reply With Quote
  #3  
Old 2nd January 2002, 17:44
Stephen Ruger's Avatar
Stephen Ruger Stephen Ruger is offline
Member
 
Join Date: Nov 2001
Location: Levittown
Posts: 83
Stephen Ruger is on a distinguished road
Baan: Triton, Baan IV and Baan V - DB: SQL, Oracle, DB2, Informix - OS: Windows 2000, UNIX
Happy new year to you as well.

I want to kick off Excel from within Baan.
Reply With Quote
  #4  
Old 3rd January 2002, 05:30
EdwinvdBorg EdwinvdBorg is offline
Guru
 
Join Date: Aug 2001
Location: Netherlands
Posts: 514
EdwinvdBorg is on a distinguished road
Baan: 2.2, 3.1, b40, b50, b51, ERP LN FP3, ERP LN FP7, ERP LN 10.2.1 - DB: ALL - OS: ALL
Hi,

Please check with the guys of Nazdaq at http://www.nazdaq.co.il/. They have some cool stuff for data mining that is being frequently by BAAN users.

Regards,

Edwin
Reply With Quote
  #5  
Old 7th January 2002, 17:24
Steve Johnson's Avatar
Steve Johnson Steve Johnson is offline
Junior Member
 
Join Date: Aug 2001
Location: San Diego, CA
Posts: 29
Steve Johnson is on a distinguished road
Baan: BaanERP 5.0c - DB: Oracle 9i - OS: Solaris 2.8
Thumbs up

You do not need to buy anyhthing to launch Excel or Word unless you want capabilities beyond what Baan offers. Set up a printer as follows:
Device: Excel
Device Type: Rewrite File
Locale: (usually ISO-8859-1, but whatever you normally use)

Driver: (blank)
Shell command: (blank)
4GL program: ttstpconv
Argument: ASCII:excel %s
Path: (whatever, but something like ${HOME}/baanrept)
Page length: (wahtever, but something large like 100)

That's it.
Reply With Quote
  #6  
Old 8th January 2002, 19:24
bartbk's Avatar
bartbk bartbk is offline
Junior Member
 
Join Date: Oct 2001
Location: Germany
Posts: 7
bartbk is on a distinguished road
What could be a reason that this detailed instruction produced only standard ASCII file (as normal) and Excel window I have not seen at all?

It is possible that my ttstpconv is destroyed? ;-)

Regards
Bart
Reply With Quote
  #7  
Old 8th January 2002, 22:06
Steve Johnson's Avatar
Steve Johnson Steve Johnson is offline
Junior Member
 
Join Date: Aug 2001
Location: San Diego, CA
Posts: 29
Steve Johnson is on a distinguished road
Baan: BaanERP 5.0c - DB: Oracle 9i - OS: Solaris 2.8
Smile

If your argument is ascii:excel %s then you must be able to start Excel on your PC from Start/Run...excel. If your paths are not set up for this then find what will start Excel from the Start/Run... command field and put that in the argument string.

Example: ascii:d:\Program Files\Microsoft\excel.exe %s
Reply With Quote
  #8  
Old 9th January 2002, 12:58
Ehabos's Avatar
Ehabos Ehabos is offline
Junior Member
 
Join Date: Nov 2001
Posts: 22
Ehabos is on a distinguished road
B2Win - Baan to Excel in one click!

B2Win is a simple and Elegant Add-on that automatically downloads every Baan Report Directly into Excel Word or Notepad, formats it, for you to do additional calculations or editing on the output from the ERP system.

How is it done today?
Many users want to take the data from ERP systems into Excel.
1) Send report output to device "ASCIF"
2) Locate the file on your server and transfer it using FTP to your PC.
3) Launch Excel
4) Read ASCII file, by defining the scope of each column
5) Delete all headers and subtotals from report

Those that do this know it is not fun. In B2Win, this is all done in one click! Just choose device "B2Excel", and data is loaded and formatted in your excel file.


How does B2Win Work?

B2Win is fully installed on the Baan Server, and there is no need to install it on every single PC in the organization. B2Win is a Baan Tools session that uses the capability of Baan Client Server to download the report output from the server to the PC, while copying an Excel or Word Macro to your PC. This Macro is responsible for cleaning the report output and formatting it in a way that it can be used in Excel and Word.

The Excel Macro of B2Win 3.1 has been modified to match any Baan Report with a standard looking layout.

The Word Macro of B2Win 3.1 works in Portrait Mode and Landscape Mode. The Macro prepares a formatted Word document that is easy to modify and edit.


Who can benefit from B2Win?

-Accountants
Download a Baan Report into Excel, add additional surcharges not included in Baan, run a Macro and print the report in a different sorting.

- Material Planners
Analyze certain fields from the item data

- Sales Representatives
Want to download the price list and open sales orders into a laptop before a business trip to a customer.

- Sales Administration
Want to send a Baan document to a customer, but want to do additional editing in Word before sending it.

- Buyers
Analyze pricing of suppliers or edit a purchase order before sending it.
And much more…


Please check our Web Site and feel free to ask for fully operational demo.

Regards,

-Ehab

Last edited by patvdv : 10th January 2002 at 18:46.
Reply With Quote
Sponsored Links
  #9  
Old 9th January 2002, 18:33
bartbk's Avatar
bartbk bartbk is offline
Junior Member
 
Join Date: Oct 2001
Location: Germany
Posts: 7
bartbk is on a distinguished road
I am able to start Excel from Run command, but apart file produced in my home directory nothing more I have achived...

Other ideas?

Regards
Bart
Reply With Quote
  #10  
Old 9th January 2002, 19:49
Steve Johnson's Avatar
Steve Johnson Steve Johnson is offline
Junior Member
 
Join Date: Aug 2001
Location: San Diego, CA
Posts: 29
Steve Johnson is on a distinguished road
Baan: BaanERP 5.0c - DB: Oracle 9i - OS: Solaris 2.8
Question Launching Excel/Word as a device

Let's check your ttstpconv and client connection:
Set up a printer called NOTEPAD as a Rewrite File:
Driver/Shell blank, 4GL Program ttstpconv, Argument ascii:notepad %s, Path ${HOME}/baanrept, uncheck Change Ouput file allowed, Page length 100. Use this devcie and simply print your Device list to it. It should bring up Notepad and your list. If it doesn't, then you should acll Baan and get this process fixed.
Reply With Quote
  #11  
Old 10th January 2002, 00:30
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,028
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Hi Bart,

I checked out that Steve's solution does work.

But maybe Steve can also let us know more info...

If there is any formating feature to be sent with the excel so that we can get the output columns in a good format or specify a delimiter option. I think its easy on unix to get around the delimiters. I have no idea on excel/word etc.

I made another device entry with word and it seems fine to me.
Reply With Quote
  #12  
Old 10th January 2002, 04:06
Steve Johnson's Avatar
Steve Johnson Steve Johnson is offline
Junior Member
 
Join Date: Aug 2001
Location: San Diego, CA
Posts: 29
Steve Johnson is on a distinguished road
Baan: BaanERP 5.0c - DB: Oracle 9i - OS: Solaris 2.8
Smile Excel/Word as Baan device

Word output will be simply text. You can Edit/Select All and change the default font to something like Courier to columnize the data.

Excel reformatting takes a couple of steps, but not hard:
Select colunm "A", the first column. Select Data/Text to Columns,
Delimited/uncheck Tab, check Other (put pipe symbol "|" in Other field), Finish.

If the file just gets to the PC in the same form with delimiters and you import that into Excel/File/Open, Excel will automatically open the Import File Wizard (aabove) and format the file on the fly. Invoking Excel from Baan as a device will not and you have to do that manually. Also note that every 9say) 100 line is an unwanted page heading. This inconvenience is taken care of with products such as B2WIN.
Reply With Quote
  #13  
Old 10th January 2002, 11:07
victor_cleto's Avatar
victor_cleto victor_cleto is offline
Guru
 
Join Date: Aug 2001
Location: Portugal
Posts: 776
victor_cleto is on a distinguished road
Baan: none (B40c4 was last) - DB: Oracle - OS: Linux (RHEL)
Excel/Word output

I agree with Steve. If you print ocassionally to Excel, and since the output is simple text, you must manually define your columns and formats when you open the output.

Now, if you tend to send reports on a regular basis, my preferred way would be build you own custom report or use a SQL statement to output the desired fields with specific field delimiter and then build a Visual Basic macro that imports the report (good way to exerceice your VBasic skills also )

If you tend to use a lot Excel with several reports, go for a commercial program that will ease all these steps and uses the standard reports.
Reply With Quote
  #14  
Old 16th January 2002, 17:26
rwright's Avatar
rwright rwright is offline
Junior Member
 
Join Date: Jan 2002
Location: Missouri, USA
Posts: 11
rwright is on a distinguished road
I have done this with notepad and it works perfectly.
If I try it with Excel or Word, it does the following.
Excel or Word opens up on my W2000 PC. Then 2 error boxes follow. The first states that file "c:\program" is not found. The second states that "files\baan\(temporary file)" is not found. It is obvious that "c:\program files\baan\..." is seen by Word and Excel as two file path names where notepad sees it as one file path name.

Any tips or suggestions?
Thanks in advance.
__________________
Richard Wright
Hussmann Corp.
Reply With Quote
  #15  
Old 16th January 2002, 17:47
Steve Johnson's Avatar
Steve Johnson Steve Johnson is offline
Junior Member
 
Join Date: Aug 2001
Location: San Diego, CA
Posts: 29
Steve Johnson is on a distinguished road
Baan: BaanERP 5.0c - DB: Oracle 9i - OS: Solaris 2.8
Question Launching Excel / Word from Baan

I grabbed a W2000 machine and tried our device "EXCEL" and it worked just fine. "WORD" did also. The 4GL argument is simply "ACSII:excel %s" (without the quotes; ASCII can be upper or lower case).
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
Excel to BaaN ltannous AFS/DDC/OLE: Function servers 1 10th December 2002 18:06
Extract data from Baan into an Excel cell rosalbaperez Miscellaneous 4 13th February 2002 01:39
Fehlerhafte Rabattfindung in C4 Kai's Forum Users Deutsches Forum 2 9th January 2001 00:00


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


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