Solved How to retrieve the name of an extracted Base64 file?

Hi,

We are using the parameters "Extract Base64Binary To File" and "Base64Binaries Extract Directory", in the template "Action Process Load Xml to Rdbms".
It works well: a file is generated.
The name of this file looks like that: "base64Binary_665ea145-83b7-4f33-9e41-2091d0115fd2.data".

My questions are :
- how to retrieve its name? The aim is to rename and move it.
- how to manage the different .data files when there 2 or 3 base64 strings to extract from the same XML file?

Thanks.

Hi,

These file names are random names.
If you map the Binary64 element to a VARCHAR column, then this column will contain the path to the ".data" file.
Once this is done, the idea is to SELECT the file list from the table, and process each file using a Bind link.

We can prepare an example if you want.

Ok, I see the idea.

I'll try this solution:
- update my mapping,
- add a SqlToParameters to get the filename,
- add a moveFiles and use the parameter.

I keep you up to date.

I would use SqlOperation

---

(bind)

---

> MoveFile

... but maybe you have specific reasons for using SqlToParameters which I don't know.
Anyway let us know what you come up with

No, you are right, your method is better
I will focus my test with yours.
Thank you.

Ok, I've tried to manage the process, it works perfectly.



I still have a question.
To get the path and the name of my result file("File To File" parameter), I use two substitution methods :
%x{$FILE_BASE64/tech:path()}x%\%x{$CONTRAT_PDF/tech:physicalName()}x%
Is there a method which allows me to get the full path+name, based on the metadata "CONTRAT_PDF"?

Good news
For the full file path, try: %x{$CONTRAT_PDF/tech:filePath()}x%

Thank you Thomas.

A last question please...
In the "Base64Binaries Extract Directory" paramater of the template, I want to get the path as defined in the metadata.
What is the method?

I tried
%x{$PATH_BASE64/tech:physicalPath()}x%
%x{$PATH_BASE64/tech:path()}x%
but it doesn't compile.
What is the correct syntax or correct method?

Thanks again.

What is $PATH_BASE64?
I assume it is a File metadata, dragged on the "Rename file" action.
- Make sure this metadata link has the property "visibility" set to "parent", so that the whole process can use it (not only the current action).
- Create a parameter on the main process, named "extractdir", value "%x{$PATH_BASE64/ref:directory()/tech:path()}x%"
- Then in your template property, use ${~/extractdir}$