SQL commands *into* Optigold

Re: SQL commands *into* Optigold

From:

Date:

Time:

I never thought of going through the web interface to do that, I will
check this out. Thanks for your help.

-Steve

-----Original Message-----
From: isp-list@optigold.com [mailto:isp-list@optigold.com] On Behalf Of
Michael J. Colvin
Sent: Monday, November 04, 2002 3:13 PM
To: 'Optigold ISP List'
Subject: RE: [Optigold ISP] SQL commands *into* Optigold

>From what I've read in the archives, the ODBC driver for Filemaker
"sucks the big one" (I believe those were Shawn's exact words :-)
)...Seems like doing a post through the web interface, XML or CDML is
the preferred method...Although I haven't tried "Customizing" anything
to accomplish this type of thing yet...

Michael J. Colvin
Avantac Internet Services
www.avantac.com - (916) 854-5940

> -----Original Message-----
> From: isp-list@optigold.com [mailto:isp-list@optigold.com] On Behalf
Of
> Steve Lok
> Sent: Monday, November 04, 2002 12:13 PM
> To: 'Optigold ISP List'
> Subject: RE: [Optigold ISP] SQL commands *into* Optigold
>
> Thanks for the info. Has anyone attempted this to your knowledge?
Would
> you recommend that the Optigold data files not be tampered with
> directly? I mean, if the process is very complicated (updating across
> multiple tables, dependent table schema, etc.) I would just throw out
> this idea in favor of preserving the data files' integrity.
>
> -----Original Message-----
> From: isp-list@optigold.com [mailto:isp-list@optigold.com] On Behalf
Of
> Shawn Hogan
> Sent: Monday, November 04, 2002 1:59 PM
> To: Optigold ISP List
> Subject: Re: [Optigold ISP] SQL commands *into* Optigold
>
>
> Steve Lok wrote:
>
> > My question is this - we've been using Optigold happily for the last
2
>
> > years, and one of the main draws was the ability to use SQL to
> > interface between Optigold and other systems. Now that we're ready
to
> > move on the project, it's become clear that we need the ability to
> > control Optigold (mostly inserting new customers, adding billing
cycle
>
> > items automatically, etc.) from an external office intranet (via
SQL).
>
> > I didn't see any mention of this ability (only SQL *out*) in the
> > manual, and the search through the lists is unclear. Can you give me
a
>
> > definitive answer on this? If SQL is not available, am I stuck with
> > resorting to the importing/exporting of text files?
>
> It's possible if you set it up as an ODBC data source... Although
doing
> so is completely, 100% not supported on our end, as if you are
inserting
> and updating into the tables, it would be very easy to break things if

> not done properly. So you would be on your own when modifying the
> tables directly.
>
> - Shawn
>
> -------------------------------
> Shawn D. Hogan
> President, Digital Point Solutions http://www.digitalpoint.com
> (858) 452-3696
>
>
> ---------------------------------------------------
> To subscribe, unsubscribe or to search list archive
> please visit http://www.optigold.com/lists/isp.html
> ---------------------------------------------------
>
>
> ---------------------------------------------------
> To subscribe, unsubscribe or to search list archive
> please visit http://www.optigold.com/lists/isp.html
> ---------------------------------------------------

---------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.optigold.com/lists/isp.html
---------------------------------------------------

---------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.optigold.com/lists/isp.html
---------------------------------------------------

Sales:
888/4-DPOINT

Support:
858/452-3696