Data

I have a line shapefile and a nodes shapefile, I want to via the topologybuilder to get the from_node_ and to_node_. However, after this transformer, I got some extra nodes which are overlapped on the some input nodes. Those are not I wanted. Because I saw that by an intersection point of 3 lines, 2 lines have the same to_node_, but another has a different to_node_, which is overlapped.   How can I solve this problem? (I can send the data and script)  Thanks for helping!

The full answer to this might ba a bit big for here but any tips on what transformers to use and how to get things to group up would be great, I just need to get started then I can probably figure the rest out. I am trying to generate an XML fragment. So far I have got my data in the following format, 14 features with 2 attributes  Group  Name 01       01 - ID prod lights 01       01 - ID  prod buoys 01       01 - ID prod achare 02       02 - ID insert lights 02       02 - ID insert buoys 03       03 - ID move lights 03       03 - ID move buoys 03       03 - ID move achare 04       04 - ID del lights 04       04 - ID del achare 05       05 - global deletes 06       06 - decide lights 06       06 - decide buoys  The XML I am trying to generate would look like this  <ApplyActionsTask>     <label>01</label>         <action>01 - ID prod lights</action>         <action>01 - ID prod buoys</action>         <action>01 - ID prod achare</action&

I have GML like this:      <gml:featureMember>         <bt:KR_Obiekt gml:id="ID_707">             <gml:boundedBy xsi:nil="true"/>             <bt:kod>104</bt:kod>             <bt:geometriaKarto>                 <gml:LineString srsName="EPSG:2180" gml:id="ID_707">                     <gml:posList>434752.25 710532.47 434752.14 710532.44 434750.4 710531.52 434748.8 710530.31 434747.34 710528.84 434746.03 710527.19 434744.88 710525.4 434743.9 710523.53 434743.08 710521.63 434742.45 710519.77</gml:posList>                 </gml:LineString>             </bt:geometriaKarto>             <bt:label>                 <bt:KR_Label>                     <bt:tekst>10</bt:tekst>                     <bt:geometriaKarto>                         <gml:LineString srsName="EPSG:2180" gml:id="ID_707">                             <gml:posList>434

Hi all,  I have a GML geometry that I would like to convert to WKT (in order to insert it in the geometry with Z column of a PostGIS DB). Here is a geometry sample (from CityGML):    <gml:MultiSurface srsName="EPSG:4979" srsDimension="3">                     <gml:surfaceMember srsDimension="3">                         <gml:Polygon srsDimension="3">                             <gml:exterior>                                 <gml:LinearRing srsDimension="3">                                     <gml:posList srsDimension="3">41.8636830995329 12.4911723999943 0 41.8637580995329 12.4912074999943 0 41.8637078995329 12.4914008999944 0 41.8636328995329 12.4913657999944 0 41.8636830995329 12.4911723999943 0</gml:posList>                                 </gml:LinearRing>                             </gml:exterior>                         </gml:Polygon>                     </gml:surfaceMember>                     <gml:surfaceMembe

I have a table of data that has two fields that have comma separated values in them. Each value is related to each other. So the first comma separted value in Neighbour Code field is related to the first comma separated value in Neighbour Angle field and so on.... The table looks like this    How do I separate these values and create a new record for each value in the fields so the table would look like this:    Thanks  Matt  

I am writing from shapefile to swallworld. I am getting the text "fme_geometry" appended to the end of a text field when I run my conversion. I don't have have the fme_geometry format attribute exposed and even if I did there is nothing connecting it to my text attribute. When I look at the attribute in the inspection point it looks fine. Anyone seen anything like this before.  output looks something like this  blah?blah?blah?blah?blah?blah?blah?blah?blah?blah?blah ?blah?blah?blah?blah?blah?blah?blah?blahfme_geometry

Hi,  I want to make several polygon features as a single GML Surface feature. I need to convert polygons into PolygonPatches and then aggregare them into single Surface (with several polygon patches) grouped by specified attribute. How to get this done? I tried Aggregator, GeometryCoercer, different combinations, but, nothing.

Data: 1-Excel sheet with two columns ABB and NME (abbreviation and full name)  900+ records. 2-Shapefile with Attributes MUNR & MUNL. This attribute has the same abbreviated municipality names as the excel sheet.  What i'm trying to do is create two new attributes (MUNRFull & MUNLFull) on the shapefile that will have the full names.  The statement would be something along the lines of where ABB = MUNR give me the NME output as MUNRFull. where ABB = MUNL give me the NME output as MUNLFull.   

Hi, I'm trying to merge features from 2 excel files with FeatureMerger.. It works if I have a relation one to many but it does not when I have many to many relation.. any idea.. Thanks

My KML files have a Description element and the Description have either an attirbute/value pair or just a value. After the Description has been extracted and a ListExploder for each entry on the description, two stream were created - one for entries that have an attribute name/value pair and another one for entries that have a value with no attribute name.  For the name/value pair (22 entries per feature) they are split and then @Value(_list{0}) was created and (_list{1}) assigned a value to each entry.  For the value only entry (3 entries per feature), an attribute name (attr_name) is created using the element index and then another atribute using @Value(attr_name) is assigned the value of each entry.  When the attributes are merged back with the geometry, the data stream from both attribute streams appear only in the feature information window when features are identified in the inspector. he transformers don't show any attributes . When I use AtributeRenamer to make the attribut

Hi! The excel writer doc says that:"The writer feature type option to Drop Existing Sheet/Named Range is irrelevant if specifying a template sheet here, since the existing sheet will always be replaced by the template sheet." [my underline]. This is not true. The template sheet is retained, and new sheets are created after it. Fanning out data on an expression like <fieldname>.xls and using <fieldname> as sheet name, and Sheet1 as template sheet produces an excel file with two sheets, Sheet1 and <fieldname>. This is not as expected (or my misunderstanding). I have tried numerous tweaks for truncate-overwrite etc etc to no avail. Please advise. Regards, Mats.E

