Larry_Jones
Legendary Poster
Yet another Media Objects question/issue due to Oracle's lack of Features and Tools related to File Attachments.
When using the old (ActiveX) OLE types of attachments user's could choose a "Ole Queue" which in turn mapped to a specific folder on a server.
So Accounting attachments could have their own queue/directory, Sales their own, Purchasing, etc.
So for us in our going forward environment (9.2, no more IE/ActiveX) the OLE attachments are out and just Plain Jane file attachments are allowed.
When a user does a File Attachment (non-OLE) the user has no Control of what Queue (ie Folder on the Server) will be used. JDE will assign it to the First 05 Type defined in P98MOQUE - by default this is HTMLUpload.
Why do we care you may ask? Well in part its because we have hundreds of thousands of these attachments and we'd like to not over-burden the File System (response time, backups, etc) with too many files in one folder. Plus I suppose I'm being somewhat OCD about it
So net, net my question is: Does anyone have a neat trick for allowing the user to Select the File Queue (as defined in P98MOQUE) when attaching a file?
If we can't find one our alternative is to run a periodic script that, based on Object Name / GT Type, moves file attachments from the HTMLUpload directory to another (such as Accounting ...) and adjusts the F00165 entry accordingly.
Thanks for your consideration of my issue.
When using the old (ActiveX) OLE types of attachments user's could choose a "Ole Queue" which in turn mapped to a specific folder on a server.
So Accounting attachments could have their own queue/directory, Sales their own, Purchasing, etc.
So for us in our going forward environment (9.2, no more IE/ActiveX) the OLE attachments are out and just Plain Jane file attachments are allowed.
When a user does a File Attachment (non-OLE) the user has no Control of what Queue (ie Folder on the Server) will be used. JDE will assign it to the First 05 Type defined in P98MOQUE - by default this is HTMLUpload.
Why do we care you may ask? Well in part its because we have hundreds of thousands of these attachments and we'd like to not over-burden the File System (response time, backups, etc) with too many files in one folder. Plus I suppose I'm being somewhat OCD about it
So net, net my question is: Does anyone have a neat trick for allowing the user to Select the File Queue (as defined in P98MOQUE) when attaching a file?
If we can't find one our alternative is to run a periodic script that, based on Object Name / GT Type, moves file attachments from the HTMLUpload directory to another (such as Accounting ...) and adjusts the F00165 entry accordingly.
Thanks for your consideration of my issue.