Home → Suggestions →

Include "Skip" on import

• Edit

Jason

Feb 08, 2016 @ 12:56 PM

Is it possible to include a checkbox option that allows me to skip the first line or better, to skip the lines i defined in the "Text-File Importer" extension?
See Attachment for a example.
Thanks..

Jason

• skip1.png 33.5 KB

1. Support Staff 1 Posted by Jenny on Feb 08, 2016 @ 01:43 PM

   

   Hi Jason,

   Within the text file importer, and the window you have attached in your screenshot - you can select the option 'ignore' for the field, which is essentially the same as skipping. It is the bottom option on the drop down list.

   Please try this, and let me know if it does not provide the information you require.

   Jenny
   Infinite Kind Support

   • Edit

2. 2 Posted by Jason on Feb 08, 2016 @ 02:19 PM

   

   Sorry, I think there is a misunderstanding.
   Yes, you are right, I can ignore a column in that screen, but I can not ignore lines.
   I would like to ignore lines, for example: just the fist line or the fist 10 lines or what ever I put in the numeric box..

   Thank You
    Jason

   • Edit

3. Support Staff 3 Posted by Jenny on Feb 08, 2016 @ 02:38 PM

   

   Hi Jason,

   Sorry for the confusion, and thanks for explaining. I now understand the feature you require.

   Thanks for the suggestion for improving Moneydance! I've filed a ticket in our ticketing system with your suggestion, so the developers will be looking into it.

   Can you let me know the reason you wish to skip these transactions? Is this data being imported from your financial institution?

   Jenny
   Infinite Kind Support

   • Edit

4. 4 Posted by Jason on Feb 08, 2016 @ 02:45 PM

   

   Hi Jenny,

   thanks.. yes, they are csv files from my financial institutions.
   They don't support standard online banking protocols, so I rely on them very much.
   This is needed as two of my banks put header and other stuff I currently need to remove manually before I import with the Text File Import extension.

   Thanks,
   Jason

   • Edit

5. Support Staff 5 Posted by Jenny on Feb 08, 2016 @ 02:58 PM

   

   Hi Jason,

   Currently, I would suggest manually amending the file before importing into Moneydance, as you have been doing. I can understand your frustrations doing this each time you need to import data.

   As the suggestion ticket is attached to the discussion, we will notify you of any updates.

   I would also suggest contacting your bank and letting them know of the issues you are encountering. They may be able to advise the reasons for including this extra information with your transactions, and they can take note of your suggestion to exclude this data from your download.

   Jenny
   Infinite Kind Support

   • Edit

6. 6 Posted by stashu.pub on Mar 26, 2016 @ 08:41 PM

   

   Hi Jason,

   csv importer does that and more. header and footer lines. saves configs, etc...

   https://github.com/stant/mdcsvimporter2015/releases/tag/v20

   find instructions: custom-reader-config....doc here:
   http://help.infinitekind.com/discussions/online-banking/742-conversion-of-either-xls-or-csv-into-something-my-moneydance-for-mac-can-import

   • Edit

7. System closed this discussion on Jun 25, 2016 @ 08:50 PM.