PxPlus User Forum

Twitter Twitter Twitter

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.


Messages - Mike Hatfield

Pages: [1] 2 3 4
1
Registration and Setup / Installing in Azure Windows Virtual Desktop
« on: September 06, 2020, 10:48:41 PM »
We are going to do a trial migration for a small end user (only three users) to Azure Windows Virtual Desktop.
I wonder has anyone done this yet or have any experience or tips?
We are going to test in the 'Hosted Pool' environment first.
If that is not successful then we will test in the individual desktop environment.

Thanks

2
ODBC / Writing to data file from PxPlus ODBC in Excel
« on: May 08, 2020, 02:59:41 AM »
Hi All,

I remember a few years ago that I worked out how to use the ProvideX ODBC to update a Providex file from Excel.
1. Populate Excel using the Providex ODBC from dictionary defined file.
2. Modify a cell and then write that row back to the ProvideX file.
3. Delete a row and that 'record' would be deleted from the ProvideX file

I just can't remember what the ProvideX ODBC configuration was to achieve this.

Has anyone done this and care to share?

Thanks

3
Registration and Setup / Re: PDF port range?
« on: March 16, 2020, 01:52:24 AM »
Apologies if I'm over stepping but....Wow, I don't know about Adobe Ports but if you are saying all those ports are open to the outside world I'd be seriously looking at Simple Client Server.
That's an open invitation to get hacked.
The company insurers would not be happy if a more secure installation was possible and not implemented.
It's very easy to change from WindX to CS.
You only need a single port open that you can lock down.
Just my 10cents

4
Nomads / Re: How to exit a panel with an <Enter> key
« on: January 29, 2020, 04:09:00 AM »
I got it.
I had previously added post display logic to close the panel after 10 seconds. I've removed that and the <ENTER> works as expected now.
Thanks again.

5
Nomads / Re: How to exit a panel with an <Enter> key
« on: January 29, 2020, 04:05:22 AM »
Thank you.
I added the button and set the default property.
The tab stop shows the button to be the first control so I assume that control is active when I press the <ENTER> key.
I must be still missing something.
How/where do I set the on-change logic?
Thanks

6
Nomads / How to exit a panel with an <Enter> key
« on: January 29, 2020, 01:39:09 AM »
hi Folks,

A really, really dumb question.....
I have a really simple panel. All it does is display an image in the Pre-Display logic
All I want to do is have the panel close when I press the <ENTER> key.
Currently it only closes on <F4>
Normally I'd have an Exit or Close button or <F4> to close the panel.
Never wanted to do this before.

00110 PREDISPLAY_ICNQ_PICTURE:
00120 LET S$=ARG_1$
00130 LET IC_PHOTO=HFN
00140 LET STK_PHOTO$=%PATH_DATA$+"ic_images/"+CVS(S$(1,25),3)+".png"
00150 OPEN (IC_PHOTO,ERR=*NEXT)STK_PHOTO$; GOTO 0170
00160 LET STK_PHOTO$=%PATH_DATA$+"ic_images/noimage.png"
00170 CLOSE (IC_PHOTO)
00180 RETURN

Thanks
 

7
Is this update supposed to be available via the online update manager or is it a full install?
It is not appearing in the online update.
Thanks

8
Thanks guys.

I'll pass this on.
Funnily enough I did suggest upgrading to latest version a couple of weeks ago to avoid compatibility issues  :-[

9
Ubuntu version 18.04.3 and Pxplus version 10

THanks

10
Hi

Ubuntu latest version
PxPlus 10 64 bit

What is the procedure to install ssl library libssl.so.10
Thanks

11
Programming / JSON files
« on: August 22, 2019, 11:45:24 PM »
Hi All,

When I create JSON files from PxPlus each element terminates with comma+0A.
I note that most JASON files we process from other sources are a continuous stream of data with only a comma between elements.
If I parse the PxPlus file at https://jsonformatter.org/ is validates OK.

Is this correct for PxPlus or should I be doing something to eliminate the 0A ?

SMPRICE_JSON:
CLEAR SMPRICEJSON${ALL}
LET SMPRICEJSON$["Price Date"]=""
LET SMPRICEJSON$["Products.1.Inventory_SKU"]=""
LET SMPRICEJSON$["Products.1.List_Price"]=""

LET SMPRICEJSON$["Price Date"]=DYMD$
FOR I=1 TO 5
READ RECORD (ICM1)ICM1$
LET SMPRICEJSON$["Products."+STR(I)+".SKU"]=ICM1.STOCK_CODE$
LET SMPRICEJSON$["Products."+STR(I)+".Price"]=STR(ICM1.PRICES[1])
NEXT I
LET SMPRICE$=DIM(LIST EDIT SMPRICEJSON${ALL})
LET JSONFILE$="/hit/temp/czapijson.json";
       ERASE JSONFILE$,ERR=*PROCEED;
       SERIAL JSONFILE$;
       OPEN (HFN,ISZ=LEN(SMPRICE$))JSONFILE$;
       WRITE RECORD (LFO)SMPRICE$;
       CLOSE (LFO)

Thanks

12
Programming / Re: Writing CSV files
« on: July 03, 2019, 01:06:00 AM »
Hi Allen,

I thought that was true but wasn't sure.
The file will be imported to Magento 2.x and I wanted to be certain.
Thanks

BTW I just discovered *obj/excel
This is so easy to use, HOWEVER, how do you make it work in WindX where the file you are working with is on the NTHOST server and you are on a workstation that has Excel installed?
 

13
Programming / Writing CSV files
« on: July 02, 2019, 11:06:27 PM »
Hi all

I have to read a csv file, update the 6th column and write the record out again.
I know I could do this with a call to Excel but I can't remember how to do it. I think it would also be very slow.
So, instead I'm reading the input CSV, updating the 6th column and writing it out to a new CSV file.
This is great except the new file has quotes around each column.
How do I write the record without the quotes?

Thanks

00015  DIM CSVREC$[1:7]
00016  IOLIST CSVREC${ALL}:[STR(",")]
00021  OPEN (2)"/HIT/TEMP/CUSTOMER.CSV"
00022  LET CUSTOMEROUT$="/HIT/TEMP/CUSTOMEROUT.CSV"
00023  ERASE CUSTOMEROUT$,ERR=*NEXT
00024  SERIAL CUSTOMEROUT$
00025  OPEN LOCK (3)CUSTOMEROUT$
00030  READ (2,END=0500)IOL=0016
00032  CSVREC$[6]=123456"
00034  WRITE (3)IOL=0016

This becomes
name@gmail.com,base,default,David,Chard,,

this
"name@gmail.com","base","default","David","Chard","123456","",


14
Programming / Re: How to remove a file from an FTP server using Curl
« on: June 11, 2019, 04:51:22 AM »
This worked!
-O or -o is needed depending on whether you want to download to other than the current folder

curl -k -ssl --user username@servername.com.au:password -o \hit\somefolder\Magento\Orders\filename.txt ftp://ftp.servername.com.au/public_html/Future/Texts/ -Q "-DELE filename.txt"

I had to be patient though.
It appeared the file wasn't deleting whilst monitoring the ftp server with Filezilla.
It just takes a while to refresh.


15
Programming / Re: How to remove a file from an FTP server using Curl
« on: June 10, 2019, 11:05:40 AM »
Removing the space certainly made a difference.
It now produces a directory listing on the command window but doesn't delete anything.
That's because the ftp url ends with /Texts/ which generates a listing.
So it seems the -Q onwards was ignored.
As you say, time to consult with curl support.
Thanks for trying.

Pages: [1] 2 3 4