• Navigation
Results 1 to 5 of 5
  1. #1
    Hyperion Cross
    Join Date
    Jan 2007
    Posts
    8,883
    BG Level
    8
    FFXIV Character
    Kai Bond
    FFXIV Server
    Gilgamesh

    Extremely simple "info collection" system + report capabilities? (PHP/MySQL)

    I am being asked to log some information in .... excel a few months back. I'm getting increasingly frustrated to use it because of the effort needed to move info around and not kill the looks of the spreadsheet. We currently move blocks of info between 8 tabs which is extremely annoying -- not my idea, ideas of the "older" generation people here.

    I wanted something with database capabilities:

    Simplified, it's basically a job ticket that will contain text and maybe a screenshot of the job in question, and then will contain additional entries for each information exchanged (e-mail) -- i.e. e-mail going out and in

    I thought about using some free phpBB or any old forum software to do the job, running my own Xampp server with PHP/MySQL enabled and giving access to maybe 1 other person (we don't need to access it that often). However, what forum software lacks (I believe) is reporting and outputting it into a specific format, I want to be able to quickly look up the amount of tickets (threads) in X forum (say, Open Tickets) and then output it quickly into a spreadsheet for meetings/client viewing.

    Ideally phpBB or equivalent will be excellent for all this simply because it will be easy to keep track of info and move threads around (i.e. between 3 forums, Open Tickets, In Progress, Closed) instead of the squeezing everything into cells. Any update to a "ticket" can be posted as replies without having to fiddle with cells etc (can just paste it in).

    TL:D;DR - PHP/MySQL forum type software to collect information with report outputting capabilities, any suggestions? Similar to a forum in a way it handles info. Preferably free.

    I could make my own but strapped for time

  2. #2
    New Spam Forum
    Join Date
    May 2010
    Posts
    159
    BG Level
    3
    FFXI Server
    Lakshmi

    why not try Access?

  3. #3
    Hyperion Cross
    Join Date
    Jan 2007
    Posts
    8,883
    BG Level
    8
    FFXIV Character
    Kai Bond
    FFXIV Server
    Gilgamesh

    Odd, I thought I mentioned Access, but it seems to be removed. Regardless, Access seems way too fiddly. Plus I'm not entirely sure how to use it fully without having to learn it.

  4. #4
    New Spam Forum
    Join Date
    May 2010
    Posts
    159
    BG Level
    3
    FFXI Server
    Lakshmi

    you could always pay someone to set it up make some forms and you never have to touch the back-end again and it should do all you want and most likely more then you can think of. PM me if you want to work on this option

  5. #5
    Hyperion Cross
    Join Date
    Jan 2007
    Posts
    8,883
    BG Level
    8
    FFXIV Character
    Kai Bond
    FFXIV Server
    Gilgamesh

    Thanks for the offer ; but unfortunately I do not control the spending and no one will really approve of that

    I'll give up the reporting option and just use the forum for myself, and "mindlessly" throw things into the spreadsheet until they realise it sucks to update. When it comes for real info I'll use my own forum and voila, it's there!

Similar Threads

  1. Replies: 13
    Last Post: 2009-07-11, 07:16