tmesser
Member
Re: Table Conversion File Name
This is a multi-part message in MIME format.
------=_NextPart_000_0045_01C0595B.5E48CFE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Here is a response from Mike Bennett on the list that I saved concerning =
this subject:
Mike Bennett wrote >
You can't change the name of the output file your report creates. What =
you
will need to do is in the End Section of your reports controlling =
section
you will need to perform a couple of Delete or Copy Flat file business
functions (B4700230).
e.g. Your database output is being created in c:\temp\outfile1.txt
In your End Section, you would use the above BF to copy
c:\temp\outfile1.txt to the file name your user has specified in the
processing options. Then use the above BF
to delete the original outfile1.txt file. This has the added
benefit of allowing your user to run this report at any stage without
having to remember to remove the original output file so that data is
not appended to it.
The cActionOnFlatFiles tells the BF whether your copying or deleting a =
file.
A value of 1 will delete and 2 will copy.
This should do what you want.
Tom
----- Original Message -----=20
From: "Support" <[email protected]>
To: <[email protected]>
Sent: Tuesday, November 28, 2000 3:37 PM
Subject: Table Conversion File Name
> To: <[email protected]>
> Subject: Table Conversion File Name
> Date: Tue, 28 Nov 2000 22:19:10 +0200
>=20
> Hi List,
> I am doing a table conversion, I am converting from txt=20
> file to OneWorld
> file. I do not want to use a static txt file name and=20
> path. I want to enter
> path and file name from processing options. Is there any=20
> way for doing it.
>=20
> OneWorld B73.3.2 SP 13 SQL 7.0 NT
>=20
> Regards
>=20
> Tankut Cizmeci
>=20
>=20
>=20
> ----- End forwarded message -----
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>=20
>=20
------=_NextPart_000_0045_01C0595B.5E48CFE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Here is a response fromMike =
Bennetton=20
the list that I saved concerning this subject:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Mike Bennett wrote ></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2>You can't change the =
name of the=20
output file your report creates. What you
will need to do is in =
the End=20
Section of your reports controlling section
you will need to perform =
a couple=20
of Delete or Copy Flat file business
functions =
(B4700230).</FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2>e.g. Your database =
output is being=20
created in c:\temp\outfile1.txt</FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2>In your End Section, =
you would use=20
the above BF to copy
c:\temp\outfile1.txt to the file name your user =
has=20
specified in the
processing options. Then use the above =
BF
to delete=20
the original outfile1.txt file. This has the added
benefit of =
allowing=20
your user to run this report at any stage without
having to remember =
to=20
remove the original output file so that data is
not appended to =
it.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2>The cActionOnFlatFiles =
tells the BF=20
whether your copying or deleting a file.
A value of 1 will delete and =
2 will=20
copy.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><FONT =
color=3D#000000>This should do=20
what you want.</FONT></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><FONT=20
color=3D#000000></FONT></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><FONT =
color=3D#000000>Tom</FONT></DIV>
<DIV>
</DIV></FONT>
<DIV><FONT face=3DArial size=3D2>----- Original Message ----- </FONT>
<DIV><FONT face=3DArial size=3D2>From: "Support" <</FONT><A=20
href=3D"mailto:[email protected]"><FONT face=3DArial=20
size=3D2>[email protected]</FONT></A><FONT face=3DArial =
size=3D2>></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>To: <</FONT><A=20
href=3D"mailto:[email protected]"><FONT face=3DArial=20
size=3D2>[email protected]</FONT></A><FONT face=3DArial=20
size=3D2>></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Sent: Tuesday, November 28, 2000 3:37=20
PM</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Subject: Table Conversion File=20
Name</FONT></DIV></DIV>
<DIV><FONT face=3DArial>
<FONT size=3D2></FONT></FONT></DIV><FONT =
face=3DArial=20
size=3D2>> To: <</FONT><A =
href=3D"mailto:[email protected]"><FONT=20
face=3DArial size=3D2>[email protected]</FONT></A><FONT =
face=3DArial=20
size=3D2>>
> Subject: Table Conversion File Name
> Date: =
Tue, 28=20
Nov 2000 22:19:10 +0200
>
> Hi List,
> I am doing a =
table=20
conversion, I am converting from txt
> file to OneWorld
> =
file. I=20
do not want to use a static txt file name and
> path. I want to=20
enter
> path and file name from processing options. Is there any =
>=20
way for doing it.
>
> OneWorld B73.3.2 SP 13 SQL 7.0 =
NT
>=20
> Regards
>
> Tankut Cizmeci
>
> =
>=20
> ----- End forwarded message -----
>=20
*************************************************************
> =
This is=20
the JDEList One World / XE Developers Mailing List.
> Archives and =
information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be =
found at=20
</FONT><A href=3D"http://www.JDELIST.com"><FONT face=3DArial=20
size=3D2>http://www.JDELIST.com</FONT></A>
<FONT face=3DArial =
size=3D2>>=20
*************************************************************
> =
>=20
</FONT></BODY></HTML>
------=_NextPart_000_0045_01C0595B.5E48CFE0--
This is a multi-part message in MIME format.
------=_NextPart_000_0045_01C0595B.5E48CFE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Here is a response from Mike Bennett on the list that I saved concerning =
this subject:
Mike Bennett wrote >
You can't change the name of the output file your report creates. What =
you
will need to do is in the End Section of your reports controlling =
section
you will need to perform a couple of Delete or Copy Flat file business
functions (B4700230).
e.g. Your database output is being created in c:\temp\outfile1.txt
In your End Section, you would use the above BF to copy
c:\temp\outfile1.txt to the file name your user has specified in the
processing options. Then use the above BF
to delete the original outfile1.txt file. This has the added
benefit of allowing your user to run this report at any stage without
having to remember to remove the original output file so that data is
not appended to it.
The cActionOnFlatFiles tells the BF whether your copying or deleting a =
file.
A value of 1 will delete and 2 will copy.
This should do what you want.
Tom
----- Original Message -----=20
From: "Support" <[email protected]>
To: <[email protected]>
Sent: Tuesday, November 28, 2000 3:37 PM
Subject: Table Conversion File Name
> To: <[email protected]>
> Subject: Table Conversion File Name
> Date: Tue, 28 Nov 2000 22:19:10 +0200
>=20
> Hi List,
> I am doing a table conversion, I am converting from txt=20
> file to OneWorld
> file. I do not want to use a static txt file name and=20
> path. I want to enter
> path and file name from processing options. Is there any=20
> way for doing it.
>=20
> OneWorld B73.3.2 SP 13 SQL 7.0 NT
>=20
> Regards
>=20
> Tankut Cizmeci
>=20
>=20
>=20
> ----- End forwarded message -----
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>=20
>=20
------=_NextPart_000_0045_01C0595B.5E48CFE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Here is a response fromMike =
Bennetton=20
the list that I saved concerning this subject:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Mike Bennett wrote ></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2>You can't change the =
name of the=20
output file your report creates. What you
will need to do is in =
the End=20
Section of your reports controlling section
you will need to perform =
a couple=20
of Delete or Copy Flat file business
functions =
(B4700230).</FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2>e.g. Your database =
output is being=20
created in c:\temp\outfile1.txt</FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2>In your End Section, =
you would use=20
the above BF to copy
c:\temp\outfile1.txt to the file name your user =
has=20
specified in the
processing options. Then use the above =
BF
to delete=20
the original outfile1.txt file. This has the added
benefit of =
allowing=20
your user to run this report at any stage without
having to remember =
to=20
remove the original output file so that data is
not appended to =
it.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2>The cActionOnFlatFiles =
tells the BF=20
whether your copying or deleting a file.
A value of 1 will delete and =
2 will=20
copy.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><FONT =
color=3D#000000>This should do=20
what you want.</FONT></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><FONT=20
color=3D#000000></FONT></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><FONT =
color=3D#000000>Tom</FONT></DIV>
<DIV>
</DIV></FONT>
<DIV><FONT face=3DArial size=3D2>----- Original Message ----- </FONT>
<DIV><FONT face=3DArial size=3D2>From: "Support" <</FONT><A=20
href=3D"mailto:[email protected]"><FONT face=3DArial=20
size=3D2>[email protected]</FONT></A><FONT face=3DArial =
size=3D2>></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>To: <</FONT><A=20
href=3D"mailto:[email protected]"><FONT face=3DArial=20
size=3D2>[email protected]</FONT></A><FONT face=3DArial=20
size=3D2>></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Sent: Tuesday, November 28, 2000 3:37=20
PM</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Subject: Table Conversion File=20
Name</FONT></DIV></DIV>
<DIV><FONT face=3DArial>
<FONT size=3D2></FONT></FONT></DIV><FONT =
face=3DArial=20
size=3D2>> To: <</FONT><A =
href=3D"mailto:[email protected]"><FONT=20
face=3DArial size=3D2>[email protected]</FONT></A><FONT =
face=3DArial=20
size=3D2>>
> Subject: Table Conversion File Name
> Date: =
Tue, 28=20
Nov 2000 22:19:10 +0200
>
> Hi List,
> I am doing a =
table=20
conversion, I am converting from txt
> file to OneWorld
> =
file. I=20
do not want to use a static txt file name and
> path. I want to=20
enter
> path and file name from processing options. Is there any =
>=20
way for doing it.
>
> OneWorld B73.3.2 SP 13 SQL 7.0 =
NT
>=20
> Regards
>
> Tankut Cizmeci
>
> =
>=20
> ----- End forwarded message -----
>=20
*************************************************************
> =
This is=20
the JDEList One World / XE Developers Mailing List.
> Archives and =
information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be =
found at=20
</FONT><A href=3D"http://www.JDELIST.com"><FONT face=3DArial=20
size=3D2>http://www.JDELIST.com</FONT></A>
<FONT face=3DArial =
size=3D2>>=20
*************************************************************
> =
>=20
</FONT></BODY></HTML>
------=_NextPart_000_0045_01C0595B.5E48CFE0--