Exporting data from JDE tables to CSV file

[ramjde]

Hi,
I need to export data using a business view to CSV file.
I understand there are three options to do it.
1. Table conversion
2. RDA Database Output option
3. C business function.

Can anyone please guide which will be best option to use out of the three.

We are on ERP9.0 Toolset 8.98

Thanks

 

[K Lakshmi]

--00163646d5c4d400e4046bd071ad
Content-Type: text/plain; charset=ISO-8859-2
Content-Transfer-Encoding: quoted-printable

Hi,
for exporting data to CSV.
1) In RDA, Alignment grid to 52 * 8 form. align each field in that grid. An d
in "Print Setup" -- > select Check box "Export to CSV"
or
2) (C busniess function) use three BSFNs 1. OpenPlatFile, 2.
WriteOneLineToFlatFile and 3.CloseFlatFile.

Regards,
Bindu


.
ist.com?Subject=3DUnsubscribe&Body=3DSirs,

Please++remove+this+address

--
Bindu K

--00163646d5c4d400e4046bd071ad
Content-Type: text/html; charset=ISO-8859-2
Content-Transfer-Encoding: quoted-printable

rid. And in "Print Setup" -- > select Check box "Export t ineToFlatFile and 3.CloseFlatFile.</div>
<div class=3D"gmail_quote">On Sun, Jun 7, 2009 at 2:36 PM, ramesh bokka <sp an dir=3D"ltr"><<a href=3D"mailto:[email protected]">rameshbokka@gma <blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0 px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi,
I need to export data usi ng a business view to CSV file.
I understand there are three options to do it.

1. Table conversion
2. RDA Database Output option
3. C business funct the three.

We are on ERP9.0 Toolset 8.98

Thanks
=3DOWDEV&Number=3D146861" target=3D"_blank">entire JDELIST thread</a> i s available for viewing.
postlist.php?Cat=3D&Board=3DOpps" target=3D"_blank">Job Opportunities f <div align=3D"center"><font face=3D"Verdana, Arial" size=3D"-2">This is the JDELIST EnterpriseOne Developers Mailing List.
JDELIST is not affiliate d with JDEdwards=AE.</font></div></td></tr></tbody></table>
[email protected]?Subject=3DUnsubscribe&Body=3DSirs,

Please++remove+ this+address+from+the+JDELIST+EnterpriseOne+Developers+Mailing+List.

T hank+You." target=3D"_blank">Click here</a>. </p>


--00163646d5c4d400e4046bd071ad--

 

[EONECNC]

Defending on your expertise, all options are good

 

[reivilo78]

Hey,

My personal opinion :

1) a pain in the ass
2) Good but not very flexible
3) Flexible, but you have to "build" the csv lines with concats.

I usually use option 2 (database output) + BSFN "Delete Or Copy Flat File" with three Processing options one for Path, one for filename, one for temporary path.
I delete the temporary file using the BSFN at location temp_path+temp_filename.
Using the database output I write to the temporary file temp_filename.
I delete existing destination_path+destination_filename
I copy the temporary file to the destination path+filename.

That way I can test it on both client and server :
- on client : put "c:\e812" in destination_path and in temp_path
- on server : put "/" in destination_path and in temp_path

 

[K Lakshmi]

--0016364ed5de7ed001046bff3032
Content-Type: text/plain; charset=ISO-8859-2
Content-Transfer-Encoding: quoted-printable

Hi Reivilo78,
can you please give me the event rules of your using method.
i want to know how you use BSFN "Delete Or Copy Flat File".

Thanks,
Bindu

:

"
ist.com?Subject=3DUnsubscribe&Body=3DSirs,

Please++remove+this+address

--
Bindu K

--0016364ed5de7ed001046bff3032
Content-Type: text/html; charset=ISO-8859-2
Content-Transfer-Encoding: quoted-printable

<div class=3D"gmail_quote">On Wed, Jun 10, 2009 at 9:27 AM, reivilo78 <span dir=3D"ltr"><<a href=3D"mailto[email protected]">olivier.vidal@ <blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0 px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hey,

My personal opinion le, but you have to "build" the csv lines with concats.

at File" with three Processing options one for Path, one for filename, one for temporary path.
I delete the temporary file using the BSFN at l ocation temp_path+temp_filename.

Using the database output I write to the temporary file temp_filename.
I delete existing destination_path+destination_filename
I copy the tempor ary file to the destination path+filename.

