• State Verified Answer
  • Replies 4 replies
  • Subscribers 48 subscribers
  • Views 1711 views
  • Users 0 members are here
Options
Related

Obtaining GroupShare file histories

Andrew Jameson

We've recently had a few projects where a freelancer has notified us that they have checked-in their completed files in a GroupShare 2015-hosted project, but when we open the project from GroupShare we can't see the freelancer's work.

Furthermore, right-clicking on a file and choosing "Get specific version" shows no trace of the freelancer having checked-in anything. However, the translations are in the TM.

I realise that the TM can contain the translations once a segment has been committed, with or without the file having been checked-in, which is why I've looked into the database to see if the user features in the file history... and this is where the water gets more muddied.

Can anyone offer a GroupShare database query which shows the file history for a given project? I'm quite willing to show what I currently have if I thought that there was anyone willing to look at this who would be able to help.
Rate translation
×
Suggest better translation
×
Parents Reply
  • 0 in reply to Luis Lopes

    Hi Louis,

    Regarding those sprocs, GetFileVersion doesn't tell me anything I don't already know (file name and ID), and although GetLanguageFileVersions does have useful information, it's only on a per-file basis and doesn't show me the file history for a project.

    In my case I want to know if a user has checked-in a file - they may not be the last user, whereas GetLanguageFileVersions will only indicate the last check-in. For example, I might want to check that a translator has checked-in a file, even though the proofreader has since performed a check-in. This is why a full file history for a project is desirable.

    Thanks for pointing out those stored procedures - I've just realised that GetLanguageFileVersions shows how to obtain the comments so I'm going to see if I can use that elsewhere.
Children
No Data