mirror of https://github.com/nocodb/nocodb
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1 lines
19 KiB
1 lines
19 KiB
"use strict";(self.webpackChunknoco_docs=self.webpackChunknoco_docs||[]).push([[6157],{3905:(e,t,a)=>{a.d(t,{Zo:()=>d,kt:()=>b});var n=a(67294);function i(e,t,a){return t in e?Object.defineProperty(e,t,{value:a,enumerable:!0,configurable:!0,writable:!0}):e[t]=a,e}function l(e,t){var a=Object.keys(e);if(Object.getOwnPropertySymbols){var n=Object.getOwnPropertySymbols(e);t&&(n=n.filter((function(t){return Object.getOwnPropertyDescriptor(e,t).enumerable}))),a.push.apply(a,n)}return a}function o(e){for(var t=1;t<arguments.length;t++){var a=null!=arguments[t]?arguments[t]:{};t%2?l(Object(a),!0).forEach((function(t){i(e,t,a[t])})):Object.getOwnPropertyDescriptors?Object.defineProperties(e,Object.getOwnPropertyDescriptors(a)):l(Object(a)).forEach((function(t){Object.defineProperty(e,t,Object.getOwnPropertyDescriptor(a,t))}))}return e}function r(e,t){if(null==e)return{};var a,n,i=function(e,t){if(null==e)return{};var a,n,i={},l=Object.keys(e);for(n=0;n<l.length;n++)a=l[n],t.indexOf(a)>=0||(i[a]=e[a]);return i}(e,t);if(Object.getOwnPropertySymbols){var l=Object.getOwnPropertySymbols(e);for(n=0;n<l.length;n++)a=l[n],t.indexOf(a)>=0||Object.prototype.propertyIsEnumerable.call(e,a)&&(i[a]=e[a])}return i}var s=n.createContext({}),c=function(e){var t=n.useContext(s),a=t;return e&&(a="function"==typeof e?e(t):o(o({},t),e)),a},d=function(e){var t=c(e.components);return n.createElement(s.Provider,{value:t},e.children)},p="mdxType",u={inlineCode:"code",wrapper:function(e){var t=e.children;return n.createElement(n.Fragment,{},t)}},m=n.forwardRef((function(e,t){var a=e.components,i=e.mdxType,l=e.originalType,s=e.parentName,d=r(e,["components","mdxType","originalType","parentName"]),p=c(a),m=i,b=p["".concat(s,".").concat(m)]||p[m]||u[m]||l;return a?n.createElement(b,o(o({ref:t},d),{},{components:a})):n.createElement(b,o({ref:t},d))}));function b(e,t){var a=arguments,i=t&&t.mdxType;if("string"==typeof e||i){var l=a.length,o=new Array(l);o[0]=m;var r={};for(var s in t)hasOwnProperty.call(t,s)&&(r[s]=t[s]);r.originalType=e,r[p]="string"==typeof e?e:i,o[1]=r;for(var c=2;c<l;c++)o[c]=a[c];return n.createElement.apply(null,o)}return n.createElement.apply(null,a)}m.displayName="MDXCreateElement"},32934:(e,t,a)=>{a.r(t),a.d(t,{assets:()=>s,contentTitle:()=>o,default:()=>u,frontMatter:()=>l,metadata:()=>r,toc:()=>c});var n=a(87462),i=(a(67294),a(3905));const l={title:"Table Operations",description:"Table Operations: Row, Column, Quick Import, Export & Import"},o=void 0,r={unversionedId:"setup-and-usages/table-operations",id:"version-0.109.7/setup-and-usages/table-operations",title:"Table Operations",description:"Table Operations: Row, Column, Quick Import, Export & Import",source:"@site/versioned_docs/version-0.109.7/030.setup-and-usages/020.table-operations.md",sourceDirName:"030.setup-and-usages",slug:"/setup-and-usages/table-operations",permalink:"/0.109.7/setup-and-usages/table-operations",draft:!1,editUrl:"https://github.com/nocodb/nocodb/tree/develop/packages/noco-docs/docs/versioned_docs/version-0.109.7/030.setup-and-usages/020.table-operations.md",tags:[],version:"0.109.7",sidebarPosition:20,frontMatter:{title:"Table Operations",description:"Table Operations: Row, Column, Quick Import, Export & Import"},sidebar:"tutorialSidebar",previous:{title:"Dashboard",permalink:"/0.109.7/setup-and-usages/dashboard"},next:{title:"Column Operations",permalink:"/0.109.7/setup-and-usages/column-operations"}},s={},c=[{value:"Table",id:"table",level:2},{value:"Table Create",id:"table-create",level:3},{value:"Table Rename",id:"table-rename",level:3},{value:"Table Delete",id:"table-delete",level:3},{value:"Column",id:"column",level:2},{value:"Column Add",id:"column-add",level:3},{value:"Column Edit",id:"column-edit",level:3},{value:"Column Delete",id:"column-delete",level:3},{value:"Row",id:"row",level:2},{value:"Row Add (Using Form)",id:"row-add-using-form",level:3},{value:"Row Add (Using Table Row at bottom of page)",id:"row-add-using-table-row-at-bottom-of-page",level:3},{value:"Row Add (Pressing Enter Key from Previous Row)",id:"row-add-pressing-enter-key-from-previous-row",level:3},{value:"Row Edit",id:"row-edit",level:3},{value:"Row Delete",id:"row-delete",level:3},{value:"Quick Import",id:"quick-import",level:2},{value:"Import Airtable into an Existing Project",id:"import-airtable-into-an-existing-project",level:3},{value:"Import CSV data into an Existing Project",id:"import-csv-data-into-an-existing-project",level:3},{value:"Import Excel data into an Existing Project",id:"import-excel-data-into-an-existing-project",level:3},{value:"Export Data",id:"export-data",level:2},{value:"Import Data",id:"import-data",level:2}],d={toc:c},p="wrapper";function u(e){let{components:t,...a}=e;return(0,i.kt)(p,(0,n.Z)({},d,a,{components:t,mdxType:"MDXLayout"}),(0,i.kt)("p",null,"Once you have created a new NocoDB project you can open it, In the browser, the URL would be like ",(0,i.kt)("inlineCode",{parentName:"p"},"example.com/#/default/<project_id>"),"."),(0,i.kt)("h2",{id:"table"},"Table"),(0,i.kt)("h3",{id:"table-create"},"Table Create"),(0,i.kt)("p",null,"On project dashboard, click on ",(0,i.kt)("inlineCode",{parentName:"p"},"Add new table")," button"),(0,i.kt)("p",null,(0,i.kt)("img",{parentName:"p",src:"https://github.com/nocodb/nocodb/assets/86527202/0b1d0b89-b3c6-4c3c-8208-4b6afce67d23",alt:"table-create-button"})),(0,i.kt)("p",null,"Provide a name for the table & click ",(0,i.kt)("inlineCode",{parentName:"p"},"Create Table")," button."),(0,i.kt)("p",null,(0,i.kt)("img",{parentName:"p",src:"https://github.com/nocodb/nocodb/assets/86527202/fceb6c48-e0d6-428c-bb16-d2da4e38a81f",alt:"table-create-modal"})),(0,i.kt)("p",null,"After the successful submission, the table will be created and open on a new grid. "),(0,i.kt)("img",{width:"1504",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795081-f41ebd4d-7fa9-4f65-a66f-3d2375925106.png"}),(0,i.kt)("h3",{id:"table-rename"},"Table Rename"),(0,i.kt)("p",null,"Right click on Table name on left hand project-tree menu, select ",(0,i.kt)("inlineCode",{parentName:"p"},"Rename")),(0,i.kt)("img",{width:"606",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795096-82b007fb-f57a-4141-938e-be502b1fb2cd.png"}),(0,i.kt)("p",null,"In modal popup, enter new table name and click ",(0,i.kt)("inlineCode",{parentName:"p"},"Submit")," button"),(0,i.kt)("img",{width:"1506",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795119-4aeb05e1-16d5-4b4f-bf6c-81752234d946.png"}),(0,i.kt)("h3",{id:"table-delete"},"Table Delete"),(0,i.kt)("p",null,"Right click on Table name on left hand project-tree menu, select ",(0,i.kt)("inlineCode",{parentName:"p"},"Delete")),(0,i.kt)("img",{width:"641",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795140-4fe71896-0802-45dd-9c93-64e51925be57.png"}),(0,i.kt)("p",null,"Click Yes to confirm the table deletion"),(0,i.kt)("img",{width:"1507",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795152-9bdbf8df-846e-42f3-89d0-c68bce022cc1.png"}),(0,i.kt)("h2",{id:"column"},"Column"),(0,i.kt)("h3",{id:"column-add"},"Column Add"),(0,i.kt)("p",null,"Click the ",(0,i.kt)("inlineCode",{parentName:"p"},"+")," icon on the right corner of the table."),(0,i.kt)("img",{width:"352",alt:"image",src:"https://user-images.githubusercontent.com/35857179/189053971-a3d29b3b-1177-49fe-8178-8868528fe3e7.png"}),(0,i.kt)("p",null,"After the click, it will show a menu and you can enter the column name and choose the column type. (See ",(0,i.kt)("a",{parentName:"p",href:"./column-types"},"Column Types")," for the full list)."),(0,i.kt)("img",{width:"459",alt:"image",src:"https://user-images.githubusercontent.com/35857179/189073266-a0f19e2e-5dd2-4343-8c74-4ef709da272c.png"}),(0,i.kt)("p",null,"You can also click ",(0,i.kt)("inlineCode",{parentName:"p"},"Show more")," for additional menu options."),(0,i.kt)("p",null,(0,i.kt)("img",{parentName:"p",src:"https://user-images.githubusercontent.com/86527202/222749857-0e793db2-a5d2-4b54-8d23-2a0cbbec8f5d.png",alt:"Screenshot 2023-03-03 at 8 13 07 PM"})),(0,i.kt)("p",null,"Click ",(0,i.kt)("inlineCode",{parentName:"p"},"Save")," button to create the new column. "),(0,i.kt)("img",{width:"1509",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795274-08483315-5538-4685-8c08-261a9c2dfe14.png"}),(0,i.kt)("h3",{id:"column-edit"},"Column Edit"),(0,i.kt)("p",null,"To edit column properties, click the down arrow, select ",(0,i.kt)("inlineCode",{parentName:"p"},"Edit")," from the menu. "),(0,i.kt)("img",{width:"230",alt:"image",src:"https://user-images.githubusercontent.com/35857179/189077129-dfb7a815-3fc7-41ea-b72c-e57f3c30a7f4.png"}),"You will be able to edit column name & associated datatype using pop-up modal. You can also click `Show more` for additional menu options.",(0,i.kt)("img",{width:"497",alt:"image",src:"https://user-images.githubusercontent.com/35857179/189077270-7acdc818-3747-4307-93fb-e970cb7936f9.png"}),(0,i.kt)("p",null,"Prior to v0.104.3, Advanced menu by default displayed developer specific database configuration options. To avoid unintended tweaks from user, these are now hidden under an easter egg menu. To enable, double click on ",(0,i.kt)("inlineCode",{parentName:"p"},"show all"),"/",(0,i.kt)("inlineCode",{parentName:"p"},"hide all")," button in column edit modal."),(0,i.kt)("p",null,(0,i.kt)("img",{parentName:"p",src:"https://user-images.githubusercontent.com/86527202/223024810-85dac1c6-87ef-4193-90cb-3a05be8ccc1d.png",alt:"Screenshot 2023-03-06 at 10 45 26 AM"})),(0,i.kt)("h3",{id:"column-delete"},"Column Delete"),(0,i.kt)("p",null,"To delete a column, click the down arrow, select ",(0,i.kt)("inlineCode",{parentName:"p"},"Delete")," from the menu. "),(0,i.kt)("img",{width:"256",alt:"image",src:"https://user-images.githubusercontent.com/35857179/189077566-c9376e4e-9ee8-4ffa-b437-1240894a30cd.png"}),(0,i.kt)("p",null,"Click ",(0,i.kt)("inlineCode",{parentName:"p"},"Yes")," to confirm the column deletion. "),(0,i.kt)("img",{width:"1507",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795311-c2a5587e-d92f-4b88-a8a3-e20ac13c694b.png"}),(0,i.kt)("h2",{id:"row"},"Row"),(0,i.kt)("p",null,"For adding new values to the table we need new rows, new rows can be added in two methods."),(0,i.kt)("h3",{id:"row-add-using-form"},"Row Add (Using Form)"),(0,i.kt)("ul",null,(0,i.kt)("li",{parentName:"ul"},"Click the ",(0,i.kt)("inlineCode",{parentName:"li"},"+")," icon in the toolbar of the table tab. ",(0,i.kt)("img",{width:"1038",alt:"image",src:"https://user-images.githubusercontent.com/35857179/189079143-8f3e3dd6-9b62-4fb0-9a78-a57545026d11.png"})),(0,i.kt)("li",{parentName:"ul"},"Then you can enter the values and click ",(0,i.kt)("inlineCode",{parentName:"li"},"Save row"),". ",(0,i.kt)("img",{width:"1506",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795353-2d90316f-a5e4-41af-8931-20b3c6ed08dc.png"})),(0,i.kt)("li",{parentName:"ul"},"After saving it will be there on your table. ",(0,i.kt)("img",{width:"620",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795402-d7c26ced-a009-43d9-a4a4-e3c2653225f0.png"}))),(0,i.kt)("h3",{id:"row-add-using-table-row-at-bottom-of-page"},"Row Add (Using Table Row at bottom of page)"),(0,i.kt)("ul",null,(0,i.kt)("li",{parentName:"ul"},"Click the bottom row of the table ",(0,i.kt)("inlineCode",{parentName:"li"},"+ Add new row"),".",(0,i.kt)("img",{width:"545",alt:"image",src:"https://user-images.githubusercontent.com/35857179/189079815-9a7ea5e3-4eb7-452e-99a8-78c271f2ad1f.png"})),(0,i.kt)("li",{parentName:"ul"},"A new empty row will be created",(0,i.kt)("img",{width:"567",alt:"image",src:"https://user-images.githubusercontent.com/35857179/189080009-3aeb70b4-92b0-4702-acb9-e5e52e31855e.png"}))),(0,i.kt)("h3",{id:"row-add-pressing-enter-key-from-previous-row"},"Row Add (Pressing Enter Key from Previous Row)"),(0,i.kt)("p",null,"When you finish editing a cell and press Enter, the cell in the next row with the same column will be highlighted."),(0,i.kt)("p",null,(0,i.kt)("img",{parentName:"p",src:"https://user-images.githubusercontent.com/35857179/203271676-bab64ca4-e0e4-4deb-9a62-609a97158911.png",alt:"image"})),(0,i.kt)("h3",{id:"row-edit"},"Row Edit"),(0,i.kt)("p",null,"You can start editing by any of the following methods "),(0,i.kt)("ul",null,(0,i.kt)("li",{parentName:"ul"},"Double click on cell to edit "),(0,i.kt)("li",{parentName:"ul"},"Click on cell and start typing (this way it will clear the previous content) "),(0,i.kt)("li",{parentName:"ul"},"Click on cell and press enter to start editing"),(0,i.kt)("li",{parentName:"ul"},"And it will automatically save on blur event or if inactive. ")),(0,i.kt)("h3",{id:"row-delete"},"Row Delete"),(0,i.kt)("p",null,"Right-click on anywhere in the row and then from the context menu select ",(0,i.kt)("inlineCode",{parentName:"p"},"Delete Row")," option. "),(0,i.kt)("p",null,"Bulk delete is also possible by selecting multiple rows by using the checkbox in first column and then ",(0,i.kt)("inlineCode",{parentName:"p"},"Delete Selected Rows")," options from the right click context menu."),(0,i.kt)("img",{width:"568",alt:"image",src:"https://user-images.githubusercontent.com/35857179/189081764-9f13c286-e02a-40d0-93ea-4b1362d96827.png"}),(0,i.kt)("h2",{id:"quick-import"},"Quick Import"),(0,i.kt)("p",null,"You can use Quick Import when you have data from external sources such as Airtable, CSV file or Microsoft Excel to an existing project by either "),(0,i.kt)("ul",null,(0,i.kt)("li",{parentName:"ul"},"Hover ",(0,i.kt)("inlineCode",{parentName:"li"},"Add new table")," button in table menu, click three dots, use Quick Import to create"),(0,i.kt)("li",{parentName:"ul"},"Drag and drop CSV, JSON or Excel file to import")),(0,i.kt)("img",{width:"1505",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795025-afd81191-4743-435b-b802-88367d2663f9.png"}),(0,i.kt)("h3",{id:"import-airtable-into-an-existing-project"},"Import Airtable into an Existing Project"),(0,i.kt)("ul",null,(0,i.kt)("li",{parentName:"ul"},"See ",(0,i.kt)("a",{parentName:"li",href:"/0.109.7/setup-and-usages/import-airtable-to-sql-database-within-a-minute-for-free"},"here"))),(0,i.kt)("h3",{id:"import-csv-data-into-an-existing-project"},"Import CSV data into an Existing Project"),(0,i.kt)("ul",null,(0,i.kt)("li",{parentName:"ul"},"Hover ",(0,i.kt)("inlineCode",{parentName:"li"},"Add new table")," button in table menu, click three dots, and click ",(0,i.kt)("inlineCode",{parentName:"li"},"CSV file")),(0,i.kt)("li",{parentName:"ul"},"Drag & drop or select files (at most 5 files) to upload or specify CSV file URL, and Click Import",(0,i.kt)("ul",{parentName:"li"},(0,i.kt)("li",{parentName:"ul"},(0,i.kt)("strong",{parentName:"li"},"Auto-Select Field Types"),": If it is checked, column types will be detected. Otherwise, it will default to ",(0,i.kt)("inlineCode",{parentName:"li"},"SingleLineText"),"."),(0,i.kt)("li",{parentName:"ul"},(0,i.kt)("strong",{parentName:"li"},"Use First Row as Headers"),": If it is checked, the first row will be treated as header row."),(0,i.kt)("li",{parentName:"ul"},(0,i.kt)("strong",{parentName:"li"},"Import Data"),": If it is checked, all data will be imported. Otherwise, only table will be created.\n",(0,i.kt)("img",{parentName:"li",src:"https://user-images.githubusercontent.com/35857179/197454479-1ed18dce-1d0b-4ee3-88b3-9b6a132dea2a.png",alt:"image"})))),(0,i.kt)("li",{parentName:"ul"},"You can revise the table name by double-clicking it, column name and column type. By default, the first column will be chosen as ",(0,i.kt)("a",{href:"/0.109.7/setup-and-usages/display-value",target:"_blank"},"Display Value")," and cannot be deleted.\n",(0,i.kt)("img",{parentName:"li",src:"https://user-images.githubusercontent.com/35857179/197454633-5b30323e-2b13-4c55-843a-948c093d373e.png",alt:"image"})),(0,i.kt)("li",{parentName:"ul"},"Click ",(0,i.kt)("inlineCode",{parentName:"li"},"Import")," to start importing process. The table will be created and the data will be imported.\n",(0,i.kt)("img",{parentName:"li",src:"https://user-images.githubusercontent.com/35857179/197455547-2d93df5e-a7f0-4c88-af53-990067625967.png",alt:"image"}))),(0,i.kt)("h3",{id:"import-excel-data-into-an-existing-project"},"Import Excel data into an Existing Project"),(0,i.kt)("ul",null,(0,i.kt)("li",{parentName:"ul"},"Hover ",(0,i.kt)("inlineCode",{parentName:"li"},"Add new table")," button in table menu, click three dots, and click ",(0,i.kt)("inlineCode",{parentName:"li"},"Microsoft Excel")),(0,i.kt)("li",{parentName:"ul"},"Drag & drop or select file (at most 1 file) to upload or specify Excel file URL and Click Import.",(0,i.kt)("ul",{parentName:"li"},(0,i.kt)("li",{parentName:"ul"},(0,i.kt)("strong",{parentName:"li"},"Auto-Select Field Types"),": If it is checked, column types will be detected. Otherwise, it will default to ",(0,i.kt)("inlineCode",{parentName:"li"},"SingleLineText"),"."),(0,i.kt)("li",{parentName:"ul"},(0,i.kt)("strong",{parentName:"li"},"Use First Row as Headers"),": If it is checked, the first row will be treated as header row."),(0,i.kt)("li",{parentName:"ul"},(0,i.kt)("strong",{parentName:"li"},"Import Data"),": If it is checked, all data will be imported. Otherwise, only table will be created.\n",(0,i.kt)("img",{parentName:"li",src:"https://user-images.githubusercontent.com/35857179/197455788-8dd8a7d1-38f3-48c3-a05e-6ab0cf25045c.png",alt:"image"})))),(0,i.kt)("li",{parentName:"ul"},"You can revise the table name, column name and column type. By default, the first column will be chosen as ",(0,i.kt)("a",{href:"/0.109.7/setup-and-usages/display-value",target:"_blank"},"Display Value")," and cannot be deleted.")),(0,i.kt)("admonition",{type:"note"},(0,i.kt)("p",{parentName:"admonition"},"If your Excel file contains multiple sheets, each sheet will be stored in a separate table.")),(0,i.kt)("img",{width:"1449",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795771-77963196-8e10-4f45-b605-eb1089d6bc9b.png"}),(0,i.kt)("ul",null,(0,i.kt)("li",{parentName:"ul"},(0,i.kt)("p",{parentName:"li"},"Click ",(0,i.kt)("inlineCode",{parentName:"p"},"Import")," to start importing process. The table(s) will be created and the data will be imported to the corresponding table(s)."),(0,i.kt)("img",{width:"1508",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795789-80366467-9778-464b-bce0-a5c0dfe97522.png"}))),(0,i.kt)("h2",{id:"export-data"},"Export Data"),(0,i.kt)("p",null,"You can export your data from a table as a CSV file by clicking the down arrow next to Table name and hover on ",(0,i.kt)("inlineCode",{parentName:"p"},"Download"),". Currently only CSV and XLSX formats are supported for export."),(0,i.kt)("img",{width:"660",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795866-a2db2a9b-d8e3-43f2-aec5-085e1932a0a5.png"}),(0,i.kt)("h2",{id:"import-data"},"Import Data"),(0,i.kt)("p",null,"You can import your data in CSV format to a table by clicking the down arrow next to Table name and hover on ",(0,i.kt)("inlineCode",{parentName:"p"},"Upload"),". Currently only CSV format is supported for upload."),(0,i.kt)("img",{width:"668",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194795880-60bf2003-0bef-45cd-aafa-1b97adb75d42.png"}))}u.isMDXComponent=!0}}]); |