Recent Posts
1
ODBC / Re: ODBC with latest MS Excel
« Last post by Mike Hatfield on Today at 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
2
Programming / accept-encoding gzip issue with call "*plus/web/request"
« Last post by Cedric on Today at 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!
3
ODBC / Re: ODBC with latest MS Excel
« Last post by Tom Anderson on Today at 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
4
Nomads / Re: numeric data in grid cells: how to round?
« Last post by James Zukowski on Today at 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.
5
Nomads / Re: numeric data in grid cells: how to round?
« Last post by PMM_CAI on Today at 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
6
ODBC / Re: ODBC with latest MS Excel
« Last post by Devon Austen on Today at 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.
7
ODBC / Re: ODBC with latest MS Excel
« Last post by Mike Hatfield on Today at 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!!
8
ODBC / Re: ODBC with latest MS Excel
« Last post by Ken Sproul on Today at 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?
9
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
10
Nomads / Re: numeric data in grid cells: how to round?
« Last post by James Zukowski on May 08, 2024, 08:44:49 AM »Not sure if this would apply... Have you checked out the 'RI' and 'RN' parameters?