Please read through....
Charles Daminato
Product Manager (ccTLDs)
Tucows Inc. - [EMAIL PROTECTED]
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Csongor Fagyal
> Sent: March 7, 2001 3:18 PM
> To: Charles Daminato; [EMAIL PROTECTED]
> Subject: Re: How to retrive a list of all our customers domains
>
>
> ----- Original Message -----
> From: "Charles Daminato" <[EMAIL PROTECTED]>
> To: "Csongor Fagyal" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, March 07, 2001 9:02 PM
> Subject: RE: How to retrive a list of all our customers domains
>
>
> > Well, if the API allowed you to query by order_id it would be a great
> idea -
> > currently it does not (yes, it's in the works - but not 'soon')...
> Well... erm... what is the word... shoot? No... shot... mmm...
> nooo... shit!
> That's it! :-)
>
> Mr. Daminato, you disappoint me.. you have ruined my plans.
>
> So, you say (actually you don't, but I assume you would if I
> asked), that it
> is a better idea to
> - set up my own registration "procedure" using the API
> - store all data locally
> - register domains using the API, and consider my DB as the "master db"
>
Ultimately, yes :) Or use our client code, but put local hooks to store
data.
> At the same time, I can use manage.cgi as the functionalities are
> "transparent".
>
> Is this approach better? Generally I wan to
> - access reg. data locally
You'll need a local db - you can store on the fly, or generate reports later
(slowly please ;))
> - make many modifications and additions to the registration
> procedure (like
> affiliates, billing, etc.)
Would require a custom setup...
> - do not spend way too much time on developement
Tricky ;) If you want to maintain the logic flow of the API, easy - if you
want mass customizations and mucho-control, tricky.
> - use manage.cgi as I find that part of the software fine
>
> What is your recommendation? (Others' comments also welcomed!) Charles, I
> worship you, furnish me with your great knowledge :-)
>
I'm flattered :) :) :)
> > It's primarily an auto_increment, but we've fluffed the numbers so you
> don't
> > REALLY know how many domain orders we have *muahahAHAHahaha* ... sorry,
> > needed that :)
> "Muahahahahaha"? That means in borgian "please send me your
> /usr/bin/* files
> pronto". I will do that. :-)
>
> OTOH I *was* thinking about this order number thing -> number of
> registrations a while ago...
>
> - Csongor
>
> >
> > Charles Daminato
> > Product Manager (ccTLDs)
> > Tucows Inc. - [EMAIL PROTECTED]
> >
> > > -----Original Message-----
> > > From: Csongor Fagyal [mailto:[EMAIL PROTECTED]]
> > > Sent: March 7, 2001 2:59 PM
> > > To: Charles Daminato; [EMAIL PROTECTED]
> > > Subject: Re: How to retrive a list of all our customers domains
> > >
> > >
> > > Hmmm...
> > >
> > > Good that you said that :-) I am about to redesign our site, and I am
> not
> > > yet familiar with the API - all that I saw was a "GET DOMAIN"
> action :-)
> > >
> > > How about this: I register domains using a modified version of
> > > reg_system.cgi (or something like that). I only store the new
> ID that is
> > > returned from the OpenSRS server (tell me, is this an 'orderid int(8)
> > > primary key auto_increment index' ? :-)), and when I need the data, I
> use
> > > the API to query the your database.
> > >
> > > Does this sound okay?
> > >
> > > - Csongor
> > >
> > > ----- Original Message -----
> > > From: "Charles Daminato" <[EMAIL PROTECTED]>
> > > To: "Csongor Fagyal" <[EMAIL PROTECTED]>; "Tom Brown"
> > > <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > > Sent: Wednesday, March 07, 2001 8:52 PM
> > > Subject: RE: How to retrive a list of all our customers domains
> > >
> > >
> > > > Two things..
> > > >
> > > > Using the Perl API means you have to be able to login to each
> > > domain, and
> > > > you can't retrieve a full list of domains from the API (yet) - that
> > > wouldn't
> > > > work. Gotta use the web interface
> > > >
> > > > Also, it may not take more than a day - we just can't spare a
> programmer
> > > to
> > > > do that yet. There are other implications - prevent
> hammering? Do we
> > > give
> > > > customized formats? (i.e. selectable fields to report) What
> information
> > > do
> > > > we provide? Simple contact information, or transaction
> audit? (audit
> > > being
> > > > more expensive to the system than just plain info) - many questions.
> We
> > > > have to design it, code it, test it, train internally, then release
> it -
> > > and
> > > > fix bugs along the way, hopefully not tooooooo many by the time
> > > it gets to
> > > > you folk. This'll take more than a day :)
> > > >
> > > > Charles Daminato
> > > > Product Manager (ccTLDs)
> > > > Tucows Inc. - [EMAIL PROTECTED]
> > > >
> > > > > -----Original Message-----
> > > > > From: Csongor Fagyal [mailto:[EMAIL PROTECTED]]
> > > > > Sent: March 7, 2001 2:48 PM
> > > > > To: Charles Daminato; Tom Brown; [EMAIL PROTECTED]
> > > > > Subject: Re: How to retrive a list of all our customers domains
> > > > >
> > > > >
> > > > > Tom: How about using the Perl API? Isn't that easier to use then
> > > emulating
> > > > > https calls?
> > > > >
> > > > > Charles: It seems to me that setting up one CGI script which
> > > > > gives back only
> > > > > the most important data in some delimited text format should not
> take
> > > more
> > > > > than a day, once someone is on the server-side and is
> > > familiar with the
> > > > > system...
> > > > >
> > > > > - Csongor
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Charles Daminato" <[EMAIL PROTECTED]>
> > > > > To: "Tom Brown" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > > > > Sent: Wednesday, March 07, 2001 8:20 PM
> > > > > Subject: RE: How to retrive a list of all our customers domains
> > > > >
> > > > >
> > > > > > As long as you don't try to get all 10,000 of your domains
> > > (and info)
> > > at
> > > > > > once, we probably won't notice. The logic being, you
> haven't kept
> > > track
> > > > > > until now - if it takes a week to parse, let it do so...
> > > > > >
> > > > > > We're painfully aware of the lack of "data dumps" our system
> > > > > currently has
> > > > > > for our resellers. We WILL get to it, but it's a back burner
> issue.
> > > If
> > > > > the
> > > > > > data is THAT important, it should be tracked locally - it's when
> you
> > > > > decide
> > > > > > to start tracking (after some time) that becomes tricky. It'll
> > > > > happen...
> > > > > > until then, Tom's tricks will help (thanks Tom!) - as long as
> > > > > you remember
> > > > > > to be patient ;)
> > > > > >
> > > > > > Charles Daminato
> > > > > > Product Manager (ccTLDs)
> > > > > > Tucows Inc. - [EMAIL PROTECTED]
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED]]On
> > > > > > > Behalf Of Tom Brown
> > > > > > > Sent: March 7, 2001 1:55 PM
> > > > > > > To: [EMAIL PROTECTED]
> > > > > > > Subject: RE: How to retrive a list of all our
> customers domains
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > did you guys break the sslbot again? (doesn't look like it.
> > > > > :) I had to
> > > > > > > write another one for a different supplier and came up with a
> > > > > much more
> > > > > > > robust page parsing algorithm... :-) [split out the
> tables, then
> > > split
> > > > > out
> > > > > > > the rows... then parse the rows] Almost looking forward
> > > to rewriting
> > >
> > > > > that
> > > > > > > sslbot script :-)
> > > > > > >
> > > > > > > Considering that forcing clients to write robot
> scripts to pound
> > > your
> > > > > > > servers into the dirt is a just generally a bad idea, and a
> > > > > simple text
> > > > > > > output screen to dump everything would be _trivial_ to
> > > > > write... you guys
> > > > > > > don't make this easy... (I know we've discussed this before,
> > > > > and I don't
> > > > > > > hold you responsible Chuck.... :)
> > > > > > >
> > > > > > > That said, I have no real desire to grab all the customer
> > > > > fields, and I
> > > > > > > would probably do that via a whois lookup instead anyway...
> > > > > much easier
> > > > > to
> > > > > > > parse text output than HTML, and it should be faster
> than using
> an
> > > SSL
> > > > > > > connection.
> > > > > > >
> > > > > > > Taking it from that point of view, the sslbot link shown
> > > > > below is a fine
> > > > > > > starting point, parsing whois output is trivial compared to
> > > > > handling the
> > > > > > > RWI authentication and parsing HTML ... e.g. use the sslbot to
> get
> > > the
> > > > > > > list of domains, then write a short script to hit the whois
> server
> > > for
> > > > > > > each domain listed by the sslbot.
> > > > > > >
> > > > > > > the only gotcha there is if OpenSRS gets upset because you
> pounded
> > > on
> > > > > > > their whois server too many times.
> > > > > > >
> > > > > > > -Tom
> > > > > > >
> > > > > > > (p.s. anyone who wants to respond to me, please send To: me,
> > > > > and cc: the
> > > > > > > list if you want... I don't generally read the list except for
> > > OpenSRS
> > > > > > > staff postings, but the filters will pickup directly address
> > > mail...)
> > > > > > >
> > > > > > > On Wed, 7 Mar 2001, Charles Daminato wrote:
> > > > > > >
> > > > > > > > You can use a variation of a script found here:
> > > > > > > >
> > > > > > > > http://www.opensrs.org/archives/dev-list/0102/0156.html
> > > > > > > >
> > > > > > > > or an older version (not using curl) here:
> > > > > > > >
> > > > > > > > http://www.opensrs.org/archives/discuss-list/0012/0147.html
> > > > > > > >
> > > > > > > > The second script doesn't work as is - it'll take some
> tweaking,
> > > but
> > > > > the
> > > > > > > > core pieces are there.
> > > > > > > >
> > > > > > > > Charles Daminato
> > > > > > > > Product Manager (ccTLDs)
> > > > > > > > Tucows Inc. - [EMAIL PROTECTED]
> > > > > > > >
> > > > > > > > > -----Original Message-----
> > > > > > > > > From: [EMAIL PROTECTED]
> > > > > [mailto:[EMAIL PROTECTED]]On
> > > > > > > > > Behalf Of Guy Baconnière
> > > > > > > > > Sent: March 7, 2001 12:33 PM
> > > > > > > > > To: [EMAIL PROTECTED]
> > > > > > > > > Subject: How to retrive a list of all our
> customers domains
> > > > > > > > >
> > > > > > > > > Hi,
> > > > > > > > >
> > > > > > > > > We want to import into our SQL database all
> contacts fields
> > > > > > > and billing
> > > > > > > > > informations of all customers domains registered.
> > > > > > > > >
> > > > > > > > > We cannot have access to the list of all domains by the
> > > > > API without
> > > > > > > > > having the login/password of each customer. We need a
> > > > > "reseller" API
> > > > > > > > > that can give us access to all informations available
> manually
> > > on
> > > > > > > > > the reseller web
> > > > > > > > > interface (http://resellers.opensrs.net/) like
> > > contacts fields,
> > > > > > > > > billing status, etc.
> > > > > > > > >
> > > > > > > > > Is there any way to do that directly by perl
> script without
> > > > > > > > > having our customer
> > > > > > > > > user and password ?
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>
