Subversion Repositories SmartDukaan

Rev

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

Rev 15776 Rev 15778
Line 33... Line 33...
33 
    num_rows = sheet.nrows
 33 
    num_rows = sheet.nrows
34 
    updatedOn = to_java_date(datetime.datetime.now())
 34 
    updatedOn = to_java_date(datetime.datetime.now())
35 
    cclient = CatalogClient().get_client()
 35 
    cclient = CatalogClient().get_client()
36 
    prodClient = CatalogClient("catalog_service_server_host_prod").get_client()
 36 
    prodClient = CatalogClient("catalog_service_server_host_prod").get_client()
37 
    iclient = InventoryClient().get_client()
 37 
    iclient = InventoryClient().get_client()
38 
 
 38 
    rowsleft = [750,789,795,805,811,817,823,829,835,841,847,853,859,865,871,877,883,889,895,901,907,913,919,925,931,937,943,949,955,961,967,973,979,985,991,997,1003,1009,1015,1021,1027,1033,1039,1045,1051,1057,1063,1069,1075,1081,1087,1093,1099,1105,1111,1117,1123,1129,1135,1141,1147,1153,1159,1165,1171,1177,1183,1189,1195,1201,1207,1213,1219,1225,1231,1237,1243,1249,1255,1261,1267,1273,1279,1285,1291,1297,1303,1309,1315,1321,1327,1333,1339,1345,1351,1357,1363,1369,1375,1381,1387,1393,1399,1405,1411,1417,1423,1429,1435,1441,1447,1453,1459,1465,1471,1477,1483,1489,1495,1501,1507,1513,1519,1525,1531,1537,1543,1549,1555,1561,1567,1573,1579,1585,1591,1597,1603,1609,1615,1621,1627,1633,1639,1645,1651,1657,1663,1669,1675,1681,1687,1693,1699,1705,1711,1717,1723,1729,1735,1741,1747,1753,1759,1765,1771,1777,1783,1789,1795,1801,1807,1813,1819,1825,1831,1837,1843,1849,1855,1861,1867,1873,1879,1885,1891,1897,1903,1909,1915,1921,1927,1933,1939,1945,1951,1957,1963,1969,1975,1981,1987,1993,1999,2005,2011,2017,2023,2029,2035,2041,2047,2053,2059,2065,2071,2077,2083,2089,2095,2101,2107,2113,2119,2125,2131,2137,2143,2149,2155,2161,2167,2173,2179,2185,2191,2197,2203,2209,2215,2221,2227,2233,2239]
39 
    tcategories = cclient.getAllCategories()
 39 
    tcategories = cclient.getAllCategories()
40 
    parent_category_ids = []
40 
    parent_category_ids = []
41 
    categoryMap = {}
 41 
    categoryMap = {}
42 
    #0-Delhi 1-Maha 2-Blr 3-Ggn 4-Rajasthan 5-Telangana 6-Gujarat
 42 
    #0-Delhi 1-Maha 2-Blr 3-Ggn 4-Rajasthan 5-Telangana 6-Gujarat
43
43
Line 49... Line 49...
49 
        if tcategory.id not in parent_category_ids:
 49 
        if tcategory.id not in parent_category_ids:
50 
            categoryMap[tcategory.label] = tcategory.id
 50 
            categoryMap[tcategory.label] = tcategory.id
51
51
52 
    message = ""
 52 
    message = ""
53 
    for rownum in range(1, num_rows):
 53 
    for rownum in range(1, num_rows):
- 
 
 54 
        if rownum not in rowsleft:
- 
 
 55 
            continue
54 
        states = {}
 56 
        states = {}
55 
        try:
 57 
        try:
56 
            product_group, category_name, brand, model_number, model_name, color, mrp, sp, mop, dp, tp, nlc, start_date, preferred_vendor, risky, weight, item_type, states[0], states[3], states[1], states[2]  = sheet.row_values(rownum)[0:21]
 58 
            product_group, category_name, brand, model_number, model_name, color, mrp, sp, mop, dp, tp, nlc, start_date, preferred_vendor, risky, weight, item_type, states[0], states[3], states[1], states[2]  = sheet.row_values(rownum)[0:21]
57 
            if isinstance(model_number, float):
 59 
            if isinstance(model_number, float):
58 
                model_number = str(int(model_number))
 60 
                model_number = str(int(model_number))