Data

I'm new to FME, so my question may be quite simple: In ORACLE I would like to output the content of a table into a new table. Except for two attributes, the structure of new table is the same as the one of the input-table. The input-table has a field "Geometry" with the type "SDO_GEOMETRY" and the output-table has to have it too. (We don't have Oracle Spatial though). I first defined a reader (format: Oracle Spatial Object) and tried to define a writer. But what format do I have to choose for the writer? With oracle non-spatial I loose the geometry and with oracle Spatial Relational the geometry is no longer saved in an "SDO_GEOMETRY"-field, but in four new tables. How could I do this (is it possible at all without oracle spatial)? Many thanks in advance!

Hi I have a workbench that create a kmz file with placemark and overlay within some nested folder. My placemark and photooverlay use a style that is referenced onto a web server. I want my folder to use a custom icon. All folder the same icon as my placemark and photooverlay. Any idea how to do this in FME ? thanks!

Hello, Our source control team asks that we use the major, minor, build, patch identifier on our FME scripts. When they go to production they drop the patch. So...we start with blah_1.2.0.1.fmw and when promoted to production we have blah_1.2.0.fmw. What I'm struggling with is ensuring that the log generated for the blah_1.2.0.1.fmw is named the same; blah_1.2.0.1.fmw. Moreover, when in production...I need the log to be named blah_1.2.0.fmw. I've tried unsetting the log value among the workspace properties, but this only works one time in execution - i.e. the log being named the same as the script. How do I ensure this behavior is consistent? Note - I cannot, at this time, introduce additional flags when we call fme on the command line, nor do we allow scripts to be touched (edited) when in production...i.e. manually set the log name. Any help or advice would be greatly appreciated. -abe Longmont, Colorado

Hi, This simple task has been stumped. I'm trying to extract 3D nodes from 3D polylines and 3D polygons, to be stored as point features in a separate dataset.. I've tried TopologyBuilder, GeometryExtractor and a handful of other transformers, but I can't seem to find the right combo. I'm sure it's quite simple, but I do need advice on this. Cheers. Lars

I'm using FeatureMerger to join a spatial and non-spatial database based on a common attribute (country column) and in the output, I'll like to write all attributes from both databases. I used "Copy attribute from Transformer", but it copied only some of the attributes...I tested it with just one database and selected Copy Attribute from Feature, it didnt select all the attributes as seen in picture. Please what am I doing wrongly? Thanks

Hi there, I am new to XML and the FME resources availible have been great so far. I am stumped though. I am trying to read a dynamic XML file via the web (similar to RSS I would assume). At this point I can access an XML file via the web and can save this file onto my local computer. Once that is done I take this XML file and use FME to flatten it for attributes and can also add in a 2D point to populate coordinate information... I am loving the FME funcationality so far. Where I am stuck is that I would like to have FME connect into to a web source to read an flatten the XML file instead of having to access the XML via a web browser and then save the XML file onto my local machine. If I plug in the XML url into a FME reader I get an error, here is an example of the error: "Sending HTTP 'GET' request to 'http://www.enetpulse.com/wp-content/uploads/sample_xml_feed_enetpulse_soccer.xml', waiting for response ... The uri-map document 'C:\\apps\\FME\\xml\\urimap\\gml_aixm.xml' is being use

Trying to find out if your software supports the conversion of ESRI shp file data to Spatial Info objects, (not just Autocad objects). Thanks in advance. Erc

Hi, Let me explain what I want to do: I have a ".obj" file, and a ".xml" file which contains some metadata. The coordinates in the ".obj" file are in a local reference frame. Thus, to get them in a projected SRS, I need to translate them using some values that I can parse in the ".xml" file. What I want to do is: Read ".obj" and ".xml" file Compute convex (concave) hull of the geometries in the ".obj" file Translate the hull with values read from the ".xml" file Save the translated geometry in a ".shp" and force its EPSG with a value read in the ".xml" file In the ".xml" file, the EPSG is in the tag <SRS> (e.g. <SRS>EPSG:2154</SRS>) and the origin of the coordinates (the transltion I want to apply) is in the tag <SRSOrigin> (e.g. <SRSOrigin>652367,6862971,0</SRSOrigin>). These tags are enclosed in a ModelMetadata tag. To do the translation, here is what I do: Read ".obj" and ".xml" files Remove unused attributes (optional) Split the SRSOrigin attribute with an AttributeSplitter in a _c

It seems when running KML Network Link Service with a workspace after a while I have "No active engines". Then I need to reboot FME Server and then it finds the floating license again. So 2 questions: 1. Have anyone else experienced this? This is very unstable behaviour 2. I noticed you can only have one user using the KML-service at the time. Do you really need 1 engine PER user that wants to look at the KML? I assume I havent found the workaround - but that it exists.

Hi all, I need some help with sending receiving success/fail notifications with FME Server 2013. I've read all I can find online but it only really covers FME Server 2012. Are there any good documents out there that are for FME Server 2013? Here are a few of my questions: When I publish a workspace to FME Server under the Job Submitter service I select the success and fail topic to publish (Is this where my success/fail notification will go?), the I have the option to select a Notification Writer. Do I have to create this writer and all the content of the notification writer in my workbench? Thanks Rob

Is it possible to use FME Server to deliver a JSON feed in this format? http://open511.org/event.html If so, has anyone done so at this point? Thanks in advance, M

