We have recently implemented Sharepoint at our company and have discussed using it for our document management.

Is it possible to export all of the documents under each project collaboration tab and load it onto Sharepoint?  Is it possible to XOG it out or maybe get a copy of those documents from the server or DB and place it into Sharepoint? What options do we have?  We strore all of our project documents within several other folders under the project's document manager.

We don't want to use a connector or any type of add-in that would just link the documents from Clarity or cost additional money. This would be a one time export. It doesn't have to be pretty, but maybe somehow sorted in folders by project ID and project title(if possible) that can be searched for if needed (ie. audit purposes, lessons learned).

We are using v13.0 On Demand.  I've done a little bit of XOGing in the past. I'm not familiar with Sharepoint but we do have resources that are.

Thanks for any input and advice,

Garrett

Hello Garret,

You can xog out the documents by project, object or folder depending on the xog you use and manually rename them. Once you return the extension this can be opened still it is a lot of work depending on the size of your filestore.

In my company we normally work a lot with clarity/sharepoint related developments and integrations. Feel free to contact me, and we can discuss other options

Hi Luis,

Thanks for the reply.  Is it possible to XOG out multiple documents from more than one project or does it need to be done one project at a time?  We have about 2000 projects.

What's the best way to contact you? I can't find a way through this forum.

Thanks,

Garrett

They are collaboration files only.

Luis,

You went a little over my head with this response. A couple clarifying questions for you:

1. What/where is the filestore xog?

2. How do I get the numeric file name and the database filename?

Thanks,

Garrett

Thanks Luis.

I'm going to run a small test.  I'll let you know how it goes and if I have any further questions.

Garrett

gsteudle:

2. How do I get the numeric file name and the database filename?

Some detail is in ths "tip" I think;

CA Clarity Tuesday Tip: Attachment Attribute

Thanks Dave!  I'll check it out.

Garrett

Here was my first try at XOGing out a document.  I wanted to Location oto be a folder on my hard drive.  I wasn't sure what the folder path should be and how to know what it is so I commented it out.  (Dave, I'm guessing that's the link you provided on how to get the path on the filestore. I just wasn't sure how to run the query.)  My XOG result was successful except the documents were not on my hard drive.

Any advice?

Here my XOG Read:

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
  <Header version="7.5" action="read" objectType="document" externalSource="NIKU">
    <args name="documentLocation" value="D:\Documents and Settings\garrett.steudle\My Documents\Clarity\XOG\XOG out documents" />
  </Header>
  <DocumentQuery>
    <Filter name="parentObjectID" criteria="EQUALS">5050069</Filter>
    <Filter name="parentObjectType" criteria="EQUALS">Projects</Filter>
    <Filter name="folderName" criteria="EQUALS">Project Management</Filter>
    <!--Filter name="folderPath" criteria="EQUALS">/Root/DMS/KS</Filter-->
  </DocumentQuery>
</NikuDataBus>

