Creating a Database Project from an Excel file

Easily convert your excel sheet into an online database application using AppGini ( https://bigprof.com/appgini ).

00:07 If you are currently using an excel sheet to collect your data, you can turn it into a database application with a few simple steps.

00:15 This tutorial shows how to convert an excel sheet into an online database application.

00:25 This is our excel sheet.

00:31 All you need to do is save it as “CSV” format.

00:49 Then we’ll start a new AppGini project.

00:52 Go to the “File” menu, and choose “import” then “Table from CSV file”.

01:03 Once you open your CSV file, a pop up window will appear on the right side of the screen, listing some actions you might need to make use of.

01:14 First, we need to add a primary key field, or set one of the fields as a primary key. In our case we’ll set the “ID” Field to “Primary key”.

01:28 As AppGini sets the default data type to “VarChar” of length 255 for all fields [Silence], you might need to change those settings according to your requirements.

01:40 In this example we’ll leave the “Country” field set as “VarChar” and change all other fields to “integer”.

02:04 Finally, set any other fields and table properties as necessary. We’ll set an icon to our table, click “Done” and generate.

02:21 Click “Done”

02:26 And generate

02:40 Now we’ll navigate to our browser.

02:56 Fill in the setup form

03:18 And click “Import existing data into your application from a CSV file”.

03:26 This takes you directly to the admin area, where you should browse your file.

03:33 After uploading your file, you might need to review the advanced options and set them according to your needs.

03:43 By clicking “Preview CSV data”, we can see how our table would display.

03:51 Let’s click “Confirm and import CSV data”,

03:59 Assign an owner to the imported records,

04:05 And we’re done.

04:06 We’ll go back to the “User’s area” [Silence], open the table [Silence], and here you go! The table is populated with the CSV file data.

04:21 To add a new record, you can simply scroll down and fill in the fields.

04:33 To get to know more about AppGini, please visit our homepage for more video tours.

Видео Creating a Database Project from an Excel file канала AppGini -- Web applications in minutes!