763 users online (135 members and 628 guests)  


Websleuths News


Page 1 of 5 1 2 3 ... LastLast
Results 1 to 15 of 61
  1. #1
    Join Date
    Jul 2008
    Location
    Orlando
    Posts
    2,097

    Lightbulb Ideas and Input on Creating a Case Reference Library

    Quote Originally Posted by Just Jayla View Post
    I still owe you a link to the person that indicated CA was mad at KC for "dumping" Caylee on her during her vacation week....Now I am not sure if it was CA or LA, or maybe even SP-But I will keep my ears open as I listen to old interviews and post as soon as I find it.
    FWIW, I remember that line too, but also don't remember who/where from.

    What we need is a searchable database, with all transcripts and documents entered in, cross-referencing SA page numbers, doc dump date, etc. Any techies have the time and know-how to put one together?

  2. #2
    Join Date
    Jul 2009
    Location
    At the lake
    Posts
    1,622
    Quote Originally Posted by Muzikman View Post
    FWIW, I remember that line too, but also don't remember who/where from.

    What we need is a searchable database, with all transcripts and documents entered in, cross-referencing SA page numbers, doc dump date, etc. Any techies have the time and know-how to put one together?

    Hey Muzikman,

    I'm up for anything, volunteering wise. Just give me an assignment and some general instructions. As for the comment about Cindy being annoyed, I believe came from the grandmothers emails.

    Reading these depositions are going to force me to take up drinking and smoking before it ever ends, I swear. Was George's Grand Jury testimony released yet?

    One last thing. From reading George's deposition, there could be some negotations in place for a movie or book. I would really like to see a massive petition against any corporation or publishing company that would make it very clearly what we as the public feel about anyone doing business with this family and our determination to boycott against them.

    Novice Seeker
    Disclaimer: Any and All comments by me are my thoughts and opinions

  3. #3
    Join Date
    Jul 2008
    Location
    Orlando
    Posts
    2,097
    Quote Originally Posted by Novice Seeker View Post
    Hey Muzikman,

    I'm up for anything, volunteering wise. Just give me an assignment and some general instructions.

    <snip>

    Novice Seeker
    Can't really instruct you, as I don't know how to create a good database.

    But something that all documents could be entered into as PDF's somehow (or maybe converted to Word?) and searchable would be great...

  4. #4
    Join Date
    Sep 2008
    Posts
    2,806
    Quote Originally Posted by Muzikman View Post
    Can't really instruct you, as I don't know how to create a good database.

    But something that all documents could be entered into as PDF's somehow (or maybe converted to Word?) and searchable would be great...
    I know when I have gone on that illusive "search" for a doc in a pdf format, I would have loved to have not only the date it was released, but the date the interview or depo was taken. They are so out of chronological order. I thank Patty G for starting it, and it was great in the beginning months, but I find now I actually have to go there to Patty G's first, cross reference what the daily news thread have and go back and forth between the two until I find what doc I am searching for.

    The other issue I have is purely self-inflicted. When I d/l a specific doc I change the title name so I know what I am looking for in my computer. Lately I have been including the media outlet and their number in my title. It does make it easier to go back and re-read a specific one.

    By the way, MM .... on my MBP I cannot convert a pdf into a word doc. I tried, Lord knows but it wouldn't do it for me. If you did it, please let me know your secret. Thanks. cz

  5. #5
    Join Date
    Jul 2008
    Location
    Orlando
    Posts
    2,097
    Quote Originally Posted by countzero View Post
    I know when I have gone on that illusive "search" for a doc in a pdf format, I would have loved to have not only the date it was released, but the date the interview or depo was taken. They are so out of chronological order. I thank Patty G for starting it, and it was great in the beginning months, but I find now I actually have to go there to Patty G's first, cross reference what the daily news thread have and go back and forth between the two until I find what doc I am searching for.

    The other issue I have is purely self-inflicted. When I d/l a specific doc I change the title name so I know what I am looking for in my computer. Lately I have been including the media outlet and their number in my title. It does make it easier to go back and re-read a specific one.

    By the way, MM .... on my MBP I cannot convert a pdf into a word doc. I tried, Lord knows but it wouldn't do it for me. If you did it, please let me know your secret. Thanks. cz
    http://www.apple.com/downloads/macos...converter.html

    Agree that date released, date statement taken, SA Page #'s etc would be really helpful.

    I have downloaded a shareware Mac program called Docs that might be able to do what I want it to search-wise, but haven't had time to play with it yet....

  6. #6
    Join Date
    Sep 2008
    Posts
    2,806
    Quote Originally Posted by Muzikman View Post
    http://www.apple.com/downloads/macos...converter.html

    Agree that date released, date statement taken, SA Page #'s etc would be really helpful.

    I have downloaded a shareware Mac program called Docs that might be able to do what I want it to search-wise, but haven't had time to play with it yet....
    Got it. You are da man. Thank you so much.

  7. #7
    Join Date
    Aug 2008
    Posts
    10,875
    Quote Originally Posted by Muzikman View Post
    Can't really instruct you, as I don't know how to create a good database.

    But something that all documents could be entered into as PDF's somehow (or maybe converted to Word?) and searchable would be great...
    Tell me what you want and I'll be happy to create the database for you and pass it along. I have a few ideas, I'll throw one together tomorrow, you can check it out and decide what more you'd like.

    I take it we want a MAC version?

  8. #8
    Join Date
    Oct 2008
    Posts
    2,319
    ThoughtElf - are you thinking of putting it together in Excel? If so, you could assign columns to various things like date, media outlet, type of document, etc. and we could alpha sort them by sub-heading that way. Is that what you had in mind?
    "Anyone who has the power to make you believe absurdities has the power to make you commit injustices" - Voltaire

  9. #9
    Join Date
    Jul 2008
    Location
    Orlando
    Posts
    2,097
    Quote Originally Posted by ThoughtElf View Post
    Tell me what you want and I'll be happy to create the database for you and pass it along. I have a few ideas, I'll throw one together tomorrow, you can check it out and decide what more you'd like.

    I take it we want a MAC version?
    Mac would be nice, I could deal with Windoze if I HAD too, I have Bootcamp...

    That would be great, and could make finding detailed info easier and faster for everyone, leaving time for more Sleuthing...

  10. #10
    Join Date
    Aug 2008
    Posts
    10,875
    Quote Originally Posted by Muzikman View Post
    Mac would be nice, I could deal with Windoze if I HAD too, I have Bootcamp...

    That would be great, and could make finding detailed info easier and faster for everyone, leaving time for more Sleuthing...
    I did a bit of research. It would be much easier for me to stick with sql than to fart around with FilemakerPro. I can get a head start by simply bastardizing a media library template in Access.

    So get out Bootcamp.


  11. #11
    TakeNote's Avatar
    TakeNote is offline Mother to little post it my boy wonder & Founding Member of AFKBPOFPOPL
    Join Date
    Sep 2008
    Location
    chasing a super hero
    Posts
    6,187
    I want some of ya'al's techno/techie (like Elfie says) brains

    Im only good at the enter button and refresh....but...i am able to now give some cute little smily guys with out going to advanced and looking them up......like...
    Last edited by TakeNote; 10-18-2009 at 11:01 PM.

  12. #12
    Join Date
    Aug 2008
    Posts
    10,875
    Quote Originally Posted by cecybeans View Post
    ThoughtElf - are you thinking of putting it together in Excel? If so, you could assign columns to various things like date, media outlet, type of document, etc. and we could alpha sort them by sub-heading that way. Is that what you had in mind?
    Hi CecyBeans,

    I could do that very easily, but that wasn't what I actually had in mind. I was thinking of just taking an Access db template for a media library and making it our own. The reasons why I was thinking of doing it that way is because I can easily repurpose already existing elements/tables like this:

    • 'Genre' - will be changed to 'Subject' - i.e. motion hearings, interviews, depositions, etc.
    • Media Type - like cd, book, dvd would be altered to reflect - print, video, audio, online blog, etc.
    • Say I wanted to document a depo. By bastardizing the template for say an 'album' (renamed by genre), I can then use the fields for 'song', 'author', 'length', etc. to actually record the keynotes, speaker and page/lines.
    • As well, we can store video/audio clips in it
    Probably sounds like Greek to many, but it is actually pretty easy to swap field labels out in an entire access/sql database and not recreate the wheel from scratch, yet still end up able to really use the inherant search capabilities and already functioning reports.


    That's where I was heading. Leave it with me for a day or two and I'll drop a sample on you guys. Alternately, I could whip an excel workbook/DB together faster than you can go gather all the links you want.

    End-user's choice. To you guys, it will just look like a nifty little program, nothing techie.
    Last edited by ThoughtElf; 10-18-2009 at 10:55 PM.

  13. #13
    Join Date
    Jul 2008
    Location
    Orlando
    Posts
    2,097
    The Access db sounds really interesting! Seems like the search capabilities would be better.

  14. #14
    Join Date
    Sep 2008
    Posts
    1,143
    Quote Originally Posted by ThoughtElf View Post
    Hi CecyBeans,

    I could do that very easily, but that wasn't what I actually had in mind. I was thinking of just taking an Access db template for a media library and making it our own. The reasons why I was thinking of doing it that way is because I can easily repurpose already existing elements/tables like this:

    • 'Genre' - will be changed to 'Subject' - i.e. motion hearings, interviews, depositions, etc.
    • Media Type - like cd, book, dvd would be altered to reflect - print, video, audio, online blog, etc.
    • Say I wanted to document a depo. By bastardizing the template for say an 'album' (renamed by genre), I can then use the fields for 'song', 'author', 'length', etc. to actually record the keynotes, speaker and page/lines.
    • As well, we can store video/audio clips in it
    Probably sounds like Greek to many, but it is actually pretty easy to swap field labels out in an entire access/sql database and not recreate the wheel from scratch, yet still end up able to really use the inherant search capabilities and already functioning reports.


    That's where I was heading. Leave it with me for a day or two and I'll drop a sample on you guys. Alternately, I could whip an excel workbook/DB together faster than you can go gather all the links you want.

    End-user's choice. To you guys, it will just look like a nifty little program, nothing techie.
    You techies really impress me!!
    Sounds awesome!

  15. #15
    Join Date
    Oct 2008
    Posts
    2,319
    Quote Originally Posted by Muzikman View Post
    The Access db sounds really interesting! Seems like the search capabilities would be better.
    You're right about Access having better search capabilities. It may be harder to download and manipulate in a web-based situation than Excel (that's been my experience). But we can certainly play around with it to see what works.

    What is cool is that if you come up with a good template for the types of categories that need catalogued for searching, Tricia can use it going forward for any case that needs to archive and search docs.
    "Anyone who has the power to make you believe absurdities has the power to make you commit injustices" - Voltaire

Page 1 of 5 1 2 3 ... LastLast