Dobrý deň,
rád by som sa informoval o postupe zriadenia jednoduchej databázy výrobkov, to znamená, kód výrobku, názov, dodavateľ a samotný obrázok,
prečítal som si už niekoľko rôznych článkov a diskusií ale zatiaľ sa neviem pohnúť z miesta.
Mám k dispozícii tabuľku - zoznam výrobkov zo spomínanými stĺpcami a obrázky by som k nim prikladal už v samotnom base.
Aspoň ja si to takto predstavujem,
z žiadneho článku som sa ale nedozvedel, možno som to prehliadol, ako importovat data z Calcu hromadne do base keďže sa jedná o vyšší počet položiek.
Nieje mi ani jasné, ako dostať obrázok do base, to som skúšal spôsoby rôzne na ktoré som narazil pri hľadaní informácií na internete.
Som začiatočník v databázovom svete, neprogramujem,
privítam preto každú informáciu ktorá by mi pomohla v mojom pláne urobiť v obrázkoch poriadok,
vopred ďakujem za info,
MH
Databáza obrázkov v OOO
Re: Databáza obrázkov v OOO
1) vystup z CALCu
skus ulozit cely sheet/db ako CSV (comma separated values),
to sa da bezne importovat do MySQL, MS-SQL, Oracle ... takze predpokladam, ze import do konkretnej DB uz nebude problem
2) obrazky ... vo vseobecnosti problem
vacsinou sa to riesi tak, ze v DB je ulozeny string/nazov suboru s obrazkom a obrazok je fyzicky nakopirovany kdesi na serveri
na zaklade tohoto nazvu uz sa vysklada jeho ulozenie na serveri... takze ak pojde vystup do html/cohokolvek, ako zdroj obrazka sa pouziva subor zo servera ...
obrazky sa samozrejme tiez daju ulozit do databazy, ako rawData, ale potom pri nacitavani konkretneho obrazku vznika dost problemov
bez blizsej specifikacie databazy/tabuliek (cielovej) a zaroven zdrojoveho suboru s datami (mozu byt data typu A; B; 1; 2; 3.15; 20080412; C; D) sa radi velmi tazko...
skus ulozit cely sheet/db ako CSV (comma separated values),
to sa da bezne importovat do MySQL, MS-SQL, Oracle ... takze predpokladam, ze import do konkretnej DB uz nebude problem
2) obrazky ... vo vseobecnosti problem
vacsinou sa to riesi tak, ze v DB je ulozeny string/nazov suboru s obrazkom a obrazok je fyzicky nakopirovany kdesi na serveri
na zaklade tohoto nazvu uz sa vysklada jeho ulozenie na serveri... takze ak pojde vystup do html/cohokolvek, ako zdroj obrazka sa pouziva subor zo servera ...
obrazky sa samozrejme tiez daju ulozit do databazy, ako rawData, ale potom pri nacitavani konkretneho obrazku vznika dost problemov
bez blizsej specifikacie databazy/tabuliek (cielovej) a zaroven zdrojoveho suboru s datami (mozu byt data typu A; B; 1; 2; 3.15; 20080412; C; D) sa radi velmi tazko...
lava, prava, lava, prava ...
-
- Moderátor
- Príspevky: 15054
- Dátum registrácie: Ut 26. Feb, 2008, 14:00
- Bydlisko: Bratislava/Štúrovo
Re: Databáza obrázkov v OOO
Ved on to specifikoval. OpenOffice.org Base. Tj nieco ako Access.
Ale inac v helpe mas celkom dobre napisane ako dostat data z Calc-u do Base :
Importing data to Base
You can import text files, spreadsheet files, and your system address book in read-only mode only.
When you import from a text or spreadsheet file, the file must have a first row of header information. The second row of the file is the first valid data row. The format of every field in the second row determines the format for the entire column. Any format information from a spreadsheet file gets lost when importing to Base.
For example, to ensure the first column has a text format, you must make sure that the first field of the first valid data row contains text. If a field in the first valid data row contains a number, the whole column is set to number format, and only numbers, no text, will be shown in that column.
1.Open a Base file of the database type that you want.
Either create a new Base file using the Database Wizard, or open any existing Base file that is not read-only.
2.Open the Calc file that contains the data to be imported to Base. You can open a *.dbf dBASE file or many other file types.
3.Select the data to be copied to Base.
You can enter a range reference like A1:X500 in the Name Box if you don't want to scroll.
If you copy a dBASE sheet, include the top row that contains the header data.
4.Choose Edit - Copy.
5.In the Base window, click Tables to view the tables.
6.In the Base window, choose Edit - Paste.
7.You see the Copy Table dialog. Most databases need a primary key, so you may want to check the Create primary key box.
On Windows systems, you can also use drag-and-drop instead of Copy and Paste. Also, for registered databases, you can open the datasource browser (press F4) instead of opening the Base window.
Ale inac v helpe mas celkom dobre napisane ako dostat data z Calc-u do Base :
Importing data to Base
You can import text files, spreadsheet files, and your system address book in read-only mode only.
When you import from a text or spreadsheet file, the file must have a first row of header information. The second row of the file is the first valid data row. The format of every field in the second row determines the format for the entire column. Any format information from a spreadsheet file gets lost when importing to Base.
For example, to ensure the first column has a text format, you must make sure that the first field of the first valid data row contains text. If a field in the first valid data row contains a number, the whole column is set to number format, and only numbers, no text, will be shown in that column.
1.Open a Base file of the database type that you want.
Either create a new Base file using the Database Wizard, or open any existing Base file that is not read-only.
2.Open the Calc file that contains the data to be imported to Base. You can open a *.dbf dBASE file or many other file types.
3.Select the data to be copied to Base.
You can enter a range reference like A1:X500 in the Name Box if you don't want to scroll.
If you copy a dBASE sheet, include the top row that contains the header data.
4.Choose Edit - Copy.
5.In the Base window, click Tables to view the tables.
6.In the Base window, choose Edit - Paste.
7.You see the Copy Table dialog. Most databases need a primary key, so you may want to check the Create primary key box.
On Windows systems, you can also use drag-and-drop instead of Copy and Paste. Also, for registered databases, you can open the datasource browser (press F4) instead of opening the Base window.
Re: Databáza obrázkov v OOO
ja som sa zlakol, ze Calc 602 ...
co je z cias 286/386, dos app, a z tej by to fakt bol problem
uz som ticho ...
co je z cias 286/386, dos app, a z tej by to fakt bol problem
uz som ticho ...
lava, prava, lava, prava ...
-
- Moderátor
- Príspevky: 15054
- Dátum registrácie: Ut 26. Feb, 2008, 14:00
- Bydlisko: Bratislava/Štúrovo
Re: Databáza obrázkov v OOO
No ved pisal v titulku ze OOO, a OOO = OpenOffice.Org