Rename file from content of an xml

More
2 years 3 months ago #23794 by downing
Hello everyone,

Is it possible to rename the filename of a pdf by the content of an xml sent with it?

The pdf and the xml always have the same file name at the beginning.

PDF: BLP_INVOICE_7beb2c0a-f6df-4a0b-bbb4-e43945b139cc_20240517_072002_result.pdf
XML: BLP_INVOICE_7beb2c0a-f6df-4a0b-bbb4-e43945b139cc_20240517_072002.xml

--> PDF:pinv_1010_58044_INV24A004-30_610013842.pdf


Fixed Text "pinv_"
<ReceiverId> "1010" &"_"
<SenderAddress><Id> "580844" &"_"
<InvoiceNum> "INV24A004-30" &"_"
<PurchaseOrderPosition> "610013842"

certain special characters should also be eliminated
e.g.
%, &, {, ...

Thx Thomas

Please Log in or Create an account to join the conversation.

More
2 years 3 months ago #23796 by admin
Am I correct in my assumption that pdf file name is calculated based on on the content of XML file?
If so can you provide us with an example of xml file please?
Just zip it and attach it here.
 

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
2 years 3 months ago #23797 by downing
Hi Mike,

Can I send the Files direct to you?
There are some Company Data in it.

Greets
Thomas

Please Log in or Create an account to join the conversation.

More
2 years 3 months ago #23798 by admin
Sure

email it to support@etl-tools.com
 

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
2 years 3 months ago #23799 by admin
I have emailed you a working example.

Here is the screenshot


Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
2 years 3 months ago #23800 by downing
Thanks Mike

I'll test it asap

Thomas

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save