WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/catalog/script/GenerateJungleeData.py

         model_number_str = str(int(model_number))
     except:
         model_number_str = str(model_number)
     if '(' in model_number_str:
         model_number_str = model_number_str.split('(')[0]
-    return brand.strip().lower() + '|' + model_number_str.strip().lower() + '|' + color.strip().lower()
+    return str('handsets|' + brand.strip().lower() + '|' + model_number_str.strip().lower() + '|' + color.strip().lower())
 def load_item_numbers():
     filename = "/home/ashish/itemNumbers.xls"
     workbook = xlrd.open_workbook(filename)
     sheet = workbook.sheet_by_index(0)
     num_rows = sheet.nrows
     itemNumberMap = {}
     itemNumberTypeMap = {}
-    for rownum in range(1, num_rows):
+    for rownum in range(2, num_rows):
         itemNumber, unused_description, unused_pc, unused_pg, unused_tech, brand, model_number, color = sheet.row_values(rownum)[0:8]
         key = get_key(brand, model_number, color)
+        itemNumberStr = str(itemNumber)
+        if not itemNumberStr.isdigit():
+            continue
-        itemNumberMap[key] = str(itemNumber)
+        itemNumberMap[key] = itemNumberStr
-        if len(str(itemNumber)) == 13:
+        if len(itemNumberStr) == 13:
             itemNumberTypeMap[key] = 'EAN'
-        else:
+        elif len(itemNumberStr) == 12:
             itemNumberTypeMap[key] = 'UPC'
     print itemNumberMap
     return itemNumberMap, itemNumberTypeMap
         screenType = 'LED'
     else:
         screenType = ''
     return screenType
+def get_hotspot_mapping(mappings):
+    for mapping in mappings:
+        if mapping.vendorId == 1:
+            return mapping.itemKey
+    return None
 def main():
     itemNumberMap, itemNumberTypeMap = load_item_numbers()
     catalog_client = CatalogClient().get_client()
     item_details = []
-    filename = "/home/ashish/featurevalues.xls"
+    filename = "/home/ashish/featurevalues2.xls"
     workbook = xlrd.open_workbook(filename)
     sheet = workbook.sheet_by_index(0)
     num_rows = sheet.nrows
     writer = csv.writer(open("junglee.csv", "wb"), delimiter='\t', quoting=csv.QUOTE_MINIMAL)
                  "Shipping Weight","Weight","Length","Height","Width","Keywords1","Keywords2", "Keywords3","Keywords4",\
                  "Keywords5","Bullet point1","Bullet point2","Bullet point3","Bullet point4","Bullet point5",\
                  "Other image-url1","Other image-url2","Other image-url3","Other image-url4","Other image-url5",
                  "Offer note","Is Gift Wrap Available","Registered Parameter","Update Delete"])
-    for rownum in range(2, num_rows):
+    for rownum in range(2, num_rows): #2 is used as the starting index because first row is a test product with 12 years of warranty.
         unused_categoryName, unused_entityName, entityID, unused_accessories, unused_softwareApplications, unused_pageTitle,\
-        unused_metaDescription, metaKeywords, snippets, shortSnippet, tagline, warranty,\
+        unused_metaDescription, metaKeywords, snippets, shortSnippet, tagline,\
         unused_skinSize, screenSize, unused_screenLeftUpperCornerDimension, unused_modelNameSynonyms, unused_modelNumberSynonyms,\
+        warranty, unused_warranty_type, unused_warranty_coverage, \
         weight, size, formFactor, color, screenType, screenSize, screenResolution, numberOfColors, keyboardType,\
         navigation, touchscreenType, sideControls, multimediaKeys, multipleSIM, voip, network2G,\
         network3G, gprs, edge, g3, wifi, bluetooth, usb, musicFormats, earphone, speakerPhone,\
         fmRadio, internetRadio, ringtoneTypes, fileFormats, streaming, liveTV, hdVideoPlayback,\
         resolution, flash, imageFormats, numberOfCameras, secondaryCamera, additionalCameraFeatures,\
         builtIn, ram, expansionType, expansionCapacity, batteryType, powerAdaptor, musicPlayback,\
         videoPlayback, tvPlayback, talktime2G, talktime3G, standy2G, standby3G, types, markupLanguages,\
         unused_http_protocols, unused_browser, unused_mail_protocols, opsys, unused_java, unused_flashPlayer, unused_drm, unused_securityFeatures, unused_gpsType, unused_mms, unused_sms, unused_ems,\
-        unused_instantMessaging, unused_email = sheet.row_values(rownum)[0:85]
+        unused_instantMessaging, unused_email = sheet.row_values(rownum)[0:87]
         items = catalog_client.getItemsByCatalogId(entityID)
         active_items = filter(is_active, items)
         if not active_items:
             continue
             length, width, height = ["", "", ""]
         else:
             list = size.split()
             length, width, height = [list[0], list[2], list[4]]
+        keywords = []
-        keywords = metaKeywords.split(",")
+        for keyword in metaKeywords.split(","):
+            keywords.append(keyword.strip())
         if len(keywords) < 5:
             length = len(keywords)
             while length < 5:
                 keywords.append('')
                 length = length + 1
+        for keyword in keywords:
+            if len(keyword) > 50:
+                print keyword
         for item in active_items:
             stdProductId = ''
             stdProductIdType = ''
             if not item.color:
                 item.color = ''
+            mappings = catalog_client.getVendorItemMappings(item.id)
-            key = get_key(item.brand, item.modelNumber, item.color)
+            key = get_hotspot_mapping(mappings)
-            if itemNumberMap.has_key(key):
+            if key and itemNumberTypeMap.has_key(key):
                 stdProductId = itemNumberMap[key]
                 stdProductIdType = itemNumberTypeMap[key]
             item_details.append(
                         [item.id, get_title(item), get_url(item), item.sellingPrice, "1", "803546031", stdProductId,\
                          stdProductIdType, "Wireless", tagline, '0', get_image_url(item), item.mrp, "TRUE",\

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/catalog/script/GenerateJungleeData.py – Rev 3584 → 3992