Puppy Database

Under development: PCMCIA, wireless, etc.
Message
Author
musher0
Posts: 14629
Joined: Mon 05 Jan 2009, 00:54
Location: Gatineau (Qc), Canada

#196 Post by musher0 »

:)
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)

Pelo

I still consider OSMO as a DataBase

#197 Post by Pelo »

I still consider OSMO as a DataBase, you just have to change colums names in file .mo
Export to csv format, your data can be imported by all the systems (including Dbase).
What people omit to say, we are speaking of DATABASE .... management
A table is like a spreadsheet.
MS Access, for instance, pick up some colums in several database to make a report, one column must be common.
By experience i can tell you that when you must create the report form, 90% of MS access lovers change their opinion. Too much work. for an ugly result.

I have been working for six years with Dbase II for managing seals, unions, and others peanuts allocated in 250 line stations in the world. If i Tell you Osmo can do it, believe me :!:
OSMO only miss a column in tasks common with contacts
Who is in charge of task ?
Linux makes no difference if contact is an human, an object or a speedy Puppy Linux (without Libre Office to trail)
350 USD is cheap, isn't it ? :)
Attachments
ChimpBox.png
I have the version with correct titles
(66.55 KiB) Downloaded 422 times

Pelo

Kexi is as small as a Puppy.

#198 Post by Pelo »

Kexi will import the csv files created by Osmo without trouble. That is Nice, only with existing applications in Puppy Linux (KDE 1.6.3 is only 47MB )
Demo done with an european Puppy (Hungarian, zone €uro)
Attachments
kexi.jpg
Kexi is as small as a Puppy.
(74.61 KiB) Downloaded 414 times

Pelo

Last step of the process : import and rename columns

#199 Post by Pelo »

Last step of the process : import and rename columns. Pelo makes life easy for his office staff (women at 90%). What a Boss :!:
Attachments
Ordinateurs.jpg
Easy as Puppy.
(70.85 KiB) Downloaded 412 times

Pelo

Rename the columns

#200 Post by Pelo »

Rename the columns (caution save your data, because structure change will erase them) . reimport data when 'birthday' has been changed to 'Acquired on'
Attachments
Structure.jpg
Users practice improves applications quality. Never used means useless.
(46.17 KiB) Downloaded 427 times

User avatar
Pete
Posts: 660
Joined: Sun 02 Mar 2014, 18:36

#201 Post by Pete »

Sorry to revive such an old thread but was looking for a super simple database and landed up here.

Amazing how often it's the simple, easy things in life that make the most difference and fields.awk is one of those.
It suits my needs perfectly.

Thank you musher0 for posting about it and of course thanks to Ian R. Forsyth for writing it.

musher0
Posts: 14629
Joined: Mon 05 Jan 2009, 00:54
Location: Gatineau (Qc), Canada

#202 Post by musher0 »

Pete wrote:Sorry to revive such an old thread but was looking for a super simple database and landed up here.

Amazing how often it's the simple, easy things in life that make the most difference and fields.awk is one of those.
It suits my needs perfectly.

Thank you musher0 for posting about it and of course thanks to Ian R. Forsyth for writing it.
My pleasure! :)
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)

User avatar
Pete
Posts: 660
Joined: Sun 02 Mar 2014, 18:36

#203 Post by Pete »

BTW, the files produced by fields.awk are 99% compatible with Gnumeric.
By 99% I mean that if one leaves the "::" between fields, Gnumeric inserts the data on every second column.

Easy fix, make a copy of the database file, and replace all "::" with a single ":"

Now can import the file into Gnumeric (just select all files not database files)
and generate stats or even graphs.

The "@@@" at the beginning does not seem to bother Gnumeric at all.

It also occurred to me that field.awk is a perfect lightweight DB for small computers like the Rasp PI.
However be aware of this:

https://www.raspberrypi.org/forums/view ... 7&p=178094

The post is from 2012, so don't know if it still applies and don't have a PI (thinking of getting one) so can't test.

If anyone here has a PI and is willing to test and report back, that would be great.

Example file (with "::" removed):

Code: Select all

@@@Param1:Param2:Param3:Param4:
11:22:44:33:
12:24:46:38:
14:24:44:34:
11:22:44:33:
Attachments
ScreenshotDB.jpg
(83.24 KiB) Downloaded 291 times

musher0
Posts: 14629
Joined: Mon 05 Jan 2009, 00:54
Location: Gatineau (Qc), Canada

#204 Post by musher0 »

Great find, Pete! :) Thanks!
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)

User avatar
Pete
Posts: 660
Joined: Sun 02 Mar 2014, 18:36

#205 Post by Pete »

Pleasure musher0.

