Showing posts with label for. Show all posts
Showing posts with label for. Show all posts
Monday, March 9, 2015
Updates on Authentication for Gmail IMAP POP and SMTP
We’d like to highlight some recent and upcoming changes around authentication for Gmail IMAP, POP, and SMTP.
Additional Scrutiny for Password Authentication
As previously announced, Google has begun increasing the security checks that occur when logging in with a user’s Google password. This includes access via Gmail IMAP, POP, and SMTP-MSA. It does not apply when authenticating with OAuth 2.0 via the XOAUTH2 mechanism.
If the checks detect anything suspicious about a password login attempt, our servers may deny login and return an error message requesting that the user first login to Google through a web browser. They may also require the user to explicitly enable “Less Secure Apps” on their account. Applications that perform password authentication to IMAP, POP, or SMTP are examples of "Less Secure Apps".
We strongly encourage developers to use OAuth 2.0 (via the XOAUTH2 mechanism for IMAP, POP, and SMTP) in order to better protect their users.
XOAUTH support ends May 5, 2015
The OAuth 1.0 XOAUTH authentication mechanism for Gmail IMAP and SMTP-MSA is deprecated and will stop being supported on May 5, 2015. Developers must migrate to XOAUTH2 in order to continue authenticating to Gmail after that date. You can migrate existing users without their intervention by following the instructions in this migration guide. Instructions for developing your XOAUTH2 code are in the XOAUTH2 documentation.
Posted by Jamie Nicolson, Gmail Software Engineer
Read more »
Additional Scrutiny for Password Authentication
As previously announced, Google has begun increasing the security checks that occur when logging in with a user’s Google password. This includes access via Gmail IMAP, POP, and SMTP-MSA. It does not apply when authenticating with OAuth 2.0 via the XOAUTH2 mechanism.
If the checks detect anything suspicious about a password login attempt, our servers may deny login and return an error message requesting that the user first login to Google through a web browser. They may also require the user to explicitly enable “Less Secure Apps” on their account. Applications that perform password authentication to IMAP, POP, or SMTP are examples of "Less Secure Apps".
We strongly encourage developers to use OAuth 2.0 (via the XOAUTH2 mechanism for IMAP, POP, and SMTP) in order to better protect their users.
XOAUTH support ends May 5, 2015
The OAuth 1.0 XOAUTH authentication mechanism for Gmail IMAP and SMTP-MSA is deprecated and will stop being supported on May 5, 2015. Developers must migrate to XOAUTH2 in order to continue authenticating to Gmail after that date. You can migrate existing users without their intervention by following the instructions in this migration guide. Instructions for developing your XOAUTH2 code are in the XOAUTH2 documentation.
Posted by Jamie Nicolson, Gmail Software Engineer
Wednesday, March 4, 2015
Do You Want Cheap Books For Your Classroom
There are so many things I love when it comes to my classroom... without card stock, Velcro, clothespins, magnetic tape and magnetic printer paper, I wouldnt know what to do! Ill definitely detail the infinite uses of all of those things one day, but all of those things being said, there is one thing that I am addicted to more than anything else: childrens books!!!
Take a look at how full my bookshelf is in my classroom!

And thats not even all: I have 11 totes full of books in my basement! They are 64 qt. totes and hold 100-200 books!

Obviously, the cost of books can add up quick, especially when we have so many different topics that there are great read alouds for. But, there is a way to get books for your classroom for dirt cheap... library books sales!!! These are probably the best way to build a classroom library!
The best way Ive found library books sales is through this website:

