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 5
16
Thin Client/WindX / Re: Client-side FID(0)
« on: January 12, 2021, 05:47:05 PM »
in the past we had a requirement that a specific computer be assigned a specific fid so that a user could print to a specific printer but in the long run we found that to be cumbersome and restrictive.
We now have multiple methods of assigning fid.
A 'next' available from a fid pool
A range of fids dependant on a subnet
A specific fid based on computer id
A specific fid based on the user login - either from the local computer login name or domain login name or the application login name.
All this is controlled and assigned at the STARTUP or Application login.
Ultimately we don't really care what the fid actually is so long as it is unique.

17
Thin Client/WindX / Re: Client-side FID(0)
« on: January 12, 2021, 04:59:17 PM »
If the user starts multiple sessions on the PC do you expect each session to have a different FID or the same FID?

18
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

19
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

20
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

21
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.

22
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

23
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
 

24
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

25
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  :-[

26
Ubuntu version 18.04.3 and Pxplus version 10

THanks

27
Hi

Ubuntu latest version
PxPlus 10 64 bit

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

28
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

29
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?
 

30
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","",


Pages: 1 [2] 3 4 5