It also works in OpenOffice (3.4.1) under Mac.
Here I didn't even bother to take out the "::"
Attachments
ScreenShotMacDBtest.jpg
(204.08 KiB) Downloaded 266 times

User avatar
Pete
Posts: 660
Joined: Sun 02 Mar 2014, 18:36

#206 Post by Pete »

Also OK with Google Drive (Google Sheets).
Just need to specify "custom separator" i.e. "::"
Attachments
ScreenshotDBgoogleDocs.jpg
(77.18 KiB) Downloaded 256 times

User avatar
Pete
Posts: 660
Joined: Sun 02 Mar 2014, 18:36

#207 Post by Pete »

Found a bug which is urxvt related and not fields.awk related.

When reading/displaying from a file and the data exceeds a certain amount of lines,
one cannot scroll down anymore even if it's made fullscreen.

I installed LXTerminal (ver 0.1.11) from the official Slacko 14 repo and problem gone.

Anyway I prefer LXTerminal as it has better copy+paste functionality.

Running Slacko 6.3 (32 bit)

User avatar
greengeek
Posts: 5789
Joined: Tue 20 Jul 2010, 09:34
Location: Republic of Novo Zelande

#208 Post by greengeek »

Hi Musher, do you have a thread for fields.awk support? I tried to install the pet but it said "failed to install" (Slacko 5.6 derivative). I tried clicking the fields.awk script and my puppy doesn't know what to do with it (nor do I !!).

Any assistance or headslaps gratefully received.
8)

User avatar
Pete
Posts: 660
Joined: Sun 02 Mar 2014, 18:36

#209 Post by Pete »

@greengeek

I'm using Slacko 6.3 32 bit and fields.awk is working perfectly.
Keep in mind that as musher0 wrote, it's a CLI pgm so start a terminal, rather use LXTerminal over URXVT (available in the PPM) then just type in fields.awk

When you run fields.awk for the first time, it will ask you to select/create a database directory.
Ffom there then you can carry on.

Another point to note, fields.awk uses a .txt extension for it's databases.
When opening a new one, or selecting one, never include the extension, just the name else it gets all confused as it appends the .txt automatically so MyDB.txt will become MyDB.txt.txt which of course will not exist.
Last edited by Pete on Sat 18 Jun 2016, 20:33, edited 1 time in total.

User avatar
greengeek
Posts: 5789
Joined: Tue 20 Jul 2010, 09:34
Location: Republic of Novo Zelande

#210 Post by greengeek »

musher0 wrote:Hello all.

I found an interesting "fields.awk" script through ask.com:
http://www.ask.com/youtube?q=fields.awk ... archTopBox
Hi Musher - I think the link you posted should be replaced with this:
https://www.youtube.com/embed/HC8Az9W8F ... autoplay=0

(I also followed the link from one of your other posts but that just went to the search page too, instead of direct to the tutorial.

cheers!

User avatar
Pete
Posts: 660
Joined: Sun 02 Mar 2014, 18:36

#211 Post by Pete »

@greengeek

Edited my post after you posted yours.

User avatar
greengeek
Posts: 5789
Joined: Tue 20 Jul 2010, 09:34
Location: Republic of Novo Zelande

#212 Post by greengeek »

Thanks Pete. I had foolishly pre-pended the awk script with #!/bin/sh. Duh!
Got it working now - just need to view the tute a couple more times.
cheers!

User avatar
Pete
Posts: 660
Joined: Sun 02 Mar 2014, 18:36

#213 Post by Pete »

Glad you got it sorted.

musher0
Posts: 14629
Joined: Mon 05 Jan 2009, 00:54
Location: Gatineau (Qc), Canada

#214 Post by musher0 »

greengeek wrote:
musher0 wrote:Hello all.

I found an interesting "fields.awk" script through ask.com:
http://www.ask.com/youtube?q=fields.awk ... archTopBox
Hi Musher - I think the link you posted should be replaced with this:
https://www.youtube.com/embed/HC8Az9W8F ... autoplay=0

(I also followed the link from one of your other posts but that just went to the search page too, instead of direct to the tutorial.

cheers!
Many thanks for pointing that out, greengeek. I corrected my original post about fields.awk.

If you could tell me where that "other post" is, I'll correct it too. (I've written a lot of posts
on this forum!) :) TIA.

BFN.
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)

User avatar
greengeek
Posts: 5789
Joined: Tue 20 Jul 2010, 09:34
Location: Republic of Novo Zelande

#215 Post by greengeek »

musher0 wrote:If you could tell me where that "other post" is, I'll correct it too. (I've written a lot of posts
on this forum!)
It's this post back a couple of pages.
cheers!

Post Reply