I would like a Cleanup Utility to remove split lines split to Imbalance-CD and with no memo and no amount or zero amount on the line

[Yawar Amin]

Hi,

I am forwarding your email to the GnuCash users mailing list, which is a
public discussion forum where everyone can benefit from sharing
questions and answers. To participate in the mailing list, click the
‘Reply All’ button in your email program whenever you get an email from
someone in the list.

Regards,

Yawar

On 2013-01-04 11:14, Rita Hall wrote:
> Dear GNUcash
>
> I have just finished using XL2QIF plus Excel macros and VBA to import
> Quickbooks file data (via a CTDR) into GNUCash.  The very biggest bottleneck
> was importing 29 balance sheet qifs into GNUCash.  I had an idea that I
> think would be relatively easy to implement and only require import of one
> QIF file.  It would also be very convenient for other purposes.
>
> It was easy enough in Excel to turn all my transactions into split
> transactions with zero amount and then import them into the single account
> Imbalance-CD (which was type "bank" for importation and then changed to
> "expense" in hopes the split line to that account would disappear from my
> transactions when GNUCash found that all the memos and amounts on that line
> were zero or blank.  I found and tried a  do a repair transactions menu
> option to see if that helped but it didn't.  The unwanted split to
> Imbalance-CD could only be removed one transaction at a time, even worse
> than the 29 qifs.  Looking at my balance sheet accounts the imports all
> looked good except all transactions showed up, of course, as split
> transactions with that useless line.  So:
>
> I wish you had a little cleanup utility that would remove all Imbalance-CD
> splits from all transactions that had an empty memo and an empty or zero
> amount on that split line.  An alternative would be the ability to record a
> simple macro in GNUCash and loop it thru the transactions in one or more
> accounts, so the process of deleting the unwanted split line by line could
> be automated.  Either of these capabilities would be useful in other
> situations as well.
>
> I know this is more about development than documentation but I lost patience
> trying to find out on the internet who and how to contact.  I hope you can
> forward it to somebody that might be able to write that clean-up utility.
>
> Sincerely,
>
> Rita Hall
> margh at taosnet.com
>
>


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 897 bytes
Desc: OpenPGP digital signature
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20130105/60054e96/attachment.sig>