Transformers

Hi. I got this problem while converting my IFC model to gdb (geodatabase folder). My model is quite complex which consist of the Architecture model. When I try to convert it to gdb, there are only some features that are successfully convert. Others features with "Encountered 3D Geometry missing appearance information. Geometry will be written without textures" warning is not converted to gdb. I actually need that texture to be in my geodatabase model. Can anyone help and guide me to solve this problem? Im a new user of FME.

Hello All,Problem:I have a csv that has 2 sets of UTM coordinates (Eastings,Northings) for each location. I would like to compare the length of the values and choose the set that has the most precision (most number of decimal places) and then write that pair to new columns. I am using the StringLengthCalculator to create and populate a field for each Easting and Northing. Eg: 1EastingLen, 1NorthingLen, 2EastingLen, 2NorthingLen.I'm getting stuck on how to use a TestFilter to write one of the pairs based on some logic.If I were to pseudo code what I want, it would sound like this:For all records in csv:If 1EastingLen >= 10, then write 1Easting to new Easting Colum AND write 1Northing to new Northing column.Else write 2Easting to new Easting etc....All help is appreciated.Thanks.

I'm getting the most current readings for streams via an xml table provided by http link. I want to make 2 tables of the readings: 1-with the most current readings and one with the history or previous days readings. What I have so far set-up in FME does the job but I cant seem to seperate "history" from "current". Also I need the time format to stay in UTC-GMT in the AttributeCreator_2 (see screenshots). I'm trying to make a live feed map in arcpro of the sensor readings so any help would be appreciated as I am totally new to FME ANYTHING!Thanks!

Hi,Bit of on odd one i cannot work out. I have some tabular data e.g.203040325The headers are 20,30,40 with values 3,2,5.Is there a simple oway to end up with20304020,20,2030,3040,40,40,40,40Thanks

Hi, I have a Schema Source and Destination in a database and the Feature Type names contain the Table Qualifier (e.g. <prefix>.<table_name>). One one side it is dbo. on the other it is tab.I tried to follow the guide https://knowledge.safe.com/articles/1156/dynamic-workflow-tutorial-destination-schema-is-de-3.html but with this same data source you can remove the prefix as an option. With SQL Server it doesnt appear to be possible. How do you get round this?Many Thanks,Oliver 

Hello, My name is Fred from the Netherlands and i have a problem creating lines from attribute values. I hope somebody can help me!In the attached file beschoeiing.xlsx you can see the RD-coordinates (dutch EPSG:28992) of line objects in 3 different columns:Option 1: rds coordinaten X- and Y-coordinate cobined in one feature Option 2.1: rds X: only X-coordinate in a feature Option 2.2: rds Y: only Y-coordinate in a feature (use option 1 or combine option 2.1 and 2.2)I want to create line objects from this data. I think i have to loop through the coordinates, but i do not know how to do that. After looping i need to make geometry (lines). I want the features "naam", "nummer" and "object id" from the excel file attached to the line-geometry.Can somebody help me please?Kind regards, Fred PS1: (i'm not completely new to FME, but i'm not (yet) a super-user) PS2: i hope you understand my english ;-)

I have compiled a workbench which writes to a multi page PDF. It groups objects by 'page number' derived from a Group_id (using count) after the PDFPage Formatter. My problem is: I have other objects (standard text/logo) which I need to write to every page. How do I get other objects to appear on every page?

Instead of splitting a line by distance or specific vertex indexes, I want to split lines whenever the angle to the next segment is not within x degrees.  Any ideas on how to accomplish this?

I'm looking for a way to find linesegments in a network behind a selected segment. In this case the red line is the selected segment.The result is the line marked with 2-45.9. In this case resulting in 1 line but there can be more segments. My question is similar with this issue: https://knowledge.safe.com/questions/56654/analyzing-water-network-connectivity.html Does anyone have an example with the NetworkFlowOrientor?Thanks.

Hi, I have a problem that I can't seem to wrap my head around maybe because it's monday or maybe it really is difficult?  I have a series of "events" (5000+) with random timestamps. I want to count how many events between every whole hour.  20180101010000  20180101011854  20180101013542  20180101015233 Count = 3  20180101020000  20180101021854  20180101024705 Count = 2   I want the resulting table to be like this Time Count 20180101010000 3 20180101020000 2 Thanks!  /Jacob   

Hi, Is there a way of being able to replicate excel's sumifs/Averageifs functions in FME?I have two tables, the first table has unique ID's and the second table contains data which I need to aggregate. Is there a transformer where I can use the unique values in table 1 to match against the data in table 2 to perform a Sumifs?Thanks in advance.

After geolocate in my SketchUp 2017 when I am trying to convert SketchUp file into GML file with epsg 24370 crs it cannot properly convert bounds that's why I lost my location I almost try with every crs of my country I usually face this problem. Please have a look at my fme skp to gml conversition file and direct me for further changesThanks.

Hi,I have a image folder (.TIF) which the structure MODIS_2017001.tif, MODIS_2017009.tif, MODIS_2017017.tif,...My target want to convert julian calender to YYYYMMDD.For example : MODIS_2017001 -> MODIS_20170101; MODIS_2017009 -> MODIS_20170109; MODIS_2017017 -> MODIS_20170117Could you tell me how to the way to make it?Thank you

