Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

specially under file details section what should be the settings or other section settings ?

Thanks

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

Hi, 

Could someone please reply here? 

Thanks. 

Original Message:
Sent: Fri July 05, 2024 09:15 AM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

specially under file details section what should be the settings or other section settings ?

Thanks

Original Message:
Sent: Fri July 05, 2024 09:06 AM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

Dear Jerry

What is the type of data you want to transfer - source code or database records?  If database records, what format are they in your PC (CSV or some such)?   Are all the data in English?  If not, which language are they in?  

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

Original Message:
Sent: Tue July 09, 2024 02:21 PM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

Hi, 

Could someone please reply here? 

Thanks. 

Original Message:
Sent: Fri July 05, 2024 09:15 AM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

specially under file details section what should be the settings or other section settings ?

Thanks

Original Message:
Sent: Fri July 05, 2024 09:06 AM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

Hi, 

Could someone please reply here? 

Thanks. 

specially under file details section what should be the settings or other section settings ?

Thanks

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

Hi Jerry,

This is what I did to transfer a CSV file to IBMi - creating a new file "MYLIB\TESTCSV".

1. At the data transfer to IBMi window: Use Actions -> Create IBMi Database File -> (A Wizard that will guide you through the process of selecting your file and create a client file description of that physical file)

2. You need that client file description for the next step: (the "pcdata.fdfx" was created on the first step)

3. Transfer the file

I hope this helps.

------------------------------
Zahir Ahmed
ERP Analyst

Original Message:
Sent: Tue July 09, 2024 02:21 PM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

Hi, 

Could someone please reply here? 

Thanks. 

Original Message:
Sent: Fri July 05, 2024 09:15 AM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

specially under file details section what should be the settings or other section settings ?

Thanks

Original Message:
Sent: Fri July 05, 2024 09:06 AM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

Hi, 

Could someone please reply here? 

Thanks. 

specially under file details section what should be the settings or other section settings ?

Thanks

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

Im no expert, and have never tried sending a text file to a pf src file before now, but I just gave it a go with the settings you had in your pic, and hit 'OK', and 'Start Transfer' and it worked for me? Is there an error holding you up? Or are you asking about what to put here on the transfer screen?

Hi, 

Could someone please reply here? 

Thanks. 

specially under file details section what should be the settings or other section settings ?

Thanks

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

Thanks , what about if i need to transfer file from system to another ( between different as400 systems)?

and can this transfer any excel file from local desktop to inside a new file in a given library as well? plus if it is able to do so will we be able to do runqry,strsql etc. on that file once it's there inside ibm i on mentioned library name?

What about other cases i asked previously ?

Thanks much..

Im no expert, and have never tried sending a text file to a pf src file before now, but I just gave it a go with the settings you had in your pic, and hit 'OK', and 'Start Transfer' and it worked for me? Is there an error holding you up? Or are you asking about what to put here on the transfer screen?

Hi, 

Could someone please reply here? 

Thanks. 

specially under file details section what should be the settings or other section settings ?

Thanks

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

is there a simple way to FTP the file with it's colmn heading correctly using FTP commands , if yes could someone please share example of the same here with FTP logs( i mean since login till transferred successfully)

Thanks much..

Thanks , what about if i need to transfer file from system to another ( between different as400 systems)?

and can this transfer any excel file from local desktop to inside a new file in a given library as well? plus if it is able to do so will we be able to do runqry,strsql etc. on that file once it's there inside ibm i on mentioned library name?

What about other cases i asked previously ?

Thanks much..

Im no expert, and have never tried sending a text file to a pf src file before now, but I just gave it a go with the settings you had in your pic, and hit 'OK', and 'Start Transfer' and it worked for me? Is there an error holding you up? Or are you asking about what to put here on the transfer screen?

Hi, 

Could someone please reply here? 

Thanks. 

specially under file details section what should be the settings or other section settings ?

Thanks

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

Hi,

Could someone please reply here, appreciate experts prompt response here.

Thanks  much...

