Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
16%
200 - 500 GB
27%
500 - 800 GB
3%
800 - 1200 GB
11%
1200 - 1500 GB
11%
1500 - 2000 GB
14%
> 2000 GB
19%
Total votes: 37

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 28th September 2002, 13:50
kphipps's Avatar
kphipps kphipps is offline
Junior Member
 
Join Date: Mar 2002
Location: Sacramento CA
Posts: 5
kphipps is on a distinguished road
Baan: Baan LN - DB: SQL 2005 - OS: Windows 2003
Post Multiple date formats & currency formats by user.

How to create multiple date formats & currency formats by user.
The following files are required:
1. ntbshell.exe ($BSE\bin)
2. datecurr ($BSE\lib)
3. ipc_info ($BSE\lib)

Steps:
1. edit ntbshell.exe code and change the datecurr file name to datecuxx.
2. after making changes to ntbshell.exe save to a new filename (i.e. xxntbshell.exe)
3. add the line ‘xxbshell s ${BSE}\bin\xxntbshell.exe’ to the ipc_info file.
4. modify the fomats to your liking in datecurr file and save to datecuxx.
5. save all code to the orignal location you found it.
6. Change the bshell name in the BW configuration and login.

Below is a explination of the formats of the datecurr file.
There are the following indexes:
========================
Index Applies to: Line in datecurr starts with:
1 Default Currency of a Company A
3 Format of a Currency C
5 Format of a Date D
7 Format of a Time T
9 Format of a UTC Time U


Actions to take to solve the problem:

Index 1. When searching for the default currency code for a company.
=======================================================
The Default Currency for a company is specified in tools session ttaad1100m000 Companies.
The information is converted to runtime, and dumped in the file $BSE/lib/datecurr, and you will see a line like:

A|589|USD|001|001|

Example
When the format of the Default Currency for company 589 has to be retreived, the bshell looks for a line in datecurr, starting with:

A|589|

The line, read from datecurr, in that case is for example:

A|589|USD|001|001|

A: Means this line specifies the Default Currency of the Company
589: Company
USD: Default Currency

In case there is not a line in datecurr for the Default Currency of a company the following error is logged.

get_format_entry pattern '818' index 1 entry 0 not found

Here:
pattern '818' = indicating company 818
index 1 = indicating it is a line from datecurr, starting with the "A"
entry 0 = always 0 in this case.

so, the line:

A|589|USD|001|001|

is not in datecurr.

To solve this problem add this currency (Generic Unit).
(session ttaad1100m000 Companies)


Index 3. When searching for the format of a currency.
==========================================
The currencies are defined via session ttaad1106m000 Generic Units, as Generic Units.
For example:
Gen.Unit: USD

The format of the currencies (Generic Units) are defined via session ttaad1107m000 Formats by Generic Unit.
For example:
Generic Unit: USD
Format: ZZZZ9

The currencies (Generic Units) are grouped in Format Codes.
A Format Code has a number, for example, Format Code 001.
Each Format Code applies to certain functional areas.

For example:
Format Code 001: Rates Manufacturing
Format Code 002: Rates Trans
Format Code 003: Prices.

The information is converted to runtime, and dumped in the file $BSE/lib/datecurr, and you will see a line like:

C|001USD|USD|ZZZZ9|

Here:

C: Means this line specifies a currency format
001USD: Format Code 001, and currency (Generic Unit) USD
ZZZZ9: The format itself.

In case you get for example the following error message:

get_format_entry pattern '003' index 3 entry 0 not found

here:

pattern = indicating the Format Code, so in this case Format Code 003
index 3 = indicating it is a line starting with "C", so it's about a format of a currency
entry 0 = always 0

So, for Format Code 003 and a certain currency (not know which from the error), the format cannot be found.
This means there is no line for this combination (Format Code 003 and the currency) in the datecurr.

To solve this problem, you have to find out which currency is used at the moment the error is logged, and add the format for this currency as Generic Unit. (Session ttaad1107m000 Formats by Generic Unit).


Index 5. When searching for the format of a date.
=======================================
The line in datecurr, for example:

D|0011|DMY|%02d-%02m-%02y|

An error can be:
get_format_entry pattern '001' index 5 entry 0 not found

where:
pattern '001' = Date format 001
index 5 = indicating it is a line starting with "D", so it's about a format of a date.
entry 0 = always 0


Index 7. When searching for the format of a time.
=======================================



