Info on DBases...

[carolynwhite2]

OK, I went to Yah help, and found the following instructions. It 
sounds as though we could do some automation working from a text or 
excel file. I will try and do this tomorrow, too tired tonight.

If anyone wants to have a go before this, I am going to check that an 
up to date version of the categories list is in the files section in 
excel & word. Looks like the data in it will have to be reconfigured 
into new columns. Also should put all those zeroes in, as Kelly has 
just pointed out, to make things run in the correct order. Also 
should merge in the existing definitions text before uploading, so 
the thing happens in one go.

I will delete the DB just created with no data in them - looks like 
we should work with just one big table.

Carolyn



1. Go to your group's Database area. 

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

3. Click on the Edit link. 

4. Click on the Import Data button. 

5. 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. 

6.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. 

7.To finish, click on Import Data. 

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