line business / commercial software for linux

Zasio is a graphics calculator for java.

Zasio is my second attempt at writing a graphics calculator for a hand held device that I own. My first was Newtsio which was writen for the Newton. The first program I wrote while I was in college.

At the time I was lugging around a Casio calculator, a Frankland spell checker, paper based calendar, and about a houndred notes jotted down on scraps of paper. To say the least I was in need of a PDA.

My goal was to get a pda and write programs that would allow me to carry just one device. Today, my needs have changed, but I still find it quite nice to have a programable graphics calculator at hand and when I got a Zaurus I just could not resist writing a calculator for it. With that modivation, I started my second calculator.

Usage:

Inputing:

Commands can be inputed into Zasio in three ways, buttons, editor tab, or file. The button layout is set up in such a way to make it easy for users of a Casio calculator (this is really the only thing Zasio shares with Casio).

The second way to input commands is to use the editor tab. In this tab is a large text edit area where you can type very complicated formulas and or programs that you want to executed. When ready, you can execute your commands with the press of the EXE button at the bottom. The third way to input commands is by file. Files can be loaded (and saved) from the edit tab. This allows you to write programs and formulas in an external editor and load them into Zasio.

Buttons:

Buttons fall into three catagories. Buttons that have one use, buttons that have up to three uses, and the F keys. Most of the one use buttons are on the first row under the F keys but a few others are closer to the bottom. These buttons are the shift, ALPHA, EXIT, Menu, Arrow keys, DEL, AC, and the EXE key.

The shift and ALPHA key are used to change the multi use keys into other keys. EXIT we will get into when I explain F keys. Menu is not used at this time as are the left are right arrow keys. The up and down arrow keys are used to recall previous calculations (scroll up or down). The DEL key will remove the last letter from the calculation (its a delete key). AC is the clear button which will clear the text line or the graph screen depending on which is displayed. Finaly EXE is the execute key. That should wrap up the the single use keys.

The majority of the other keys in Zasio are of the second kind. The up to three uses kind. These keys are like most graphic calculator buttons where the buttons have a normal action, a shifted action and an alpha action. Most of these keys are for entering functions (such as sin or sq) and shift just gives you more options so Zasio does not have to have twice the buttons on the screen. Alpha lets you enter in letters and other such charecters needed for variable access.

F keys take a bit more to understand. Some keys when shifted will allow you to access an F menu that you can navigate through the F keys. One example is the MATH menu. Press SHIFT and then MATH and you should notice a change to the F keys. These keys when pressed will either enter the function they represent into the calculation or take you to more choices in the F keys. To go back, use the EXIT key. So in our example, you can press the Num F key and then abs to get the int function in your calculation.

Calculations:

Zasio works the same as most graphic calculators. You enter your formual in and press the execute key. To run a calculation like 2+2 you would need to press the buttons 2, +, 2, and then EXE. The EXE button takes the formula and turns it into a short program which returns 2 as a result.

While this was a very simple formula, even complicated formulas are entered the same way. Take (sin Pi/2)*2. To do this calculation you would press (, sin, shift, Pi, /, 2, ), *, 2, EXE. Calculations can use variables A to Z, radius, and theta to store results from previous calculations. These variables can also be used in other calculations. To do this, simply use the variable name and the equals (=) button like this: A=(sin Pi/2)*2. You would use A like this: cos(A).

Graphing:

Graphing is done by passing forumals to the s.graph() function which contain the variable x (not to confuse with the storage variable X). To graph a simple function like sin x you would enter in s.graph(s.sin(x)). After pressing EXE, Zasio will change to the graph screen to display the rusults of your function.

To get back to the text screen, press the TG. I should point out now that the clear button (AC) only clears the active screen, so pressing it while in the viewing the text screen will not clear out the gragh screen. You can also display graphs in different colors by setting the color you want in the Color F menu.

Ricebridge CSV Manager project allows you to read and write CSV files from within your Java application. This component covers all sorts of boundary cases and bad data that youd rather not think about.
Main features:
- Any CSV Format
Read and write Excel, UNIX and arbitrary CSV formats. Easily define the separation, quoting, escape and whitespace characters. We can handle multi-line data and missing fields. We provide detailed error reporting when badly formatted data is encountered.
- Access Data Directly
From ArrayLists to TableModels, from ResultSets to plain old Java arrays, we provide the data the way you want it. You can even create your own data models using callback interfaces.
- Great Documentation
Our documentation is something were really proud of. We cover everything you need to know, fully and comprehensively, from the basics to advanced usage.
- Easy to Use
Weve put lots of thought into making our components usable. Our interfaces and naming conventions are consistent, coherent and sensible. We take the time to find the least surprising way to do something.
- Fast and Scalable
Weve defined a proper grammar for CSV files to parse them cleanly and efficiently, and weve verified that our parser has linear performance for any file size.
- Learn from Open Source
Weve taken selected sections of the CSV Manager source code and released them under a BSD-style license. This means that you can get see in detail how to use our entire API.
Version restrictions:
- 30-day trial
Enhancements:
- Comments within lines were enabled by default, causing unexpected data loss.
- Comments are now only valid at the start of a line, unless CsvSpec.setCommentWithinLine is true.

xls2mysql project is an application to perform data conversion from XLS to MySQL.
xls2mysql is shipped with a simple and easy-to-understand DHTML interface that allows uploading and displays the files available for conversion.
Main features:
- uses first line of the excel file to create sql columns.
- uses filename to create table
- uses each following row (from 2 to N) to create inserts.
- does not actually perform the sql : please copy and paste to your favorite sql admin interface.
Version restrictions:
- detect field types (numeric, text, longtext, unique)
Usage:
- download the package xls2mysql.zip and unzip it to a web folder that has PHP
- run the xls2mysql.php page within your browser
- Upload the files or test from the sample xls files from the file list tab
- if you upload files, check that php has rad/write rights on the xls folder.
Xls2Mysql uses :
- Super-Simple DHTML Tabs, by Joshua Olson (Georgia, USA)
- Sliding doors of css, by Douglas Bowman (San Francisco, California, USA)
- Spreadsheet_Excel_Reader.