Note: Im not getting paid to promote the website, Im posting it because it honestly is the best!!
Browse through the site to find sales near you. Usually the ones that state "Big Sale!" are pretty good, but only trial and error will really work. You can sign up for a weekly email alerts so youre always aware of the sales in your area (without having to remember to check the website!)
Now, any given day at a library sale is a steal for books... but do you want books for your classroom that are basically free? Of course you do!!!! So you need to go to the book sales on the best day... bag day! Most large library sales have this the last day of their sale. Fill up a whole bag full of books for $5! A lot of places let you even bring your own bag... I get a kick out of people with giant beach bags full of books (ok, so Im usually one of those people but it is funny to watch)!
Not only do I use bag day to stock up on new books for the classroom, but I also use it to fill my treasure chest! The kids just look to bring home books as a prize for their good behavior! I started off this year with two totes full of books for the treasure chest (easily 300 books that I paid a total of $10 for) and all of these books were gone by December! They were the most popular prize as well as the least expensive!
Read more »
Take a look at how full my bookshelf is in my classroom!
And thats not even all: I have 11 totes full of books in my basement! They are 64 qt. totes and hold 100-200 books!

Obviously, the cost of books can add up quick, especially when we have so many different topics that there are great read alouds for. But, there is a way to get books for your classroom for dirt cheap... library books sales!!! These are probably the best way to build a classroom library!
The best way Ive found library books sales is through this website:

Note: Im not getting paid to promote the website, Im posting it because it honestly is the best!!
Browse through the site to find sales near you. Usually the ones that state "Big Sale!" are pretty good, but only trial and error will really work. You can sign up for a weekly email alerts so youre always aware of the sales in your area (without having to remember to check the website!)
Now, any given day at a library sale is a steal for books... but do you want books for your classroom that are basically free? Of course you do!!!! So you need to go to the book sales on the best day... bag day! Most large library sales have this the last day of their sale. Fill up a whole bag full of books for $5! A lot of places let you even bring your own bag... I get a kick out of people with giant beach bags full of books (ok, so Im usually one of those people but it is funny to watch)!
Not only do I use bag day to stock up on new books for the classroom, but I also use it to fill my treasure chest! The kids just look to bring home books as a prize for their good behavior! I started off this year with two totes full of books for the treasure chest (easily 300 books that I paid a total of $10 for) and all of these books were gone by December! They were the most popular prize as well as the least expensive!
Tuesday, March 3, 2015
Facebook Twitter for Learning at IMEC8!

