RE: [External] Regarding downloading data from IBM i series -- RPG400-L

Perhaps your administrators configured yours different from mine, hiding some options.
My IBM I Access Client Solutions Help About says Data Transfer (64-bit) Version 1.1.8.3 Build id: 9490.
My Download Properties has tabs: Conversions, Library List, Display, Connection, Start-up, SQL.

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of jerry ven
Sent: Tuesday, June 7, 2022 10:08 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [External] Regarding downloading data from IBM i series

[WARNING]: External Email

no such icons and properties in my IBM i session just that buttons 'send files to host' , 'receive files from host'. and when i select 'receive files from host' then i can enter IBM i name, file name , data options and at PC side i have options under Display details, ,font, font style ,size, effects, sample, script, and under file details:- 1) create new file, 2) overwrite existing file 3) append to existing file 4) create or overwrite file even if empty result set

under
file type - ASCII Text, BASIC RANDOM, ASIC SEQUENTIAL, BIFF3(MS EXCEL 3) -MSEXCEL 8 ,CSV, DIF(Lotus), DOS RANDOM ....WK4(LOTUS)

And i have the option to save PC file description as 1) standard 2) Enhanced radio buttons to select from.

Thanks

On Tue, 7 Jun 2022 at 20:29, Lehti, Eric <elehti@xxxxxxxxxxxx> wrote:

See icons 'Start Transfer', 'Stop Transfer', 'Properties'. Open
'Properties' > Conversions.

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
jerry ven
Sent: Tuesday, June 7, 2022 9:42 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [External] Regarding downloading data from IBM i series

[WARNING]: External Email

where can i chec these properties i don't have separate i series
navigator to download i just have a session and that button 'Data
transfer from IBM i ' i could not find these properties there-
Download properties

Conversions > General Options ? Convert CCSID 65535

Thanks

On Tue, 7 Jun 2022 at 20:08, Lehti, Eric <elehti@xxxxxxxxxxxx> wrote:

Junk data? Is your CCSID conversion set as needed? Download
properties

Conversions > General Options ? Convert CCSID 65535

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
jerry ven
Sent: Tuesday, June 7, 2022 9:32 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [External] Regarding downloading data from IBM i series

[WARNING]: External Email

I tried these different options but getting junk data in excel file
also getting error 'CWBTF0009 - The Data in this Field Is Too Long
for the
OS/400 Field'

Thanks

On Tue, 7 Jun 2022 at 19:59, Lehti, Eric <elehti@xxxxxxxxxxxx> wrote:

Jerry,
Those options are available so you can get the results you want
for the excel format you choose.

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
jerry ven
Sent: Tuesday, June 7, 2022 9:20 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: [External] Regarding downloading data from IBM i series

[WARNING]: External Email

Hi,

When trying to download a spool file's data which is in a flat
file (copied spool file into a flat file) in IBM i to local
desktop in a excel file format then which specific settings under
file details like BIFF3(MS
Excel3 - 8) should be selected to download this spool file in a
good excel format to local desktop?

also under PC file description file how hould it be saved 1
enhanced or 2) standard

--
This is the RPG programming on IBM i (RPG400-L) mailing list To
post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2F
li
st
s.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&data=05%7C01%7C
el
eh
ti%40quiktrip.com%7C1348033050ca4167be0508da48928967%7Cbe902cb3a2b
74
bf
d86442264fe46c43d%7C0%7C0%7C637902091464518906%7CUnknown%7CTWFpbGZ
sb
3d
8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3
D%
7C
3000%7C%7C%7C&sdata=lJbyVQE4EdiUfC%2F4HxRcctgwikv7AL9gst1aRKyv
kP
g%
3D&reserved=0 or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at

https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Far
ch
ive.midrange.com%2Frpg400-l&data=05%7C01%7Celehti%40quiktrip.com
%7
C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d
%7
C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAw
MD
AiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp
;s
data=eajkRpkz77qDFOMYb4WfReU3hEor1c5iwjMNWRGwmLY%3D&reserved=0
.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2F
am
az
on.midrange.com%2F&data=05%7C01%7Celehti%40quiktrip.com%7C1348
03
30
50ca4167be0508da48928967%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C
0%
7C
637902091464518906%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJ
QI
jo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=
Q%
2B
5N%2BzoDSJDjeAgqpa%2BP7jVCFXcwsT9dzsegEfsnfSg%3D&reserved=0

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post
a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fli
st
s.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&data=05%7C01%7Cel
eh
ti%40quiktrip.com%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74
bf
d86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb
3d
8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%
7C
3000%7C%7C%7C&sdata=m6danhOFgavcpqVsKbo0ZoiIQar3KdOhiquGt3WJFok%
3D
&reserved=0 or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Far
ch
ive.midrange.com%2Frpg400-l&data=05%7C01%7Celehti%40quiktrip.com
%7
C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d
%7
C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAw
MD
AiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp
;s
data=eajkRpkz77qDFOMYb4WfReU3hEor1c5iwjMNWRGwmLY%3D&reserved=0
.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fam
az
on.midrange.com%2F&data=05%7C01%7Celehti%40quiktrip.com%7C478c71
37
780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%
7C
637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQI
jo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=nB
r4
x4dooetzlDdlCoiNYutOfk0YbLT0R0kxWW9xqJo%3D&reserved=0
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post
a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fli
st
s.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&data=05%7C01%7Cel
eh
ti%40quiktrip.com%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74
bf
d86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb
3d
8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%
7C
3000%7C%7C%7C&sdata=m6danhOFgavcpqVsKbo0ZoiIQar3KdOhiquGt3WJFok%
3D
&reserved=0 or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at

