• State Suggested Answer
  • Replies 7 replies
  • Answers 1 answer
  • Subscribers 432 subscribers
  • Views 4805 views
  • Users 0 members are here
Options
Related

Analyzing multiple projects at once

Paola

Hello, I have to compile a monthly report of my last 2 years of work (words translated, words proofread by month). My work is done 90% in Studio, so it would be awesome if I could use it for this task.

Usually, I just select multiple projects in the Project page and I get the total wordcount. However, every time that an Update is installed (about every 3 months) I lose all the projects in the Project page.

So, what I'd like to do is to load all of my Studio projects (*.sdlproj) I did in 2016 and in 2017. I tried to simply drag and drop the many *.sdlproj files but the application crashed. Is there a tool to do this?

Thank you in advance!
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
  • 0
    I'm afraid not.
    The best solution for the future would be backing up the projects.xml file you find in the library, documents, Studio projects folder.
    Studio does not like to have too many projects listed in projects view and usually it is not necessary to keep them there.
    My wife and myself use nearly only Studio, but only for translating. The administration is done via Translation Office 3000. However, TBH, we never did any statistics on the number of words translated...

    _________________________________________________________

    When asking for help here, please be as accurate as possible. Please always remember to give the exact version of product used and all possible error messages received. The better you describe your problem, the better help you will get.

    Want to learn more about Trados Studio? Visit the Community Hub. Have a good idea to make Trados Studio better? Publish it here.

  • 0
    A few ideas...
    How about going back through your invoices for the last 2 years? If they list projects by reference, number of words, rate and total by project, you would get the total words quite easily.
    Or 'load' projects back into Studio by month/quarter to make a note of your figures, then remove from the Studio list and add the next month/quarter. Maybe in smaller groups it will work without crashing. Your invoices or other records should tell you which projects to load. Maybe you file them by year/month, etc.
  • 0 in reply to Simon Cole

    I cannot load more than one project at time. I have 665 projects with just one client in the last 2 years. What a missed chance for Studio!

    I'll have to make an estimate based on the invoiced amounts
  • 0 in reply to Paola
    Hi.
    Of course I do not know your admin systems, but how do you know there were 665 projects in 2 years with one customer? If you have a list (Excel file?), does it include word counts for each job? If so, here is your data, you don't need Studio. As a separate question, if you don't have such a list, how do you know how much to invoice every month?
    I agree with your idea to base it on invoiced amounts. A list of invoiced monthly totals, each divided by the rate per word, will give you the word counts - Excel strikes again!
  • 0 in reply to Simon Cole

    @Simon Cole (SimonCole) I simply count the number of folder-projects for a Client in the last two years. Besides, I also put the date in my folder in the YYYY_MM_DD format, so I simply sort the folder by name, select all the folders from 2015_ to 2017_ and in the status bar it says '665 folders selected'.

    E.g. Client X is an agency specialized in Videogames, I do 98% Videogame-related projects for this client. 90% of projects are done in Studio, whereas some are done directly in Word (small updates)

    My folder structure is Client X > 2015_01_01 - project12345 I select 2015_ to 2017_ and I know how many project I did for Client X in the last 2 yrs.

    What I did was apply two filters to my Client X folder: look for .sdlproj and that contains 2015_ or 2016_ or 2017_ in the folder name, so I have about 600 .sdlproj files for Client X in the last 2 yrs (projects done in Studio) of 665 projects (all projects for Client X).

     

    >> As a separate question, if you don't have such a list, how do you know how much to invoice every month?

    l am using an accounting software called Billings Pro which is very popular among Mac freelancers. When a client commissions a job, I create a project and insert the relevant word count. At the end of the month I invoice the client (some clients want an invoice per project - bummer!). When I receive the payment I add it to Billings Pro.

     

    However... There is one client whose POs just read a weighted word count, so that it reads 1.111,43 words  - New words weight 100%, fuzzy weights less, reps weights 50%. It is very practical to file these POs in my accounting systems.

    Whereas other clients' POs are made of 6 lines (New words / 95-99% matches / 85-95% matches / ...) and so it would take too much time to enter 6 tasks for each project. I just insert a translation task 1 x total.

     

    With Billings Pro I can generate reports, but they are of course financial reports, such as how much I have invoiced per month by Client, etc. It is possible to create custom-made report but you need programming skills  I don't have, so I am stuck with their standard reports (which are fine for my usual needs).
  • 0
    Hi Paola,

    I don't have much to add to this thread... a little tricky without using the server solutions we have. But it did get me thinking about additional apps for the appstore. Might be good to have some things that did this:

    - allow you to select a folder and then pick the projects in that folder that you wanted to load into the Studio View, and then load them
    - an improved dashboard that could maintain some stats on words translated, by day/week/month, and by client... things like this

    Might actually be two fairly simple things to do. Although I think you'd need an export feature on the dashboard to make sure you don't lose stuff through upgrading or removing projects.

    Regards

    Paul

    Paul Filkin | RWS Group

    ________________________
    Design your own training!
    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

  • 0 in reply to Paul
    Thanks for chiming in, Paul! Glad to see you are always on the radar!

    Why does Studio loses working languages and projects at every install? I have no other single software that loses all of its setting when it is updated.

    Another thing that could be improved is that productivity app which has a timer to keep track of the time spent on a project. I tried it once but you have to click into the app menu (lower left side, select the project and hit play/pause every time you start/stop working on a project. For example - I have to reply to an email.... click, stop
    I resume translating... clic, start
    I pick up the phone... clic, stop

    Can't you simply make a timer that keeps going while 1) Studio is in foreground 2) the mouse pointer is moving?

    ---

    Anyway, thank you!