| Line 157... |
Line 157... |
| 157 |
|
157 |
|
| 158 |
def main():
|
158 |
def main():
|
| 159 |
itemNumberMap, itemNumberTypeMap = load_item_numbers()
|
159 |
itemNumberMap, itemNumberTypeMap = load_item_numbers()
|
| 160 |
catalog_client = CatalogClient().get_client()
|
160 |
catalog_client = CatalogClient().get_client()
|
| 161 |
item_details = []
|
161 |
item_details = []
|
| 162 |
filename = "/home/ashish/featurevalues2.xls"
|
162 |
filename = "/home/ashish/featurevalues3.xls"
|
| 163 |
workbook = xlrd.open_workbook(filename)
|
163 |
workbook = xlrd.open_workbook(filename)
|
| 164 |
sheet = workbook.sheet_by_index(0)
|
164 |
sheet = workbook.sheet_by_index(0)
|
| 165 |
num_rows = sheet.nrows
|
165 |
num_rows = sheet.nrows
|
| 166 |
|
166 |
|
| 167 |
writer = csv.writer(open("junglee.csv", "wb"), delimiter='\t', quoting=csv.QUOTE_MINIMAL)
|
167 |
writer = csv.writer(open("junglee.csv", "wb"), delimiter='\t', quoting=csv.QUOTE_MINIMAL)
|
| Line 177... |
Line 177... |
| 177 |
"Keywords5","Bullet point1","Bullet point2","Bullet point3","Bullet point4","Bullet point5",\
|
177 |
"Keywords5","Bullet point1","Bullet point2","Bullet point3","Bullet point4","Bullet point5",\
|
| 178 |
"Other image-url1","Other image-url2","Other image-url3","Other image-url4","Other image-url5",
|
178 |
"Other image-url1","Other image-url2","Other image-url3","Other image-url4","Other image-url5",
|
| 179 |
"Offer note","Is Gift Wrap Available","Registered Parameter","Update Delete"])
|
179 |
"Offer note","Is Gift Wrap Available","Registered Parameter","Update Delete"])
|
| 180 |
|
180 |
|
| 181 |
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.
|
181 |
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.
|
| 182 |
unused_categoryName, unused_entityName, entityID, unused_accessories, unused_softwareApplications, unused_pageTitle,\
|
182 |
unused_categoryName, unused_entityName, entityID, image_url, unused_accessories, unused_softwareApplications, unused_pageTitle,\
|
| 183 |
unused_metaDescription, metaKeywords, snippets, shortSnippet, tagline,\
|
183 |
unused_metaDescription, metaKeywords, snippets, shortSnippet, tagline,\
|
| 184 |
unused_skinSize, screenSize, unused_screenLeftUpperCornerDimension, unused_modelNameSynonyms, unused_modelNumberSynonyms,\
|
184 |
unused_skinSize, screenSize, unused_screenLeftUpperCornerDimension, unused_modelNameSynonyms, unused_modelNumberSynonyms,\
|
| 185 |
warranty, unused_warranty_type, unused_warranty_coverage, \
|
185 |
warranty, unused_warranty_type, unused_warranty_coverage, \
|
| 186 |
weight, size, formFactor, color, screenType, screenSize, screenResolution, numberOfColors, keyboardType,\
|
186 |
weight, size, formFactor, color, screenType, screenSize, screenResolution, numberOfColors, keyboardType,\
|
| 187 |
navigation, touchscreenType, sideControls, multimediaKeys, multipleSIM, voip, network2G,\
|
187 |
navigation, touchscreenType, sideControls, multimediaKeys, multipleSIM, voip, network2G,\
|
| Line 189... |
Line 189... |
| 189 |
fmRadio, internetRadio, ringtoneTypes, fileFormats, streaming, liveTV, hdVideoPlayback,\
|
189 |
fmRadio, internetRadio, ringtoneTypes, fileFormats, streaming, liveTV, hdVideoPlayback,\
|
| 190 |
resolution, flash, imageFormats, numberOfCameras, secondaryCamera, additionalCameraFeatures,\
|
190 |
resolution, flash, imageFormats, numberOfCameras, secondaryCamera, additionalCameraFeatures,\
|
| 191 |
builtIn, ram, expansionType, expansionCapacity, batteryType, powerAdaptor, musicPlayback,\
|
191 |
builtIn, ram, expansionType, expansionCapacity, batteryType, powerAdaptor, musicPlayback,\
|
| 192 |
videoPlayback, tvPlayback, talktime2G, talktime3G, standy2G, standby3G, types, markupLanguages,\
|
192 |
videoPlayback, tvPlayback, talktime2G, talktime3G, standy2G, standby3G, types, markupLanguages,\
|
| 193 |
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,\
|
193 |
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,\
|
| 194 |
unused_instantMessaging, unused_email = sheet.row_values(rownum)[0:87]
|
194 |
unused_instantMessaging, unused_email = sheet.row_values(rownum)[0:88]
|
| 195 |
|
195 |
|
| 196 |
items = catalog_client.getItemsByCatalogId(entityID)
|
196 |
items = catalog_client.getItemsByCatalogId(entityID)
|
| 197 |
active_items = filter(is_active, items)
|
197 |
active_items = filter(is_active, items)
|
| 198 |
if not active_items:
|
198 |
if not active_items:
|
| 199 |
continue
|
199 |
continue
|
| Line 259... |
Line 259... |
| 259 |
if key and itemNumberTypeMap.has_key(key):
|
259 |
if key and itemNumberTypeMap.has_key(key):
|
| 260 |
stdProductId = itemNumberMap[key]
|
260 |
stdProductId = itemNumberMap[key]
|
| 261 |
stdProductIdType = itemNumberTypeMap[key]
|
261 |
stdProductIdType = itemNumberTypeMap[key]
|
| 262 |
item_details.append(
|
262 |
item_details.append(
|
| 263 |
[item.id, get_title(item), get_url(item), item.sellingPrice, "1", "803546031", stdProductId,\
|
263 |
[item.id, get_title(item), get_url(item), item.sellingPrice, "1", "803546031", stdProductId,\
|
| 264 |
stdProductIdType, "Wireless", tagline, '0', get_image_url(item), item.mrp, "TRUE",\
|
264 |
stdProductIdType, "Wireless", tagline, '0', 'http://' + str(image_url), item.mrp, "TRUE",\
|
| 265 |
item.brand, "", "", item.modelNumber, "", builtIn,\
|
265 |
item.brand, "", "", item.modelNumber, "", builtIn,\
|
| 266 |
ram, "", "", "", screenSize, screenResolution,\
|
266 |
ram, "", "", "", screenSize, screenResolution,\
|
| 267 |
screenType, "", "", "", "", "",\
|
267 |
screenType, "", "", "", "", "",\
|
| 268 |
cellularTechnology, opsys,\
|
268 |
cellularTechnology, opsys,\
|
| 269 |
#talktime2G, standy2G, - use these values after converting them to minutes and hours respectively
|
269 |
#talktime2G, standy2G, - use these values after converting them to minutes and hours respectively
|