Hello
Do you know of a SQL query that would retrieve the Windows storage path of the files stored in the Vault?
We would like to update variable values in our maps, the problem being that the software we would like to use needs the physical path of the Sld file to update the variable.
Thank you
Can this help you
https://www.developpez.net/forums/d339433/general-developpement/programmation-systeme/windows/scripts-batch/chemin-fichier-ligne-commande/
via the forum developpez.net you will surely find a walkthrough
https://zestedesavoir.com/tutoriels/297/petit-guide-de-sql-plus/
@+
Thank you for your answer gt22,
The problem with a batch, for example, is that it doesn't see in my local folder the files that I haven't extracted. If I do dir*.* in a folder in the vault from my computer, it sends me the directories in this folder but not the files, except the ones I created locally.
For the SQL query, not knowing the structure of the database, I don't know which table to point my query to.
your files do have an extension
so via this extension you should find the files it seems to me
Digging in the Developper .net forum
and give news thank you
@+
if it's an EPDM trunk
See this link
http://www.lynkoa.com/forum/epdm/comment-lister-tous-les-fichiers-qui-sont-dans-le-coffre-fort
including this response from PL
BEST ANSWER
Hello
By searching the vault with a wildcard (either * or ? or % or $), we should have a list of all the files.
Then to export this result, a right-click should work.
Edition: for export see here:
http://help.solidworks.com/2015/french/EnterprisePDM/FileExplorer/t_Expo...
@+
Hello
The batch does not find the files because there are no files.
Unextracted files are stored directly in memory in a blob or threadable in a database.
I don't know what object epdm uses but you can look in this direction. Without knowing the structure of the database, it's going to be hard. Use the SQL Server console (management tool) to connect directly to the database and snoop around again and again:)
Other than leaving the latest version on disk space, there will be no path.
Hello
On the other hand, fiddling with the server's SQL tables is at your own risk. The easiest way is to go through excel, with the EPDM API it works not too badly without the risk of putting the system in error.
I got my answer, in the search tool, you can export the search result in Excel.
Just search for *.* and you get the list of items in the vault with the path in the vault of files in a column.
Then with the Excel export I can do what I want, no need for SQL query
I got my answer, in the search tool, you can export the search result in Excel.
Just search for *.* and you get the list of items in the vault with the path in the vault of files in a column.
Then with the Excel export I can do what I want, no need for SQL query
