DBTC Trades, POST COMPLETED TRANSACTIONS HERE

Discussion in 'DBTC - Info and Discussion' started by sfsuphysics, Jun 10, 2007.

  1. sfsuphysics

    sfsuphysics Supporting Member

    Yesterday at the meeting one of the members came to me with a suggestion for somewhat automating the DBTC so that users could update it as they complete transactions and trades and tracking of said corals. Now I'm not a computer wiz on the software side of things, so I thought up this simple solution, if someone who's handy with webpages/programming/idea thinkin' can come up with something else I'm all ears.. er eyes.

    The way it is now it's almost impossible for me to keep up with this program unless I check for new messages every day and track them on a daily basis which I don't have the time nor desire to do quite frankly, every time I do an update I literally have to go back to day one and check all the corals/trades that went on which is a helluva lot of work.

    So the purpose of this thread, is for those who have given/received corals, to post that transaction in this thread! Now if you want to post in your own thread that's fine, but for purposes of tracking chains I will stop looking at individual threads and only do statistics from what's posted here. Perhaps those who are giving corals can also make part of their "Standard DBTC rules" the receiver must post what they got so that there's one less thing for them to do... just an idea ;)

    So the format that I would like is simple

    <Who gave the coral> - <What coral got exchanged> - <Who got the coral>

    As simple as that, then updating the statistics is as simple as looking from the date I last updated and seeing what was posted after.

    I'll do one last update of the messages either today or tomorrow, however starting Monday June 10, 2007 I will not be looking at individual threads as far as statistics for this program are.

    Thank you for your time, and keep the trading going!
    Mike.
     
  2. zepplock

    zepplock Guest

    Since I was "one of the members" I probably could create a simple PHP script where you can state your name, what coral you've got, and from which person and then generate stats on each particular frag and person.

    If anyone with PHP/SQl skills wants to help (hey this is Bay Area) - please PM me.
     
  3. kinetic

    kinetic Webmaster

    [quote author=Zepplock link=topic=2136.msg21096#msg21096 date=1181499312]
    Since I was "one of the members" I probably could create a simple PHP script where you can state your name, what coral you've got, and from which person and then generate stats on each particular frag and person.

    If anyone with PHP/SQl skills wants to help (hey this is Bay Area) - please PM me.
    [/quote]

    haha sure I can help =) We need a webserver with a simple MySQL database. This project may be too simple to use any complex framework, so we could do simple PEAR database transactions.
     
  4. zepplock

    zepplock Guest

    [quote author=kinetic link=topic=2136.msg21110#msg21110 date=1181514812]
    [quote author=Zepplock link=topic=2136.msg21096#msg21096 date=1181499312]
    Since I was "one of the members" I probably could create a simple PHP script where you can state your name, what coral you've got, and from which person and then generate stats on each particular frag and person.

    If anyone with PHP/SQl skills wants to help (hey this is Bay Area) - please PM me.
    [/quote]

    haha sure I can help =) We need a webserver with a simple MySQL database. This project may be too simple to use any complex framework, so we could do simple PEAR database transactions.
    [/quote]

    I have a hosting we could use.
    You have IM?
     
  5. Mr. Ugly

    Mr. Ugly Past President

    Easier to track by frags than by person.

    The 2nd template I set up works that way, Mike.

    Every frag is a new record in the database. Just add fields for whatever you want to track.

    coral/original donor/from/to/generation/date

    Underoos Favia/Mike/Mike/Eileen/1/feb. 2, 2007
    Underoos Favia/Mike/Mike/Perry/1/feb. 2, 2007
    Nuclear Mishap Acro/Mike/Mike/Norman/1/feb. 2, 2007
    Green Nepthea/Jim/Jim/Steve/1/June 9, 2007
    Underoos Favia/Mike/Eileen/Alvin/2/June 9, 2007

    All the other info for people stats, number of frags in the program, list of species etc can be derived easily from the data.

    People can post each frag passed on to a tracking thread as has been suggested.
     
  6. Mr. Ugly

    Mr. Ugly Past President

    So hypothetically, going by the above format, I would just post a new frag like this:

    Pink cap/Mike/Norman/Kenzo/2/March 3, 2007

    Mike could just copy and paste that as a new entry into an Excel spreadsheet.

    Makes it easy to do data analysis.
     
  7. sfsuphysics

    sfsuphysics Supporting Member

    Alright Norman you lost me right around the time you said "Easier" :D
     
  8. Mr. Ugly

    Mr. Ugly Past President

    Well the other spreadsheet I saw had kind of an outline structure. And it went by donor and what was contributed. That's fine if you want to manually/visually go through the info and figure stuff out. And if the focus is on the person.

    If we make each unique frag an entry in a flatfile database, and each field has the information filled in, we/I can use Excel autofiltering or whatever to do data analysis really easily.
     
  9. Mr. Ugly

    Mr. Ugly Past President

    Ok, checked the template... I had been thinking about tracking:

    DBTC Coral Common Name Scientific Name Chain Starter Giver Receiver Offer Date Tranfer Date Frag Generation Frag Status Notes DBTC url


    We can add or subtract fields as appropriate.
     
  10. sfsuphysics

    sfsuphysics Supporting Member

    ok ok, I'll have to fish through it to learn it Norman, but where did you put this template?
     
  11. kinetic

    kinetic Webmaster

    so we're not putting it in fancy PHP SQL ? =)
     
  12. zepplock

    zepplock Guest

    [quote author=kinetic link=topic=2136.msg21153#msg21153 date=1181581021]
    so we're not putting it in fancy PHP SQL ? =)
    [/quote]

    I think we do ;-)
    PM me.
     
  13. sfsuphysics

    sfsuphysics Supporting Member

    [quote author=kinetic link=topic=2136.msg21153#msg21153 date=1181581021]
    so we're not putting it in fancy PHP SQL ? =)
    [/quote]

    For now, no. There's an extremely simple solution at hand, simply post your transactions here. Doesn't require any more work, don't need to do anything fancy, K.I.S.S. (Keep It Simple Stupid) idea works in this instance. If someone wants to work on something fancy elegant on their own, then we'll see what goes of it, however I'm not going to be involved in that.

    So feel free to work amongst yourselves, discuss it, just don't use this thread for discussion please :)
     
  14. Mr. Ugly

    Mr. Ugly Past President

    [quote author=sfsuphysics link=topic=2136.msg21126#msg21126 date=1181531532]
    ok ok, I'll have to fish through it to learn it Norman, but where did you put this template?[/quote]

    ygpm :D
     
  15. fishnfst

    fishnfst Guest

    small blue clove looking polyps/Doug/Doug/raddogz
    " "/Nash
    " "/Dyngoe
    " "/Patchin
    " "/xinumaster

    Bright Green Polyp Encrusting Monti/Doug/Doug/zepplock
    " "/xinumaster

    All frags were delivered on June 09,2007

    Hello Mike if I messed this up let me know and I'll try to fix it :)
     
  16. sfsuphysics

    sfsuphysics Supporting Member

    Thanks Doug that's more than fine.
     
  17. Mr. Ugly

    Mr. Ugly Past President

    We'll get it into the new spreadsheet database.

    Looking good so far :D
     
  18. CitS

    CitS Guest

    Purple Zoa/CitS/CitS/1/Natterjak/May 2007
    Purple Zoa/CitS/CitS/1/Raddogz/May 2007
    Purple Zoa/CitS/CitS/1/dswong01/June 9, 2007
     
  19. skorpinok

    skorpinok Guest

    Neon Green Toadstool / Arnold / Alvin/tonggao / 2 / June 9, 2007
    Neon Green Toadstool / Arnold / Alvin/Zepplock / 2 / June 9, 2007
     
  20. capescuba

    capescuba Supporting Member

    So at the risk of sounding completely nuts, I think I have a solution to this! My company just finished a show case app for Microsoft, called Family Show. The whole concept is geneology and family trees, but with a little imagination I can easily map a "Family" Tree to a "Propagator/Coral" tree ...
    Check out http://www.vertigo.com/familyshow.aspx and http://www.codeplex.com/familyshow for the details.

    I think I'm gonna play with it and then convince Mike this is the way to go ;)
     

Share This Page