H
- Status
B
Big Kenny
New member
I'm looking forward to getting my new ribbons so I can use the mics I bought last time, that's patience....
C
chance
Well-known member
I think Quiktune has you beat. When I shipped tha last GB orders, I shipped his from the previous Group buy. LOL
R
recordinghacks
professional middle child
another volunteer
Regarding the need to either retype or copy/paste thousands of cells of data:
Like the other folks here with a background in software, I could easily produce a CVS or Excel file of the necessary data... if only I had the source data to work with.
My suggestion is one I haven't seen mentioned here before -- if Randy could send me a dump of the database (mysql can output this with a one-line command) I could import it and work with Chance to give UPS whatever they need.
I know Randy is slammed, but I bet he and I could effect the transfer in about 10 minutes -- he'd do the export, then we'd arrange a secure transfer to my network, and I'd import the data back into mysql and produce whatever output is needed.
Just another option...
Regarding the need to either retype or copy/paste thousands of cells of data:
Like the other folks here with a background in software, I could easily produce a CVS or Excel file of the necessary data... if only I had the source data to work with.
My suggestion is one I haven't seen mentioned here before -- if Randy could send me a dump of the database (mysql can output this with a one-line command) I could import it and work with Chance to give UPS whatever they need.
I know Randy is slammed, but I bet he and I could effect the transfer in about 10 minutes -- he'd do the export, then we'd arrange a secure transfer to my network, and I'd import the data back into mysql and produce whatever output is needed.
Just another option...
dgatwood
is out. Leave a message.
That thought crossed my mind as well. Depends on how he has the data split up as to whether that would expose too much info, though ISTR that the CC numbers never reach his server, so maybe that's not an issue. Dunno. I didn't get as far as checking to see if it was NySQL or SQL Server. If it's mysql, then
mysqldump -uUsername -p db_name > file
(and then type the password when prompted) ought to do it.
C
chance
Well-known member
The only thing I have is a text list with names, addresses, phone numbers, and E-dresses. This is nothing that Fed Ex or USPS can convert to a CSV
mshilarious
Banned
Even with all the data in a single field, it shouldn't be that hard to parse. Look for a number to split the street from the name, a five-number sequence for ZIP, the two letters before that for state . . . there will be more than a few exceptions, but those can be handled manually. Still a lot faster than rekeying . . .
C
chance
Well-known member
What I have been doing (still takes a lot of time) is copy/paste from my list each first name, last name, address, city, state, zip code, phone number, and E-dress. For international, theres more.
antichef
pornk rock
that sounds painful -- if you haven't gotten very far through it, I can probably automate it a great deal with a perl script, pretty much the way mshilarious describes.
(edit: but my offer has to be withdrawn in 3 hours when I go back to my house-without-power for the weekend
)
Last edited:
KJI
New member
How is the list formatted?
With that info alone it might be possible to write a program or script to transform it into something useable.
For example, is it like:
Name1
Address1
Phone#1
email1
<blank line>
Name2
Address2
Phone#2
email2
C
chance
Well-known member
Well,, I got 22 orders entered in my address book.
Here is how my list looks for each order:
Chance Pataki
musicians.workshop@gte.net
Salutation:
Mr.
First Name:
Chance
Last Name:
Pataki
Address Line 1:
XXXX E Granada Ct
Address Line 2:
City:
Ontario
State:
CA
Zip Code:
91764
Country Code:
USA
Phone Number:
555-555-5555
Phone Extension:
Fax Number:
Cellular Phone Number:
555-555-5555
It's gonna be a loong week LOL (inch by inch it's a cinch)
Here is how my list looks for each order:
Chance Pataki
musicians.workshop@gte.net
Salutation:
Mr.
First Name:
Chance
Last Name:
Pataki
Address Line 1:
XXXX E Granada Ct
Address Line 2:
City:
Ontario
State:
CA
Zip Code:
91764
Country Code:
USA
Phone Number:
555-555-5555
Phone Extension:
Fax Number:
Cellular Phone Number:
555-555-5555
It's gonna be a loong week LOL (inch by inch it's a cinch)
thebwack
New member
chance, i really admire your attitude,
but it just hurts me to think your gonna have to do all that one item at a time... especially with so many willing and able (myself included) to turn any kind of data you have (any format really) into a cvs for you.
sorry we are going on about this... it just hurts...
YOU ROCK by the way...
but it just hurts me to think your gonna have to do all that one item at a time... especially with so many willing and able (myself included) to turn any kind of data you have (any format really) into a cvs for you.
sorry we are going on about this... it just hurts...
YOU ROCK by the way...
S
studio23
...Uh?...
If you're using a mac and Excel 2008, it seems like you could just use this simple automator workflow. here and that should do it all in one click for you provided the only people in your address book are GB participants. Obviously you wouldn't have to do the second step of importing into gmail, but the first step should leave you with an excel file of all of your contacts. Any reason why that wouldn't work?
EDIT: click free:
To create a csv file Automator of your contacts in Address Book add the following actions to a workflow:
Find People in Address Book, Set Whose to Name, is not equal to, and then use * in the input field - This tells automator to look through all the names in your address book and return everyone that doesn’t have a * in their name.
Get Contact Information, Export Format: Spreadsheet (tabs) - This gathers all the information about each contact and puts it into a standard format we can work with.
New Text File - I named it contacts.txt and saved it to my desktop - This will write the information from address book to a text file
Import Text Files to Excel Workbook - Select New Workbook and mark the delimiters as Tab
Save Excel Workbooks - Save Workbooks as contacts, on the desktop and select CSV(Comma Delimited) as the format
EDIT: click free:
To create a csv file Automator of your contacts in Address Book add the following actions to a workflow:
Find People in Address Book, Set Whose to Name, is not equal to, and then use * in the input field - This tells automator to look through all the names in your address book and return everyone that doesn’t have a * in their name.
Get Contact Information, Export Format: Spreadsheet (tabs) - This gathers all the information about each contact and puts it into a standard format we can work with.
New Text File - I named it contacts.txt and saved it to my desktop - This will write the information from address book to a text file
Import Text Files to Excel Workbook - Select New Workbook and mark the delimiters as Tab
Save Excel Workbooks - Save Workbooks as contacts, on the desktop and select CSV(Comma Delimited) as the format
dgatwood
is out. Leave a message.
I assume there is really a blank line for extension before fax number? If so, save this in your home directory as parselist.sh, then do
chmod a+x parselist.sh
./parselist.sh /path/to/file/containing/this/list.txt
and see if that gives you an acceptable CSV file. If not, let me know what order you need the fields in or what records give you trouble and I'll see what I can do.
#!/bin/sh
echo "$1"
IFS="
"
DATA="$(cat $1)";
echo "DATA: $DATA"
while [ "x$DATA" != "x" ] ; do
EMAIL="$(echo "$DATA" | grep -B 1 "Salutation:" | head -n 1 | sed 's/,/-/g')"
SALUTATION="$(echo "$DATA" | grep -A 1 "Salutation:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
FIRSTNAME="$(echo "$DATA" | grep -A 1 "First Name:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
LASTNAME="$(echo "$DATA" | grep -A 1 "Last Name:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
ADDR1="$(echo "$DATA" | grep -A 1 "Address Line 1:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
ADDR2="$(echo "$DATA" | grep -A 1 "Address Line 2:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
CITY="$(echo "$DATA" | grep -A 1 "City:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
STATE="$(echo "$DATA" | grep -A 1 "State:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
ZIP="$(echo "$DATA" | grep -A 1 "Zip Code:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
COUNTRY="$(echo "$DATA" | grep -A 1 "Country Code:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
PHONE="$(echo "$DATA" | grep -A 1 "Phone Number:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
EXT="$(echo "$DATA" | grep -A 1 "Phone Extension:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
if [ "x$EXT" = "xFax Number:" ] ; then
EXT="";
fi
# DATA="$(echo "$DATA" | perl -pi.bak -e "s/^.*?Cellular Phone Number:\n(\s|\d|[()])+\n+\s*//s")"
DATA="$(echo "$DATA" | perl -e '$/=undef;my $foo = <STDIN>; $foo =~ s/^.*?Cellular Phone Number:\n([-0-9 (),]|\t)*\n\s*//s; print $foo;')"
# echo "DATA is \"$DATA\"";
echo "$SALUTATION $FIRSTNAME $LASTNAME,$ADDR1,$ADDR2,$CITY,$STATE,$ZIP,$COUNTRY,$PHONE $EXT"
done
chmod a+x parselist.sh
./parselist.sh /path/to/file/containing/this/list.txt
and see if that gives you an acceptable CSV file. If not, let me know what order you need the fields in or what records give you trouble and I'll see what I can do.
#!/bin/sh
echo "$1"
IFS="
"
DATA="$(cat $1)";
echo "DATA: $DATA"
while [ "x$DATA" != "x" ] ; do
EMAIL="$(echo "$DATA" | grep -B 1 "Salutation:" | head -n 1 | sed 's/,/-/g')"
SALUTATION="$(echo "$DATA" | grep -A 1 "Salutation:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
FIRSTNAME="$(echo "$DATA" | grep -A 1 "First Name:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
LASTNAME="$(echo "$DATA" | grep -A 1 "Last Name:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
ADDR1="$(echo "$DATA" | grep -A 1 "Address Line 1:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
ADDR2="$(echo "$DATA" | grep -A 1 "Address Line 2:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
CITY="$(echo "$DATA" | grep -A 1 "City:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
STATE="$(echo "$DATA" | grep -A 1 "State:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
ZIP="$(echo "$DATA" | grep -A 1 "Zip Code:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
COUNTRY="$(echo "$DATA" | grep -A 1 "Country Code:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
PHONE="$(echo "$DATA" | grep -A 1 "Phone Number:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
EXT="$(echo "$DATA" | grep -A 1 "Phone Extension:" | head -n 2 | tail -n 1 | sed 's/,/-/g')"
if [ "x$EXT" = "xFax Number:" ] ; then
EXT="";
fi
# DATA="$(echo "$DATA" | perl -pi.bak -e "s/^.*?Cellular Phone Number:\n(\s|\d|[()])+\n+\s*//s")"
DATA="$(echo "$DATA" | perl -e '$/=undef;my $foo = <STDIN>; $foo =~ s/^.*?Cellular Phone Number:\n([-0-9 (),]|\t)*\n\s*//s; print $foo;')"
# echo "DATA is \"$DATA\"";
echo "$SALUTATION $FIRSTNAME $LASTNAME,$ADDR1,$ADDR2,$CITY,$STATE,$ZIP,$COUNTRY,$PHONE $EXT"
done
C
chance
Well-known member
C
chance
Well-known member
hotroder. Check your Em, and lemme nough.
C
chance
Well-known member
You too Dave!
Some of you guys are probably thinking, "Huh?", but a couple people offered their help. I hope they can make it happen because the boat is due to arrive in a couple of days
C
chance
Well-known member
The boat is due in Oct first. Man, I'm getting nervous! Without that shipping info, is like having that perfect mix, and your burner isn't working. LOL
W
wreckd504
New member
Sounds like you've got someone helping you out now?
If not - I know everyone else has already said the same...but an export of the database takes <10mins, then just need it to be put it on an ftp for me to grab it.
I could then generate a csv file for you in about the same time it would take you to finish typing the first entry, is it not worth emailing randy and asking for an export of the db? I know he's busy but its not a giant task, and this will take you hours needlessly.
If not - I know everyone else has already said the same...but an export of the database takes <10mins, then just need it to be put it on an ftp for me to grab it.
I could then generate a csv file for you in about the same time it would take you to finish typing the first entry, is it not worth emailing randy and asking for an export of the db? I know he's busy but its not a giant task, and this will take you hours needlessly.
C
chance
Well-known member
Send me an E-mail ASAP
- Status