Facilitating a half-day hands-on Facebook & Twitter for Learning workshop on the 13th March (2013) at the 8th International Medical Education Conference (IMEC-2013). Venue: International Medical University (IMU), Malaysia.
- Facebook Group
FACEBOOK & TWITTER WORKSHOP
Today more than one billion people use Facebook, and more than 500 million use Twitter to connect, share and interact with one another. In this workshop, we will explore how we can use Facebook and Twitter to facilitate learning and teaching.
During the hands-on activities, we will learn how to create Facebook Groups to engage students and conduct assignments, and create unique Twitter #hashtags to empower dedicated streams for sharing and learning. Finally, we will explore several Twitter apps to engage students in the classroom and beyond.
LEARNING OUTCOMES
After this workshop, you will be able to:- Use Facebook and Twitter to facilitate learning and teaching.
- Create Facebook Groups/Pages to engage students and conduct assignments.
- Create unique Twitter #hashtags for programmes, courses and events.
- Use Twitter apps to engage students in the classroom (and beyond).
PRESENTATION SLIDES
Facebook for Learning at #IMEC8 from Zaid Alsagoff
CLICK HERE to download (PowerPoint version).
CLICK HERE to download (PowerPoint version).
Twitter for Learning at #IMEC8 from Zaid Alsagoff
CLICK HERE to download (PowerPoint version).
CLICK HERE to download (PowerPoint version).
Facebook and Twitter are still cool learning tools, so dont miss this crash course :)
Sunday, March 1, 2015
Forget Photoshop PowerPoint 2010 Rocks for AHA G!
BEING ATTACKED! HELP!
First, I must make it clear (once and for all!) that I do not work for Microsoft (or get paid in any way by them!), and I am also NO GREAT SUPPORTER of Microsoft products in general, including Microsoft Office 2010. However, I will admit that I have been using PowerPoint ever since I got into e-learning, and have interestingly never stopped loving it, especially in mashing up graphics (Although, PowerPoint can be frustrating at times).
Secondly, no doubt Photoshop fanatics are going to scream foul and use long-winded scientific methods to illustrate all the things that it can do, which PowerPoint cant do. True! But, most educators are not graphic designers, and want to simply develop cool/relevant graphics to spice up, or enhance their websites (e.g. blog), or presentations quickly (EFFICIENCY)! Also, it takes time to master Photoshop (basics), while in PowerPoint you can learn some amazing stuff within seconds.
Thirdly, Apple fanatics are going to say, "What about Keynote?" Yes, of course Keynote is 10 times better than any other presentation tool on planet Earth! But, unless it is so disruptively good that it gives me genuine reasons for me to convert to Keynote instead, well...FORGET IT!
However, I am always open to change, so you never know. For example, I did use Nokia phones for 10 years, but when the iPhone came along, I said Adios Amigo to Nokia. In terms of mobile learning experience (iPhone Vs. Nokia), it was NO CONTEST! Every time I play with a Nokia phone these days, it makes me wonder... What happened? Hopefully, Nokia wakes up, because Finland kind of depends on it being successful. Anyway, my wife bought a Nokia phone yesterday, so it cant being doing that bad. So, if Keynote can do what iPhone did to Nokia, then why not?
Thirdly, Apple fanatics are going to say, "What about Keynote?" Yes, of course Keynote is 10 times better than any other presentation tool on planet Earth! But, unless it is so disruptively good that it gives me genuine reasons for me to convert to Keynote instead, well...FORGET IT!
However, I am always open to change, so you never know. For example, I did use Nokia phones for 10 years, but when the iPhone came along, I said Adios Amigo to Nokia. In terms of mobile learning experience (iPhone Vs. Nokia), it was NO CONTEST! Every time I play with a Nokia phone these days, it makes me wonder... What happened? Hopefully, Nokia wakes up, because Finland kind of depends on it being successful. Anyway, my wife bought a Nokia phone yesterday, so it cant being doing that bad. So, if Keynote can do what iPhone did to Nokia, then why not?
Alright, enough defending... Lets attack!
THANKS, TOM!
First, I would like to thank Tom Kuhlmann for inspiring me to explore PowerPoint as a tool itself to create or mash-up graphics using Clipart (ungroup & group) and images. My first Clipart mash-up in PowerPoint (2007):
Tom Kuhlmann not only inspired me, he also shared my first Clipart mash-up in his post entitled: 3 Sure-Fire Ways to Make Your E-Learning Graphics Sizzle (Great tips, so please read it, too!)
If you notice the image above carefully, you will see my old ZaidLearn header/banner (September, 2007), which was terrible. Anyway, my current blog header is better (I think), and it was developed 95% using PowerPoint (Cropping was done in Microsoft Paint). So, in addition to PowerPoint, I have to admit that I still use Microsoft Paint (cropping) and Notepad (cleaning up hidden PowerPoint/Word/HTML scripts!) a lot, as they empower me to do certain things more efficiently.
THE SPARK!
It was actually Erkki Pung (an awesome designer from Estonia) who kind of sparked me to write this post, as he asked (through e-mail) if I could cook up a short story (for his homepage) about the designing process in e-learning.
That got me thinking, and then I thought, why not write about something that is practical and that basically anyone with the tool in their hand could do, and that got me thinking about how I create graphics for my blog using PowerPoint. Yeah! Why not share my secret graphic design process (oh boy!). As the graphic design process is not overly complex and rather fun, I believe anyone with a few tips can do it.
Besides Photoshop (and PowerPoint) there are tons of other graphic visualization tools that we can use to sizzle photo effects (PhotoFunia), word clouds (Wordle), diagrams (Gliffy), cartoons (ToonDoo), cartoonish animations (GoAnimate & xtranormal), 3D models (Sculptris), etc. In short, we are certainly not limited by choice. Actually, we are overloaded, and many are still clueless (including me!) of all the amazing possibilities we have at our disposal to create attractive, stimulating, and relevant visual learning/thinking triggers, which I call AHA-Graphics or AHA-G (Nothing to do with A-HA...That Norwegian group!).
AHA-G?
When we talk about AHA-G, we are focusing on creating graphics that sparks the reader, or viewer to think about something relevant to what we want to say or write. If the graphic looks out of this world and is attractive is a bonus, but that is not the main objective of an AHA-G. In a way, an AHA-G wants to shock, click, inspire, and make you laugh, all at the same time. If we can shock (emotional engagement), click (Aha, I got it!), inspire (motivate interest), and make you laugh (Haha!)...Now that is a great AHA-G.
To create AHA-Gs, I mostly (92.5%) use PowerPoint, because I still find it the most user-friendly and efficient tool around. Actually, besides using PowerPoint to create cool graphics, animations, and diagrams, you can even trim videos and do some really spectacular things with PowerPoint 2010, which I will illustrate later in this post.
My 5 Favorite AHA-G features in PowerPoint 2010 are:
Oops, I forgot to show you how to create quickly a text bubble, group images (and Clipart), and finally save an AHA-G as a picture (JPG or PNG). This happens when you dont use a script (outline). Anyway, here is part 2, including the missed AHA-G(ems):
Here are some more great examples of using PowerPoint to create graphics that sizzle:
DESIGN PROCESS
If you are wondering how the AHA-G design process works for me, here is brief description:
Here are some of my favorite AHA-G mash-ups:



