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
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 29th August 2005, 14:10
baaniac baaniac is offline
Member
 
Join Date: Dec 2001
Posts: 62
baaniac is on a distinguished road
Baan: TRITON 3.1b, Baan IV b2/c2/c4, BaanERP 5.0b - DB: tbase, Oracle, Informix - OS: Sun Solaris, OSF, HP-UX
Any way to upload Parts List from Autocad to BoM in Baan ?

Hi,

We have following configuration -
Baan Version - Baan IV C4 Service Pack 18
Operating System - Windows 2000
Database - SQL Server

Our Engineering department creates drawings in Autocad. For their drawings, they create a Parts List in Autocad. Once this drawing is approved, they create a Bill of Material in Baan.

Our Parts List is huge; more than 500 items per assembly. And number of drawings is also big - some 30-50 per day.

Is there any way in Baan, by which Parts List from Autocad can be directly uploaded to Bill of Material (Engineering/Production) in Baan ?

Thanks and Regards
Reply With Quote
  #2  
Old 29th August 2005, 23:22
shah_bs's Avatar
shah_bs shah_bs is offline
Guru
 
Join Date: Jan 2002
Location: Lewisville, Texas
Posts: 387
shah_bs is on a distinguished road
Baan: BAAN IVc3 with A&D2.2b - DB: ORACLE 9 - OS: HPUX
If you have 'developer's licence', the easiest way to do this is to write your own 'update' session that will read the BOM records from an ASCII file and create records in the BAAN table. [This assumes that Autocad is capable of at least creating an ascii output consisting of Parent Item, Component Item and Quantity per Parent.] The rest of the fields required by tibom010 table are easy to figure out by creating and observing a small BOM by hand. This is how I did this in my company and it has been running successfully for many years now.

There is one important pre-requisite: The Item Data (tiitm001) records (parent as well as components) must have been established in BAAN up front (this is done manually), because that is one of the validations that I do in my program.
Reply With Quote
  #3  
Old 30th August 2005, 04:33
Paul P's Avatar
Paul P Paul P is offline
Guru
 
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
Hi baaniac (cool name, dude),

At one of my project, we ported BOM for hundreds of finished goods during the last few weeks of implementation (just before they went live). We used API to create the hundreds of item data required as well as their BOMs. With simple commands in API, we could make sure that all the related tables (there are quite a few involved in this) are updated properly. Please look around the API discussion forum for more information

Rgds,
Paul
__________________
Pambudi

Visit my technology consulting blog
Reply With Quote
Sponsored Links
  #4  
Old 30th August 2005, 08:00
baaniac baaniac is offline
Member
 
Join Date: Dec 2001
Posts: 62
baaniac is on a distinguished road
Baan: TRITON 3.1b, Baan IV b2/c2/c4, BaanERP 5.0b - DB: tbase, Oracle, Informix - OS: Sun Solaris, OSF, HP-UX
Thanks ...

Thanks a lot Shah and Paul for your valued suggestions.

We will handle the problem through small customizations.

Regards
Reply With Quote
  #5  
Old 21st September 2005, 08:33
rnayak72's Avatar
rnayak72 rnayak72 is offline
Junior Member
 
Join Date: Jun 2005
Location: Mumbai, India
Posts: 28
rnayak72 is on a distinguished road
Baan: B40C4,B50C - DB: SQL SERVER 2000, ORACLE 9 - OS: WINDOWS 2000 SERVER, SOLARIS
Exchange Scheme

Have you tried using exchange scheme for importing data from ascii file
Reply With Quote
  #6  
Old 21st September 2005, 08:52
Anuraag's Avatar
Anuraag Anuraag is offline
Member
 
Join Date: Nov 2003
Location: India
Posts: 42
Anuraag is on a distinguished road
Baan: B40 c4 IS5 - DB: Oracle 9.2 - OS: 2003 SERVER
its better to read ascii file directly using baan session. baan have the functions to read the ascii file (eg seq.open,seq.gets,string.scan,seq.clos).

best of luck.
Reply With Quote
  #7  
Old 22nd September 2005, 14:35
kopson's Avatar
kopson kopson is offline
Junior Member
 
Join Date: May 2003
Location: Slovenia
Posts: 4
kopson is on a distinguished road
Baan: Baan ERP - DB: Oracle - OS: Unix/Win
A set of sessions using AFS

Hello,

at S&T Slovenia we have developed a set of sessions specially designed to import ASCII data (exported from Autocad, ProfiDB or any other Windows application). Transaction logging and error reporting is also included. Sessions are based on AFS and are dynamically configured based on Import scheme. That means you can decide which fields you are going to insert in the Item or BOM table. They are much simpler to use than Exchange.
If you think this information is useful for you, feel free to contact me.
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
Invitation to SSA Global's BaaN User Group Meeting in Bangkok nopadon ไทยฟอรัม 0 12th January 2005 19:25
Baan World Users conference in Orlando chadwickh General Discussion & Chat 7 3rd November 2001 21:55
Availability of Web-Based DEM (Baan Press Release) Pierre B. General Discussion & Chat 0 5th September 2001 05:59
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 19:44
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 18:40.


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