insert csv file mysql with date time error

Question

I am trying to insert csv file into mysql but I have error in my datetime field. I tried this but recive this error on this line..... date,time = startdatetime.split('/') ValueError: need more than 1 value to unpack mycsv file rows are like these:

2880,HY13KZV,2014/07/07 09:34:28,2014/07/08 09:34:28,1280
2880,RK09UZB,2014/07/07 10:34:05,2014/07/07 16:34:05,640
for row in reader:
                print row
                try:
                    (machine_name,vrm,startdatetime,enddatetime,ticket_price) = [x.decode('utf-8-sig') for x in row]
                except:
                    print "Error with row: " % row
                tmp = startdatetime.split(" ")
                tmp = enddatetime.split(" ")
                vrm = vrm.replace(' ','')
                vrm = vrm.upper()

                ticket_price = int( SessionCost / 100)

                date,time  = startdatetime.split('/')
                month,day,year = startdate.split('/')

                entryDatetime = "%s-%s-%s %s" % (year,month,day,time)

                date,time = enddatetime.split('/')
                month,day,year = enddate.split('/')

                expiryDatetime = "%s-%s-%s %s" % (year,month,day,time)

                sql_local = """INSERT INTO customer_1.pay_and_display
                    (plate, machine_id, ticket_datetime, expiry_datetime, ticket_name, ticket_price)
                    VALUES ("%s", "%s", "%s", "%s", "%s", "%s") """ % (vrm, machine_name, entryDatetime, expiryDatetime, "Ringo", SessionCost)
            print sql_local
            cursor.execute(sql_local)

            curl = pycurl.Curl()
            body = Body()

Don't you just use the wrong separator? date,time = startdatetime.split(' ') — koffein
– koffein, Commented Jul 9, 2014 at 15:51

beiller · Accepted Answer · 2014-07-09 15:52:10Z

1

Your problem is splitting on "/" brings out 3 fields

year,month,day  = startdatetime.split('/')

Actually there is a bit more errors than that. Use the following in its place

date,time = startdatetime.split(' ')
year,month,day = date.split('/')
hour,min,second = time.split(':')

answered Jul 9, 2014 at 15:52

beiller

3,1351 gold badge14 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

shruthi Over a year ago

thanks for the quick response but i get the same error date,time = startdatetime.split(' ') ValueError: need more than 1 value to unpack

shruthi Over a year ago

I am calling this file python ./ringo.py /home/toor/ringolist/RingGoData-2014-06-24.csv

beiller Over a year ago

than it could be your row is either blank, or not formatted correctly. So validate that the row is correct at the top.

Collectives™ on Stack Overflow

insert csv file mysql with date time error

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related