Using Twitter to Transform the Classroom!

My Most Satisfying PowerPoint Animation!





Yes, I have to admit that I used to use Photoshop to remove backgrounds from images, but in PowerPoint 2010 you have finally got that awesome feature called Remove Background (big button). Now, I can convert completely and ditch Photoshop for good. This means shorter learning curve, less clicks, quicker output, and more AHA-G moments. I arrest my case!
Thats it! Of course it is not the whole story, but at least you got a glimpse on how I create AHA-Gs, and that I am taking sabbatical leave from Photoshop until I am convinced otherwise :)

Tom Kuhlmann not only inspired me, he also shared my first Clipart mash-up in his post entitled: 3 Sure-Fire Ways to Make Your E-Learning Graphics Sizzle (Great tips, so please read it, too!)
If you notice the image above carefully, you will see my old ZaidLearn header/banner (September, 2007), which was terrible. Anyway, my current blog header is better (I think), and it was developed 95% using PowerPoint (Cropping was done in Microsoft Paint). So, in addition to PowerPoint, I have to admit that I still use Microsoft Paint (cropping) and Notepad (cleaning up hidden PowerPoint/Word/HTML scripts!) a lot, as they empower me to do certain things more efficiently.THE SPARK!
It was actually Erkki Pung (an awesome designer from Estonia) who kind of sparked me to write this post, as he asked (through e-mail) if I could cook up a short story (for his homepage) about the designing process in e-learning.
That got me thinking, and then I thought, why not write about something that is practical and that basically anyone with the tool in their hand could do, and that got me thinking about how I create graphics for my blog using PowerPoint. Yeah! Why not share my secret graphic design process (oh boy!). As the graphic design process is not overly complex and rather fun, I believe anyone with a few tips can do it.
Besides Photoshop (and PowerPoint) there are tons of other graphic visualization tools that we can use to sizzle photo effects (PhotoFunia), word clouds (Wordle), diagrams (Gliffy), cartoons (ToonDoo), cartoonish animations (GoAnimate & xtranormal), 3D models (Sculptris), etc. In short, we are certainly not limited by choice. Actually, we are overloaded, and many are still clueless (including me!) of all the amazing possibilities we have at our disposal to create attractive, stimulating, and relevant visual learning/thinking triggers, which I call AHA-Graphics or AHA-G (Nothing to do with A-HA...That Norwegian group!).
AHA-G?
When we talk about AHA-G, we are focusing on creating graphics that sparks the reader, or viewer to think about something relevant to what we want to say or write. If the graphic looks out of this world and is attractive is a bonus, but that is not the main objective of an AHA-G. In a way, an AHA-G wants to shock, click, inspire, and make you laugh, all at the same time. If we can shock (emotional engagement), click (Aha, I got it!), inspire (motivate interest), and make you laugh (Haha!)...Now that is a great AHA-G.
To create AHA-Gs, I mostly (92.5%) use PowerPoint, because I still find it the most user-friendly and efficient tool around. Actually, besides using PowerPoint to create cool graphics, animations, and diagrams, you can even trim videos and do some really spectacular things with PowerPoint 2010, which I will illustrate later in this post.
My 5 Favorite AHA-G features in PowerPoint 2010 are:
- Remove Background
- Artistic Effects
- Picture Styles
- Picture Effects
- Trim Video (Not exactly an AHA-G effect, but I love it!)
Oops, I forgot to show you how to create quickly a text bubble, group images (and Clipart), and finally save an AHA-G as a picture (JPG or PNG). This happens when you dont use a script (outline). Anyway, here is part 2, including the missed AHA-G(ems):
Here are some more great examples of using PowerPoint to create graphics that sizzle:
- Create comic book characters in PowerPoint
- Create a re-usable animated hand animation
- How to easily extend a photos background for PowerPoint
- Visual surprise and slicing image effects in PowerPoint
- PowerPoint tip to create hand holding cards
- Add an easy photo-corner effect to images
- Creating the perspective floor effect in PowerPoint using 3-D Rotation
DESIGN PROCESS
If you are wondering how the AHA-G design process works for me, here is brief description:
- STEP 1 - Visualization
When I am exploring a topic (upcoming article) in my head, I like to let the story (idea) linger in my head for at least 4-5 days before I begin writing (Something I learned from Einstein, I think!). To support the story, I also try to visualize an AHA-G I would like to include to spark the creative thinking cells even more. The end product always looks very different from what I originally thought, which I find truly exciting and inspiring. It is like Forest Gumps mum famous quote, "Life was like a box of chocolates. You never know what youre gonna get." AHA-Gs should be a visualized fusion of the expected and unexpected. So, if it can shock, click, inspire and even make you laugh , now that is in AHA-G worth spending perhaps 1-2 hours to mash-up. Usually, it takes me around 30 minutes to develop the main AHA-G for each article. Most time is spent finding images and moving them around to reach my AHA-G moment. - STEP 2 - Find Images to Mash-up
So, this is where you are going to break the copyright law...NOT! Personally, I mostly use Clipart, Pictures (from Microsoft), and Google Image search. So, I might be breaking the law quite often frankly, and I might one day be sued by Yoda and Mr. Bean. But, sometimes we need to take risks to inspire people to think (Dont quote me on that!). If you are looking for images to infuse into your AHA-Gs that will not get you into trouble, this post by Tom Kuhlmann has a pretty good collection of free (or cheap) image repositories to pluck from. - STEP 3 - Add Text Bubble(s)
The problem of just mashing-up a bunch of images into an AHA-G, is that readers might miss the point unless your master piece is very direct and clear. To minimize that and amplify your message or point, I like to add one, two or three text bubbles. And you can create some sizzling fonts and bubbles in PowerPoint within seconds (Try doing that in Photoshop!). Interestingly, what I originality wanted to say is sometimes adapted or contextualized to the images discovered, and other times it is the other way around. For example, I might have some idea about a text bubble, but then when I find an awesome image, it might trigger a totally different text bubble, which is kind of cool! So, let the mind do the talking and be flexible, because you never know what pops-up. However, if you feel that text bubbles is not necessary, then skip it.
Anyway, the AHA-G is just the support act, supporting the main event; your article and message. Meaning, sometimes people need to read the whole article to understand why this AHA-G is like that. Aha, now it makes sense. Awesome! - STEP 4 - Crop & Save
When you have finished your AHA-G master piece, it is time to crop (and resize if necessary) it. First, you need to group all the images and Clipart included, and then you right-click and Save as Picture (All can be done in PowerPoint). I like to save it in JPG format, because it becomes light and easy (to view), however if you want it too look more crisp (pixel wise), then you might want to save it in PNG format (size will increase, though!). I used to crop and save it in JPG format using Microsoft Paint, but since you can do all this in PowerPoint, then why bother? - STEP 5 - Upload & Review
Finally, you are ready to upload your AHA-G to your blog or site (unless it is for a presentation), and review how it fits into the big picture. If you feel it is saucy and sizzling, then your AHA-G is done. If not, then edit and upload again until you feel great about it. Sometimes, if your AHA-G turns out to be really offensive religiously, sexually, culturally, racially, etc. then you should rethink and redo. Well, that is what I would do!
Here are some of my favorite AHA-G mash-ups:
Go Online! Go Mobile! Lost in Space!
PLENK2010
Using Twitter to Transform the Classroom!
My Most Satisfying PowerPoint Animation!
RT01- Closed Book Exams Could Even Kill George the Jungle!
Join the #moodlewish Twitter Stream!
Salman Khan Uses Microsoft Paint to Inspire Learning
University Learning = OCW + OER = FREE!
Any Free Hosted CMS or LMS? (Yes, Obama Says!)
![[Free+hosted+LMS_obama.jpg]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgyfNAzA3hGgPkd0sgZMX8ahgpae_mSvibI4h6WclGtirQha83FNelc_pQMeUyXXbiMTlwYGG8gN2ve348PGktzQoUdM86NpPBIRNuo5HwcasFKlWZi4rTSgS9_quDINSGjQcCbb7V_go/s1600/Free+hosted+LMS_obama.jpg)
Alright, any average graphic designer would think all this is crap, and that Photoshop is a 100 times better than PowerPoint 2010. However, if you just want to create some sizzling AHA-Gs efficiently, PowerPoint 2010 is pretty good. For the record, 9 out of 10 AHA-Gs above were created with PowerPoint 2007.![[Free+hosted+LMS_obama.jpg]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgyfNAzA3hGgPkd0sgZMX8ahgpae_mSvibI4h6WclGtirQha83FNelc_pQMeUyXXbiMTlwYGG8gN2ve348PGktzQoUdM86NpPBIRNuo5HwcasFKlWZi4rTSgS9_quDINSGjQcCbb7V_go/s1600/Free+hosted+LMS_obama.jpg)
Yes, I have to admit that I used to use Photoshop to remove backgrounds from images, but in PowerPoint 2010 you have finally got that awesome feature called Remove Background (big button). Now, I can convert completely and ditch Photoshop for good. This means shorter learning curve, less clicks, quicker output, and more AHA-G moments. I arrest my case!
Thats it! Of course it is not the whole story, but at least you got a glimpse on how I create AHA-Gs, and that I am taking sabbatical leave from Photoshop until I am convinced otherwise :)
Saturday, February 28, 2015
IMU Learning Series 01 Facebook for Learning and Teaching
Date: Wednesday, 28th December
Venue: Online (WiZiQ)
Time: 2:30 - 3:30 P.M. (Malaysian time)
(GMT + 8 Hours: 6:30 - 7:30 A.M)
AGENDA
Can Facebook be used for teaching and learning? How can it be used? In this online session we explored how it can be used for teaching and learning with a specific emphasis on using Facebook Groups and Pages.
FACILITATORS
- Zaid Ali Alsagoff
- Fareeza Marican
RECORDING
You are recommended to skip the first 10 minutes, so that you can get right into the action. If you have problems viewing, try updating your Flash Player.
IMU Learning Series 01 - Facebook for Learning and Teaching?

