Subversion Repositories SmartDukaan

Rev

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

Rev 5444 Rev 5452
Line 31... Line 31...
31 
        raise Exception("No vendor found for the id: " + str(vendorId))
 31 
        raise Exception("No vendor found for the id: " + str(vendorId))
32
32
33 
    workbook = xlrd.open_workbook(filename)
 33 
    workbook = xlrd.open_workbook(filename)
34 
    sheet = workbook.sheet_by_index(0)
 34 
    sheet = workbook.sheet_by_index(0)
35 
    num_rows = sheet.nrows
 35 
    num_rows = sheet.nrows
36 
    keys = []
 - 
 
37 
    new_items = []
 36 
    new_items = []
38 
    phased_out_items = []
 37 
    phased_out_items = []
39 
    updated_items = []
 38 
    updated_items = []
40 
    unchanged_items = []
 39 
    unchanged_items = []
41
40
Line 48... Line 47...
48 
        if isinstance(model_number, float):
 47 
        if isinstance(model_number, float):
49 
            model_number = str(int(model_number))
 48 
            model_number = str(int(model_number))
50
49
51 
        item = None
 50 
        item = None
52 
        vendor_item_pricing = None
 51 
        vendor_item_pricing = None
- 
 
 52 
        keys = []
53 
        if product_group.strip().lower() == 'New Handset'.strip().lower():
 53 
        if product_group.strip().lower() == 'New Handset'.strip().lower():
54 
            for our_group in ["handsets", "mobile handset", "smart phone"]:
 54 
            for our_group in ["handsets", "mobile handset", "smart phone"]:
55 
                new_key = our_group.strip().lower() + '|' + brand.strip().lower() + '|' + model_number.strip().lower() + '|' + color.strip().lower()
 55 
                new_key = our_group.strip().lower() + '|' + brand.strip().lower() + '|' + model_number.strip().lower() + '|' + color.strip().lower()
56 
                keys.append(new_key)
 56 
                keys.append(new_key)
57 
        else:
 57 
        else: