« Previous -
Version 33/46
(diff) -
Next » -
Current version
Bogdan Ciobanu, 04/05/2011 14:19
= How to update MDS database =
Target users: managers and content editors
- ''' Content editors: adding and editing records'''
In order to add new records go to "the spreadsheet page" and from the Form tab select Go to live form BR
Image(formselect.JPG) BR
Fill the form as needed and click '''submit''',''' '''the data will then appear on the spreadsheet.BR
'''In order for the form to work none of the data entered may contain " ,use ' instead.'''BR
Any editing of existing content has to be done from the spreadsheet directly.BR - '''Managers: exporting to CSV and adding the exhibit'''BR
'''Exporting to CSV'''BR
Open '''"the spreadsheet page"''', go to '''file''' tab, select '''download as''' and then select OpenOffice BR
Image(saveods.JPG)BR
After the file has been saved open it in Open Office, go to '''file''' and select '''save as'''; under '''save as type''' select '''TextCSV (.csv)'''BR
Image(savecsv.JPG) BR
Check the '''Edit filter settings''' box and the click '''save''' BR
Image(saveedit.JPG)BR
In the '''Export of text files''' window select '''Unicode (UTF-8)''' for the Character set, '''{Tab}''' for the field delimiter and '''" '''for the text delimiter and then click ok BR
Image(saveexport.JPG)BR
=== Adding the exhibit ===
On the EEA site, login as CMS and go to '''"the exhibit folder"''', once there go to '''add items''' and select '''file''' from the dropdown menu Image(addfile.JPG) Select the csv saved from open office and click save, the page will now display your file in csv view, go to '''actions''' and select '''convert to exhibit view''' Image(convert.JPG) Clicking the '''view''' tab will now display the file in exhibit tile view.
