PDA

View Full Version : Help - File Conversion




Hurricane Bruiser
12-03-2007, 04:19 PM
Can anyone here convert the pdf file found here: http://www.wvgopconvention.com/delegate/contentview.asp?c=42045 that contains all the registered delegates, to an Excel spreadsheet that maintains the proper columns? I tried but perhaps my software conversion package is outdated. Any help would be appreciated.

RPinSEAZ
12-03-2007, 04:24 PM
Done, PM me your email address and I'll email it to you.

Dutch
12-03-2007, 04:26 PM
Can anyone here convert the pdf file found here: http://www.wvgopconvention.com/delegate/contentview.asp?c=42045 that contains all the registered delegates, to an Excel spreadsheet that maintains the proper columns? I tried but perhaps my software conversion package is outdated. Any help would be appreciated.

I put it on Megaupload for you. Sorry I have no server of my own.

http://www.megaupload.com/?d=JE530C2G

Dutch

theswedishchef
12-03-2007, 04:28 PM
Will you be posting the numbers here?
if not where?

Hurricane Bruiser
12-03-2007, 04:36 PM
I put it on Megaupload for you. Sorry I have no server of my own.


Dutch

I was looking for the file with names, addresses, county, etc... Thanks though.

tjasond
12-03-2007, 04:45 PM
Here's a Linux shell script that will download and count the delegates for you (courtesy of Damian in my meetup):

#!/bin/sh

echo "Cleaning up ..."
rm delegates.txt
rm -rf wvgopconvention.com

echo "Downloading delegate registrations from WV GOP Convention website ..."
wget -r -l 1 -I content http://wvgopconvention.com/delegate/contentview.asp?c=42045

PDF=$(ls wvgopconvention.com/content/img/f42045/Delegate_Registrations*.pdf)
echo "Converting $PDF to delegates.txt ..."
pdftotext -layout $PDF delegates.txt

echo "Delegate count:"
echo "Candidate Total At Large Committee"
for CANDIDATE in "Rudy Giuliani" "Mike Huckabee" "Duncan Hunter" "John McCain" "Ron Paul" "Mitt Romney" "Tom Tancredo" "Fred Thompson"; do
DELEGATES=$(grep "$CANDIDATE" delegates.txt)
TOTAL=$(echo "$DELEGATES" | wc -l)
ATLARGE=$(echo "$DELEGATES" | grep "At-Large" | wc -l)
XC=$(echo "$DELEGATES" | grep "XC" | wc -l)
echo "$CANDIDATE $TOTAL $ATLARGE $XC"
done

RPinSEAZ
12-03-2007, 04:46 PM
I wasn't able to convert the file you needed. I grabbed the wrong one and converted it. I was unable to properly convert the file you need to excel. I thought I was pretty smart, but this one isn't working out like I thought it would.

Dutch
12-03-2007, 05:01 PM
If you still have trouble, please directly link to the file you need converted and I'll see what I can do.

Dutch

Hurricane Bruiser
12-03-2007, 05:23 PM
Here is the direct link. http://www.wvgopconvention.com/content/img/f42045/Delegate_Registrations_12_03.pdf I thought I was pretty smart too. I don't know how to use that linux script so I must not be that smart.

Eventually the WV GOP will probably have a list by county but I would't count on it. I want to be able to use this to sort by county and see how each county is doing. If someone figures it out, let me know how for future reference. Thanks.

Dutch
12-03-2007, 05:44 PM
Sorry, that's too much for my limited skills. I could do the other one because it had one word per column so I could use spaces as delimiter.

You may want to look at http://www.investintech.com/prod_downloadsa2e.htm if you're willing to spend $ for it.

Sorry I could not be of help.

Dutch