PxPlus User Forum

Twitter Twitter Twitter

Recent Posts

Pages: 1 ... 8 9 [10]
91
Off Topic / AWS or other Hosted Server for production environment
« Last post by Patrick Denny on July 13, 2022, 02:34:20 PM »
Does anyone have experience running a PxPlus production environment on AWS (or other)?
Would running an 8 - 20 user application using Windx (full accounting, customer management, manufacturing application) run well in that environment?
Would you recommend this for a client, rather than an on-site server?

Also curious about "cost estimates" for running a PxPlus production environment (multi-user) application via a Hosted Server service such as AWS. i.e. what are the monthly/annual costs of running a multi-user application on an AWS hosted server?

Looking for options to provide "always up" service to avoid down-time, especially when running in a small company.
92
Language / Re: Json element class
« Last post by michaelgreer on July 12, 2022, 11:57:53 AM »
This will work. Thanks.  I had considered it but couldn't find the exact syntax described.  ::)
93
Language / Re: Json element class
« Last post by Mike King on July 12, 2022, 11:44:59 AM »
Have you considered using the DIM CLASS directive as in:

po$["po.order_items.1.item"]="widget1"
po$["po.order_items.1.price"]="10.25"
dim class po$["po.order_items.1.price"]="N"
po$["po.order_items.1.qty"]="2"
dim class po$["po.order_items.1.qty"]="N"


Or perhaps make a simple function of it:

DEF FN_poSetNum(local idx$, local val)
 po$[idx$]=str(val)
 dim class po$[idx$]="N"
 return
End Def


Then

po$["po.order_items.1.item"]="widget1"
fn_poSetNum("po.order_items.1.price", 10.25)
fn_poSetNum("po.order_items.1.qty", 2)



94
Language / Re: Json element class
« Last post by St├ęphane Devouard on July 12, 2022, 10:58:13 AM »
Michael

Unless there are some undocument features in PxPlus JSON support via associative array, I have bad news : you must provide all the array keys that have numeric values in the with num() clause

PxPlus JSON support is great but it lacks some helper functions, especially in the area of JSON arrays
Something like DIM(READ NUM(json$["po.order_items."]) would be nice to count the number of elements in the order_items[] array
As well as being able to specify something like "po.order_items.{*}.price" in the with num() clause

Regards
95
Language / Json element class
« Last post by michaelgreer 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?
96
Programming / Re: *web/sftp
« Last post by Devon Austen on July 12, 2022, 08:28:11 AM »
Hi Peter,

If you can sometimes download the file and other times you can't that would possibly indicate the issue is on the sftp server. Likely sometimes the file is locked by a program updating it for example. The best you can do in that situation is to handle errors like that by trying again a few times before giving up.

Another probably less likely possibility is that sometimes your current directory is different so maybe using a absolute path would help /HOME/USERNAME/PO/OUT
97
Programming / Re: Create Excel Spreadsheet from PvxPlus
« Last post by Tom Anderson on July 12, 2022, 07:28:08 AM »
Thanks Peter.

I hope you are well.
98
Programming / Re: Create Excel Spreadsheet from PvxPlus
« Last post by Peter.Higgins on July 12, 2022, 06:27:56 AM »
Tom,
Writing to Excel can be slow.  The fastest way I've found is to use the excel PasteSpecial() command which is fast and works on windows and Linux.  This doesn't require the sheet to be in the foreground to catch errant keystrokes.

CLIP_BOARD WRITE data$
SheetObjectHandle'RANGE(R$)'PasteSpecial()
 
99
Programming / *web/sftp
« Last post by Peter.Higgins on July 11, 2022, 08:28:30 PM »
At one location, CALL "*web/sftp;receive" returns the sporadic error below.  I have tried PO/OUT /PO/OUT ~/PO/OUT & /~/PO/OUT and still get the error a few times a day.  File: is the FilesToReceive variable sent.

*web/sftp;receive:Error: /~/PO/OUT not found on server.
File: /~/PO/OUT|B0

Is there a way to debug this?
100
iNomads / Re: %inomads'upload_file() times out
« Last post by Mike King on July 11, 2022, 09:21:31 AM »
No -- the start_up is fine
Pages: 1 ... 8 9 [10]