PxPlus User Forum

Main Board => Discussions => Language => Topic started by: Jeffrey Ferreira on March 01, 2022, 08:02:21 AM

Title: Convert PxPlus File to CSV
Post by: Jeffrey Ferreira 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

Title: Re: Convert PxPlus File to CSV
Post by: Devon Austen 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.

Title: Re: Convert PxPlus File to CSV
Post by: Jeffrey Ferreira 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

Title: Re: Convert PxPlus File to CSV
Post by: Devon Austen 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.