Previous Thread
Next Thread
Print Thread
Charts/Dashboards #37649 13 Nov 24 03:55 PM
Joined: Nov 2006
Posts: 2,223
S
Stephen Funkhouser Offline OP
Member
OP Offline
Member
S
Joined: Nov 2006
Posts: 2,223
Hi Jack,

I'm just following up on a topic the '23 conference. I can't recall the name of the chart package. Just curious if this has gained any research time, or thought on actual implementation.

TIA,
Stephen


Stephen Funkhouser
Diversified Data Solutions
Re: Charts/Dashboards [Re: Stephen Funkhouser] #37650 13 Nov 24 04:26 PM
Joined: Jun 2001
Posts: 11,794
J
Jack McGregor Offline
Member
Offline
Member
J
Joined: Jun 2001
Posts: 11,794
I think both Steve and Matt were using DevExpress, although Steve had bundled his version along with support for other common back-end ERPs into a package they call Toucan. Your timing is interesting because I was just thinking about looking into this again yesterday. After the Conference I got distracted by other things and didn't really have a chance to investigate it. And now a year has gone by. But it's not clear that there's anything new needed on the A-Shell side. My understanding is that the client uses RESTful HTTP requests to communicate with the back end, so you could use the A-Shell CGI mode to service the requests. Everything else is essentially independent front-end development, mostly likely in Visual Studio.

Re: Charts/Dashboards [Re: Stephen Funkhouser] #37651 13 Nov 24 04:45 PM
Joined: Sep 2003
Posts: 4,158
Steve - Caliq Offline
Member
Offline
Member
Joined: Sep 2003
Posts: 4,158
Really a year has gone by already??

I think we here at Caliq have gone around in circles several times over god know how many years with different type of dashboards, charts, data integration etc etc.. from calling external charts from with in Ashell to just supplying meaningful SQL Tables for customers to use and do themselves in something like PowerBI...

As Jack says we end up with using the DevExpress components and writing an external Data Analytics web portal that we squirt data too (not via SQL but mostly simple CSV files) this also allowed us to open it up a bit to other systems like Sage, Microsoft Dynamics , Caliq, good old Madics/Ashell and other bespoke systems

John there at Diversified Data Solutions had a little play back at the conference.

We have gotten on well with the DevExpress stuff , nice Charts, Grids and at the moment im playing with the new C# Devexpress Blazor but it is all outside Ashell.

The portal is currently mostly aimed at Sales Analytics, seeing Company Orders, Invoices and helping Sales Rep gain business and leads.but have dozens of customers using it with great feed back.

Your welcome to explore it here at Toucan Sales Analytics just drop me an email for a login (if everyone uses the same it just get confused) smile

It fed by the following CSV Struture Here

Last edited by Steve - Caliq; 13 Nov 24 04:51 PM.
Re: Charts/Dashboards [Re: Stephen Funkhouser] #37652 13 Nov 24 06:56 PM
Joined: Sep 2003
Posts: 4,158
Steve - Caliq Offline
Member
Offline
Member
Joined: Sep 2003
Posts: 4,158
Actually here is another example im working on at the moment (Warehouse Stock Relocate) and closer to Jacks A-Shell CGI mode suggestion, Its a Web Portal written in Net/C#/Blazor but ALL its data is coming from our Ashell Linux Server (hosted in the Cloud) its just passing JSON data back and forth via an API/A-Shell CGI. (I think similar to what OmniLedger is doing)

Idea is a nice front end for the user using a web browser and all the back-end processing is STILL running the the good old very solid 1980s ashell stock adjustment code (well 1987 to be be precise) just the RUN program data comes from JSON rather than ATE and a keyboard.

Idea here being web based allows it to run on any device (with a web browser) and users can to walk around a large Warehouse picking and relocating stock, aim is for Android handhelds (with built in bar code scanners) - It keeps the Ashell clients we have out there seeing update development but still running ashell/Madics.

But the theory is much the same if you want to show a nice Chart, Graph or something where the Ashell program launches the browser passing all the data needed in a JSON.

My Test development is here Test Stock Locate and the PIN to login is 2324 and its talking to our Ashell Server for all the data and processing.
* Once logged in click the RELOCATE button
* Enter ZGILO for a BIN
* WHEELS for the item.
* Enter a Qty and click Pick
(The stock is now in your hand, well cart) to put it else where...
* Enter ABC123 for a BIN
* WHEELS for the item.
* Enter Qty you got and click LOCATE.

(Take me a while to get this screen layout to work well for a small Android screen, but works just as well for a Windows PC browser too)











Attached Files Pick.pngLocate.png
Last edited by Steve - Caliq; 13 Nov 24 07:00 PM.
Re: Charts/Dashboards [Re: Stephen Funkhouser] #37653 13 Nov 24 07:42 PM
Joined: Jun 2001
Posts: 11,794
J
Jack McGregor Offline
Member
Offline
Member
J
Joined: Jun 2001
Posts: 11,794
Very slick! (Now when you get some free time, can you add ATE functionality to it so we can run text and AUI applications on a phone?) cool

Re: Charts/Dashboards [Re: Stephen Funkhouser] #37654 13 Nov 24 08:27 PM
Joined: Sep 2003
Posts: 4,158
Steve - Caliq Offline
Member
Offline
Member
Joined: Sep 2003
Posts: 4,158
cool sure , why not smile

Re: Charts/Dashboards [Re: Stephen Funkhouser] #37656 14 Nov 24 05:38 PM
Joined: Nov 2006
Posts: 2,223
S
Stephen Funkhouser Offline OP
Member
OP Offline
Member
S
Joined: Nov 2006
Posts: 2,223
Looks Cool Steve!

Here's an email refocus-much-uncle@duck.com if you could give me demo access that would be great. I can send my primary email via email later if you need that for the demo.

I look forward to checking it out.


Stephen Funkhouser
Diversified Data Solutions
Re: Charts/Dashboards [Re: Stephen Funkhouser] #37658 14 Nov 24 07:11 PM
Joined: Sep 2003
Posts: 4,158
Steve - Caliq Offline
Member
Offline
Member
Joined: Sep 2003
Posts: 4,158
Hi Stephen, I've email you a password its fine just using the email address refocus-much-uncle@duck.com and login HERE

Once logged in the menu is the round orange burger 'thing' in the top-left of the screen, once you selected a menu option you just click the grey individual panels to open them up for different data-grid/charts/graphs/stats etc etc etc

(Let me know if you dont receive it or any any questions etc etc etc )


Moderated by  Jack McGregor, Ty Griffin 

Powered by UBB.threads™ PHP Forum Software 7.7.3