Menu
▾
▴
portabase-devel — PortaBase development
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(6) |
Nov
(1) |
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2012 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2013 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Jeffrey N. <jef...@gm...> - 2013-03-09 04:24:22
|
Hi. Just discovered portabase and it looks like a great app. Just what I need. One feature -- date calculations. I'd like to be able to add 30 days to a date and come up with another date, subtract one date from another and get a number of days between, etc. Is that possible in a future release? Thanks. |
|
From: BARE W. s. <bar...@eu...> - 2012-12-08 05:52:42
|
<html>
<head>
<meta http-equiv="content-type" content: text/html;
charset=ISO-8859-1>
</head>
<body>
Hi,<br>
thanks for this awesome database !<br>
<br>
Command line use is much appreciated.<br>
In combination with a wordprocessor (i.e. abiword), mail merging is
feasable using a output.csv file from Portabase, and combining it with a
template.abw file with abiword.<br>
This will result in so many printouts as the records in the output.csv
file.<br>
<br>
This needs the template file to have the relevant title of colons as merge
fields.<br>
<br>
question and request: wouldn't it be nice the Portabase export dialog box
to have an option «export colons titles as first line»: colons titles would
then be present as first row in the output.csv file, comma separated as the
other datas.<br>
<br>
(afaik, such an option is present in sql manager for sqlite)<br>
<br>
example:<br>
<br>
FirstName,LastName,StreetAddr,City,State,Zip
<------ 1st row containing colons names (or titles)<br>
Mark,Gilbert,666 Microsoft
Way,Redmond,WA,
<--from here are the records<br>
David,Chart,123 Easydoc Street,Userville,MD,12345<br>
Dom,Lachowicz,777 GNU Ave.,Utopia,CA,02111<br>
<br>
thanks for any answer<br>
<br>
Charlie<br>
<br>
attached: ?uggestion for export dialog box<br>
<br>
<br>
<br>
Charlie Ledocq<br>
BARÉ Willy sprl<br>
rue du Gonoy, 114<br>
5640 Maison-Saint-Gérard<br>
bar...@eu...<br>
mobile: +32 0474 780051<br>
fax: +32 071 798711
</body>
</html> |
|
From: Jeremy B. <ml...@ya...> - 2002-11-16 19:45:15
|
--- li...@ap... wrote: > Hi, Jeremy! I just realised I'm still on version 1.1, and I want to upgrade > to 1.2. I remember reading somewhere about having to uninstall and reinstall > ipks in order to upgrade, but obviously I don't want to lose my data. > Tips/brief instructions? 1- Go to "Add/Remove Software" and uninstall "portabase". This only deletes the files added by the installer, so your data files will be left alone. 2- Install the new portabase .ipk. (The libmetakit1 .ipk hasn't changed since PortaBase 1.0, so you don't need to do anything with it.) > P.S. Do you have a rough ETA on 1.3? Probably in a week or so. Features I plan to add for it are: - Unicode support (mostly done, all that's left is allowing unicode characters in column names) - Font selection, so you can choose a unicode font or reduce the font size to fit more data on the screen - "Blank" date support - Enumeration column type - Optional delete confirmation dialogs (for rows, views, sortings, and filters) - "Delete All Rows" option Jeremy __________________________________________________ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com |
|
From: Jeremy B. <ml...@ya...> - 2002-10-28 19:08:07
|
Just released PortaBase 1.1 which addresses some of the points you mentioned...I'll just make comments inline: > > * Multiple column sorting SOMETIMES USEFUL This was added in 1.1. > > * Filtering/Searching EXTREMELY USEFUL This seems to be the still-remaining TODO item which is in the highest demand; I'll try to get it done for a 1.2 release in a week or two. > > * Date column type INTEGERS WORK FINE (20021028) > > * Date and time column type DECIMALS WORK FINE (20021028.0555) Strings work for these too; in both cases, sorting and such work out fine, and use of CSV export and import can transfer such data to a real date or date/time column later. The main point of having a specific date column would be to use a calendar-picker widget for selecting dates; this is often faster and prevents you from entering invalid dates. But nobody (including me) seems to have a strong need for this, so it's on the back burner for now. > > * Enumeration column type POSSIBLY USEFUL Like date fields, on hold until somebody needs it. > > * Multiline text column type !! CRITICAL NEED FOR ME !! Added in 1.1 (including support in CSV import and export; fields containing newlines should be enclosed in quotes and imported into a Note column). > > * File properties dialog POSSIBLY USEFUL This one should be easy to do...I might throw it into 1.2 for the heck of it. > > * Alternate-row shading POSSIBLY USEFUL This one looks to actually be pretty hard; the display widget I'm using doesn't support this easily. I'm probably going to leave it as is for the foreseeable future...I think selecting a row serves well enough as a horizontal guide. > One item that you didn't list is resizing of the display window when the > pick screen is used to enter text. Hmm...the main window resizes automatically, but dialogs don't. I'll see what I can do about this. > Another > "VERY USEFUL" item is encrypted files/fields, but this is not critical > since there are several programs for the Z that already provide this > functionality. I'll add it to the TODO list; hadn't really occurred to me. > I found the directory where portabase stores the database, but I can't > find where it stores the exported data file. If I specify a full path > for the exported data file, it doesn't show up where I specified. Am I > doing something wrong, or is this a bug? This was a bug in 1.0; it wasn't creating the output directory if it didn't exist. In 1.1 it gets created correctly and appears in the Documents tab. Should also be editable in the standard text editor app (output file is mime-type text/x-csv, the text editor allows you to edit files with any text mime-type). > The ability to import/export CSV files is critical to me. I've been > using a handheld PC since the HP95LX came out in 1991, and I'd be lost > if I couldn't move data files among different platforms easily. I'm > still using the HP200LX as my primary handheld PC, but portabase, if it > had multiline text fields, would tip the balance in favor of the Zaurus. Well, PortaBase has multiline text fields now. ^_^ > I wish I had the time/skills to help with the programming, but I don't. > I'd be happy to help with beta testing, though. I'd also be happy to > contribute Perl scripts for reformatting CSV files, if there is any need > for that sort of thing. If you could test out 1.1 and let me know of any problems or quirks you find, that would be great. And if you need to pre-process CSV files, let me know why and I might be able to enhance the import feature to handle it for you (like allowing you to specify a non-comma delimiter or use "true"/"false" instead of 0/1 for boolean fields). Jeremy __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ |
|
From: Jeremy B. <ml...@ya...> - 2002-10-28 07:08:00
|
I just released PortaBase 1.1; it's available from the Sourceforge project page at: http://sourceforge.net/projects/portabase Summary of Changes ------------------------ Version 1.1 fixes all of the bugs that have been reported for version 1.0, and also adds suport for Note columns (muli-line text entries) and sorting on multiple columns. Installation ------------ Note that there are *two* packages that must be installed in order to run PortaBase; since many people didn't realize this for version 1.0, they are now only distributed together in a zip file along with the README file. First install the libmetakit1 .ipk file onto the Zaurus, then install the portabase .ipk file. (The MetaKit library is packaged separately because it is likely to be used by other applications in the near future.) The libmetakit1 package hasn't changed since PortaBase 1.0, so if you already have it installed you only need to uninstall the old portabase package and install the new one. Once both packages have been installed, PortaBase can be launched from the Applications tab and the two .ipk files may be safely deleted. Changelog extract ----------------- 2002-10-28 JMB Multiple column sorting Added support for sorting on multiple columns. 2002-10-26 JMB Note column type, minor bugfixes Added support for "Note" columns (a.k.a. multi-line text fields). Count change of view to "All Columns" as a change that the user should be prompted to save before closing. Removed help file sentence about ".csv" being appended to export files; true in the test environment, but apparently not on the Zaurus. 2002-10-22 JMB View editor crash bugfix Fixed a crash that occurred when saving changes to an existing view. 2002-10-21 JMB Fixed CSV export The text/x-csv directory is now created if it doesn't exist, and a ".desktop" file is created so the CSV file appears in the Documents tab. __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ |
|
From: Jeremy B. <ml...@ya...> - 2002-10-28 06:43:10
|
Just released PortaBase 1.1, which I think fixes all the issues you mentioned; in order: 1- The ".csv" is appended in the test environment on my desktop, but not on the Zaurus. So I struck the line about it getting appended from the help file; if you want it, just type in a file name that ends in ".csv" 2- The view editor had a bug where it would crash if you clicked "OK" after editing an existing view (whether you made any changes or not); this has been fixed. If you're seeing something else that persists in 1.1, please give me a test case so I can track it down. I have deleted columns that are used in views, and it seems to work... 3- I reworked the CSV import code in order to allow import of multi-line fields for Note columns, and I think I fixed this bug in the process; let me know if you still have problems with it. The new features added in 1.1 beyond bugfixes are "Note" columns (which allow large text blocks containing newlines) and sorting on multiple columns. Downloads are available from the project page: http://sourceforge.net/projects/portabase Jeremy --- Gérard Manchot <ge...@pe...> wrote: > On Mon, 21 Oct 2002 15:09:04 -0700 (PDT) > Jeremy Bowman <ml...@ya...> wrote: > > You didn't miss anything, this looks like a genuine bug...it tries > > writing the output to /home/root/Documents/text/x-csv/ but apparently won't > > create the directory if it doesn't exist. I'll fix this in a 1.1 release > > after waiting a week or so for more feedback, in the meantime you can just > > create that directory and it should work fine (just tested on my Zaurus.) > > Looks like I need to create a matching .desktop file for it to show up in > > the Documents tab...will do that for 1.1 also. > > > > Thanks for the feedback, > > > > Hi ! > > Of course this worked like a charm. Thanks a zillion times, I really like it. > Three features you may already know of : > > 1. the exported file does not receive its .csv extension > 2. more aggravating : (I think that) deleting a column used in a view > blocks the access to that db completely. > 3. imports fail if the last column to be imported is empty, even if there is > a > comma. > > Once more, thx for the software, it's great ! > > Gerard > _______________________________________________ > http://www.oneweb.be - free high speed internet __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ |
|
From: Jeremy B. <ml...@ya...> - 2002-10-22 23:30:56
|
Ok, this makes vote #3 for "don't provide downloads of the portabase .ipk independent of the libmetakit .ipk". You need the other .ipk file that's available from the download section of the Sourceforge project page. As mentioned in the release notes (which I guess are easy to miss if you aren't familiar with the Sourceforge site layout) and briefly on the PortaBase homepage, this package should be installed before portabase (although installing it after will probably work too). It isn't included in the application package because it will probably be used by other applications in the near future; including it with each one would break all the others when one was uninstalled (because it would delete the library). Version 1.1 will be downloadable only as a zip file containing both .ipk files and a README file; hopefully that will eliminate (or at least reduce) the confusion. Jeremy --- Senthil Mummachi <mse...@ya...> wrote: > Hi Jeremy, > > Today I was looking about your program PortaBase from > www.killefiz.de/zaurus. This seems to be wonderful and this is the one I > was looking for(which is equivalent to 'Data' application in my Psion). > > I downloaded the ipk file and installation went fine without any problem. > But, when I click the icon nothing happens. The application is not getting > loaded. Then, I tried from Terminal. This time it gave me the following > message: > "error while loading shared libraries: libmk4.so: cannot load shared > object file: No such file or directory" > > I searched for libmk4.so in my Z. I couldn't find one. Does the ipk > provide this file or I'm missing something? > > Please help. I really want to use this program. > > Thanks in advance. > > Regards > Senthil > > > __________________________________________________ > Do you Yahoo!? > Y! Web Hosting - Let the expert host your web site > http://webhosting.yahoo.com/ __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ |
|
From: Jeremy B. <ml...@ya...> - 2002-10-22 23:14:53
|
Just fixed in CVS; there was a bug in the logic for updating the view's column order. This and other fixes/enhancements will be released with version 1.1 in a week or so. Jeremy --- Mike Luntz <ml...@cf...> wrote: > Jeremy, > > When trying to edit a view, Portabase crashes. This seems to > occur whether or not I actually make any changes to the > view. When exiting the editor (OK) the application crashes. > Has anyone else reported this problem? > > Mike __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ |
|
From: Jeremy B. <ml...@ya...> - 2002-10-22 13:35:37
|
> import doesn't list any files, I get an empty window > (and I have file sin the DOcumet directory and home ending in csv and also > CSV in case it was a case issue). Do these files show up in the Documents tab? I think it only looks at files that appear there; code-wise, it's just a filter for mime-type text/x-csv, which the PortaBase installation maps to files ending in ".csv". The process that works for me is: 1- Install PortaBase 2- Transfer "blah.csv" files to the Zaurus through Qtopia Desktop 3- Those files now appear in the Import file selector If you're creating the files on the Zaurus via texteditor or such, they may get treated as text/plain instead of text/x-csv. If none of this helps, let me know how you're creating/transferring the files so I can try it and debug the process. At the very least, I should document whatever you're doing that doesn't work for other people's benefit... > Export asks for a filename but after enering > a name doesn't make a new file, I even tried giving a full pathname. I did a > "find / etc." to check. Fixed this yesterday; it's failing to create /home/root/Documents/text/x-csv if it doesn't exist. For a quick fix, just create this directory. The proper fix (which also makes the exported files show up in the Documents tab) has been checked into CVS on Sourceforge and will be released with PortaBase 1.1 in a week or so. > I also have afeature request. Is it possible/easy to > add support for strings with emedded carriage returns (\n)? I've a few palm > database with a columns that conatin multiple carriage returns. This would be the "multiline text column type" from the todo list...the underlying storage mechanism already handles this, I just need to use different GUI widgets to enter and display the content. Shouldn't be too hard, I'll see if I can fit this in for 1.1 also. Thanks for the feedback, Jeremy __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ |
