Rocket MultiValue

I've added 3 attachments    file "OPENPYXLTEST.txt"   is this basic program that calls Python program named "openpyxlText.py".  From inside an Accuterm7  windows I RUN OPENPYXLTEST program 3 consecutive times. with out changing any code  or anything.  I get the output below.     As a test I ran this python code in Linux and windows neither test caused an error nor OS failure. We are using universe 11.3.4 The python openpyxl library is the most recent available.  I've attached the requirements20230111.txt file also that I created yesterday.I have a few print() statements in python code to show the flow.====== output from python openpyxlTest.py from AccuTerm 7 window ======>RUN OPENPYXLTESTCalled build_u2_objectLoading variablesreturn control to U2loaded start_U2excel methodAt top of method, load_csv_from_file()

sorry to post this again but for some reason I could not post a follow up question to derek's response, is xadmin the ONLY way to create accounts in unidatathanksdougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

i can create an unidata account using ext admin tool just fine but in universe (which is where I came from to unidata) there was a uv account that went to a universe menu where you could add/delete accounts amount  a lot of other things, is this not available in unidata?thanksdougc

Please excuse a basic question. but is it possible to delete an item from a select list like you can with an array?SelStr = ' WITH ORD.CODE = "A"  AND ORD.SHIP.DATE < "1/01/2023"'XCmd = 'SSELECT ORDERS' : SelStr : ' TO 1'CRT XCmd ; EXECUTE XCmd  LOOP    READNEXT ORD.ID FROM 1 ELSE EXIT          IF ORD.ID = 12192209 THEN      DELETE ORD.ID FROM 1?????         END   REPEATEND------------------------------Matthew WrightAnalystTomago Aluminium Co PTY Ltd.Tomago NSW AU------------------------------

I've been trying to write an ATGUI program using the data grid.  I want to change the row colors on some of the rows but not all. I was able to do it using the ATGUISETPROPS subroutine but it's pretty slow.  My grid displays that data quickly enough by filling it in with the ATGUISETPROPS and loading them all at once. There are only about 30 rows.  After they're displayed I make a second pass highlighting the special rows. It pops up the "Waiting..." dialog and you can watch the colors flow down.Is there anyway to set multiple row colors all at once like ATGUISETPROPS?When I refresh the grid with new data the highlights stay there. I tried setting all the foreground and background colors for the entire grid by using ATGUISETPROP and setting the col and row values to zero. I couldn't get it to work so instead of just setting the highlight colors I have to reset them all for each row whenever I load new data. Is there a better way to re-initialize the grid colors?

There was an SQL optimization error in 3.4.7 caused by using wildcard characters in your WHERE clause. This build fixes it. If you want this latest version, please contact D3 support and we'll get it to you.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

We ran into this recently and I thought I'd share. In the legacy/character version of our software, we normally prompt for dates using a two digit year (mm-dd-yy), iconving and oconving as needed.  Recently, a user entered "12-31-33" as a date.  The iconv returned -12418 (12-31-1933) rather than the expected value of 24107 (12-31-2033).  After researching this we discovered that Pick/Rocket and QM both default to dates entered with 2 digit years greater than 30 to be in the 1900's, years less than 30 as assumed to be in the 2000's  Note: iconving a date with a 4 digit year always returns the correct value..  QM does have a config setting that will allow you to override the cutoff, however rather than remembering to change the config setting every few years on every user system, we opted to add code to our legacy system that checks the iconv'ed value and adjusts it as needed.------------------------------Ben Cr

We ran into this recently and I thought I'd share. In the legacy/character version of our software, we normally prompt for dates using a two digit year (mm-dd-yy), iconving and oconving as needed.  Recently, a user entered "12-31-33" as a date.  The iconv returned -12418 (12-31-1933) rather than the expected value of 24107 (12-31-2033).  After researching this we discovered that Pick/Rocket and QM both default to dates entered with 2 digit years greater than 30 to be in the 1900's, years less than 30 as assumed to be in the 2000's  Note: iconving a date with a 4 digit year always returns the correct value..  QM does have a config setting that will allow you to override the cutoff, however rather than remembering to change the config setting every few years on every user system, we opted to add code to our legacy system that checks the iconv'ed value and adjusts it as needed.------------------------------Ben Cr

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates

