Baanboard.com

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

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 12th October 2009, 18:41
newtobaan's Avatar
newtobaan newtobaan is offline
Member
 
Join Date: May 2003
Posts: 36
newtobaan is on a distinguished road
Baan: BaanC4 SP19 - DB: Oracle 9i - OS: HP UX
Multiline text import - exchange error
Baan: ERP LN 6.1
DB: Other/Unknown
OS: Other/Unknown
C/S: None/Unknown

Hi,

Tried searching on the site regarding this topic but not able to get any suitable answers.

Trying to import multiline text into the Items table. but this is not working!

My file looks like this
Code:
         100727|
{\{txta    2
change wc to sub wc
}\}
         0352-0034-01|
{\{txta    2
text must be entered
new line on text
}\}
The error I am getting is:
Quote:
2009-10-12[15:34:48(UTC+00:00)]:E:bsp: ******* S T A R T of Error message *******
2009-10-12[15:34:48(UTC+00:00)]:E:bsp: Log message called from /view/port.8.5a.02/vobs/tt/lib/dbc/c_dd_chk.c: #105 keyword: Check dd
2009-10-12[15:34:48(UTC+00:00)]:E:bsp: Pid 1932 Uid 125 Euid 125 Gid 125 Egid 125 Pset bghosh@cor2wkl998.emea.tsp.ad:2916
2009-10-12[15:34:48(UTC+00:00)]:E:bsp: user_type S language 2 user_name bsp tty ote locale ISO88591/NULL
2009-10-12[15:34:48(UTC+00:00)]:E:bsp: session: "10.o";object: "10.o"; company number: 90
2009-10-12[15:34:48(UTC+00:00)]:E:bsp: Errno 0 bdb_errno 0
2009-10-12[15:34:48(UTC+00:00)]:E:bsp: Log_mesg: tcibd001.citg not according to FILL (value ' ')
2009-10-12[15:34:48(UTC+00:00)]:E:bsp: ******* E N D of Error message *******
2009-10-12[15:34:48(UTC+00:00)]:E:bsp:
Can someone help in resolving this error message.
Thanks
Reply With Quote
  #2  
Old 14th October 2009, 14:58
Dieter's Avatar
Dieter Dieter is offline
Senior Member
 
Join Date: Aug 2001
Location: Germany
Posts: 101
Dieter is on a distinguished road
Baan: ERP LN 6.1 FP3 - DB: Oracle, MS SQL - OS: SuSE Linux, W2K3
Hi newtobaan,

look at the table relation in the import batch.
The checkboxes "Add" and "Delete" should _not_ be marked. Mark only "Override" and "Update"

Regards
Dieter
Reply With Quote
  #3  
Old 14th October 2009, 18:13
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,653
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
Look at citg

Quote:
Originally Posted by newtobaan View Post
Hi,

Tried searching on the site regarding this topic but not able to get any suitable answers.

Trying to import multiline text into the Items table. but this is not working!

My file looks like this
Code:
         100727|
{\{txta    2
change wc to sub wc
}\}
         0352-0034-01|
{\{txta    2
text must be entered
new line on text
}\}
The error I am getting is:


Can someone help in resolving this error message.
Thanks
Hello,

seems like itemgroup has no valid relation.
tcibd001.citg should be filled with "" and this is not valid.

Regards
__________________
//Bernd
Reply With Quote
Sponsored Links
  #4  
Old 7th November 2009, 15:27
catnesma catnesma is offline
Junior Member
 
Join Date: Oct 2009
Posts: 9
catnesma is on a distinguished road
Baan: LN6.1 FP3 - DB: SQL 2000 - OS: Windows 2003
to import text

identify last used text number in table tttxt001.
inform everyone not to create any text for that company.

if last used text is 100, and you have 50 text lines to be imported,
generate number from 101 to 150 on excel then fillup the default values for table tttxt001, tttxt002 and finally tttxt010 then the same text number (not the text) should be attached to item table.

This way you can see the text is imported.

Thanks,
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
How to call AFS in sp24? PV Ramone AFS/DDC/OLE: Function servers 4 2nd September 2008 12:06
[Critical] Tape Backup problem. flysurfing Operating Systems & Databases 14 31st August 2007 08:38
DDC and Triton3.1 a1 saso.its AFS/DDC/OLE: Function servers 2 7th January 2004 11:39
Running a Baan script from UNIX command line; ba6.1 runtime options chadwickh Tools Development 18 25th September 2002 23:48


All times are GMT +2. The time now is 09:58.


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