is there a simple way to FTP the file with it's colmn heading correctly using FTP commands , if yes could someone please share example of the same here with FTP logs( i mean since login till transferred successfully)

Thanks much..

Thanks , what about if i need to transfer file from system to another ( between different as400 systems)?

and can this transfer any excel file from local desktop to inside a new file in a given library as well? plus if it is able to do so will we be able to do runqry,strsql etc. on that file once it's there inside ibm i on mentioned library name?

What about other cases i asked previously ?

Thanks much..

Im no expert, and have never tried sending a text file to a pf src file before now, but I just gave it a go with the settings you had in your pic, and hit 'OK', and 'Start Transfer' and it worked for me? Is there an error holding you up? Or are you asking about what to put here on the transfer screen?

Hi, 

Could someone please reply here? 

Thanks. 

specially under file details section what should be the settings or other section settings ?

Thanks

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

Jerry, You seem to be jumping between multiple scenarios.  For text download, upload, and file data to a spreadsheet the ACS functions are best.  See the ACS training for examples.  To get files between systems with all attributes you need to use save files.  Save on the first system, create a save file on the second, FTP in binary mode with replace.   Then you can restore on the second system.  Once restored all your queries can be run on the second system.

Hi,

Could someone please reply here, appreciate experts prompt response here.

Thanks  much...

is there a simple way to FTP the file with it's colmn heading correctly using FTP commands , if yes could someone please share example of the same here with FTP logs( i mean since login till transferred successfully)

Thanks much..

Thanks , what about if i need to transfer file from system to another ( between different as400 systems)?

and can this transfer any excel file from local desktop to inside a new file in a given library as well? plus if it is able to do so will we be able to do runqry,strsql etc. on that file once it's there inside ibm i on mentioned library name?

What about other cases i asked previously ?

Thanks much..

Im no expert, and have never tried sending a text file to a pf src file before now, but I just gave it a go with the settings you had in your pic, and hit 'OK', and 'Start Transfer' and it worked for me? Is there an error holding you up? Or are you asking about what to put here on the transfer screen?

Hi, 

Could someone please reply here? 

Thanks. 

specially under file details section what should be the settings or other section settings ?

Thanks

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

Thanks , what about if i need to transfer file from system to another ( between different as400 systems)?

and can this transfer any excel file from local desktop to inside a new file in a given library as well? plus if it is able to do so will we be able to do runqry,strsql etc. on that file once it's there inside ibm i on mentioned library name?

What about other cases i asked previously ?

Thanks much..

Im no expert, and have never tried sending a text file to a pf src file before now, but I just gave it a go with the settings you had in your pic, and hit 'OK', and 'Start Transfer' and it worked for me? Is there an error holding you up? Or are you asking about what to put here on the transfer screen?

Hi, 

Could someone please reply here? 

Thanks. 

specially under file details section what should be the settings or other section settings ?

Thanks

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

Hi,

I was able to download source ember in text file to my desired location using this ACS tool as per advised settings but while using same settings when trying to upload keep getting below error: -

Note:- I tried even converting that for example here pg1.txt on my local system to fdfx file with save as option same file pg1.txt to pg1.flfx just so that at least this way it could be uploaded to IBM i but neither text file nor 'fdfx file' are getting uploaded to the desired library/source physical file for the desired source member name here.

I tried both ways first by checking that 'use client file description' and when it gave me mentioned error then tried unchecking and tried uploading the text file but for both got that error

Then got below error:-

So, could someone please advise correct settings for uploading a text file into a desired source member name and desired library/source physical file location?

Thanks much...

Original Message:
Sent: Thu July 25, 2024 03:20 PM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

Thanks , what about if i need to transfer file from system to another ( between different as400 systems)?

and can this transfer any excel file from local desktop to inside a new file in a given library as well? plus if it is able to do so will we be able to do runqry,strsql etc. on that file once it's there inside ibm i on mentioned library name?

What about other cases i asked previously ?

Thanks much..

Original Message:
Sent: Tue July 09, 2024 03:06 PM
From: Kelly William
Subject: settings for transferring a text file to a member of given library and source physical file

