https://neowiki.neooffice.org/index.php?title=Creating_a_Table_From_a_Spreadsheet&action=history&feed=atomCreating a Table From a Spreadsheet - Revision history2024-03-28T08:43:50ZRevision history for this page on the wikiMediaWiki 1.10.1https://neowiki.neooffice.org/index.php?title=Creating_a_Table_From_a_Spreadsheet&diff=17862&oldid=prevPluby: Update broken link2016-12-08T21:08:05Z<p>Update broken link</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 21:08, 8 December 2016</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{TBBA Header}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{TBBA Header}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">For the birding journal database, we need a table listing all of the birds we might see in our birding area. Creating a table from scratch would be tedious and time consuming. Fortunately, the data we need is already available if a format we can access and use. The [http://<del style="color: red; font-weight: bold; text-decoration: none;">www</del>.aou.org/<del style="color: red; font-weight: bold; text-decoration: none;">checklist/index.php3 </del>American Ornithologists' Union] provides their checklist of birds in the AOU area (North and Middle America) in an Excel file. This article describes how to get this data from the xls file into our Birding Journal database.</td><td>+</td><td style="background: #cfc; font-size: smaller;">For the birding journal database, we need a table listing all of the birds we might see in our birding area. Creating a table from scratch would be tedious and time consuming. Fortunately, the data we need is already available if a format we can access and use. The [http://<ins style="color: red; font-weight: bold; text-decoration: none;">checklist</ins>.aou.org/ American Ornithologists' Union] provides their checklist of birds in the AOU area (North and Middle America) in an Excel file. This article describes how to get this data from the xls file into our Birding Journal database.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Importing Spreadsheets vs. Connecting to Spreadsheets==</td><td> </td><td style="background: #eee; font-size: smaller;">==Importing Spreadsheets vs. Connecting to Spreadsheets==</td></tr>
</table>Plubyhttps://neowiki.neooffice.org/index.php?title=Creating_a_Table_From_a_Spreadsheet&diff=13634&oldid=prevLJ-Bettona: /* Importing the Data */ typo - add e to generally2008-03-29T10:49:25Z<p><span class="autocomment">Importing the Data -</span> typo - add e to generally</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 10:49, 29 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 48:</strong></td>
<td colspan="2" align="left"><strong>Line 48:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:The {{Window|Type Formatting}} window appears. Highlight each field in turn in the vertical column to the left, and adjust the {{prefName|Field Name}}, {{prefName|Field Type}}, {{prefName|Entry Required}}, and {{prefName|Length}} settings as needed.</td><td> </td><td style="background: #eee; font-size: smaller;">:The {{Window|Type Formatting}} window appears. Highlight each field in turn in the vertical column to the left, and adjust the {{prefName|Field Name}}, {{prefName|Field Type}}, {{prefName|Entry Required}}, and {{prefName|Length}} settings as needed.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">::In this table, all the fields are TEXT ''except'' for the ID field, whose field type should be INTEGER.</td><td> </td><td style="background: #eee; font-size: smaller;">::In this table, all the fields are TEXT ''except'' for the ID field, whose field type should be INTEGER.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">::Most of the Lengths are ok, although the Hawaii, Introduced, Accidental, and Nonbreeding could be reduced to a length of 5 or so, since the data in those columns is <del style="color: red; font-weight: bold; text-decoration: none;">genrally </del>only one character.</td><td>+</td><td style="background: #cfc; font-size: smaller;">::Most of the Lengths are ok, although the Hawaii, Introduced, Accidental, and Nonbreeding could be reduced to a length of 5 or so, since the data in those columns is <ins style="color: red; font-weight: bold; text-decoration: none;">generally </ins>only one character.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">::The ID and English Name fields should be marked for Entry Required.</td><td> </td><td style="background: #eee; font-size: smaller;">::The ID and English Name fields should be marked for Entry Required.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">::Right-click or control-click on the "ID" field name in the left hand column. Select {{Menu|Primary Key}} from the contextual menu (it is the only option.) A yellow key appears to the left of the field name.</td><td> </td><td style="background: #eee; font-size: smaller;">::Right-click or control-click on the "ID" field name in the left hand column. Select {{Menu|Primary Key}} from the contextual menu (it is the only option.) A yellow key appears to the left of the field name.</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Creating_a_Table_From_a_Spreadsheet&diff=13524&oldid=prevLJ-Bettona: /* Importing the Data */ consistency of table names2008-03-13T17:37:48Z<p><span class="autocomment">Importing the Data -</span> consistency of table names</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 17:37, 13 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 40:</strong></td>
<td colspan="2" align="left"><strong>Line 40:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:In the lower rectangular area, labeled {{Section|Tables}}, right-click or control-click in the white space. (If there is an existing table, make sure not to click on it).</td><td> </td><td style="background: #eee; font-size: smaller;">:In the lower rectangular area, labeled {{Section|Tables}}, right-click or control-click in the white space. (If there is an existing table, make sure not to click on it).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:In the contextual menu that comes up, choose {{Menu|Paste}}. The {{Window|Copy Table}} window appears.</td><td> </td><td style="background: #eee; font-size: smaller;">:In the contextual menu that comes up, choose {{Menu|Paste}}. The {{Window|Copy Table}} window appears.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:Give the table a name in the {{prefName|Table Name}} field; I chose <del style="color: red; font-weight: bold; text-decoration: none;">AOU Birdlist</del>.</td><td>+</td><td style="background: #cfc; font-size: smaller;">:Give the table a name in the {{prefName|Table Name}} field; I chose <ins style="color: red; font-weight: bold; text-decoration: none;">AOU_Birdlist</ins>.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Make sure the {{prefName|Definition and Data}} radio button is marked</td><td> </td><td style="background: #eee; font-size: smaller;">:Make sure the {{prefName|Definition and Data}} radio button is marked</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Because we added an ID field while prepping the spreadsheet, we want to leave the {{prefName|Create primary key}} checkbox ''unchecked.'' If you were importing data that did not already include a primary key field, you would want to check this box.</td><td> </td><td style="background: #eee; font-size: smaller;">:Because we added an ID field while prepping the spreadsheet, we want to leave the {{prefName|Create primary key}} checkbox ''unchecked.'' If you were importing data that did not already include a primary key field, you would want to check this box.</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Creating_a_Table_From_a_Spreadsheet&diff=13494&oldid=prevLJ-Bettona: /* Importing the Data */ typo2008-03-08T10:07:52Z<p><span class="autocomment">Importing the Data -</span> typo</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 10:07, 8 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 38:</strong></td>
<td colspan="2" align="left"><strong>Line 38:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Open the Birder's journal database</td><td> </td><td style="background: #eee; font-size: smaller;">:Open the Birder's journal database</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Click on the {{prefName|Tables}} icon in the {{Section|Database}} column on the right.</td><td> </td><td style="background: #eee; font-size: smaller;">:Click on the {{prefName|Tables}} icon in the {{Section|Database}} column on the right.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:In the lower rectangular area, <del style="color: red; font-weight: bold; text-decoration: none;">labled </del>{{Section|Tables}}, right-click or control-click in the white space. (If there is an existing table, make sure not to click on it).</td><td>+</td><td style="background: #cfc; font-size: smaller;">:In the lower rectangular area, <ins style="color: red; font-weight: bold; text-decoration: none;">labeled </ins>{{Section|Tables}}, right-click or control-click in the white space. (If there is an existing table, make sure not to click on it).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:In the contextual menu that comes up, choose {{Menu|Paste}}. The {{Window|Copy Table}} window appears.</td><td> </td><td style="background: #eee; font-size: smaller;">:In the contextual menu that comes up, choose {{Menu|Paste}}. The {{Window|Copy Table}} window appears.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:Give the table a name in the {{prefName|Table Name}} field; I chose AOU Birdlist.</td><td> </td><td style="background: #eee; font-size: smaller;">:Give the table a name in the {{prefName|Table Name}} field; I chose AOU Birdlist.</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Creating_a_Table_From_a_Spreadsheet&diff=12499&oldid=prevLorinda: /* Formatting the Spreadsheet */ Bird_ID to AOU_ID2007-10-31T01:56:05Z<p><span class="autocomment">Formatting the Spreadsheet -</span> Bird_ID to AOU_ID</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 01:56, 31 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 25:</strong></td>
<td colspan="2" align="left"><strong>Line 25:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*The order of the AOU checklist a standard order, used in birding books and checklists. To ensure that we can reproduce this order in the database, it would be wisest to add an ID field, with the first record given the number 1, the next 2, etc. To do so:</td><td> </td><td style="background: #eee; font-size: smaller;">*The order of the AOU checklist a standard order, used in birding books and checklists. To ensure that we can reproduce this order in the database, it would be wisest to add an ID field, with the first record given the number 1, the next 2, etc. To do so:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:*Insert a new column to the left of Column A (click on column A and then choose {{Menu|Columns}} from the {{Menu|Insert}} menu.</td><td> </td><td style="background: #eee; font-size: smaller;">:*Insert a new column to the left of Column A (click on column A and then choose {{Menu|Columns}} from the {{Menu|Insert}} menu.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:*Type <tt><del style="color: red; font-weight: bold; text-decoration: none;">Bird_ID</del></tt> into the cell in new column A just to the left of the cell labeled <tt>order</tt></td><td>+</td><td style="background: #cfc; font-size: smaller;">:*Type <tt><ins style="color: red; font-weight: bold; text-decoration: none;">AOU_ID</ins></tt> into the cell in new column A just to the left of the cell labeled <tt>order</tt></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:*Type a <tt>1</tt> into the first cell under <tt>ID</tt>:</td><td> </td><td style="background: #eee; font-size: smaller;">:*Type a <tt>1</tt> into the first cell under <tt>ID</tt>:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:*Follow the instructions on the [[Selecting and Filling a Cell Range]] wiki page to fill the column so that each cell contains a number one greater than the one above it. (i.e. 1, 2, 3, etc.)</td><td> </td><td style="background: #eee; font-size: smaller;">:*Follow the instructions on the [[Selecting and Filling a Cell Range]] wiki page to fill the column so that each cell contains a number one greater than the one above it. (i.e. 1, 2, 3, etc.)</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Creating_a_Table_From_a_Spreadsheet&diff=12192&oldid=prevLorinda: /* Formatting the Spreadsheet */ add step to remove spaces in field names2007-10-07T21:57:29Z<p><span class="autocomment">Formatting the Spreadsheet -</span> add step to remove spaces in field names</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 21:57, 7 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 13:</strong></td>
<td colspan="2" align="left"><strong>Line 13:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*The first row of the data range (not necessarily of the document) should contain the field names.</td><td> </td><td style="background: #eee; font-size: smaller;">*The first row of the data range (not necessarily of the document) should contain the field names.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">*Field names should not include spaces. Change the cell containing the text <tt>English Name</tt> to <tt>EnglishName</tt></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Any fields that must not be empty need to have data in them.</td><td> </td><td style="background: #eee; font-size: smaller;">*Any fields that must not be empty need to have data in them.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:In the case of the AOU list, a careful inspection will show that the Order, Family, Subfamily, and genus fields only contain data for the first record with that order, family, subfamily, or genus. In our database, this information needs to be in each record. To fix this:</td><td> </td><td style="background: #eee; font-size: smaller;">:In the case of the AOU list, a careful inspection will show that the Order, Family, Subfamily, and genus fields only contain data for the first record with that order, family, subfamily, or genus. In our database, this information needs to be in each record. To fix this:</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Creating_a_Table_From_a_Spreadsheet&diff=12187&oldid=prevLorinda: correct field name2007-10-07T21:27:11Z<p>correct field name</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 21:27, 7 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{TBBA Header}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{TBBA Header}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">For the birding journal database, we need a table listing all of the birds we might see in our birding area. Creating a table from scratch would be tedious and time consuming. Fortunately, the data we need is already available if a format we can access and use. The <del style="color: red; font-weight: bold; text-decoration: none;">{</del>http://www.aou.org/checklist/index.php3 American Ornithologists' Union<del style="color: red; font-weight: bold; text-decoration: none;">} </del>provides their checklist of birds in the AOU area (North and Middle America) in an Excel file. This article describes how to get this data from the xls file into our Birding Journal database.</td><td>+</td><td style="background: #cfc; font-size: smaller;">For the birding journal database, we need a table listing all of the birds we might see in our birding area. Creating a table from scratch would be tedious and time consuming. Fortunately, the data we need is already available if a format we can access and use. The <ins style="color: red; font-weight: bold; text-decoration: none;">[</ins>http://www.aou.org/checklist/index.php3 American Ornithologists' Union<ins style="color: red; font-weight: bold; text-decoration: none;">] </ins>provides their checklist of birds in the AOU area (North and Middle America) in an Excel file. This article describes how to get this data from the xls file into our Birding Journal database.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Importing Spreadsheets vs. Connecting to Spreadsheets==</td><td> </td><td style="background: #eee; font-size: smaller;">==Importing Spreadsheets vs. Connecting to Spreadsheets==</td></tr>
<tr><td colspan="2" align="left"><strong>Line 16:</strong></td>
<td colspan="2" align="left"><strong>Line 16:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:In the case of the AOU list, a careful inspection will show that the Order, Family, Subfamily, and genus fields only contain data for the first record with that order, family, subfamily, or genus. In our database, this information needs to be in each record. To fix this:</td><td> </td><td style="background: #eee; font-size: smaller;">:In the case of the AOU list, a careful inspection will show that the Order, Family, Subfamily, and genus fields only contain data for the first record with that order, family, subfamily, or genus. In our database, this information needs to be in each record. To fix this:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:*Click in a cell that contains an Order (or Family, etc.) name. The cell border becomes black, and a small back square is visible in the lower right hand corner of the cell.</td><td> </td><td style="background: #eee; font-size: smaller;">:*Click in a cell that contains an Order (or Family, etc.) name. The cell border becomes black, and a small back square is visible in the lower right hand corner of the cell.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:*Drag this square downward; as you do so, a red border drags with you. Keep dragging until the border encompasses all of the empty cells, up to but not including the next cell with text in it, then release the mouse button. The empty cells with the text content of the first cell.</td><td>+</td><td style="background: #cfc; font-size: smaller;">:*Drag this square downward; as you do so, a red border drags with you. Keep dragging until the border encompasses all of the empty cells, up to but not including the next cell with text in it, then release the mouse button. The empty cells <ins style="color: red; font-weight: bold; text-decoration: none;">fill </ins>with the text content of the first cell.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">:*Repeat this procedure until the empty fields are filled. (Note that in some cases, Subfamily will remain empty)</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Any rows with empty (null) cells in the English Name column must be deleted.</td><td> </td><td style="background: #eee; font-size: smaller;">*Any rows with empty (null) cells in the English Name column must be deleted.</td></tr>
<tr><td colspan="2" align="left"><strong>Line 23:</strong></td>
<td colspan="2" align="left"><strong>Line 24:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*The order of the AOU checklist a standard order, used in birding books and checklists. To ensure that we can reproduce this order in the database, it would be wisest to add an ID field, with the first record given the number 1, the next 2, etc. To do so:</td><td> </td><td style="background: #eee; font-size: smaller;">*The order of the AOU checklist a standard order, used in birding books and checklists. To ensure that we can reproduce this order in the database, it would be wisest to add an ID field, with the first record given the number 1, the next 2, etc. To do so:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:*Insert a new column to the left of Column A (click on column A and then choose {{Menu|Columns}} from the {{Menu|Insert}} menu.</td><td> </td><td style="background: #eee; font-size: smaller;">:*Insert a new column to the left of Column A (click on column A and then choose {{Menu|Columns}} from the {{Menu|Insert}} menu.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:*Type <tt><del style="color: red; font-weight: bold; text-decoration: none;">ID</del></tt> into the cell in new column A just to the left of the cell labeled <tt>order</tt></td><td>+</td><td style="background: #cfc; font-size: smaller;">:*Type <tt><ins style="color: red; font-weight: bold; text-decoration: none;">Bird_ID</ins></tt> into the cell in new column A just to the left of the cell labeled <tt>order</tt></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:*Type a <tt>1</tt> into the first cell under <tt>ID</tt>:</td><td> </td><td style="background: #eee; font-size: smaller;">:*Type a <tt>1</tt> into the first cell under <tt>ID</tt>:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:*Follow the instructions on the [[Selecting and Filling a Cell Range]] wiki page to fill the column so that each cell contains a number one greater than the one above it. (i.e. 1, 2, 3, etc.)</td><td> </td><td style="background: #eee; font-size: smaller;">:*Follow the instructions on the [[Selecting and Filling a Cell Range]] wiki page to fill the column so that each cell contains a number one greater than the one above it. (i.e. 1, 2, 3, etc.)</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Creating_a_Table_From_a_Spreadsheet&diff=12002&oldid=prevJgd: /* Importing the Data */ add space2007-09-17T08:34:06Z<p><span class="autocomment">Importing the Data -</span> add space</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 08:34, 17 September 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 51:</strong></td>
<td colspan="2" align="left"><strong>Line 51:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">::Once the fields are properly defined, click on {{Button|Create}}</td><td> </td><td style="background: #eee; font-size: smaller;">::Once the fields are properly defined, click on {{Button|Create}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">''Note: Make certain that all the field definitions are correct before clicking {{Button|Create}}. Attempting to change field types, lengths, etc. later will destroy data in those fields.''</td><td> </td><td style="background: #eee; font-size: smaller;">''Note: Make certain that all the field definitions are correct before clicking {{Button|Create}}. Attempting to change field types, lengths, etc. later will destroy data in those fields.''</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:If you forget to set the primary key, a {{Window|No primary key}} warning window will appear. You can click {{Button|Cancel}} and set the primary key as above, or you can click {{Button|No}}and identify the primary key in as follows:</td><td>+</td><td style="background: #cfc; font-size: smaller;">:If you forget to set the primary key, a {{Window|No primary key}} warning window will appear. You can click {{Button|Cancel}} and set the primary key as above, or you can click {{Button|No}} and identify the primary key in as follows:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">::Once the new table has appeared in the {{Section|Tables}} Section of the document window, right-click or control-click on the new table. Select {{Menu|Edit}} from the contextual menu. The table opens in design view.</td><td> </td><td style="background: #eee; font-size: smaller;">::Once the new table has appeared in the {{Section|Tables}} Section of the document window, right-click or control-click on the new table. Select {{Menu|Edit}} from the contextual menu. The table opens in design view.</td></tr>
</table>Jgdhttps://neowiki.neooffice.org/index.php?title=Creating_a_Table_From_a_Spreadsheet&diff=11996&oldid=prevLorinda: /* Importing the Data */ add "new" method for identifying primary key in import wizard2007-09-16T22:41:55Z<p><span class="autocomment">Importing the Data -</span> add "new" method for identifying primary key in import wizard</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 22:41, 16 September 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 48:</strong></td>
<td colspan="2" align="left"><strong>Line 48:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">::Most of the Lengths are ok, although the Hawaii, Introduced, Accidental, and Nonbreeding could be reduced to a length of 5 or so, since the data in those columns is genrally only one character.</td><td> </td><td style="background: #eee; font-size: smaller;">::Most of the Lengths are ok, although the Hawaii, Introduced, Accidental, and Nonbreeding could be reduced to a length of 5 or so, since the data in those columns is genrally only one character.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">::The ID and English Name fields should be marked for Entry Required.</td><td> </td><td style="background: #eee; font-size: smaller;">::The ID and English Name fields should be marked for Entry Required.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">::Right-click or control-click on the "ID" field name in the left hand column. Select {{Menu|Primary Key}} from the contextual menu (it is the only option.) A yellow key appears to the left of the field name.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">::Once the fields are properly defined, click on {{Button|Create}}</td><td> </td><td style="background: #eee; font-size: smaller;">::Once the fields are properly defined, click on {{Button|Create}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">''Note: Make certain that all the field definitions are correct before clicking {{Button|Create}}. Attempting to change field types, lengths, etc. later will destroy data in those fields.''</td><td> </td><td style="background: #eee; font-size: smaller;">''Note: Make certain that all the field definitions are correct before clicking {{Button|Create}}. Attempting to change field types, lengths, etc. later will destroy data in those fields.''</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:<del style="color: red; font-weight: bold; text-decoration: none;">A </del>{{Window|No primary key}} warning window will appear. <del style="color: red; font-weight: bold; text-decoration: none;">Click </del>{{Button|No}}<del style="color: red; font-weight: bold; text-decoration: none;">. We will </del>identify the primary key in <del style="color: red; font-weight: bold; text-decoration: none;">a moment.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;">:<ins style="color: red; font-weight: bold; text-decoration: none;">If you forget to set the primary key, a </ins>{{Window|No primary key}} warning window will appear. <ins style="color: red; font-weight: bold; text-decoration: none;">You can click {{Button|Cancel}} and set the primary key as above, or you can click </ins>{{Button|No}}<ins style="color: red; font-weight: bold; text-decoration: none;">and </ins>identify the primary key in <ins style="color: red; font-weight: bold; text-decoration: none;">as follows:</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">Once the new table has appeared in the {{Section|Tables}} Section of the document window, right-click or control-click on the new table. Select {{Menu|Edit}} from the contextual menu. The table opens in design view.</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">::</ins>Once the new table has appeared in the {{Section|Tables}} Section of the document window, right-click or control-click on the new table. Select {{Menu|Edit}} from the contextual menu. The table opens in design view.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:Click on the line containing the ID field. A green flippy triangle appears in the "cell" to the left of the word ID</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">:</ins>:Click on the line containing the ID field. A green flippy triangle appears in the "cell" to the left of the word ID</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:control-click or right-click on the green triangle and choose {{Menu|Primary Key}} from the contextual menu. A key icon appears in the box</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">:</ins>:control-click or right-click on the green triangle and choose {{Menu|Primary Key}} from the contextual menu. A key icon appears in the box</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:Click on the disk-drive icon in the toolbar to save your changes, then close the window.</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">:</ins>:Click on the disk-drive icon in the toolbar to save your changes, then close the window.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">You have successfully imported data from a spreadsheet.</td><td> </td><td style="background: #eee; font-size: smaller;">You have successfully imported data from a spreadsheet.</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Creating_a_Table_From_a_Spreadsheet&diff=11976&oldid=prevLorinda: /* Formatting the Spreadsheet */ correct <tt> tags2007-09-15T01:59:11Z<p><span class="autocomment">Formatting the Spreadsheet -</span> correct <tt> tags</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 01:59, 15 September 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 23:</strong></td>
<td colspan="2" align="left"><strong>Line 23:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*The order of the AOU checklist a standard order, used in birding books and checklists. To ensure that we can reproduce this order in the database, it would be wisest to add an ID field, with the first record given the number 1, the next 2, etc. To do so:</td><td> </td><td style="background: #eee; font-size: smaller;">*The order of the AOU checklist a standard order, used in birding books and checklists. To ensure that we can reproduce this order in the database, it would be wisest to add an ID field, with the first record given the number 1, the next 2, etc. To do so:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:*Insert a new column to the left of Column A (click on column A and then choose {{Menu|Columns}} from the {{Menu|Insert}} menu.</td><td> </td><td style="background: #eee; font-size: smaller;">:*Insert a new column to the left of Column A (click on column A and then choose {{Menu|Columns}} from the {{Menu|Insert}} menu.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:*Type <del style="color: red; font-weight: bold; text-decoration: none;"><</del><tt<del style="color: red; font-weight: bold; text-decoration: none;">></del>>ID<del style="color: red; font-weight: bold; text-decoration: none;"><</del></tt<del style="color: red; font-weight: bold; text-decoration: none;">></del>> into the cell in new column A just to the left of the cell labeled <del style="color: red; font-weight: bold; text-decoration: none;"><</del><tt<del style="color: red; font-weight: bold; text-decoration: none;">></del>>order<del style="color: red; font-weight: bold; text-decoration: none;"><</del></tt<del style="color: red; font-weight: bold; text-decoration: none;">></del>></td><td>+</td><td style="background: #cfc; font-size: smaller;">:*Type <tt>ID</tt> into the cell in new column A just to the left of the cell labeled <tt>order</tt></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:*Type a <del style="color: red; font-weight: bold; text-decoration: none;"><</del><tt<del style="color: red; font-weight: bold; text-decoration: none;">></del>>1<del style="color: red; font-weight: bold; text-decoration: none;"><</del></tt<del style="color: red; font-weight: bold; text-decoration: none;">></del>> into the first cell under <del style="color: red; font-weight: bold; text-decoration: none;"><</del><tt<del style="color: red; font-weight: bold; text-decoration: none;">></del>>ID<del style="color: red; font-weight: bold; text-decoration: none;"><</del></tt<del style="color: red; font-weight: bold; text-decoration: none;">></del>>:</td><td>+</td><td style="background: #cfc; font-size: smaller;">:*Type a <tt>1</tt> into the first cell under <tt>ID</tt>:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:*Follow the instructions on the [[Selecting and Filling a Cell Range]] wiki page to fill the column so that each cell contains a number one greater than the one above it. (i.e. 1, 2, 3, etc.)</td><td> </td><td style="background: #eee; font-size: smaller;">:*Follow the instructions on the [[Selecting and Filling a Cell Range]] wiki page to fill the column so that each cell contains a number one greater than the one above it. (i.e. 1, 2, 3, etc.)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
</table>Lorinda