×
If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html
creating the first database
- nexturejohn
- Topic Author
- Offline
Less
More
- Posts: 4
- Thank you received: 0
5 years 4 months ago #5238
by nexturejohn
creating the first database was created by nexturejohn
Hi, I have just downloaded JooDatabase, and in trying to create a database for the first time, your instructions say: "Add Menuentry - Add a JooDB-Catalog-view to your menus".
Can you please explain in simple steps what this means?
thanks
John
Can you please explain in simple steps what this means?
thanks
John
Please Log in to join the conversation.
- Dirk
-
- Offline
Less
More
- Posts: 1222
- Thank you received: 226
5 years 4 months ago #5240
by Dirk
Replied by Dirk on topic creating the first database
Joodb does not create database tables. Only if you import Excel spreadsheets .
It just displays tables and let you layout the catalog and single item view with a template engine.
Please take a look at the example database and add a menu entry (katalog view).
You can use this table #_joodb_sample and add fields using a tool like PHPMyadmin.
It just displays tables and let you layout the catalog and single item view with a template engine.
Please take a look at the example database and add a menu entry (katalog view).
You can use this table #_joodb_sample and add fields using a tool like PHPMyadmin.
The following user(s) said Thank You: nexturejohn
Please Log in to join the conversation.
- nexturejohn
- Topic Author
- Offline
Less
More
- Posts: 4
- Thank you received: 0
5 years 4 months ago #5241
by nexturejohn
Replied by nexturejohn on topic creating the first database
Is it possible to import other table structures into Joodb, and then visualise them? That is, ones that don't have the exact structure of the sample database you provided.
thanks
thanks
Please Log in to join the conversation.
- nexturejohn
- Topic Author
- Offline
Less
More
- Posts: 4
- Thank you received: 0
5 years 4 months ago #5250
by nexturejohn
Replied by nexturejohn on topic creating the first database
Can you tell me how I can display a simple table? The table is already in
the joomla database. In the example beow it has 10 rows. I wish to simply
display all the rows and columns.
When I look at your example database, I don't know what to change!
Also using that example it shows each row separately.
I just want to show the whole table! Can you tell me which parameters to set
to display this? It can't be difficult, but I really do not understand where
to start! Thanks!
DROP TABLE IF EXISTS `cs39_tbl_ASME`;
CREATE TABLE `cs39_tbl_ASME` (
`VOL` INTEGER NOT NULL,
`FOTO` TINYINT(1),
`PAG` INTEGER,
`POS` VARCHAR(50),
`TIPO` VARCHAR(50),
`CHIESA` VARCHAR(50),
`DA` INTEGER,
`A` INTEGER,
`NREC` INTEGER,
`NPAG` INTEGER,
`FOTOSTAT` VARCHAR(50),
`CONTEN` LONGTEXT
) ENGINE=myisam DEFAULT CHARSET=utf8;
SET autocommit=1;
#
# Dumping data for table 'tbl_ASME'
#
INSERT INTO `cs39_tbl_ASME` () VALUES (1, 0, 2, '1sup', 'Libro',
'S.Giuliano', 1695, 1720, NULL, NULL, NULL, 'Libro della venerabile
parrocchiale Chiesa di S. Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (2, 0, 2, '1sup', 'Admin',
'S.Giuliano', 1807, 1902, NULL, NULL, NULL, 'Atti vari relativi alla Chiesa
di S. Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (3, 0, 2, '1sup', 'Messe', 'S.Carlo',
1958, 1966, NULL, NULL, NULL, 'Registro di Messe - Istituto S. Carlo di
Erice');
INSERT INTO `cs39_tbl_ASME` () VALUES (4, 0, 2, '1sup', 'Messe', 'S.Carlo',
1951, 1956, NULL, NULL, NULL, 'Messe celebrate in S. Carlo di Erice');
INSERT INTO `cs39_tbl_ASME` () VALUES (5, 0, 2, '1sup', 'Admin', 'S.Carlo',
1872, 1897, NULL, NULL, NULL, 'Giornale di esito di S. Carlo');
INSERT INTO `cs39_tbl_ASME` () VALUES (6, 0, 2, '1sup', 'Libro',
'S.Giuliano', 1630, 1750, NULL, NULL, NULL, 'Intavolatura - Parrocchia di S.
Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (7, 0, 2, '1sup', 'Libro',
'S.Giuliano', 1722, 1771, NULL, NULL, NULL, 'Intavolatura - Parrocchia di S.
Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (8, 0, 2, '1sup', 'Admin',
'S.Giuliano', 1601, 1763, NULL, NULL, NULL, 'Atti di soggiogazione relativi
alla Parrocchia di S. Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (9, 0, 2, '1sup', 'Eredita\'',
'S.Giuliano', 1856, 1857, NULL, NULL, NULL, 'Amministrazione di eredita\'
diverse aggregate alla Chiesa di S.Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (10, 0, 2, '1sup', 'Admin',
'S.Giuliano', 1594, 1608, NULL, NULL, NULL, 'Libro di Introito ed esito
relativo alla Chiesa di S. Giuliano');
# 10 records
the joomla database. In the example beow it has 10 rows. I wish to simply
display all the rows and columns.
When I look at your example database, I don't know what to change!
Also using that example it shows each row separately.
I just want to show the whole table! Can you tell me which parameters to set
to display this? It can't be difficult, but I really do not understand where
to start! Thanks!
DROP TABLE IF EXISTS `cs39_tbl_ASME`;
CREATE TABLE `cs39_tbl_ASME` (
`VOL` INTEGER NOT NULL,
`FOTO` TINYINT(1),
`PAG` INTEGER,
`POS` VARCHAR(50),
`TIPO` VARCHAR(50),
`CHIESA` VARCHAR(50),
`DA` INTEGER,
`A` INTEGER,
`NREC` INTEGER,
`NPAG` INTEGER,
`FOTOSTAT` VARCHAR(50),
`CONTEN` LONGTEXT
) ENGINE=myisam DEFAULT CHARSET=utf8;
SET autocommit=1;
#
# Dumping data for table 'tbl_ASME'
#
INSERT INTO `cs39_tbl_ASME` () VALUES (1, 0, 2, '1sup', 'Libro',
'S.Giuliano', 1695, 1720, NULL, NULL, NULL, 'Libro della venerabile
parrocchiale Chiesa di S. Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (2, 0, 2, '1sup', 'Admin',
'S.Giuliano', 1807, 1902, NULL, NULL, NULL, 'Atti vari relativi alla Chiesa
di S. Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (3, 0, 2, '1sup', 'Messe', 'S.Carlo',
1958, 1966, NULL, NULL, NULL, 'Registro di Messe - Istituto S. Carlo di
Erice');
INSERT INTO `cs39_tbl_ASME` () VALUES (4, 0, 2, '1sup', 'Messe', 'S.Carlo',
1951, 1956, NULL, NULL, NULL, 'Messe celebrate in S. Carlo di Erice');
INSERT INTO `cs39_tbl_ASME` () VALUES (5, 0, 2, '1sup', 'Admin', 'S.Carlo',
1872, 1897, NULL, NULL, NULL, 'Giornale di esito di S. Carlo');
INSERT INTO `cs39_tbl_ASME` () VALUES (6, 0, 2, '1sup', 'Libro',
'S.Giuliano', 1630, 1750, NULL, NULL, NULL, 'Intavolatura - Parrocchia di S.
Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (7, 0, 2, '1sup', 'Libro',
'S.Giuliano', 1722, 1771, NULL, NULL, NULL, 'Intavolatura - Parrocchia di S.
Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (8, 0, 2, '1sup', 'Admin',
'S.Giuliano', 1601, 1763, NULL, NULL, NULL, 'Atti di soggiogazione relativi
alla Parrocchia di S. Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (9, 0, 2, '1sup', 'Eredita\'',
'S.Giuliano', 1856, 1857, NULL, NULL, NULL, 'Amministrazione di eredita\'
diverse aggregate alla Chiesa di S.Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (10, 0, 2, '1sup', 'Admin',
'S.Giuliano', 1594, 1608, NULL, NULL, NULL, 'Libro di Introito ed esito
relativo alla Chiesa di S. Giuliano');
# 10 records
Please Log in to join the conversation.
Moderators: Dirk, joest