Brad - for your consideration.

[Brangwyn]

Ok, I'm getting kinda fed up with the lack of information available to be "exported" out of HSphere, simple things like a listing of customer details, plans they're on, domains loaded etc etc etc

What I was wondering is if Brad would consider commissioning some of his coding expertise at hand to create a series of scripts external to the core HSphere stuff that resellers could use to get simple .csv files or displays of data in the main PGSQL database pertinent to them.

For starters something really simple like a script where the Reseller could enter their reseller name and password, be presented with a list of basic customer related DB fields, select what they want to display and the script would then just select these from the database and either display or present to the user for download in a nice csv format.

I'm prepared to chuck a few $$$ Vortech's way to get something like this developed (and I'm sure there's other resellers too that would be happy to contribute too) I would also expect there to be a market for something like this to be sold/licensed to other HSphere resellers which would turn a few more dollars Vortech’s way.

The script would only ever allow the reseller to display information, never update it external to HSphere so I can't think of any real security issues with doing something like this, but I could be missing something too.

[mresell]

Does seem like exporting should not be a big deal. I suppose hsphere really has no interest in this since it may involve another program.

[Brangwyn]

I can't understand why they haven't added the functionality into HSphere really, they already have the code there to "export" becuase several of the reports let you do this so adding it to say the search screens shouldn't be all that hard ... I've checked 2.4 and theres no sign of anything new in this regard hence asking if Brad could work something out ... I can't see it taking more than a few hours to actually even code personally.

The core database is a huge mess to me. I'm sure Psoft has some sort of organization to it, but reliably pulling all the data can be a bit tedious. Let alone the fact that as a reseller, you only have access to you're data, so thats every select statement would have to ensure that the data pulled is yours. This can be tremendously difficult depending on what data. DNS records for example, are stored in a table with some ID, this ID points to another ID, etc. etc. There could be 3 or 4 "hops" before you hit a reseller id.

Either way, there would be a simple modular method to implement this... The best example I have to suggest you is the current reports section and whatnot... I guess Psoft just needs a way to export the data you pull up in searches.. :/


So its not just an easy coding and I believe any implementation would be a HUGE security risk.

I don't think this will be done as you describe.

BUT:

Look here:

http://www.psoft.net/HSdocumentation/devel/index.html

http://www.psoft.net/HSdocumentation...s_xml_api.html

http://www.psoft.net/HSdocumentation...re-xml-api.pdf


The XML API may be for resellers... Not sure ;/

[Brangwyn]

My understanding was the XML API wouldn't be for resellers (but I'll cross my fingers and hope I'm wrong).

I would have expected that every column has something like the reseller ID etc as a key to be able to negate security issues, I guess if its so bad it would go a long way to explaining why performance is so p*** poor I guess ... they should be shot though too if its like that.

Looking at that first link I don't see it being all that bad really, seems theres a fairly logical structure to me .. obviously hard to say 100% without seeing the entire DB Schema

Actually just rereading your post again Matt it sounds to me like its fairly well normalised which isn't a bad thing after all

[Brangwyn]

Mind enabling the XML API on the 2.4 test install we have? The second doc you linked too explains how-to

[mresell]

Looks like someone is already using the pdf api. That's just a guess I really didn't look at the addon that closely. (hspheretools.com) Where's the 2.4 test...missed that...will go look.

Its on now... Works too...

As admin:

>searchbydomainname vortechhost.net
>Params:1:vortechhost.net
User name - wwwuser
Account id - 1136
Created - 2004-01-14 15:43:52.67
Email - webmaster@vortechhost.net
Billing type - Check
Balance - 0.0
Credit - 0.0
PEnd - 2004-04-14
Account description - Account
Domain - vortechhost.net
Domain type - Service Domain


As a reseller:

>searchbydomainname vortechhost.net
>Params:1:vortechhost.net
Error : java.lang.Exception: Not found admin resource

Also:

http://cp.vortechhost.net:8180/psoft...et/AxisServlet

[mresell]

Cool...have to check it out.

[mresell]

Originally Posted by Bladesnitz

Its on now... Works too...

As admin:

>searchbydomainname vortechhost.net
>Params:1:vortechhost.net
User name - wwwuser
Account id - 1136
Created - 2004-01-14 15:43:52.67
Email - webmaster@vortechhost.net
Billing type - Check
Balance - 0.0
Credit - 0.0
PEnd - 2004-04-14
Account description - Account
Domain - vortechhost.net
Domain type - Service Domain


As a reseller:

>searchbydomainname vortechhost.net
>Params:1:vortechhost.net
Error : java.lang.Exception: Not found admin resource

When I log onto demo and go into admin and Search by domain name using vortechhost.net I don't get anything. I don't see it listed in generic searches either. Am I missing something?

Uhm no.. vortechhost.net isn't your domain... Its owned by admin. I was using the command line test utility psoft provides to demonstrate that when I logged in as ADMIN I could look up vortechhost.net, but when I was a reseller underneat, I couldn't. So the security of data is preserved... IE I can only lookup what I should...?

Can you look up hsphere.cc in your current control panel?

[mresell]

Originally Posted by Bladesnitz

Uhm no.. vortechhost.net isn't your domain... Its owned by admin. I was using the command line test utility psoft provides to demonstrate that when I logged in as ADMIN I could look up vortechhost.net, but when I was a reseller underneat, I couldn't. So the security of data is preserved... IE I can only lookup what I should...?

Can you look up hsphere.cc in your current control panel?

I knew it wasn't mine and owned by admin I just assumed when you said as admin in search by domain that is what you meant in cp. I used the demo and logged in as admin. So apparently, you are really logged in as admin. Thanks for clarification, I was confused.

I wasn't logged into the CP, was using the Hsphere XML API test utilities...

[mresell]

If I use my real admin cp and put hsphere.cc into search by domain name I get nothing.