Re: Using CPYFRMIMPF -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

On Thu, Jun 3, 2021 at 8:48 AM Howie, Bill <BHowie@xxxxxxxxxxxxxxxx> wrote:

I'm working on importing a CSV file to the IBM I using CPYFRMIMPF. The file started out as an XLS file that I saved as a CSV file, and then did the CPYFRMIMPF. Is there a foolproof way to handle the alpha fields that have commas as part of the data? I know that saving the file as a CSV causes the data with commas in it to have double quotes around it. These records all fall out into the error file that I'm using with the command. Thoughts? Any info is most appreciated.

Well, someone suggested maybe you have to adjust the parameters on the
CPYFRMIMPF command. If there is some combination of settings that
works, then that is of course a quick and easy option.

Someone else suggested uploading the data directly from the Excel
workbook using the data transfer capabilities that come with ACS.
That's another fairly convenient and perhaps more robust option.

But I think this is a great excuse/opportunity to get your feet wet
with Python, which can handle CSVs or Excel workbooks (.xls or .xlsx).
For me, that is the most foolproof way to handle getting data out of
Excel and into IBM i database files.

John Y.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.