CLICK HERE
(To view the recorded online session)
PRESENTATION SLIDES
IMU Learning Series 01 - Facebook for Learning and Teaching?
View more presentations from Zaid Alsagoff.
Stay tuned for the upcoming online session, which will be revealed soon :)
Sunday, February 15, 2015
Reading data from single data source Single SQL Query for two charts in pentaho CDE
Hi guys...!!!
Community Dashboard Editor is the best reporting/dash boarding tool that I have worked. Its smart functionality made me love to work with it and exploring the things time by time.
Youll learn how to fetch different columns from result set of a single query and use them in different analysis purpose in charting.
Recently I needed to work with a single query data source(SQL) of having 3 columns result set ...
Lets say there are 3 columns A,B and C where as A column is having some category names and B and C are having some columns.
A B C
--------------
abc 2 4
pqr 6 8
xyz 10 5
and etc.
From the result set A&B are on first chart and A&C are on other chart..
Now how ?????? This question leads me to check the "Data sources" section of CDE.
Follow the steps below.
1) Click on the "sqloverjndi" which you created for your SQL query.
2) In the properties section you can find an option called "Output options". Just click on it.
3) Lets say you have 3 columns in your result set and these 3 columns takes index values starting from 0 to n.. i.e., A column index is 0 , B column index is 1 and for the C value 2 is the index.
NOTE: if you have more numbers of columns you can give as many indexes by clicking "Add" button as many times.
4)For Chart 1:
i) Click on the chart component where you want show A& B columns ( A is category B is value)
ii) In the properties(Click on Advanced properties) click on "Pre Execution"
iii) Write this below code
function f() {
this.chartDefinition.readers = [
{names:category, indexes: 0},
{names: value, indexes: 1},
{indexs: 2}
];
}
Why this {indexs:2} ? if you omit this the values of index2 append to the category names... to eliminate that problem you need to write it.
5) For Chart2 :
Repeat the steps in in point 4)
Slight changes in code ...
function f() {
this.chartDefinition.readers = [
{names:category, indexes: 0},
{names: value, indexes: 1},
{indexs: 2}
];
}
You are done with reading data from single query of 3 columns where 1&2 for one chart and 1&3 for another chart...
Save your dashboard and see the preview.
Sadakar
BI developer
( "Learning never exhausts the mind" )
Community Dashboard Editor is the best reporting/dash boarding tool that I have worked. Its smart functionality made me love to work with it and exploring the things time by time.
Youll learn how to fetch different columns from result set of a single query and use them in different analysis purpose in charting.
Recently I needed to work with a single query data source(SQL) of having 3 columns result set ...
Lets say there are 3 columns A,B and C where as A column is having some category names and B and C are having some columns.
A B C
--------------
abc 2 4
pqr 6 8
xyz 10 5
and etc.
From the result set A&B are on first chart and A&C are on other chart..
Now how ?????? This question leads me to check the "Data sources" section of CDE.
Follow the steps below.
1) Click on the "sqloverjndi" which you created for your SQL query.
2) In the properties section you can find an option called "Output options". Just click on it.
3) Lets say you have 3 columns in your result set and these 3 columns takes index values starting from 0 to n.. i.e., A column index is 0 , B column index is 1 and for the C value 2 is the index.

