Agile Design Objects
Hi,
As far as I can tell, there isn’t a way to mass Import new file folder (specifically ‘design’) objects into Agile. I would like to use an ‘Import’ type tool to auto-create 1000’s of Design objects without using a 3rd party tool. Has anybody done this before? I’m using 9.3.5.
Thanks in advance.
Brad Levitan
You’re correct import for file folders is not part of Agile functionality. You’d have to create something (using webservices) or seek out a third party tool.
Has anyone tried with Fileload? Design object belongs to filefolderÂ
FILEFOLDER as object type and rest follow fileload format
ObjectType, PrimaryKey, SecondaryKey, Path/Filename, AttachType, Description[,attrib1=value1,attrib2=value2,…attribn=valuen]<CR>
I think you can FILELOAD to a Design Folder, but the actual mass creation of the Design object itself is not possible without 3rd party help.
Blevitan is correct the file folder would have to exist so it can be identified in the secondary Key / version
FILEFOLDER,DESIGN00011,1,D:/docs/Design.doc,FILE,Design Document
So you still need a utility to create the design objects on-mass. The OP didn’t state the use of Designs but if it for something MCAD you really need to create the structure too.
If its MCAD we have found the MCAD integration to CREO in our case quite capable of  importing complete product design creating the designs / parts / structure / relationships as well as uploading the files
Thank you Adrian. Here’s my challenge. I have 40k+ image sitting in regular PC file folders associated with regular PC documents in Agile. If I now want to re create them in new ‘Design’ file folders, I have no way to mass create those 40k+ Design objects. If they were items I could easily use the Import function, but file folders are not an option in the OOB Import tool.
I have been using and become a bit of  a fan of Talend it can make SOAP calls to access the webservice and will process many forms of input (txt,csv,excel, database) and probably could navigate the folder structure and infer attribute values from folder names if that applicable. You could even get it to write the fileload catalog for you to.
There are probably a whole bunch of ETL data tools equivalent to Talend, but that’s what my company uses. Desktop version if open source too.
That’s what I’d use, but having learn’t enough to be dangerous with it and having other more experienced users nearby to seek help that relatively easy for me to say. But, other than paying a third party with dataload for Agile, leveraging the webservice interface or the other API is my recommendation.
Regards
Adrian Kendall
PS where are you based?