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 - bbssupport

Pages: [1]
1
Language / Re: 'XK'
« on: August 12, 2020, 05:43:57 PM »
Hi Mike,

Thanks for your reply. I makes sense that depending on the file and data structure, that results would vary.

Can I enable the XK parameter and issue a KEYED LOAD on each file to convert them to the enhanced VLR format, or do i need to recreate the file from scratch? Is there a way to detemine if a file is an enhanced VLR vs a standard VLR so that i can confirm the conversions have occurred?

2
Language / 'XK'
« on: August 12, 2020, 01:17:20 AM »
Hi PxPlusers!

I've been playing around with the XK parameter on a few of our data files but i'm not seeing much of a reduction in file size or increase in performance. Running the test programs from the users guide gives me the results described, so its just possible that the files i'm converting don't benefit much from the enhanced VLR format. I would like to do away with segmenting however, so I would like to convert all our files across to the newer format.

Can someone advise
1) is there a way to see (eg using FID/FIN etc) if a file is an enhanced VLR file (ie was created with the XK parameter turned on).
and
2) do i have to completely recreate each file with the XK parameter set, including the data dictionary, copy the data across, and then replace the original file with the new file? I read somewhere that you can issue a 'keyed load' to convert an enhanced VLR file back to a standard VLR so that it can be read by older PVX/PXPLUS versions.... does the same apply the other way?

Thanks :)

3
Registration and Setup / Re: CCP License Temporary Activation
« on: June 18, 2020, 12:10:55 AM »
Follow-up question, for future reference as we struggled with this when we upgraded all our CCP licenses from v12 to v16...what would be the recommended procedure to upgrade from an older ProvideX or PxPlus to the latest PxPlus version?

4
Registration and Setup / Re: CCP License Temporary Activation
« on: June 16, 2020, 09:42:18 PM »
Hi Mike,

Thank you for your reply.

I've gotten my head around how to implement the upgrade, my only concern was not having up-to-date keys for an emergency temporary activation. I will request a list of keys for the version we are using with our CCP licenses via my dealer.

Thanks,

Chris

5
Registration and Setup / Re: CCP License Temporary Activation
« on: June 15, 2020, 01:28:54 AM »
Hi All,

Does anyone have any advice on the post above? Would I be better cancelling CCP on all our licenses perhaps and just purchase version upgrades as needed?

6
Registration and Setup / CCP License Temporary Activation
« on: May 25, 2020, 08:50:51 PM »
Hi All,

I asked this question through my dealer but the answer I got from PxPlus didn't make any sense to me so I thought I'd ask here in case there was a misunderstanding.

Lets say I have a set of registration keys for a license from back when it was purchased and they are for version 13. This license is on CCP. When installed, we used the online registration to activate the license on version 16 and this works because the online activation system knows the license is on CCP. All works well.

Now lets say that customers server crashes and we have to restore from a backup to new hardware, or we for some other reason need to urgently migrate the customer to a new server. I need to get the customer up and running on a temporary license, and then request a license move or reset once they are back in business and we can breathe again.

The keys we have on file are for version 13, so if I install v16 and try to apply the v13 keys to get them up and running we receive errors like 'not activated for this software package'. If i try to run the online activation to make the software realize that these keys have CCP associated with them we receive the message 'This serial is already registered'.

If i install version 13 (or lower), and apply the activation keys, I will be able to get the system running in a temporary state...again if i run the online activation i'll receive 'This serial is already registered' which doesn't allow me to then install v16 using the same key file and the keys (as far as it can see) are for v13 still....

So how do we overcome this in an emergency situation where we need to install a temporary activation but we only have the keys for an older version?

This issue recently came up due to some poor planning on our part when migrating a customer to a new server where we forgot until the 11th hour to request a license move. Luckily we were able to get the move initiated by PxPlus just in time for the migration. We need to have an internal procedure in place to ensure we can activate our software out of hours in a data emergency (especially since we are on the other side of the world from PxPlus) to ensure business continuity for our clients.

Your help please!

Thanks,

Chris

7
Nomads / Re: Hotlink Logic
« on: October 07, 2019, 04:36:34 PM »
Hi Jane,

thanks for the info. I promise I did scour the documentation before posting.

As per James' request regarding updating the docs, it would be a great help to others i'm sure if it made mention of 'hotlink' somewhere in the columnclicked property so that it can be located in a search.

Chris

8
Nomads / Hotlink Logic
« on: October 03, 2019, 08:56:42 PM »
Hi All,

In v16.1. I've defined a column in a report view list box as a hotlink in the Format screen in Nomads. The column appears as a hotlink in the panel now, but I cannot work out how to assign logic to process the user clicking on the hotlink, nor can I see any variables changing that I could interrogate in my PROCESS logic even with the list box is set to automatic.

I'm loading the contents on the list box in my own logic, ie I do not use smart loading from a query.

Can someone please help?!?! This looks like an amazing feature that we would love to start implementing throughout our system.

Chris

9
Language / Re: Sort File 2GB Limit
« on: October 03, 2019, 08:06:51 PM »
Hi Mike,

Any guidance to the best way to recreate this file to avoid the 2GB limit?

10
Language / Re: Sort File 2GB Limit
« on: September 26, 2019, 05:46:30 PM »
Hi Mike,

Sorry for the slow response. This was my first forum post since you guys have done away with the mailing list and even though i thought i had set up email notifications I didn't seem to receive on. I'll go play with the settings again.

Here is the *UFI for the original sort file which is almost at its limit.
-------
Keyed file: U:\DATA\DATA.TO\INFSILSTO

     Maximum Record size ..........: 0 (Sort file)
     Maximum # records ............: (No limit)
     Current # records ............: 20852709
     Size of key block ............: 4096 bytes
     External key size ............: 50
-------

When i convert the file to a VLR using the data dictionary with only the 50b external element.
-----
Keyed file: V:\TEST\DATA\DATA.TO\infsilsto

     Maximum Record size ..........: 256 (Variable)
     Maximum # records ............: (No limit)
     Current # records ............: 20852709
     Size of key block ............: 4096 bytes
     Record Expansion factor ......: 10%
     Total # of Keyed File Segments: 2
     External key size ............: 50

----

I'm happy to tweak the settings as you suggest.

11
Language / Sort File 2GB Limit
« on: September 23, 2019, 08:54:15 PM »
Hi All,

We have just had a customer hit a 2GB limit on a sort file. We have multi-segmenting enabled and it works for VLR files but i'm guessing not for sort files?

Problem is, if we convert this file to a VLR or EFF, even with a RSZ of 1, the file grows from 2GB to 3.5GB which seems excessive.

Does anyone have any other method to get around this, or am I stuck with just changing the file to VLR across all our systems?

Thanks,

Chris

Pages: [1]