Index 9. When searching for the format of a utc time.
==========================================
For example, line from datecurr:

U|0011||%02H%x%02m%x%02s|
Reply With Quote
Sponsored Links
  #2  
Old 1st October 2002, 16:22
rpura1's Avatar
rpura1 rpura1 is offline
Junior Member
 
Join Date: Jan 2002
Location: California
Posts: 9
rpura1 is on a distinguished road
this is fantastic, they should name the next release after you!!!!
Reply With Quote
  #3  
Old 22nd September 2003, 15:17
richard richard is offline
Senior Member
 
Join Date: Oct 2001
Location: France
Posts: 178
richard is on a distinguished road
Baan: triton 3.2/Baan IV/LN - DB: Oracle 9.2.0.6/informix 31 - OS: HP UX 11.23
And for unix ...

the bshell6.1 is an executable and can't be changed.

Is the only solution, a second baan in a specific envirionment ?

Regards
Reply With Quote
  #4  
Old 22nd September 2003, 17:28
richard richard is offline
Senior Member
 
Join Date: Oct 2001
Location: France
Posts: 178
richard is on a distinguished road
Baan: triton 3.2/Baan IV/LN - DB: Oracle 9.2.0.6/informix 31 - OS: HP UX 11.23
Solution for unix

It's a little far-fetched,

1) bshellu in ipc_info
2) bshellu: cp datecurruk datecurr
3) and a startup session to copy the original datecurr ...

The risk of user connecting during these seconds is low but not null.

regards
Reply With Quote
  #5  
Old 9th October 2003, 16:19
nick_rogers nick_rogers is offline
Senior Member
 
Join Date: Feb 2002
Location: Toronto, Canada
Posts: 249
nick_rogers is on a distinguished road
Baan: BaanIVb2 - DB: Oracle 7.3 - OS: Unix 11
On our new baan server we now will have 3 different companies from 3 different geographic locations...2 comps want the date format (MM-DD-YYYY), the other comp wants the date format (DD-MM-YYYY).

Can this be done using some of the techniques above ??
__________________
NR
Reply With Quote
  #6  
Old 9th October 2003, 18:58
richard richard is offline
Senior Member
 
Join Date: Oct 2001
Location: France
Posts: 178
richard is on a distinguished road
Baan: triton 3.2/Baan IV/LN - DB: Oracle 9.2.0.6/informix 31 - OS: HP UX 11.23
Yes I think so

Here our unix:

#!/bin/ksh
#bshellu utilise pour societes anglaises
. /administration/setenv
cd $BSE/lib
cp datecurr datecurrfr
cat datecurrfr | sed -f /administration/datecurr-sed > datecurr
$BSE/bin/bshell6.1 $*
cp datecurrfr datecurr
# ce cp est aussi fait dans la session de startup #tccom0500m911, datecurr est genere par convert

/baan/app/bse/bin: cat /adm*/datecurr-sed
1,$s/V,/V./
1,$s/9,V/9.V/
1,$s/Z\.Z/Z,Z/g

Regards
Reply With Quote
  #7  
Old 9th November 2005, 15:19
Kozure Ohashi's Avatar
Kozure Ohashi Kozure Ohashi is offline
Guru
 
Join Date: Dec 2003
Location: Tokyo-Otsuka
Posts: 324
Kozure Ohashi is on a distinguished road
Baan: Baan IV c4 SP 19, ERP LN 6.1 FP3 - DB: 10g R2 - OS: Linux SLES 10 64 Bit
Additional change in $BSE/lib/user/u<username> possible

Konichiwa,

to modify the appearance of the date in the menu browser status line to us style, please modify the following lines in the $BSE/lib/user/u<username> file:

old:
dateformat: DDMMYY
datesep:.

(european format)

new:
dateformat: MMDDYY
datesep:/

(US format)

This will show the date e.g. 11/09/2005 (=09-NOV-2005) on the menu browser for e.g. a user working with language 2 on a US System in a company running language 2 in europe and us style using the datecurr solution of this thread.

Please be aware that a convert of "user data to runtime data dictonary" will overwrite this modification.
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
Maintain Generic Units ttaad1106m000 mark_h Tools Development 2 5th March 2004 15:43
Zoom Session for selection bklunder Tools Development 1 27th November 2003 08:25
Different Date Formats in Different Companies Khushro Tools Administration & Installation 5 6th December 2002 23:47


All times are GMT +2. The time now is 04:32.


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