Vtiger 5.4 print out value from external database into email template
$30-250 USD
Lukket
Slået op over 9 år siden
$30-250 USD
Betales ved levering
Task is to retrieve values from an external MySQL database through a query and print it out in an email template in vtiger 5.4
I have a query with different values that I want to print in an email and send out
Example
I do a search and then get out:
Quantity of posts
value1
value2
value3
I will then print out these values in a template where the different values has its own specific location for each search.
In addition, it will also calculate the Quantity with a fixed price for this search as quantity * price = final price and also insert final price value in an specific location in template.
I have EMAIL Maker 540.04.05 from IT Solutions4You installed so I will use their template system for the email.
For your information, I will have about 100 different templates for different searches but what I ask is that you make one and write me how I then can create same for my other searches.
VERY IMPORTANT that you have high knowle about vtiger 5.4 and done similar work in the past.
I do not pay anything until I seen that this works 100%.
If you are unsure if you can complete this so do NOT BID.
I decline with thanks any advertising, etc. in the body when you bid, write important information regarding this project, nothing else.
If any questions just ask
Hi,
I am an ex vtiger team member with 3+ years experience on the team and 3+ years working as freelance consultant.
I suggest you to use a separate variable system for the external values so that we can differentiate between them and the vtiger ones. Also, the vtiger database user should be given read access to the external db if possible.
If you want, you can contact me on skype to discuss any details. My skype handle is vtmodules. Let me know your thoughts.
Thanks
vTiger Customization Expert. 12+ years of experience. Did many PDF and Email templates Customization. Very familiar with vTiger 5.4, Email Maker and PDf Maker. Can do the following in 1 day:
1. Customize Email Maker to get values from custom queries (that come from external database)
2. Coach you on how to create other templates from different queries.
Feel free to contact me anytime.
Thank You