Go Back > Forum > Baan Quick Support: Functional & Technical > Distribution, Transportation & Warehousing

User login

Frontpage Sponsor


Google search

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

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 25th January 2003, 04:34
Paul P's Avatar
Paul P Paul P is offline
Join Date: Jul 2002
Location: Jakarta, Indonesia
Posts: 797
Paul P is on a distinguished road
Baan: BaanIV, BaanERP - DB: SQL Server, Informix, Oracle - OS: Windows, HP-UX
Smile Importing item data from CSV file

Dear all,

We figured that constructing API program to import item data from a CSV file would probably be rather too complicated. Can anybody say that we'd be safe if we import these items through Exchange on the following tables alone ?
  • tcibd001 general item data
  • tdisa001 item sls data
  • tiipd001 item prod data
  • whwmd400 item WH data
  • tcibd007 item costing data
  • tdipu001 item pur data
  • tcibd200 item ordering data
  • cprpd100 item planning data
We don't use Projects, Services. By the way, do you think we need tdipu010 item supplier information too? Thank you very much

Reply With Quote
Sponsored Links
Old 4th September 2007, 13:17
v.rohatgi v.rohatgi is offline
Junior Member
Join Date: Aug 2007
Posts: 3
v.rohatgi is on a distinguished road
Baan: Sp0 - DB: Oracle 10g - OS: AIX 5.3
Hi Paul,

We have done all of the above table imports through exchange schemes asnd it works fine.


Vineet Rohatgi
Reply With Quote
Old 5th September 2007, 14:18
jp.aalders's Avatar
jp.aalders jp.aalders is offline
Senior Member
Join Date: Aug 2001
Location: Ootmarsum - The Netherlands
Posts: 164
jp.aalders is on a distinguished road
Baan: Baan c4 - DB: Oracle, Bisam, Informix - OS: AIX, HP-UX, Suse
Thumbs up

Don't forget to fill the tiitm100 table ( relations between item/containers) to prevent errors afterwards! This table has a 1:1 relation with tiitm001.

Good Luck

Reply With Quote
Old 8th September 2007, 14:01
msninave msninave is offline
Junior Member
Join Date: Feb 2005
Posts: 21
msninave is on a distinguished road
Baan: BAAN IV - DB: oracle - OS: windows 2000
I have used the exchange scheme successfully. It works.
Reply With Quote

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
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38
Importing Via Exchange with a CSV file Abuibra Tools Development 6 1st October 2002 17:52

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

©2001-2018 - -