Web notification to customers

[jeppegotha]

Hi,
Maybe some of you could be interested in this.

We have an agreement with customers that they should be able to see information on the intranet about server outage, maintenence etc.
We have SLA on this so we have to be able to check if the customers have been informed via web at the right times.

To make this I have created a dbdict where the information can be inserted (see screendump). When a record is inserted it can be viewed from the intranet but only in the time period you enter in the record.

[kobear]

Does SC actually control the placement of the message on your intranet site? If so, how do you manage the timeframe that the message is available?

[jeppegotha]

in my web application !

[tommy]

Jeppe are You using Get.It to display the information on the intranet or are You using something else to push the data to the intranet? Or are You on RDBMS?

[jeppegotha]

I am on P4
I am using Get-It .. I also tried building my own in MS ASP using the odbc driver to sc5 and that also worked.

[tommy]

wow, can You post that asp script or parts of it? we could use that on our intranet.

[kobear]

Glad to hear that someone has had success with the ODBC driver from SC v5.x

I want to start testing, but I am having problems installing the driver on any/every workstation that I have tried (about 5 so far).

What version of SC/P4 are you running?

[tommy]

Kyle check the read bit on the driver files I have experienced that I could not upgrade / downgrade the odbc driver because a dll was set to read-only. I can't remember the actual name of the dll file.

[jeppegotha]

hi,
i am on vacation now but I will return to my office in two weeks and then I will send you the asp-script.

[Gérard]

I am interested in the script also, as well with ODBC on SC5, I am stocking as well....

Waiting... Cheers

[kobear]

Does anyone have documentation on how to connect via the ODBC driver, and what is supported? Support says that the driver supports ODBC v2.0, but there are some queries that I know should work, and return -1 records.

The only thing that I got from support is the following blurb of code, which is worthless, since it describes how to do a file import into MS Access, not an ODBC call.

> 1. Copy the scdobc32.exe and scodbc32.dll into the ServiceCenter run
> directory
> 2. Add the validateodbcfieldnames into the sc.ini
> 3. Add the validateodbcfieldnames into a separate sc.ini and put the
> sc.ini in the My Documents directory (note: I did not have to do this and
> the import still worked)
> 4. Configure the ODBC driver:
> - goto ODBC Data Sources
> - Click on the <Add> button
> - Select ServiceCenter ODBC Driver
> - In the SC ODBC Driver Configuration Window&#58;
> - Data Source Name - ServiceCenterODBC
> - in the second field, put in the server name.port number
> - Click on the <ok> button
> 5. In ServiceCenter&#58;
> - goto the contacts table
> - unload the contacts to a text &#40;tab delimited&#41; file
> 6. Test in Microsoft Access&#58;
> - goto Microsoft Access
> - open a new mdb file
> - in the Files of Type&#58; ODBC Databases&#40;&#41;
> - Goto Machine Data Source tab
> - select ServiceCenterODBC for the Data Source Name
> - goto File, Get External Data and import
> - browse to your contacts text file
> - Follow the instructions and now the text is in the table

Leave it to Peregrine support to completely skirt around ODBC and do a file import into MS Access.

[kobear]

Does anyone know if the SC 5 ODBC driver is compatable with SC 3.0 SP2d?