Im creating some tables with an oracle spatial writer but its creating them without a primary key.  I am using a sequence in oracle to increment the value but the created table does not have this ID set to primary key.  How do I get a table I am creating to set a column to be the primary key?  (Im in FME 2013)     

I have a few additional generic attributes with specific values (meaning of them are in a separate codelist)  in my CityGML dataset. Now I want to test them with the transformer "Filter" an sort them by the gml:id. Then I want to write them in an Excel-file or text file. Some attributes are also in the buildingpart with means I need a multidimensional output maybe as xml-file. How can I test only one attribute with the transformer "Filter"? My intention is to build a row of transfomers and every transformer is testing one attribute. At the end I want to write a protocol with invalid datasets. Any ideas? Best regards, Frank

I am looking to create a road outline (Open Street Map). We have gps traces for the left and right edges of the road (time stamped, as two seperate data sets). I realize that most folks would just want the centerline of the road, but we have an unique need, and we need the way paths for both sides of the road.   No need for a full workup soluiton, but if you have tips that would be good (it is a small area, only about 30 acres of road).  

How to add the result of the spatial relator as CSV in the data of requestor

Hi!  I'm using FeatureMerger to merge a Shape file and a CSV file, and outputting to a GeoJSON file. The merge works as it should, but is producing seven extra attribute columns that I don't want, even though none of the Format Attributes are selected in the Feature Type Properties settings (csv_line_number, csv_number_of_fields, csv_total_number_of_columns, multi_reader_full_id, multi_reader_id, multi_reader_keyword, multi_reader_type).  This is obviously making the GeoJSON larger than necessary. Can someone please tell me how to ensure these Format Attributes don't get written out to the final GeoJSON file?  Thanks!

Hello,  I have a bunch of shapefiles as inputs but i'm not using them all everytime, so i put them as Optional in the User Parameter. But i get this message : "Shape Reader: Failed to open dataset 'T:\\Test\\\\SHP\\test.shp' which is neither an existing file nor directory" when i run my script using a python script. Eventhough the shapefile doesn't exist, since it's set as optional, FME should ignore it, no ? How can I make it work please ?

Hi, I am trying to create a folder in "Resource Management" on our FME Server 2014 SP2 - Build 14336 - win32. But the buttons (Upload, New Folder, etc.) are not accessible. And the message "There was a communication problem" is displayed. I have added the following lines in fmeServerConfig.txt: What have I forgotten? Regards Magnus  SHAREDRESOURCE_TYPE_6=FILE SHAREDRESOURCE_NAME_6=SERVER_TEMP SHAREDRESOURCE_DISPLAYNAME_6=Server Temp SHAREDRESOURCE_DESCRIPTION_6=This shared resource is for temporary files SHAREDRESOURCE_ISMIGRATABLE_6=false SHAREDRESOURCE_DIR_6=D:/Temp/ 

Search results for I use several readers in one script, if one is empty FME stops, how can i skip empty readers without stop?

Hi,  I have GML dataset with different polygon orientation. I need to get two points in clockwise order from that polygon. E.g. (in WKT): POLYGON ((0 0, 10 0, 10 10, 0 10)) - counter clockwise Points from this polygon: First Point - POINT (0 0);  Second Point - POINT (0 10) It doesn't matter which two points, but they need to be one after another, and orientation must be clockwise. How to determin or change direction of polygon in FME to know what point I need?

In below image if my excel sheet name is January then all the Fields of Januray joins with writer field "Previous reading","Current reading" etc.If my sheet name is February then all the fields of February joins with with writer field "Previous reading","Current reading" etc.I want a single Fme tool to just read from excel sheet name if its January then all the fields of Jan goes to relative field.If my sheet name is March then all the cloumns of March goes to the specific field.  

Hello all,  I have a problem with CSV reader with FTP path in FME Desktop / FME server 2015.1.  My goal is to watch an FTP server for new files, when a new file comes in, test the name for today’s date and the extension for .csv, do some manipulation to that file and put the data in a database. Once it is done, I want to trigger a job on the database.  As for now, I have a watcher on my FTP server which triggers a workbench that tests the name of the file and launch another workbench with an fmeServer_JobSubmitter. This workbench has a csv reader that takes the FTP path of the file and reads the file. It does the manipulations and put the result in the database. Then, the original workbench triggers the job on the database. I have around 150 files to load every morning and it works for around 140-145 of them every time, but there are a few files that don’t work for a mysterious reason.  For the files that didn’t work, I tried the use the same JSON received by the watcher in the “test t

Hi,  I have a Microstation file in which I am writing to Sketchup. The initial translation from microstation to sketchup works but when I open my sketchup file, the model is placed very far from the origin. Is there anyway that I can move model to the origin?

Hi everyone,  Is it possible to change geometry names for a boundary too? I used the GeometryPropertySetter to set the GeometryName and Traits (see pic below), but it also changes the geometry name for the Boundary IFMELine. I want to set the name for the boundary to curveMember (see Example 2nd pic). The Problem is, that FME is creating a LinearRing for an ElevatedSurface, but i need an GeodesicString. I hope that the geometryname will help me with that.  My geometry:  It should look similar to this:   thanks, Mel

Hello,  I am trying to create a workflow in order to transform a dwg to a cityGML file and later to import it into a 3D citygml database. I have tried to find an example online doing something similar but I had no luck. I wanted to ask if something like this is possible with FME and if there is an available example to get a first impression of how to implement it.  Thanks. Dimitris