Skip to main content

What Python modules are you integrating with your U2 application?

  • July 24, 2020
  • 3 replies
  • 0 views

Mike Rajkowski
Forum|alt.badge.img+1

With close to 250 thousand projects on https://pypi.org/, it is not likely any of us will have a chance to try them all.

Please reply to this discussion with a short comment on any python module/package you feel would be of interest to the group.


For example:

Recently, Louis Tur and I published blog posts on using Twilio to send SMS Text Messages.

How to Send SMS Text Messages from U2 with Python

WHY SEND SMS TEXT MESSAGES FROM U2 WITH PYTHON



------------------------------
Michael Rajkowski
Rocket Software
------------------------------

3 replies

Manu Fernandes
Forum|alt.badge.img+2
  • Inspiring
  • 257 replies
  • July 25, 2020

With close to 250 thousand projects on https://pypi.org/, it is not likely any of us will have a chance to try them all.

Please reply to this discussion with a short comment on any python module/package you feel would be of interest to the group.


For example:

Recently, Louis Tur and I published blog posts on using Twilio to send SMS Text Messages.

How to Send SMS Text Messages from U2 with Python

WHY SEND SMS TEXT MESSAGES FROM U2 WITH PYTHON



------------------------------
Michael Rajkowski
Rocket Software
------------------------------
hi,
We use python from years, before u2 implement it dwith uniBasic.
our main modules are :
- xlwt, xlrd, xlutils and/or openpyxl to prepare Excel files
- qrcode to encode text to QRcode binary values, used into postscript form
- gdata to interact with Google services
- jwt for some json manipulation,
- cryptography for certificate encoding/decoding
- oauth2client for oauth interfaces encryption, decryption
regards.






------------------------------
Manu Fernandes
------------------------------

Manu Fernandes
Forum|alt.badge.img+2
  • Inspiring
  • 257 replies
  • July 26, 2020
hi,
We use python from years, before u2 implement it dwith uniBasic.
our main modules are :
- xlwt, xlrd, xlutils and/or openpyxl to prepare Excel files
- qrcode to encode text to QRcode binary values, used into postscript form
- gdata to interact with Google services
- jwt for some json manipulation,
- cryptography for certificate encoding/decoding
- oauth2client for oauth interfaces encryption, decryption
regards.






------------------------------
Manu Fernandes
------------------------------
In detail, the use of the xlrd / xlwt module to export data directly into an MSExcel file.
On the one hand, we attach great importance to being able to perform tasks by the server without calling on the capacity of a client.
On the other hand, we always try to create simple routine to do a job and not train all our programmers in the techniques used.
In this example, we have defined a 'script template' in python, an SB process that receives documented parameters and AM / VM / SVM data.
Any application programmer can therefore on the one hand prepare the data and simply request an XLS format, and on the other hand, he can develop the python script without compromising the default one.
Here are the calling program parameters : 
* PARAM <1>: FILE.DEST: name of the destination file
* PARAM <2>: directory: local! sbc remote
* PARAM <3>: open immediately _yes / _no
* PARAM <4>: FILE_OF_PYSCRIPT_CANVAS; optional default INDEFN
* PARAM <5>: RECORDID_OF_PYSCRIPT_CANVAS; optional default PY.DTA.TO.XLS
* PARAM <6, mv>: TITLE: title of the array tag # TITLE #
* PARAM <7>: orientation of the header / data tables: (1 = default) VM, AM (the rows in VM; the columns in AM) (2) AM, VM (the rows in am; the columns in vm)
* PARAM <8, mv, sv>: COL.HEADER: column header; oriented according to <5>
* PARAM <9, mv, sv>: COMMENT: comment added at the bottom of the sheet
* PARAM <10, mv>: SHEET.NAME: title of the page tag # SHEET # if empty then we take title
* PARAM <11 +, y>: COL.DATA: column data in the format: am = row; vm = column or the reverse: am = column; vm = line;
* ------------------------------------------------- -------------------------------
linked I share our py script and SBprocess py.dta.to.xls and our py default p.xls.out.py 
enjoy

------------------------------
Manu Fernandes
------------------------------

Mike Rajkowski
Forum|alt.badge.img+1
  • Author
  • Rocketeer
  • 162 replies
  • July 27, 2020
In detail, the use of the xlrd / xlwt module to export data directly into an MSExcel file.
On the one hand, we attach great importance to being able to perform tasks by the server without calling on the capacity of a client.
On the other hand, we always try to create simple routine to do a job and not train all our programmers in the techniques used.
In this example, we have defined a 'script template' in python, an SB process that receives documented parameters and AM / VM / SVM data.
Any application programmer can therefore on the one hand prepare the data and simply request an XLS format, and on the other hand, he can develop the python script without compromising the default one.
Here are the calling program parameters : 
* PARAM <1>: FILE.DEST: name of the destination file
* PARAM <2>: directory: local! sbc remote
* PARAM <3>: open immediately _yes / _no
* PARAM <4>: FILE_OF_PYSCRIPT_CANVAS; optional default INDEFN
* PARAM <5>: RECORDID_OF_PYSCRIPT_CANVAS; optional default PY.DTA.TO.XLS
* PARAM <6, mv>: TITLE: title of the array tag # TITLE #
* PARAM <7>: orientation of the header / data tables: (1 = default) VM, AM (the rows in VM; the columns in AM) (2) AM, VM (the rows in am; the columns in vm)
* PARAM <8, mv, sv>: COL.HEADER: column header; oriented according to <5>
* PARAM <9, mv, sv>: COMMENT: comment added at the bottom of the sheet
* PARAM <10, mv>: SHEET.NAME: title of the page tag # SHEET # if empty then we take title
* PARAM <11 +, y>: COL.DATA: column data in the format: am = row; vm = column or the reverse: am = column; vm = line;
* ------------------------------------------------- -------------------------------
linked I share our py script and SBprocess py.dta.to.xls and our py default p.xls.out.py 
enjoy

------------------------------
Manu Fernandes
------------------------------
Manu,

Thanks for the great post and the detail, this is exactly the type of exchange of information I hoped for with my initial post.

------------------------------
Michael Rajkowski
Rocket Software
------------------------------