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

What emulator are you using?
Click on "Help" on the menu, then "About" ...
On Tuesday, June 7, 2022, 11:08:20 AM EDT, jerry ven <jerryven95@xxxxxxxxx> wrote:

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%2Fli
st
s.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&data=05%7C01%7Cel
eh
ti%40quiktrip.com%7C1348033050ca4167be0508da48928967%7Cbe902cb3a2b74
bf
d86442264fe46c43d%7C0%7C0%7C637902091464518906%7CUnknown%7CTWFpbGZsb
3d
8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%
7C
3000%7C%7C%7C&sdata=lJbyVQE4EdiUfC%2F4HxRcctgwikv7AL9gst1aRKyvkP
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%2Farch
ive.midrange.com%2Frpg400-l&data=05%7C01%7Celehti%40quiktrip.com%7
C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7
C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMD
AiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&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%7C134803
30
50ca4167be0508da48928967%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%
7C
637902091464518906%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQI
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%2Flist
s.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&data=05%7C01%7Celeh
ti%40quiktrip.com%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bf
d86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d
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
C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7
C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMD
AiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&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%2Famaz
on.midrange.com%2F&data=05%7C01%7Celehti%40quiktrip.com%7C478c7137
780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C
637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=nBr4
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%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bf
d86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d
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%2Farchive.midrange.com%2Frpg400-l&data=05%7C01%7Celehti%40quiktrip.com%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=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%2Famaz
on.midrange.com%2F&data=05%7C01%7Celehti%40quiktrip.com%7C478c7137
780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C
637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=nBr4
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%2Flists.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&data=05%7C01%7Celehti%40quiktrip.com%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%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%2Farchive.midrange.com%2Frpg400-l&data=05%7C01%7Celehti%40quiktrip.com%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=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%2Famazon.midrange.com%2F&data=05%7C01%7Celehti%40quiktrip.com%7C478c7137780a45bdd61508da4893f883%7Cbe902cb3a2b74bfd86442264fe46c43d%7C0%7C0%7C637902097613364203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=nBr4x4dooetzlDdlCoiNYutOfk0YbLT0R0kxWW9xqJo%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://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com