4)For Chart 1:
i) Click on the chart component where you want show A& B columns ( A is category B is value)
ii) In the properties(Click on Advanced properties) click on "Pre Execution"
iii) Write this below code
function f() {
this.chartDefinition.readers = [
{names:category, indexes: 0},
{names: value, indexes: 1},
{indexs: 2}
];
}
Why this {indexs:2} ? if you omit this the values of index2 append to the category names... to eliminate that problem you need to write it.
5) For Chart2 :
Repeat the steps in in point 4)
Slight changes in code ...
function f() {
this.chartDefinition.readers = [
{names:category, indexes: 0},
{names: value, indexes: 1},
{indexs: 2}
];
}
You are done with reading data from single query of 3 columns where 1&2 for one chart and 1&3 for another chart...
Save your dashboard and see the preview.
Sadakar
BI developer
( "Learning never exhausts the mind" )
Thursday, February 12, 2015
Fixing a Map Projection Issue for the Next SAR Toolbox
In the Nest Sar Toolbox you have a choice of coordinate systems:
For some of these, however, Nest reports the error "Axis Too Complex".
I compared a map projection that works with one where “Axis too complex” error is reported. Map projections that work contain these lines:
While the non-working ones contain these lines, which apparently are wrong or unprocessable by NEST
If you use the graph builder or command line (gpt) where the parametres are defined in an XML-file, you can manually replace these lines in the graph file (xml file) for the projection definition, then it works! An example for such an XML-file used by NEST is here.
Another example, this one works
Read more »

