Import rule search term > 50 chars

Idea suggested by Darren Green 11 years ago

Please can you allow search terms greater than 50 chars. I have several recurring items that I cannot set sensible rules on because of this.

An example statement item -
STANDING ORDER VIA FASTER PAYMENT TO Name Withheld REFERENCE Custom Text

The 50 chars limit chops off in the name. Even if I use a short name, I cannot get to the reference text to filter on that.

5 Replies

I meant to tag this against the import tool pages.

I also have this.

I have DIRECT DEBIT from INTERNET PROVIDER reference THINGY1 and DIRECT DEBIT from INTERNET PROVIDER reference THINGY2

and need separate accounting codes for both...

Could you just create a rules using THINGY1 and THINGY2?

Just did it in the demo account with a dummy csv and it worked fine.

Kevin, you are right.

I have now used that approach, but it wasn't obvious to me that the rule search text is a full wild card search, and obviously not others as well.

I'd suggest that having a such an artificial limit is not good, especially with the lack of prompt or documentation to explain how rules can work is not ideal.

Hello,

The support team are looking at making more comprehensive guides on the import rules.

The best option I recommend is to look for a common reference in the bank imports.

For example, an O2 phone bill have your bill reference of "6789ABC" then extra details. So it may look like this overall " Call ref BILLTOSEPT30 6789ABC".

The search term which you will use is the 6789ABC to enable good use of the mass update tool. The part before it will always be changing month on month but the common area is the part at the end.

This will need to be done for the other import rules you have on the system.

There is a character lock on the system because it can cause issues with the mass updates if there are too many variables/characters to search for in a specific order. Extending this limit may cause the page to load slowly.

Vanish

Reply to this idea

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are