| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Database in YG

Page history last edited by ElizabethHS 10 years, 10 months ago

Return to YAHOO GROUPS HELP FILES

If you are using the new version of YG, please use Database in New YG instead

 

The Database in YG

 

The database function can be quite useful. For example:

 

  •  make a list of participants with all their important contact information
  •  post specific assignments using the table format
  • divide participants into working groups with tasks and deadlines for discussion, 
  • create a joint document with each paragraph a record and room to add comments
  • have participants register for the sessions with guest speakers. In that way, you can give the presenter an approximate number of participants

 

To start, go to the Database section using the navigation bar on the left of your YG frontpage (Figure 1):

 

Database_Fig1.jpg

Fig. 1. Navigation bar

 

 1. How do I create a table?

 

Yahoo! Groups provides templates that are great starting points, including a simple phone book, class assignments, and a FAQ table. To create a table:

 

a. Click on the Create table button, on the right.

b. Select the "empty" template to choose your own number of columns in the table, or choose one of the existing templates (see Fig. 2)

 

Database_Fig2.jpg

Fig. 2. Selecting a Template for the database

 

c. Fill out the required information for the table, including table information, policies, and columns.

d. Finish by clicking on Create Table at the bottom.

 

 At this point, you are ready to begin adding records to your table.

 

 Note: Each group can only have up to 10 tables. Each table can't exceed 1000 rows, or 10 columns.

 

 

 

 2. How do I add records to a table?

 

a.  Click on the name of the table you'd like to edit.

b. Click on the Add Record button (see Fig. 3).

 

Database_Fig3.jpg

Fig. 3. Adding a record to the database

 

c. Enter the data you wish to add.

d. Click on Add Record.

 

Alternately, you can choose to import a set of data all at once.

 

 

3. How do I import data into a table?

a. Go to your group's Database area.

b. Create a table, or click on the name of the table where you'd like to import data.

c. Click on the Edit link (see Fig. 3).

d. Click on the Import Data button (at the bottom of the page, see Fig. 4 below)

 

Datbase_Fig4.jpg

Fig. 4. Importing data from the database

 

e. At this point, you're ready to input your data into the empty data box presented, row by row. You'll need to select a delimiter (a way of separating one piece of information from the next) to separate information within each row (See Fig. 5).

 

Database_Fig5.jpg

Fig. 5. Box to input data.

 

f. Enter your data, row by row, depending upon how you set up your table. For example, if you set up a table with the following columns:

 

Name, Gender, Grade, Telephone Number

 

and then selected a semi-colon to be your delimiter, you would enter each row of data into the box like this:

 

James; male; 12; 555-1234

Kate; female; 10; 555-9876

 

Make sure to put a return after each row of information.

g. Before completing the import, Click on Preview Import to see how it looks. To finish, click on Import Data. If it doesn't look as you wish, you can always delete that particular database and start over.

 

 

 4. How do I export data from a table in the database?

 

a. Go to your group's Database area.

b. Click on the name of the table from which you'd like to export data.

c. Click on the Edit link.

d. Click on the Export Data button (see Fig. 4).

e. The data will be presented to you in a delimited set.

 

 

5. How do I print a table from the database?

 

a. Click on the name of the table you'd like to print. 

b. Then, click the Printable Report link. This will create a Web page with your table on it. 

c. Print this page using your browser's print command.

 

 

For more information about databases, visit the Yahoo! Groups Help area and search under Web Only Features of Groups.

 


 

  evo-training_logo.png   CALL_IS_logo.jpgEVO is a project of TESOL's CALL Interest Section

Revised by E. Hanson-Smith, September 2013

Revised and updated by Dafne González, June, 2005. Revised by E. Hanson-Smith, November 2009

Comments (0)

You don't have permission to comment on this page.