Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
31
Programming / Re: Error 13 on [tcp] connection with secure
« on: August 02, 2022, 10:56:28 AM »
Devon,
I tried this open: api.anvyl.com;443;secure;TLS1.1
Still got my error 13. My version doesn't support TLS1.2.
Mike, I did not have a cert bundle but downloaded the one you referenced and put it in my pvx base directory. Still a no go.
Thoughts?
Michael
I tried this open: api.anvyl.com;443;secure;TLS1.1
Still got my error 13. My version doesn't support TLS1.2.
Mike, I did not have a cert bundle but downloaded the one you referenced and put it in my pvx base directory. Still a no go.
Thoughts?
Michael
32
Programming / Error 13 on [tcp] connection with secure
« on: July 29, 2022, 11:27:43 AM »
This is version 15.1. When I attempt to use request the open on a website using ";secure" and port 443 I get an error 13. I can use postman and disable all but TLS 1.1 and I have no issue. Thoughts on how I might get the open.
33
Language / Re: Json element class
« on: July 12, 2022, 11:57:53 AM »
This will work. Thanks. I had considered it but couldn't find the exact syntax described. 
34
Language / Json element class
« on: July 12, 2022, 10:39:31 AM »
I am looping through a PO to build a json like this
po$["po.order_items.1.item"]="widget1"
po$["po.order_items.1.price"]="10.25"
po$["po.order_items.1.qty"]="2"
There could be anywhere between 1 and several hundred elements in the items array. Oddly, I need to output price as a numeric ( but not quantity). Is there a way to do this without have to specify *every* price element in the "with num()" phrase?
po$["po.order_items.1.item"]="widget1"
po$["po.order_items.1.price"]="10.25"
po$["po.order_items.1.qty"]="2"
There could be anywhere between 1 and several hundred elements in the items array. Oddly, I need to output price as a numeric ( but not quantity). Is there a way to do this without have to specify *every* price element in the "with num()" phrase?
35
Programming / Re: Loading a json pre version 11
« on: July 02, 2022, 08:15:47 AM »
Mike, it would it need be simpler were not Infor in the mix. I think the federal government takes lessons in arcane bureaucracy from them 
.
.
36
Programming / Loading a json pre version 11
« on: July 01, 2022, 02:39:07 PM »
All, I developed a routine to retrieve JSON data from an API and, developing at 11.5, used the dim load array$[all]=json$. My customer is running at 9.x and this feature is not available. Does anyone have a routine to load or parse a json. I have parsing ability, but it isn't foolproof.
37
Registration and Setup / Re: Linux Licensing
« on: June 21, 2022, 06:51:15 PM »
Thank you. I figured if Windows could do it so could linux but I didn't thing the -bkg did anything in linux.
38
Registration and Setup / Linux Licensing
« on: June 21, 2022, 12:39:23 PM »
I need to run a "stand alone" application that, unfortunately, needs to have PVX running on a Linux box and accessed via Windx. Can this be accomplished with a single user license. I'm afraid the simple client server instance will use a license and then the Windx connection will use one. Is this correct or can I get by with one license?
39
Web Services / Re: Setup EZWeb server and API calls
« on: June 02, 2022, 12:22:40 PM »
If I am reading your question correctly, you do not need EZ Web at all. Your pxplus pro will include *plus/web/request. This will easily allow you to send in a url and a payload (for a post endpoint). You can hit both REST and SOAP endpoints and receive the responses.
40
Language / Re: Json Element addressing
« on: May 24, 2022, 10:56:45 AM »
Stephan,
Except for having to add a "." after the first record #, this is perfect. Thanks! Thought I had tried that, but missed an index.
Michael
Except for having to add a "." after the first record #, this is perfect. Thanks! Thought I had tried that, but missed an index.
Michael
41
Language / Json Element addressing
« on: May 24, 2022, 10:16:30 AM »
I have this JSON:
{
"totalSize":1,
"done":true,
"records":[
{
"attributes":{
"type":"Order",
"url":"/services/data/v54.0/sobjects/Order/8012D0000016xq5QAA"
},
"Id":"8012D0000016xq5QAA",
"OrderNumber":"00000100",
"CreatedDate":"2022-02-21T13:13:01.000+0000",
"OrderItems":{
"totalSize":1,
"done":true,
"records":[
{
"attributes":{
"type":"OrderItem",
"url":"/services/data/v54.0/sobjects/OrderItem/8022D000001GgV5QAK"
},
"Id":"8022D000001GgV5QAK",
"Product2":{
"attributes":{
"type":"Product2",
"url":"/services/data/v54.0/sobjects/Product2/01t2D0000050iKrQAI"
},
"StockKeepingUnit":"25"
},
"Quantity":5.0,
"TotalPrice":1250.0
}
]
}
}
]
}
I cannot figure out how to address, the OrderItems, or the "records" under that element. The above is the result of a dim load test$=myjson$.
{
"totalSize":1,
"done":true,
"records":[
{
"attributes":{
"type":"Order",
"url":"/services/data/v54.0/sobjects/Order/8012D0000016xq5QAA"
},
"Id":"8012D0000016xq5QAA",
"OrderNumber":"00000100",
"CreatedDate":"2022-02-21T13:13:01.000+0000",
"OrderItems":{
"totalSize":1,
"done":true,
"records":[
{
"attributes":{
"type":"OrderItem",
"url":"/services/data/v54.0/sobjects/OrderItem/8022D000001GgV5QAK"
},
"Id":"8022D000001GgV5QAK",
"Product2":{
"attributes":{
"type":"Product2",
"url":"/services/data/v54.0/sobjects/Product2/01t2D0000050iKrQAI"
},
"StockKeepingUnit":"25"
},
"Quantity":5.0,
"TotalPrice":1250.0
}
]
}
}
]
}
I cannot figure out how to address, the OrderItems, or the "records" under that element. The above is the result of a dim load test$=myjson$.
42
Programming / Re: Need leading zeros in excel
« on: May 06, 2022, 09:41:32 AM »
When using excel UI if you put an apostrophe (hex 27) you get leading 0s displayed with no apostrophe. I have successfully added that to my output to get the desired effect in some cases. Other instances it fails, but it is worth a try.
43
Programming / Re: UCS-2
« on: May 06, 2022, 09:25:53 AM »
Thanks Mike. It is not clear to me using the cvs function how I specify 16 bit UTF-8.
44
Programming / UCS-2
« on: May 05, 2022, 05:25:42 PM »
I am having trouble using the SalesForce API and it appears it might be because those endpoints require UCS-2 encoding. Can anyone verify this, and more importantly does anyone have a function or routine that creates that encoding.
Thanks!
Michael
Thanks!
Michael
45
Programming / Re: GODEX G530 using commands to print
« on: April 06, 2022, 10:49:11 AM »
Danilo,
Configure the printer as you would any other except in windows use generic/text only as the driver, and don't give it a PxPlus driver. In *nix you can also specify no print driver. Simply open a channel to the device and print your ZPL or EPL commands. I have done this literally hundreds of times with different customers. The biggest mistake is usually to try and use the printer's own driver.
Hope this helps!
Michael
Configure the printer as you would any other except in windows use generic/text only as the driver, and don't give it a PxPlus driver. In *nix you can also specify no print driver. Simply open a channel to the device and print your ZPL or EPL commands. I have done this literally hundreds of times with different customers. The biggest mistake is usually to try and use the printer's own driver.
Hope this helps!
Michael