Data

I am migrating data from ESRI shape files to Smallworld by using FME. But in my ESRI shape files attributes contains special characters and symbols. Sometimes I don’t want to migrate those symbols and specials characters into Smallworld.

Hi All, I have 2 table and I want to find the gap between them and join them in one table to better comparison and presentation of gaps    Can I do this comparision using FME?  Thank you, Lubna

Hello All, I am using a simple workbench that reads ESRI ArcSDE and writs to a dynamic API file geodatabase, the workbench should work as if I am copying the data stored in SDE file (SQL server ) to a fil Geodatabase, but the issue here is that the FME writes the features with wrong names Not as expected.   The FME workbench adds “DBO” prefix and the type of the feature class as suffix  Manual copy/past works fine and names the features as intended   Is there any method to truncate the prefix and suffix which is added by the FME to have the names as if I am using copy/past ?   Best regards, Ahmad Saleh

I am working with ESRI shape files and the data in on of the attribute field in my existing dataset is a mix of information that needs to qualified and segregated into atleast 4 new attribute fields. I hope using regular expressions would be the best way to accomplish this task. I donot have too much experience wotking with FME and I was hoping to see if anyone here has a workspace that you used for somethjng similar that I could refer to . Any help in this is appreciated as all I have now is the regular expressions that will help me qualify the data.

I have data with lines and polylines.. I’d like to have segment with 30m from the starting point and from the ending point (end minus 30). For the polyline I’d like to have only the first and the last segments. I’m using chopper (2 vertexes) to get lines from 2 vertexes but then I need to choose only the first and the last segments. The resultings segments should have the same angle of starting or ending segments of polyline. Any idea .. thanks

Hi! I want to perform a post and reconcile operation on a whole SDE geodb using FME workbench.   I'm following the guidelines here :  http://docs.safe.com/fme/html/FME_ReadersWriters/FME_Readers_Writers.htm#geodatabase/Writer_Directives_EntGeodbFeatClass.htm  It states that :  This optional directive reconciles all the changes between the version specified by the writer directive VERSION and its parent version, even those edits made outside of the current translation, and then posts the version to its parent. [...] Since reconciling is done for all features including those inserted/updated/deleted outside the current translation, then this directive can be used in an empty workspace to simply reconcile and post a child version to its parent. So if I underst

All,  I am using the ESRI file geodatabase writer to write data to both a feature class and table class and establish a foreign key relationship between the data in the two classes.  The only relationship documentation I've found is under the ESRI geodatabase (Access database) writer and that is what I have been trying.  I have three FME feature types for my writer;  one for the feature class, one for the table class, and one for the relationship.  I am setting a geodb_oid on the data for the feature class and table class.  I am setting the set the geodb_type to geodb_relationship, and I've also tried geodb_attributed_relationship, on the relationship FME feature type.  The geodb_feature_has_relationship is set to Yes for all three FME feature types and the geodb_rel_origin_oid and geodb_rel_destination_oid are being set for just the relationship feature type.  When I run the workspace, I'm receiving the error:  Attemp

A 1 STARTED A 2 IN PROGRESS A 3 IN PROGRESS A 4 PAUSED A 5 IN PROGRESS A 6 IN PROGRESS A 7 COMPLETE A 1 STARTED B 2 IN PROGRESS B 3 IN PROGRESS B 4 IN PROGRESS B 5 COMPLETE  I have a list of actions which are listed in the order they performed. Sometimes the actions do not result in a change in the attribute  I am interested in, so there are 'duplicate' entries. However I want to keep those duplicates where they appear either side of a status change.  So in the above examples I'd end up with  A 1 STARTED A 2 IN PROGRESS A 4 PAUSED A 5 IN PROGRESS A 7 COMPLETE A 1 STARTED B 2 IN PROGRESS B 5 COMPLETE  I know how to do this in excel but I'm struggling to find a way to repeat it within FME 