https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Farch
ive.midrange.com%2Frpg400-l&data=05%7C01%7Celehti%40quiktrip.com%7
C502218a22a6e4e56896d08da48978ef2%7Cbe902cb3a2b74bfd86442264fe46c43d%7
C0%7C0%7C637902113023678608%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMD
AiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&s
data=Ox3ivs5QDjNAh6u4OjAmmUyLmpljBKIQLeg0nhxt%2BtQ%3D&reserved=0
.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fam
az
on.midrange.com%2F&data=05%7C01%7Celehti%40quiktrip.com%7C478c71
37
780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%
7C
637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQI
jo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=nB
r4
x4dooetzlDdlCoiNYutOfk0YbLT0R0kxWW9xqJo%3D&reserved=0

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
s.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&data=05%7C01%7Celeh
ti%40quiktrip.com%7C502218a22a6e4e56896d08da48978ef2%7Cbe902cb3a2b74bf
d86442264fe46c43d%7C0%7C0%7C637902113023678608%7CUnknown%7CTWFpbGZsb3d
8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C
3000%7C%7C%7C&sdata=D1ujAGCRIv2pauJzUeHTPl8B8riEqOnW0ypA2ur9yE4%3D
&reserved=0 or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Farch
ive.midrange.com%2Frpg400-l&data=05%7C01%7Celehti%40quiktrip.com%7
C502218a22a6e4e56896d08da48978ef2%7Cbe902cb3a2b74bfd86442264fe46c43d%7
C0%7C0%7C637902113023678608%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMD
AiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&s
data=Ox3ivs5QDjNAh6u4OjAmmUyLmpljBKIQLeg0nhxt%2BtQ%3D&reserved=0
.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Famaz
on.midrange.com%2F&data=05%7C01%7Celehti%40quiktrip.com%7C502218a2
2a6e4e56896d08da48978ef2%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C
637902113023678608%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=9sqt
mEigh87x5Kenq0YgBkwwqOIvYPwpNGorjrMqYJQ%3D&reserved=0
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
s.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&data=05%7C01%7Celeh
ti%40quiktrip.com%7C502218a22a6e4e56896d08da48978ef2%7Cbe902cb3a2b74bf
d86442264fe46c43d%7C0%7C0%7C637902113023678608%7CUnknown%7CTWFpbGZsb3d
8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C
3000%7C%7C%7C&sdata=D1ujAGCRIv2pauJzUeHTPl8B8riEqOnW0ypA2ur9yE4%3D
&reserved=0 or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Frpg400-l&data=05%7C01%7Celehti%40quiktrip.com%7C502218a22a6e4e56896d08da48978ef2%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902113023678608%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Ox3ivs5QDjNAh6u4OjAmmUyLmpljBKIQLeg0nhxt%2BtQ%3D&reserved=0.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Famaz
on.midrange.com%2F&data=05%7C01%7Celehti%40quiktrip.com%7C502218a2
2a6e4e56896d08da48978ef2%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C
637902113023678608%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=9sqt
mEigh87x5Kenq0YgBkwwqOIvYPwpNGorjrMqYJQ%3D&reserved=0

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&data=05%7C01%7Celehti%40quiktrip.com%7C502218a22a6e4e56896d08da48978ef2%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902113023678608%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=D1ujAGCRIv2pauJzUeHTPl8B8riEqOnW0ypA2ur9yE4%3D&reserved=0
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Frpg400-l&data=05%7C01%7Celehti%40quiktrip.com%7C502218a22a6e4e56896d08da48978ef2%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902113023678608%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Ox3ivs5QDjNAh6u4OjAmmUyLmpljBKIQLeg0nhxt%2BtQ%3D&reserved=0.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com%2F&data=05%7C01%7Celehti%40quiktrip.com%7C502218a22a6e4e56896d08da48978ef2%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902113023678608%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=9sqtmEigh87x5Kenq0YgBkwwqOIvYPwpNGorjrMqYJQ%3D&reserved=0