Annotation tables - Revision history

Stacy shinneman: /* Introduction */

2018-02-20T11:38:08Z

‎Introduction

2018-02-20T11:37:25Z

‎Sharing tables with other users

2018-02-20T11:36:51Z

‎Sharing tables with other users

2014-10-31T08:30:35Z

‎Giving access to your schema

2013-11-21T16:51:23Z

‎Introduction

2013-06-11T15:19:56Z

‎Creating a database table by uploading a CSV file

2013-06-11T15:18:48Z

‎Creating a database table by uploading a CSV file

2013-06-11T15:18:05Z

‎Creating a database table by uploading a CSV file

2013-06-11T15:16:08Z

‎Creating a database table by uploading a CSV file

2013-03-05T10:04:42Z

‎Introduction

@@ Line 3: / Line 3: @@
 == Introduction ==
-In a highly database oriented environment with different types of users, some users prefer the possibility of uploading file-based data they would like to merge with data currently stored in the database and potentially share with other users.
+In a highly database-oriented environment with different types of users, some users prefer the possibility of uploading file-based data they would like to merge with data currently stored in the database and potentially share with other users.
 For the creation of a new table, the automated system should know the number and type of columns in the uploaded file. This means that some sort of template must exist in the system before a table can be uploaded and inserted automatically. Since most users will typically upload more than one table with the same column names and types, a template has to be created only once and can be reused many times by the same user or by a group of users.
@@ Line 14: / Line 14: @@
 Furthermore, these pages describe how tables can be used and shared with other users.
-The annotation webservice is still being tested and not for general use: [https://services.e-ecology.sara.nl/cgi-bin/flysafe/uva_admin/upload_csv.cgi]
+The annotation webservice is still being tested and is not for general use: [https://services.e-ecology.sara.nl/cgi-bin/flysafe/uva_admin/upload_csv.cgi]
 == Creating a new table template ==

@@ Line 135: / Line 135: @@
 You can give other users access to your schema and the tables contained in your schema using a database administration tool, such as PgAdminIII. The following example shows how to give another user the usage privilege to your schema. The second step shows how to give another user read-only access to the recently uploaded table, so that the other user can read the contents of the table. The contents are still protected, so they cannot be changed by other users.
-Start PgadminIII and connect to the e-Ecology database. Then
+Start PgadminIII and connect to the e-Ecology server. Then
 look in the server browser.

@@ Line 135: / Line 135: @@
 You can give other users access to your schema and the tables contained in your schema using a database administration tool, such as PgAdminIII. The following example shows how to give another user the usage privilege to your schema. The second step shows how to give another user read-only access to the recently uploaded table, so that the other user can read the contents of the table. The contents are still protected, so they cannot be changed by other users.
-Start PgadminIII and connect to "services.flysafe.sara.nl". Then
+Start PgadminIII and connect to the e-Ecology database. Then
 look in the server browser.

@@ Line 140: / Line 140: @@
 === Giving access to your schema ===
-To give other users access to your tables, you must first give the other users access to your schema. Due to an inconsistency in PgAdminIII, changing this in PgAdminIII requires administrator privileges, although this should not be required. As a workaround, you must use SQL to give others access to your schema.
+To give other users access to your tables, you must first give the other users access to your schema. To do so you must modify the schema rights by using SQL.
+Open the SQL interface by clicking on the "SQL" button as shown in the figure. This will open the SQL interface.
 [[File:annotation_sql.png]]
-The SQL shown will be to create the object that is hightlighted. You can safely remove the code and type your own code.
+The SQL shown will be to create the object that is highlighted. You can safely remove the code and type your own code.
 To grant another user access to this schema, type

@@ Line 14: / Line 14: @@
 Furthermore, these pages describe how tables can be used and shared with other users.
-The annotation webservice is still being tested and not for general use: [https://services.flysafe.sara.nl/cgi-bin/flysafe/uva_admin/upload_csv.pl]
+The annotation webservice is still being tested and not for general use: [https://services.e-ecology.sara.nl/cgi-bin/flysafe/uva_admin/upload_csv.cgi]
 == Creating a new table template ==

@@ Line 62: / Line 62: @@
 To upload a file into a new database table:
 .Go to the "Upload table" page in the Annotation management pages. This will show you an upload
 form.

@@ Line 58: / Line 58: @@
 each column corresponds with a column in your CSV file.
-To upload a file into a new database table, go to the "Upload table"
+Note that fields that use the timestamp format must be a valid postgresql date-time format. Otherwise an error will occur when trying to upload a file. See the link below for accepted formats:
 page in the Annotation management pages. This will show you an upload
 form.
-First, select the file you want to upload by clicking on the "browse"
+. Select the file you want to upload by clicking on the "browse"
 button.
-Second, enter a name for the new database table. This must be a valid
+. Enter a name for the new database table. This must be a valid
 database table name, so it must start with a letter, contain no spaces or
 special characters, and be no longer than ? characters.
-Then select the template which will be used for creating the new table.
+. Select the template which will be used for creating the new table.
 Currently, all templates from all owners are shown.
-Note that fields that use the timestamp format must be a valide postgresql date-time format. Otherwise an error will occur when trying to upload a file. See the link below for accepted formats:
+. Click the "Upload file" button. This will start uploading the
 file, create a new table from the specified template and import the data
 from the file into the new table.