verify existence of file in storage

Offline Stephanie Doherty over 9 years ago

I have been asked to write an API which will verify the existence of documents in their specified storage location. (Basically to make sure there are no files that show up in PW which don't physically exist.) I can envision a couple of ways to do this depending on what PW functions are available.

1. If there is a document function which will indicate whether the file exists in the designated storage location this is a simple Boolean task.

2. If option 1 is not available, is there a way to return the physical path on the storage location that the document is supposed to reside in so I can check for the existence of that document?

3. Use of an existing verification process which my PW Admin is not aware of at this time.

Any advice or suggestions are helpful.

Thanks,

Stephanie

Top Replies

0 Offline Dean Lyon Thu, Mar 12 2015 3:34 PM
Stephanie, Documents in ProjectWise may or may not have an associated file. So the first task would be to determine which documents have a non null filename and/or a filesize greater than 0 bytes. Each document is associated with a Storage Area. Once you have the document you can get the ID of the storage area, then use the Storage functions to get the location of that area, you then need the document's code, this is the name of the folder under the storage area. Then you would need the document's filename. With these tools you can construct a path to the file on the server which you can test open somehow.
However, it may be much simpler to write a copy_out function for each one and log the failures. copy_out may fail for reasons other than the file being missing, so investigate those. I would definatly use the local organiser to clean out any files, checked out, copied out or exported to your machine under the login you plan to use so that the status of the local files does not interfere.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Offline James Kennedy Thu, May 17 2018 2:09 PM in reply to Dean Lyon

Hey Dean,

I have a simple question. By "Document Code" - what is this? I've look through the Document Properties and I don't see a Document Code as I expected to see. The Projects have a Code, but this does not match to what I expected the Document Code to be.

Thank you
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Offline Dean Lyon Thu, May 17 2018 3:36 PM in reply to James Kennedy
The code I was referring to is actually a property of the folder (I had it misplaced) if you get the DOC_PROP_PROJECTID of the document, then you can get the PROJ_PROP_CODE (string) from the folder record. That will give you the dms000123 or d01234 folder name.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Offline James Kennedy Thu, May 17 2018 5:11 PM in reply to Dean Lyon

Thanks for the reply.

That's the answer I needed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel