Importing MetaData from SQL Database

I have pages that I've created in .NET that I will be placing on the TeamSite server. These pages are referred to by us as "Non-Templated Pages."

However, we have created a DCT to manage a portion of these pages. We enter data on the DCT and it gets written to SQL Server via DataDeploy. There is no presentation template. But the DCT pulls from the TeamSite MetaData to prepopulate the fields. If I move the non-templated page into Teamsite initially there will be no TeamSite MetaData for the page until someone enters that data for the first time.

Question is: Can I directly add the TeamSite metadata through some script?

Find more posts tagged with

Comments

gzevin

yes you can. iwextattr is the command.

Greg Zevin, Ph.D. Comp. Sc.
Independent Interwoven Consultant/Architect
Sydney, AU

Dogbert

Is that found in the Templating Documentation? I have no idea how this would work....

gzevin

no, it's a teamsite CLT. a very commonly used one.

Ok. To get what you need to do, do the following:



$IWHOME  = TeamSite::Config::iwgethome();    $IWHOME  =~ s/[\\\/]+/\//g;

sub setEA {
 my ($path, $attr, $val) = @_;
 $path =~ s/^.*?\/default/\/default/;
 my $ret = system("$IWBIN/iwextattr", "-s", "$attr=$val", "$path");
}

setEA will take 3 parameters - vpath of the file, attribute name - say TeamSite/Metadata/MyKey and the value

enjoy

Greg Zevin, Ph.D. Comp. Sc.
Independent Interwoven Consultant/Architect
Sydney, AU

Dogbert

Ok. Please forgive my ignorance. I have received ZERO training on this and am a .NET developer trying to clean up......so.

What will that script actually do?

gzevin

you asked for the way to attach metadata - this snippet will help to write a script to do this.

if you are unable to handle perl scripting yourself, ask other members of the team.. or hire a consultant

.

Greg Zevin, Ph.D. Comp. Sc.
Independent Interwoven Consultant/Architect
Sydney, AU

Migrateduser

I think the documentation for iwextattr is in the command line tools manual (downloadable from support). The usage on the command gives you a pretty good idea of what it does. Open up a cmd window and type:


iwextattr /?

If you have some specific questions after checking out the manual and the usage help, we can probably serve you better.

Dogbert

Well, I guess I'll look into that then. I have several attributes to input and I guess I am expecting a straightfoward approach.