You can translate the question and the replies:

source file info

Hi, I found some interesting predefined stored procedures here, but as far as I've seen, they don't deliver output I'm looking for: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_procedures# From source files as xml, delimited, excel, .. we are trying to find the file name, file location (including server/pc name?) , can we find this information in a stored procedure? we found already some information using get_elements() , but this did not include the original file name and location. kind regards
user
23-07-2018 03:38:24 -0400

3 Answers

Hi, I feel that the "FileSystem Custom Wrapper" from DenodoConnects will solve this for you. If you are a user with valid support access, you can download this wrapper from our [Support Site](https://support.denodo.com/resources/denodo-connect/list/Denodo%207.0) and use it. Another user with a similar request asked this as well, and the [answer](https://community.denodo.com/answers/question/details?questionId=9060g0000004EgmAAE&title=CSV+Filename+Column) given will be helpful to read, in my opinion. Hope this helps!
Denodo Team
23-07-2018 14:49:58 -0400
Hi, thank you for this information, verry usefull. I installed the denodo-filesystem-customwrapper-6.0 JAR. The case is, we use view_dependencies() in a custom stored procedure we are creating. When dependency_type = 'Df Datasource', I want to find more information (file name, path,..) regarding that file, using the dependency_name and input_database_name fields. As far as I see the documentation, I cannot get this information using the filesystem plugin? Or can anyone here give me advice in how to retreive this info kind regards
user
24-07-2018 09:41:42 -0400
Hello, As per this answer [here](https://community.denodo.com/answers/question/details?questionId=9060g0000004EgmAAE&title=CSV+Filename+Column), you can do what is described to get the file name, folder and the path. I think this solution fits relatively close to what you are looking for. Hope this helps!
Denodo Team
07-08-2018 15:14:16 -0400
You must sign in to add an answer. If you do not have an account, you can register here