Software » EEA website systems

= How to update MDS database =
General information * Reference ticket: '''#4199''' * Google account to store the data: '''eeacms@gmail.com''' * Target users: '''managers''' and '''content editors''' * '''EEA CMS add form: '''not yet available'''''' * '''MDS Exhibit view: '''not yet available''''''

For content editors * ''' add new record''' In order to add new records go to MDS spreadsheet and from the "Form" tab select "Go to live form", fill the form as needed and click '''submit''',''' '''the data will then be added on a new row at the end of the spreadsheet. In order for the form to work, data entered throw the form must '''NOT''' contain '''"''', please use ''''''' instead.BRBR Image(formselect.JPG)''' * ''' edit an existing record''' Any editing of existing content has to be done on 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 BR Image(addfile.JPG) BR 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''' BR Image(convert.JPG) BR Clicking the '''view''' tab will now display the file in exhibit tile view.