Rocket U2 | UniVerse & UniData

 View Only
  • 1.  What Python modules are you integrating with your U2 application?

    ROCKETEER
    Posted 07-24-2020 12:48

    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
    ------------------------------


  • 2.  RE: What Python modules are you integrating with your U2 application?

    PARTNER
    Posted 07-25-2020 11:33
    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
    ------------------------------



  • 3.  RE: What Python modules are you integrating with your U2 application?

    PARTNER
    Posted 07-26-2020 08:38
    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
    ------------------------------

    Attachment(s)



  • 4.  RE: What Python modules are you integrating with your U2 application?

    ROCKETEER
    Posted 07-27-2020 10:33
    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
    ------------------------------