Adding PHP to IIS 7.5

ITSM,Programming,Web Stuff,Windows — Jeff Eske on October 4, 2011 at 2:25 pm

Got php up and running successfully on IIS 7.5 (Windows Server 2008R2) today.  Will post the step-by-step instructions shortly.  I’m hoping that this will allow me add the ability to create web forms that can submit tickets directly ITSM.  We’ll see how it pans out.

Learning Old-School Web Services

Programming,Web Stuff — Jeff Eske on July 21, 2011 at 2:06 pm

I’m in the process of bringing up a new version of ITSM (Version 7), and we have an outsourced call center that needs to be interfaced with it.   ITSM has old-school web services (SOAP) available, but they’re not terribly well documented.   Consequently, it’s given me a lot of reason to spend time pounding away learning how to implement web services.  It’s pretty interesting.  I’d like to dive in and learn more about REST APIs, but don’t know when I”ll have time.

Viewing ITSM Incidents and Tasks

ITSM,Programming — Jeff Eske on July 20, 2011 at 4:19 pm

I’ve started creating a web page that will give you a list of the ITSM Incidents/Tasks that you own or that are assigned to you.  It gives you a “read-only” view of the Incidents and Tasks and allows you to view them and navigate amongst them.  I envision it being useful mainly for techs out in the field.  This will allow them to be able to view their ticket information using only their phone.   It’s been tried on various smartphones, including Blackberry, iPhone, and various Android phones.  It also works on all of the other iDevices.   It displays in REALLY basic HTML, so it should work on virtually anything with a browser.

ITSM Team Incident and Task Viewing

ITSM,Programming — Jeff Eske on July 20, 2011 at 4:18 pm

I’ve started creating a web page that will give you a list of all of the ITSM Incidents/Tasks that are assigned to a team within ITSM.  It gives you a “read-only” view of the Incidents and Tasks for each team  member and allows you to view them in a new window.  It’s been tried on various smartphones, including Blackberry, iPhone, and various Android phones.  It also works on all of the other iDevices.   It’s displays REALLY basic HTML, so it should work on virtually anything with a browser.  I’m using PHP and directly querying the DB server to pull the appropriate information.  It may not be perfect, or the preferred method, but it’s quick and I understand it.

Instructions for using Claris Homepage 3.0 to create forms for Filemaker Pro 4.0

Programming — Jeff Eske on May 27, 2009 at 11:01 am

I would STRONGLY urge you to ditch Claris Homepage and Filemaker for a more robust solution.  If you still insist on using them, this should at least get you started…

Instructions for using Claris Homepage 3.0 to create forms for Filemaker Pro 4.0

1> Make sure that FM Pro 4.0 is running and that the desired database is open and shared.

2> Start Homepage and goto — File: New…

3> Choose “Use Assistant”

4> Choose Filemaker Connection Assistant.

5> Follow the Assistant through.

IMPORTANT NOTES ABOUT THE CONNECTION ASSISTANT

On the Database Selection Screen …

Claris Homepage Connection Assistant

DON’T US “This computer”. It’ll kill CHP, or lock up the computer, OR BOTH. I’ve NEVER gotten it to work successfully.

USE: IP Address= localhost, and then click “Connect to server” button. This should bring up a listing of any open and shared databases.

Layout Selection: Make sure that the layout that you select contains all of the fields that you want to be able to use on your form, because you will select the specific fields used a couple of steps down the road.

Feature Selection: You can select to create both the Search and Add New Records pages at the same time here.

Location: I generally choose to create a New Folder to keep all of the pages together, so that I can easily find them to tweak ‘em to my liking. Also, the possibility exists that there may be other files of the same name that would be overwritten otherwise.

Filemaker Error Codes

Programming — Jeff Eske on May 27, 2009 at 10:57 am

(Now Includes FMP 5 Error Codes)
PLEASE NOTE: I don’t use Filemaker anymore, but this page is popular enough that I’m going to try to improve it and make it more useful.
I would encourage you to look into using PHP and MySQL in place of Filemaker.

-1 Unknown error.

0 No error.

1 User canceled action.

2 Memory error.

3 Command is unavailable (for example, wrong operating system, wrong mode, etc.).

4 Command is unknown.

5 Command is invalid (for example, a Set Field script step does not have a calculation specified).

100 File is missing.

101 Record is missing.

102 Field is missing. (In my experience, a field name in the form was usually misspelled, so Filemaker didn’t recognize it. In any event, the form is sending Filemaker a field name or names that Filemaker isn’t finding in the database.).

103 Relationship is missing.

104 Script is missing.

105 Layout is missing.

200 Record access is denied.

201 Field cannot be modified.

202 Field access is denied.

203 No records in file to print or password doesn’t allow print access.

204 No access to field(s) in sort order.

205 Cannot create new records; import will overwrite existing data.

300 The file is locked or in use.

301 Record is in use by another user.

302 Script definitions are in use by another user.

303 Paper size is in use by another user.

304 Password definitions are in use by another user.

305 Relationship or value list definitions are locked by another user.

306 Record modification ID does not match.

400 Find criteria is empty.

401 No records match the request.

402 Not a match field for a lookup.

403 Exceeding maximum record limit for demo.

404 Sort order is invalid.

405 Number of records specified exceeds number of records that can be omitted.

406 Replace/Reserialize criteria is invalid.