Hello, I would like to load and transform my ArcGIS datasets into our GeoNetwork v3. The metadata is created through ArcGIS Metadata editor and needs to get transformed from ArcGIS format to ISO19139. For this i currently use ArcGIS methods:  translator= ARCGIS2ISO19139.xml arcpy.ESRITranslator_conversion(inputFile,translator,exportFile,logFile)  The workflow should look like the following: inputFile gets zipped, xml gets transformed, xml is published, zipfile is published as geonetwork download service for the xml metadata record  I´ve taken a look at the meta workspace demo but do not understand how to get it working with geonetwork and allready created metadata.

I have managed to create a workspace that will generate PDF files based on maptiles that are run through a clipper transformer and output one PDF per maptile for my entire dataset. Now I want to add non-map elements to the PDF files, but i can find very little info about how to easily do thissimply.  How can I add text (title, map scale, etc) and jpeg images (north arrow, scale bar?) to the output pdf?  Thanks,  Christopher

How do I set the MPolygon line color seperate from the fill pattern color in FME 2015?  Changing the Color value changes both, and setting the attribute autoccad_color (as recommended in a related post) does nothing. If I go into AutoCAD, I can set the line color seperate from the fill - but I'm not sure how to tell FME to output this combo. I am using the REALDWG writer.  Thanks, Bryan

Hello everyone, i think i got a simple task but i seem stuck on it  i have an excel workbook with 100 sheets, with every sheet i would like to create a table in MYSQL  every table has different headers and amount of headers, i can read every sheet as an "indivudual feature type" and connect/dis-connect the wires from the MariaDB writer and this works, but when i use a merged feature type i only get one element, i am fanning out by fme_feature_type to get the correct naming of the table   any help on working with this would be great, thanks!

Hello,  I want to log errors and warnings, therefor I use the MessageLogger Transformer. But in the end when the translation finished the output is "Translation was SUCCESSFULL" even if there were errors. It also prints "|INFORM|Translation was SUCCESSFUL with 4 warning(s) (9 feature(s) output)" with the right amount of warnings created from the MessageLogger transformer.  Is there a setting I need to make, so it prints that translation has failed? Also what I don't get is how the Log Filter is working,  disabling Information and Statistics doesn't change anything.  best regards, Mel

Hi All, I've two shpae files with only geometries and like to delete feature from the first one that contains into the second one. The condition for deleting is there two feautures (feature 1 from file1 and feauture 2 from file 2) are equals.   Thanks an advance.  FarFar

Hello All, FME 2015.1 fails to produce the expected results, I have developed a workbench that mainly convert hatches form AutoCAD to polygons (Esri Geodatabase (File Geodb API)) writer. But the FME fails to write the polygons correctly, In the attached AutoCAD file I have one single hatch that should be transformed to a polygon and stored in a feature class, after running the workbench I found that the FME fills an empty gap with an extra polygon.        Link to download the workbench and the autocad file 

Hello,  I'm using HTTPCaller to call a Web Feature Service URL as a single feature and pull out a further series of web feature services using XMLFragmenter to generate a subsequent list of URLs. This approach has worked a few other times and works well in this instance .... until I use a second HTTP Caller to call the URLs using the attribute generated from the XMLFragmenter (and a bit of string replacement and concatenation).  At first, there is no apparent problem. Even looking at the Data Inspector attached to the HTTPCaller rejection port, it appears to be straightforward. However, pasting the URL into a browser directly leads to a failure and copying and repasting the URL into Word reveals the characters %EF%BB%BF as a hidden part of the URL. This also appears as a square (control character?) and the characters ï»¿ as a surprise part of the URL when the _error attribute is looked at in the Data Inspector table. .   As yo

hello all,  i got an excel file with two columns, one with reference letter and one with a value, i want to turn the values into headers within a SQL tables, each sql table being one reference number what would be the best way going about it?  i have been messing around with listbuilder then expose the values which does give me one row per reference number, also each reference number has a different amount of values, so exposing them leaves a lot of missing values and i am still lost on how to turn them into header, maybe a custom transformer with a loop could help?  any help would be great,  

