Posts

Showing posts from 2006

Inter-tel Voice Over IP Phones

I got a used Inter-tel IP phone off ebay that wouldn't let me program it using the 7/8 key combination.

I was able to telnet into the IP phone with the default password of iptpassw and use the command DBMN to tell it the IP settings.
After that it still couldn’t connect because the firmware was not compatible with the v9 IPRC. The phone was at v1.01 and needed 8.1.0.

I looked in the manual and found out that I need to flash the latest 8.1.0 firmware and it should be called ipp+.hex
My v.9.1.0.1 disc has lots of firmware, but not that one. I did find it on the v9.0.0.1 disc.
I held down the 5 and 6 to get the 770.4500 into download mode.
It assigned itself an address of 192.168.200.201.
I started the Upload utility and entered the IP address of 192.168.200.201 along with the default account (IPT) and password (iptpassw).
I changed my PC IP address to 192.168.200.200 so I could connect to the IP phone.
I started the upload and everything worked!

It looks like everyone was correct a…

More Useful SQL statments for Visual Enterprise from Infor

Here are some of my raw notes:


SELECT CUSTOMER_ID, ID, CUSTOMER_PO_REF
FROM CUSTOMER_ORDER
WHERE (ID = '200150960')

select CUST_ORDER_ID from CUST_ORDER_LINE where CUST_ORDER_ID='200150960'

SELECT QUOTE_ID FROM QUOTE_ORDER WHERE CUST_ORDER_ID = '200150960'

Use SFC to get the Work Order Number:
------------------------------------------

SELECT SUPPLY_BASE_ID, DEMAND_BASE_ID
FROM DEMAND_SUPPLY_LINK
WHERE (DEMAND_BASE_ID = '200150960')


Now find the Operation Status
---------------------------------
SELECT OPERATION_SEQ_NO, RESOURCE_ID
FROM LABOR_TICKET
WHERE WORKORDER_TYPE = 'W' AND WORKORDER_BASE_ID = '746952' AND WORKORDER_LOT_ID = '1'

What is the work order Status, and ship date if it's already gone?
----------------------------------------------
SELECT STATUS, close_date
FROM WORK_ORDER
WHERE BASE_ID = '789635'


Combine WO and Status
------------------------
SELECT DEMAND_SUPPLY_LINK.DEMAND_…

Usefull SQL Statements for SQL Server and Visual Manufacturing from Infor

Here is an example of how you can convert OPERATION_BINARY.BITS to text using cast, so that you can have it show up in a report.


SELECT OPERATION_BINARY.SEQUENCE_NO, CAST(CAST(OPERATION_BINARY.BITS AS varbinary(8000)) AS varchar(8000)) AS specs,
OPERATION.RESOURCE_ID, OPERATION.OPERATION_TYPE, OPERATION_TYPE.DESCRIPTION,
OPERATION_BINARY.WORKORDER_TYPE
FROM OPERATION_BINARY INNER JOIN
OPERATION ON OPERATION_BINARY.WORKORDER_BASE_ID = OPERATION.WORKORDER_BASE_ID AND
OPERATION_BINARY.SEQUENCE_NO = OPERATION.SEQUENCE_NO AND
OPERATION_BINARY.WORKORDER_TYPE = OPERATION.WORKORDER_TYPE AND
OPERATION_BINARY.WORKORDER_SUB_ID = OPERATION.WORKORDER_SUB_ID AND
OPERATION_BINARY.WORKORDER_SPLIT_ID = OPERATION.WORKORDER_SPLIT_ID AND
OPERATION_BINARY.WORKORDER_LOT_ID = OPERATION.WORKORDER_LOT_ID INNER JOIN

Automated Silent Installation/Deploy

Every admin out there has the need to install software on a new PC, and hopefully silently.
Here is my batch file that I use to install everything after I use RIS to install XP.
My ERP and other software that would be useless to most people has been removed.
The Ghostscript PDF creation tool is available from my website: http://www.looserubble.com

-------------------------------------------

@echo off
q:
cd "Q:\software\Build PC"

echo Installing Quicktime
start /WAIT QuickTimeFullInstaller.exe

echo Installing Real Player
start /WAIT RealPlayer10GOLD_bb.exe /S

echo Installing MSN Messenger 7.5
start /WAIT msiexec /i "MSN Messenger\msnmsgs.msi" /q

echo Installing Prism Plug-In for Boeing Drawings
start /WAIT prism\PrizmPlug-in-ext.exe /s /f1"prism\SkillsInstallPrism.iss"

echo Installing Desktop Icons
REM start /WAIT "Installing" "Q:\software\Desktop Apps\Desktop Icons\Doc Control Icons.EXE"
echo Copy desktop icons from the terminal server
copy "\\monst…