Universe and Python data extraction

Hello everyone  ,

Anyway where I can extract data directly from universe using python?

I want to pull data directly from universe and display it using python. 

Need some guidance here. 


Thank you.

------------------------------
Roland Kayver
Core Banking Support
Rocket Forum Shared Account
------------------------------

Roland,

Have you reviewed section 4 'Writing Python programs that access U2' from the UniVerse Python User Guide this is a good starting point on how to do this.

I have attached for you to review, once you have taken a lot at this, if there is any more help you need please ask the group again.

Thanks,


------------------------------
Jonathan Smith
UniData ATS
Rocket Support
------------------------------

Hello everyone  ,

Anyway where I can extract data directly from universe using python?

I want to pull data directly from universe and display it using python. 

Need some guidance here. 


Thank you.

------------------------------
Roland Kayver
Core Banking Support
Rocket Forum Shared Account
------------------------------

Following Jonathan's lead:

1) If U2 server based code then use the inbuilt interface to access UniVerse data. call U2 BASIC subroutines or execute TCL commands from Python
2) If client-based than look at UOPY (UniObjects for Python)

Unless absolutely wedded to a direct Python interface you could also consider creating a RESTful Web Service and consuming the service in Python. I'd add as a general guideline that for any data volume it is best to avoid single record reads and writes - try and perform business functions based upon a  reference Object Model - e.g. (based on an invoice and starting from an Invoice number):

Could

• Read invoice header from U2 into Python
• Loop on header in Python picking out each order line ad the corresponding product code
  • From Python read the description and item cost of each product individually from U2

Should

• Read invoice header from U2 into Python
• Call a  U2 subroutine to return all the required invoice body details, including the required details of each line item as a dynamic array in one call.

Generally the objective is to minimise the number (and hence the overheads) of calls between U2 and Python and maximise the 'received value' of each such invocation. 

Regards

JJ

------------------------------
John Jenkins
Thame, Oxfordshire
------------------------------

Roland,

Have you reviewed section 4 'Writing Python programs that access U2' from the UniVerse Python User Guide this is a good starting point on how to do this.

I have attached for you to review, once you have taken a lot at this, if there is any more help you need please ask the group again.

Thanks,


------------------------------
Jonathan Smith
UniData ATS
Rocket Support
------------------------------

Thank you Jonathan. 

No I have not. Will have a read and seek assistance if need be.

Thanks again!





------------------------------
Roland Kayver
Core Banking Support
Rocket Forum Shared Account
------------------------------

Thank you Jonathan. 

No I have not. Will have a read and seek assistance if need be.

Thanks again!





------------------------------
Roland Kayver
Core Banking Support
Rocket Forum Shared Account
------------------------------

Hi Jonathan,
Had a read about it and in the article it mentioned only univsers 12 + I'm currently using 11.2 . Just wondering if my version  supports U2 Python. 


For your advice.

Thanks.

------------------------------
Roland Kayver
Core Banking Support
Rocket Forum Shared Account
------------------------------

Following Jonathan's lead:

1) If U2 server based code then use the inbuilt interface to access UniVerse data. call U2 BASIC subroutines or execute TCL commands from Python
2) If client-based than look at UOPY (UniObjects for Python)

Unless absolutely wedded to a direct Python interface you could also consider creating a RESTful Web Service and consuming the service in Python. I'd add as a general guideline that for any data volume it is best to avoid single record reads and writes - try and perform business functions based upon a  reference Object Model - e.g. (based on an invoice and starting from an Invoice number):

Could

• Read invoice header from U2 into Python
• Loop on header in Python picking out each order line ad the corresponding product code
  • From Python read the description and item cost of each product individually from U2

Should

• Read invoice header from U2 into Python
• Call a  U2 subroutine to return all the required invoice body details, including the required details of each line item as a dynamic array in one call.

Generally the objective is to minimise the number (and hence the overheads) of calls between U2 and Python and maximise the 'received value' of each such invocation. 

Regards

JJ

------------------------------
John Jenkins
Thame, Oxfordshire
------------------------------

Thanks John .

WI'll look into Uni objects for Python. 


Cheers.

------------------------------
Roland Kayver
Core Banking Support
Rocket Forum Shared Account
------------------------------

Hi Jonathan,
Had a read about it and in the article it mentioned only univsers 12 + I'm currently using 11.2 . Just wondering if my version  supports U2 Python. 


For your advice.

Thanks.

------------------------------
Roland Kayver
Core Banking Support
Rocket Forum Shared Account
------------------------------

Hi Roland,

Python support was first added at UniVerse 11.3.1 for Linux and Windows.

Thanks,


------------------------------
Jonathan Smith
UniData ATS
Rocket Support
------------------------------

Hi Roland,

Python support was first added at UniVerse 11.3.1 for Linux and Windows.

Thanks,


------------------------------
Jonathan Smith
UniData ATS
Rocket Support
------------------------------

Thanks Jonathan. 

Thats means I need to upgrade from 11.2 to 12.3.1 and above.

Is there any chance to still use python in my current version (11.2) ?


For your advice. 
Thanks.

------------------------------
Roland Kayver
Core Banking Support
Rocket Forum Shared Account
------------------------------

Thanks Jonathan. 

Thats means I need to upgrade from 11.2 to 12.3.1 and above.

Is there any chance to still use python in my current version (11.2) ?


For your advice. 
Thanks.

------------------------------
Roland Kayver
Core Banking Support
Rocket Forum Shared Account
------------------------------

Roland,

You will have to upgrade to 11.3.1 or above. At 11.3.1 python was added for Windows and Linux only. If you want to use python on another platform you will have to upgrade past 11.3.1. Solaris was added at 11.3.2 , Aix was added at 12.1.1 and currently is not available for HP.

Thanks,



------------------------------
Jonathan Smith
UniData ATS
Rocket Support
------------------------------

Hello everyone  ,

Anyway where I can extract data directly from universe using python?

I want to pull data directly from universe and display it using python. 

Need some guidance here. 


Thank you.

------------------------------
Roland Kayver
Core Banking Support
Rocket Forum Shared Account
------------------------------

Roland,

Looking at the release notes for 11.3.2 it does state Python version 3.7 is now bundled with that release of UniVerse and supported on the AIX, Linux,Solaris Sparc, Solaris X86, and Windows platforms. I was looking at the internal tickets and they are not all marked as done in 11.3.2, hence my comments on the versions they were.

Looking deeper It does appear that they are all in 11.3.2 and the internal tickets here on our system have not been marked with the correct versions, I will ensure they are updated correctly to avoid any further confusion.

Thanks,

------------------------------
Jonathan Smith
UniData ATS
Rocket Support
------------------------------