• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Table Converter Issues

Hi list,
I've got a table converter which imports a CSV file from the C drive to the
Z files.
I would like to change the 'from' location to a UNC path, however, in std.
jde if you do this you lose ALL your event rules and mappings.
Does anyone know of a way of getting around this problem?
Cheers,
JC
___________________________________________________________________________
Visit http://www.visto.com/info, your free web-based communications center.
Visto.com. Life on the Dot.
 

Adrian_Chimirel

Legendary Poster
JC,
First thing first I'd copy the TC (something like R55TCPY).
Next, I'd copy the source ER.
Finally, paste the ER into your copy (destination).
Should there be any other little mods, you may update them afterwards.
Adrian

B732.1 SP12.2, Oracle 805 on RS/6000, Citrix, Win95&NT
 

Zoltan_Gyimesi

Legendary Poster
Hi John,
This issue is a typical recurrent one and answerd more times.
The solution that I remember is that you have to make a shell UBE or APPL where you copy your input file to the fixed name and location and after it you call your TC through report interconnect.
I do not remember the name of the BSFN with which you can delete and copy op-sys files.
Please, look for detailed answers then mine using the Search capability of the Forum. Search for e.g. "flat", "CSV", "file name" and use the and/or feature. I'm sure, you will find the best fit answer for your problem.

ERIC,
If you could find some good answer for this typical issue then would you be so good as to put them onto the Tips & Traps. Thanks.

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

tombrown

Active Member
Hi John,

You can't 'soft code' the input table to table convertors, and yes, if
you change it after adding event rules, you lose the event rules, since
the events are associated with each input table. What you should do is
use the busines function to 'copy/delete a file' to copy your .csv into
a known location from a unc path - the unc path coould even come from a
processing option if you like...

send us a mail John, let us know how the weather in London is!

Tom






--- johncrook75 <jhc@internet400.com> wrote:
> Hi list,
> I've got a table converter which imports a CSV file from the C drive
> to the
> Z files.
> I would like to change the 'from' location to a UNC path, however, in
> std.
> jde if you do this you lose ALL your event rules and mappings.
> Does anyone know of a way of getting around this problem?
> Cheers,
> JC
>
___________________________________________________________________________
> Visit http://www.visto.com/info, your free web-based communications
> center.
> Visto.com. Life on the Dot.
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=2984
>
> *************************************************************
> 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
> *************************************************************
>


=====
Please reply to tombrown@rocketmail.com






__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/
 
Discover how to build no-code data integrations and business process automations.
Top