Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Palm Expense Wizard Needed|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description tcblack 2005-01-11 18:07:38 UTC
Palm OS based PDA computers by default include a program for recording Expenses. Currently there is an ability to produce automated Expense Report Spreadsheets for Microsoft Excel as well as Lotus Smartsuite's 123 Spreadsheet. I would like a wizard that would import standard Palm OS Expense database and generate an expense report from the PALM data. An example can be found at: http://www.famechurch.net/expense.pdf
Comment 1 frank 2005-01-13 10:08:28 UTC
One for requirements. Frank
Comment 2 lohmaier 2005-01-15 19:48:06 UTC
please attach one of the standard Palm OS Expense databases I guess it should be pretty easy to write a macro that does the job (or maybe this isn't even necessary). But if the database format is proprietary (no driver available) this will be harder...
Comment 3 tcblack 2005-01-15 23:12:38 UTC
Created attachment 21556 [details] Zip file of both the db and the .txt (comma separated) palm expense files.
Comment 4 tcblack 2005-01-15 23:13:27 UTC
Ok, there are two options, the palm database format and a text (coma delimited?) format. I suppose launching the wizard would need to offer a browse dialog to locate the database. I've enclosed both formats with a few test entries for your enjoyment. :-)
Comment 5 lohmaier 2005-01-16 14:43:24 UTC
$ unzip expense.zip Archive: expense.zip skipping: expense.db unsupported compression method 12 skipping: expense.txt unsupported compression method 12 Please use a stnadard compressin method (or no compression at all) and upload again. Thanks.
Comment 6 tcblack 2005-01-16 21:40:23 UTC
Created attachment 21580 [details] text version of Palm Expense Data
Comment 7 tcblack 2005-01-16 21:42:07 UTC
Created attachment 21581 [details] DB version of the Palm Expense Data
Comment 8 tcblack 2005-01-16 21:43:29 UTC
Sorry about the wrong format, It's a standard ZIP (Well if winXP creates a "standard" zip.
Comment 9 ace_dent 2008-05-15 13:47:49 UTC
Thanks for info. Removed 'needmoreinfo'. Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~