{"id":1425,"date":"2023-06-21T08:53:28","date_gmt":"2023-06-21T06:53:28","guid":{"rendered":"https:\/\/test.contribute.be\/cases\/psa\/"},"modified":"2025-03-25T16:57:58","modified_gmt":"2025-03-25T14:57:58","slug":"psa","status":"publish","type":"cases","link":"https:\/\/contribute.be\/en\/cases\/psa\/","title":{"rendered":"PSA"},"content":{"rendered":"\n
\n
\n

Contribute cases: PSA<\/h2>\n\n\n\n

PSA is the largest container handler at the Port of Antwerp, operating three container terminals and a multipurpose terminal. With the growing expansion of the port, PSA aims to better serve the drivers and companies that deliver and pick up containers.<\/p>\n\n\n\n

<\/div>\n\n\n\n

It\u2019s critical for a driver to show up at the correct location, as a wrong location results in significant detours, causing additional costs. Planning is subject to factors such as delays, tide conditions, and loading and unloading times. It\u2019s often unclear where a ship will dock until just before it enters the harbor. Last-minute changes in dock locations are not optimally communicated through standard systems.<\/p>\n\n\n\n

<\/div>\n\n\n\n

Additionally, the companies that place orders to ship containers are often different from those picking them up. Truckers may be unavailable, and replacements by other firms or subcontractors are common. Container codes frequently pass through various parties, creating uncertainty about where a container will be loaded or unloaded and who is responsible for transporting it.<\/p>\n\n\n\n

<\/div>\n\n\n\n

PSA partnered with Contribute to create an accessible, centralized system that provides real-time information to truck drivers about the location of containers. Additionally, the authorities seek more insight into container transport to help combat drug trafficking and other illegal shipments.<\/p>\n<\/div>\n<\/div>\n\n\n\n

<\/div>\n\n\n\n

Concept and solution<\/h3>\n\n\n\n

To create a user-friendly application, we designed a mobile app that can be downloaded from any app store. The complexity is kept minimal, with no login or password required, and the app consists of just a few screens. The user enters a container number and receives the dock address and a Google Maps route. <\/p>\n\n\n\n

<\/div>\n\n\n\n

The app does not provide access to the gate; it\u2019s purely informational, designed to break down communication barriers between different parties. Meanwhile, the app collects user data: device type, requested container number, location, and more. <\/p>\n\n\n\n

<\/div>\n\n\n\n

The complexity of this solution lies in fetching the correct information. Each terminal has its own database, which is regularly updated with new applications and upgrades, meaning the data structure may vary between databases. <\/p>\n\n\n\n

<\/div>\n\n\n\n

PSA already uses Oracle APEX, but it cannot be used to create a mobile app. Therefore, we needed a technology that could combine mobile app development with the ability to query data from multiple databases and filter the correct information. <\/p>\n\n\n\n

<\/div>\n\n\n\n

Oracle JET (JavaScript Extension Toolkit) was chosen for this purpose. It\u2019s an open-structured toolkit that ensures the application works seamlessly on both desktop and mobile devices. We streamline communication between the databases and the app using Oracle REST APIs, which integrate smoothly with the existing PL\/SQL database structure. <\/p>\n\n\n\n

<\/div>\n\n\n\n

While no login or profile creation is necessary, security remains a priority. Requests from the app go directly from the user to the database, and we address this with proper database security and a well-considered approach to user rights. <\/p>\n\n\n\n

<\/div>\n\n\n\n

We capture user data such as download time, request time, device type, and which requests a user made. Additionally, network-level restrictions are set to control the number of requests made through the app.<\/p>\n\n\n\n

<\/div>\n\n\n\n

Result<\/h3>\n\n\n\n

When a container arrives at the port, its arrival is certain, but knowing exactly when, where, and which trucker will pick up the container is not always clear. To address this, Contribute designed a mobile app. Thirty minutes before pickup, a driver enters the correct details and knows exactly where to go. This results in lower costs through time savings and fewer errors.<\/p>\n\n\n\n

<\/div>\n\n\n\n

The development of this solution was cost-effective.  Based on the technologies and infrastructure available at PSA, we developed the app without any additional licensing costs. By using Oracle REST Data Services (ORDS) and Oracle JET, we built the app while optimizing existing knowledge and resources, achieving efficiency gains, and creating new functionalities.<\/p>\n\n\n\n

<\/div>\n\n\n\n

The greatest challenge wasn\u2019t the app development itself, but the collection, hierarchical structuring, and accurate interpretation of data from various sources. The app is designed to remain operational even if the underlying structures change. <\/p>\n\n\n\n

<\/div>\n\n\n\n

For PSA, this was their first experience with mobile apps. An application with just a few screens, but still a real solution to an urgent problem. At the moment, the app\u2019s focus is strongly on the added value for drivers and companies. In the future, this application will also offer opportunities for the government and port police. The app is freely available in the Google Play Store and Apple\u2019s App Store.<\/p>\n\n\n\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

PSA is the largest container handler at the Port of Antwerp. For further expansion, the company wanted to create a mobile solution for container handling. <\/p>\n","protected":false},"featured_media":900,"template":"","cases_categories":[36,38],"class_list":["post-1425","cases","type-cases","status-publish","has-post-thumbnail","hentry","cases_categories-managed-services-en","cases_categories-custom-application"],"acf":[],"_links":{"self":[{"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/cases\/1425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/cases"}],"about":[{"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/types\/cases"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/media\/900"}],"wp:attachment":[{"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/media?parent=1425"}],"wp:term":[{"taxonomy":"cases_categories","embeddable":true,"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/cases_categories?post=1425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}