Skip to main content

Data

Using readers and writers to extract and load data.

  • 7,283 Posts
  • 26,762 Replies
7283 Posts
gschleusner
Contributor
gschleusnerContributor
 Data
M
matthewbrucker
 Data
K
kelldell
 Data
M
mattyryan
 Data
WFS Doesn't Run Workspace Transformers or Post SQL

Hi Everyone,  I have a workspace which contains a reader for a WFS and a writer for Oracle. I have an issue where if the WFS doesn't read any data then it does NOT run any of the transformers or the pre/post sql scripts for the writer.  This is a problem because if the data has changed we want out database to reflect that. This means that if there is NO data in the WFS we want our table to have no data in it. I can write python to have it delete the data from Oracle but then I also have to kick off some procedures and run some other SQL and realistically that should be in the post SQL. Additionally this would add a third party dependency on a python module which we don't want.  My questions - Is this a bug or is this how it is meant to function? Is there possibly a setting I'm meant to change for WFS to run the workspace even when no features are read?

620
K
J
johng
 Data
KML filename in Zip Output

Hello,  I have a very simple workflow which reads ESRI Shape file  and converts it to either KML, MIF, MITAB etc. using generic writer. To create a compressed output file I appended .zip to DestDataset.  I am facing an unusual behavior in case I try to convert to KML. When I select KML as output format it creates zip file with kml but the file name inside the zip is comping as something _auto_zip_<some numbers>.kml. This is the case only for KML for MITAB, MIF file names are same as source shape file.  e.g. If source shape file is test.shp and output format is MITAB then it created zip with test.tab, test.id etc but if the output is KML then it create zip with _auto_zip_1256789651236_1234.kml Could anybody explain is this behavior as expected?  Cheers John

350
takashi
Celebrity
B
brookphillip
 Data
A
ali
 Data
jamal
jamal
 Data
J
jonathan
 Data
hoa_le
Contributor
hoa_leContributor
 Data
P
phil
 Data
Generic (Any Format) Reader and Schema

Can the Generic (Any Format) Reader handle an arbitrary schema or is it limited to a fixed schema?  This quote from the FME 2014 documentation suggest that it should handle arbitrary schema: "... and is very useful for solving problems when the input format and schemas are not known at design time."  However I have a workflow with Generic (Any Format) Readers that throws an error when I change one or more of the input datasets when testing. The error is:  "During translation, some features were read that did not match a reader feature type in the workspace. This can happen if the reader is changed, or a reader feature type removed or renamed."  "The following unexpected feature types were read:" .....  My workflow checks for a number of data problems.  There are two datasets: a reference dataset and a dataset to check. The reference dataset and the one to check are each used by a Schema (Any Format) Reader so I can check schema differences and a Generic (A

843
mark
Contributor
A
aquamarine
 Data
R
robbie_botha
 Data
How does FME handle empty shape files?

Hi there,  I've created a workspace you can point at any folder containing multiple shape files, and outputs an access mdb files that simply summarizes the counts and present attributes for each shape. The problem is however, FME seems to ignore “Empty” shape files. This is somewhat understandable, but is there any way I can bypass it? The nature of the tasks this workbench has to perform dictates that it also needs to list the empty features. The count will be zero for these specific layers, but I still need them to be added to the output file.  I’ve done several tests, and it doesn’t seem like the empty layers get thrown away at any of the specific transformers, so I’m guessing that it’s an inherent feature of FME it self? Or am I missing something?   Thanks in advance,

1126
mark
Contributor
A
Anonymous
 Data
T
tobias
 Data
Cross section to shape

Hi!  I work with Maritime Spatial Planning and thus have a lot of mapping to be done. One of my biggest concerns is that very often in maps there are layers upon layers - areas of national interest - in the maps, making them hard to read. However, there isn't always a conflict between the interests because some are below the surface, some are on or below the seabed and some are above the surface. My problem is that I wish to make a traditional map and in that map include cross sections as an inset from lines I draw (and then run through FME).     I have gotten as far as extruding (seabed bathymetry model)-draped lines with line on area overlay to polygons, but I cannot export the results to shape to use in ArcMap or QGIS. It has to be a popular format because these results will be shared.     So: I have a lot of polygon and line interests which intersects my freshly drawn cross section-line (straight line, 2 vertex is good enough). Line on area (and line) overlay. Extrude the fea

340
T
J
jking
 Data
GeoRSS Reader working in Desktop but not on Server through Proxy

Hi All,  We have a simple GeoRSS reader workbench here which we would like to publish to our FME Server. The server sits behind a proxy, so proxy authentication is passed into the GeoRSS readers advanced parameters.  Doing some testing on FME Desktop, if I set the proxy settings in the GeoRSS advanced properties, but don't have those setting set in the FME Desktop network options, the workbench hangs for a while whilst trying to call the RSS URL and eventually fails like below:    As soon as I set the proxy settings in the FME Desktop network options, regardless of whether it's set in the GeoRSS properties, the workbench runs fine. So first question is, what is the point of the GeoRSS Network Proxy parameter? If it doesn't seem to effect anything. Does the GeoRSS reader use a different HTTP Client library to other readers/transformers (i.e. HTTPFetcher)?  Also, are we able to set a global proxy setting for our FME Server, in the same way we set the network options in Deskto

220
J
francis_m
Contributor
francis_mContributor
 Data
zzupljanin
Contributor
zzupljaninContributor
 Data
daniel_l
daniel_l
 Data
L
lin_geopartner
 Data
How to read DGN tags intelligently ?

Hi,  Most of the docs on DGN tags are unfortunately about writing them. But I need to read them intelligently.  Tags are exposed as the list variable tag_names{}, which either contains the tag key names, or the tag values, dependent on the "Output Tags As Text" setting in the DGN reader.  And the values in the tag_names{} list is accessed used a numeric index, not the key names.  If one needs to build some logic to handle the situation, where individual objects has vastly individual tag assignments, both name wise and index wise, how does one go about that ?  Intuitively I would loop thru and test the key names, and assign the corresponding value to a variable of my choice. But as I see it, this is not possible in FME 2014 !?  Any experiences and thoughts and suggestions on - or alternatives to - this issue ?  Cheers Lars I  

1047
L
E
eldertt
 Data
P
puppalsm
 Data
M
makela
 Data
M
morijlumos
 Data
E
erwanr
 Data

Badge Winners

  • Bloomsday
    creeatsafehas earned the badge Bloomsday
  • Bloomsday
    crystalwanghas earned the badge Bloomsday
  • Online Training
    gustavohas earned the badge Online Training
  • Accelerator
    jspearshas earned the badge Accelerator
  • Integrate Data with the FME Platform Training
    hudahas earned the badge Integrate Data with the FME Platform Training
Show all badges

Community Stats

32,647
Posts
123,910
Replies
41,040
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.