Downloads31
Subscribe
0
Bookmark
0
This application is not supported by InterSystems Corporation. Please be notified that you use it at your own responsibility.
Details
Releases
Reviews
Screenshots
Rewards
Issues

What's new in this version

fixed install for windows

Repo-GitHub

OEX-zapm

Docker-ports

appmsw-sql2xlsx

OEX GitHub last commit Demo

Module for exporting IRIS queries to an excel file using the python openpyxl library.

To demonstrate the possibilities, I used the fileserver and csvgen projects

Requirements

IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2021.2 (Build 649U) Thu Jan 20 2022 08:53:15 EST

Installation with ZPM

If ZPM the current instance is not installed, then in one line you can install the latest version of ZPM.

zn "%SYS" d ##class(Security.SSLConfigs).Create("z") s r=##class(%Net.HttpRequest).%New(),r.Server="pm.community.intersystems.com",r.SSLConfiguration="z" d r.Get("/packages/zpm/latest/installer"),$system.OBJ.LoadStream(r.HttpResponse.Data,"c")

If ZPM is installed, then exchange-rate-cbrf-ui can be set with the command

zpm:USER>install appmsw-sql2xlsx

Installation with Docker

Prerequisites

Make sure you have git and Docker desktop installed.

Installation

Clone/git pull the repo into any local directory

$ git clone https://github.com/SergeyMi37/appmsw-sql2xlsx.git

Open the terminal in this directory and run:

$ docker-compose build
  1. Run the IRIS container with your project:
$ docker-compose up -d

How to Test it

Open link: http://localhost:52663/apptoolsrest/a/xlsx&class=appmsw.python.demo

Link

Demo

ZPM installation
zpm "install appmsw-sql2xlsx"
Rating
5 (1)
Category
Solutions
Works with
InterSystems IRISInterSystems IRIS for Health
Tags
Info
Version
1.0.1
Last updated
2022-02-23
Repository
Open
Documentation
Open
License
Link