Recent Posts
1
Programming / Re: accept-encoding gzip issue with call "*plus/web/request"
« Last post by Mike King on Today at 12:21:30 AM »If you need to provide the content type to the request you can pass it in as the fifth parameter to *plis/web/request.
See https://manual.pvxplus.com/PXPLUS/Web%20Services/Overview.htm#submitting
To compress data use the CMP() function and strip the first byte as per the manual.
See https://manual.pvxplus.com/PXPLUS/Web%20Services/Overview.htm#submitting
To compress data use the CMP() function and strip the first byte as per the manual.
2
ODBC / Re: ODBC with latest MS Excel
« Last post by Mike Hatfield on May 09, 2024, 05:29:31 PM »Hi Devon & Tom,
I see that you found the same solution as I did.
Thanks to all for the responses
I see that you found the same solution as I did.
Thanks to all for the responses
3
Programming / accept-encoding gzip issue with call "*plus/web/request"
« Last post by Cedric on May 09, 2024, 04:30:25 PM »Hi, I would like to report 1 issue that I have juste encountered:
Unable to read compressed data like gzip for example. Normally, I would specify in the header "accept-encoding: none" and it would result in a non compressed response, but on this particular server, it seems they force the response in gzip no matter what I do. So, now I have to figure out how to handle this in PVX!
Unable to read compressed data like gzip for example. Normally, I would specify in the header "accept-encoding: none" and it would result in a non compressed response, but on this particular server, it seems they force the response in gzip no matter what I do. So, now I have to figure out how to handle this in PVX!
4
ODBC / Re: ODBC with latest MS Excel
« Last post by Tom Anderson on May 09, 2024, 03:44:56 PM »I see that MS Excel - Data - Get Data - Other Sources- MS Query has disappeared from the latest version of Excel.
How do we now run PxPlus ODBC ?
Thanks
Mike,
This worked for us:
https://answers.microsoft.com/en-us/msoffice/forum/all/the-excel-microsoft-query-menu-option-has/33158d52-6d06-46a9-b848-9656d9957671
Tom Anderson
5
Nomads / Re: numeric data in grid cells: how to round?
« Last post by James Zukowski on May 09, 2024, 03:34:19 PM »As a possibility, you could enable it before the load and disable it immediately after. That would minimize the potential crash time.
6
Nomads / Re: numeric data in grid cells: how to round?
« Last post by PMM_CAI on May 09, 2024, 03:17:44 PM »Thanks James. 'RI' did the trick, although we haven't decided about using it yet, since we don't want the behavior to be used elsewhere, and we might not want to risk turning it on in the pgm and then aborting out before turning it back off. But we are considering it! Thanks again.
Paula McKeever
CAI Software LLC
Paula McKeever
CAI Software LLC
7
ODBC / Re: ODBC with latest MS Excel
« Last post by Devon Austen on May 09, 2024, 08:03:51 AM »Hi Mike,
The newer option "From Other Sources->From ODBC" will show PxPlus ODBC data sources and you can use it to get at your data. The only exception being if you are using a version of PxPlus ODBC driver older than version 6.
The newer option "From Other Sources->From ODBC" will show PxPlus ODBC data sources and you can use it to get at your data. The only exception being if you are using a version of PxPlus ODBC driver older than version 6.
8
ODBC / Re: ODBC with latest MS Excel
« Last post by Mike Hatfield on May 09, 2024, 04:54:37 AM »Hi Ken, That is true but it doesn't allow the selections from the PxPlus ODBC 32/64 interface.
Typical of Microsoft to remove a feature that half the world uses without any explanation of how to work around.
However, I have done some research and I believe I have the solution.
You have to click on File - Options - Data
In Show Legacy data import wizards
tick From Data Connection Wizard (legacy)
tick From Microsoft Query (legacy)
OK
Back in the Spreadsheet
Click Data
Click Get Data
then in the Dropdown you will see Legacy Wiards - From Microsoft Queary (Legacy)
Et Voila!!
Typical of Microsoft to remove a feature that half the world uses without any explanation of how to work around.
However, I have done some research and I believe I have the solution.
You have to click on File - Options - Data
In Show Legacy data import wizards
tick From Data Connection Wizard (legacy)
tick From Microsoft Query (legacy)
OK
Back in the Spreadsheet
Click Data
Click Get Data
then in the Dropdown you will see Legacy Wiards - From Microsoft Queary (Legacy)
Et Voila!!
9
ODBC / Re: ODBC with latest MS Excel
« Last post by Ken Sproul on May 09, 2024, 01:06:50 AM »Mike,
I just applied the latest updates to Office 365.
My Excel is now showing: Version 2404 (Build 17531.20140 Click-to-Run)
On the Data ribbon the section Get & Transform Data still exists with a Get Data drop-down that contains:
Under "From Other Sources" is "From ODBC" among a bunch of other options.
What Version do you have?
I just applied the latest updates to Office 365.
My Excel is now showing: Version 2404 (Build 17531.20140 Click-to-Run)
On the Data ribbon the section Get & Transform Data still exists with a Get Data drop-down that contains:
- From File
- From Database
- From Azure
- From Power Platform
- From Other Sources
- Combine Queries
- Launch Power Query Editor...
- Data Source Settings...
- Query Options
Under "From Other Sources" is "From ODBC" among a bunch of other options.
What Version do you have?
10
ODBC / ODBC with latest MS Excel
« Last post by Mike Hatfield on May 08, 2024, 10:10:34 PM »I see that MS Excel - Data - Get Data - Other Sources- MS Query has disappeared from the latest version of Excel.
How do we now run PxPlus ODBC ?
Thanks
How do we now run PxPlus ODBC ?
Thanks