Im no expert, and have never tried sending a text file to a pf src file before now, but I just gave it a go with the settings you had in your pic, and hit 'OK', and 'Start Transfer' and it worked for me? Is there an error holding you up? Or are you asking about what to put here on the transfer screen?

------------------------------
Kelly William

Original Message:
Sent: Tue July 09, 2024 02:21 PM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

Hi, 

Could someone please reply here? 

Thanks. 

Original Message:
Sent: Fri July 05, 2024 09:15 AM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

specially under file details section what should be the settings or other section settings ?

Thanks

Original Message:
Sent: Fri July 05, 2024 09:06 AM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

See previous comment details.

You have to save the FDFX file on the download in order to use it for the upload.  You can create one manually but that takes hours of work and is frustrating.  Check the box in the download file details.

Hi,

I was able to download source ember in text file to my desired location using this ACS tool as per advised settings but while using same settings when trying to upload keep getting below error: -

Note:- I tried even converting that for example here pg1.txt on my local system to fdfx file with save as option same file pg1.txt to pg1.flfx just so that at least this way it could be uploaded to IBM i but neither text file nor 'fdfx file' are getting uploaded to the desired library/source physical file for the desired source member name here.

I tried both ways first by checking that 'use client file description' and when it gave me mentioned error then tried unchecking and tried uploading the text file but for both got that error

Then got below error:-

So, could someone please advise correct settings for uploading a text file into a desired source member name and desired library/source physical file location?

Thanks much...

Original Message:
Sent: Thu July 25, 2024 03:20 PM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

Thanks , what about if i need to transfer file from system to another ( between different as400 systems)?

and can this transfer any excel file from local desktop to inside a new file in a given library as well? plus if it is able to do so will we be able to do runqry,strsql etc. on that file once it's there inside ibm i on mentioned library name?

What about other cases i asked previously ?

Thanks much..

Im no expert, and have never tried sending a text file to a pf src file before now, but I just gave it a go with the settings you had in your pic, and hit 'OK', and 'Start Transfer' and it worked for me? Is there an error holding you up? Or are you asking about what to put here on the transfer screen?

Hi, 

Could someone please reply here? 

Thanks. 

specially under file details section what should be the settings or other section settings ?

Thanks

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

You have to save the FDFX file on the download in order to use it for the upload.  You can create one manually but that takes hours of work and is frustrating.  Check the box in the download file details.

Hi,

I was able to download source ember in text file to my desired location using this ACS tool as per advised settings but while using same settings when trying to upload keep getting below error: -

Note:- I tried even converting that for example here pg1.txt on my local system to fdfx file with save as option same file pg1.txt to pg1.flfx just so that at least this way it could be uploaded to IBM i but neither text file nor 'fdfx file' are getting uploaded to the desired library/source physical file for the desired source member name here.

I tried both ways first by checking that 'use client file description' and when it gave me mentioned error then tried unchecking and tried uploading the text file but for both got that error

Then got below error:-

So, could someone please advise correct settings for uploading a text file into a desired source member name and desired library/source physical file location?

Thanks much...

Original Message:
Sent: Thu July 25, 2024 03:20 PM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

Thanks , what about if i need to transfer file from system to another ( between different as400 systems)?

and can this transfer any excel file from local desktop to inside a new file in a given library as well? plus if it is able to do so will we be able to do runqry,strsql etc. on that file once it's there inside ibm i on mentioned library name?

What about other cases i asked previously ?

Thanks much..

Im no expert, and have never tried sending a text file to a pf src file before now, but I just gave it a go with the settings you had in your pic, and hit 'OK', and 'Start Transfer' and it worked for me? Is there an error holding you up? Or are you asking about what to put here on the transfer screen?

Hi, 

Could someone please reply here? 

Thanks. 

specially under file details section what should be the settings or other section settings ?

Thanks

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

and also, the file which is not there on IBM i itself and I want to upload a new text file inside a given source member whose type is 'TXT' and is currently empty and awaiting it's data to be filled from a text file which is on local desktop so how can I do so? 

