Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 30th August 2017, 14:15
baan1612's Avatar
baan1612 baan1612 is offline
Senior Member
 
Join Date: May 2007
Location: USA
Posts: 121
baan1612 is on a distinguished road
Baan: Triton, baan 4c4, Baan V, ERPLN 6.1 FP2, FP3, FP6, FP7 and FP9 - DB: oracle - OS: windows 2000
extracting chinese text data
Baan: Other/Unknown
C/S: None/Unknown

Hi,

How can we export the Chinese language text data into a file ?
Reply With Quote
  #2  
Old 1st September 2017, 22:09
vamsi_gujjula's Avatar
vamsi_gujjula vamsi_gujjula is offline
Senior Member
 
Join Date: Nov 2011
Location: hyderabad ; india
Posts: 240
vamsi_gujjula is on a distinguished road
Baan: ERPLN fp3 and 10.4 - DB: oracle - OS: Aix , Redhat linux 6
are you talking abt text field . or as such description fields with Chinese language ??

if its description fields yes you can export using UTF encoding .

I think even text should be possible but never tried it.
__________________
Regards,
Vamsi
Reply With Quote
  #3  
Old 15th September 2017, 13:49
baan1612's Avatar
baan1612 baan1612 is offline
Senior Member
 
Join Date: May 2007
Location: USA
Posts: 121
baan1612 is on a distinguished road
Baan: Triton, baan 4c4, Baan V, ERPLN 6.1 FP2, FP3, FP6, FP7 and FP9 - DB: oracle - OS: windows 2000
Thanks for your reply !

I am able to export, but the outcome comes out to be like this -

北京信邦电子有限公司;;›%Õñ›%ÐË›%·9›%ºÅ;›%²ý›%ƽ›%Çø›%¿Æ›%¼¼›%Ô°›%Çø;;102200;›%±±›%¾©

I have tried UTF encoding functions too.. but doesn't seem working.

Can you give some examples on how to use the UTF encoding functions.
Much thanks !
Reply With Quote
  #4  
Old 15th September 2017, 19:34
vamsi_gujjula's Avatar
vamsi_gujjula vamsi_gujjula is offline
Senior Member
 
Join Date: Nov 2011
Location: hyderabad ; india
Posts: 240
vamsi_gujjula is on a distinguished road
Baan: ERPLN fp3 and 10.4 - DB: oracle - OS: Aix , Redhat linux 6
Our LN is set up for Unicode Mode ... attached the picture

I think a UTF BOM seq is required at beginning of the file ( but not mandatory for all applications)

delimiter is a comma in this case

Code:
function boolean create.file.and.write.header()
{
	string dummy(30) mb 
	fp = seq.open(creat.tmp.file$( bse.tmp.dir$()),"wt+",file)
| 	fp = seq.open("Customer_details_" & dte$() & ".txt","wt+",file)

	if fp < 1 then
		return(false)
	endif
	|BOM
	seq.puts(chr$(239) & chr$(187) & chr$(191),fp)
	
	
	line = concat$(delimiter,
			tt.label.desc ("tctccom100.bpid",ttadv.cont.general,dummy), 
			tt.label.desc ("tctccom100.nama",ttadv.cont.general,dummy), 
			tt.label.desc ("tctccom110.crep",ttadv.cont.general,dummy), 
			tt.label.desc ("gbcom4401m000s01",ttadv.cont.general,dummy), 
			tt.label.desc ("tctcmcs013.cpay",ttadv.cont.general,dummy), 
			tt.label.desc ("tctccom112.crlr",ttadv.cont.general,dummy), 
			tt.label.desc ("tctcmcs143.cste",ttadv.cont.general,dummy),
			get.desc.of.cdf.field("5glk"), 
			get.desc.of.cdf.field("4khd"), 
			get.desc.of.cdf.field("1hyf"), 
			get.desc.of.cdf.field("6qyj"), 
			tt.label.desc ("tctcmcs031.cbrn",ttadv.cont.general,dummy), 
			get.desc.of.cdf.field("2ywx"), 
			get.desc.of.cdf.field("3qyx"), 			
			tt.label.desc ("tctcmcs029.cbtp",ttadv.cont.general,dummy), 
			tt.label.desc ("tctcgen.cadr",ttadv.cont.general,dummy), 
			tt.label.desc ("tctcnama",ttadv.cont.general,dummy), 
			tt.label.desc ("tctcmcs010.ccty",ttadv.cont.general,dummy), 
			tt.label.desc ("tctccom130.city",ttadv.cont.general,dummy),
			tt.label.desc ("gbcom4400m000s01",ttadv.cont.general,dummy)
			)

	ret = utf8.export(unicode.line,line,UTF8_STD_MODE)
	seq.puts(unicode.line,fp)
	return(true)
}


function write.data()
{
	if not isspace(text) then
		search.and.replace(text,","," ")
		search.and.replace(text,chr$(10),chr$(09))
	endif

	line = concat$("|",
		trim$(tccom100.bpid), 
		trim$(tccom100.nama), 
		trim$(tccom110.crep), 
		trim$(crep.nama), 
		trim$(tccom112.cpay),
		tccom112.crlr,
		trim$(tcmcs143.dsca),
		trim$(tccom110.cdf_5glk), 
		trim$(tccom110.cdf_4khd), 
		trim$(tccom110.cdf_1hyf), 
		trim$(tccom110.cdf_6qyj), 
		trim$(tccom110.cbrn), 
		trim$(tccom110.cdf_2ywx), 
		trim$(tccom110.cdf_3qyx), 			
		trim$(tccom110.cbtp), 
		trim$(tccom100.cadr), 
		trim$(tccom130.nama), 
		trim$(tcmcs010.dsca), 
		trim$(tccom139.dsca))

	search.and.replace(line,","," ")
	search.and.replace(line,"|",",")
	line = trim$(line)&chr$(44)&text
	utf8.export(unicode.line,line,UTF8_STD_MODE)
	seq.puts(unicode.line,fp)
	
}
Attached Images
File Type: png unicode parameter.PNG (12.3 KB, 6 views)
__________________
Regards,
Vamsi
Reply With Quote
Sponsored Links
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
T-SQL way to retrieve Chinese text eric.dizon Tools Development 2 23rd April 2014 22:35
purchase text in session item data abas_cool Manufacturing & Supply Chain 3 27th August 2009 12:04
Application data dictionary vs. run-time data dictionary NPRao Tools Development 5 7th July 2009 09:16
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 06:38


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


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