|
RIA Deployment
Mulyadi Jet
|
|
|
|
Re: Using MS Excel for Dash Board integrating with uniPaaS 1.9
Wes Hein
Lado,
1. Use DataViewToText() to get it to a csv, then use OfficeCom to open the csv and save it as a xls if excel is installed and you are ok with xls, mostly easy. 2. Still use DataViewToText() to get it to a csv then read through the file and write each line to xlsx using a dll you will need to write using openxml and closedxml, not so easy but works without excel installed. 3. Write a dll using using openxml and closedxml that allows you to write to a dntable then convert the table to excel, also not so easy but gets you a xlsx and does not require excel to be installed. We do have a dll for option 2 but it is somewhat out of date and not really sharable as contains other features for our company as well. Once you use XPA this becomes much easier. Wes
|
|
|
|
Re: Transaction Processing in blended database environment
Tom,
toggle quoted messageShow quoted text
My specific experience in this regard was with Oracle on an HP9000 and Btrieve on NetWare4, and Magic v7.11h on a PC. And yes, both databases would either be committed or rolled-back together. It was pretty amazing, if I do say so myself. In a project for 3-Com’s US Robotics division in SLC, I wrote a transaction processor that read finished goods transactions from Oracle, blew through the related BOMs, relieved inventory of component parts and received the finished goods into inventory, all in Btrieve. When complete, the process closed the loop by marking the assembly line transaction created in Oracle as having been received. It had to be scalable and bulletproof. I recall testing at one point by simply pulling the plug on the PC to see if it could rollback and recover properly on restart. It did. I don’t recall any caveats or gotchas, just a shit-ton of testing. Steve Blank
On May 18, 2020, at 9:17 AM, Tom Worthen <tworthen@...> wrote:
|
|
|
|
Re: Transaction Processing in blended database environment
Tom Worthen
Steve,
Are you indicating if that flag is set that it will roll back both databases? Does the same hold true if the main table is Pervasive with links/updates to an MS-SQL database, that they would both be rolled back?
I presume you have had experience with this so shouldn’t question your knowledge but just wanting to make sure. J
Tom
From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Steven Blank
Sent: Friday, May 15, 2020 11:51 AM To: main@magicu-l.groups.io Subject: Re: [magicu-l] Transaction Processing in blended database environment
Tom,
In Options > Settings > Environment, on the Multi User tab, if Line 2, ISAM Transactions = Yes, then the transaction will be rolled back in Pervasive as well; else, not.
Steve Blank
On 5/15/2020 6:53 AM, Tom Worthen wrote:
|
|
|
|
Using MS Excel for Dash Board integrating with uniPaaS 1.9
Lado Wali
Hi Group, Just checking if we can integrate MS Excel with uniPaaS 1.9 to display exported data for graphical interface. In normal cases we export the data to xml and open in file in Excel to create the pivot and also create graphs. Just wondering if we can create some kind of excel template and then write the data from uniPaaS to Excel. Just wondering if someone can share their ideas. Thanks Lado
|
|
|
|
HTTPCALL /GET stopped working in XPA versions above 3.2
Avgerinos
Hi magicians
This is to report one more case related the the HTTPcall issue already reported to the group for XPA versions. In our case all HTTPcalls (/GET to Coinbase API) that used to work fine in version 3.2, are failing in all versions above (3.3. and 4.x) After failing to find the cause, we ended up using a non-Magic solution. Anyone knows if there is a ticket for this issue or a bug-fix version expected? Regards Avgerinos
|
|
|
|
limit how many windows the user can open
#ria
Ryan Guedes <ryanguedes2010@...>
Hello group, I would like to know if there is any way to limit how many windows the user can open
|
|
|
|
Re: Magic xpa 3.3 RIA - Link to Outlook
Darren
Hello Richard,
|
|
|
|
Re: Unipaas 1.9 mgconst.spn
Andy Jerison
I'd forgotten, but MSE withdrew most languages from the development environment at some point. Andy
On Sun, May 17, 2020, 16:42 Steven Blank <sgblank@...> wrote:
|
|
|
|
Re: Unipaas 1.9 mgconst.spn
Lupasa
Steven. Thank you.
|
|
|
|
Magic xpa 3.3 RIA - Link to Outlook
Richard Sainsbury
Hi
I'm preparing to convert an application to RIA in Magic xpa 3.3. One of the important features I use is linking to the user's local Outlook to send emails using Invoke Com from both Online and Batch tasks. Will I still be able to do that with RIA? Thanks in advance Richard
|
|
|
|
Re: Unipaas 1.9 mgconst.spn
I have uniPaaS v1.9p and just ran the installation/setup program to extract a copy, however, apparently, uniPaaS v1.9 does not offer Spanish language support any more, which I find very odd, but Spanish is indeed simply not listed. Sorry, but it would appear that you're out of luck.
On 5/17/2020 9:36 AM, Lupasa wrote:
|
|
|
|
Re: canadian magicians for coding and more
oldone
|
|
|
|
Re: Window State Property from Dot Net
Hi Mulyadi
I'm not sure I understand what you mean by "minimized in the back of homepage form". -- Gadi Birman
I know nothing (Manuel) Don't underestimate the power of the Source (GB)
|
|
|
|
Re: Unipaas 1.9 mgconst.spn
Lupasa
Thank you Steven. The thing is my installer is UniPaas 1.9i. No Spanish la gauge to choose. Regards.
|
|
|
|
Re: Window State Property from Dot Net
Mulyadi Jet
Hi Gadi,
toggle quoted messageShow quoted text
|
|
|
|
Re: Unipaas 1.9 mgconst.spn
One way to get this file would be to run the uniPaaS installation program again. Choose to modify the installation. Add the Spanish language. Complete the (re)installation and you’re done. Two minutes, tops.
toggle quoted messageShow quoted text
Steve Blank
On May 17, 2020, at 8:30 AM, lupasa@... wrote:
|
|
|
|
Unipaas 1.9 mgconst.spn
Lupasa
Hello.
I am looking for mgconst.spn file (spanish) for UniPaaS 1.9. Any help? Thank You.
|
|
|
|
Re: Testing libraries with ActiveX and Crystal Reports XI
Humberto C
Thank you, Humberto
El sábado, 16 de mayo de 2020 04:53:21 p. m. GMT-5, <przemm@...> escribió:
OK, Suppose you have an OCX you would like to generate a .NET wrapper for and this OCX is PRISMVW.OCX and it is located in ,say, C:\IBIZA\OCX . For this you need AXIMP.EXE tool . Find it on disk. For simplicity then copy this AXIMP.EXE to your equivalent of C:\IBIZA\OCX. Open command prompt (CMD) and CD to your equivalent of C:\IBIZA\OCX in the prompt. Type: AXIMP <yourocxfile> and hit ENTER . Eg in my case: AXIMP PRISMVW.OCX <ENTER>
If all is ok , two new DLL files will be generated – in my case PRISMVWLib.DLL and AxPRISMVWLib.DLL These are the .Net wrapper for this single OCX . You will need 2 DLL’s for every OCX you want to wrap.
You should copy those 2 files to a main XPA directory, the one that contains MGXPARuntime.EXE. Both development installation , and for every customer installation.
Now you should reference those 2 DLL’s in Magic CRR in your application ( what used to be under Shift-F7 in uniPaas ), type .Net. Also you have to reference some additional .Net libraries for the wrapper to work .
Below is a list of all .NET references that I settled on , by trial and error, some are possibly not needed , but hey , it works. System.Windows.Forms System.ComponentModel System.ComponentModel.Annotations System.ComponentModel.Composition System.ComponentModel.DataAnnotations System.ComponentModel.EventBasedAsync System.ComponentModel.Primitives System.ComponentModel.TypeConverter System netstandard
Add to that list both of the new DLL’s. 1. Add new line , choose type .NET , the .Net Assembly Selection dialog window will open.2. Choose Browse tab 3. Choose first DLL file , from your Magic directory , click OK 4. Repeat 1-3 for the other DLL
Now comes the hard part , blood , sweat and tears . 😉 You have to rip out anything that handles OCX and put in it’s place new and shiny .Net control stuff - for every occurrence of the OCX in your forms . For every OCX placed on the form you have to : 1. Add variable of type .Net2. Go to its properties , to Object Type , start typing by typing A . A list of various types opens and you can select your desired control ( in my case AxPRISMVWLib ) . Then when you have it in property field , type dot and then another list appears of subtypes and I choose AxPrismVw , so all in all I have ObjectType = AxPRISMVWLib.AxPrismVW 3. Put a .NET widget on you form ( the one with blue ball, green something and red cube) , at least this is what I chose in XPA v2 4. Open it’s property list , find a property called .Net Object , zoom there and choose your .Net variable. Let’s say it is variable with Magic code BE. 5. Then you have to replace each and every Invoke COM with .NET equivalent , the funniest part. Say , I had Invoke COM , Method SetZoomPercent , with single parameter in parameter table Now I can replace it with following expression: BE.SetZoomPercent(CB) It is quite neat: you type BE (as in your .net var code ) and dot – and list of valid methods appears , you choose one and then you even have tooltips about possible parameters so it’s not all horrible. In harder cases you could Invoke .NET and create C# snippet instead. 6. In theory you can even capture events ( as type .Net) , but I didn’t really use it .
For my simple use case it was sufficient . If you have problems with the above , ask questions , I will do my best to help , though I still learn XPA and C#Hope this helps someone Przemek
|
|
|
|
Re: Window State Property from Dot Net
Hello Mulyadi
Try the following: 1. Select a new dotnet variable B of type System.Windows.Forms.Form 2. In the Task Prefix of the child MDI cast the child form to variable B using the following Update operation: DNCast (DotNet.System.Windows.Forms.Form.FromHandle(WinHWND(0)),DotNet.System.Windows.Forms.Form) 3. Evaluate operation: B.BringToFront() -- Gadi Birman
I know nothing (Manuel) Don't underestimate the power of the Source (GB)
|
|
|