Alpha Video Training
Page 1 of 2 12 LastLast
Results 1 to 30 of 37

Thread: A5/FusionCharts Genie is Ready!

  1. #1
    Volunteer Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    Location
    The Dreaded Chair
    Posts
    5,629

    Default A5/FusionCharts Genie is Ready!

    Announcing the A5/FusionCharts Genie
    Codeless FusionCharts for your Alpha Five Database
    From Steve Workings


    I am proud to announce that the A5/FusionCharts Genie is ready for purchase.

    If you've wanted to put charts on your Alpha Five web pages or forms, but were stopped with all the coding involved, then this Genie is for you.

    The A5/FusionCharts Genie helps Alpha Five users create FusionCharts that can be integrated with Alpha Five databases. The primary method of integration is the production of code for use in .A5W pages, which can then be displayed in a web application and on desktop forms.

    Codeless FusionCharts for your Alpha Five database!

    Here is the A5/FusionCharts Web Page where you'll find a full description, plenty of helpful videos and more.

    The Genie is for sale for $69.00 at the IADN Store. You have unlimited use of the Genie, across as many databases, websites or other Alpha Five applications you have.

    This has been tested with A5 versions 9 and 10. It should also work with version 8. Many of the techniques for display demonstrated in the videos use version 10 features.
    -Steve


  2. #2
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,412

    Default Re: A5/FusionCharts Genie is Ready!

    Looks Great Steve!

    Does the Genie currently support mysql?

    Thanks

    Chad

  3. #3
    Volunteer Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    Location
    The Dreaded Chair
    Posts
    5,629

    Default Re: A5/FusionCharts Genie is Ready!

    Right now the Genie just supports native .dbfs. I'd like to add support for other database types later.
    -Steve


  4. #4
    "Certified" Alphaholic mmaisterrena's Avatar
    Real Name
    Mauricio Maisterrena
    Join Date
    Nov 2006
    Location
    Torreon, Mexico
    Posts
    1,435

    Default Re: A5/FusionCharts Genie is Ready!

    Great Job Steve
    Its good for alpha and its users that an ecosystem of Add-ons / plug-ins for alpha five is starting to rise
    Cheers
    Mauricio


  5. #5
    Volunteer Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    Location
    The Dreaded Chair
    Posts
    5,629

    Default Re: A5/FusionCharts Genie is Ready!

    And may all boats rise!
    -Steve


  6. #6
    "Certified" Alphaholic
    Real Name
    Bill Griffin
    Join Date
    Jul 2001
    Location
    Edgewood, NY
    Posts
    1,201

    Default Re: A5/FusionCharts Genie is Ready!

    Quote Originally Posted by chadbrown View Post
    Looks Great Steve!

    Does the Genie currently support mysql?

    Thanks

    Chad
    Chad,

    I just setup an active link table to a Mysql db and all seemed to work just fine. Not sure if there any gotchas involved with SQl, but putting the data from an active (or passive) link table works great.

    Bill
    Bill Griffin
    Parkell, Inc

  7. #7
    Volunteer Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    Location
    The Dreaded Chair
    Posts
    5,629

    Default Re: A5/FusionCharts Genie is Ready!

    Bill's right! Something I didn't know. It's really the facility that A5 has provided, but it all works just fine. I never thought to try it.

    I set up an Active Link table with the NorthWinds ProductsInStock table, and created a chart with the Genie againsta few of its fields.

    The result is attached here.

    I think that there may be some limits (at least at this time) about specifying chart values with expressions in the Genie when you're drawing on Active Link tables, but with a bit of design consideration, this shouldn't be a huge deal.
    -Steve


  8. #8
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,412

    Default Re: A5/FusionCharts Genie is Ready!

    If you dont ask you will never know.

    Awesome news!


    But apparently I just crashed the site to purchase this lovely genie on.

    I purchased it and since then the site has been down and i dont know how i get my download
    Last edited by chadbrown; 10-19-2009 at 04:42 PM.

  9. #9
    Volunteer Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    Location
    The Dreaded Chair
    Posts
    5,629

    Default Re: A5/FusionCharts Genie is Ready!

    I just went to the site, and it looks OK to me -at least at this moment.

    Steve Wood is the manager of the IADN site and store. He's not around today, so we'll have to check in with him late tonight and/or tomorrow.

    Sorry for any inconvenience to anyone. We'll make everything right for anyone who's had a problem.
    -Steve


  10. #10
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,643

    Default Re: A5/FusionCharts Genie is Ready!

    Quote Originally Posted by chadbrown View Post
    But apparently I just crashed the site to purchase this lovely genie on.

    I purchased it and since then the site has been down and i dont know how i get my download
    The site looks up to me....
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  11. #11
    Volunteer Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,842

    Default Re: A5/FusionCharts Genie is Ready!

    Chad, the order went through fine. The only thing that failed was the very final confirmation page, conflicting data type threw an errror. And I was at a conference today and caught it when I came back. The big problem with any purchase system is ensuring you get the confirmation. My confirmation screen did not work but the order went through and it DID send you a confirmation email including the download links and license numbers (I get a BCC).
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  12. #12
    "Certified" Alphaholic peteconway's Avatar
    Real Name
    Peter Conway
    Join Date
    Oct 2005
    Location
    Melbourne, Australia
    Posts
    2,669

    Default Re: A5/FusionCharts Genie is Ready!

    Well Steve what can I say but good on you, like Mauricio (Calender) you have entered the new world of Alpha Apps. V10 as shown to us at the conference was an indicator of things to come.

    This is a fantastic effort, not just the product - but the entire delivery and support.

    A professional and absolutely first all round.

    Well - done. A proud moment in Alpha Development.

    Peter Conway
    Insanity: doing the same thing over and over again and expecting different results.
    Albert Einstein, (attributed)
    US (German-born) physicist (1879 - 1955)

  13. #13
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,412

    Default Re: A5/FusionCharts Genie is Ready!

    Hi Steve you are correct the email was sent. It just hit my junk mail which sits in a quarantine area until I sign into that area and release it and when I didn't see either the email or a confirmation I figured it was just a little glitch.

    Thanks again for the quick response from your team at IADN.

    Chad

  14. #14
    Volunteer Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,842

    Default Re: A5/FusionCharts Genie is Ready!

    Thank you Peter. One point though to keep things honest - I wrote the shopping cart featured on the IADN website in Feb 09 for my personal AlphaToGo website, and just copied it to the IADN project, and its all in V9 so far.
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  15. #15
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,412

    Default Re: A5/FusionCharts Genie is Ready!

    Steve,
    The shopping cart was very smooth perhaps you could sell that aspect aswell.

    Chad

  16. #16
    Volunteer Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,842

    Default Re: A5/FusionCharts Genie is Ready!

    People keep asking me that!!
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  17. #17
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,412

    Default Re: A5/FusionCharts Genie is Ready!

    Giddy up
    Get it packaged up.

  18. #18
    Volunteer Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,842

    Default Re: A5/FusionCharts Genie is Ready!

    Well (plug follows) the AlphaToGo Web Template, upon which the Cart is based has 45 customers and is featured here: http://wt.alphatogohost.com/

    I've been reluctant to package up the cart because it needs soo much more to be a real industry strength shopping cart - promo setup, coupons, shipment tracking, etc. www.zencart.com is my model.

    It does have a flawless integration with PayPal, the fancy kind that breaks out each item in the PayPal and uses their IPN - Instant Payment Notification to 'tell' my website in the background that the transaction went through, at which point I do all my transaction processing. That is a much better method than the simple BuyNow button options they provide since it does not depend on the user actually coming back to the website.

    Going on now - PayPal is actually more complex than it looks. This IPN happens in the background like I said. PayPal does not consider the transaction complete until MY WEBSITE sends back a secret handshake proving I am who I say, and only then does PayPal complete the transaction. But this happens long after the buyer is gone (OK, like 2 seconds after they are gone.) By time the user gets back to my website, I have processed the transaction, updated their MyAccount information with the order and sent out confirmation emails to the buyer and the seller, and BCC to me if necessary.

    I've done four or five different Payment Gateway scenerios with different gateway companies. PayPal is actually the hardest.
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  19. #19
    "Certified" Alphaholic
    Real Name
    Bill Griffin
    Join Date
    Jul 2001
    Location
    Edgewood, NY
    Posts
    1,201

    Default Re: A5/FusionCharts Genie is Ready!

    Steve,

    It keeps getting better!! The addition of some of the fusion widgets in the latest beta are awesome!! Keep em coming....
    Bill Griffin
    Parkell, Inc

  20. #20
    "Certified" Alphaholic
    Real Name
    Michael Humby
    Join Date
    Apr 2000
    Location
    Leicester, UK
    Posts
    1,036

    Default Re: A5/FusionCharts Genie is Ready!

    Steve,

    I've downloaded your FusionCharts genie but am having some trouble installing it. I've extracted the files to a folder but it seems some are missing. In your video clip for Installing the genie, the extracted files include; the database files and then 3 folders 'Charts', 'Fusion.WebProjects' and 'JavaScript' (see attached screenshot taken from your video). However when I extract the files from your genie zip file, I only get the database files (see 2nd screenshot)? Any ideas what is wrong? It's difficult to follow the rest of the instructions until this is clear.

    Could you please email me if it's something I've done wrong,

    Cheers,

    Michael

  21. #21
    Volunteer Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    Location
    The Dreaded Chair
    Posts
    5,629

    Default Re: A5/FusionCharts Genie is Ready!

    For whatever reason, a couple people got a download of a zip file that didn't have the web pages. You, and anyone else who didn't get the full package can download the package again; I've installed a new .zip file for you.
    -Steve


  22. #22
    Member FrankR's Avatar
    Real Name
    Frank R
    Join Date
    Mar 2006
    Posts
    210

    Default Re: A5/FusionCharts Genie is Ready!

    Let me put in a vote for a rev that is tested with SQL Server.

    That will bring us a Very Big step forward in the types of apps we can do with AAS 10.
    Frank R

  23. #23
    Volunteer Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    Location
    The Dreaded Chair
    Posts
    5,629

    Default Re: A5/FusionCharts Genie is Ready!

    Bill Griffin (aka Super Beta Tester) has pointed out that you can use the A5/FusionCharts genie against any table in A5. That includes Active Link tables. I've done it too, and it works seamlessly.
    -Steve


  24. #24
    Member
    Real Name
    ierp
    Join Date
    Jan 2010
    Posts
    52

    Default Re: A5/FusionCharts Genie is Ready!

    I used the genie with MySql and it works great! I also got excellent support from Steve

    thanks
    raj

  25. #25
    Member
    Real Name
    Chris Turnbull
    Join Date
    Oct 2009
    Posts
    445

    Default Re: A5/FusionCharts Genie is Ready!

    Hi Steve,

    I have been looking at the Genie Videos to night and everything looks find and dandy.

    I work in a school and 1 application I am hoping to use it for is to drag data (Attendance\Assessment etc) from the mssql MIS system and display it on the Digital signage system to get some competition going amongst the different year groups. Is it possible to setup a chart that links to the data and whenever that data changes the graph will show this or are updates manual.

    Thanks

    Chris

  26. #26
    Volunteer Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    Location
    The Dreaded Chair
    Posts
    5,629

    Default Re: A5/FusionCharts Genie is Ready!

    I don't know what the "digital signage system" is, but,

    Is it possible to setup a chart that links to the data and whenever that data changes the graph
    Yes. Haven't done it, but I'm positive it can be done.

    You're combining drag & drop and FusionCharts! Cool. If'n I can find time I'll make up a model.
    -Steve


  27. #27
    Member
    Real Name
    Chris Turnbull
    Join Date
    Oct 2009
    Posts
    445

    Default Re: A5/FusionCharts Genie is Ready!

    Hi Steve.

    The digital signage system are the big tellies that you see in malls and worplaces with information on them.

    I would guess it is just a case of refreshing the webpage or flicking through a series of webpages that refresh the data when it reloads.

    Thanks for the reply

    Chris

    PS Thanks for putting the time in you do your vidoes are excellent and I find them very helpful. I had a play with just the fusion charts last nights and found that they are quite static for the sql stuff so what you have done with Alpah and Fusion is fantastic for people like me.

  28. #28
    "Certified" Alphaholic
    Real Name
    Frank Bicknell
    Join Date
    Feb 2010
    Location
    39.1915° N, 84.4348° W
    Posts
    2,467

    Default Re: A5/FusionCharts Genie is Ready!

    Does this genie work with the free version of fusion charts?
    I am a little confused by these messages, would I be able to use an AlphaDAO connection or would I have to make an Active Link connection?

  29. #29
    Volunteer Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    Location
    The Dreaded Chair
    Posts
    5,629

    Default Re: A5/FusionCharts Genie is Ready!

    The A5/FusionCharts Genie comes with all the free charts, plus the trial version of the Version 3 Charts and the trial version of the Widgets. The only difference between the trial and non-trial versions are that the trial versions have a watermark on them (you'll see it in most of my videos).

    The Genie does not support every chart. A list of what's supported is on my web site. More coming later, I hope.

    The Genie was originally designed to work with native .dbfs or active link tables.

    You can still use the Genie to design the charts for AlphaDAO connections, but you'll need to first "dummy" the data in, say, an active link table, then write yourself just a bit of code to convert to a connection string. Videos 22 and 23 on my site show you how to do that.

    For answers to more questions, better understanding, etc., see the A5/FusionCharts Web Site.
    -Steve


  30. #30
    Member FrankR's Avatar
    Real Name
    Frank R
    Join Date
    Mar 2006
    Posts
    210

    Default Re: A5/FusionCharts Genie is Ready!

    Are there any drill down capabilities?
    Frank R

Similar Threads

  1. A5/FusionCharts Genie is Ready!
    By Steve Workings in forum Announcements
    Replies: 0
    Last Post: 10-19-2009, 11:08 AM
  2. FusionCharts Suite Compatibility ??????
    By JohnZaleski in forum Application Server Version 9 - Web/Browser Applications
    Replies: 23
    Last Post: 09-28-2009, 08:04 PM
  3. FusionCharts Suite - Webinar
    By gmeredith17 in forum Alpha Five Version 9 - Desktop Applications
    Replies: 6
    Last Post: 09-24-2009, 09:21 AM
  4. When will V8 Ready
    By MFAUZIM in forum Alpha Five Version 7
    Replies: 6
    Last Post: 12-18-2006, 04:47 AM
  5. Web Graphs - FusionCharts
    By intertag in forum Web Application Server v6
    Replies: 3
    Last Post: 03-28-2005, 07:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •