Jasper Webinar Thursday 8PM EST

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: Jasper Webinar Thursday 8PM EST

Post by weblike »

Playing around with Jasper Reports, very powerfull ReportServer...awesome reports.

I manage to open the reports as PDF => this is ok
2.I want to achieve to import this PDF into a BO, so I use cURL like here:
http://www.awareim.com/forum/viewtopic. ... url#p47329

The process looks like this:

Code: Select all

CREATE MyTokens WITH MyTokens.CompanyOwner=Offers.CompanyOwner,MyTokens.ObjectID=Offers.ID
Offers.PDF_path=Offers.CompanyOwner.DocsPath+'\Offer--'+Offers.ID+'.pdf'
MyTokens.URL=SystemsSettings.Jasper_Server_PAth+Offers.ID+'&webToken='+MyTokens.webToken
EXECUTE PROGRAM '<<SystemSettings.curl_install_path>>\curl.exe -o <<Offers.PDF_path>> <<SystemSettings.SpecialDQ>><<MyTokens.URL>><<SystemSettings.SpecialDQ>>'
SystemSettings.SpecialDQ= " (double quotes)

Looking in Log Viewer I see:
1. the generated URL = is correct
2. The "EXECUTE PROGRAM" does generates the command correctly
3. BUT the result is an empty PDF.

IF I execute manually from CMD (command prompt) the CURL command generated by "EXECUTE PROGRAM" ------> it appears a correct PDF file with desired data.

Any advice would be highly appreciated!!!!

Thx,
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Jasper Webinar Thursday 8PM EST

Post by Jaymer »

george, am confused

1) are you using the full Jasper, like Bruce showed us in this seminar?
2) would be nice if you could paste in exactly whats in the log. whats the values of your fields, the URL, etc.
3) You'd still have to IMPORT DOCUMENT to get that PDF attached, correct?
4) I don't see value for MyTokens.webToken

jaymer...
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: Jasper Webinar Thursday 8PM EST

Post by weblike »

Jaymer wrote:george, am confused

1) are you using the full Jasper, like Bruce showed us in this seminar?
2) would be nice if you could paste in exactly whats in the log. whats the values of your fields, the URL, etc.
3) You'd still have to IMPORT DOCUMENT to get that PDF attached, correct?
4) I don't see value for MyTokens.webToken

jaymer...
1. Yes, I'm using fully Jasper Server Reports
2. As soon as I get to the office I will provide link
3.I know ....I have that rule disabled....1st I want to see that the PDF is created correctly into the folder, than I deal with import part.
4. MyTokens.webToken is created by a rule in BO MyTokens
IF MyTokens IS NEW Then
MyTokens.webToken=RANDOM(.............)
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

curl example

Post by Jaymer »

here's a curl string I have successfully executed.
Only diff is I use a NP tempCurl BO to write the string into, then EXEC that string.

I think the key will be seeing exactly whats in the SERVER OUTPUT/TOMCAT OUTPUT windows while this is trying to execute.

CREATE tempCurl WITH tempCurl.theCommand=`curl -XPOST `+
`https://api.twilio.com/2010-04-01/Accou ... sages.json `+
` -d ` +SystemSettings.DQ +`Body=` + ContactSMS.Message +SystemSettings.DQ +
` -d ` +SystemSettings.DQ +`To=+1` + REPLACE_PATTERN(Lead.Phone,'_','') +SystemSettings.DQ +
` -d ` +SystemSettings.DQ +`From=+18005551212` +SystemSettings.DQ +
` -u AC95d46334f6xxxx4ee90eb23f78:2d8b0eb3bxxxx4f9e5c147b1`
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Jasper Webinar Thursday 8PM EST

Post by Jaymer »

George

Bruce is working on a totally new methodology for doing exactly what you need...
From Aware, execute a Jasper report (passing any needed params),
and have it saved to a custom/uniquely named File.

And I think be able to email it directly (not from Aware) from that Process.

This is using NODE technology.
Easily callable from Aware with EXEC_JS.
If Emailing, pass it the relevant host/userid/password parms to login to SMTP.

Should finish by the weekend (1 or 2 days).
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: Jasper Webinar Thursday 8PM EST

Post by weblike »

Jaymer wrote:George

Bruce is working on a totally new methodology for doing exactly what you need...
From Aware, execute a Jasper report (passing any needed params),
and have it saved to a custom/uniquely named File.

And I think be able to email it directly (not from Aware) from that Process.

This is using NODE technology.
Easily callable from Aware with EXEC_JS.
If Emailing, pass it the relevant host/userid/password parms to login to SMTP.

Should finish by the weekend (1 or 2 days).
Awesome...looking forward to see it.
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
bwalk
Posts: 47
Joined: Thu May 10, 2018 12:10 am

Re: curl example

Post by bwalk »

Jaymer wrote:here's a curl string I have successfully executed.
Only diff is I use a NP tempCurl BO to write the string into, then EXEC that string.

I think the key will be seeing exactly whats in the SERVER OUTPUT/TOMCAT OUTPUT windows while this is trying to execute.

CREATE tempCurl WITH tempCurl.theCommand=`curl -XPOST `+
`https://api.twilio.com/2010-04-01/Accou ... sages.json `+
` -d ` +SystemSettings.DQ +`Body=` + ContactSMS.Message +SystemSettings.DQ +
` -d ` +SystemSettings.DQ +`To=+1` + REPLACE_PATTERN(Lead.Phone,'_','') +SystemSettings.DQ +
` -d ` +SystemSettings.DQ +`From=+18005551212` +SystemSettings.DQ +
` -u AC95d46334f6xxxx4ee90eb23f78:2d8b0eb3bxxxx4f9e5c147b1`
Jaymer, I'm trying to get Twilio working in AwareIM, I have a few questions if you would be so kind.
1- how do you execute the Curl Command once you have built and saved it?
2- What is in SystemSetting.DQ?
It would be great to get Twilio working in AwareIM
Thanks, Bill
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: Jasper Webinar Thursday 8PM EST

Post by weblike »

weblike wrote:
Jaymer wrote:George

Bruce is working on a totally new methodology for doing exactly what you need...
From Aware, execute a Jasper report (passing any needed params),
and have it saved to a custom/uniquely named File.

And I think be able to email it directly (not from Aware) from that Process.

This is using NODE technology.
Easily callable from Aware with EXEC_JS.
If Emailing, pass it the relevant host/userid/password parms to login to SMTP.

Should finish by the weekend (1 or 2 days).
Awesome...looking forward to see it.
Hello Jaymer,
I'm back to this problem.
I'll appreciate your help in guiding how to do this with node.js.
thank you
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
Post Reply