I don't understand how MVIS pooled license work. Can I assume that a single pool license can hold a certain number of user licenses for use with MVIS out of all of the user licenses on the system? If I have a single application on my server does it only require a single pooled license? What if for some reason my API call takes longer than expected, does that prevent other users from connecting to MVIS site?How can I calculate the optimum number of pooled licenses I need to effectively run my new MVIS system?Jon

in the past as these are test VM's running rocky linux on my personal laptop I usually just disable the firewall so I can use ext admin tool to create accounts and suchbut if I wanted to keep the firewall up what ports do I need to open up so I can still access via ext admin tool?thanks

if not is there another way to handle moving files from one OS to anotherthank you dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

I'd like to use Adds Viewpoint enhanced, it works well with my application except - when my application switches from 80 to 132 column mode, it changes the emulation to VT100.  I haven't found the right place to tell me how to fix this.TIA,Bruce------------------------------Bruce AckmanVice PresidentLewis Supply Co IncRichmond VA US------------------------------

We are currently running UniData 8.2 on AIX 7.1 on soon to be Power10 IBM servers. We have roughly 2000 connections across "4" UniData instances linked by NFS and NFA data pointers sharing a pool of 22 Power server cpu running at smt8.Our management wants to look into moving to a cheaper Linux environment and I am trying to gauge how good or bad of an idea that is and what that would look like vs our AIX setup we have been running for 25+ years.We also have over 2000 AIX user accounts on each system, several hundred AIX printer queues, thousands of programming calls using and parsing output from various AIX commands. If we drop this on Linux, what programming changes would need done to make the code run, outside of all the AIX vs Linux OS command vetting?If you have a large UniData environment, I'd love to get on the phone and chat if anyone is up to it? Maybe even do a meet and great and see how your environment looks vs ours. Some knowl

Hy all i have field for cars license plate ... but users input data all the differents waylike for exemple: QAA.6814 QAA-6814 QAA 6814 QAA/6814 QAA6814 how to create an index so i can search the data... but ignoring the .-/ (space)  ???------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

UniVerse version 11.3.5 has been released on January 05 2023 for the below platforms/versions:AIX POWER       7.1,  7.2AlmaLinux       8CentOS       7,  8HP/UX ITANIUM       11.31Oracle Enterprise Linux x86       7,  8RedHat Enterprise Linux Intel       7,  8Rocky Linux       8Solaris SPARC       11Solaris Intel       11SuSE Linux Enterprise Server Intel       12.0,  15.0Windows       Windows 10,  Windows 11This product is available to order immediately via y

Relatively new to Accuterm but have an issue I've inherited from the last programmer....when using the 'required' option for data fields, attempting to close the screen with the top right screen 'X' returns the message that the field is required.  The documentation says the code should hit the validate and deactivate after the 'close' call but it doesn't seem to....as my debugs are not executing.I don't want to have to manually check / set required fields for every click - but I do need to allow the user to exit with the 'X' (CLose) feature without the error message.Anyone know what I might be doing wrong here? How do I keep the 'required' error from displaying when the top right X is clicked, while keeping that field required for all other clicks?Thanks!------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

I'd like to get certified as a UniVerse Administrator. Is there any word on when/where MV Universe will be held in 2023? Can I get certified taking an on-line test?Jon

Hello,We have a requirement to upload a file to an AWS endpoint using the POST method and multipart/form-dataWe have the pieces in place and parameters added using addRequestParameter function, however the file is not getting uploaded with its contents. When we check the contents of the file uploaded in the server it contains the filename itself.What are we missing?*---------------HTTP.POST.FILE:*---------------HTTP.METHOD="POST:multipart/form-data"TIMEOUT=3600svc_return_code = setHTTPDefault("VERSION", "1.1")** Create security context*X.SECURE.HANDLE = ""X.CONTEXT.RESULT = createSecurityContext(X.SECURE.HANDLE, "TLSv1.2") ** Create secure request

Hello everyone,We are planning to upgrade our UniVerse (UV) ERP system this year and also do a hardware refresh. We would like the hardware refresh to include running in a VM (we don't currently). Our current UV system is running on an IBM AIX server with Kaminario flash storage (~2TB) with our largest hashed file being 120GB / 23M records.Looking for any insight or opinions related to getting more speed and performance for UniVerse i.e. stick with AIX or go with another UNIX / Linux? Virtualize or don't virtualize? Nutanix VM or something else? Anything better than flash storage from Kaminario?Thanks in advance!