Article Muhammad Waseem · Feb 10, 2023 5m read Getting to know Python Flask Web Framework - Part 2 Hi Community, This article is a continuation of my article about Getting to know Python Flask Web Framework In this article, we will cover the basics of topics listed below: 1. Routing in Flask Framework2. Folder structure for a Flask app (Static and Template)3. Getting and displaying data in the Flask application from IRIS. So, let's begin. #Databases #HTML #JavaScript #Python #InterSystems IRIS for Health #Open Exchange Open Exchange app 2 0 0 927
Article Muhammad Waseem · Feb 9, 2023 2m read Step by step tutorial to add Interactive map and visualize geographic data to web application Hi Community,In this article I will demonstrate below steps to add Interactive map and visualize geographic data to web application: Step1 : Install Application Step2 : Create CSP Page Step3 : Extend dc.IrisGeoMap.Folium class Step4 : Invoke DrawGeoDetails() Method So Let us start. Step1 : Install Application First of all we need to install iris-geo-map application by using ZPM zpm "install iris-geo-map" #CSP #Embedded Python #JavaScript #InterSystems IRIS #Open Exchange Open Exchange app 1 0 1 216
Article Muhammad Waseem · Feb 6, 2023 3m read Plugin Interactive Maps and Visualize Geographic Data Hi CommunityIn this article, I will demonstrate the functionality of my app iris-geo-map #CSP #Embedded Python #JavaScript #InterSystems IRIS #Open Exchange Open Exchange app 2 0 0 287
Article Muhammad Waseem · Jan 24, 2023 4m read 5 useful SQL functions to take your SQL skills to the next level Hi Community, In this article, I listed 5 useful SQL functions with explanations and query examples 👇🏻These 5 functions are COALESCE RANK DENSE_RANK ROW_NUMBER Function to Get Running Totals So Let us start with COALESCE function #Beginner #Best Practices #SQL #Tips & Tricks #Caché 22 13 6 907
Article Muhammad Waseem · Sep 20, 2022 8m read Getting to know Python Flask Web Framework Hi Community,In this article, I will introduce Python Flask Web Framework. Together we will create a minimal web application to connect to IRIS and get data from it.Below you can find the steps we will need to follow: Step 1 : Introduction to Python Flask Web Framework Step 2 : Installation of Flask module Step 3 : Creation of web application using Flask Step 4 : Use of HTML Templates Step 5 : Installation of IRIS Python Native module Step 6 : Establishment of a connection with IRIS Step 7 : Transferring data from IRIS to Flask and displaying it So Let's start with step 1 Step1-Introduction to Python Flask Web Framework Flask is a small and lightweight Python web framework that provides useful tools and features that make creating web applications in Python easier. It gives developers flexibility and is a more accessible framework for new developers since it allows to build a web application quickly using only a single Python file. Flask is also extensible and doesn’t requires a particular directory structure or complicated boilerplate code before getting started. For more details please view Flask Documentations #Globals #HTML #Python #InterSystems IRIS for Health 2 2 1 551
Article Muhammad Waseem · Sep 13, 2022 5m read Sustainable energy data by calling API from the major Independent System Operators (ISOs) in the United States with the help of PEX and Embedded Python Hi Community,In this article I will demonstrate the functionality of my app iris-energy-isodata . Application is accessing energy data (production, demand and supply) from the major Independent System Operators (ISOs) in the United States to ensure sustainable consumption and production patterns (SDG's 12) #Contest #Embedded Python #Interoperability #Ensemble #InterSystems IRIS for Health Open Exchange app 3 2 0 262
Article Muhammad Waseem · Jul 10, 2022 10m read IRIS Climate Change application that shows how temperature is increasing worldwide as a proof of global warming Hi Community, This post is a introduction of my open exchange iris-climate-change application. iris-climate-change web application Imports The Food and Agriculture Organization (FAO) Climate Change dataset by using LOAD DATA (SQL) functionality and analyze and visualize data with the help of Python Flask Web Framework, Pandas Python data analysis Library, Plotly Open Source Graphing Library for Python and Plotly JavaScript Open Source Graphing Library. #Contest #Embedded Python #Python #Visualization #InterSystems IRIS Open Exchange app 14 0 0 384
Article Muhammad Waseem · Jul 2, 2022 6m read Display Management Portal Dashboard by using Python Flask web and Bootstrap Frameworks with the help of embedded python Hi Community, In this article I will explain how to display management portal dashboard by using Python Flask web and Boostrap framework with the help of embedded python #Best Practices #Embedded Python #Management Portal #SQL #InterSystems IRIS for Health Open Exchange app 18 1 2 1.3K
Article Muhammad Waseem · Jun 4, 2022 3m read Creating Patient and Patient Observations by using iris-fhir-client application Hi Community, This article will demonstrate how to create Patient and Patient Observation Resources by using iris-fhir-client application. I recommend to read my first article about this app and watch Youtube Video before continue so let's start #Embedded Python #FHIR #InterSystems IRIS for Health Open Exchange app 4 0 1 479
Article Muhammad Waseem · May 30, 2022 3m read FHIR Client to connect any open FHIR Server by using embedded python Hi Community, This post is a introduction of my open exchange iris-fhir-client application. iris-fhir-client can connect to any open FHIR Server by using embedded python with the help of fhirpy Library.Get Resource information by terminal and by using CSP web application. #Contest #CSP #Dashboards #Embedded Python #FHIR #InterSystems Package Manager (IPM) #ObjectScript #REST API #InterSystems IRIS for Health #Open Exchange Open Exchange app 6 2 0 636
Article Muhammad Waseem · Apr 5, 2022 7m read Using Globals as a graph database to store and retrieve graph structure data Hi Community, #Contest #CSS #Databases #Data Model #Python #Caché #InterSystems IRIS for Health #Open Exchange #VSCode Open Exchange app 2 2 1 554
Article Muhammad Waseem · Feb 24, 2022 2m read 2 steps to display cache tables data on the web by using jquery datatable and embedded python Hi, Community, This post will demonstrate how to display data on the web by using Embedded Python , Python Flask Web Framework and Jquery datatable We will display processes from %SYS.ProcessQuery table. #Dashboards #Databases #Embedded Python #JavaScript #SQL #InterSystems IRIS for Health Open Exchange app 1 0 0 1.4K
Article Muhammad Waseem · Feb 22, 2022 5m read Building IRIS Responsive dashboard with Python Flask Web Framework Hi Community, This post is a introduction of my openexchange iris-python-apps application. Build by using Embedded Python and Python Flask Web Framework. Application also demonstrates some of the Python functionalities like Data Science, Data Plotting, Data Visualization and QR Code generation. Features Responsive bootstrap IRIS Dashboard View dashboard details along with interoperability events log and messages. Use of Python plotting from IRIS Use of Jupyter Notebook Introduction to Data Science, Data Plotting and Data Visualization. QR Code generator from python. #CSS #Dashboards #Databases #Embedded Python #Python #Visualization #InterSystems IRIS for Health Open Exchange app 4 1 0 4.3K
Article Muhammad Waseem · Jan 14, 2022 3m read Plug and play DATASETS with ObjectScript Package Manager (ZPM) With the release of InterSystems IRIS 2021.2 Preview and all-new LOAD DATA functionality dataset can by added with Objectscript Package Manager (ZPM) Medical Datasets contains following 12 datasets. For dataset tables and data details please visit ONLINE DEMO by using SuperUser | SYS ID Dataset Name Tables Licence 1 Synthetic Medical Data 11 Public Domain 2 Health Care Analytics - 1 8 Public Domain 3 Global Suicide Data 7 Public Domain 4 COVID-19 Polls1 7 CC-BY 5 Cancer Rates by U.S. State 2 Public Domain 6 Opioid Overdose Deaths 2 Public Domain 7 Heart Disease Prediction 1 Public Domain 8 Yellowpages medical services dataset 1 Public Domain 9 Hospital ratings 1 Public Domain 10 Heart Failure Prediction 1 (CC BY 4.0) 11 Diabetes Dataset 1 Public Domain 12 Chronic Kidney Disease 1 Public Domain #Contest #CSP #InterSystems Package Manager (IPM) #InterSystems IRIS Open Exchange app 2 0 0 184
Article Muhammad Waseem · Jan 11, 2022 2m read Use of %SQL_Diag logging along with all-new LOAD DATA functionality In this article I will explain the usage of %SQL_Diag.Result and %SQL_Diag.Message table along with all-new LOAD DATA functionality. It is recommended to go through LOAD DATA documentation first. After successful operation LOAD DATA insert one record in %SQL_Diag.Result table and details are inserted in %SQL_Diag.Message table Below is the basic command when table is already created and source file does not contain header row. LOAD DATA FROM FILE 'C://TEMP/mydata.txt' INTO MyTable The file name must include a .txt or .csv (comma-separated values) suffix and both source and target have the same sequence of data columns. Loading from File Source: Header #Databases #SQL #Tips & Tricks #InterSystems IRIS Open Exchange app 3 1 0 228
Article Muhammad Waseem · Jan 10, 2022 4m read 12 Medical Datasets along with 43 tables dynamically created by using all-new LOAD DATA SQL functionality Application to import 12 Datasets along with 43 tables dynamically by using LOAD DATA command which loads data from a source into an IRIS SQL table. List of Datasets #Contest #CSS #Databases #InterSystems Package Manager (IPM) #SQL #InterSystems IRIS Open Exchange app 1 2 0 1.1K
Article Muhammad Waseem · Dec 4, 2021 3m read OAuth2 Authentication with GitHub account from IRIS Web Application In this article I will demonstrate basics of OAuth2 authentication with GitHub account with the help of online demo https://dappsecurity.demo.community.intersystems.com/csp/user/index.csp by using SuperUser | SYS #Authentication #GitHub #OAuth2 #InterSystems IRIS Open Exchange app 5 0 2 627
Article Muhammad Waseem · Nov 29, 2021 3m read OAuth2 and Basic Authentication, Authorization AND Auditing by code from Web Application In this article I will explain how to Authenticate, Authorize and Audit by code by using CSP Web Application along with Enabling /Disabling and Authenticate/Unauthenticate any Web Application. Online Demo is available on cloud https://dappsecurity.demo.community.intersystems.com/csp/user/index.csp (SuperUser | SYS) I recommend to watch the video before continue https://www.youtube.com/watch?v=qFRa3njqDcA Application Layout #Authentication #Best Practices #OAuth2 #InterSystems IRIS Open Exchange app 8 5 1 1.1K
Article Muhammad Waseem · Nov 17, 2021 2m read Deleting data to Caché by using ODBC connection from Appeon PowerBuilder In my previous articles I demonstrated the steps to connect, retrieve and save data to Caché from Appeon PowerBuilder by using ODBC.In this article I will demonstrated how to Delete data from Caché with Appeon PowerBuilder (https://www.appeon.com/products/powerbuilder) by using ODBC #ODBC #InterSystems IRIS 2 0 0 235
Article Muhammad Waseem · Nov 14, 2021 2m read Saving data to Caché by using ODBC connection from Appeon PowerBuilder In my previous articles I demonstrated the steps to connect and retrieve data from Caché from Appeon PowerBuilder by using ODBC.In this article I will demonstrated how to Save data to Caché with Appeon PowerBuilder (https://www.appeon.com/products/powerbuilder) by using ODBC #Databases #Caché 1 2 0 245