Username:  Password:
Forgot your username or password?        
     
Home Product Tour FAQ Links Forum Pricing Contact Us Buy Now         
MySF Forums
Home       Calendar
        



Attachments being attached to the wrong... Expand / Collapse
Author
Message
Posted 13/02/2008 12:11:02 AM
Master Member

Master MemberMaster MemberMaster MemberMaster MemberMaster MemberMaster MemberMaster MemberMaster Member

Group: Forum Members
Last Login: Yesterday @ 7:15:10 PM
Posts: 107, Visits: 1,367
After not being too happy with some of the work arounds given to correct errors, I decided to write off my first years input as a learning experience and started afresh.

All is generally going well - it is a lot easier the second time round!! and so far (touch wood) I haven't made any input errors.

However I have discovered one bug that is, well, really bugging me.

I decided to take advantage of the fresh start to attach supplementary documents to transactions (eg contract notes, dividend statements, members contribution forms, ETP statements etc, etc).

Then I had reason to check a few transactions and found that attachments were not being attached to the right transactions.

Eg a listing of members contributions where I had attached a contribution form (MCF) to each transaction was now showing some transactions with 3 or 4 attachments and others with none. The same with some rollovers where 2 ETPs would be attached to some transactions and none to others.

I found that I could remove the wrongly attached documents then re-attached them to the right transaction - and so far they seem to be staying put.

However, I now find I'm losing confidence in the integrity of the database - how can stuff-ups like this happen?

At least with the attachments it is relatively obvious when there is a problem (well, at least if you go and check every transaction). But if fund allocations wander around like this it would obviously be a real problem.

How is the link between the transaction and the attached file maintained - what sort of problem would result in these links being corrupted - and what other problems might this indicate.

I'm now really getting behind with all this so your response is needed urgently.

Neil H.
Post #3799
Posted 13/02/2008 5:33:25 PM
Master Member

Master MemberMaster MemberMaster MemberMaster MemberMaster MemberMaster MemberMaster MemberMaster Member

Group: Forum Members
Last Login: Yesterday @ 7:15:10 PM
Posts: 107, Visits: 1,367
I don't know if there could be any connection, but I'm also seeing a problem with viewing some past bank reconciliations. see separate post.

Neil H.
Post #3801
Posted 13/02/2008 10:59:14 PM
MySF Administrator

MySF AdministratorMySF AdministratorMySF AdministratorMySF AdministratorMySF AdministratorMySF AdministratorMySF AdministratorMySF Administrator

Group: Administrators
Last Login: Yesterday @ 11:32:15 PM
Posts: 133, Visits: 636
Hello,

We can confirm that there is currently an issue with the attachments box where attaching a file to a transaction for example, is not being displayed. The files are being attached correctly but there is a problem with them being displayed.

We have tested several transactions and attached files to them and have found that when you go into the Transaction Reporter and edit those transactions, you can see the files are not being displayed in the attachments box.

If you go to your funds attachment folder within your fund folder, you will see the files are being copied there as they should. We are investigating this issue further and will release a fix for this as part of a software update as soon as possible.

We sincerely apologise for any inconvenience this may be causing you. Please continue to attach files to transactions as normal and when the fix is issued, those files will be displayed correctly in the attachment box.

Kind Regards,

MySF

Post #3804
Posted 14/02/2008 1:54:02 AM
Master Member

Master MemberMaster MemberMaster MemberMaster MemberMaster MemberMaster MemberMaster MemberMaster Member

Group: Forum Members
Last Login: Yesterday @ 7:15:10 PM
Posts: 107, Visits: 1,367
OK, well that would explain why several of the files, which I knew I HAD attached and could, indeed, see in the attachment folder were not displayed against the relevant transaction (or any other transaction for that matter).

HOWEVER, the problem goes deeper than that. As I said in my original post:

"Eg a listing of members contributions where I had attached a contribution form (MCF) to each transaction was now showing some transactions with 3 or 4 attachments and others with none. The same with some rollovers where 2 ETPs would be attached to some transactions and none to others.

I found that I could remove the wrongly attached documents then re-attached them to the right transaction - and so far they seem to be staying put."

In other words, it was not just a problem of the attached file not displaying but with the attachments actually being linked to the wrong transactions - or being displayed as being linked to the wrong transactions, which to all intents and purposes is the same thing.

So your post saying:

"The files are being attached correctly but there is a problem with them being displayed."

Might be true in some cases (eg where the files were in the attachment folder but not seen against any transaction) but would not explain why other attachments WERE being displayed - but against the WRONG transaction.

I seem to have cured the problem by deleting all the transactions that were either not showing or showing against the wrong transaction and then correctly attaching them using transaction reporter.

I think (but am not 100% sure) that the problem arises only when the file is attached when the original transaction is generated and not if the file is later attached to an existing transaction.

Hopefully, the above may assist in debugging.

Neil H.
Post #3807
« Prev Topic | Next Topic »



All times are GMT -6:00, Time now is 2:40am

Powered by InstantForum.NET v4.1.4 © 2010
Execution: 0.500. 13 queries. Compression Disabled.