Here's the result:

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_document.xsd">
  <Header action="write" externalSource="NIKU" objectType="document" version="13.0.1.0102"/>
  <Documents>
    <Parent documentLocation="D:\Documents and Settings\garrett.steudle\My Documents\Clarity\XOG\XOG out documents" parentObjectId="5050069" parentObjectType="Projects">
      <Folder allowNonParticipants="1" hasAllParticipants="1" name="Project Management">
        <Document allowNonParticipants="1" fileCreatedDate="2009-09-24T00:00:00" hasAllParticipants="1" language="en"
          name="Business Case Template.doc" numCheckoutDays="1" owner="Garrett.Steudle" status="0" versioningEnabled="1">
          <Version id="5064401" owner="Garrett.Steudle" versionNumber="1"/>
        </Document>
        <Document allowNonParticipants="1" fileCreatedDate="2009-09-24T00:00:00" hasAllParticipants="1" language="en"
          name="Project Management Plan Template.doc" numCheckoutDays="1" owner="Garrett.Steudle" status="0" versioningEnabled="1">
          <Version id="5064451" owner="Garrett.Steudle" versionNumber="1"/>
        </Document>
        <Document allowNonParticipants="1" fileCreatedDate="2009-10-29T00:00:00" hasAllParticipants="1" language="en"
          name="FINAL CODE REVIEW CHECKLIST.xls" numCheckoutDays="1" owner="Garrett.Steudle" status="0" versioningEnabled="1">
          <Version id="5064501" owner="Garrett.Steudle" versionNumber="1"/>
        </Document>
        <Document allowNonParticipants="1" fileCreatedDate="2009-10-29T00:00:00" hasAllParticipants="1" language="en"
          name="PEER CODE REVIEW CHECKLIST.doc" numCheckoutDays="1" owner="Garrett.Steudle" status="0" versioningEnabled="1">
          <Version id="5064551" owner="Garrett.Steudle" versionNumber="1"/>
        </Document>
      </Folder>
      <Folder allowNonParticipants="1" hasAllParticipants="1" name="Specifications">
        <Folder allowNonParticipants="1" hasAllParticipants="1" name="Design"/>
        <Folder allowNonParticipants="1" hasAllParticipants="1" name="Requirements">
          <Document allowNonParticipants="1" fileCreatedDate="2009-09-24T00:00:00" hasAllParticipants="1" language="en"
            name="Scope Document Template.doc" numCheckoutDays="1" owner="Garrett.Steudle" status="0" versioningEnabled="1">
            <Version id="5064601" owner="Garrett.Steudle" versionNumber="1"/>
          </Document>
          <Document allowNonParticipants="1" fileCreatedDate="2009-09-24T00:00:00" hasAllParticipants="1" language="en"
            name="Security Checklist Template.xls" numCheckoutDays="1" owner="Garrett.Steudle" status="0" versioningEnabled="1">
            <Version id="5064651" owner="Garrett.Steudle" versionNumber="1"/>
          </Document>
          <Document allowNonParticipants="1" fileCreatedDate="2009-09-24T00:00:00" hasAllParticipants="1" language="en"
            name="Functional Requirements Document Template.doc" numCheckoutDays="1" owner="Garrett.Steudle" status="0" versioningEnabled="1">
            <Version id="5064701" owner="Garrett.Steudle" versionNumber="1"/>
          </Document>
        </Folder>
      </Folder>
      <Folder allowNonParticipants="1" hasAllParticipants="1" name="Testing">
        <Folder allowNonParticipants="1" hasAllParticipants="1" name="Test Approval"/>
        <Folder allowNonParticipants="1" hasAllParticipants="1" name="Test Results">
          <Document allowNonParticipants="1" fileCreatedDate="2009-09-24T00:00:00" hasAllParticipants="1" language="en"
            name="Defect Tracking Log Template.xls" numCheckoutDays="1" owner="Garrett.Steudle" status="0" versioningEnabled="1">
            <Version id="5064751" owner="Garrett.Steudle" versionNumber="1"/>
          </Document>
        </Folder>
        <Folder allowNonParticipants="1" hasAllParticipants="1" name="Test Plan"/>
      </Folder>
      <Folder allowNonParticipants="1" hasAllParticipants="1" name="Documentation and Training"/>
    </Parent>
  </Documents>
  <XOGOutput>
    <Object type="document"/>
    <Status state="SUCCESS"/>
    <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="17" updatedRecords="0"/>
    <Records/>
  </XOGOutput>
</NikuDataBus>

Hello Everyone,

Thanks for all your great feedback.  I was actually able to make some progress using XOG but this project got cancelled/put on hold before it could be completed.

Garrett

Hello Alistair, Garret, Dave, Luis and All,

Would someone please help me with a very similar question?  I am also needing to extract Project documents from Collaboration (but not for sharepoint).  I have successfully extracted multiple documents and its folder structure from one project.  However, how do I:

- use GEL to automate this process for thousands of projects (writing GEL script is not my strength) and

- find out the correct folder and file names (as opposed to the IDs) and

- find out the correct file types (as no file extension are associated with the documents)

Would you please contact me by email at thao.nguyen@daf.qld.gov.au?

If it is of any help, this is the DOCUMENTS_READ.XML

<NikuDataBus xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Header externalSource="NIKU" objectType="document" action="read" version="7.5"><args value="E:\CA\Clarity\Config" name="documentLocation"/></Header><DocumentQuery><Filter name="parentObjectType" criteria="EQUALS">Projects</Filter><Filter name="parentObjectID" criteria="EQUALS">5034203</Filter></DocumentQuery></NikuDataBus>