DonorHub ®
Bridging the information gap between you and your staff...

Browse Site by Tags

Showing related tags and posts across the entire site.
  • Donors with numeric values for their names..

    on the web portal, some "donors" appear as numeric values. discovered that we have .. 551 that have this condition.. select donorid , description -- 551 rows returned from donor where 1=1 and isnumeric(description) = 1 they are also in the DesigDonor table.. select * -- 556 rows returned. from...
    Posted to Technical Support (English) by Jim Crozier on 14 Feb 2017
  • Re: Removing Duplicate Users in SQL Database?

    Hi Troy, We could try that but we have many users in this situation. Would it be feasible or advisable to take a snapshot, delete the data server and re sync/re import using our custom access database that we have set up? Basically deleting all designations in the sql data base and re syncing. Thanks...
    Posted to Technical Support (English) by David on 28 Sep 2011
  • Re: Removing Duplicate Users in SQL Database?

    My apologies good sir! I'm not that familiar with Sql and am working with a more experienced senior member to resolve this issue. We can now see from the below screenshots that there are errors with the Sql database and that the TNT sync is not working to remove them. Screenshot #1: Sql Full Join...
    Posted to Technical Support (English) by David on 23 Sep 2011
  • Re: Removing Duplicate Users in SQL Database?

    Hi Troy, Correct me if I'm wrong but we believe this might be a problem with the TNT application itself not querying the Sql database properly? We believe this because: 1. We've pumped Web Users and Webuser Profiles/Designations multiple times during the same day and on different days. 2. We...
    Posted to Technical Support (English) by David on 22 Sep 2011
Page 1 of 1 (20 items)
© 2019 TntWare, Inc. | Privacy | Terms of Use