|
Re: HTTPCall parameters
Adrian Wick
Hello Graham,
i don't know why, but I had to change this setting in .ini file HTTPFramework = D in order to get the HTTPCall working. Else I was getting an empty return. Regards A |
||||||||
|
|
||||||||
|
Re: View PDF in an IOS App
Wolfgang Mayer
hello graham.
Thank you for your answer.
I have it now testet with 'file://_____.pdf'. unfortunately the same result. nothing is displayed.
even with the instructions in mastering.pdf from magic it doesn't work.
 no idea what's going wrong. |
||||||||
|
|
||||||||
|
Re: View PDF in an IOS App
Graham White
Hi,
I am not sure if you got this going but we just display the PDF in a Browser Control with an expression 'file://Name_Of_PDF.PDF' Regards Graham White |
||||||||
|
|
||||||||
|
HTTPCall parameters
Graham White
Hi,
I have been replacing places in our application that we having been using curl for and I have come across one that I can’t figure out. We use the curl statement below which works fine.
curl -k -X POST --header "Content-Type: application/x-www-form-urlencoded" -d grant_type=urn:ietf:params:oauth:grant-type:jwt-bearer&assertion=OURBEARER https://oauth2.googleapis.com/token
I have made my call HTTPCall('POST','https://oauth2.googleapis.com/token',Trim(BLOB containing “grant_type=urn:ietf:params:oauth:grant-type:jwt-bearer&assertion=OURBEARER”),'Content-Type: application/x-www-form-urlencoded’)
When I make this call I get an error saying Invalid Grant Type so I put the Grant Type as a header as per below
HTTPCall('POST','https://oauth2.googleapis.com/token',Trim(BLOB containing “grant_type=urn:ietf:params:oauth:grant-type:jwt-bearer&assertion=OURBEARER”),'Content-Type: application/x-www-form-urlencoded','grant_type=urn:ietf:params:oauth:grant-type:jwt-bearer')
This returns nothing.
Can anyone shed any light on how I should be structuring my HTTPCall?
Regards
Graham White
IMPORTANT NOTICE: This e-mail message and any attachments are confidential to EC Credit Control and subject to legal privilege (which is not waived or lost by mistaken delivery). If you have received this e-mail in error, please advise the sender immediately and destroy the message and any attachments. If you are not the intended recipient you are notified that any use, distribution, amendment, copying or any action taken or omitted to be taken in reliance of this message or attachments is prohibited. EC Credit Control collects personal information to provide and market our services (see our privacy policy at: www.eccreditcontrol.co.nz – www.eccreditcontrol.com - www.eccreditcontrol.com.au for more information about use, disclosure and access). EC Credit Control’s liability in connection with transmitting, unauthorised access to, or viruses in this message and its attachments is limited to resupply of any affected message or attachments. |
||||||||
|
|
||||||||
|
Re: Opening DBFs in XPA 3.3
Steven Burrows
We access Opera DBFs using ODBC with the “Microsoft Visual FoxPro Driver” 6.01.8629.01. I think its an old one (07/12/1999!), certainly not the current standard MS install.
Steven Burrows
From: main@magicu-l.groups.io <main@magicu-l.groups.io>
On Behalf Of Adrian Wick via groups.io
Sent: 04 December 2022 12:05 To: main@magicu-l.groups.io Subject: [magicu-l] Opening DBFs in XPA 3.3
Hi all, |
||||||||
|
|
||||||||
|
Re: Opening DBFs in XPA 3.3
Adrian Wick
So far, what i have done:
1. Created a User DSN 2. Data Source name: the name I also have in magic databases 3. Selected version (i have tried all 3, the results are always the same). 4. Unchecked the "Use current directory" and selected the one directory that has the dbf files. 5. Played with Collating Sequence but didn't see any difference. 6. Went into XPA and created a table name without the .DBF. 7. Hit F9 and I got the structure without indexes ... 8. Used directsql to see the data in the table, but it seems like the data is broken. Regards, A |
||||||||
|
|
||||||||
|
Re: Opening DBFs in XPA 3.3
Todd Baremore
A,
toggle quoted message
Show quoted text
If the dbf is part of a shape file, I've never been able to open it directly in Magic. If dbf2csv does not work, try using LibreOffice Calc which has always worked for me. Todd On 12/4/2022 7:04 AM, Adrian Wick
wrote:
Hi all, |
||||||||
|
|
||||||||
|
Opening DBFs in XPA 3.3
Adrian Wick
Hi all,
I tried searching the forums on how to get DBF files into magic, but couldn't find a working solution. Does anyone know the correct steps needed to be done in order for me to open a table in XPA? So far I know I have to use the ODBC in order to connect. Now some say I need to install a FoxPro driver, some say windows native ODBC for DBFs should work ... Should i just use "dbf2csv" to export data and give up on trying to use the ODBC? I have no idea what in what version the files are stored ... Regards, A |
||||||||
|
|
||||||||
|
Re: New ODBC-Based Gateway for MSSQL
yuvalasheri@...
Steve ,
There is a simple explanation to this development effort. More and more organizations consider running their apps on Linux for various reasons. On the other hand, lots of our customers use SQLServer as their main database. Since our existing SQLserver gateway is OLEDB based, as Steve rightly mentioned, moving to Linux becomes impossible. The only way to allow Windows based applications using SQLServer to become available on Linux was to provide a gateway that will exist on both platforms and will behave identically (as much as possible) . This is why ODBC was chosen. With xpa 4.9 you can decide to start using an ODBC based gateway to SQLServer, and run the same app on Linux. Our OLEDB based gateway for SQLServer (running on Windows) will continue on being maintained as it was before. Yuval |
||||||||
|
|
||||||||
|
New ODBC-Based Gateway for MSSQL
Dear Friends, Countrymen, and Fellow Prestidigitators,
I received an invoice yesterday from MSE for 2023 Support & Maintenance (S&M) and noted with interest the following excerpt from the accompanying marketing letter:  The item of particular interest to me follows the first bullet point, "A new ODBC based gateway..." The existing MSSQL gateway is, of course, based on OLEDB which, when Microsoft first released it, was to replace ODBC as the preferred generic database access method. You will recall that, at the time, ODBC was and had been poo-poo-ed as "legacy" and "brain-dead" and all the other reasons why NOT to implement something SO OLD AND USELESS. Isn't life interesting? New becomes old and old becomes new. Cycles. --
Steven G. Blank Ξ SGBlank Consulting Here's wishing you all, my friends, a safe, healthy, and happy holiday season. |
||||||||
|
|
||||||||
|
Re: 3.3 XPA start up time of the application compared to 1.9 UniPaaS
Adrian Wick
I am talking about signing into a project in runtime. After user logs in. The time it takes for the whole
project to appear on the screen, before user can start using it. Regards, A |
||||||||
|
|
||||||||
|
Re: 3.3 XPA start up time of the application compared to 1.9 UniPaaS
Dear A
Are you talking about loading a project (1) in the studio, or running the project (2)?.
|
||||||||
|
|
||||||||
|
3.3 XPA start up time of the application compared to 1.9 UniPaaS
Adrian Wick
Is there anything I can do to speed up the loading time of applications in 3.3 XPA? There is a big difference in start up time compared
to UniPaaS. Has anyone noticed this? Or am I doing something wrong? For example: UniPaaS takes 2-3 sec XPA takes 8-9 sec Regards A |
||||||||
|
|
||||||||
|
Re: DataView2.. Combo-Box Weirdness
Todd Baremore
Steve,
toggle quoted message
Show quoted text
"That's f****ng weird" Try making the virtual combo variable the last one in the data view. Beneath it add a virtual (not hidden) with the same data type as the combo and name it "_". Initialize _ to '', or 0 or whatever is appropriate for the variable. You still get the column in the export, but the values will be blank/null. Haven't tried this, pure conjecture. Jelly On 12/1/2022 9:57 AM, Steven Burrows
wrote:
|
||||||||
|
|
||||||||
|
DataView2.. Combo-Box Weirdness
Steven Burrows
This is a bit obscure, but someone may have come across it before. XPA481 We have a DataView process that excludes fields with certain names. Recently added a Virtual as a Combo Box with a Linked Data Table to a form. If we leave that virtual as visible to the DataView2 process, all works well, and it displays the looked up value. If the virtual is tagged as Hidden, a value from the Linked Table appears against another field that IS included in the view. Its not even the value you would get normally, it seems like the Linked Table is being used by this unrelated field and using that result.
Told you it was weird. Couldn’t code it if we wanted to!
Steven Burrows
|
||||||||
|
|
||||||||
|
View PDF in an IOS App
Wolfgang Mayer
Hi!
I've been trying to display a PDF in an IOS APP for a few days.
As explained in the help under "How Do I View a PDF in My Mobile Application?" it doesn't work. The file is found but not displayed.
The whole thing works in the Windows RIA app.
Does anyone have an idea where the error is?
In general, I think the topic of IOS is very poorly supported by Magic.
Thanks for your help. |
||||||||
|
|
||||||||
|
Re: XPA4 Project Modules
Steven Burrows
Thanks, that look like it.
Steven Burrows From: main@magicu-l.groups.io <main@magicu-l.groups.io>
On Behalf Of Tom Worthen via groups.io
Sent: 29 November 2022 20:14 To: main@magicu-l.groups.io Subject: Re: [magicu-l] XPA4 Project Modules
From what I found in the help they are only for web client projects.
I found this in the help for 4.7: Web Module Properties The Web Module folders are separate logical units in the Web Client application. You can create an independent Web Module per folder so that you can load these modules on demand. When you right-click on a folder under Program repository, a short-cut menu opens. Select Properties (Alt + Enter) option to open the Web Module properties dialog box, which contains the following properties:
When you create a Web Module for a desired folder, the following two files are created in the folder <project_name>\src\app\magic\<folder_name>:
When you set Load on Demand, in addition to above two files, the following file is created:
Hope that helps, Tom
From:
main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Steven Burrows
Noticed today that a Get Latest Source updated an object named “Project Modules” – Had never heard of it XPA Help was vague, but it sounds interesting. The Add Module menu item is always greyed out so I can only guess its some Web feature. Should I be able to add Modules to a regular non-Web Project, if so how, and what do Modules do ?
Steven Burrows
|
||||||||
|
|
||||||||
|
Re: XPA4 Project Modules
Tom Worthen
From what I found in the help they are only for web client projects.
I found this in the help for 4.7: Web Module Properties The Web Module folders are separate logical units in the Web Client application. You can create an independent Web Module per folder so that you can load these modules on demand. When you right-click on a folder under Program repository, a short-cut menu opens. Select Properties (Alt + Enter) option to open the Web Module properties dialog box, which contains the following properties:
When you create a Web Module for a desired folder, the following two files are created in the folder <project_name>\src\app\magic\<folder_name>:
When you set Load on Demand, in addition to above two files, the following file is created:
Hope that helps, Tom
From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Steven Burrows
Sent: Tuesday, November 29, 2022 12:39 PM To: main@magicu-l.groups.io Subject: [magicu-l] XPA4 Project Modules
Noticed today that a Get Latest Source updated an object named “Project Modules” – Had never heard of it XPA Help was vague, but it sounds interesting. The Add Module menu item is always greyed out so I can only guess its some Web feature. Should I be able to add Modules to a regular non-Web Project, if so how, and what do Modules do ?
Steven Burrows
|
||||||||
|
|
||||||||
|
XPA4 Project Modules
Steven Burrows
Noticed today that a Get Latest Source updated an object named “Project Modules” – Had never heard of it XPA Help was vague, but it sounds interesting. The Add Module menu item is always greyed out so I can only guess its some Web feature. Should I be able to add Modules to a regular non-Web Project, if so how, and what do Modules do ?
Steven Burrows
|
||||||||
|
|
||||||||
|
Emailing with two step authentication
sales professionalcomputingltd.com
I recently started getting this error when sending emails from my xpa application. <“NOT SENT: The SMTP Server requires a secure connection of the client was not authenticated”.>. I believe it is because Microsoft implemented 2 step authentication.
Regards to all |
||||||||
|
|
