cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

Data Loading

rstav
1-Visitor

Data Loading

Windchill Administrators,

I am currently using Windchill 9.0 build M030 and we have been using the system successfully for about a year. Now it is time to expand the use of Windchill, so I am looking at bulk loading about 300 Word documents into Windchill PDMLink. I have been reading through the Windchill Data Loading Reference and Best Practice Guide and it is not as clear as I would like.

Does anyone out there have a Data Loading for Dummies version? Or just some tips and tricks?

Thanks
Rich

Richard Stavish
Pro/E System Administrator
Sargent Controls & Aerospace

[cid:image003.jpg@01CA6215.AA0D3CF0]

E-mail:
Office:
Fax:

RStavish@sargentcontrols.com
520-744-1000 Ext. 4570
520-744-7529
3 REPLIES 3
dtkach1
1-Visitor
(To:rstav)

Try to load files from Windchill "loadFiles" folder. As long as you
don't need to load data that used custom model objects you should be
fine. If you have own custom Windchill Object you have to write own java
load processors (load helpers, etc) to extend wt loading classes.

thansk,
Dmitry
MikeLockwood
22-Sapphire I
(To:rstav)

Super difficult to dig this out of that manual. See Powerpoint which I'll attach to next email with simple steps. It took us about 15 hours to dig out of the manual how to do this - but it's just a few simple steps once you "get" it. We do this every day now.

rey
1-Visitor
1-Visitor
(To:rstav)

Richard,

For best practice it is a good idea to create a soft type of a document
that will hold your Word documents with defined attributes suited for that
type of document and your business needs.

A. Using the Type and Attribute Manager within Site/Utilities
1. Create a new attribute organizer for your document type.
2. Create the attributes you need for that document type within the organizer.
3. Create the document soft type you will use for the word document.
4. Add the attributes to the new document soft type.

B. Using the OIR administrator download a copy of the OIR for documents
and edit it to fit your requirements for the new document soft type. For
example you can specify numbering, versioning, folder initialization
rules....etc.
1. Create the OIR for the new document soft type.

D. Check if your new document soft type appears in the pull-down for
creating new documents. If so, see if you can create a new one with all
the attributes you defined.
1. Attached your word document as the primary attachment and check it in.
If everything works well at this point then you are ready to bulk load your
word document to this soft type.

E. Example loader - myloadfile.xml - create in
<windchill_dir>/src/loadfiles directory
Put content file mywordfile.doc in <windchill_dir>/loadfiles/content/
directory
You can use the csv to xml to create this file or use PERL to create
one for you in this format.



<nmloader>
<csvbeginwtdocument handler="wt.doc.LoadDoc.beginCreateWTDocument">
<csvname>Washer</csvname>
<csvtitle>Plastic</csvtitle>
<csvnumber>123456-00</csvnumber>
<csvtype>Document</csvtype>
<csvdescription>Hardware</csvdescription>
<csvdepartment>DESIGN</csvdepartment>
<csvsavein>/Default/Hardware</csvsavein>
<csvteamtemplate></csvteamtemplate>
<csvdomain></csvdomain>
<csvlifecycletemplate>Basic</csvlifecycletemplate>
<csvlifecyclestate>Released</csvlifecyclestate>
<csvtypedef>YourSoftypeName</csvtypedef>
<csvversion>A</csvversion>
<csviteration></csviteration>
</csvbeginwtdocument>

<csvibavalue handler="wt.iba.value.service.LoadValue.createIBAValue">
<csvdefinition>Material</csvdefinition>
<csvvalue1>Plastic-x</csvvalue1>
<csvvalue2></csvvalue2>
<csvdependency_id></csvdependency_id>
</csvibavalue>

<csvibavalue handler="wt.iba.value.service.LoadValue.createIBAValue">
<csvdefinition>Vendor</csvdefinition>
<csvvalue1>Vendor-x</csvvalue1>
<csvvalue2></csvvalue2>
<csvdependency_id></csvdependency_id>
</csvibavalue>

<csvibavalue handler="wt.iba.value.service.LoadValue.createIBAValue">
<csvdefinition>Project</csvdefinition>
<csvvalue1>X1</csvvalue1>
<csvvalue2></csvvalue2>
<csvdependency_id></csvdependency_id>
</csvibavalue>

<csvendwtdocument handler="wt.doc.LoadDoc.endCreateWTDocument">
<csvprimarycontentype>ApplicationData</csvprimarycontentype>
<csvpath>mywordfile.doc</csvpath>
<csvformat>doc</csvformat>
<csvcontdesc></csvcontendesc>
<csvparentcontainerpath></csvparentcontainerpath>
</nmloader>

F. Execute Load command in <windchill_dir>/src/loadfiles directory

windchill wt.load.LoadFromFile -u username -p yourpasswd -d myloadfile.xml
-CONT_PATH
\"/wt.inf.container.OrgContainer=YOURORG/wt.pdmlink.PDMLinkProduct=YOURPRODUCT\"
-o mylog.log


Hope this gives you some idea what needs to be done.

Rey




Announcements


Top Tags