Screen scraping?
How hard is this?
I have a ticket system that includes, among other fields, a first column with "Incident ID"
Is there a way (for a novice/intermediate programmer ;) to gather this field information into a combo box and then, based upon which ticket #/incident ID that is chosen, open that ticket (just a double-click on, or <Enter> while it's highlighted does it in the application) and read certain fields from the ticket?
I'll start this out at 100 points just for the info, and increase it to 500 if it's doable and someone can help me with the code.
Thanx!
I have a ticket system that includes, among other fields, a first column with "Incident ID"
Is there a way (for a novice/intermediate programmer ;) to gather this field information into a combo box and then, based upon which ticket #/incident ID that is chosen, open that ticket (just a double-click on, or <Enter> while it's highlighted does it in the application) and read certain fields from the ticket?
I'll start this out at 100 points just for the info, and increase it to 500 if it's doable and someone can help me with the code.
Thanx!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry - my ignorance is showing, eh? : )
This is a 3rd party application, called Service Center. I'm not really sure how the data is stored for it...I don't know much about it actually....
In the taskbar, if it helps, when on the main incident screen (which shows all open tickets), it is listed as:
Prod - [Incident Queue: Open Incidents in my Assignment Group(s)]
Still sound doable? :$
This is a 3rd party application, called Service Center. I'm not really sure how the data is stored for it...I don't know much about it actually....
In the taskbar, if it helps, when on the main incident screen (which shows all open tickets), it is listed as:
Prod - [Incident Queue: Open Incidents in my Assignment Group(s)]
Still sound doable? :$
Thats a coincidence, i work with service center too.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So good to know I'm not alone in the world (I hate it, btw)....
It does its job, I suppose, but I think it's poorly written/developed, at least at this point...
I'll see if that's something I can acquire then. Thanx!
It does its job, I suppose, but I think it's poorly written/developed, at least at this point...
I'll see if that's something I can acquire then. Thanx!
ASKER
I'm wondering if they'll even have an issue with my request...is there any way to proceed with this as initially described?
ASKER
Ok - I've gotten the permission to access the db - but what do I do from here?
What kind of database are they using ? P4, SQL or ORACLE ?
ASKER
Still waiting on that info. I think if it's SQL/Oracle, I can handle with ADO, correct?
I'm not familiar with P4 - but I'm hoping to hear back from them today...
Thanx aelatik!
I'm not familiar with P4 - but I'm hoping to hear back from them today...
Thanx aelatik!
ASKER
Hi aelatik - ODBC was the response I received...
I'm guessing it's as simple as using ADO from here, huh?
I'm guessing it's as simple as using ADO from here, huh?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sounds like I may have trouble if it's Oracle or P4 then...I can probably handle the SQL option (I'm used to using Access for my backend). Where would I get the Oracle client? Presumably, the db owner would have the odbc driver if it's P4?
I'm bumping the points to 500 as I suspect I may need additional help from you. ; )
I'm bumping the points to 500 as I suspect I may need additional help from you. ; )
ASKER
Getting a little more info here...
It's apparently on a Solaris box (apparently Oracle) - I've just been shipped my login name/pw.
He's looking for the data definitions (odbc driver) for me...
I'll keep ya posted. :)
It's apparently on a Solaris box (apparently Oracle) - I've just been shipped my login name/pw.
He's looking for the data definitions (odbc driver) for me...
I'll keep ya posted. :)
ASKER
<gasp> Has it been 21 days already!?
Well, I'm still stuck with this - mostly because of my lack of understanding and the apparent lack of the db owner's ability to grant me what I need.
I'll split the points for effort here to close this out - and when he finally gets me the db connection I need, I'll drop a new question and post a pointer here.
Well, I'm still stuck with this - mostly because of my lack of understanding and the apparent lack of the db owner's ability to grant me what I need.
I'll split the points for effort here to close this out - and when he finally gets me the db connection I need, I'll drop a new question and post a pointer here.
If using a database then post the code you already have....