Jasper Webinar Thursday 8PM EST

BLOMASKY

Not sure, but think that makes it 1AM Friday Morning GMT.

The agenda has been mentioned in a previous post. If you do attend, have your mic working since I do expect to take questions. At the end of the hour, you should be comfortable in building and deploying Jasper Reports using Jasper Server and Jasper Studio and seamlessly interfacing it to Aware.

the url is: join.me/bruceLomasky

I will record it (if I remember to press the right buttons!) so those who don't attend can watch it at their leisure.

Bruce

weblike

Great Bruce,
Please do it at beginner level and don't forget to record at HD resolution 🙂. I will buy you that Martini.

Thanks a lot for doing this.

tford

Thanks so much for recording it, Bruce!

BLOMASKY

only thank me AFTER I do record it. (Figure if I screw up, I can always blame the Martini!)

Latest Favorite:
Deep Eddy Grapefruit or Blackberry Vodka, Shaken over Ice. (Deep Eddy has real fruit in it with no sugar added. mmmm!)

Bruce

4xjbh

A great whirlwind webinar. Thank you very much.

BLOMASKY

OK, I "THINK" I did press the right button to record it. Perhaps the recording is here:

https://recordings.join.me/H18yES0KIEeSF4vodmiYsA

Bruce

tford

Thanks so much Bruce!

I've also added a link to your video on the master list of tutorial videos at:
https://www.awareim.com/forum/d/8771>

RentProperty

Thank you very much Bruce!! This will help a lot! Look forward to start experimenting.
Just one question... How would you create a document to save in aware im? I.e. if you an object with document attribute and you want to compile a report amd store it in Aware in that document attribute instead of using DISPLAY URL? Is that still possible?

BLOMASKY

I do not know how to store a jasper report in awareIM. I know there is a .JRXML file that compiles down to a .JASPER file. Without knowing how Aware stores documents, I have no idea how it could be incorporated into aware. Again, Aware documents don't have any SQL written. The engine handles that for you. When writing a Jasper report you have to write (or copy) the SQL statement.

Perhaps Support can give you an idea if this is doable but I would guess not.

Bruce

customaware

Just one more thing Bruce....

Wondering if you know how to print an Aware Picture attribute on a Jasper report?

RentProperty

Mmm. Thanks Bruce. Will wait to hear what support says. The jasper Studio software is very powerful and flexible. It his can be the new report writer in V8 it will be awesome, but need to be able to generate and Save to a document attribute.

Once again thank you for sharing.

weblike

Hi Bruce,

Now that 8.1 has the REST feature, did you tried to access reports through web service from Jasper Server?

Thx,

BLOMASKY

weblike wrote
Hi Bruce,

Now that 8.1 has the REST feature, did you tried to access reports through web service from Jasper Server?

Thx,

I did NOT. Since I just want to show the PDF output to the users I am still using the same DISPLAY URL. I find the Jasper UI for viewing reports as only OK. It does give you options to change the output format, page through reports, but for my needs, PDF works fine. (and, as someone smarter than me once said, "if it ain't broken don't change it")

Bruce

weblike

Bruce,

Everyone with the report url can access it...If a tenant hints the ID number of an invoice which is for other tenant-> will see information that is not for him.
I want to pass in the jasper report URL a token with a non-persisted object, so that token dies after the report is viewed on the screen .

I create a non persisted BO "BOMytoken" with "token" field
Process :
CREATE BOMyToken with BOMyToken.token="some random string"
DISPLAY URL "SystemSettings.Jasperpath"+'&myInvoiceID='+Invoice.ID+'&myTokenVariable='+BOMyToken.token

1 question: How can I make Jasper be aware of that token existence and only when a valid created token to display the report?
I hope I have explain it clear enough.
Thank you in advance.

weblike

weblike wrote
Bruce,

Everyone with the report url can access it...If a tenant hints the ID number of an invoice which is for other tenant-> will see information that is not for him.
I want to pass in the jasper report URL a token with a non-persisted object, so that token dies after the report is viewed on the screen .

I create a non persisted BO "BOMytoken" with "token" field

Process :
CREATE BOMyToken with BOMyToken.token="some random string"
DISPLAY URL "SystemSettings.Jasperpath"+'&myInvoiceID='+Invoice.ID+'&myTokenVariable='+BOMyToken.token

1 question: How can I make Jasper be aware of that token existence and only when a valid created token to display the report?
I hope I have explain it clear enough.
Thank you in advance.

Figure it out...It's pretty easy infact.
Don't have to use a non-persisted BO.
BOMyToken.token =AS_STRING(ROUND(RANDOM()*10000000,0))

In jasper Report you have to remake the SQL statement to include the JOIN with BOMyToken and add a Parameter to the report
After call the report with url -> in process add this "DELETE BOMyToken"
Pretty easy...
cheers,

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:
Import Document from URL (comment)&hilit=curl#p47329

The process looks like this:

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:

the generated URL = is correct
The "EXECUTE PROGRAM" does generates the command correctly
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,

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...

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...

Yes, I'm using fully Jasper Server Reports
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.
MyTokens.webToken is created by a rule in BO MyTokens
IF MyTokens IS NEW Then
MyTokens.webToken=RANDOM(.............)

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/Accounts/AC95xx655d2cbe4764ee90eb23f78/Messages.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

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).