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 Fri 22 Sep 2017, 20:27
All times are UTC - 4
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Documents
An impressive duo for processing flat DBs: csvfix & CSVpad
Post new topic   Reply to topic View previous topic :: View next topic
Page 2 of 3 [32 Posts]   Goto page: Previous 1, 2, 3 Next
Author Message
musher0


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

PostPosted: Fri 19 Dec 2014, 13:32    Post subject:  

Good afternoon, csv table lovers! Smile

I've uploaded version 1.60 of csvfix (released circa mid-2014) at
http://www.datafilehost.com/d/672b6210

I compiled it from source on Slacko-6.0b. Since this powerful csv file processor
is a console app, there should be no compatibility problems with other Puppies.

Please note that the main site for csvfix is now: http://neilb.bitbucket.org/csvfix/

The docs are included in the *.pet package, but they are also available online
at http://neilb.bitbucket.org/csvfix/manual/csvfix16/csvfix.html

Enjoy.

musher0

_________________
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 
musher0


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

PostPosted: Sat 20 Dec 2014, 04:08    Post subject:  

Hello!

Just a note to say that I have made CSVpad-1.2, a much more powerful
replacement for dmcsv, available through:
http://murga-linux.com/puppy/viewtopic.php?p=815999&sort=lastpost#815999

BFN.

musher0
~~~~~~~~~~
Late thanks and apologies to pelo... Embarassed

_________________
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: 12510
Location: Mer méditerrannée (1 kms°)

PostPosted: Wed 31 Aug 2016, 07:38    Post subject: CSVpad will help untill libgcong found.  

Gnumeric broken in Slacko 5.7 8Geee. Never mind CSVpad will help untill libgcong found.
_________________
Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.
Back to top
View user's profile Send private message Yahoo Messenger 
ac2011

Joined: 09 Feb 2011
Posts: 116

PostPosted: Wed 21 Sep 2016, 20:08    Post subject:  

musher0 wrote:
Good afternoon, csv table lovers! Smile
I compiled it from source on Slacko-6.0b. Since this powerful csv file processor
is a console app, there should be no compatibility problems with other Puppies.


The link is dead but I compiled CSVfix 1.60 in Tahr and it works fine there, but unfortunately not in Wary (GlibC errors) despite being a console app.

If I try to compile it in Wary I get issues with g++ errors. Don't suppose anyone's managed to compile this on an in-between version of Puppy so it'll work in Wary?
Back to top
View user's profile Send private message 
Pelo


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

PostPosted: Sun 05 Feb 2017, 12:19    Post subject: Musher0, please check your links, s'il vous plait..  

Musher0, please check your link, s'il vous plait..
CSVpad.jpg
 Description   Depannage avec vieille version.
 Filesize   48.43 KB
 Viewed   196 Time(s)

CSVpad.jpg


_________________
Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.
Back to top
View user's profile Send private message Yahoo Messenger 
musher0


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

PostPosted: Sun 05 Feb 2017, 18:46    Post subject:  

Hello all.

CSVpad is now available again, from PCloud. Please see edited first post of
the CSVpad thread. Thanks.

As to making CSVpad available on a Wary Puppy, I cannot, sorry:
the executable comes pre-compiled by the author, and I have no access
to the source code. I only repackaged it for Puppy.

Best regards.

_________________
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 
ac2011

Joined: 09 Feb 2011
Posts: 116

PostPosted: Sun 05 Feb 2017, 19:13    Post subject:  

Thanks Musher. CSVpad is fine - it's CSVfix that I'd like to see in a Wary version. The source code for that is available, but I can't find the right build environment to create a version that'll work in Wary.
Back to top
View user's profile Send private message 
musher0


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

PostPosted: Sun 05 Feb 2017, 21:24    Post subject:  

ac2011 wrote:
Thanks Musher. CSVpad is fine - it's CSVfix that I'd like
to see in a Wary version. The source code for that is available, but I can't
find the right build environment to create a version that'll work in Wary.

Hi ac2011

You're welcome.

IIRC, a while back, I compiled an earlier version of CSVfix for an older
version of Puppy. Maybe try that one?

As I'm set-up now, I only have recent versions of Puppy on my computer.
No Wary on this machine unfortunately.

