|
Home → WINDEV 2024 → Import a nested JSON File to HFSQL analysis, select one record and redistribute it as JSON file |
Import a nested JSON File to HFSQL analysis, select one record and redistribute it as JSON file |
Started by danilue, Jun., 12 2019 10:51 AM - No answer |
| |
| | | |
|
| |
Registered member 1 message |
|
Posted on June, 12 2019 - 10:51 AM |
Dear Community I am programming in WINDEV24 a Portal Application to administrate different projects for my customers. My customers are Consultants with their own projects. They manage their projects with a web app which writes the project data as a nested JSON File. My intention is it to import this nested JSON File with all Project-Data in my HFSQL Database as analysis. Here I want to give every Consultant the possibility to select one single project and export it as a JSON File to the WebApp to continue working on it there. As first step I am looking for an answer how to get the JSON-Data to my analysis and make them relational. I was able to integrate the JSON File as an “external description” but I found no further possibilities to access the data directly from the code. I do not understand what’s the benefit of seeing this external description. Second try was the “HImportJSON Function” – this works with a flat JSON File but I did not find out how to handle a nested one… I think, that I have to create an analysis in the HFSQL DB for each level of the JSON structure But how do I set the relations while importing the data? I would be grateful for any help. Thanks a lot danilue
Here the view of "external description"
Here one example of one project-data-record from the JSON File
{ "id": 13, "mandant": "Bluetools Solutions GmbH", "name": "Bluetools Solutions GmbH 2019 Strategy", "owner": "Florian Wieser", "description": "20190214 - Strategy Workshop for Bluetools Solutions GmbH ", "start": "2019-02-14", "end": "2019-02-15", "mainProblem": "How should Bluetools Solutions GmbH direct its activities in 2019 to be most effective?", "criticalEvents": [ { "id": 0, "name": "Empty Event", "author": "Empty Author", "description": " Empty Description" }, { "id": 1, "name": "new event", "author": "", "description": "" } ], "tensions": [ { "id": 0, "defName": "Resources", "name": "How does Bluetools retrieve its resources?", "extName": "self-created", "intName": "obtained at Market", "subtensions": [ { "yesterday": 6, "today": 12, "tomorrow": 50, "id": 0, "extName": "internal finan. inv.", "intName": "external finan. inv." }, { "yesterday": 9, "today": 70, "tomorrow": 28, "id": 1, "extName": "internal knowledge", "intName": "external knowledge" }, { "yesterday": 9, "today": 23, "tomorrow": 60, "id": 2, "extName": "philosophy-driven HR", "intName": "market-driven HR" }, { "yesterday": 6, "today": 13, "tomorrow": 50, "id": 3, "extName": "social capital", "intName": "strategic partnersh." }, { "yesterday": 5, "today": 22, "tomorrow": 75, "id": 4, "extName": "informal structures", "intName": "corporate structures" } ], "trends": [ { "direction": 0, "knowledge": 2, "kind": 0, "id": 1, "name": "social: Trend to self-advice" }, { "direction": 1, "knowledge": 3, "kind": 0, "id": 2, "name": "rise of impact investment" }, { "direction": 1, "knowledge": 2, "kind": 0, "id": 3, "name": "increase of sense-workers" }, { "direction": 1, "knowledge": 1, "kind": 0, "id": 4, "name": "increase in org. hybrid-think." }, { "direction": 0, "knowledge": 1, "kind": 0, "id": 5, "name": "rising critique of angel inv." }, { "direction": 0, "knowledge": 1, "kind": 0, "id": 6, "name": "social: DIY-movement" } ], "groupTrends": [ { "trends": [ { "direction": 0, "knowledge": 2, "kind": 0, "id": 1, "name": "social: Trend to self-advice" }, { "direction": 1, "knowledge": 3, "kind": 0, "id": 2, "name": "rise of impact investment" }, { "direction": 1, "knowledge": 2, "kind": 0, "id": 3, "name": "increase of sense-workers" }, { "direction": 1, "knowledge": 1, "kind": 0, "id": 4, "name": "increase in org. hybrid-think." }, { "direction": 0, "knowledge": 1, "kind": 0, "id": 5, "name": "rising critique of angel inv." }, { "direction": 0, "knowledge": 1, "kind": 0, "id": 6, "name": "social: DIY-movement" } ], "id": -1, "name": "Ungrouped Trends" } ], "initiatives": [ { "direction": 0, "knowledge": 3, "impact": 3, "progress": 54, "risk": 2, "disabled": false, "kind": 1, "id": 1, "name": "VIVA offices" }, { "direction": 0, "knowledge": 4, "impact": 4, "progress": 72, "risk": 2, "disabled": false, "kind": 1, "id": 2, "name": "Financial investment Dani" }, { "direction": 0, "knowledge": 4, "impact": 4, "progress": 50, "risk": 2, "disabled": false, "kind": 1, "id": 3, "name": "Knowledge-Investment" }, { "direction": 0, "knowledge": 4, "impact": 4, "progress": 86, "risk": 2, "disabled": false, "kind": 1, "id": 4, "name": "Financial investment Urs" }, { "direction": 0, "knowledge": 4, "impact": 4, "progress": 28, "risk": 2, "disabled": false, "kind": 1, "id": 5, "name": "Time investments" }, { "direction": 1, "knowledge": 2, "impact": 4, "progress": 15, "risk": 1, "disabled": false, "kind": 1, "id": 6, "name": "Active search for leads" }, { "direction": 1, "knowledge": 3, "impact": 4, "progress": 48, "risk": 2, "disabled": false, "kind": 1, "id": 7, "name": "Access to SIM" } ], "initiativeTrends": [ { "idInitiative": 1, "idTrend": 3, "influence": 3 }, { "idInitiative": 1, "idTrend": 4, "influence": 4 }, { "idInitiative": 2, "idTrend": 2, "influence": 2 }, { "idInitiative": 2, "idTrend": 3, "influence": 4 }, { "idInitiative": 2, "idTrend": 4, "influence": 4 }, { "idInitiative": 2, "idTrend": 5, "influence": 3 }, { "idInitiative": 3, "idTrend": 1, "influence": 4 }, { "idInitiative": 3, "idTrend": 2, "influence": 4 }, { "idInitiative": 3, "idTrend": 3, "influence": 5 }, { "idInitiative": 3, "idTrend": 4, "influence": 5 }, { "idInitiative": 3, "idTrend": 5, "influence": 3 }, { "idInitiative": 3, "idTrend": 6, "influence": 4 }, { "idInitiative": 4, "idTrend": 1, "influence": 4 }, { "idInitiative": 4, "idTrend": 2, "influence": 4 }, { "idInitiative": 4, "idTrend": 3, "influence": 5 }, { "idInitiative": 4, "idTrend": 4, "influence": 4 }, { "idInitiative": 4, "idTrend": 5, "influence": 4 }, { "idInitiative": 4, "idTrend": 6, "influence": 3 }, { "idInitiative": 5, "idTrend": 1, "influence": 5 }, { "idInitiative": 5, "idTrend": 2, "influence": 4 }, { "idInitiative": 5, "idTrend": 3, "influence": 5 }, { "idInitiative": 5, "idTrend": 4, "influence": 5 }, { "idInitiative": 5, "idTrend": 6, "influence": 5 }, { "idInitiative": 6, "idTrend": 3, "influence": 3 }, { "idInitiative": 6, "idTrend": 4, "influence": 4 }, { "idInitiative": 6, "idTrend": 6, "influence": 4 }, { "idInitiative": 7, "idTrend": 1, "influence": 2 }, { "idInitiative": 7, "idTrend": 3, "influence": 4 }, { "idInitiative": 7, "idTrend": 4, "influence": 3 }, { "idInitiative": 7, "idTrend": 6, "influence": 3 } ], "yesterday": 7, "today": 28, "tomorrow": 52.6 }, { "id": 1, "defName": "Value Creation", "name": "What is the value that Bluetools creates?", "extName": "socially beneficial", "intName": "economically profit- oriented", "subtensions": [ { "yesterday": 12, "today": 32, "tomorrow": 54, "id": 0, "extName": "idea", "intName": "concrete" }, { "yesterday": 13, "today": 59, "tomorrow": 62, "id": 1, "extName": "gift to society", "intName": "business" }, { "yesterday": 16, "today": 50, "tomorrow": 75, "id": 2, "extName": "single solution", "intName": "systemic solution" }, { "yesterday": 25, "today": 50, "tomorrow": 75, "id": 3, "extName": "front-end", "intName": "back-end" } ], "trends": [ { "direction": 1, "knowledge": 2, "kind": 0, "id": 1, "name": "LA: Trend for boutique-consul." }, { "direction": 0, "knowledge": 3, "kind": 0, "id": 2, "name": "Social: Social Focus" }, { "direction": 1, "knowledge": 3, "kind": 0, "id": 3, "name": "Sustainability Business-Inte. " }, { "direction": 1, "knowledge": 2, "kind": 0, "id": 4, "name": "Online-Education" }, { "direction": 0, "knowledge": 2, "kind": 0, "id": 5, "name": "Social: Open-mindedness" }, { "direction": 1, "knowledge": 0, "kind": 0, "id": 6, "name": "Strat.-Cons.: Standard Soluti." }, { "direction": 1, "knowledge": 4, "kind": 0, "id": 7, "name": "Create Internet Infrastru." }, { "direction": 1, "knowledge": 2, "kind": 0, "id": 8, "name": "Decentralization of organis." }, { "direction": 1, "knowledge": 0, "kind": 0, "id": 9, "name": "Competi. based on business mo." }, { "direction": 0, "knowledge": 2, "kind": 0, "id": 10, "name": "Internet access as human right" }, { "direction": 0, "knowledge": 3, "kind": 0, "id": 11, "name": "Social org. more strategic" }, { "direction": 0, "knowledge": 0, "kind": 0, "id": 12, "name": "TrendV12" } ], "groupTrends": [ { "trends": [ { "direction": 1, "knowledge": 2, "kind": 0, "id": 1, "name": "LA: Trend for boutique-consul." }, { "direction": 0, "knowledge": 3, "kind": 0, "id": 2, "name": "Social: Social Focus" }, { "direction": 1, "knowledge": 0, "kind": 0, "id": 6, "name": "Strat.-Cons.: Standard Soluti." }, { "direction": 1, "knowledge": 2, "kind": 0, "id": 8, "name": "Decentralization of organis." }, { "direction": 1, "knowledge": 0, "kind": 0, "id": 9, "name": "Competi. based on business mo." }, { "direction": 0, "knowledge": 3, "kind": 0, "id": 11, "name": "Social org. more strategic" }, { "direction": 1, "knowledge": 3, "kind": 0, "id": 3, "name": "Sustainability Business-Inte. " }, { "direction": 0, "knowledge": 0, "kind": 0, "id": 12, "name": "TrendV12" } ], "id": -1, "name": "Ungrouped Trends" }, { "trends": [ { "direction": 1, "knowledge": 4, "kind": 0, "id": 7, "name": "Create Internet Infrastru." }, { "direction": 0, "knowledge": 2, "kind": 0, "id": 10, "name": "Internet access as human right" }, { "direction": 0, "knowledge": 2, "kind": 0, "id": 5, "name": "Social: Open-mindedness" }, { "direction": 1, "knowledge": 2, "kind": 0, "id": 4, "name": "Online-Education" } ], "id": 1, "name": "Internet infrastructure" } ], "initiatives": [ { "direction": 1, "knowledge": 3, "impact": 4, "progress": 31, "risk": 1, "disabled": false, "kind": 1, "id": 1, "name": "Dani sales Switzerland" }, { "direction": 1, "knowledge": 3, "impact": 2, "progress": 58, "risk": 2, "disabled": false, "kind": 1, "id": 2, "name": "Sales-Presentation & Website" }, { "direction": 1, "knowledge": 1, "impact": 3, "progress": 41, "risk": 1, "disabled": false, "kind": 1, "id": 3, "name": "Fundes Joint Venture" }, { "direction": 1, "knowledge": 3, "impact": 4, "progress": 34, "risk": 1, "disabled": false, "kind": 1, "id": 4, "name": "Licensing Solution Development" }, { "direction": 1, "knowledge": 1, "impact": 1, "progress": 19, "risk": 0, "disabled": false, "kind": 1, "id": 5, "name": "Executive education INCAE" }, { "direction": 1, "knowledge": 2, "impact": 3, "progress": 29, "risk": 1, "disabled": false, "kind": 1, "id": 6, "name": "Back-end solution" }, { "direction": 0, "knowledge": 1, "impact": 1, "progress": 48, "risk": 1, "disabled": true, "kind": 1, "id": 7, "name": "VIVA Idea Licensing" } ], "initiativeTrends": [ { "idInitiative": 1, "idTrend": 1, "influence": 4 }, { "idInitiative": 1, "idTrend": 6, "influence": 4 }, { "idInitiative": 1, "idTrend": 9, "influence": 2 }, { "idInitiative": 1, "idTrend": 4, "influence": 2 }, { "idInitiative": 2, "idTrend": 6, "influence": 5 }, { "idInitiative": 2, "idTrend": 8, "influence": 3 }, { "idInitiative": 2, "idTrend": 9, "influence": 2 }, { "idInitiative": 2, "idTrend": 11, "influence": 5 }, { "idInitiative": 2, "idTrend": 4, "influence": 4 }, { "idInitiative": 3, "idTrend": 1, "influence": 5 }, { "idInitiative": 3, "idTrend": 6, "influence": 5 }, { "idInitiative": 3, "idTrend": 8, "influence": 5 }, { "idInitiative": 3, "idTrend": 11, "influence": 5 }, { "idInitiative": 3, "idTrend": 3, "influence": 5 }, { "idInitiative": 3, "idTrend": 4, "influence": 5 }, { "idInitiative": 4, "idTrend": 1, "influence": 5 }, { "idInitiative": 4, "idTrend": 6, "influence": 5 }, { "idInitiative": 4, "idTrend": 8, "influence": 3 }, { "idInitiative": 4, "idTrend": 9, "influence": 5 }, { "idInitiative": 4, "idTrend": 11, "influence": 4 }, { "idInitiative": 4, "idTrend": 3, "influence": 3 }, { "idInitiative": 4, "idTrend": 7, "influence": 5 }, { "idInitiative": 4, "idTrend": 4, "influence": 4 }, { "idInitiative": 5, "idTrend": 1, "influence": 3 }, { "idInitiative": 5, "idTrend": 6, "influence": 4 }, { "idInitiative": 5, "idTrend": 9, "influence": 2 }, { "idInitiative": 5, "idTrend": 11, "influence": 5 }, { "idInitiative": 5, "idTrend": 3, "influence": 5 }, { "idInitiative": 5, "idTrend": 7, "influence": 2 }, { "idInitiative": 5, "idTrend": 4, "influence": 5 }, { "idInitiative": 6, "idTrend": 1, "influence": 4 }, { "idInitiative": 6, "idTrend": 2, "influence": 2 }, { "idInitiative": 6, "idTrend": 6, "influence": 5 }, { "idInitiative": 6, "idTrend": 8, "influence": 5 }, { "idInitiative": 6, "idTrend": 9, "influence": 4 }, { "idInitiative": 6, "idTrend": 11, "influence": 5 }, { "idInitiative": 6, "idTrend": 3, "influence": 5 }, { "idInitiative": 6, "idTrend": 7, "influence": 5 }, { "idInitiative": 6, "idTrend": 10, "influence": 5 }, { "idInitiative": 6, "idTrend": 5, "influence": 2 }, { "idInitiative": 6, "idTrend": 4, "influence": 5 }, { "idInitiative": 7, "idTrend": 1, "influence": 5 }, { "idInitiative": 7, "idTrend": 2, "influence": 2 }, { "idInitiative": 7, "idTrend": 6, "influence": 5 }, { "idInitiative": 7, "idTrend": 8, "influence": 5 }, { "idInitiative": 7, "idTrend": 11, "influence": 5 }, { "idInitiative": 7, "idTrend": 3, "influence": 5 }, { "idInitiative": 7, "idTrend": 7, "influence": 5 }, { "idInitiative": 7, "idTrend": 4, "influence": 5 } ], "yesterday": 16.5, "today": 47.75, "tomorrow": 66.5, "ScrollElementId": -1 }, { "id": 2, "defName": "Self-Leadership", "name": "What is the motivation to be part of Bluetools?", "extName": "indep. \nentrepre.", "intName": "security", "subtensions": [ { "yesterday": 70, "today": 43, "tomorrow": 19, "id": 0, "extName": "FW: fulfilment", "intName": "FW: given tasks" }, { "yesterday": 49, "today": 27, "tomorrow": 19, "id": 1, "extName": "JV: fulfilment", "intName": "JV: given tasks" }, { "yesterday": 10, "today": 39, "tomorrow": 75, "id": 2, "extName": "DL: fulfilment", "intName": "DL: given tasks" }, { "yesterday": 96, "today": 50, "tomorrow": 25, "id": 3, "extName": "UJ: fulfilment", "intName": "UJ: given tasks" } ], "trends": [ { "direction": 1, "knowledge": 2, "kind": 0, "id": 1, "name": "Social: Request of standardiz." }, { "direction": 0, "knowledge": 2, "kind": 0, "id": 2, "name": "Social: Gig-Economy" }, { "direction": 0, "knowledge": 2, "kind": 0, "id": 3, "name": "Millenials need for self-fulf." }, { "direction": 1, "knowledge": 3, "kind": 0, "id": 4, "name": "Need for basic security" }, { "direction": 0, "knowledge": 2, "kind": 0, "id": 5, "name": "Rising critic on current secu." } ], "groupTrends": [ { "trends": [ { "direction": 1, "knowledge": 2, "kind": 0, "id": 1, "name": "Social: Request of standardiz." }, { "direction": 0, "knowledge": 2, "kind": 0, "id": 2, "name": "Social: Gig-Economy" }, { "direction": 0, "knowledge": 2, "kind": 0, "id": 3, "name": "Millenials need for self-fulf." }, { "direction": 1, "knowledge": 3, "kind": 0, "id": 4, "name": "Need for basic security" }, { "direction": 0, "knowledge": 2, "kind": 0, "id": 5, "name": "Rising critic on current secu." } ], "id": -1, "name": "Ungrouped Trends" }, { "trends": [], "id": 1, "name": "Pura Vida" } ], "initiatives": [ { "direction": 1, "knowledge": 4, "impact": 2, "progress": 47, "risk": 2, "disabled": false, "kind": 1, "id": 1, "name": "Accounting by Dani" }, { "direction": 1, "knowledge": 3, "impact": 3, "progress": 56, "risk": 1, "disabled": false, "kind": 1, "id": 2, "name": "Salary to Florian" }, { "direction": 1, "knowledge": 3, "impact": 4, "progress": 31, "risk": 1, "disabled": false, "kind": 1, "id": 3, "name": "Process of implementation" }, { "direction": 0, "knowledge": 1, "impact": 3, "progress": 6, "risk": 0, "disabled": false, "kind": 1, "id": 4, "name": "Book on Bluetools" }, { "direction": 1, "knowledge": 4, "impact": 4, "progress": 100, "risk": 2, "disabled": false, "kind": 1, "id": 5, "name": "Team" } ], "initiativeTrends": [ { "idInitiative": 1, "idTrend": 1, "influence": 5 }, { "idInitiative": 1, "idTrend": 3, "influence": 3 }, { "idInitiative": 1, "idTrend": 4, "influence": 5 }, { "idInitiative": 2, "idTrend": 2, "influence": 2 }, { "idInitiative": 2, "idTrend": 3, "influence": 5 }, { "idInitiative": 2, "idTrend": 4, "influence": 5 }, { "idInitiative": 2, "idTrend": 5, "influence": 2 }, { "idInitiative": 3, "idTrend": 1, "influence": 4 }, { "idInitiative": 3, "idTrend": 2, "influence": 1 }, { "idInitiative": 3, "idTrend": 3, "influence": 2 }, { "idInitiative": 3, "idTrend": 4, "influence": 3 }, { "idInitiative": 4, "idTrend": 1, "influence": 4 }, { "idInitiative": 4, "idTrend": 5, "influence": 5 }, { "idInitiative": 5, "idTrend": 1, "influence": 3 }, { "idInitiative": 5, "idTrend": 3, "influence": 2 }, { "idInitiative": 5, "idTrend": 4, "influence": 3 } ], "yesterday": 56.25, "today": 39.75, "tomorrow": 34.5 }, { "id": 3, "defName": "Leadership", "name": "How does leadership within Bluetools take place ?", "extName": "collective", "intName": "directive", "subtensions": [ { "yesterday": 25, "today": 59, "tomorrow": 50, "id": 0, "extName": "knowledge-driven", "intName": "market-driven" }, { "yesterday": 25, "today": 75, "tomorrow": 53, "id": 1, "extName": "philosophy", "intName": "tool" }, { "yesterday": 87, "today": 22, "tomorrow": 73, "id": 2, "extName": "Partner-Model", "intName": "Role-Model" }, { "yesterday": 75, "today": 20, "tomorrow": 94, "id": 3, "extName": "creative", "intName": "result-driven" } ], "trends": [ { "direction": 0, "knowledge": 3, "kind": 0, "id": 1, "name": "Mindfulness of employees" }, { "direction": 0, "knowledge": 2, "kind": 0, "id": 2, "name": "Participatory processes" }, { "direction": 0, "knowledge": 1, "kind": 0, "id": 3, "name": "Decentralized work structures" }, { "direction": 1, "knowledge": 3, "kind": 0, "id": 4, "name": "Request for given tasks" }, { "direction": 1, "knowledge": 3, "kind": 0, "id": 5, "name": "Revival of the family business" }, { "direction": 1, "knowledge": 3, "kind": 0, "id": 6, "name": "TrendL6" }, { "direction": 1, "knowledge": 3, "kind": 0, "id": 7, "name": "TrendL7" } ], "groupTrends": [ { "trends": [ { "direction": 0, "knowledge": 3, "kind": 0, "id": 1, "name": "Mindfulness of employees" }, { "direction": 0, "knowledge": 2, "kind": 0, "id": 2, "name": "Participatory processes" }, { "direction": 0, "knowledge": 1, "kind": 0, "id": 3, "name": "Decentralized work structures" }, { "direction": 1, "knowledge": 3, "kind": 0, "id": 5, "name": "Revival of the family business" }, { "direction": 1, "knowledge": 3, "kind": 0, "id": 6, "name": "TrendL6" }, { "direction": 1, "knowledge": 3, "kind": 0, "id": 7, "name": "TrendL7" } ], "id": -1, "name": "Ungrouped Trends" }, { "trends": [ { "direction": 1, "knowledge": 3, "kind": 0, "id": 4, "name": "Request for given tasks" } ], "id": 1, "name": "Hierarchy" } ], "initiatives": [ { "direction": 1, "knowledge": 3, "impact": 4, "progress": 46, "risk": 2, "disabled": false, "kind": 1, "id": 1, "name": "Administration infrastructure" }, { "direction": 1, "knowledge": 4, "impact": 4, "progress": 100, "risk": 2, "disabled": false, "kind": 1, "id": 2, "name": "Formalizing of Bluetools" }, { "direction": 1, "knowledge": 3, "impact": 3, "progress": 51, "risk": 1, "disabled": false, "kind": 1, "id": 3, "name": "Florian Co-CEO" }, { "direction": 1, "knowledge": 3, "impact": 4, "progress": 37, "risk": 0, "disabled": false, "kind": 1, "id": 4, "name": "Contracting of Programers" }, { "direction": 0, "knowledge": 1, "impact": 3, "progress": 9, "risk": 1, "disabled": false, "kind": 1, "id": 5, "name": "Capacitation of new entrants" } ], "initiativeTrends": [ { "idInitiative": 1, "idTrend": 2, "influence": 5 }, { "idInitiative": 1, "idTrend": 3, "influence": 5 }, { "idInitiative": 1, "idTrend": 4, "influence": 5 }, { "idInitiative": 3, "idTrend": 1, "influence": 3 }, { "idInitiative": 3, "idTrend": 2, "influence": 3 }, { "idInitiative": 3, "idTrend": 3, "influence": 4 }, { "idInitiative": 3, "idTrend": 4, "influence": 2 }, { "idInitiative": 4, "idTrend": 1, "influence": 4 }, { "idInitiative": 4, "idTrend": 2, "influence": 3 }, { "idInitiative": 4, "idTrend": 3, "influence": 3 }, { "idInitiative": 4, "idTrend": 4, "influence": 5 }, { "idInitiative": 5, "idTrend": 1, "influence": 5 }, { "idInitiative": 5, "idTrend": 2, "influence": 5 }, { "idInitiative": 5, "idTrend": 3, "influence": 3 }, { "idInitiative": 5, "idTrend": 4, "influence": 4 } ], "yesterday": 53, "today": 44, "tomorrow": 67.5 } ] }
-- I am a Newbie in programming with WINDEV - thanks to all who support me with their answers. |
| |
| |
| | | |
|
| | | | |
| | |
|