Hello,
In Apps9, is it possible to stop checking in some documents over a certain file size?
Does it need to create a macro?
Many Thanks,
Anne-Sophie
Solved
Document Management file size
Best answer by Mathias Dahl
Hi again,
I made a quick test, and the macro approach works in IEE in Apps 9. I created a simple macro that checks the file size when checking in and which raise an error if it is too large. Here is what how it looks:
After the user has clicked OK, the process stops. He can try to check in another file.
Here is the macro code. You need to read up in the documentation about macros on how to define the macro:
Public Sub SizeCheck ()
Const maxFileSize = 10000
strFile = ClientScriptValues.Item("LOCAL_FILE_1").Value
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.GetFile(strFile)
If objFile.Size > maxFileSize Then
Err.Raise 1000, "File size check", "File is larger (" & objFile.Size & ") than the maximum specified file size (" & maxFileSize & "). Try again and select a smaller file."
End If
End Sub
This might work in IEE in Apps 10 as well. Perhaps not in Aurena, not sure.
Good luck!
/Mathias
+10Hi Anne-Sophie
I am pretty sure it is not possible to restrict the file size from within IFS Applications. One of our team looked into this before.
Of course there may be a way to do this from the Oracle side of things, but it is not something we decided to do.
Regards
Mike
+10Probably worth raising a question with IFS Support, as I think this is a fair request/feature. Of course this does not help you immediately.
Of course there may be a way to do this that we have not discovered. Will be interesting to see if anyone else comments.
Mike
+32A check in macro could probably do something here, but it would need to be tested. The macro, for sure, could check the file size, but I am unsure if it could stop the check in from happening in a good way. Or, well, it might be able to move the file away such that, when IFS tries to upload it, it will not find it, or perhaps raise an error and hope the error in the macro stops the whole check in process. It might cause some bad side effect though (file status being stuck in some bad status).
A custom event might be able to do something on the database server (check the file that was just checked in, and delete it), but it would happen “after the fact”, so the network/bandwidth would still be “consumed”. This would require some careful testing also to make sure the database does not end up in a bad state.
It would be better with a proper support for this, if you want something stable. For IEE, it should not be a problem, technically, to do it. For Aurena it would be harder, at least on all platforms (I don’t think the JavaScript code in web client is allowed to check the file size, but I have not researched it).
Or, you could educate your users :)
Mathias,
Thank you very much for the reply. I don’t know why but I did not get a notice of your answer and just seen it today.
I tried the macro but it looks like it does not know the file size at check in point.
Thanks for taking the time, we might just stick to educating :).
+32Hi again,
I made a quick test, and the macro approach works in IEE in Apps 9. I created a simple macro that checks the file size when checking in and which raise an error if it is too large. Here is what how it looks:
After the user has clicked OK, the process stops. He can try to check in another file.
Here is the macro code. You need to read up in the documentation about macros on how to define the macro:
Public Sub SizeCheck ()
Const maxFileSize = 10000
strFile = ClientScriptValues.Item("LOCAL_FILE_1").Value
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.GetFile(strFile)
If objFile.Size > maxFileSize Then
Err.Raise 1000, "File size check", "File is larger (" & objFile.Size & ") than the maximum specified file size (" & maxFileSize & "). Try again and select a smaller file."
End If
End Sub
This might work in IEE in Apps 10 as well. Perhaps not in Aurena, not sure.
Good luck!
/Mathias
/Mathias
Hi Mathias,
I tested it recently and it worked really well. Thank you so much for your help.
Kind Regards,
Anne-Sophie
+32asmackenzie wrote:
Hi Mathias,
I tested it recently and it worked really well. Thank you so much for your help.
Kind Regards,
Anne-Sophie
Glad to hear it worked, thanks for replying back!
+9+32VsoMDjewP wrote:
Have a look at the official end-user documentation about macros. It explains how the macro configuration works and the steps needed to setup a macro.
Let us know if there are details there that are not clear.
Good luck!
/Mathias
1 person likes this
+2
VsoMDjewP wrote:
Have a look at the official end-user documentation about macros. It explains how the macro for IFS 10
+32Did you want to add a comment,
Hello
Thanks for the script example but it seems it does not work if you attach 2 or more files simultaneously (by drag and drop for example).
Could anyone confirm?
At the same time Macro works perfectly for single attachment. Now I am searching for the way how to delete shortcut created without any connection to the file in this case. IFS EE 10.
Thanks.
+32Alexander wrote:
Hello
Thanks for the script example but it seems it does not work if you attach 2 or more files simultaneously (by drag and drop for example).
Could anyone confirm?
At the same time Macro works perfectly for single attachment. Now I am searching for the way how to delete shortcut created without any connection to the file in this case. IFS EE 10.
Are you referring to drag and drop in Aurena or IEE? In Aurena, macro execution is not possible to combine with drag and drop. If this is IEE, let us know some more details about what you tried.
Hello
I am referring to the IFS10 EE .
First issue is that macro does not execute when you drag and drop more than one file into the attachments section. It just ignores any macro, independently what it does.
Second issue is that if for example macro prevents attaching large files than as the result we have shortuct created with no file linked to it. So we would like not to see that as users could understand it in a different way as a success case.
Thank you.
+32Thanks!
What I can say is that there are certainly limitations when using macros to implement a file size check and you seem to have found some of them.
I recommend a proper modification instead of using a macro, if a file check is important to you and sing you have hit limitations in the macro functionality.
+1Hi
One of the customer needs to limit the upload PDF file size to 5 MB in general(ex : attaching a document to customer order). Is there any other way to limit the file size except check in macros and custom events? Also, what should be the most suitable according to this customer requirement?
+32I can see a number of options, if they don't want to or cannot use macros or a custom event to solve this:
1. Educate the users 🙂
2. Create an idea here on IFS Community such that we can consider this for future development.
3. Do a modification.
4. Run a quick report at regular intervals, looking for documents with large PDF files, and then ask the creators to upload smaller versions of those files.
I have some questions of my own:
1. Why do they want to do this in the first place?
2. Why can't they rely on a macro or custom event?
Thanks!
+2Hi
I was trying this and experiencing the below error in one of our reference environments. Could you please help me here and guide me on what is the mistake done by me?
Thank you and Best Regards,
Chamuditha
+32It looks like there is something in your macro that says "IFS_EXEC" which it's not happy about.
/Mathias
1 person likes this
+2Hi Mathias,
I was able to get this sorted, and it worked as shown below.
However, I was trying to get this on Aurena Client but it didn’t work in the same environment. are there any basic conditions and data, that I have to setup, to get this sorted in the Aurena client?
Thank you and Best Regards,
Chamuditha
+32It should work in Aurena as well I think, but if this is on Apps 10, we don't run macros in that many places. Also, getting hold of the local file can be a bit different in a macro that's running in Aurena. What did you try, what happened?
Hi,
the macro is applied everywhere in IFS where we have the possibility to attach a document?
I found there is a Max File Size, using this could be Ok too? Document Classes (ifs.com)
Thank you,
Eleazar
+32Eleazar_AyaviriCarrillo wrote:
Hi,
the macro is applied everywhere in IFS where we have the possibility to attach a document?
Hi Eleazar,
No, the macro runs in screens where macros has been enabled in Apps 10 Aurena (not all places) or IFS Cloud (all places in the web client where a document can be checked in) and if the Aurena Agent is installed and enabled for the environment. The Aurena Agent, and therefore document macros, only works on Windows.
I found there is a Max File Size, using this could be Ok too? Document Classes (ifs.com)
I'm not sure what you mean, sorry. Do you want to fetch the size there, and use that in the macro? That would require some special coding since the document macro would not have access to those values.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.