| Line 92... |
Line 92... |
| 92 |
if '(' in model_number_str:
|
92 |
if '(' in model_number_str:
|
| 93 |
model_number_str = model_number_str.split('(')[0]
|
93 |
model_number_str = model_number_str.split('(')[0]
|
| 94 |
return str('handsets|' + brand.strip().lower() + '|' + model_number_str.strip().lower() + '|' + color.strip().lower())
|
94 |
return str('handsets|' + brand.strip().lower() + '|' + model_number_str.strip().lower() + '|' + color.strip().lower())
|
| 95 |
|
95 |
|
| 96 |
def load_item_numbers():
|
96 |
def load_item_numbers():
|
| 97 |
filename = "/home/ashish/itemNumbers.xls"
|
97 |
filename = "/home/rajveer/Desktop/itemNumbers.xls"
|
| 98 |
workbook = xlrd.open_workbook(filename)
|
98 |
workbook = xlrd.open_workbook(filename)
|
| 99 |
sheet = workbook.sheet_by_index(0)
|
99 |
sheet = workbook.sheet_by_index(0)
|
| 100 |
num_rows = sheet.nrows
|
100 |
num_rows = sheet.nrows
|
| 101 |
itemNumberMap = {}
|
101 |
itemNumberMap = {}
|
| 102 |
itemNumberTypeMap = {}
|
102 |
itemNumberTypeMap = {}
|
| Line 186... |
Line 186... |
| 186 |
|
186 |
|
| 187 |
def main():
|
187 |
def main():
|
| 188 |
itemNumberMap, itemNumberTypeMap = load_item_numbers()
|
188 |
itemNumberMap, itemNumberTypeMap = load_item_numbers()
|
| 189 |
catalog_client = CatalogClient().get_client()
|
189 |
catalog_client = CatalogClient().get_client()
|
| 190 |
item_details = []
|
190 |
item_details = []
|
| 191 |
filename = "/home/ashish/featurevalues3.xls"
|
191 |
filename = "/home/rajveer/Desktop/featurevalues.xls"
|
| 192 |
workbook = xlrd.open_workbook(filename)
|
192 |
workbook = xlrd.open_workbook(filename)
|
| 193 |
sheet = workbook.sheet_by_index(0)
|
193 |
sheet = workbook.sheet_by_index(0)
|
| 194 |
num_rows = sheet.nrows
|
194 |
num_rows = sheet.nrows
|
| 195 |
|
195 |
|
| 196 |
writer = csv.writer(open("junglee.csv", "wb"), delimiter='\t', quoting=csv.QUOTE_MINIMAL)
|
196 |
writer = csv.writer(open("junglee.csv", "wb"), delimiter='\t', quoting=csv.QUOTE_MINIMAL)
|
| Line 272... |
Line 272... |
| 272 |
|
272 |
|
| 273 |
if size == "Not available" or size == '':
|
273 |
if size == "Not available" or size == '':
|
| 274 |
length, width, height = ["", "", ""]
|
274 |
length, width, height = ["", "", ""]
|
| 275 |
else:
|
275 |
else:
|
| 276 |
list = size.split()
|
276 |
list = size.split()
|
| 277 |
length, width, height = [list[0], list[2], list[4]]
|
277 |
length, width, height = [list[0]+" MM", list[2]+" MM", list[4]+" MM"]
|
| 278 |
|
278 |
|
| 279 |
keywords = []
|
279 |
keywords = []
|
| 280 |
for keyword in metaKeywords.split(","):
|
280 |
for keyword in metaKeywords.split(","):
|
| 281 |
keywords.append(keyword.strip())
|
281 |
keywords.append(keyword.strip())
|
| 282 |
if len(keywords) < 5:
|
282 |
if len(keywords) < 5:
|
| 283 |
length = len(keywords)
|
283 |
length1 = len(keywords)
|
| 284 |
while length < 5:
|
284 |
while length1 < 5:
|
| 285 |
keywords.append('')
|
285 |
keywords.append('')
|
| 286 |
length = length + 1
|
286 |
length1 = length1 + 1
|
| 287 |
|
287 |
|
| 288 |
for keyword in keywords:
|
288 |
for keyword in keywords:
|
| 289 |
if len(keyword) > 50:
|
289 |
if len(keyword) > 50:
|
| 290 |
print keyword
|
290 |
print keyword
|
| 291 |
|
291 |
|
| Line 299... |
Line 299... |
| 299 |
key = get_hotspot_mapping(mappings)
|
299 |
key = get_hotspot_mapping(mappings)
|
| 300 |
if key and itemNumberTypeMap.has_key(key):
|
300 |
if key and itemNumberTypeMap.has_key(key):
|
| 301 |
stdProductId = itemNumberMap[key]
|
301 |
stdProductId = itemNumberMap[key]
|
| 302 |
stdProductIdType = itemNumberTypeMap[key]
|
302 |
stdProductIdType = itemNumberTypeMap[key]
|
| 303 |
item_details.append(
|
303 |
item_details.append(
|
| 304 |
[item.id, get_title(item), get_url(item), item.sellingPrice, "1", "803546031", stdProductId,\
|
304 |
[item.id, get_title(item), get_url(item), item.sellingPrice, "1", "803073031", stdProductId,\
|
| 305 |
stdProductIdType, "Wireless", tagline, '0', 'http://' + str(image_url), item.mrp, "TRUE",\
|
305 |
stdProductIdType, "Wireless", tagline, '0', str(image_url), item.mrp, "TRUE",\
|
| 306 |
item.brand, "", "", item.modelNumber, "", builtIn,\
|
306 |
item.brand, "", "", item.modelNumber, "", builtIn,\
|
| 307 |
ram, "", "", "", screenSize, screenResolution,\
|
307 |
ram, "", "", "", screenSize, screenResolution,\
|
| 308 |
screenType, "", "", "", "", "",\
|
308 |
screenType, "", "", "", "", "",\
|
| 309 |
cellularTechnology, opsys,\
|
309 |
cellularTechnology, opsys,\
|
| 310 |
#talktime2G, standy2G, - TODO: use these values after converting them to minutes and hours respectively
|
310 |
#talktime2G, standy2G, - TODO: use these values after converting them to minutes and hours respectively
|