DPChallenge: A Digital Photography Contest You are not logged in. (log in or register) 
 

DPChallenge Forums >> General Discussion >> Need help with
Pages:  
Showing posts 1 - 6 of 6, (reverse)
AuthorThread
 11/28/2006 02:35:48 AM · #1
Office 2000 (excel) building a query. I had one user send me a query file where you could enter the source code from a challenge webpage and it would list username and score, from 1st place to last place. I lost the email file that contained that query file and would love to have it back. I would like to know if this kind of query could be advanced enough to look for particular usernames. I am looking for help with this in attempts of updating the wpl quicker.

Can anyone offer me help with this or any other program that would help me automate the site? Any help would be grateful.
Thanks,
SDW
11/28/2006 11:10:59 AM · #2
bump
11/28/2006 11:27:32 AM · #3
I have this link that gives you info by user name.

//www.myfoobar.com/DPC/

Maybe it is the same person. I can't find the thread where this was posted. I'll keep looking.

here it is

//www.dpchallenge.com/forum.php?action=read&FORUM_THREAD_ID=425843

//www.dpchallenge.com/profile.php?USER_ID=48257

Message edited by author 2006-11-28 11:31:55.
 11/28/2006 11:39:07 AM · #4
Originally posted by scarbrd:
I have this link that gives you info by user name.

//www.myfoobar.com/DPC/

Maybe it is the same person. I can't find the thread where this was posted. I'll keep looking.

here it is

//www.dpchallenge.com/forum.php?action=read&FORUM_THREAD_ID=425843

[user]48257[/user]

Thanks but thats not the one I'm looking for. I'll try to explain a little what I looking for.

The excel query file allows you to:
1. Goto the challenge results page and click 'Show full results' so all entries are on one page.
2. Right click > view source.
3. It will open up a text editor with the page source code.
4. Save the text file.
5. Open the "query excel file" I'm looking for and import the saved source file.
6. Run query and it will list in column A 'Username' and in column B 'Score'.
7. It will list all entries from 1st to last place "username and score".

Oh I wish I could remember who sent me that file. I lost the email it was attached to.

And help would be grateful.
Thanks,
SDW
11/28/2006 07:23:16 PM · #5
Sent you a PM
 11/28/2006 07:47:44 PM · #6
Originally posted by Nuzzer:
Sent you a PM

Thanks, I have pm you back.
SDW
Pages:  
Current Server Time: 09/20/2025 03:23:08 PM

Please log in or register to post to the forums.


Home - Challenges - Community - League - Photos - Cameras - Lenses - Learn - Help - Terms of Use - Privacy - Top ^
DPChallenge, and website content and design, Copyright © 2001-2025 Challenging Technologies, LLC.
All digital photo copyrights belong to the photographers and may not be used without permission.
Current Server Time: 09/20/2025 03:23:08 PM EDT.