1 | ## Script (Python) "uploads_index" |
---|
2 | ##bind container=container |
---|
3 | ##bind context=context |
---|
4 | ##bind namespace= |
---|
5 | ##bind script=script |
---|
6 | ##bind subpath=traverse_subpath |
---|
7 | ##parameters= |
---|
8 | ##title= |
---|
9 | ## |
---|
10 | # $Id:uploads_index.py 486 2006-09-06 10:09:39Z joachim $ |
---|
11 | """ |
---|
12 | return Info about the Uploads |
---|
13 | """ |
---|
14 | import DateTime |
---|
15 | import logging |
---|
16 | logger = logging.getLogger('Skins.upload_index') |
---|
17 | |
---|
18 | |
---|
19 | try: |
---|
20 | from Products.zdb import set_trace |
---|
21 | except: |
---|
22 | def set_trace(): |
---|
23 | pass |
---|
24 | request = context.REQUEST |
---|
25 | |
---|
26 | wf = context.portal_workflow |
---|
27 | mtool = context.portal_membership |
---|
28 | member = mtool.getAuthenticatedMember() |
---|
29 | |
---|
30 | path_info = request.get('PATH_INFO').split('/') |
---|
31 | info = {} |
---|
32 | info['action'] = "%s" % context.absolute_url() |
---|
33 | info['choosen_ids'] = request.get('ids',[]) |
---|
34 | info['doc'] = context.getContent() |
---|
35 | |
---|
36 | edit = request.form.has_key('edit') |
---|
37 | ids = request.get('ids',[]) |
---|
38 | if edit and ids: |
---|
39 | for long_id in ids: |
---|
40 | short_id = long_id.replace('.csv','') |
---|
41 | doc = getattr(context, long_id).getContent() |
---|
42 | import_layout = request.form.get(short_id)['import_layout'] |
---|
43 | logger.info('%s set import layout of object %s to %s' % (member,long_id,import_layout)) |
---|
44 | doc.edit(mapping = request.form[short_id]) |
---|
45 | msg, invalid_keys = doc['checkKeys']() |
---|
46 | new_keys = [] |
---|
47 | i = 0 |
---|
48 | for old_key,previous,value,err in invalid_keys: |
---|
49 | id_key = "%s|%s" % (short_id,i) |
---|
50 | if request.form.has_key(id_key): |
---|
51 | new_key = request.form.get(id_key)['valid_key'] |
---|
52 | if new_key != old_key: |
---|
53 | if new_key == doc.IGNORE: |
---|
54 | new_keys += (old_key,"%s_%s" % (doc.IGNORE,old_key),i), |
---|
55 | elif new_key != doc.NO_KEY: |
---|
56 | new_keys += (old_key,new_key,i), |
---|
57 | i += 1 |
---|
58 | if new_keys: |
---|
59 | doc.editHeadline(new_keys) |
---|
60 | for key in new_keys: |
---|
61 | logger.info('%s changed column %s heading in file %s from %s to %s' % (member, |
---|
62 | key[2], |
---|
63 | long_id, |
---|
64 | key[0], |
---|
65 | key[1])) |
---|
66 | return request.RESPONSE.redirect(context.absolute_url()) |
---|
67 | |
---|
68 | wrong = [] |
---|
69 | imported = [] |
---|
70 | importable = [] |
---|
71 | for id,upload in context.objectItems(): |
---|
72 | add_to = wrong |
---|
73 | row = {} |
---|
74 | doc = upload.getContent() |
---|
75 | row['valid_keys'] = doc['getKeys']() |
---|
76 | row['valid_keys'][0:0] = doc.NO_KEY, |
---|
77 | row['valid_keys'][1:1] = doc.IGNORE, |
---|
78 | row['id'] = id.replace('.csv','') |
---|
79 | row['title'] = doc.filename |
---|
80 | row['url'] = upload.absolute_url() |
---|
81 | row['imported'] = False |
---|
82 | row['fields'] = [] |
---|
83 | import_message = getattr(doc,'import_message','') |
---|
84 | if import_message: |
---|
85 | row['imported'] = True |
---|
86 | row['imported_by'] = getattr('doc','imported_by','') |
---|
87 | row['msg'] = import_message |
---|
88 | if getattr(doc,'import_date',''): |
---|
89 | row['import_date'] = doc.import_date.strftime("%d/%m/%y %H:%M:%S") |
---|
90 | else: |
---|
91 | row['import_date'] = '' |
---|
92 | add_to = imported |
---|
93 | |
---|
94 | else: |
---|
95 | row['msg'],row['fields'] = doc['checkKeys']() |
---|
96 | if not (request.has_key('goto_edit') and id in ids) and not row['msg']: |
---|
97 | add_to = importable |
---|
98 | row['filename'] = doc.filename |
---|
99 | row['import_layout'] = doc.import_layout |
---|
100 | row['uploaded_by'] = doc.uploaded_by |
---|
101 | row['upload_date'] = doc.upload_date.strftime("%d/%m/%y %H:%M:%S") |
---|
102 | row['imported_by'] = doc.imported_by |
---|
103 | add_to.append(row) |
---|
104 | wrong.sort(cmp,key=lambda d:d['upload_date'],reverse=1) |
---|
105 | importable.sort(cmp,key=lambda d:d['upload_date'],reverse=1) |
---|
106 | imported.sort(cmp,key=lambda d:d['import_date'],reverse=1) |
---|
107 | info['wrong'] = wrong |
---|
108 | info['imported'] = imported |
---|
109 | info['importable'] = importable |
---|
110 | info['import_allowed'] = str(member) in ('admin','joachim',) |
---|
111 | |
---|
112 | validate = "upload" in request.keys() |
---|
113 | mode = "create" |
---|
114 | res,psm,ds = context.portal_layouts.renderLayout(layout_id = 'upload', |
---|
115 | schema_id = 'upload', |
---|
116 | layout_mode = mode, |
---|
117 | context=context, |
---|
118 | mapping=validate and request, |
---|
119 | ob= {}, |
---|
120 | commit = True, |
---|
121 | ) |
---|
122 | while True: |
---|
123 | if psm == 'invalid': |
---|
124 | psm = "Please correct your input!" |
---|
125 | # return context.uploads_form(rendered = res, |
---|
126 | # psm = "Please correct your input!", |
---|
127 | # mode = mode, |
---|
128 | # ds = ds, |
---|
129 | # info = info, |
---|
130 | # ) |
---|
131 | elif psm == 'valid': |
---|
132 | filename = ds['upload_file'].filename |
---|
133 | if filename.find('\\') > -1: |
---|
134 | filename = filename.split('\\')[-1] |
---|
135 | if filename not in context.objectIds(): |
---|
136 | break |
---|
137 | psm = "Upload object exists!" |
---|
138 | logger.info('%s views upload section' % member) |
---|
139 | return context.uploads_form(rendered = res, |
---|
140 | psm = psm, |
---|
141 | ds = ds, |
---|
142 | mode = mode, |
---|
143 | info = info, |
---|
144 | ) |
---|
145 | |
---|
146 | context.invokeFactory('Upload',filename) |
---|
147 | #set_trace() |
---|
148 | upload = getattr(context,filename) |
---|
149 | d = {} |
---|
150 | d['filename'] = d['id'] = filename |
---|
151 | d['upload_date'] = DateTime.DateTime() |
---|
152 | d['import_layout'] = ds.get('import_layout','') |
---|
153 | d['uploaded_by'] = str(member) |
---|
154 | d['url'] = upload.absolute_url() |
---|
155 | upload.getContent().edit(mapping=d) |
---|
156 | logger.info('%s uploaded file %s with import layout %s' % (member,filename,d['import_layout'])) |
---|
157 | |
---|
158 | return request.RESPONSE.redirect(context.absolute_url()) |
---|
159 | |
---|
160 | |
---|