Efficient and affordable software for Macintosh - Maker of MaxBulk Mailer, eMail extractor, eMail Checker, e-Mail Bounce Handler

Home

Products

Downloads

News

Store

Support

Forums

Forums


 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
connecting 'type' info on txt-import

 
Post new topic   Reply to topic    Maxprog Forum Index -> iCash
Author Message
Ward



Joined: 13 Apr 2008
Posts: 6

PostPosted: Fri Apr 25, 2008 7:06 pm    Post subject: connecting 'type' info on txt-import Reply with quote

Q1:
My bank-mut-file include codes which shows what kind of transaction has been made (like 'GA' for 'ATM withdrawals')

How can I connect these codes to the 'type'-field while importing a comma-delimited mut-file???

And then recognize 'GA' and replace it in a more human 'ATM withdrawal'?

Q2:
Is there a possibility to add extra fields to the import-filter?
for example, my bank-txt file contains 4 rows on 'remarks', the importfilter just 1.
Back to top
stanbusk
Site Admin


Joined: 28 Dec 2005
Posts: 1967

PostPosted: Mon Apr 28, 2008 8:25 am    Post subject: Reply with quote

#1 Right now you have to do that manually, until we create a rule editor.

#2 In fact we one have one comment field.

What kind of file is this?
Back to top
Ward



Joined: 13 Apr 2008
Posts: 6

PostPosted: Mon Apr 28, 2008 9:54 am    Post subject: Reply with quote

This is a comma-delimited export file form Rabobank, a common dutch bank.

1 export-line looks like this:

"0335968244","EUR",20080102,"D",333.33,"P0129637","OWM AGIS ZORGVERZEKERING",20080102,"MA","","BETALINGSKENM. 1001080100549053","AGIS ZORGVERZEKERINGEN","NUMMER VERZAMELBLAD* 100583943","PERIODE 200801","",""

I'd rather import this file directly into iCash, and be able to customize the filter so no data will be lost on import. This data contains valueable information that can be used with the future rule editor too.

Otherwise maybe number of presetted import filters could be generated for common banks?

this file will not be imported correctly so I use this script in the terminal to convert it to a .qif file.

My bank allows me to export a file with multiple bank-account-details in it. It also keeps track of the last export-request-date so it's very easy to export 1 file with all updated transactions which prevents duplicates in iCash after import. With the future rule editor the import filter could recognise the account so iCash will be almost a hands-free application!

Thank you for improving iCash so intensively! Great job!
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Maxprog Forum Index -> iCash All times are GMT
Page 1 of 1

 


Powered by phpBB © 2001, 2005 phpBB Group
captcha mod by phpbb-security.com

Home

Products

Downloads

News

Store

Support

Forums


Maxprog ® - MAX Programming, LLC - © 2001-2006 - All Rights reserved
Company Info | Site Map | Legal Notice | Privacy Policy | Jobs