for i in range(100):
test_list.append(data_list[i])
print "處理資料..."
size = len(data_list)
count = 0
results = []
count = 0
for v in data_list:
result = ResultModel()
result.nid = v.nid
result.title = v.title
result.field_data_field_body = v.field_body_value
result.link = v.link
result.field_revision_field_resource_description_g = v.field_resource_description_g_value
result.field_data_field_resource_url_g = v.field_resource_url_g_url
result.taxonomy_term_data = v.name
try:
res = Downloader.download(v.field_resource_url_g_url)
result.status = res.status_code
if res.status_code == 200:
try:
result.type = Downloader.getFileNameNExtension(res)
except NotFileException, e:
print e
try:
result.type = Downloader.getFileExtension(res)
except NoExceptionFound, e:
number_of_columns = sheet.ncols
print number_of_rows
items = []
rows = []
for row in range(1, number_of_rows):
model = ResultModel()
if row != 1:
for col in range(number_of_columns):
value = (sheet.cell(row,col).value)
if col == 0:
model.nid = value
elif col == 1:
model.title = value
elif col == 2:
model.field_data_field_body = value
elif col == 3:
model.link = value
elif col == 4:
model.field_revision_field_resource_description_g = value
elif col == 5:
model.field_data_field_resource_url_g = value
elif col == 6:
model.taxonomy_term_data = value
elif col == 7:
model.status = value
elif col == 8:
model.type = value
#print model.title
values.append(model)