But AFAIK, if you have the corresponding devx for your Wary mounted,
compiling of even the newer CSVfix should work fine. I think I had to
specify the linux environment on the "make" line and that was it.
Quote:
readme.txt
----------

This is the source for CSVfix and the supporting alib library.
Building requires a GCC installation. To build, enter the command
"make win" for a Windows build, "make lin" for a Linux/Unix build,
or "make mac" for a Mac build.

For further information, please see the CSVfix website
at http://neilb.bitbucket.org/csvfix/

Neil Butterworth
13-Nov-2014

IHTH

_________________
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 
musher0


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

PostPosted: Sun 05 Feb 2017, 22:09    Post subject:
Subject description: Fresh compilation of csvfix-1.60
 

For the record, here is the source of version 1.60:
https://bitbucket.org/neilb/csvfix/get/default.tar.bz2

You unpack it, you enter the new csvfix dir., you open a terminal there
and you type
Code:
make lin

~~~~~~~~~~~
If you prefer something ready-made, I've uploaded a fresh compilation
here, for the recent slacko's, tahrpup's, and devuan/debian pups:
https://my.pcloud.com/publink/show?code=XZFBDlZkIbz91xxcypefE2KtQjT1yeCNIWX

This pet archive contains the executable, the docs, an icon and a
desktop file to display the docs in your default web browser.

To work with csvfix proper, please remember that you must open a
terminal and call csvfix with

Code:
csvfix /path/to/file
OR
Code:
csvfix help

I'll try to provide an older Wary version for ac2011 sometime later, as
I have limited time ATM. Thanks for your understanding.

If you need a separate desktop file (the pet installer on your Pup could
perhaps replace the Database category with something else, some older
versions of the PPM are funny that way), there is one below.

Any constructive comment welcome.

BFN.
csvfix-doc.desktop.zip
Description  To activate, please unzip in /usr/share/applications and refresh your window manager's menu.
zip

 Download 
Filename  csvfix-doc.desktop.zip 
Filesize  350 Bytes 
Downloaded  54 Time(s) 

_________________
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 
musher0


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

PostPosted: Sun 05 Feb 2017, 23:40    Post subject:  

Almost forgot: thanks for the reminder, Pelo! Wink
_________________
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 
ac2011

Joined: 09 Feb 2011
Posts: 116

PostPosted: Mon 06 Feb 2017, 17:51    Post subject:  

musher0 wrote:
ac2011 wrote:
Thanks Musher. CSVpad is fine - it's CSVfix that I'd like
to see in a Wary version. The source code for that is available, but I can't
find the right build environment to create a version that'll work in Wary.

Hi ac2011

You're welcome.

IIRC, a while back, I compiled an earlier version of CSVfix for an older
version of Puppy. Maybe try that one?

As I'm set-up now, I only have recent versions of Puppy on my computer.
No Wary on this machine unfortunately.

But AFAIK, if you have the corresponding devx for your Wary mounted,
compiling of even the newer CSVfix should work fine. I think I had to
specify the linux environment on the "make" line and that was it.
Quote:
readme.txt
----------

This is the source for CSVfix and the supporting alib library.
Building requires a GCC installation. To build, enter the command
"make win" for a Windows build, "make lin" for a Linux/Unix build,
or "make mac" for a Mac build.

For further information, please see the CSVfix website
at http://neilb.bitbucket.org/csvfix/

Neil Butterworth
13-Nov-2014

IHTH


An earlier version sounds good but I haven't found one - do you have a link?

I do have the source and I attempted compilation. Can't remember the issue as it was a while ago, but I think it was a problem with a later version of C libraries required. But compiling on a later Puppy that had those libs made the binary unusable on Wary. I'll have another attempt some time.
Back to top
View user's profile Send private message 
musher0


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

PostPosted: Mon 06 Feb 2017, 19:49    Post subject:  

Hi ac2011.

What is the glibc version of your Wary? You can find out by typing in
console
Code:
ldd --version

And the version of your Wary, please? I ask because the oldest Pup I
have available is Puppy CE-3 by forum member wanderer and its glibc
version is 2.11. If your Wary had glibc 2.11 or higher, I could try to
recompile csvfix on Puppy CE-3, and it should be ok.

