I'm in the process of making a SQL query to pull similar information that would be pulled in an "Explorer Classic" split report with "All Columns" for a range of splits for an entire day. The main difference for my needed query is the order of the columns, a few less columns, and the descriptions left off (i.e. "50268" instead of "50268
oe, Jane" for a login). I don't know much about SQL, but I am slowly getting the information I need out of the tables (10 of 50+ fields per day).
I would be grateful get a copy of any example SQL queries that pulls some or all of the fields that appear in an "All Columns" report.
Thanks in advance for ANY help.
Dan
---
Also, another problem, which happens to be the reason I want a SQL query is as follows...
I recently made a VB macro that automates Internet Explorer to pull "All Columns" reports for 6 splits for a whole day and save them as unique html files. It takes around two hours to save the reports as HTML, compile them in Excel, delete junk, remove unwanted columns, put columns in order I want, and finally save the file as CSV. Using this means to get the data has caused the following problems:
1. Too slow
2. One split at a time
3. Can't pull 24 hrs at a time because automation fails if it takes over 50 minutes or so for a single report to finish. I can't remember the exact error, but it is similar to "Excel is waiting for another OLE automation to finish".
4. Have to pull 4 hrs at a time twice for a whole day per split (my solution to problem 3). If I pull a report from 12 AM to 4 AM and another for 4 AM to 8 AM, and incrementing 4 hrs each time, I do not get any calls that start before 4 AM and end after 4 AM. So the solution is to run another report at 2 AM to 6 AM and 6 AM to 10 AM, and incrementing 4 hrs each time.
5. I can't get all the calls for an entire day no matter what I do. This is similar to problem 4. If the call starts before midnight and ends after midnight, the call will never show up on the report. If I pull the report manually for 12:00 AM to 11:59 PM for 6/1/02 to 6/2/02, it will not show a call that started on the 1st and ended on the 2nd.
6. I hate to use "SendKeys" to fill out fields on the query pages, and I don't know a way around it.
If anyone notices that problem 5 doesn't exist for their server, I'd appreciate the info. Also, If anyone has an example for filling out text boxes on a web page using VB code and without using SendKeys, I'd really like to see it.
Thanks again for any info,
Dan
oe, Jane" for a login). I don't know much about SQL, but I am slowly getting the information I need out of the tables (10 of 50+ fields per day). I would be grateful get a copy of any example SQL queries that pulls some or all of the fields that appear in an "All Columns" report.
Thanks in advance for ANY help.
Dan
---
Also, another problem, which happens to be the reason I want a SQL query is as follows...
I recently made a VB macro that automates Internet Explorer to pull "All Columns" reports for 6 splits for a whole day and save them as unique html files. It takes around two hours to save the reports as HTML, compile them in Excel, delete junk, remove unwanted columns, put columns in order I want, and finally save the file as CSV. Using this means to get the data has caused the following problems:
1. Too slow
2. One split at a time
3. Can't pull 24 hrs at a time because automation fails if it takes over 50 minutes or so for a single report to finish. I can't remember the exact error, but it is similar to "Excel is waiting for another OLE automation to finish".
4. Have to pull 4 hrs at a time twice for a whole day per split (my solution to problem 3). If I pull a report from 12 AM to 4 AM and another for 4 AM to 8 AM, and incrementing 4 hrs each time, I do not get any calls that start before 4 AM and end after 4 AM. So the solution is to run another report at 2 AM to 6 AM and 6 AM to 10 AM, and incrementing 4 hrs each time.
5. I can't get all the calls for an entire day no matter what I do. This is similar to problem 4. If the call starts before midnight and ends after midnight, the call will never show up on the report. If I pull the report manually for 12:00 AM to 11:59 PM for 6/1/02 to 6/2/02, it will not show a call that started on the 1st and ended on the 2nd.
6. I hate to use "SendKeys" to fill out fields on the query pages, and I don't know a way around it.
If anyone notices that problem 5 doesn't exist for their server, I'd appreciate the info. Also, If anyone has an example for filling out text boxes on a web page using VB code and without using SendKeys, I'd really like to see it.
Thanks again for any info,
Dan