PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Convert PxPlus File to CSV  (Read 995 times)

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 175
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
Convert PxPlus File to CSV
« on: March 01, 2022, 08:02:21 AM »
Hello All,

I know you can convert a grid or list box to an csv.  Are there any Utilities out there that will take a PxPlus and convert it to a CSV file. I figured I would ask before creating it.

thanks

jeff

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: Convert PxPlus File to CSV
« Reply #1 on: March 01, 2022, 08:56:07 AM »
Hi Jeff,

I don't believe there is any utility to convert a PxPlus Keyed file to a CSV file.

It should be fairly straight forward to code yourself though with the benefit of giving you full control over how it works.
Principal Software Engineer for PVX Plus Technologies LTD.

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 175
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
Re: Convert PxPlus File to CSV
« Reply #2 on: March 01, 2022, 08:58:38 AM »
Hi Devon,

Thank you. I didn't think it would be too bad but I just wanted to make sure. I wanted to do it for clients who want to use a BI tool but don't have ODBC or an Architecture conflict (32 bit vs 64 bit app). I appreciate you helping me on this.

Jeff

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: Convert PxPlus File to CSV
« Reply #3 on: March 01, 2022, 09:25:31 AM »
If your customers don't have a pro license and therefore no ODBC then yes a tool like this may be useful.

If your customer does have ODBC an architecture mismatch should never be an issue. If you are using a 32-bit Excel then install the 32-bit ODBC driver, if you are using the 64-bit Excel use the 64-bit ODBC driver. The architecture of your PxPlus does not matter to the ODBC driver, so you can have a 32-bit PxPlus with a 64-bit ODBC driver and that will work and vice-versa.
Principal Software Engineer for PVX Plus Technologies LTD.