I'm trying to turn a pointcloud into a DEM raster using VectorOnRasterOverlay. My problem is that some of the points in my pointcloud overlap (in Z), and when creating the raster sometimes only the lower points from the point cloud end up in the DEM. Obviously it has something to do with the order the points are processed, but I can't find an easy way to fix it. Any ideas?

Hi, I have a chained set of translations in development. I have been using Schema Reader and Generic Reader while publishing their Source Dataset and chaining them together with Workspacerunner (I do not have FME Server). I have had great success with chaining translations in the past, but I have never used the Generic Reader or the Schema Reader. I would post the translation, but right now I cannot. The problem is, I have a lot of file geodatabases (*.gdb) and I need to send a combination of many or all of them through as the source for the schema reader in a child translation. So I make sure the child translation has the source for the schema reader published and then I create the string for the gdb paths and send it through the workspace runner to the child translation from the parent. Here is how the string looks before it goes through the workspace runner: C:\\Projects\\Area1\\ClientNetwork.gdb,C:\\Projects\\Area2\\ClientNetwork.gdb Now when the child translation fails I go to tak

I have a attribute name Unit # and the writer makes it and underscore. Is there a way to write out the special characters? Thanks, Chad

Hi Guys, I'd like to be able to send a link to download a log file by using the Email template language: http://docs.safe.com/fme/2012/html/FME_ServerRefManual/ServerCore/EmailTemplateLanguage.htm I know how to send the link to resulting data but this is not giving any sensible result: <fmeblock type="optional">Click to download the full log: {urlPrefix}{LogFileLocation}/{LogFileName}</fmeblock> This is not giving any result at all: <fmeblock type="optional">{LogFileLocation}</fmeblock> Any help would be much apreciated. JP.

Hi all I have large scale data and a copy of the same data that has been positionally improved. I have the Point data associated with the original large scale data and would like to apply the point data to the positionally improved data so that the points remain within their polygons (ensuring that the improvement shift does not leave a point outside its original polygon). With FME capable of all tasks, has anyone any ideas how I can use it to do this? Much appreciated Colm

Hello, I've setup a workbench that has a generic reader writing to a file geodatabase with dynamic properties. In the output it keeps appending the geometry type to the feature class name e.g. xxxx_polygon. Can I stop it from doing this? In the dynamic properties section if I set the schema source to the generic reader then I get this issue but if I set the schema source to a SDE reader for example then it doesn't put the feature type on the end. I've tried editing the fme_basename and fme_feature_type properties to force the name to be the value of a user parameter but it still appends the geometry type without me asking it to. Thanks, Peter.

Does anyone know (or can test) if when you only have access to the ESRI Data Interoperability Extension license...assuming you have ArcGIS 10.1, which gives you FME 2012 under the bonnet... can you access FME Store components like custom transformers? This is possible IF you have the ESRI Edition of FME Desktop if you extend ESRI, but I'm wondering if you can see the store or install downloaded FMX files if you have only bought the Data Interoperability Extension direct from ESRI? Cheers, Dave

Hi everybody. I have checked the tutorials on how to write metadata but am troubled. it seems like FME includes extra xml tags causing ArcCatalog not to recognize the metadata. I have included the tags in the text below. What am I doing wrong? any pointers? -<fme:xml-tables xsi:schemaLocation="http://www.safe.com/xml/xmltables signs.xsd" > -<fme:NewFeatureType-table> -<fme:NewFeatureType> <fme:geodb_metadata_string> METADATA GOES HERE </fme:NewFeatureType> </fme:NewFeatureType-table> </fme:xml-tables>

Can someone point me to know where I can find this reader format: "geocode [FILEGDB]" It is a reader that cannot be edited in an existing workspace. When I try to recreate the same transformation in a new blank workspace...Im unable to find that reader format. The reader should be reading a geodatabase file (but we are trying to not have to use ArcGis to consome the file). Any advice or assistance would be appreciated. -abe

Hello everybody, how can I convert a csv-file into a xls-file? How can I declare the delimiter? Thanx

Hi, I'm migrating data into a file geodatabase in which I currently have one feature class that is in my standard format. I want the data im mnigrating to this geodatabase to be stored in a number of feature classes with identical schema. Is there a way to either copy the feature class and change its name and contants each time, or copy its schema? Thanks, Chris

Hello I have converted a shp file to dxf. However, the dxf is natively a 3D polyline and i need it to simply be a polyline. Is there a way of changing the writer to be a polyline? I dont know of the difference apart from the 3D line may have a z value(?) Many thanks Ben

Hi, I'm trying do a simple task involving moving some data from one geodatabase to another, matching up the attributes that I want to keep. Ive selected a file geodatabase as the "writer" but I cannot find a way to specify the feature class that I want to add too so that FME can populate the fields. How can I input into a specific featureclass, rather than create one. Thanks, Chris

Hi All, I have a similar problem to one that was asked here at the end of last year... I have the need to get FME to truncate all of the writers in a workbench regardless of the number of features being written to them. Setting the properties of each Feature Type works perfectly except if there are NO features being passed to the writer... I also have users out there with MXDs which reference all 18 of these SDE feature classes, so deleting them before (or as) the workbench starts is not an option - it has to be a truncate. I have a Python guru looking at it at the moment, but it would be nice if someone on here has had a similar experience and can offer an alternate solution to cutting code.