407 One or both key fields are missing (invalid relation).

408 Specified field has inappropriate data type for this operation.

409 Import order is invalid.

410 Export order is invalid.

411 Cannot perform delete because related records cannot be deleted.

412 Wrong version of FileMaker Pro used to recover file.

500 Date value does not meet validation entry options.

501 Time value does not meet validation entry options.

502 Number value does not meet validation entry options.

503 Value in field does not meet range validation entry options.

504 Value in field does not meet unique value validation entry options.

505 Value in field failed existing value validation test.

506 Value in field is not a member value of the validation entry option value list.

507 Value in field failed calculation test of validation entry option.

508 Value in field failed query value test of validation entry option. OR

508 Invalid value entered in Find mode. – (FMP 5)

509 Field requires a valid value.

510 Related value is empty or unavailable.

600 Print error has occurred.

601 Combined header and footer exceed one page.

602 Body doesn’t fit on a page for current column setup.

603 Print connection lost.

700 File is of the wrong file type for import.

701 Data Access Manager can’t find database extension file.

702 The Data Access Manager was unable to open the session.

703 The Data Access Manager was unable to open the session; try later.

704 Data Access Manager failed when sending a query.

705 Data Access Manager failed when executing a query.

706 EPSF file has no preview image.

707 Graphic translator can not be found.

708 Can’t import the file or need color computer to import file.

709 QuickTime movie import failed.

710 Unable to update QuickTime file reference because the database is read-only.

711 Import translator can not be found.

712 XTND version is incompatible.

713 Couldn’t initialize the XTND system.

714 Insufficient password privileges do not allow the operation.

800 Unable to create file on disk.

801 Unable to create temporary file on System disk.

802 Unable to open file.

803 File is single user or host cannot be found.

804 File cannot be opened as read-only in its current state.

805 File is damaged; use Recover command.

806 File cannot be opened with this version of FileMaker Pro.

807 File is not a FileMaker Pro file or is severely damaged.

808 Cannot open file because of damaged access privileges.

809 Disk/volume is full.

810 Disk/volume is locked.

811 Temporary file cannot be opened as FileMaker Pro file.

812 Cannot open the file because it exceeds host capacity.

813 Record Synchronization error on network.

814 File(s) cannot be opened because maximum number is open.

815 Couldn’t open lookup file.

816 Unable to convert file.

900 General spelling engine error.

901 Main spelling dictionary not installed.

902 Could not launch the Help system.

903 Command cannot be used in a shared file.

Filemaker Pro 5-specific Error Codes

904 Command can only be used in a file hosted under FileMaker Server.

950 Adding repeating related fields is not supported.

951 An unexpected error occurred.

971 The user name is invalid.

972 The password is invalid.

973 The database is invalid.

974 Permission Denied.

975 The field has restricted access.

976 Security is disabled.

977 Invalid client IP address (for the new IP restriction feature).

978 The number of allowed guests has been exceeded (for the 10 guest limit over a 12 hour period).

Gempak Cleanup Process

Linux,Programming — Jeff Eske on May 27, 2009 at 10:44 am

If Gempak programs hang, you can run a cleanup process that is supposed to remove them.

1> Make sure you source the Gemenviron/Gemenviron.profile file first.

2> Type in: $NAWIPS/bin/cleanup -c

It should give you a couple of status messages if it works. i.e.
Checking for and removing IPC message queues . . .
Checking for and removing IPC semaphores . . .

Decoding Individual Sounding Files with Gempak Decoders

Linux,Programming — Jeff Eske on May 14, 2009 at 2:43 pm

I realize this post is pretty rough, but it tells ME what I need.

download/obtain sounding data in wmo format.

Open file and add beginning and ending headers/footers.

save as “soundings.txt”.

First Run: cat soundings.txt | dcuair  -d – YYYYMMDD_upa.gem

This will throw DATTIM errors because the archive date/time will be different than expected.  It will show you what the datafile time is, so you can correct your commandline to match it.

Next Run:  cat soundings.txt | dcuair -c 20090529/0000 -d – YYYYMMDD_upa.gem

Adjust this date/time to each required combination, until all of the records have been decoded.

Decoding Individual GRIB file with Gempak Decoder

Linux,Programming — Jeff Eske on May 14, 2009 at 11:29 am

I know that this post is rather rough, but it tells ME what I need to know.

copy grib files to a directory.

change to that directory.

Run:  dcgrib2 -c YYMMDD/HHNN -d dcgrib2.log  < input file name

creates directory structure within present directory.

Old scripts that I had laying around…

Programming — Jeff Eske on December 16, 2008 at 3:35 pm

I’ve found several badly-written scripts from early on, when I was just learning PHP.  I decided to add them to a “Tools” section on my site, because they are handy sometimes.

============

Arin Info – Ever wonder who the owner of an IP is?  You can use this to query  the American Registry for Internet Numbers (ARIN) to see what company or organization owns the ip address.  It’s not very sexy, but it works.

Basic Browser Info – Want to know what your browser is telling websites when you visit them?  This script gives you a basic idea of what’s sent by your browser.

More Advanced (and somewhat more accurate) Browser Sniffer – This one was developed for use where the Java VM needed to be known.  It required Microsoft Java, so if you have Sun, it will tell you that you need to get Microsoft Java.  Trust me, that’s not my opinion…

« Previous Page
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.5 License. | Jeff's Blog