Place HTML Report Diagram on Sharepoint

[Knightrider]

Hi Gang

I've created a Data Landscape Diagram (eventually) in Sparx EA 12.1 and have generated an HTML report/diagram using the Sparx functionality. The HTML Diagram can be viewed using Internet Explorer and allows me to click on components which give additional information such as Notes, Tags and Connector details. That is great but the final goal is to move the diagram to a SharePoint (2010) site. This is so other people in the organisation (who don't have Sparx) can view and click the diagram to explore our application/data landscape.

My question is, does anyone know how to do this. I appreciate its not a Sparx question as such but more of a Share Point one. I am hoping someone may have successfully done this and can save me some time. The other thing I've noticed is Sparx seems to create hundreds and hundreds of files which are a right pain to upload into Share Point 2010.

Any help will really be appreciated as always. Thanks.

[Glassboy]

Yes I do :-)

The short answer is to create a document library for Sparx HTML reports and put all the files in it.  Then create a link to index.htm in your menu structure.

The slightly longer answer is that you will need to have the Sharepoint admin increase the file limit for the document library and give you webdav access to the server if you want this to be a practical thing to do. 

[Knightrider]

Really appreciate the quick reply Glassboy. Im new to Sharepoint so when it tells me the max number of files I can upload at anytime is 100 - is that something that can be changed by Admin? Is this what you mean or are you referring to the max number of files that a library can hold needs to be changed? I have Admin access for our Sharepoint site. Is that sufficient?

Apologies for the basic questions but I am no expert on Sharepoint

[Geert Bellekens]

If you have UCC (webdav?) access to the library then this isn't an issue.
Then you can just use the windows explorer and type \\sharepointlocation\myEAWebsiteFolder\ and drop the whole structure there.
Just make sure you don't need checkin-checkout for that part as that tends to mess things up.

If you are interested, I have a VBscript that can be executed by the windows scheduler to export the model say every night to a location on sharepoint.
See https://github.com/GeertBellekens/Enterprise-Architect-VBScript-Library/blob/master/Framework/Publish/ExportHTML.vbs

You just have to make sure the an actual user is logged in and the machine has EA installed.

Geert

[Knightrider]

Many thanks Greet. That script looks very useful as that the next part of my project. I want t o publish stuff every night as our Data Analysts will be updating the models during the day.

Having loaded the HTML, it seems a bit slow. I don't know if other people have found this to be the case.

By the way Greet I also owe you a drink for pointing me to your VB code which loads Excel based data into Sparx. I managed to modify it to generate about 70 Data landscape diagrams automatically, each containing many tags, connectors and attributes. A big big thanks!!!

[Glassboy]

Really appreciate the quick reply Glassboy. Im new to Sharepoint so when it tells me the max number of files I can upload at anytime is 100 - is that something that can be changed by Admin? Is this what you mean or are you referring to the max number of files that a library can hold needs to be changed? I have Admin access for our Sharepoint site. Is that sufficient?

From memory it was a setting the SharePoint server admin had access to, not the individual site admin.  I'm no SharePoint guru tho' so it maybe somewhere in your site config.

[Geert Bellekens]

Many thanks Greet. That script looks very useful as that the next part of my project. I want t o publish stuff every night as our Data Analysts will be updating the models during the day.

Having loaded the HTML, it seems a bit slow. I don't know if other people have found this to be the case.

By the way Greet I also owe you a drink for pointing me to your VB code which loads Excel based data into Sparx. I managed to modify it to generate about 70 Data landscape diagrams automatically, each containing many tags, connectors and attributes. A big big thanks!!!

You're welcome.
If you are ever in the neighborhood of Antwerp give me a shout and I might take you up on that offer for a beer 

Geet

[Glassboy]

If you are ever in the neighborhood of Antwerp give me a shout and I might take you up on that offer for a beer 

I imagine if I ever made it around the other side of the world to Belgium there's be a lot of "beer" happening :-)

[koenvv]

Hi Geert,

when the export files are copied to SharePoint, how do you manage to get SharePoint to display the htmls properly? Javascript is disabled and the html can also be modified. Also, the relative img & href paths are not usable.

thanks,
Koen