Hello,  I am working on a dynamic workspace that is supposed to read multiple feature types that are determined at run-time.  These feature types have different WHERE clauses. I am using a process similar to the ones described in the document below.  However, while I can read multiple feature types I cannot find a way to associate each feature type with its own respective WHERE clause.  I am using the feature reader transformer to read any layer I like and the data sources can be separated by a ":" however the transformer takes only one where clause which is applied to all feature types.  http://fmepedia.safe.com/articles/How_To/Pass-a-List-of-Tables-or-Layers-to-an-FME-Reader-using-Python-Scripted-Parameters  Any help or ideas are greatly appreciated!  Regards, 

Hi Guys, I'm not sure if this is possible..... I have a lot of profile drawings in one dwg....(screenshot) Is it possible to generate an automatization in FME to create pdfs for each drawing with the same scale? Do i have to set frames first or can i create frames in FME? Problem: the drawings have not the same size as you see on the screenshot....Any Ideas?   Thx and Greetz Franco

Hi,  I am trying to do a really basic function.  I have a CAD file which i add an attribute to and populate with the fme_basename. I then have an EXCEL that contains the fme_basename and also another field called 'DESCRIPTOR'  basically what i want to do it a test where FME says If the fme_basename = the Basename from excel then populate new field with the value from descriptor. I have used an attribute creator with a conditional value but does not seem to work?

Printing workbenches in A4 paper size in pdf file, I wanted to print the workbench below in A4 paper size in pdf file but it appears that there is no sufficient tools to better layout it in the A4 paper (having it centered, etc.) How this can be implemented in FME? I am not if there is a tool to export the model directly as jpg file the same way we do in the model builder of the ArcGIS Thank you Best Jamal      

We have an inspire transport networks water dataset that we would like to setup a WFS service for. The data is already in gml format and validates ok with the XSD’s provided by FME. I have tried to follow the article: https://knowledge.safe.com/articles/How_To/How-to-Create-a-WFS-Service-Using-FME-Server and indeed I do get getCapabilities to work and also manage to get data out through a web browser. The actual server is inside our firewalls - but can be seen through php here:  http://153.44.6.24/inspireWFS/php/dataRequest.php?version=1.1.0&request=GetCapabilities  or to get some data (be a bit patient)  

Hi,  I've got a weird difference between x-y coordinates between two points which is causing some issues. Using a FGDB, with a featureclass with points included, as a basemap I draw a polygon using the esri snapping function on. This polygon has its corners snapped to the points and is saved in a .shp shape file. In ArcMap the x-y coordinates of the corner points are exactly the same as the points underneath them.  Now when using FME and FME dataviewer these points have slightly different x-y coordinates only differing on the 9th decimal. Meaning that the points do not fall inside the polygon creating difficulties.  To keep it simple the x-coordinate of the point is: 67479.59299999848 and the x-coordinate of the polygon corner point is: 67479.593000002205  Now my question is this: What makes the differences because the difference isn't just plain and simple rounding. With rounding I would

I am getting error as "Unable to login to smallworld". Following error is coming.  Creating reader for format: Smallworld 4  Trying to find a BUILTIN plugin for reader named `SWORLDSWAF'  Trying to find a DYNAMIC plugin for reader named `SWORLDSWAF'  Loaded module 'SWORLDSWAF' from file 'C:\\Program Files\\FME\\SWORLDSWAF.dll'  FME internal API version is '3.7 20150407'. The 'SWORLDSWAF' module was built with FME API version '3.6 20090807'  Creating reader for format: Smallworld 4  Trying to find a BUILTIN plugin for reader named `SWORLDSWAF'  Trying to find a DYNAMIC plugin for reader named `SWORLDSWAF'  FME internal API version is '3.7 20150407'. The 'SWORLDSWAF' module was built with FME API version '3.6 20090807'  Opening the Smallworld Reader on dataset `

Hello everybody,  i am pretty new the FME. so please dont bash if this is actually a simple question.  I would like to intersect a Digital Elevation Model with 3D-Buildings. What would be the preferred data type (TIn, Raster, Triangles...etc) of the DEM (i have got a regurlarly spaced point file .xyz with z-values and breaklines in an esri-shape) to intersect it with the buildings (which i have in a CityGML-file)? As a result i would like to get the lowest point of each building, which i will use to calcalute the height of the buildings (the roofs i ahve already...).  Thanks for any suggestions about what kind of DEM and transformers to use...  Greets Patrick