A2C Data Integration System

D6.2. A2C Data Integration System October 2023 Authors: CETEC, EQUMETRICS, EVRYTHNG, EXUS SOFTWARE Ref. Ares(2023)7430258 - 31/10/2023 2 A2C – Deliverable D1.10v1.0 Technical references Project Acronym Agro2Circular Project Title TERRITORIAL CIRCULAR SYSTEMIC SOLUTION FOR THE UPCYCLING OF WASTE FROM THE AGRIFOOD SECTOR Project Coordinator Fuensanta Monzó CETEC [email protected] Project Duration October 2021 – September 2024 (36 months) Deliverable No. D6.2 Dissemination level* PU Work Package WP2 - Demonstration of the A2C technological solution Task T6.2 - A2C Demonstrators Lead beneficiary 1 (CETEC) Contributing beneficiary/ies 34 (EQU), 35 (EXUS), 36 (EVRY) Due date of deliverable 31 Oct 2023 Actual submission date 31 Oct 2023 * PU = Public PP = Restricted to other programme participants (including the Commission Services) RE = Restricted to a group specified by the consortium (including the Commission Services) CO = Confidential, only for members of the consortium (including the Commission Services) Document history V Date Comments v0.1 24/10/2023 First draft of document v0.2 31/10/2023 Revised version based on the comments of –Salvador Navarro-GWC and Sofía Martínez-CTNC v1.0 31/10/2023 First final version, approved by the WP leader and the project coordinator, (will be) submitted to EC. v1.1 First draft based upon first final version v2.0 Second final version, approved by the WP leader and the project coordinator, (will be) submitted to EC. Document Distribution Log Versio n Date Distributed to v0.1 24/10/2023 Jaime Ortiz-CETEC v0.2 31/10/2023 Sofía Martínez-CETEC 3 A2C – Deliverable D1.10v1.0 v1.0 31/10/2023 Jaime Ortiz-CETEC Verification and approval Name Date Verification Final Draft by WP leader Jaime Ortiz 31/10/2023 Approval Final Deliverable by coordinator Fuensanta Monzó Disclaimer and acknowledgement This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 101036838 Disclaimer This document reflects only the views of the author(s) the European Research Executive Agency (REA) is not responsible for any use that may be made of the information it contains. Whilst efforts have been made to ensure the accuracy and completeness of this document, the A2C consortium shall not be liable for any errors or omissions, however caused. 4 A2C – Deliverable D1.10v1.0 Table of contents 1. Introduction 6 2. Executive summary 7 3. User guide 8 3.1 Traceability Tool 8 3.1.1 Home page 8 3.1.2 Login 8 3.1.3 Dashboard 9 3.1.4 Operative modules 10 3.1.4.1 Admin 10 3.1.4.2 Plastic waste producer 10 3.1.4.3 Plastic waste manager 12 3.1.4.4 Plastic manufacturer 14 3.1.4.5 Aluminium separation 15 3.1.4.6 Agrifood waste manager 16 3.1.4.7 Biotechnological routes: CetecBio PHVB production 18 3.2 QR identification App 20 i. Introduction 20 ii. Basic User’s Guide: 20 2.3 Decision Tool 26 1. Dashboard Overview 27 2. How to use the Dashboard 28 4. Conclusions 31 5 A2C – Deliverable D1.10v1.0 List of abbreviations Abbreviation Definition A2C Agro2Circular DIS Data Integration System ICT Information and communication technology 6 A2C – Deliverable D1.10v1.0 1. Introduction This deliverable is designated within Work Package Number Six, where it serves as a demonstration of the various technologies developed at a pilot scale. It is imperative to emphasise that this system is currently under development and testing, adhering to the technical specifications set forth by each partner within the project's life cycle. As a result, the primary focus has been directed toward processes that are more mature and well-defined, considering the intricate nature of developing a software solution within this complex context. This deliverable functions as a comprehensive guide, elucidating the diverse scenarios that technical partners encounter while utilising their respective operational modules. 7 A2C – Deliverable D1.10v1.0 2. Executive summary This document serves as a user guide for the A2C Data Integration System online platform user guide. The platform offers end-to-end traceability of materials, leveraging cutting-edge technologies, including cloud technology, Quick Real-QR for information identification, Big Data, Artificial Intelligence for data processing, and Blockchain for data security and immutability. These technologies ensure the highest level of security and reliability. The primary objective of the DIS platform is to assist users in selecting the most suitable upcycling option for materials, considering factors like environmental impact, costeffectiveness, and availability. Additionally, it fosters effective communication among stakeholders, enhancing supply chain sustainability. In conclusion, the DIS platform is a vital tool for organisations aiming to enhance their sustainability practices. This executive summary provides an overview of the platform's capabilities, features, and functionalities to enable users to harness its full potential. 8 A2C – Deliverable D1.10v1.0 3. User guide 3.1 Traceability Tool 3.1.1 Home page The welcome page (Figure 1) displays information about the different types of waste being tracked in the system. There are three cards, each representing a different type of waste. The cards display the total amount of waste in kilograms, along with a title and subtitle describing the type of residue being measured. The only functionality found here is the login, which is explained next. Figure 1. Welcome page 3.1.2 Login 1. Click on the top right corner "Login" button. 2. You will be redirected to the Keycloak login page (Figure 2). 3. Enter your Keycloak username and password and click on the "Sign in" button. 4. Once you have successfully logged in, you will be redirected back to the web application and will be able to access its resources. 9 A2C – Deliverable D1.10v1.0 Figure 2. Keycloak login page 3.1.3 Dashboard The view displays different cards with statistics, such as the last received and delivered quantities, total quantities received and delivered, and weekly received and delivered amounts (Figure 3). The user can see the values displayed in each card, which are fetched from the database. The view also shows a table with the details of the last received entries, such as ID, resource type, and quantity in kilograms. This page is only accessible to users with specific roles, as defined by the conditional statements in the code. By this way, it is confirmed that the user will only see data relative to his organization. The displayed information is shown by the administrator, who has access to all data. 16 A2C – Deliverable D1.10v1.0 Figure 10. Aluminium separation, Delamination option 3.1.4.6 Agrifood waste manager 1. Classification: Identification of the organic residue taking into account (Figure 11): a. Origin b. Date c. Type of residue (crop) d. Variety e. Campaign f. Weight 17 A2C – Deliverable D1.10v1.0 Figure 11. Organic residues, Classification option 2. Extraction: Form to prepare the extraction. There are 2 types of extractions, selected in the “technology” input. Other options selected here are the solvents used and the weight used from the residue. The system automatically generates an extract id. 3. Waste water delivery: Waste waters from the extraction process are recognized as residues by its content. These are treated on the biotechnological routes, which are explained in the next section. 4. Purification: Sort the obtained phase of the extraction process. Figure 12. Organic residues, Purification option 5. Validation: Identification of the final product with: 18 A2C – Deliverable D1.10v1.0 ● Resultant net weight ● Validation identification ● Date ● Percentage of fibres. ● Percentage of polyphenols. 6. Delivery: Expedition form with: ● Assigned delivery identification ● Weight of the product delivered ● Client (formulator) ● Date This delivery generates a traceability report with the information of the product and a QR for traceability. 3.1.4.7 Biotechnological routes: CetecBio PHVB production 1. New ingredient: Possibility to sign up ingredients and raw materials used in the process. The indicated inputs are (Figure 13): a. Date b. Raw material type c. Composition d. Lot identification e. Concentration f. Product reference g. Trading house h. Volume Figure 13. Biotechnological routes, PHBV production, Ingredients sign up? 2. Acceptance: This operation will be done at the mobile app. On this BETA version, it is under development, but the idea is the same as the manufacturer classification. 19 A2C – Deliverable D1.10v1.0 3. Classification: Confirm the accepted residue and sort it. 4. Process: Select different attributes related to the chemical properties choosing the ingredients which contribute to generate the product (Figure 14): a. Sources b. Salts c. Inoculums d. Forefathers Figure 14. Selection of the ingredients that contribute to produce the product 5. Storage: The most important term is the type of product generated (carotenoids/PHBV) and its quality. 6. Delivery: Expedition form with: ● Assigned delivery identification ● Volume of the product delivered ● Client ● Date 20 A2C – Deliverable D1.10v1.0 3.2 QR identification App i. Introduction The App of the A2C waste management project is currently in an active BETA testing situation, with part of the processes accessible and others under development. The A2C app is already available, as BETA, on the Google Play platform for Android for download on mobile devices. Now, its use is restricted, it is only active for users authorized by the WP1 managers of the project. It is being used as a performance testing system with the first processes already activated on the A2C platform. This way, although it is not publicly displayed, users with authorized Gmail accounts can download the latest version. As it is operational with limited access for test operation, it has been tested with the introduction of data in WASTE ACCEPTANCE for an intermediate collection operator. Right now, it allows entering basic data for each batch of waste, as well as the date and signature of the operator involved in the process. Currently the app consists of multiple operational screens, both for anonymous users and registered agents involved in the processing of materials. ii. Basic User’s Guide: Once the application is downloaded (currently under authorization), the A2C icon will appear for direct access. The app starts with an animation introducing the A2C logo. Anonymous Users (General Public Access): 21 A2C – Deliverable D1.10v1.0 Upon completion, a screen is displayed with a graphic button for scanning by anonymous users. Clicking on this button launches the device's camera and detects the presence of QR codes in the focused area. When scanning a QR code, it is checked if it is a web URL, in which case it is launched in the browser of the device. Once the exact format of these codes and their content are defined, a filter can be implemented so that only the results of products involved in the project are launched. Registered Users (A2C Professional Users): In the upper right corner of the screen there is a discreet "Access" button, clicking on it makes the app advance to the login screen for registered users. LOGIN SCREEN: This screen shows the username and password fields, and a button to confirm the credentials entered. Upon confirmation, these credentials are consulted with the A2C server. If they are valid, it advances to the main menu for authorized users. If they are not, an error message is displayed. The credentials are stored for easy access at future times. Also, if you have successfully logged in at least once, the next time the app is launched, it will automatically advance to the login screen, saving operators unnecessary keystrokes. 22 A2C – Deliverable D1.10v1.0 OPERATIVE BUTTONS MENU: The menu for authorized users currently consists of multiple buttons in anticipation that, depending on the role of the user who has accessed, some possible actions or others are shown. 6 types of users are identified: 1. admin, with access to all forms. 2. plastic-manager, with access to the 3 plastic waste forms. 3. plastic-manufacturer, with access to the manufacturer material receipt form. 4. al-delaminate producer, with access to the aluminized layer classification form. 5. organic manager, with access to the organic waste acceptance form. 23 A2C – Deliverable D1.10v1.0 6. organic-nut-formulator, with access to the extract receipt form (nutraceutical formulation). APP CALLING FOR THE QR SCAN: Clicking on this button launches the camera for QR scanning in a similar way to scanning for anonymous users. However, when scanning a valid QR code, what the app does is check if the code complies with the proper format, in which case it checks the code with the A2C server. If the code has the valid format and the A2C server returns information associated with said code, the app advances to the waste acceptance confirmation form. Otherwise, it displays an error message. LOT DATA SCREEN: In this case, the Waste Reception has been selected, and the lot code has been scanned. The lot data are opened, and it must be confirmed. In the waste acceptance confirmation form. Currently, the more than forty data that this action may require are displayed. A confirmation button is displayed at the bottom of the screen. WASTE ACCEPTATION SCREEN: 24 A2C – Deliverable D1.10v1.0 The screen of waste acceptance is opened, and the receiver must decide if he accepts the lot, why and any new data about the lot characteristics. Between all the forms, the “waste acceptance” one is the longer and it has many fields; this is the reason why it is divided into three screens, with “next” and “previous” buttons in each screen. On the third screen, the acceptance field allows you to choose between yes and no; if it is chosen “not accepted”, 5 additional fields are shown to describe the reason for nonadmission and define new delivery dates. Once the lot has been accepted and all their data introduced, the system accepts the lot as received and all the data transmitted to the database. One message appears on the screen as “Acceptation successfully done” and the user is returned to the main menu. Otherwise, an error message is displayed, allowing you to modify the values and reconfirm the shipment without repeating the process from the beginning. The pretreatment form has an “extruder machine selection” field. Clicking on it, the available extruders are shown (according to API). Once confirmed the form, an additional batch ID field is added, which is automatically generated from the date and extruder ID. OTHER ACCEPTATION SCREENS: 25 A2C – Deliverable D1.10v1.0 All the other forms work in a similar way: ● QR is scanned, it is checked if it is valid for the user and the selected options. ● Relevant product data is obtained from the API. ● The form is launched with all possible fields already filled in. ● When confirmed, it is sent to where it should be, obtaining an OK (with or without PDFs and with or without QRs), or an error. ● In case of OK, the user returns to the menu; in case of error the user is allowed to edit the fields and try again. Here are shown the form for “Aluminized Layer Classification” and “Manufacturer Material Reception”. GENERAL NOTES ABOUT THE App SCREENS: ● Date fields display a widget that allows you to select the date using vertical spinners. ● If a form confirmation returns a PDF document generated in the API, the app automatically downloads it. 32 A2C – Deliverable D1.10v1.0 4. Conclusions In conclusion, this deliverable has provided a comprehensive demonstration of the technologies developed at a pilot scale within the framework of Work Package Number Six. The development and testing of this system have been conducted in strict adherence to the unique technical requirements of each project partner across the entire project life cycle. Our primary emphasis has been placed on processes that are more mature and welldefined, acknowledging the inherent complexity of creating a software solution within this intricate context. As a result, this deliverable stands as an invaluable guide, offering insights into the various challenges and scenarios that technical partners may encounter when utilising their respective operational modules. By addressing these technical intricacies and offering practical insights, we aim to facilitate a smoother integration of these technologies into the overall project, ultimately contributing to the success and efficiency of our collaborative efforts. Once the rest of the demonstrators are ready and integrated, we will be able to test it on real situations more than on isolated processes.