Subversion Repositories SmartDukaan

Rev

Rev 9453 | Rev 9455 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 9453 Rev 9454
Line 117... Line 117...
117
    workbook = xlrd.open_workbook(filename)
117
    workbook = xlrd.open_workbook(filename)
118
    sheet = workbook.sheet_by_index(0)
118
    sheet = workbook.sheet_by_index(0)
119
    num_rows = sheet.nrows
119
    num_rows = sheet.nrows
120
    for rownum in range(1, num_rows):
120
    for rownum in range(1, num_rows):
121
        print sheet.row_values(rownum)
121
        print sheet.row_values(rownum)
122
        item_id = int(sheet.row_values(rownum)[0])
-
 
123
        supc = sheet.row_values(rownum)[1]
-
 
124
        try:
122
        try:
-
 
123
            item_id = int(sheet.row_values(rownum)[0])
-
 
124
            supc = sheet.row_values(rownum)[1]
125
            item = Item.query.filter_by(id=item_id).one()
125
            item = Item.query.filter_by(id=item_id).one()
126
        except Exception as e:
126
        except Exception as e:
127
            print "No item found"
127
            print "No item found"
128
            print e
128
            print e
129
            one_line = _SnapdealItemInfo(item.id, '', '', 0, '', '','', '', 0, '', False,"item_related")
129
            one_line = _SnapdealItemInfo(item.id, '', '', 0, '', '','', '', 0, '', False,"item_related")