|
|
|
|
|
|
|
|
- 1 Sharing data
- 2 Retrieving data from a site
- 2.1 Via a query Active WEBDEV Page
- 2.2 Via a Webservice
- 2.3 Via FTP:
- 2.4 Via email:
- 3 Performing a replication
12. Retrieving data from a site
A commercial site allows end users to place orders, make reservations and more, ... Several methods can be used to retrieve this information. Tip: Process the retrieved data in a "Back Office" application developed with WINDEV. The data of a WEBDEV site can be directly shared with the data found in the Back Office application used to process the operations performed on the site. Simply use an HFSQL Client/Server database. Here is how it works: Benefit: The site data is accessible in real time. Drawback: Need to manage security in an optimal way: use a secured connection to access data, open a specific port to access data (port 4900 by default), configure the firewall, etc. This solution is recommended for a site installed on a dedicated server. 2 Retrieving data from a site 2.1 Via a query Active WEBDEV Page WEBDEV allows you to create Active WEBDEV Pages. WP pages are independent pages that can run processes from the parameters passed as command lines to the page. Active WEBDEV Pages can be used to retrieve data entered on the site. Active WEBDEV Pages on the Web server receive regular HTTP requests run by the Back Office application. The data is returned in string format and processed by the WINDEV application. Benefits: - Solution that can be easily implemented.
- Equivalent to a custom Web service.
- No additional executable is required on the server. No additional session is run on the server.
Drawback: Unidirectional data retrieval: no data update toward the server. This solution can be used on a shared server. 2.2 Via a Webservice WEBDEV allows you to create Webservices. The Webservice is installed on the Web server and the WEBDEV Application Server allows you to use it. The Webservice can be used to retrieve the data entered in the site. The Webservice located on the Web server is queried on a regular basis by the HTTP requests run by the Back Office application. The data is returned in XML format, as strings (or other) and processed by the WINDEV application. Benefits: - Solution that can be easily implemented.
- No additional executable is required on the server. No additional session is run on the server.
Drawback: Unidirectional data retrieval: no data update toward the server. This solution can be used on a shared server. 2.3 Via FTP: WEBDEV allows you to regularly save the data files of the WEBDEV site. This backup can be transferred by FTP to the company headquarters. Then, all you have to do is: - retrieve the compressed backup of the data files.
- decompress the files (via a WINDEV application).
- process the data found in the files.
Benefits: - Solution that can be easily implemented.
- No additional executable is required at the hosting company.
Drawback: All data files found in the application are retrieved. This solution can be used on a shared server. 2.4 Via email: How it works: - The user places an order on the site.
- The WEBDEV site informs the user that the order was successfully registered. The user is notified that a confirmation email will be sent.
- The WEBDEV site sends an email to the company headquarters. This email contains the order placed by the user.
- The company sends an email to notify the user that the order has been processed.
Benefits: - Solution that can be easily implemented.
- No additional executable is required on the server.
Drawback: Unidirectional data retrieval: no data update toward the server. This solution can be used on a shared server. 3 Performing a replication The replication is used to keep the remote databases of identical structure updated. A replication can be performed between the database of a WEBDEV site and the database of a WINDEV application at the company headquarters. For example, a database used to enter orders and to manage stocks is used both on a WEBDEV site (online orders) and at the company headquarters (orders by phone or by mail). The replication is used to: - transmit the online orders to the company headquarters (unidirectional replication)
- transmit the online orders to the company headquarters and transmit the stock update to the Internet site (bi-directional replication).
Caution: The replication constraints must be taken into account during the project creation. Indeed, several rules must be followed when describing the analysis and the file items. The replication can be performed by email or via the assisted universal replication. For more details on replication, see Assisted universal replication. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|