Any best practice tips to clean up orphaned files in the Global Files Container?
Hi community, on a regular basic I clean up orphaned files. Typically these are files that were used in a relationship or file property item. But we have another type of files -> images and thumbnails. If thumbnails are not referenced any more, they are not marked as orphaned. They stay in the Global Files Container. We cannot use the locator to check if the files are still used. What is the best way to get and overview of these files? I am already able to find orphaned thumbnails of Parts via SQL. But I noticed that it´s dangerous to only check the "Part" Item Type. The "Image" property is used more than 30 ItemTypes. Just because my orphaned image isn´t use in a Part, doesn´t mean it isn´t use in a mpp_Tool So I wonder if my current approach to get the files via SQL is really the best approach. Does anyone have a better idea? Angela
How to batch download and upload files?
Under Documents, Type= Setup Sheet, State = Released, are documents that are in excel and they have to be converted to pdf I guess the first the step woudl be to get the meta data, Document name, ID, Related Files, and File ID. Then loop through this file to download them. But then what would the path be to download this. How do I go about this? Thanks!!
Vault Error - You have insufficient permissions to open the File.
Hello all, I'm getting a weird error with the vault using a completely out of the box install of Innovator 2023. No new users, changes to itemtypes, etc. We literally just installed Innovator 2023 and logged in. "Failed to get the File" "You have insufficient permissions to open the File." The problem is that it doesn't happen to everyone, and who it happens to changes after an IIS reset or application pool recycle. I can log in to Innovator, using localhost from a browser on the same server the application is installed on, using the admin user, and I can open and add files to a Document no problem. Then my colleague, also on the same server, logs in using localhost, with the admin user, and she can't open the file thanks to this error. She CAN add a file to the Document, and it is properly vaulted, though she is unable to view that file after it's been added. It's like create access still works, but not read access. If we recycle the app pools and she logs in first, then I log in, I will get the error. It's usually the second person to log in that gets the error, though not always. Usually it's just the one person with the error, but that's not always the case either. Normally when I'd see an error like this I would check the windows folder permissions on the Vault to make sure the user the application pool runs as has access. Everything seemed normal there but to rule it out I added Everyone to the permission with full control. We're both using the admin user to rule out permissions inside the Innovator application as well. Accessing it from a different server, or using a different browser like Chrome makes no difference, clearing the browser cache also doesn't help, and neither does the Admin > Clear Client Metadata Cache option in Innovator.. We turned on all the logging we could and seemed to find the culprit but are at a loss for what is going on and why it's so intermittent. It seems that for whoever Innovator decides shouldn't be able to get files, it's because of an error in the AuthenticationBrokerWebService. It's trying to do Aras.Server.Models.AuthenticationBroker.GetFileDownloadTokenModel but getting an error, "Database configuration was not found for 'dbname'". Has anyone seen something similar before? I've worked with Innovator for many years now, including installs of this version, Innovator 2023, and never seen something quite like this before. I also noticed weirdness in the license manager. I log in first, and I see just the one session for admin. Then my colleague logs in and tried to get the file, and when I look at the license manager again I see over a 100 sessions for admin. Maybe it's nothing because I always see multiple sessions per user in other Innovator instances, though 100s of them for a single login and file download attempt seems excessive. I don't know if it's related but since the authenticationBroker seems to be the problem with the file download, I figured I'd mention it since it would also have to do with authentication. Thanks -ScottToggle visibility of Restricted files under Documents
The Document's Type field had to be updated to a new value that was added to the list. Batch loader was used to the edit the Document but this created a new Version and the State to Preliminary from Released. We did not want the new versions to be created. The new version of these Documents were purged. Now, under these Documents all the files show as "Restricted" however, they are visible to Admins. How do I make these files visible again. Screenshot below
Direct Link to Download File From Vault
I am wondering if there is a way to download a file directly via a link. In previous versions of Innovator there was a way to do this through the vault server: /vault/vaultserver.aspx?dbName={dbName}&fileId={fileId}&fileName={filename}&vaultId={vaultId} However it seems like in later versions of Innovator this no longer works. I am aware of an option of: /client/?StartItem=File:{fileId}, however this requires a user to authenticate and a popup window is displayed, it is not a direct download. Is there any way to achieve this?File checkout (using fetchFileProperty & checkout) not working in custom user with custom identity. how to checkout file in for user not having administrator permissions ?
I'm trying to checkout a file using item method fetchFileProperty in custom user with custom identity which do not have administrator permission. Aras gets hang after this method call, also tried with file.checkout methods behaviour is same. With admin user file checkout with same code is working but not for different user. What is the issue ? is this due to permissions ? what permissions needed to checkout file?
Removing file from vault via server Event
Hai , I do have a requirement to delete unused files from vault , because it consumes memory . So I was trying to deleting files via server event which does not have any relationship . But I was not able to reach vault . Please help me to find a solution in this requirement. Thanks in advance !!Extending FileType table with additional types for software files - what do I have to consider? @Aras: Could you provide an official extension?
Hi community, does any one have experience with extending the FileType table with custom entries? Is there anything we need to know before adding own new entries? We use Innovator for more and more software related tasks, but the FileType table mostly contains general or CAD related file extensions. The missing file types are not really a big issue from a technical perspective. Innovator just ignores FileTypes it doesn´t know. It´s more a nice to have. But well, let´s say our PLM implementation is so advanced that stuff like this are now the BIG issues people complain about. [emoticon:6d505171faa4497c85c5ca27290c555d] Extending the FileType table is pretty easy. We can create own entries like this: But I wonder if it´s really smart when end users expand the FilesType table by themselves? In case Aras adds similar file types in the future, my own file types would conflict with the new ones. And I right now don´t know, if there are any cross references to other tables or even the codetree that we should consider (despite the Files table). Does anyone know if there are "official" extended Aras FileType entries for software files? @Aras: Could you provide some official FileType extension package? A official dataset would ensure that everyone works on the same items a minimize conflicts when people update!! These are the file types I miss so far related to typical software files: hex, ini, exe, app, bin, rom, dfu, dmg, iso, md5, msi, deb,... If we think even further, we could also add the file types for source code files like cpp, py, json, html, dll,.... Not sure if storing sources is somebody ever will do, but who know the future? Other file types that are missing are trivial common stuff like 7z, rar and ico. I assume there are more than enough file types that could be part of an "extension" package. Would be a great work for an intern :D Despite that, if any one from this forum community has experience with adding own FileTypes I would be happy to know! Best regards! AngelaLoading files using BeforeAMLPackagesImport script
Hello All, I am loading some custom help pages as items in Innovator as part of an AML package. These items have pictures attached to them so I know I need to load the pictures separately through a BeforeAMLPackagesImport script (or just before the help items on the import.manifest file?) I need these items (and the files that the items rely on) to load with a new build. The question is, how would I script to load those files into the database?
You have no default Vault server.
Dear All, I have a default vault server entry and vault server installed during installation. Still, I receive a weird error "You have no default Vault Server" during file creation. Did anyone face the same issue, if so what fix helped you to resolve this issue? FYI, I have re-installed the Aras Application but used the same Database which I had during initial setup. I doubt this to be a database level miss. Thank you, Super A.