Otherwise, I'll have to reinstall your Wary version, and as I said before,
it's not that I don't want to help out, but I have limited time ATM, sorry...

Tip: If you're in a bind, depending what you want to do, of course, you
can perhaps use awk to extract and/or process data from your csv file.
All Puppies have awk.

BFN.

_________________
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 
musher0


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

PostPosted: Thu 09 Feb 2017, 02:30    Post subject:  

Hello ac2011.

Here is csvfix-1.20 (goes back to 2013) for Puppy:
https://my.pcloud.com/publink/show?code=XZ4rdlZaJyMADPJyEkMvJhaULaruSWEFpGX.
I dug it out of an old repository I had.

Works fine from terminal on Wary-5.5.

I tried compiling csvfix-1.60 on Wary-5.5 and got the same error you got.
Even csvfix-1.50 refused to run on Wary-5.5.

So there you go. The pet archive has scripts and *.desktop files for
opening a terminal to run csvfix (doesn't run it, but puts you in position
to, IIRC) and for showing the docs. I didn't re-test these scripts, but they
were ok then, they should be ok now!

This csvfix-1.20 certainly has a few less parameters to process your csv
file with, than the new csvfix-1.60, but it's the best I can offer given the
Wary-5.5 context.

BTW, Wary-5.5 has glibc-2.10.1, if anybody needs this info.

IHTH. BFN.

_________________
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 
musher0


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

PostPosted: Thu 09 Feb 2017, 13:17    Post subject:  

Hello again all.

As a reminder, we also have on this forum discussions about
Fields.awk:
http://murga-linux.com/puppy/viewtopic.php?p=908333&sort=lastpost&search_id=1174376501#908333
for light and moderate csv table needs.

Also worthy of note is gnumeric, which can be used to manage
simple lists, if that's all you need to process.

For bigger needs, there is datacrow, a java app. that allows you to
create collections (aka databases) of almost anything:
http://murga-linux.com/puppy/viewtopic.php?p=686631&sort=lastpost&search_id=1568772550#686631

There is also a discussion about datacrow in French, here:
http://murga-linux.com/puppy/viewtopic.php?p=686628&sort=lastpost&search_id=1568772550#686628
We owe the French translation of datacrow to French member Argolance,
the developer of ToOpPy. Thanks, Argo!

I mention both datacrow threads because the discussions evolved in
different directions, so both may be useful to a serious user.

Please note that datacrow requires a recent java JRE to run.

Last but not least: the "base" (aka "sbase") application in
OpenOffice / Libre Office, which needs no introduction, of course. Sbase
has a good SQL language for constructing queries.

All considered, we're pretty well equipped now on Puppy for processing
databases of various kinds if we need to.

With the above tools, Puppy Linux can be used as a viable solution in a
Small Office / Home Office environment. Can you believe that some
narrow-minded people have dismissed the Puppy OS as unsuitable for
serious work only because of its name?! Ah! Shame on them!

IHTH. BFN.

_________________
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: 12510
Location: Mer méditerrannée (1 kms°)

PostPosted: Fri 10 Feb 2017, 03:05    Post subject: Professional Office suites  

Little Puppy was featured with light tools for home works, usually once a month. Unfortunately, some of our puppy lovers have work to do at home, after a long day at the office or teaching classes of nasty pupils. Sure Libre Office will be the Office suite to load on our Little Puppy,

Personally , i have Microsoft office, soft Office, Open Office, Libre Office on my Windows partition for any professional task
My choice : Windows Seven for tasks, Puppy for fun Smile

Business section here, was created for you, men , and women, for your feed back.
DMcsv.jpg
 Description   Quick and fast DMcsv for Puppies.
 Filesize   77.71 KB
 Viewed   57 Time(s)

DMcsv.jpg


_________________
Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.
Back to top
View user's profile Send private message Yahoo Messenger 
Display posts from previous:   Sort by:   
Page 2 of 3 [32 Posts]   Goto page: Previous 1, 2, 3 Next
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Documents
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.0599s ][ Queries: 14 (0.0099s) ][ GZIP on ]