Bead Stringing Projects
Looking for freelance Bead Stringing jobs and project work? PeoplePerHour has you covered.
Post an offer to educate them
Past "Bead-stringing" Projects
LinkedIn Leads Extract into LinkedIn List
I need someone who is familiar with LinkedIn Sales Navigator who can search through LinkedIn and extract 100 potential leads per week based on the criteria I have. This is a bit more than just putting in a search string and accepting the selection returned by LinkedIn. Each potential lead needs to have a (very) brief review for quality. There will need to be a couple of weeks close collaboration where I can feedback on the quality but generally very straight forward. I have current take up rates for % connections etc. to monitor performance. The requirement is ongoing but there will be periods/weeks where the searches will not be undertaken. I would envisage that there will generally be 4 week search with occassional breaks. Ignore the budget displayed, happy to answer any queries. Look forward to hearing from you.
Collect information from web and LinkedIn and make database in online Excel. 5-7 days
2 account from you. (1 here, 1 from last offer) Target: We collect all funds into 2 LI accounts and 1 online CRM file. Firstly we should connect Sales Navigator to these accounts. I have virtual debit card for this purposes. Actions 0. Main work file in online 1. Find new company. No duplicates! ( but in should be inside. Closed and developing funds is ok for me too) 2. Fill new strings - Yellow + green + blue 3. Add website (yellow field) 4. Add public email (Green field) 5. Go to LinkedIn. 6. Find company inside search 7. Click inside. Click to the “See all xxx employees on LinkedIn” 8. Copy top persons a. founders + CEO b. Analytics and invest managers c. Angels d. Advisers 9. Max – 10 people per Fund! 10. Add everybody to the friends (!) In this account 11. Copy info about everybody to the strings a. Name b. Linkedin address c. Role 12. New string for new person (!) What we need from this list --- main information 1. founders + CEO 2. Analytics and invest managers 3. Angels 4. Advisers It take from me 10 minutes per company. There near 270 funds (some of them is closed). It will be 200-240 real companies. So it would take 4-6 days of 8 hours work.
pre-fundedurgent
I need python code fixed
I am currently using python and tweepy to access a MySQL db and pull down screen_names in the store, I then request the tweets associated with the specific screen name and save them to MySQL for processing. I have a central table where I store if an account has been pulled from Twitter, when I get the repose I update the central table to indicate that the screen_name has been processed. The problem is that the central table is not being updated to indicate that the screen_name has been processed. Not being effective with Python I am not sure the syntax to use (I have tried strings and %s but that does not work). I need someone to urgently help and assist in fixing the below code so that I am able to execute the program. The line of code below I am having problems with is: cursor.execute("UPDATE `xxxxxxxx.xxxxxxxxx` SET submitted = 'yes' WHERE screen_name=%s;", (screen_name,)) I need to finish this within the next two hours. ============================================================================================= #!/usr/bin/env python import tweepy import MySQLdb import sys # Keys consumer_key = 'xxxxxxxxxxxxxxx' consumer_secret = 'xxxxxxxxxx' access_token = 'xxxxxxxxxx' access_token_secret = 'xxxxxxxxxxx' host = "xxxxxxxxxx" user = "xxxxxxxx" passwd = "xxxxxxxxxxxx" database = "xxxxxxxxx" # Twitter initialization auth = tweepy.OAuthHandler(consumer_key, consumer_secret) auth.set_access_token(access_token, access_token_secret) api = tweepy.API(auth) # MySQL initialization connection = MySQLdb.connect(host=host, user=user, passwd=passwd, db=database, charset="latin1") cursor = connection.cursor() # The table schema: CREATE TABLE tweets # tweet_id BIGINT NOT NULL, # tweet_text VARCHAR(160) NOT NULL, # screen_name VARCHAR(160) NOT NULL, cursor.execute("SELECT screen_name FROM xxxxxx.xxxxxxxx WHERE platform = 'tw' and submitted = 'no' LIMIT 1") screen_name = cursor.fetchone()[0] print(screen_name) cursor.execute("UPDATE `xxxxxxxx.xxxxxxxxx` SET submitted = 'yes' WHERE screen_name=%s;", (screen_name,)) print(screen_name) print("submitting to twitter") try: statuses = api.user_timeline(screen_name=screen_name, count=200) for user in statuses: print(user.id, user.text.encode('UTF-8'), user.author.screen_name.encode('UTF-8'), user.author.id, user.created_at) # load to MySQL server cursor.execute("INSERT INTO tweets (tweet_id, tweet_text, screen_name, author_id, created_at, inserted_at) VALUES (%s, %s, %s, %s, %s, NOW());", (user.id, user.text.encode('UTF-8'), user.author.screen_name.encode('UTF-8'), user.author.id, user.created_at)) connection.commit() if not cursor.rowcount: print("no values found") except tweepy.error.TweepError: print("Tweepy error, could not fetch data!") except UnicodeEncodeError: print('Unicode error') else: print("Unexpected error: ", sys.exc_info()[0]) finally: cursor.close() connection.close()