source: WAeUP_SRP/trunk/skins/waeup_upload/uploads_index.py @ 17936

Last change on this file since 17936 was 5596, checked in by Henrik Bettermann, 14 years ago

Allow isouaba import of data.

  • Property svn:keywords set to Id
File size: 5.9 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.strftime("%d/%m/%y %H:%M:%S")
90            row['import_date_for_sort'] = doc.import_date.strftime("%y/%m/%d %H:%M:%S")
91        else:
92            row['import_date'] = ''
93        add_to = imported
94
95    else:
96        row['msg'],row['fields'] = doc['checkKeys']()
97        if not (request.has_key('goto_edit') and id in ids) and not row['msg']:
98            add_to = importable
99    row['filename'] = doc.filename
100    row['import_layout'] = doc.import_layout
101    row['uploaded_by'] =  doc.uploaded_by
102    row['upload_date_for_sort'] =  doc.upload_date.strftime("%y/%m/%d %H:%M:%S")
103    row['upload_date'] =  doc.upload_date.strftime("%d/%m/%y %H:%M:%S")
104    row['imported_by'] = doc.imported_by
105    add_to.append(row)
106wrong.sort(cmp,key=lambda d:d['upload_date_for_sort'],reverse=1)
107importable.sort(cmp,key=lambda d:d['upload_date_for_sort'],reverse=1)
108imported.sort(cmp,key=lambda d:d['import_date_for_sort'],reverse=1)
109info['wrong'] = wrong
110info['imported'] = imported
111info['importable'] = importable
112info['import_allowed'] = str(member) in ('admin','isouaba',)
113
114validate = "upload" in request.keys()
115mode = "create"
116res,psm,ds = context.portal_layouts.renderLayout(layout_id = 'upload',
117                             schema_id = 'upload',
118                             layout_mode = mode,
119                             context=context,
120                             mapping=validate and request,
121                             ob= {},
122                             commit = True,
123                            )
124while True:
125    if psm == 'invalid':
126        psm = "Please correct your input!"
127    # return context.uploads_form(rendered = res,
128    #                              psm = "Please correct your input!",
129    #                              mode = mode,
130    #                              ds = ds,
131    #                              info = info,
132    #                             )
133    elif psm == 'valid':
134        filename = ds['upload_file'].filename
135        if filename.find('\\') > -1:
136            filename = filename.split('\\')[-1]
137        if filename not in context.objectIds():
138            break
139        psm = "Upload object exists!"
140    logger.info('%s views upload section' % member)
141    return context.uploads_form(rendered = res,
142                                        psm = psm,
143                                        ds = ds,
144                                        mode = mode,
145                                        info = info,
146                                       )
147
148context.invokeFactory('Upload',filename)
149#set_trace()
150upload = getattr(context,filename)
151d = {}
152d['filename'] = d['id'] = filename
153d['upload_date'] =  DateTime.DateTime()
154d['import_layout'] = ds.get('import_layout','')
155d['uploaded_by'] = str(member)
156d['url'] = upload.absolute_url()
157upload.getContent().edit(mapping=d)
158logger.info('%s uploaded file %s with import layout %s' % (member,filename,d['import_layout']))
159
160return request.RESPONSE.redirect(context.absolute_url())
161
162
Note: See TracBrowser for help on using the repository browser.