I've managed to get this working now, by using the following:
"D:\Program Files\FME Suite\fme.exe" GENERATE SDE30 MAPINFO dataset
SDE_tables_to_Tab_with_Symbology.fme --_IN_SDE3Server server --
_IN_SDE3Instance sde --_IN_SDE3UserName username --_IN_SDE3Password
password +ID hotel LOG_STANDARDOUT Yes --APPEND_LINE "INCLUDE
D:\Get_MapInfoSymbology.fmi"
"D:\Program Files\FME Suite\fme.exe"
SDE_tables_to_Tab_with_Symbology.fme --SourceDataset dataset --
DestDataset "D:\tab" LOG_FILENAME
SDE_tables_to_Tab_with_Symbology.log
However, I am also trying to assign the symbology to the Mapinfo Tab
file. I have a field called symbolname in the SDE feature class
which I can use to lookup the mapinfo symbol values from a csv file
using JOINER (see Get_MapInfoSymbology.fmi below). This works fine
and I get the right symbology in the log, however, its not being
passed on to the tab file, I'm not sure how to "expose" the mapinfo
attributes on the Tab file? Has anyone done this before?
Also I would like to add an new column (EXTRACTED) to the Tab file
and populate it with date, I've found on other posts that I may need
to use TCL, but I haven't used TCL before, so not sure where to
start. Has anyone got any examples I could use, and how would I
incorporate it into my Get_MapInfoSymbology.fmi.
Thanks for your help.
Jackie
# -------------------------------------------------------------------
---
# Get_MapInfoSymbology.fmi
#
# -------------------------------------------------------------------
---
DEFAULT_MACRO WB_KEYWORD "SDE30"
"INCLUDE" \"D:\Program Files\FME Suite\metafile\mapinfoCommon.fmi\"
# -------------------------------------------------------------------
------
Relate
TABLE_LOCATION "JOINER:Symbology" "G:\EICU\EICU_scripts\FME_Models\De
velopment\Symbology.csv"
Relate TABLE_DEF "JOINER:Symbology" CSV \
symbolname
column_type_unneeded \
mapinfo_symbol_font
column_type_unneeded \
mapinfo_symbol_shape
column_type_unneeded \
mapinfo_symbol_color
column_type_unneeded \
mapinfo_symbol_angle
column_type_unneeded \
mapinfo_symbol_file_name
column_type_unneeded \
mapinfo_symbol_size
column_type_unneeded \
mapinfo_symbol_style
column_type_unneeded \
CSV_FIELD_NAMES
yes \
CSV_STRIP_QUOTES
yes \
CSV_SEPARATOR
(,) \
CSV_SKIP_LINES
1 \
CSV_DUPLICATE_DELIMS
no \
CSV_MERGE_SCHEMAS YES
Relate RELATION_DEF "JOINER"
1:0..1 \
TABLE "JOINER:Symbology" \
UNIQUE
(symbolname) \
JOIN symbolname TO
SYMBOLNAME \
MATCHED_RECORDS_ATTR
matched_records \
TRIM_TRAILING
No \
TRANSFER mapinfo_symbol_angle TO
mapinfo_symbol_angle \
TRANSFER mapinfo_symbol_color TO
mapinfo_symbol_color \
TRANSFER mapinfo_symbol_file_name TO
mapinfo_symbol_file_name \
TRANSFER mapinfo_symbol_font TO
mapinfo_symbol_font \
TRANSFER mapinfo_symbol_shape TO
mapinfo_symbol_shape \
TRANSFER mapinfo_symbol_size TO
mapinfo_symbol_size \
TRANSFER mapinfo_symbol_style TO mapinfo_symbol_style
# Somehow add a new column called EXTRACTED
# and then add date using TIMESTAMPER below.
FACTORY_DEF *
TeeFactory \
FACTORY_NAME
TIMESTAMPER \
INPUT FEATURE_TYPE * \
OUTPUT FEATURE_TYPE * \
EXTRCTDATE @Timestamp(^Y^m^d)
--- In [email protected], Paul Ramsey <[EMAIL PROTECTED]> wrote:
>
> Jackie,
>
> There are two ways to do this. One is to write a .bat file which
> executes FME 500 times, each time with a different parameter.
> Another is to write an FME "command file" (.cmd I think) which
when
> run by the FME will invoke different mapping files sequentially,
in
> your case the same mapping file over and over, each time with a
> different parameter value for the featureclass.
>
> Paul
>
> On 10-May-06, at 6:51 PM, [EMAIL PROTECTED] wrote:
>
> > Hi
> >
> > I'm trying to export a featureclass from a ArcSDE database into
> > mapinfo
> > tab files. I've got around 500 features classes to export as
tab
> > files,
> > so I would like to do batch processing this ie pass in
featureclass
> > name
> > and get tab file with the same name and same attributes as the
source
> > featureclass plus an additional "extrctdate" attribute.
> >
> > I've sort of got it working using command line. A tab file with
the
> > correct name is created and has the geometry but none of the
> > feature class
> > attributes. I probably need to define the MAPINFO_DEF somehow
but
> > that of
> > course will differ depending on the source featureclass. And
then i
> > need
> > to add an extra field, not sure if this is possible.
> >
> > Has anyone done a similar thing or any suggestions.
> >
> > Thanks in advance for any help.
> >
> > Jackie
>
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our
Professional Services team. Visit www.safe.com/services for details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