I compared a map projection that works with one where “Axis too complex” error is reported. Map projections that work contain these lines:
AXIS["Easting", EAST],
AXIS["Northing", NORTH]
While the non-working ones contain these lines, which apparently are wrong or unprocessable by NEST
AXIS["Easting", "North along 90 deg East"],
AXIS["Northing", "North along 0 deg"],
If you use the graph builder or command line (gpt) where the parametres are defined in an XML-file, you can manually replace these lines in the graph file (xml file) for the projection definition, then it works! An example for such an XML-file used by NEST is here.
Another example, this one works
PROJCS["WGS 84 / Australian Antarctic Lambert",EPSG3031 works not:
GEOGCS["WGS 84",
DATUM["World Geodetic System 1984",
SPHEROID["WGS 84", 6378137.0, 298.257223563, AUTHORITY["EPSG","7030"]],
AUTHORITY["EPSG","6326"]],
PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]],
UNIT["degree", 0.017453292519943295],
AXIS["Geodetic longitude", EAST],
AXIS["Geodetic latitude", NORTH],
AUTHORITY["EPSG","4326"]],
PROJECTION["Lambert_Conformal_Conic_2SP", AUTHORITY["EPSG","9802"]],
PARAMETER["central_meridian", 70.0],
PARAMETER["latitude_of_origin", -50.0],
PARAMETER["standard_parallel_1", -68.5],
PARAMETER["false_easting", 6000000.0],
PARAMETER["false_northing", 6000000.0],
PARAMETER["scale_factor", 1.0],
PARAMETER["standard_parallel_2", -74.5],
UNIT["m", 1.0],
AXIS["Easting", EAST],
AXIS["Northing", NORTH],
AUTHORITY["EPSG","3033"]]
PROJCS["WGS 84 / Antarctic Polar Stereographic",
GEOGCS["WGS 84",
DATUM["World Geodetic System 1984",
SPHEROID["WGS 84", 6378137.0, 298.257223563, AUTHORITY["EPSG","7030"]],
AUTHORITY["EPSG","6326"]],
PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]],
UNIT["degree", 0.017453292519943295],
AXIS["Geodetic longitude", EAST],
AXIS["Geodetic latitude", NORTH],
AUTHORITY["EPSG","4326"]],
PROJECTION["Polar Stereographic (variant B)", AUTHORITY["EPSG","9829"]],
PARAMETER["central_meridian", 0.0],
PARAMETER["Standard_Parallel_1", -71.0],
PARAMETER["false_easting", 0.0],
PARAMETER["false_northing", 0.0],
UNIT["m", 1.0],
AXIS["Easting", "North along 90 deg East"],
AXIS["Northing", "North along 0 deg"],
AUTHORITY["EPSG","3031"]]
Wednesday, February 4, 2015
MobileGo Android PC Suite for Windows Free Downlad
MobileGo PC Suite for Android
Download Full version Free

MobileGo is Pc suite for Android Smartphones and tablets. MobileGo allow user to manage their data,backup,apps and many more.
Android Pc Suite Features :
- Transfer Media and files .
Manage files in SD Card and Memory. Convert Videos to different format and transfer to PC.
- Edit your contacts
You can edit contacts from Pc to directly in Phone, find duplicate and marge them.
- SMS Assistant
Backup your Sms on Computer in xml format. Manage a group from Pc no need to send one by one message . Send it once to multiple.
- Apps Organizer
Download free apps directly to your smartphone or tablet. Move them to SD card without rooting.
- 1 Click apps and videos download.
Download apps from Google Play. Direct access to youtube to download songs and videos.
Download Full Paid version for Free
Tuesday, February 3, 2015
Learn PowerPoint for free
If you are looking for free PowerPoint training classes, here is one. Shivali, one of our readers and PowerPoint enthusiast is conducting a free PowerPoint training class for beginners.
PowerPoint 2007 Introduction Course for Beginners- Class 1 by Shivali Gupta
Get your own Virtual Classroom
Labels:
for,
free,
learn,
powerpoint
Subscribe to:
Posts (Atom)