Replacing {{placeholders}} in html file

More
2 years 3 weeks ago - 2 years 3 weeks ago #23962 by prashant
Hi, 
I have a html file containing placeholders like 

dear {{full_name}}, 
We have received your application to apply to {{company}}. We will revert to you shortly 

thanks again {{full_name}}

how do I pass values to these , so they can be replaced with variables of choice .

do I need to recreate the html file always using text output or I can use template file and replace values inside ? 
Last edit: 2 years 3 weeks ago by prashant.

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

More
2 years 3 weeks ago #23963 by admin
Am I correct in my assumption that this file will become body of html email?

Mike
ETL Architect

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

More
2 years 3 weeks ago - 2 years 3 weeks ago #23964 by prashant
Hi Mike, 

actually we are evaluating prince xml as an alternative to (ETL sql)reporting feature . We create an HTML file, run a package using prince to convert the html to pdf then 

short answer - no it won’t become 
Last edit: 2 years 3 weeks ago by prashant.

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

More
2 years 3 weeks ago #23965 by admin
1 You can use report generator to create pdf files.
Some of our customers use it to generate invoices 

2 You can use file operation to replace text in html files
(There are other ways of doing it as well) 

Mike
ETL Architect

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

More
2 years 3 weeks ago #23966 by prashant

2 You can use file operation to replace text in html files
(There are other ways of doing it as well) 

Could you walk me through other ways of doing this?

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

More
2 years 3 weeks ago #23968 by Peter.Jonson
You can load template into variable using script

Here is basic example.


 

Peter Jonson
ETL Developer

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