CSE Cranio Database

tenderlaΛογισμικό & κατασκευή λογ/κού

13 Δεκ 2013 (πριν από 3 χρόνια και 8 μήνες)

82 εμφανίσεις

CSE
Cranio

Database

What you need


Firefox



SQLite

Manager Extension

https://addons.mozilla.org/en
-
US/firefox/addon/sqlite
-
manager/



Database file and Templates for tables

/projects/cranio1/database/cranioDatabase.sqlite

/projects/cranio1/database/TableTemplates

Opening the manager in
F
irefox

Opening database

Database view

Table view
-

structure

Table view
-

contents

Table view


SQL query

Adding to a table (one item)

Importing new table

CSV view of table

Sometimes you get errors!


At that point the whole import fails, and you
have to fix the
csv

and try again

Adding to table (lots of items)


old version


Export
TABLE as
csv


Edit
csv

file to
add new entries


Drop
TABLE
from database


Import
TABLE
with old and
new data


Backup the database before
you do anything like this!!!

Adding to table (lots of items)


new version


I think this should work


Use
the empty
csv

table template in
the
TableTemplate

directory


Edit
csv

file to add
new entries


Import
TABLE with
new data (it should
append the new
data onto the old)


Backup the database before
you do anything like this!!!