Posts Tagged access web

Asistencia2010_1

Access system for Asistencia2010

Tags: , , , , , , , , , ,

SOAP Web Services With Joomla And Fabrik

We are creating a web application that accesses Web Services using SOAP. The Application is built in Joomla 1.5, using Fabrik (Joomla Application Builder). I need to have a mortgage calculator access web services and return a calculation.

I was provided a sample soap message. I have replaced the domain name with "ServerDomain" for security reasons.

POST /WebService.asmx HTTP/1.1
Host: webservice.ServerDomain.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://webservice.ServerDomain.com/CalculateLoan"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<CalculateLoan xmlns="http://webservice.ServerDomain.com">
<ProductId>int</ProductId>
<CompanyID>string</CompanyID>
<BirthDate1>dateTime</BirthDate1>
<BirthDate2>dateTime</BirthDate2>
<Zip>int</Zip>
<PropertyValue>double</PropertyValue>
<Liens>double</Liens>
</CalculateLoan>
</soap:Body>
</soap:Envelope>

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<CalculateLoanResponse xmlns="http://webservice.ServerDomain.com">
<CalculateLoanResult>
<ProductID>int</ProductID>
<ProductName>string</ProductName>
<IndexName>string</IndexName>
<InitialRateOfIndex>string</InitialRateOfIndex>
<RateMargin>double</RateMargin>
<Zip>int</Zip>
<PropertyValue>double</PropertyValue>
<PrincipalLimit>double</PrincipalLimit>
<ServicingFeeReserve>double</ServicingFeeReserve>
<ClosingCosts>double</ClosingCosts>
<Liens>double</Liens>
<NetLoanAmount>double</NetLoanAmount>
<NetTenureAmount>double</NetTenureAmount>
<Message>string</Message>
</CalculateLoanResult>
</CalculateLoanResponse>
</soap:Body>
</soap:Envelope>

You can see the development site at: http://demo.wmdwebservices.com/workinreverse/index.php?option=com_fabrik&view=form&fabrik=4&random=0&Itemid=2

That leads directly to the Fabrik form I need to add the SOAP calculation to. You can see the calculator under the "calculator" tab.

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Repair or rebuild access DB system

This will need to be done via remote access. Here are described issues by user.

System does not populate "Name, Address, City, State, Postal Code" Fields with information entered. Instead, it automatically plugged in "Name (or a two digit number) , Address, City, State, Postal Code". This did not effect all the database just certain members.
If I need to search for a particular member, the database doesn’t recognize it by name because it plugged in a number (i.e. if you enter a #10 it brings up all the members affected).

Cannot send out membership cards because the information in the Contact Info. Screen formation also populates the letters that are to be mailed with membership cards.

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,