I am trying to copy the data from our staging database to our production, but it hanging at this stage forever (more than 12 hours now). 35.9| 0.1|INFORM|Geodatabase Writer: Truncating table/feature class `GEODBMGR.Assess_Parcels'I don't see any error message. It used to work. This is first time I run it after I clicked the 'Update writer'. I don't know if that has anything to do with this.Thank you in advance for any of your help!

My goal is to create a JSON file that matches the following template. I've been struggling getting the coordinates in the linestring geometry property properly formatted. Note the addition of the "tippecanoe" property.{    "type" : "Feature",    "tippecanoe" : { "maxzoom" : 9, "minzoom" : 4 },    "properties" : { "FULLNAME" : "N Vasco Rd" },    "geometry" : {        "type" : "LineString",        "coordinates" : [ [ -121.733350, 37.767671 ], [ -121.733600, 37.767483 ], [ -121.733131, 37.766952 ] ]    }}Things I tried:Basic geojson writer - Writes the maxoom/minzoom property under "properties" instead of "tippecanoe".JSONTemplater - concat('[[',geom:get-points('xy', ', ', '],['),']]')This method works, but feels hackish; it adds quotation marks (") which I remove later. geom:get-text-data(geom:get-name())The second method returns null values. I give the geometry a name with the GeometryPropertySetter, but still returns a null value. If someone can post a working example, I can go from th

I'm writing line and polygon data to an OSGB-file and need color info to be preserved and written correctly. At the moment I can't seem to get a written file with color data in it. Everything else however works and is represented as expected. Am I missing something in order to get the writer to write color data? As textures and diffuse color values are supported according to the quick facts page I figured that simple color values would be as well, but maybe this isn't the case?

We have a new server (windows server 2016) on which we have installed FME2018. Before that, we had FME2016 installed on a server with an older operating system (WindowsServer 2007). On the old server, the names of the open workbenches and whether they were runnig were displayed in the taskbar, which was very handy. But now on the new server, only FME symbols are displayed and I have to do something to get to those informations. I guess this is rather a windows than a FME2018 issue, but is there a possibility to display the name and the running-status of the open workbenches?Thanks, Vera

Hi,I am writing out to KML using a FeatureWriter from a File Geodatabase and want to set the geometry of the polygons to not tessellate (default is for tessellation).I have found the geometry tag but I am unable to figure out how to insert it into the workflow. I need to optimize a large dataset in google earth for less than ideal computers.Thanks!

Hi,I'm trying to create a shortest path from point A to B, yet FME is not outputting any path. I've looked at similar questions asked on here, and I've adapted my workbench accordinly, but still no luck.I'm using an OpenStreetMap highway layer as input. I've explicitely set my snapping tolerance as relatively high in the shortespathfinder, just so that I could just get some output. But it didn't work either.Printscreen of my workbench: 

I am really a neophyte at SQL so could use some help. I have 2 tables, my primary data is a dgn file and the table to update from is an Excel spreadsheet.dgn file: excel:I want to join the excel to the dgn file when the first 12 characters of igds_level_name contains the NameCode in the Excel file. I will then update the dgn.Category from the excel.Category. My output should only be the dgn file.The last attempt at making this work:SELECT * FROM Output    LEFT JOIN "US36_dgn_Categories00" ON (SUBSTR("igds_level_name",1,12) LIKE "US36_dgn_Categories00"."NameCode")    SET "Output"."Category" = "US36_dgn_Categories00"."Category"

Since last couple of versions this really annoying message pop's up.As soon as one or more merge keys has duplicates. Even if the combined keys are unique. I am forced to put a (disabled) inspector on the rejected features output port.PCNLTSTRAATNAAM2324HG702Bachstraat2324HG704Bachstraat2324HG706Bachstraat In the example above I use both fields as merge keys. The "straatname" causes the extra_ref._feature rejection.This gets worse if I merge on more fields, which I do in this workbench the example is from, up to 7 fields. (setting ignore nulls or empty will cause everything to not merge, as all of them have 1 or more with value null) There is no setting to "ignore rejection" afaik.Of course I can concatenate first into a merge_key to emulate oracle's "coalesce". But shouldn't be necessary I think.Anyone knows why? Or is there a setting to stop this behavior.Is there a "ignore rejection" option?

Hi everyone, I use an XMLTemplater (FME Desktop 2015), where I want to add text that includes special characters. So I want to wrap <![CDATA[]]> around the text, when I add it to the String itself, it gets automatically resolved by fme. XML Templater:<adv:localFlightRestrictions><![CDATA[@Value(localFlightRestrictions)]]></adv:localFlightRestrictions>So the XML output does not contain the CDATA term, is it somehow possible to stop fme resolving the term itself, and write it to the xml as a simple string?Thanks, best regardsMel

Hi FMErs,I have an AutoCAD dxf of 2D contours with elevations at 1m increments in an attribute.When trying to create a surface DEM and points with the surface modeller, the tolerance parameter needs to be tuned to an appropriate value to reduce the number of vertices. Question is, what are the units of the tolerance parameter ?Thanks in advance

So I try to update my profile, but I continuesly encounter this problem:Failed to load profile.Since the report a bug only contains category issues about the software, I though I should post it here if anyone else is encountering the same problem.So what can I do to fix this?

Is there abilities to itierate through mutliple datasets in a folder? EG; I want to convert the format of multiple grid datasets so want to be able to build a simple FME process that runs for the first dataset, then runs for the seond, then third, etc.I don't want to have to duplicate the simple FME process for each dataset I want converted.