An impressive duo for processing flat DBs: csvfix & CSVpad

Word processors, spreadsheets, presentations, translation, etc.
Message
Author
ac2011
Posts: 134
Joined: Wed 09 Feb 2011, 08:22

#31 Post by ac2011 »

musher0 wrote:Hello ac2011.

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

Works fine from terminal on Wary-5.5.
Thanks musher0, much obliged. That's working fine here and does what I need. I did try compiling 1.60 on various other Puppies but couldn't create any version that works on Wary. This'll do fine, though - thanks again.

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

#32 Post by musher0 »

My pleasure, ac2011! :)
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)

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

#33 Post by musher0 »

Hello.

Here is csvfix for XenialPup7.

To recreate the complete pet for it from the sections provided below, please open a
terminal in the download directory and type:

Code: Select all

cat xa*7.pet csvfix-1.60_93804d497be6-XenPup7.pet
I realize this is an inconvenience. On the other hand one does not have to run to
"Devil's Corner" and back to fetch the material.

~~~~~~~~~~~~~

What is particular in this version:
-- strangely, developer Neil Butterworth has not changed the version number. It is
still version 1.60;

-- however this one is dated 2015, and compiles with a library that was not there
before, AFAICT;

-- I ran all the tests provided and only one function "seems" to be broken, "shuffle."
(Test results are attached.) I ran them a couple of times to make sure, but there
was still one error. I'm not sure if that is due to a conversion fault on my part. (I
converted all the tests and corrections files from WhineDose to Unix format.) Test
reports on the various csvfix functions will then be much appreciated from your side.)

-- I devised a special rxvt terminal to the colors of the csvfix logo. When you will
click on the csvfix entry in your menu, this terminal will open. Simply type:

Code: Select all

csvfix help
or

Code: Select all

csv help <function>
in that terminal to get started.

-- There is also a menu entry for the csvfix docs. Those will open in your browser
when you click on that entry. May I suggest that you work your csv file(s) with the
csvfix terminal and the csvfix docs side-by-side for easy reference.

-- I translated the csvfix logo from *.ico to *.png.

~~~~~~~~~~~~~

Now having more experience with Puppy and Linux, I fully realize that some of the
csvfix functions are not really needed in a Linux environment, i.e., in presence of
the awk language, and also of the sqlite3, paste, nl, join, cat, head, etc., utilities,
which PuppyLinux provides OOTB.

Nevertheless, IMO, csvfix preserves some advantages:
-- it is a complete environment devoted to csv processing, and

-- its documentation is absolutely superb. In short, you do not need to know the
complete ins and outs of some GNU/Linux utilities to take advantage of csvfix,
simply the basics of csv databasing;

-- finally, csvfix is multi-platform: it runs on WhineDose and Linux. Some users may
appreciate not having to learn another set of commands to process csv files when
they have to switch platforms. (As much as I love Linux, I am also realistic.)

~~~~~~~~~~~~~~~~

So there you go. In the coming days, I will revive the dead URLs on the previous
pages, so Puppyists will lesser versions than the XenialPup7 can once again use
csvfix.

Feedback appreciated.

IHTH. BFN.

~~~~~~~~~~~~~~~~

P. S. 1) The csvfix development site is now at the following bitbucket URL:
https://bitbucket.org/neilb/csvfix.

2) Test results from the "runalltests" script:
PASSED ab.test
PASSED atable.test
PASSED block.test
PASSED case.test
PASSED check.test
PASSED dates.test
PASSED diff.test
PASSED echo.test
PASSED edit.test
PASSED erase.test
PASSED escape.test
PASSED evalextra.test
PASSED eval.test
PASSED exclude.test
Execution problem with exec.test - please correct
PASSED fileinfo.test
PASSED find.test
PASSED fixed.test
PASSED flatten.test
PASSED fmerge.test
PASSED from_xml.test
PASSED headtail.test
PASSED inter.test
PASSED join.test
PASSED map.test
PASSED mdflat.test
PASSED merge.test
PASSED mline.test
PASSED money.test
PASSED multi.test
PASSED number.test
PASSED order.test
PASSED osep.test
PASSED out_join.test
PASSED pad.test
PASSED pivot.test
PASSED printf.test
PASSED put.test
PASSED read_dsv.test
PASSED retsep.test
PASSED rmnew.test
PASSED rowsort.test
PASSED sequence.test
[01;31mFAILED shuffle.test[00m
PASSED skippass.test
PASSED smoke.test
PASSED sort.test
PASSED specquote.test
PASSED splitlen.test
PASSED splitregex.test
PASSED split.test
PASSED splittrans.test
PASSED sql_delete.test
PASSED sql_insert.test
PASSED sql_update.test
PASSED squash.test
PASSED stat.test
PASSED summary.test
PASSED template.test
PASSED toxml.test
PASSED trim.test
PASSED unique.test
PASSED val_fields.test
PASSED wmulti.test
PASSED write_dsv.test

1 failed, 64 passed
Attachments
csvfix-terminal.jpg
A convenient csvfix terminal.
(229.56 KiB) Downloaded 227 times
csvfix-1.60_DOC.pet
The csvfix docs.
(174.86 KiB) Downloaded 312 times
xaa-csvfix-1.60_93804d497be6-XenPup7.pet
The formula to re-attach these three parts is in the body of the above post.
(185.28 KiB) Downloaded 318 times
xab-csvfix-1.60_93804d497be6-XenPup7.pet
(185.28 KiB) Downloaded 304 times
xac-csvfix-1.60_93804d497be6-XenPup7.pet
(185.28 KiB) Downloaded 303 times
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)

Post Reply