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?
+ Reply to Thread
Results 1 to 4 of 4
Thread: Firehouse v5 Question
12-20-2005, 04:53 PM #1
- Join Date
- Nov 2003
Firehouse v5 Question
01-04-2006, 05:55 PM #2
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
01-04-2006, 06:46 PM #3
- Join Date
- Dec 2005
You can do it in PHP or Delphi as well rather easily.
01-17-2006, 10:36 PM #4
- Join Date
- Feb 2005
- Medina Township, Ohio, USA
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
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By redepidermis345 in forum Hiring & Employment DiscussionReplies: 2Last Post: 01-18-2010, 11:34 AM
By mdoddsjffhnfc in forum Firefighters ForumReplies: 1Last Post: 01-05-2003, 12:15 PM
By NJFFSA16 in forum The Off Duty ForumsReplies: 0Last Post: 09-30-2002, 04:42 AM
By Truckie465 in forum Firefighters ForumReplies: 30Last Post: 02-14-2002, 10:21 PM
By Duke in forum Meet and GreetReplies: 3Last Post: 11-05-1999, 06:51 PM