def import_wxr(request, blog_slug='', blog_root=''):
from forms import ImportForm
if request.method == "POST":
form = ImportForm(request.POST, request.FILES)
if form.is_valid():
if form.cleaned_data.get('format') == "WXR":
blog_slug = form.cleaned_data['blog_slug']
included_tags = form.cleaned_data['include_tags']
excluded_tags = form.cleaned_data['exclude_tags']
wxr_file = request.FILES['input_file']
tools.import_wxr(blog_slug, wxr_file, included_tags, excluded_tags)
else:
form = ImportForm()
td = dict(form=form)
return render_to_response("blog/tools/import_wxr.html",
td,
context_instance=RequestContext(request))
def importgrades(request):
username = request.user.username
if request.POST:
form = ImportForm(request.POST, request.FILES)
if form.is_valid():
try:
xlsfile = request.FILES.get('grades', '')
filename = xlsfile.name
#创建文件存储的路径
fname = os.path.join(
settings.MEDIA_ROOT,
'uploads/grades/%s' % strftime("%Y/%m/%d", localtime()),
filename)
if os.path.exists(fname):
os.remove(fname)
dirs = os.path.dirname(fname)
if not os.path.exists(dirs):
os.makedirs(dirs)
#写入文件
if os.path.isfile(fname):
os.remove(fname)
content = xlsfile.read()
fp = open(fname, 'wb')
fp.write(content)
fp.close()
#格式化xls文件中数据，将其存到数据库中
book = open_workbook(fname)
sheet = book.sheet_by_index(0)
for row_index in range(sheet.nrows):
record = sheet.row_values(row_index, 0)
try:
student = Student.objects.get(
user__username=str(record[1]).rstrip(".0"))
grade = Grade(term=record[0],
student=student,
score=record[2])
grade.save()
except Student.DoesNotExist, e:
traceback.print_stack()
traceback.print_exc()
print e
successinfo = "上传"
success = True
return render_to_response(
'grade/import.html', {
"title": '导入成绩单',
'form': form,
'successinfo': successinfo,
'success': success,
'username': username
},
context_instance=RequestContext(request))
except Exception, e:
traceback.print_stack()
traceback.print_exc()
print e
def importgrades(request):
username = request.user.username
if request.POST:
form = ImportForm(request.POST, request.FILES)
if form.is_valid():
try:
xlsfile = request.FILES.get('grades', '')
filename = xlsfile.name
#文件存储路径创建
fname = os.path.normpath(os.path.join(settings.MEDIA_ROOT, 'uploads/grades/%s' %strftime('%Y/%m/%d', localtime()), filename))
if os.path.exists(fname):
os.remove(fname)
dirs = os.path.dirname(fname)
if not os.path.exists(dirs):
os.makedirs(dirs)
#Writing into file
if os.path.isfile(fname):
os.remove(fname)
content = xlsfile.read()
fp = open(fname, 'wb')
fp.write(content)
fp.close()
#格式化xls文件中数据， 将其存在到数据库中
book = open_workbook(fname)
sheet = book.sheet_by_index(0)
for row_index in range(sheet.nrows):
record = sheet.row_values(row_index, 0)
try:
student = Student.objects.get(user__username=str(record[1]).rstrip(".0"))
grade = Grade(term=record[0], student=student, socre=record[2])
grade.save()
except Student.DoseNotExist, e:
traceback.print_stack()
traceback.print_exc()
print e
successinfo = u'上传'
success = True
return render_to_response('grade/import.html', {
'title': u'导入成绩',
'form': form,
'successinfo': successinfo,
'success': success,
'username': username
}, context_instance=RequestContext(request))
except Exception, e:
traceback.print_stack()
traceback.print_exc()
print e
def import_subscription(request):
"""
Forms-based interface for OPML import
"""
import_failed = False
if request.method == 'POST':
form = ImportForm(request.POST, request.FILES)
if form.is_valid():
uploaded_file = request.FILES['opml_file']
try:
feedprocessor.import_opml(uploaded_file.read(), request.user)
return HttpResponseRedirect(reverse('reader:index'))
except:
import_failed = True
else:
form = ImportForm()
return render(request, 'reader/import.html', {'form':form, 'import_failed':import_failed})
