1:40:46 AM Kevin Liu: keep getting this error at a certain location of a certain piece of the US list
11:40:48 AM Kevin Liu: from lwb.py
11:40:49 AM Kevin Liu: Traceback (most recent call last):
  File "/usr/lib/python2.3/threading.py", line 436, in __bootstrap
    self.run()
  File "lwb.py", line 297, in run
    uid = string.atol(a[0])
  File "/usr/lib/python2.3/string.py", line 236, in atol
    return _long(s, base)
ValueError: invalid literal for long( s261


11:40:54 AM Kevin Liu: anything off the top of your head?
11:42:01 AM jimkgarvey: there might be an invalid character in the list
11:42:08 AM jimkgarvey: if you can pinpoint where it is
11:42:11 AM jimkgarvey: you can probably manually fin dit
11:42:53 AM Kevin Liu: yeah im looking
11:42:56 AM Kevin Liu: but it's referring the the uid
11:42:59 AM Kevin Liu: which is numeric
11:43:04 AM Kevin Liu: the error is thrown when trying to convert it to a num
11:43:26 AM Kevin Liu: did you add data recently?
11:49:11 AM Kevin Liu: ?
11:49:17 AM jimkgarvey: no
11:49:48 AM Kevin Liu: it does not have anything to do with the email address
11:49:50 AM Kevin Liu: it's the uid
11:50:42 AM jimkgarvey: ok well if you want to separate the uid and sort them
11:50:47 AM jimkgarvey: maybe there is an extra char somewhere
11:51:11 AM Kevin Liu: ValueError: invalid literal for long( s261

11:57:22 AM Kevin Liu: k
11:57:23 AM Kevin Liu:    for a in targets:

                                uid = string.atol(a[0])
                                cid = string.atol(a[1])
                                listname = a[2];
                                email = a[3]


11:57:32 AM Kevin Liu: how can i print out the uid it's trying to convert
11:57:55 AM Kevin Liu: like
11:57:55 AM Kevin Liu: for a in targets:
                             #print uid here
                             uid = string.atol(a[0])
                             cid = string.atol(a[1])
                             listname = a[2];
                             email = a[3]


11:58:28 AM jimkgarvey: hey sorry let me finish this contract to caroreal quick
11:58:32 AM Kevin Liu: np
12:03:48 PM Kevin Liu: k i got it to print hte uid
12:03:52 PM Kevin Liu: now to see why it can't convert...
12:04:12 PM Kevin Liu: for a in targets:
                                print "Parsing: " + a[0]
                                uid = string.atol(a[0])
                                cid = string.atol(a[1])
                                listname = a[2];
                                email = a[3]
12:05:53 PM Kevin Liu: i found the person
12:05:53 PM Kevin Liu: s261:2:haileyrobertson@msn.com

12:06:05 PM jimkgarvey: there you go
12:06:08 PM Kevin Liu: the heck though
12:06:08 PM jimkgarvey: nice work
12:06:10 PM Kevin Liu: where the person come from
12:06:13 PM jimkgarvey: not sure how tha thappened
12:06:22 PM jimkgarvey: so dude last night
12:06:23 PM Kevin Liu: and the user doesnt have  a uid or a campaign id
12:06:30 PM jimkgarvey: supposedly we did a deal to get like 12m uk
12:06:36 PM Kevin Liu: i heard!
12:06:38 PM jimkgarvey: we should get it today
12:06:47 PM Kevin Liu: great man
12:06:55 PM Kevin Liu: i heard one is like the universal music list with al ot of uk
12:06:57 PM Kevin Liu: and another is a feed
12:15:30 PM Kevin Liu: ok im scrubbing the us list for similarly bad lines
12:15:36 PM Kevin Liu: while it's running im gonna pack shower etc
12:15:49 PM jimkgarvey: word
12:17:04 PM Kevin Liu: btw what database and table is the us ("RG") data stored?
12:17:24 PM Kevin Liu: ah
12:17:27 PM Kevin Liu: "data"
12:18:26 PM jimkgarvey: yeah just double checked
12:18:29 PM Kevin Liu: brand_rg
12:18:57 PM jimkgarvey: correct
12:19:49 PM Kevin Liu: i ahve no idea how it's possible that a character could have gotten in to the list
12:19:53 PM Kevin Liu: as the user id
12:20:00 PM Kevin Liu: since it's stored as an int
12:22:11 PM Kevin Liu: weird
12:22:11 PM Kevin Liu: ok
12:22:15 PM Kevin Liu: it's happening in suppression
12:22:17 PM Kevin Liu: i'll figure it out
12:22:28 PM Kevin Liu: the offending person showed up as S:s261:2:haileyrobertson@msn.com in today's list
12:22:39 PM Kevin Liu: in the database and in the unsupped list
12:22:40 PM Kevin Liu: the person is
12:22:41 PM Kevin Liu: 15493853:93457:2:haileyrobertson@msn.com
1:40:26 PM Kevin Liu: ok man
1:40:27 PM Kevin Liu: im bouncing soon
1:40:36 PM jimkgarvey: aight dog
1:40:51 PM Kevin Liu: im sure that the list error is happning at suppression