Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Sun 28 May 2017, 01:12
All times are UTC - 4
 Forum index » Advanced Topics » Cutting edge
Puppy Database
Moderators: Flash, Ian, JohnMurga
Post new topic   Reply to topic View previous topic :: View next topic
Page 14 of 16 [236 Posts]   Goto page: Previous 1, 2, 3, ..., 12, 13, 14, 15, 16 Next
Author Message
musher0


Joined: 04 Jan 2009
Posts: 10169
Location: Gatineau (Qc), Canada

PostPosted: Thu 11 Feb 2016, 18:16    Post subject:  

Smile
_________________
musher0
~~~~~~~~~~
« Un insensé sur le trône n'est qu'un singe sur le haut d'un toit. » / "A madman
on the throne is just a monkey on top of a roof." (Bernard de Clervaux)
Back to top
View user's profile Send private message 
Pelo


Joined: 10 Sep 2011
Posts: 11446
Location: Mer méditerrannée (1 kms°)

PostPosted: Wed 02 Mar 2016, 23:02    Post subject: I still consider OSMO as a DataBase  

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 Exclamation
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 ? Smile
ChimpBox.png
 Description   I have the version with correct titles
 Filesize   66.55 KB
 Viewed   359 Time(s)

ChimpBox.png


_________________
Lx Cute On Stage
Back to top
View user's profile Send private message Yahoo Messenger 
Pelo


Joined: 10 Sep 2011
Posts: 11446
Location: Mer méditerrannée (1 kms°)

PostPosted: Wed 02 Mar 2016, 23:36    Post subject: Kexi is as small as a Puppy.  

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)
kexi.jpg
 Description   Kexi is as small as a Puppy.
 Filesize   74.61 KB
 Viewed   349 Time(s)

kexi.jpg


_________________
Lx Cute On Stage
Back to top
View user's profile Send private message Yahoo Messenger 
Pelo


Joined: 10 Sep 2011
Posts: 11446
Location: Mer méditerrannée (1 kms°)

PostPosted: Wed 02 Mar 2016, 23:48    Post subject: Last step of the process : import and rename columns  

Last step of the process : import and rename columns. Pelo makes life easy for his office staff (women at 90%). What a Boss Exclamation
Ordinateurs.jpg
 Description   Easy as Puppy.
 Filesize   70.85 KB
 Viewed   348 Time(s)

Ordinateurs.jpg


_________________
Lx Cute On Stage
Back to top
View user's profile Send private message Yahoo Messenger 
Pelo


Joined: 10 Sep 2011
Posts: 11446
Location: Mer méditerrannée (1 kms°)

PostPosted: Thu 03 Mar 2016, 00:04    Post subject: Rename the columns  

Rename the columns (caution save your data, because structure change will erase them) . reimport data when 'birthday' has been changed to 'Acquired on'
Structure.jpg
 Description   Users practice improves applications quality. Never used means useless.
 Filesize   46.17 KB
 Viewed   363 Time(s)

Structure.jpg


_________________
Lx Cute On Stage
Back to top
View user's profile Send private message Yahoo Messenger 
Pete


Joined: 02 Mar 2014
Posts: 675

PostPosted: Tue 07 Jun 2016, 19:01    Post subject:  

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.
Back to top
View user's profile Send private message 
musher0


Joined: 04 Jan 2009
Posts: 10169
Location: Gatineau (Qc), Canada

PostPosted: Tue 07 Jun 2016, 21:05    Post subject:  

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! Smile
_________________
musher0
~~~~~~~~~~
« Un insensé sur le trône n'est qu'un singe sur le haut d'un toit. » / "A madman
on the throne is just a monkey on top of a roof." (Bernard de Clervaux)
Back to top
View user's profile Send private message 
Pete


Joined: 02 Mar 2014
Posts: 675

PostPosted: Wed 08 Jun 2016, 06:20    Post subject:  

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/viewtopic.php?t=17907&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:

@@@Param1:Param2:Param3:Param4:
11:22:44:33:
12:24:46:38:
14:24:44:34:
11:22:44:33:
ScreenshotDB.jpg
 Description   
 Filesize   83.24 KB
 Viewed   229 Time(s)

ScreenshotDB.jpg

Back to top
View user's profile Send private message 
musher0


Joined: 04 Jan 2009
Posts: 10169
Location: Gatineau (Qc), Canada

PostPosted: Wed 08 Jun 2016, 12:35    Post subject:  

Great find, Pete! Smile Thanks!
_________________
musher0
~~~~~~~~~~
« Un insensé sur le trône n'est qu'un singe sur le haut d'un toit. » / "A madman
on the throne is just a monkey on top of a roof." (Bernard de Clervaux)
Back to top
View user's profile Send private message 
Pete


Joined: 02 Mar 2014
Posts: 675

PostPosted: Wed 08 Jun 2016, 14:30    Post subject:  

Pleasure musher0.

It also works in OpenOffice (3.4.1) under Mac.
Here I didn't even bother to take out the "::"
ScreenShotMacDBtest.jpg
 Description   
 Filesize   204.08 KB
 Viewed   204 Time(s)

ScreenShotMacDBtest.jpg

Back to top
View user's profile Send private message 
Pete


Joined: 02 Mar 2014
Posts: 675

PostPosted: Wed 08 Jun 2016, 16:01    Post subject:  

Also OK with Google Drive (Google Sheets).
Just need to specify "custom separator" i.e. "::"
ScreenshotDBgoogleDocs.jpg
 Description   
 Filesize   77.18 KB
 Viewed   195 Time(s)

ScreenshotDBgoogleDocs.jpg

Back to top
View user's profile Send private message 
Pete


Joined: 02 Mar 2014
Posts: 675

PostPosted: Wed 08 Jun 2016, 19:06    Post subject:  

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)
Back to top
View user's profile Send private message 
greengeek


Joined: 20 Jul 2010
Posts: 4578
Location: New Zealand

PostPosted: Sat 18 Jun 2016, 16:20    Post subject:  

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.
Cool
Back to top
View user's profile Send private message 
Pete


Joined: 02 Mar 2014
Posts: 675

PostPosted: Sat 18 Jun 2016, 16:28    Post subject:  

@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, 16:33; edited 1 time in total
Back to top
View user's profile Send private message 
greengeek


Joined: 20 Jul 2010
Posts: 4578
Location: New Zealand

PostPosted: Sat 18 Jun 2016, 16:31    Post subject:  

musher0 wrote:
Hello all.

I found an interesting "fields.awk" script through ask.com:
http://www.ask.com/youtube?q=fields.awk&qsrc=1&o=0&l=dir&qo=serpSearchTopBox
Hi Musher - I think the link you posted should be replaced with this:
https://www.youtube.com/embed/HC8Az9W8FV4?rel=0&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!
Back to top
View user's profile Send private message 
Display posts from previous:   Sort by:   
Page 14 of 16 [236 Posts]   Goto page: Previous 1, 2, 3, ..., 12, 13, 14, 15, 16 Next
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » Advanced Topics » Cutting edge
Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.1281s ][ Queries: 14 (0.0375s) ][ GZIP on ]