Transactons view and export

Share your cool Custom SQL reports or Lua scripts with other mmex users

Transactons view and export

Postby Texicantom » Fri Mar 30, 2012 3:38 pm

I am not a sql programmer. I am new to Money Manager EX and I think it is great except for a Standard Check book register styple view and export.
I need a script so that I can view this requested report on screen and export it to excel for printing.
(my wife is visually impaired so I have to enhance the print for her to be able to see it and I really need it in a check book style register format for her to quickly understand it.)
Right now I have 1 checking account and two savings accounts.
Fields> Account View: Viewing all Transactions: Date: Number: Payee: Category: Withdrawal: Deposit: Balance (running): Notes:
Much like what you see on the "Bank Accounts" account View.
I searched the many posting, tried a few of the scripts, I even tried to edit them to make them work but again not a sql programmer.
Would someone please help me out with this?
Thanks
Texicantom
Texicantom
New MMEX User
 
Posts: 4
Joined: Fri Mar 30, 2012 9:25 am

Re: Transactons view and export

Postby Nikolay » Fri Mar 30, 2012 10:28 pm

I am not understand what you need exactly...
May be that helps:
viewtopic.php?f=12&t=1584
it may be changed to export only last week, for example...
Nikolay
MMEX Developer
 
Posts: 1173
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia

Re: Transactons view and export

Postby Texicantom » Sat Mar 31, 2012 9:04 am

Thanks for your assistance and i do not understand the script you gave me. I put it in as a coustom report and all I got was the word Date.
Basicly I need two things.
1. a display mode that looks like the one you see when you look at a bank account now but with less fields
(I have 3 accounts)
All transactins for Account XYZ
Date: Number: Payee: Category: Withdrawal: Deposit: Balance (running): Notes:
12/12/2012 2042 Walmart Clothes $25.00 $1,000.00 New blue jeans
12/13/2012 001 Texican Salary $550.00 $1,550.00 Auto deposit pay check

2. I need to be able to select the report once generated and print to file or export to csv so that I can plug it into excel, modify accordingly, and print.

Hopes this helps you help me.
Thanks again
Texicantom
New MMEX User
 
Posts: 4
Joined: Fri Mar 30, 2012 9:25 am

Re: Transactons view and export

Postby Nikolay » Sun Apr 01, 2012 3:21 am

viewtopic.php?f=12&t=804
Try that report.
Change $Наличные to proper name of your account.
Nikolay
MMEX Developer
 
Posts: 1173
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia

Re: Transactons view and export

Postby Texicantom » Mon Apr 02, 2012 9:10 am

Wow excellent it is all there except The deposit and withdrawal fields do not reflect the .00 unless there is and amount after the decimal.
500.00 displays 500 500.01 displays 500.01 but I can deal with that if need be.

Now the next step how do I export That specific file as a CSV file?
Last edited by Texicantom on Mon Apr 02, 2012 9:18 am, edited 1 time in total.
Texicantom
New MMEX User
 
Posts: 4
Joined: Fri Mar 30, 2012 9:25 am

Re: Transactons view and export

Postby Nikolay » Mon Apr 02, 2012 9:17 am

Try export report to html then open it in excel.
Nikolay
MMEX Developer
 
Posts: 1173
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia

Re: Transactons view and export

Postby Texicantom » Mon Apr 02, 2012 9:24 am

Ok I did not think of tht one. It works GREAT! Your are a outstanding! Thanks.
Texicantom
New MMEX User
 
Posts: 4
Joined: Fri Mar 30, 2012 9:25 am


Return to Custom SQL and Lua Scripts

Who is online

Users browsing this forum: Ayilslnhe and 1 guest

cron