API to add external document (word/pdf etc) to model ?

[OpenIT Solutions]

Hi,

Anyone know if there is an API that can be used to add a document (as an artefact in t_object and corresponding extdoc entry in t_document) to a Sparx repository ? If there isn't' an API has anyone got a script that does this ?

Regards,

Jon.

[qwerty]

You're probably looking for EAElement.LoadLinkedDocument (string Filename)

q.

[Geert Bellekens]

You're probably looking for EAElement.LoadLinkedDocument (string Filename)

q.

No, that's not it. That will only load the contents into the linked document of the element, not have it as external document.

I'm not aware of any API function to do so, but I never really had to look for it either.

Geert

[OpenIT Solutions]

Ok, thanks both - I think I might be able to hack my way around it with EAElement.LoadLinkedDocument (string Filename) - assuming it does the zipping/encoding of the document into t_document.strcontent ...

Regards,

Jon.

[OpenIT Solutions]

Hi,

Turns out it is possible - but only if you generate the doc as PDF (extension = ".pdf" below) due to encoding/zipping... this code did the trick for me..

p.RunReport thePackage.PackageGUID, "DB Diagram and Element Details (A3)", fname & extension
            
            Set theElement = thePackage.Elements.AddNew ("Baseline Approval Document [" & theDate & "]" & extension, "Artifact")
            theElement.LoadLinkedDocument (fname & extension)
            theElement.Update
            sql = "UPDATE t_object SET style = 'ExtDoc=1;' WHERE object_id = " & theElement.ElementID
            Repository.Execute (sql)
            
            sql = "UPDATE t_document SET DocName = '" & theElement.Name & "', ElementType = '" & extension & "', DocType = 'ExtDoc' " &_
               "WHERE ElementID = '" & theElement.ElementGUID & "' AND ElementType = 'ModelDocument'"
            Repository.Execute (sql)
            

Regards,

Jon.