Page 3 of 4 FirstFirst 1234 LastLast
Results 41 to 60 of 61
  1. #41  
    Same thing is happening to me, TNT.
  2. #42  
    surely we can collaborate & find a solution. Amyone know one of the talented software gurus?

    saw a post about this for 650s when they came out.

    What if we delete one category at a time & see which one most impacts the size? I already tried sorting based on last name and then on company name.

    On almost all of my contacts I start each phone # with *82 to allow my phone # to be displayed to person I'm calling (verizon featurel Could that cause this size increase?

    I don't attach pics to contacts

    I do attach unique ring tones for business callers. I guess I could rule that out by deleting all my work contacts & see if it decreases once those are gone. Of course I have backups.

    I'm hesitant to install other apps until I get this foxed as I figure this size thing will cause other probs.

    Thoughts?
  3. #43  
    Well - I have found out more...not sure what it means. Found by looking in the Contacts DB using Filez...that some files are 20k to 30K. So looked at the details of those large files by (right side of filez - under edit feature)...just scroll down...and finally see where the file I'm looking at which has a huge size is corrupted because it contains part of the next file...or even part of the next two files...and my thoery is that's why the file size is huge.

    So - What I've been doing is starting at the top with the A's and using my treo and my desktop. I use the treo and filez to identify which files are huge...and then on my desktop I change that file from whatever category it's currently listed as to unfiled. So to make this manageable I did the As and Bs and then printed from desktop all the Unfiled As and Bs including their notes. By the way the records look totally normal on desktop with no extraneous records from other files and also looks normal on the treo (unless you look in filez). So - I go to desktop and use my printout of the items that are now classified as unfiled...and re-enter the data and assign it to whatever category it should have been. Then I delete from the unfiled category whatever I've just re-entered. Next I do a hot-sync and set it with desktop overwrites Handheld for Contacts.

    First time I tried it with As and Bs and deleted/re-entered about 45 records...UGGG took 2-3 hours. File size on the Contacts DB went from 8.0 Meg to 7.2 Megabytes.

    I've continued doing this and now gotten through the Cs and am down to 5.7 MB. I have about 1200 entries in all and I'm guessing that something like 200 of them are corrupted. So I've got a lot of work ahead of me.

    What I want to know is what has caused this and how do I prevent it in the future.

    Before I went to all this work I sampled by trying to enter data by treo and sync and then also trying it by desktop and so far have not found a reason for this to get corrupted.

    My working theory is that one of three things caused it:
    1) A while back I was doing both Hot Sync and Wireless Synch on Verizon and would get messages that some files were duplicated or some other message....so wonder if that corrupted files. My understanding is that one program takes apart files and re-assembles them in a different order than the other and we really should not use both programs or will get problems....so I no longer use both. Only use Hot Sync.
    2) I upgraded from a Palm 3, 3e, Viix, T3 and Treo 650...and wonder if somewhere along the way data got corrupted. I remember have lots of problems when I went from viix to T3...never really had data corruption until the T3 and then even more probs with the Treo and from there had experienced probs every 6-9 months....so figure the database was just getting so huge and corrupt that it woudl cause crashes.
    3) Could just be some bizzare issue with the current palm system - maybe NFVS or whatever it's called...and maybe the alleged patch will fix the problems.

    I have noticed that a record I entered just this week got huge. LOL...I entered it via the desktop. I also wonder if I enter a record by desktop and then edit it via treo if that makes it get huge?

    Lots of info here...any insights? I REALLY don't want to have to key in another 200 records, but also don't think it's wise to leave this bloated. I want to install some other software like Datebook and Daynotez etc...but am holdign off until I can get this contacts DB size issue resolved.

    Thanks.
  4. #44  
    I have multiple duplicates of the same contact. How do I delete them? Any ideas, any programs?
  5. #45  
    bump
  6. #46  
    Quote Originally Posted by TNTreoUser View Post
    bump
    ?
  7. kvsnut's Avatar
    Posts
    17 Posts
    Global Posts
    18 Global Posts
    #47  
    TNTreoUser

    This happened to me and I suspect it is caused by an earilier version of Directory Assistance (DA) from Rick Whitt (great program, btw). Unfortunately I have trouble syncing (becuase of the metal contacts) and haven't been able to fix the problem.

    You can see my earlier posts (and link to another thread) regarding this problem.


    lghitis

    There is a tool in Palm Desktop that will look for and delete duplicates.

    Good luck
  8. #48  
    Take a look at DBScan - http://pimlicosoftware.com/support.htm / the actual file link is http://pimlicosoftware.com/dbscan.zip) - see what happens - it removes deleted records and BLOBs (there really is such an animal). The utility is also available in the Datebook6 release file, http://pimlicosoftware.com/datebk6-v60a-s5.zip.

    Ben
  9. #49  
    Quote Originally Posted by bclinger View Post
    Take a look at DBScan - http://pimlicosoftware.com/support.htm / the actual file link is http://pimlicosoftware.com/dbscan.zip) - see what happens - it removes deleted records and BLOBs (there really is such an animal). The utility is also available in the Datebook6 release file, http://pimlicosoftware.com/datebk6-v60a-s5.zip.

    Ben
    dbScan, at this point, only removes corrupt BLOBs from the calendar. CESD, the developer of dbScan, will soon be releasing a new utility that will clean up all databases, which will include the removal of corrupt BLOBs from the contacts db.
    V > Vx > m505 > m515 > T/T > T3 > TC > 650 > 680
    <script type="text/javascript" src="http://download.skype.com/share/skypebuttons/js/skypeCheck.js"></script>
    <a href="skype:wwgamble?call"><img src="http://mystatus.skype.com/balloon/wwgamble" style="border: none;" width="150" height="60" alt="My Skype status" /></a>
  10. #50  
    I forgot that part of the discussion. Thanks! Ben
  11. kvsnut's Avatar
    Posts
    17 Posts
    Global Posts
    18 Global Posts
    #51  
    "CESD, the developer of dbScan, will soon be releasing a new utility that will clean up all databases, which will include the removal of corrupt BLOBs from the contacts db."

    Does anyone know if this new utility has been released yet? Or any better solutions besides manually deleting and readding?

    Thanks
  12. #52  
    Quote Originally Posted by kvsnut View Post
    ...Does anyone know if this new utility has been released yet?...
    Not yet.
    V > Vx > m505 > m515 > T/T > T3 > TC > 650 > 680
    <script type="text/javascript" src="http://download.skype.com/share/skypebuttons/js/skypeCheck.js"></script>
    <a href="skype:wwgamble?call"><img src="http://mystatus.skype.com/balloon/wwgamble" style="border: none;" width="150" height="60" alt="My Skype status" /></a>
  13. #53  
    I have the same problem. My contacts DB is like 6 MB!!!!!!! ARHHHHH! I dont' have another Treo to beam my contacts to or else I would try that solution....
    _________________
    aka Gfunkmagic

    Current device: Palm Pre
    Device graveyard: Palm Vx, Cassiopeia E100, LG Phenom HPC, Palm M515, Treo 300, Treo 600, Treo 650, Treo 700p, Axim X50v, Treo 800w



    Please don't PM me about my avatar. For more info go here.

    Restore your Pre to factory settings using webos doctor and follow these instructions
  14. #54  
    Well, I am having the exact same problem, and cant seem to get it fixed. I tried the delete in desktop method, it gives me the error that was described before, and it doesn't let me fix it... I am working on this since yesterday morning, and desperately need help with this.
  15. Normandie's Avatar
    Posts
    10 Posts
    Global Posts
    27 Global Posts
    #55  
    Quote Originally Posted by aznmode View Post
    Ok here's how I fixed mine!!

    Hotsynced, then after, I opened up my Palm Desktop and went to Contacts. Did Edit>Select ALL and then File>Export Vcard. Saved Vcard on my PC. I then did a Select ALL again and Edit>Delete and deleted all of them. I then did a File>Import and imported the Vcard back. All contacts showed up again. Before I hotsynced I made sure that I set it for 'Desktop overwrites Handheld'. Did a hotsync. After, I checked my ContactsDB and now down to 26k. From 3.3mb to 26k?? I thought something else was wrong, So I made sure and checked some of the contacts that I had multiple #s and emails and they were all still there. Filez still says 199 records. So all is well.

    ALSO GET THIS. When I look up contacts and type a name, it does NOT lag anymore. Before when I type the first letter it takes atleast 5-7 seconds before I can type the 2nd letter. Now it's almost INSTANT! Also no more lag when I scroll down my entire contacts. And no skipping as someone else mentioned. WOHOOO!
    aznmode,

    I know that this thread is old, but I faced the same problem this week, 600 contacts and the file size was 12.2 meg on both the palm 680 and the desktop. I tried the method you mentioned above and now my files is still 600 contacts, but only 125 K. A BIG difference in size and performance. Thanks to all in this thread for the help.

    Have a good day,
    Normandie
  16. #56  
    Ok, this week I ran into a huge problem trying to restore my contacts information from the Palm Desktop. My address.dat on my PC is over 15Meg in size, so when I sync it blows up the sync process.

    Anyway, after trying the suggestions, dbScan, tools check for duplicate, I decided to export the contacts to a tab delimited format. I checked it for corruption and did not find any.

    I deleted the contacts from the Palm Desktop, synced it to archive. It generated all the categories on separate .ABA files which totals less than 6Meg in total.

    I then imported back the contact list to my Palm Desktop. The final address.dat is now 878K which is about the size before I had the corruption.

    Thanks to you all.

    Caveat: After checking records after restore, the Palm Desktop did not convert the CR control characters correctly on the notes section of the contacts. For now, at least it did not drop or truncated the data.
    Last edited by ronbo2000; 03/20/2008 at 12:28 AM.
  17. #57  
    Since the last time this thread was discussed (in 2007), there is a new program out called DBFixIt, which fixes everything very easily, and deletes all corrupted files in PIM's.
  18. #58  
    Quote Originally Posted by Mahootzki View Post
    Since the last time this thread was discussed (in 2007), there is a new program out called DBFixIt, which fixes everything very easily, and deletes all corrupted files in PIM's.
    Agreed. The program is worth every cent. I cleaned up nearly 10M of corrupted data from the contact db, without any loss of data.

    Highly recommended
  19. #59  
    Quote Originally Posted by Mahootzki View Post
    Since the last time this thread was discussed (in 2007), there is a new program out called DBFixIt, which fixes everything very easily, and deletes all corrupted files in PIM's.
    Quote Originally Posted by BCCISProf View Post
    Agreed. The program is worth every cent. I cleaned up nearly 10M of corrupted data from the contact db, without any loss of data.

    Highly recommended
    Yes, I agree, this is worth it if you spotted the issue on your Palm based Treo before you even tried to sync back with the desktop app.

    My concern with this software is that it works only on your device but if you are trying to recover from the Palm Desktop side and your contact DB is already expanded with extra data on the BLOBs on your desktop and you have already hard reset your Treo, then you would need to take two steps:
    1. First step is to sync only your contact data into a clean Treo with the dbfixit software. All other PIM conduits must be set to do nothing except for contacts and Quick Install.
    2. 2nd step, clean up the data with DBFixit and then sync back to desktop with setting for all other PIM conduits set to do nothing and the contact set to Handheld overlays Desktop.


    Yes, the DBFixit software does its job wonderfully. I fully agree however the export step also works with extra work.
  20. #60  
    I'm pretty sure DBFixit can reliably fix the problems (considering the source of the software), but for the times I've had to fix these kind of problems, it seemed simple enough to just use a PC file viewer to find where in the file the blobs were and then use Filez to confirm/correct the offending records.
Page 3 of 4 FirstFirst 1234 LastLast

Posting Permissions