Hi all
Is it possible to retrieve the status value of a file, to put it in a property?
The question may seem far-fetched, so a little context:
We've changed the way our files are classified. Before, they were grouped in folders by type (a plan folder, a part folder, an assembly folder, etc...) Not very practical.
From now on, everything related to a component (the 3D file, the plan, the pdfs, the various exports, step, stl, etc.) is stored in a folder. 1 ref = 1 complete file.
The only problem is that you lose the overall visualization of the database: before you could identify at a glance in the explorer the status of each part from its state (is it obsolete or not, is it being modified or not).
So I'm trying to find that. You can do it via searches, but it's not as fast as before.
I was able to retrieve (and keep up-to-date in auto) all the other properties of the parts to inject them into their folder, via the dispatch, but I don't know how (or even if it's possible) to retrieve the status value, which is still an important piece of information.
Does anyone have a tip?
Hello
The answer is ' yes ' because I have the file status on my data cards:
In the Map Editor:
There is a lot of recoverable EPDM data under this ' special value ' box
Hello
@froussel , the problem is retrieving the value to inject it into the file's properties. Viewing on the map is possible, but not transferring to a property of the file directly through the map.
Dispatch allows you to do this, but to add this property you will have to extract the files and have them take a version to inject this variable.
Wouldn't it be easier to create favorite searches that allow you to get the result quickly?
All column displays are configurable so you can get the desired result more or less quickly (depending on the size of the database, the search may take a little time to process).
2 Likes
Thank you for your answers.
Research is indeed what I have advocated so far. It works well, but it requires user action, I'm trying to find the ergonomics of before, without actions on their part. It's a luxury, I know 
, but I try to pamper my users.
If I can't do what I want, that's how we'll continue to do it.
For the recovery via the dispatch, I'm very interested!
Nowadays, the updating of a folder's properties is done following an archive, so we must be able to play with an extraction / archiving.
After I can't find the state data anywhere else than on the map (which f.roussel shows), I can't put it in ownership.
I can actually display it on the map, via a special value in a text field, but if I link it to a variable, I don't have access to it anymore.
Hello
Using the parts in PDM ( SOLIDWORKS PDM Professional Part Explorer - 2022 - SOLIDWORKS PDM Help would meet your need.
After... I say that, I say nothing.
→With the articles, it can quickly become a gas plant if it's not well thought out and structured at the beginning. Officially, Visiativ recommends not using it.
1 Like
Hello
At the dispatch level, you need to create a variable:
Then call it to inject it on a variable mapped with the file properties:
Personally, I would pamper users less.
Creating a reference inside the file that links to its state will inflate (for me unnecessarily) the number of file versions and/or the EPDM database.
So it will weigh everything down to bring a little comfort to users.
It seems easier to me to work on the display/settings of the EPDM file explorer to display what you want.
At home, we show the status of the files and their version (and as I'm also obsessed with the file ID if I need to go rummaging through the meanders of the archive server with its nice directories in hexadecimal):
And it's kif kif that what the data card returns:
It can be set up here:
1 Like
Hello
I reserve that for the display of the administrators of the vault (users have other displays).
HS ON: Otherwise I have the whole chest in an Excel table with all the links to the servers I save time overall vs transform to hexa from the ID visible in the display columns.
Hi @Cyril_f
It's true that it's easy to link a sql table in an Excel file nowadays (I used it to create automatic indicators for the BE: number of plans rejected / number approved for example).
What SQL tables do you get in Excel?
When you say link, does it mean that you have created hypertext links to the files and/or directories of the safe? Of course, if you have fiat that, it's much faster than taking out your hexa calculator, and rummaging through the multitude of directories with almost identical names
In principle, you're right: the ID is not really useful for users. But since I'm not logged in as an admin all the time (a bad click can happen so quickly), I preferred to add the column for everyone.
Until now, no one has ever asked me what it was 
I don't even query SQL, I run a search on the entire vault and then I retrieve what I am interested in (variable content, workflow status, location of the files in the vault and physical location on the server recalculated from the file ID of the vault).
I used this table at one time to massively move files, fix broken links following a PDM upgrade that went wrong (we have a whole batch of files from a year of conversion that no longer have dynamic links between ASMs and DRWs), redisplay hidden views on drawings during a file conversion without having to extract the files (I directly manipulate the files on the server as long as it doesn't touch the links, except in the special case of our corrupted versions).