source: WAeUP_SRP/base/skins/waeup_upload/uploads_index.py @ 3325

Last change on this file since 3325 was 3325, checked in by joachim, 17 years ago

pending and errors can be downloaded,
line_nr of wrong record added

  • Property svn:keywords set to Id
File size: 5.5 KB
Line 
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"""
12return Info about the Uploads
13"""
14import DateTime
15import logging
16logger = logging.getLogger('Skins.upload_index')
17
18
19try:
20    from Products.zdb import set_trace
21except:
22    def set_trace():
23        pass
24request = context.REQUEST
25
26wf = context.portal_workflow
27mtool = context.portal_membership
28member = mtool.getAuthenticatedMember()
29
30path_info = request.get('PATH_INFO').split('/')
31info = {}
32info['action'] = "%s" % context.absolute_url()
33info['choosen_ids'] = request.get('ids',[])
34info['doc'] = context.getContent()
35
36edit = request.form.has_key('edit')
37ids = request.get('ids',[])
38if 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
68wrong = []
69imported = []
70importable = []
71for 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
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)
104wrong.sort()
105imported.sort()
106importable.sort()
107info['wrong'] = wrong
108info['imported'] = imported
109info['importable'] = importable
110info['import_allowed'] = str(member) in ('admin','joachim',)
111
112validate = "upload" in request.keys()
113mode = "create"
114res,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                            )
122while 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 not in context.objectIds():
134            break
135        psm = "Upload object exists!"
136    logger.info('%s views upload section' % member)
137    return context.uploads_form(rendered = res,
138                                        psm = psm,
139                                        ds = ds,
140                                        mode = mode,
141                                        info = info,
142                                       )
143
144context.invokeFactory('Upload',filename)
145upload = getattr(context,filename)
146d = {}
147d['filename'] = d['id'] = filename
148d['upload_date'] =  DateTime.DateTime()
149d['import_layout'] = ds.get('import_layout','')
150d['uploaded_by'] = str(member)
151d['url'] = upload.absolute_url()
152upload.getContent().edit(mapping=d)
153logger.info('%s uploaded file %s with import layout %s' % (member,filename,d['import_layout']))
154
155return request.RESPONSE.redirect(context.absolute_url())
156
157
Note: See TracBrowser for help on using the repository browser.