Thanks

You have to save the FDFX file on the download in order to use it for the upload.  You can create one manually but that takes hours of work and is frustrating.  Check the box in the download file details.

Hi,

I was able to download source ember in text file to my desired location using this ACS tool as per advised settings but while using same settings when trying to upload keep getting below error: -

Note:- I tried even converting that for example here pg1.txt on my local system to fdfx file with save as option same file pg1.txt to pg1.flfx just so that at least this way it could be uploaded to IBM i but neither text file nor 'fdfx file' are getting uploaded to the desired library/source physical file for the desired source member name here.

I tried both ways first by checking that 'use client file description' and when it gave me mentioned error then tried unchecking and tried uploading the text file but for both got that error

Then got below error:-

So, could someone please advise correct settings for uploading a text file into a desired source member name and desired library/source physical file location?

Thanks much...

Original Message:
Sent: Thu July 25, 2024 03:20 PM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

Thanks , what about if i need to transfer file from system to another ( between different as400 systems)?

and can this transfer any excel file from local desktop to inside a new file in a given library as well? plus if it is able to do so will we be able to do runqry,strsql etc. on that file once it's there inside ibm i on mentioned library name?

What about other cases i asked previously ?

Thanks much..

Im no expert, and have never tried sending a text file to a pf src file before now, but I just gave it a go with the settings you had in your pic, and hit 'OK', and 'Start Transfer' and it worked for me? Is there an error holding you up? Or are you asking about what to put here on the transfer screen?

Hi, 

Could someone please reply here? 

Thanks. 

specially under file details section what should be the settings or other section settings ?

Thanks

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks

..Also, why it's not able to find out the file which is there and ready to be uploaded inside IBM i from my local desktop( from a given path on system  just for example from here : "C:\Users\myusername\Documents\IBM\iAccessClient\DataTransfer\av1.txt:"

And with above settings when I click on 'Start Transfer' button then get below error message: -

Thanks much...

and also, the file which is not there on IBM i itself and I want to upload a new text file inside a given source member whose type is 'TXT' and is currently empty and awaiting it's data to be filled from a text file which is on local desktop so how can I do so? 

Thanks

You have to save the FDFX file on the download in order to use it for the upload.  You can create one manually but that takes hours of work and is frustrating.  Check the box in the download file details.

Hi,

I was able to download source ember in text file to my desired location using this ACS tool as per advised settings but while using same settings when trying to upload keep getting below error: -

Note:- I tried even converting that for example here pg1.txt on my local system to fdfx file with save as option same file pg1.txt to pg1.flfx just so that at least this way it could be uploaded to IBM i but neither text file nor 'fdfx file' are getting uploaded to the desired library/source physical file for the desired source member name here.

I tried both ways first by checking that 'use client file description' and when it gave me mentioned error then tried unchecking and tried uploading the text file but for both got that error

Then got below error:-

So, could someone please advise correct settings for uploading a text file into a desired source member name and desired library/source physical file location?

Thanks much...

Original Message:
Sent: Thu July 25, 2024 03:20 PM
From: jerry ven
Subject: settings for transferring a text file to a member of given library and source physical file

Thanks , what about if i need to transfer file from system to another ( between different as400 systems)?

and can this transfer any excel file from local desktop to inside a new file in a given library as well? plus if it is able to do so will we be able to do runqry,strsql etc. on that file once it's there inside ibm i on mentioned library name?

What about other cases i asked previously ?

Thanks much..

Im no expert, and have never tried sending a text file to a pf src file before now, but I just gave it a go with the settings you had in your pic, and hit 'OK', and 'Start Transfer' and it worked for me? Is there an error holding you up? Or are you asking about what to put here on the transfer screen?

Hi, 

Could someone please reply here? 

Thanks. 

specially under file details section what should be the settings or other section settings ?

Thanks

Hi,

If i simply want to transfer a text file from local desktop or from a given folder from my computer to a given member in a given library and source physical file then what should be the settings for ttransferring this file using ibm i acs tool?

could someone please share stepwise screenshots for the same?

thanks