That way I can test it on both client and server :

- on client : put "c:\e812" in destination_path and in temp_path< <div class=3D"h5">
=3DOWDEV&Number=3D146985" target=3D"_blank">entire JDELIST thread</a> i s available for viewing.
postlist.php?Cat=3D&Board=3DOpps" target=3D"_blank">Job Opportunities f <div align=3D"center"><font face=3D"Verdana, Arial" size=3D"-2">This is the JDELIST EnterpriseOne Developers Mailing List.
JDELIST is not affiliate d with JDEdwards=AE.</font></div></td></tr></tbody></table>
[email protected]?Subject=3DUnsubscribe&Body=3DSirs,

Please++remove+ this+address+from+the+JDELIST+EnterpriseOne+Developers+Mailing+List.

T hank+You." target=3D"_blank">Click here</a>. </p>


--0016364ed5de7ed001046bff3032--

 

[reivilo78]

here you go. i attached the event rules.

You can see that
cActionOnFlatFiles =1 -> Delete
cActionOnFlatFiles =2 -> Copy

it's easy to remember since in the name of the BSFN the actions are in that order : "Delete(1) or Copy(2) Flat File"

 

[Zoltan_Gyimesi]

Hi Bindu,

In my humble opinion, there is no need sample code to use B4700230 "Delete Or Copy Flat File", because the parameters of it are so obvious.

On the other hand, if you examine the C source, you can figure out the ActionCodes. Here is an outline extract fro the code.

========================================
switch ( lpDS->cActionOnFlatFiles )
{
/* Action to delete original flat file */
case '1':
.
.
.
/* Action for copying from original flat file to new flat file */
case '2':
.
.
.

/* Action for deleting both original flat file and new flat file */
case '3':
.
.
.
========================================

Regards,

Zoltán

 

[jacobw123]

If a reort isn't needed Data Conversion would be the fasted.Define the output as comma delimeter.

Jacob

 

[K Lakshmi]

--0016367f96e09783c3046c21a0d5
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

HI,
Thank for the information.
I would like to know, where we will give flat file name in that BSFN.
(before using this BSFN , i think we have to use "OpenFlatFile" and After
"CloseFlatFile" ?)

Thanks,
Bindu
:

at
ist.com?Subject=3DUnsubscribe&Body=3DSirs,

Please++remove+this+address

--
Bindu K

--0016367f96e09783c3046c21a0d5
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

ot;=A0 and After "CloseFlatFile" ?) </div>
<div class=3D"gmail_quote">On Thu, Jun 11, 2009 at 8:42 AM, reivilo78 <span dir=3D"ltr"><<a href=3D"mailto[email protected]">olivier.vidal1 <blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0 px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">here you go. i attached the even t rules.

You can see that
cActionOnFlatFiles =3D1 -> Delete<br cActionOnFlatFiles =3D2 -> Copy

it's easy to remember since i n the name of the BSFN the actions are in that order : "Delete(1) or C opy(2) Flat File"
ools IBM i on Power systems(AS/400) , DB2 V5.4
<div class=3D"im">
=3DOWDEV&Number=3D147018" target=3D"_blank">entire JDELIST thread</a> i s available for viewing.</div>
postlist.php?Cat=3D&Board=3DOpps" target=3D"_blank">Job Opportunities f <div align=3D"center"><font face=3D"Verdana, Arial" size=3D"-2">
<div class=3D"im">This is the JDELIST EnterpriseOne Developers Mailing List <div class=3D"im">
[email protected]?Subject=3DUnsubscribe&Body=3DSirs,

Please++remove+ this+address+from+the+JDELIST+EnterpriseOne+Developers+Mailing+List.

T hank+You." target=3D"_blank">Click here</a>. </p>

--0016367f96e09783c3046c21a0d5--

 

[reivilo78]

I dont have any example in mind, but from my experience, on the 8.12 version, table conversion behaviour is really strange. At least with a standard report I understand what is going on.
But I guess this is a matter of which solution you're more used to.
One good thing to do in my opinion is to create a table containing all the fields that you want to create.
Then u have all the opportunities and you can eventually quickly change from one solution to another if users are unhappy with the way it is.

 

[ramjde]

Hi
Thanks for the input
I have used the third option.
It gave me a flexibility to give a dynamic path and a dynamic filename.