I have a client that has a old installation of Trim 6, they have not used the system for many years having moved on to a different product. We are about to replace their servers and they have told me that they do not want to migrate the Trim system to the new servers.
However they do not want to loose the data, what they have asked is for a way to make sense of the documents in the document store. I have had a look at the database tables and the information appears to be spread across multiple tables, what I'm strugling with (aside not being a SQL expret) is how the variuos tables interact.
Does anyone havea method/query to product a table/spreadsheet that would allow us to show which file belongs to which client, and what the document title/type is?
Essentially something that shows Client, Document title, filename, etc
Thanks for the reply, I though we may be doing it a difficult way. However I'm strugling with trimport.
Is there a easy way to select all records, it seems I have to select the clients 1 by 1 and add the records per client, with a large number of clients this is going to take some time, and may be error prone.