IBM i Access Client Solutions

Hello, 

I have been attempting for about a week to get a data set from a csv or xlsx format to upload to a flat file the original data was downloaded from. The upload however only loads the data from the first column in the xlsx, or the first data set before the first comma in the csv. 

I know I used to have this done successfully with Client Access for Windows, hoping someone has a way to do this with ACS.

------------------------------
Amy Williams CISSP CISA PCIP
Principal Security Consultant
Fortra LLC
------------------------------

Dear Amy

The word "flat DB file" that you used is confusing.  Are you actually mean an IBM i physical file object in an IBM i library object?    If you actually mean a "stream file" in an IBM i IFS folder, then Data Transfer feature of both Client Access for Windows and ACS is NOT designed to do this.  

Assuming you mean an IBM i physical file, in uploading a PC file to a physical file, you need to specify a FDFX file (field definition file created and used by Client Access and ACS for upload operation - used to be FDF for Client Access) in conjunction with the upload.   If you have no such a FDFX file yet, you just do a download from your physical file to your PC first (make sure you select the option "Save client file description" and specify the file name as shown in the sample screen shot below) and a FDFX file is created by ACS for you at download (you delete the resulting downloaded CSV/XLSX file as you do not need it). Do this for each physical file you deal with and keep the FDFX file for all subsequent ACS upload.

------------------------------
Satid S

Original Message:
Sent: Sun August 25, 2024 12:43 AM
From: Amy Williams
Subject: Upload CSV or XLSX file to Flat DB file using Data Transfer in ACS

Hello, 

I have been attempting for about a week to get a data set from a csv or xlsx format to upload to a flat file the original data was downloaded from. The upload however only loads the data from the first column in the xlsx, or the first data set before the first comma in the csv. 

I know I used to have this done successfully with Client Access for Windows, hoping someone has a way to do this with ACS.

------------------------------
Amy Williams CISSP CISA PCIP
Principal Security Consultant
Fortra LLC
------------------------------

Hello, 

I have been attempting for about a week to get a data set from a csv or xlsx format to upload to a flat file the original data was downloaded from. The upload however only loads the data from the first column in the xlsx, or the first data set before the first comma in the csv. 

I know I used to have this done successfully with Client Access for Windows, hoping someone has a way to do this with ACS.

------------------------------
Amy Williams CISSP CISA PCIP
Principal Security Consultant
Fortra LLC
------------------------------

Satid,

Let me explain "flat file".  CRTPF FILE(MYLIB/MYFILE) RCDLEN(132)

Think old RPG II where you used Input specs to define the fields.

------------------------------
Robert Berendt IBMChampion

Original Message:
Sent: Sun August 25, 2024 12:43 AM
From: Amy Williams
Subject: Upload CSV or XLSX file to Flat DB file using Data Transfer in ACS

Hello, 

I have been attempting for about a week to get a data set from a csv or xlsx format to upload to a flat file the original data was downloaded from. The upload however only loads the data from the first column in the xlsx, or the first data set before the first comma in the csv. 

I know I used to have this done successfully with Client Access for Windows, hoping someone has a way to do this with ACS.

------------------------------
Amy Williams CISSP CISA PCIP
Principal Security Consultant
Fortra LLC
------------------------------

Dear Robert

Thanks to your explanation, this means a physical file with only one field.   No one in my part of the world uses the name flat file for so many years now.  

If this is actually what Amy meant, then her question puzzles me now because, from her post, it means she is trying to upload a multi-column CSV/XLSX PC file to that one-column physical file and I have no idea how it can be done and what the purpose of this kind of upload is for ?     Could you clarify more if you think you know what Amy is trying to achieve?  Or do we wait for her response first ?

Satid,

Let me explain "flat file".  CRTPF FILE(MYLIB/MYFILE) RCDLEN(132)

Think old RPG II where you used Input specs to define the fields.

Hello, 

I have been attempting for about a week to get a data set from a csv or xlsx format to upload to a flat file the original data was downloaded from. The upload however only loads the data from the first column in the xlsx, or the first data set before the first comma in the csv. 

I know I used to have this done successfully with Client Access for Windows, hoping someone has a way to do this with ACS.

------------------------------
Amy Williams CISSP CISA PCIP
Principal Security Consultant
Fortra LLC
------------------------------

You could wait for her response but I'd bet the farm on it.  This would explain this:

<snip>

The upload however only loads the data from the first column in the xlsx, or the first data set before the first comma in the csv. 

</snip>

She'd be better off creating a new intermediate file with actual columns/fields.  Or see if there is a way to say the "from" file has no delimiters.  

Dear Robert

Thanks to your explanation, this means a physical file with only one field.   No one in my part of the world uses the name flat file for so many years now.  

If this is actually what Amy meant, then her question puzzles me now because, from her post, it means she is trying to upload a multi-column CSV/XLSX PC file to that one-column physical file and I have no idea how it can be done and what the purpose of this kind of upload is for ?     Could you clarify more if you think you know what Amy is trying to achieve?  Or do we wait for her response first ?

Satid,

Let me explain "flat file".  CRTPF FILE(MYLIB/MYFILE) RCDLEN(132)

Think old RPG II where you used Input specs to define the fields.

Hello, 

I have been attempting for about a week to get a data set from a csv or xlsx format to upload to a flat file the original data was downloaded from. The upload however only loads the data from the first column in the xlsx, or the first data set before the first comma in the csv. 

I know I used to have this done successfully with Client Access for Windows, hoping someone has a way to do this with ACS.

------------------------------
Amy Williams CISSP CISA PCIP
Principal Security Consultant
Fortra LLC
------------------------------

Hello, 

I have been attempting for about a week to get a data set from a csv or xlsx format to upload to a flat file the original data was downloaded from. The upload however only loads the data from the first column in the xlsx, or the first data set before the first comma in the csv. 

I know I used to have this done successfully with Client Access for Windows, hoping someone has a way to do this with ACS.

------------------------------
Amy Williams CISSP CISA PCIP
Principal Security Consultant
Fortra LLC
------------------------------

Amy,

If this flat file was created with something like CRTPF ... RCDLEN(265) and without DDS or DDL then you may be better off creating a new temporary file to upload that data in which DOES have columns/fields created with DDS or DDL.

Hello, 

I have been attempting for about a week to get a data set from a csv or xlsx format to upload to a flat file the original data was downloaded from. The upload however only loads the data from the first column in the xlsx, or the first data set before the first comma in the csv. 

I know I used to have this done successfully with Client Access for Windows, hoping someone has a way to do this with ACS.

------------------------------
Amy Williams CISSP CISA PCIP
Principal Security Consultant
Fortra LLC
------------------------------

the problem with this is each excel is always different, depending on the User. We never know how many columns are in each excel.  Funny thing is that the old Client Access for Windows worked.

Amy,

If this flat file was created with something like CRTPF ... RCDLEN(265) and without DDS or DDL then you may be better off creating a new temporary file to upload that data in which DOES have columns/fields created with DDS or DDL.

Hello, 

I have been attempting for about a week to get a data set from a csv or xlsx format to upload to a flat file the original data was downloaded from. The upload however only loads the data from the first column in the xlsx, or the first data set before the first comma in the csv. 

I know I used to have this done successfully with Client Access for Windows, hoping someone has a way to do this with ACS.

------------------------------
Amy Williams CISSP CISA PCIP
Principal Security Consultant
Fortra LLC
------------------------------