PDA

View Full Version : Hello all!



KDub
09-19-2002, 11:56 AM
Just registered and wanted to poke my head in to say "hello all"...

So...... uhhhhhh... hello all.

Anyway, I also had a question regarding AMS.

Is there a way to attach to SQL Databases?

Thanks for any help in advanced, and I look forward to getting to know you people! /ubbthreads/images/icons/smile.gif

Cheers.

Corey
09-19-2002, 12:48 PM
Hey Kdub, glad to meet you...

How do you currently integrate with your SQL database from appliations or web sites? Chances are your current method can be piggy-backed using AMS...

Corey Milner
Creative Director, Indigo Rose Software (http://www.indigorose.com)

John-oh
09-19-2002, 12:52 PM
All this is beyond me, but here's a link to something similar that Corey put together..
http://www.indigorose.com/ubbthreads/showthreaded.php?Cat=&Board=UBB2&Number=10702&page =&view=&sb=&o=

I doing this, 'cause when Coreys answering Forum questions - he's not working on the new web site /ubbthreads/images/icons/laugh.gif

Hope this helps to point you in the right direction.

Cheers

John-oh
09-19-2002, 12:53 PM
Dam .. just too late.

Corey
09-19-2002, 06:14 PM
/ubbthreads/images/icons/smile.gif

Corey Milner
Creative Director, Indigo Rose Software (http://www.indigorose.com)

sferguson
11-04-2003, 08:53 AM
Hi Folks...

Appologies in advance if I'm missing something obvious -

How can I access the tutorial mentioned below?


Originally posted by John-oh
All this is beyond me, but here's a link to something similar that Corey put together..
http://www.indigorose.com/ubbthreads/showthreaded.php?Cat=&Board=UBB2&Number=10702&page =&view=&sb=&o=

I doing this, 'cause when Coreys answering Forum questions - he's not working on the new web site /ubbthreads/images/icons/laugh.gif

Hope this helps to point you in the right direction.

Cheers

Brett
11-04-2003, 09:16 AM
That link is to a message on the old forums so it will not work. In short, one of the best ways to access databases through AMS40 is by hosting your database on a Web site (perhaps MySQL) and expose scripts that can be executed (perhaps written in PHP or ASP) and then use AMS40's Internet - Submit to Web action to submit data to the Web and then parse the returned resuls. Not for the faint of heart but it does work well if you know your Web database programming.

If you want to host the database locally, that is a bit more difficult. The main problem is that most databases need a pre-installed DBMS in place before queries can be executed. The whole thing really depends on your needs... are you trying to use AMS40 to mine data from an existing corporate database or juetc trying to store a bit of information between sessions or somewhere in-between. If we know what you are trying to accomplish, perhaps we can find some better ideas for you.

sferguson
11-04-2003, 10:59 AM
Brett,

Thanks in advance for your guidance!

We have a corporate database (SQL) that stores details related to each job our freelance reporters handle.

I'm using AMS 4, however I've just downloaded the 5 beta and WOW... what a killer upgrade!

My AMS app will be installed on local desktops in the shipping dept. (and eventually on a touch-screen kiosk)


I'm using AMS to create an app that:

- Prompts user to enter the job number from the freelancer's job turn-in sheet
(the job number was automatically generated by the SQL database when the freelancer was assigned the gig

- Querries the SQL database for the job details

- Displays the job details in the AMS app


Other notes:
Creating a web-based solution sounds fine by me, I'm pretty web and tech savvy, and a super-quick study to boot, when it comes to learning just the pieces and parts of what's needed.

I've been trucking through the user forums, as well as the AMS 5 "Scripting Basics" lesson and Scripting Guide. I also have my handy-dandy "Learn JavaScript in 24 Hours" book within arms reach.

I don't scare easy, but I'm just not sure what road will be the simplest (...I'm a big fan of the KISS mantra when it comes to building something). What might you and the fellas at IR suggest?

Brett
11-04-2003, 11:03 AM
What are your requirements for the database? Does it have to be a certain type (Oracle, MySQL, MS SQL Server)? Does the database already exist? Would putting it on a Web server be an option? If so, what kind of Web server (in terms of OS and installed software)?

Or are things open-ended and up to you as far as the database interface?

sferguson
11-04-2003, 11:10 AM
Things are pretty open ended...

The existing enterprise job tracking app is based on MS SQL Server, and currently facilitates web access to the data

see: RB Web Demo - Reporter Login
http://www.reporterbase.com/webproducts.html

Brett
11-04-2003, 11:27 AM
The existing enterprise job tracking app is based on MS SQL Server, and currently facilitates web access to the data

Well that makes the whole job much easier. If you haven't started development with AMS40 then I would strongly reccomend that you do it with AMS50 because it has much more flexible ways to deal with returned data. You should have no trouble getting AMS to post data to an ASP page and having the ASP page return results that can then be parsed and used by the ASM50 runtime.

sferguson
11-04-2003, 11:40 AM
Hey, that's GREAT news!

I'm a bit new to these areas, in terms of having my sleeves rolled up and being "hands-on" in the process.

If I can find an example (the more closely related the better) I can "model" the heck out of something. At this point, it's the "blank canvas" that's a little bit daunting.

What resources or tutorials could you suggest?

Corey
11-04-2003, 02:46 PM
We have a training CD coming out in the next week or so here which is perfect for your situation... It'll be announced here in the forum so keep an eye out if this interests you. :)

Corey Milner
Creative Director, Indigo Rose Software (http://www.indigorose.com)

sferguson
11-04-2003, 03:17 PM
Sweet! I'll be counting the days.

In the mean time, has anybody else already been through this one? I've got a project deadline that's tearin' up the calendar, with more projects stacking up behind it than Santa Claus will be able to shake a candy cane at (...it's beginning to look alot like pre-Christmas project rush time).

If it's a matter of needing to "book" some one-on-one, invoiceable time with one of the gurus, that might be an option. I don't have a budget for the project, per say, but I'm reasonably confident I could "expense" it, along with the AMS 5 upgrade.

Any takers?

Corey
11-04-2003, 03:27 PM
We have excellent rates here at IR for a variety of services, training and project assistance being among them. If that's something you would like to get more details about simply email sales@indigorose.com any time and they'll be happy to answer any questions you might have...

Corey Milner
Creative Director, Indigo Rose Software (http://www.indigorose.com)

sferguson
11-04-2003, 03:31 PM
Thanks! Will do.

Corey
11-04-2003, 03:40 PM
One interesting note for you. We do video training modules. So let's say you want to learn a specific task for this project. I can prepare and provide you with professional video training lessons which address your project specifically. Depending on the complexity of your task it can be very inexpensive to have Indigo Rose produce such custom video training for you. Just thought I'd share that. :)

Corey Milner
Creative Director, Indigo Rose Software (http://www.indigorose.com)

sferguson
11-04-2003, 04:14 PM
Corey,

That would be ideal! That kind of training is right up my alley, I use it around here alot for showing staff how to set prefs and compress vid files.

Per your suggestion, I've sent an email to the sales folks, but no one has contacted (just yet anyway <grin>).

How can we get this show on the road ASAP - obviously, I'm a little bit anxious...

I've planned out most of my app and created a pseudo working prototype that i've user tested in the shipping dept - just to make sure the obvious was really obvious to the end user, as oppossed to just me <grin>.

So - needless to say, I'm currently in the "home stretch" and folks above and below me are gettin antsy.

Corey
11-04-2003, 04:22 PM
Well the hierarchy goes like this. Sales gives a client our rate, I believe it is $50/hour USD but I'm not certain, which is cheap for the 100% guarantee of quality we provide. Then the client either hires us or gives us details of their project and requests an estmiate of how many hours it will take.

If it gets past that stage then I am given the work order and work begins. It is theoretically possible to get from start to this stage within a day or two if a deposit is made by courier if expediency is the issue. Completion times vary according to the complexity of the project but typically I work very fast and can be 100% done most small projects within in a few days or 10-20 hours.

So ostensibly one could purchase customized training videos for as little as a few dollars each depending on the scenario... These are one of a kind video training modules creating specifically for you, which you may re-use or share as you please.

Corey Milner
Creative Director, Indigo Rose Software (http://www.indigorose.com)

sferguson
11-04-2003, 04:30 PM
Great!

Well, if you bump into any sales folks at the water cooler, or if you happend to have a cattle prod layin around, ask 'em to get back with me at earliest convenience...

sheeesh... I think the whole "rush it" disease is turnning out to be highly contagious around here, much to my dismay, it appears to be spreading out of control and seeping into my office <grin>.

Corey
11-04-2003, 04:35 PM
I dropped an email to the top cat, you can bet it will get addressed by tomorrow at the latest. (It's after hours here in snowland)

Corey Milner
Creative Director, Indigo Rose Software (http://www.indigorose.com)