Skip to main content
Solved

Document Management - Moving File Repository

Did this topic help you find an answer to your question?
Show first post

Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32

…

 

/Mathias
Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
nicwlk wrote:

Currently one of the customers I am working with, use DBMS_LOB.getlength function in a custom field to get the size of a document directly from Edm File Storage. 

In case we move documents from database to a FTP , will it be possible to fetch the file size? Is there any method we can fetch the size from a FTP/Shared folder? 

Hi,

It is possible, but I'm not sure I would recommend it. We have a method for it but, as you might expect, it needs to get "outside" the database, communicating with the FTP server. We do this via our middle tier code in Java, and we call that Java code via the PL/SQL access provider.

Having that being called as the user populate data is asking for performance problems. If I am right and they get problems, we would not accept that as a bug.

The warning aside, this is the method:

Edm_File_API.Get_Repository_File_Size

Why are they doing this in the first place? What is this information telling the user?

Thanks!

/Mathias
 

/Mathias
chgalk
1 person likes this
  • chgalk
    chgalk
N
Do Gooder (Employee)
Forum|alt.badge.img+2
  • nicwlk
  • Do Gooder (Employee)
  • April 30, 2021

Thank you Mathias for the answer. 

 

Customer use this custom field to see whether the physical file is connected to ORIGINAL or VIEW record in EDM_FILE_STORAGE. 

 

/Nicum

Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
nicwlk wrote:

Thank you Mathias for the answer. 

Customer use this custom field to see whether the physical file is connected to ORIGINAL or VIEW record in EDM_FILE_STORAGE. 

Do they use the size to determine if it is an original file or a view copy? Why not look at the file type?

 

 

/Mathias
B
Do Gooder (Customer)
Forum|alt.badge.img+3
  • BjornH
  • Do Gooder (Customer)
  • January 27, 2022
Mathias Dahl wrote:
nicwlk wrote:

Thank you Mathias for the answer. 

Customer use this custom field to see whether the physical file is connected to ORIGINAL or VIEW record in EDM_FILE_STORAGE. 

Do they use the size to determine if it is an original file or a view copy? Why not look at the file type?

 

 

I do believe majority of customers in Norway have this set in base profile. Both nice to see the size of file before you download (largest we have is 5,5 GB), as well as seeing there actually is a file there and not only an “empty” record. For documents with Original files you can also see if a View file exist.

Bjørn T. Hetland
Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
  • Mathias Dahl
  • Superhero (Employee)
  • January 27, 2022

Thanks for the input, @BjornH !

/Mathias
B
Do Gooder (Customer)
Forum|alt.badge.img+3
  • BjornH
  • Do Gooder (Customer)
  • May 27, 2022

Hi @Mathias Dahl 

I have the same question as @nicwlk. Almost sure I’ve seen somewhere that it is possible, but not recommended for performance issues, though may mix up with something else.

We have currently moved majority of documents out from DB to local shares on application server, that way we are 100% sure there are never mix up between Prod and Test environment. There are some API’s not working well with “share”, but nothing we haven’t been able to work our way around, except the file-size that is needed on occasions. 

Cheers, Bjørn

Bjørn T. Hetland
Mathias Dahl
1 person likes this
  • Mathias Dahl
    Mathias Dahl
Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
BjornH wrote:

Hi @Mathias Dahl 

I have the same question as @nicwlk. Almost sure I’ve seen somewhere that it is possible, but not recommended for performance issues, though may mix up with something else.

If you mean check the file size, yes it is discussed above, and I also mention a possible performance impact there.

 

 

BjornH wrote:

We have currently moved majority of documents out from DB to local shares on application server, that way we are 100% sure there are never mix up between Prod and Test environment. There are some API’s not working well with “share”, but nothing we haven’t been able to work our way around, except the file-size that is needed on occasions. 

Good to know, thanks!

 

/Mathias
B
1 person likes this
  • B
    BjornH

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings