Error while inserting data into mysql table using python from excel sheet -


here trying import data excel mysql table, getting error like: not arguments converted during string formatting

import xlrd import mysqldb,os,os.path,datetime dt os.chdir("file path") filename = raw_input("enter file name: ",) workbook = xlrd.open_workbook(filename) sheet = workbook.sheet_by_index(0) date = dt.datetime.today().strftime("%d/%m/%y") fname = filename user = 'umd' database = mysqldb.connect (host="localhost", user = "root", passwd = "psswd", db = "mrkt_data") cursor = database.cursor() r in range(0, sheet.nrows):     name      = sheet.cell(r,0).value     email_id      = sheet.cell(r,1).value     alt_numbr      = sheet.cell(r,2).value     dob      = sheet.cell(r,3).value     mobile      = sheet.cell(r,4).value     functional_area      = sheet.cell(r,5).value     specialization      = sheet.cell(r,6).value     industry      = sheet.cell(r,7).value     resume_title      = sheet.cell(r,8).value     keyskill      = sheet.cell(r,9).value     work_exp      = sheet.cell(r,10).value     curnt_emplyr      = sheet.cell(r,11).value     prev_emplyr      = sheet.cell(r,12).value     curnt_sal      = sheet.cell(r,13).value     level      = sheet.cell(r,14).value     curnt_loc      = sheet.cell(r,15).value     pref_loc      = sheet.cell(r,16).value     course_pri_high_edu      = sheet.cell(r,17).value     splztn_pri_high_edu      = sheet.cell(r,18).value     inst_pri_high_edu      = sheet.cell(r,19).value     course_sec_high_edu      = sheet.cell(r,20).value     splztn_sec_high_edu       = sheet.cell(r,21).value     inst_sec_high_edu       = sheet.cell(r,22).value     last      = sheet.cell(r,23).value     active      = sheet.cell(r,24).value     date      = sheet.cell(r,25).value     gender      = sheet.cell(r,26).value     age      = sheet.cell(r,27).value      address      = sheet.cell(r,28).value     resume_id      = sheet.cell(r,29).value      query =  insert data (name,email_id,alt_numbr,dob,mobile,functional_area,specialization,industry,resume_title,keyskill,work_exp,curnt_emplyr,prev_emplyr,curnt_sal,level,curnt_loc,pref_loc,course_pri_high_edu,splztn_pri_high_edu,inst_pri_high_edu,course_sec_high_edu,splztn_sec_high_edu,inst_sec_high_edu,last,active,date,gender,age,address,resume_id,market_type,date_logged,source) values ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');"     values = (name,email_id,alt_numbr,dob,mobile,functional_area,specialization,industry,resume_title,keyskill,work_exp,curnt_emplyr,prev_emplyr,curnt_sal,level,curnt_loc,pref_loc,course_pri_high_edu,splztn_pri_high_edu,inst_pri_high_edu,course_sec_high_edu,splztn_sec_high_edu,inst_sec_high_edu,last,active,date,gender,age,address,resume_id,user,date,fname) cursor.execute(query, values) cursor.close() database.commit() database.close() print "no of rows : ", sheet.nrows print "" print " done! " print "" 


error:      traceback (most recent call last):      file "excel2mysql.py", line 60, in <module>      cursor.execute(query, values)      file "/usr/lib/python2.7/dist-packages/mysqldb/cursors.py", line 159, in execute      query = query % db.literal(args)      typeerror: not arguments converted during string formatting

you have 33 items want insert, 32 places insert them. try below code. (i added %s)

 query =  insert data (name,email_id,alt_numbr,dob,mobile,functional_area,specialization,industry,resume_title,keyskill,work_exp,curnt_emplyr,prev_emplyr,curnt_sal,level,curnt_loc,pref_loc,course_pri_high_edu,splztn_pri_high_edu,inst_pri_high_edu,course_sec_high_edu,splztn_sec_high_edu,inst_sec_high_edu,last,active,date,gender,age,address,resume_id,market_type,date_logged,source) values ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');"

Comments

Post a Comment

Popular posts from this blog

How to connect android app to App engine -

i'm trying connect app in android server i've opened on appengine. my server's name : dddd-daniel-2345 , website server : http://dddd-daniel-2345.appspot.com/ this how connect android app server in app engine: app.yaml: application: dddd-daniel-2345 version: 1 runtime: python27 api_version: 1 threadsafe: yes handlers: - url: .* script: main.app libraries: - name: webapp2 version: "2.5.2" main.py: #!/usr/bin/env python # # copyright 2007 google inc. google.appengine.api import users import webapp2 class userhandler(webapp2.requesthandler): def get(self): user = users.get_current_user() if user: greeting = ('%s,%s,%s' % (user.email(),user.user_id(),user.nickname())) else: greeting = ('not logged in') self.response.out.write(greeting) app = webapp2.wsgiapplication([('/', userhandler),], debug=true) my applications code : add manifast main....
Read more

gcc - MinGW's ld cannot perform PE operations on non PE output file -

i know there other similar questions out there, stackoverflow or not. i've researched lot this, , still didn't find single solution. i'm doing operative system side project. i've been doing in assembly, wanna join c code. test, made assembly code file (called test.asm): [bits 32] global _a section .text _a: jmp $ then made c file (called main.c): extern void a(void); int main(void) { a(); } to link, used file (called make.bat): "c:\mingw\bin\gcc.exe" -ffreestanding -c -o c.o main.c nasm -f coff -o asm.o test.asm "c:\mingw\bin\ld.exe" -ttext 0x100000 --oformat binary -o out.bin c.o asm.o pause i've been researching ages, , i'm still struggling find answer. hope won't flagged duplicate. acknowledge existence of similar questions, have different answers, , none work me. question: what doing wrong? old mingw versions had problem "ld" not able create non-pe files @ all. maybe current versions...
Read more

php - display validation error message next to the textbox in codeigniter -

Image
i'm newbie codeigniter.i want display error message next text box.my view file create.php contains following code. <?php echo validation_errors(); //validation echo form_open('news/create'); //create form ?> <div class="boxes"> <div class="common"> <div class="lables"> <label for="name">name</label> </div> <div class="text_boxes"> <input type="text" name="uname" /><div id="infomessage"><?php echo $message;?></br> </div> </div>` and below controller model: public function create() { $this->load->helper('form'); $this->load->library('form_validation'); $data['title'] = 'insert items'; $this->form_validation->set_rules('uname','required|min_length[6]|m...
Read more