Issue 40427

Summary: Palm Expense Wizard Needed
Product: Calc Reporter: tcblack <t.c.black>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 1.1.3Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
URL: http://www.famechurch.net/expense.pdf
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Zip file of both the db and the .txt (comma separated) palm expense files.
none
text version of Palm Expense Data
none
DB version of the Palm Expense Data none

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 ~