1. #1
    Forum Member

    Join Date
    Nov 2003
    Posts
    8

    Default Firehouse v5 Question

    I know I might not get an answer here, but here goes nothing... I am working on a new website for my fd. I have a members only section with a unique login for each member. What we want to do is provide training, detail and call attendance details for each user. We are currently using firehouse 5.0 with plans to update to 6.0 shortly... I can do all the coding to display the information on the website, but I need to get the information out of firehouse and uploaded to my database on the internet nightly (well, more precisly, send it to a page to strip all useless data and properly format before saving to my database). Does anyone have any idea on how to do this WITHOUT doing it by hand?

  2. #2
    MembersZone Subscriber
    N2DFire's Avatar
    Join Date
    Feb 2000
    Location
    S.W. Virginia
    Posts
    1,286

    Default

    Firehouse uses Microsoft SQL server for it's data storage.

    Not knowing the breadth and depth of your programming knowledge & skills, I'll simply suggest attaching directly to the database and pulling your data from SQL instead of trying to rip it out of one of the FH generated reports.

    Depending on how your web server is configured, you may be able to pull directly from the SQL server with your page code.

    As to automating the process - this will also depend on your server connectivity and configuration(s). Off-hand I'd suggest writing something in code (C, VB, etc.) and then make the compiled program a scheduled task on one of the servers that runs nightly.

    Best of luck. Coming from someone who's "paying gig" is as a computer programmer - sometimes the projects that look so simple on the surface end up being darn near impossible when you start digging into it.
    Take Care - Stay Safe - God Bless
    Stephen
    FF/Paramedic
    Instructor

  3. #3
    Forum Member

    Join Date
    Dec 2005
    Location
    IL
    Posts
    459

    Default

    You can do it in PHP or Delphi as well rather easily.

  4. #4
    MembersZone Subscriber

    Join Date
    Feb 2005
    Location
    Medina Township, Ohio, USA
    Posts
    3

    Default

    This is what i have done for a lot of firehouse information.
    Please keep in mind i am not a programmer or even a wannabe.
    Go into reports and determine a report that is close to the data you want.
    next make a copy of the report and then strip the fields from the report you don't need.
    next run the report and choose print or output to on the option list

    I export my data to excel (it is what i am most comfortable with)

    and then hopefully the data will be easily tranferred to your webpage

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting hired already...geez
    By redepidermis345 in forum Hiring & Employment Discussion
    Replies: 2
    Last Post: 01-18-2010, 11:34 AM
  2. Atlantic County Firehouse up in Flames!
    By mdoddsjffhnfc in forum Firefighters Forum
    Replies: 1
    Last Post: 01-05-2003, 12:15 PM
  3. COLLEGE-coming to a firehouse near you?
    By NJFFSA16 in forum The Off Duty Forums
    Replies: 0
    Last Post: 09-30-2002, 04:42 AM
  4. Junior Members Sleeping in the firehouse
    By Truckie465 in forum Firefighters Forum
    Replies: 30
    Last Post: 02-14-2002, 10:21 PM
  5. Firehouse Construction Question
    By Duke in forum Meet and Greet
    Replies: 3
    Last Post: 11-05-1999, 06:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Log in

Click here to log in or register