Transformers

Hello,I'm very new to FME and trying a relatively simple workflow. I have a DWG file of a building layout. It includes polylines for rooms (all on one layer), and within each polyline, there is a simple text label for the room number (all on another layer).  I would like to transform the data in this DWG to an existing PostGIS table, where the room geometries will populate the 'geom' field and the text labels will populate the 'name' field.  I'm having a hard time converting the labels to text strings and also ensuring that the text labels are matched to the correct room polyline.  My current workflow is shown below:The room polygons from the DWG file import fine, however the text labels for rooms do not populate at all in the PostGIS table.

HiI wonder why FME sometimes add more decimals. For example:  If I import the number 652314.30, FME sometimes convert it to 652314.300000004Does anyone know why? I see this problem quite often and I solve it with the string formatter./Fredrik

Hello, I am struggling with an issue within my workbench. It is a bit difficult to explain, so I hope my explanation is understandable. I got stuck at this transformer: The failed output port is similar to this format: The passed output port is similar to this format: What I want to accomplish is the following table:So I want to test the outcome of the failed output port based on the fact if a value in the 'Number' column corresponds to a value in the 'Number' column of the passed output port. And if a row meets this requirement I want to join it with the rows of the passed output port.Can anyone explain to me which transformer(s) I should use to accomplish this? Thanks in advance!Eva

hi, I have an excel file, which has 3 fields: date, confirmed and country. But some data and confirmed values are without values. For those who are without values, I would like them to be filled out, considering the last value. In other words, the last data for a given country was 04/29 and the next data record for empty, the filling must be automatic for 04/30. The same thing should happen for "confirmed" if the last record is determined for 50 country and the next record is empty for that same country, the filled value must be 50, always the previous value.  thank´s

Prior in FME Server 2016.1, CANA83-10TM115-EAP is recognized by FME SVR.Predefined coordinate system `CANA83-10TM115-EAP' (Alberta NAD83; 115 deg West, positive easting coordinates) matches dataset coordinate system Now in FME Server 2019.1,  here is the log:Predefined coordinate system `10TMAEPFOREST_83' () matches dataset coordinate systWhich is not the one set in the submitted gdb. This is specific to FME Server, when running locally, CANA83-10TM115-EAP is set correctly within FME properties.  This is not a custom coordinate system so it should not be added to the Engine/CoordinateSystems repository according to the documentation  Any thoughts anyone? tks

Is there a way to import settings directly into the DGNStyler, ideally using an export from another Microstation file to maintain the symbology etc?

HelloI am looking to write a simple execution report in a file with the name of the writer / table name and the number of records written. I don't want to use summaryReporter or FME_END_PYTHON. How to do this simply? Thanks in advance  

So the last requirement for the professional certification states:Once you’ve completed the exam and have a grade of 75% or higher, you are ready to submit your application. Before submitting your application, please review the sample documentation. Your application must include: 2-3 workspaces from projects which conform to FME best practices as outlined in FME Desktop Basic Best Practice section. Your sample projects should demonstrate an advanced level of FME expertise. Any related files or information should be provided just as if you were delivering a solution to a client. Source data or output data is not required for your sample projects.Workspace documentation in a PDF, Word document, or Text file. Here is an example of workspace documentationReferences from 2 clients whose projects you’ve been involved with within the last two years.All parts of your application must be in English with the exception of your workspaces. At the moment, I'm only using FME that comes shipped

Simple need, simple question.I have a raster with 1 cell size 25x25 meters (geotiff)Just want to have the cell split up to a 5x5 meters raster with having those new 25 cells with a 5x5 meters raster having the same value as the original 1 cell of 25x25 metersAnd nothing else should change! But whatever Transformer I use or in combination with each other, it doesn't let me succeed in my goal.For example: with the RasterResampler it recreates a new raster with my desired resolution, but it doesn't keep the original values. It also seems to shift my raster. I have also tried to create a new raster and then use the points from that raster to extract the desired values. But that takes so much time to process...  What am I missing? What do I not understand?

Is it possible to transform a RASTER file into MBTiles format using FME? For example GEOTIFF raster to MBTiles format.Is there a tutorial on youtube?

For one user, SQLExecutor is correctly changing to connect to DEVSQL\\High at run-time. For another user, the default parameters specified in the SQLExecutor (QASQL\\High as shown above) are being used. What user configuration setting needs to change in order to correctly grab the same database as user #1 is getting?

Hi, not sure where else to ask this (first time poster).I have a large amount of coordinate data (only know the coordinates in Gauss-Kruger and the zone (zone 3)). Is there any way I can mass convert these coordinates to UTM? I've been researching this all day and have came across a few helpful research articles and one finished with a website that was created by a team of researchers using R and Shiny software, but the link was dead and I don't have time to recreate their work.I do not need to put them into a GIS, this data is being recorded in an rdb for analysis purposes, but is still very reliant on LOCIIDs.

Hi everyone,Noob here.I want to translate (move) the red lines in order to have the ending (or initial point) on the red line over the blu line. The length of the red line does not have to change. I tried with anchored snapper, but I think I need an anchored mover?!The red lines can also have many many vertices. Thanks,Have a nice day. 

Are there any known conflicts between Harris Geospatial FlexNet License Server and FME Server?

Hi,I'm trying to convert UTC datetimes to CET/CEST but can't find the way of getting a datetime that takes into account the Daylight Saving Time differences. The local settings of the DateTimeStamper or @TimeZoneSet function are of no use because the workspace is run in an FME Server where the local time is UTC.Thanks a lot in advance! Francisco

Hi, I'm using a JSON reader to grab data from an API. It's reading the attributes, but the datetime is formatted like so: 1587896100000 Firstly, what is the format of this? Is it JSON specific? And how can I convert to this to a SQL datetime,. which is where the output is going to be stored? ThanksN

I have a dynamic workbench that reads shapefiles and exports them to a FGDB. I have a .shp that had a few duplicate field names and wouldn't export to FGDB until I removed them. Is there a Transformer that will flag these duplicate fields and remove or rename them?

I have multiple shapefiles (total size is 8.4 GB). Those need to be zipped. When using FME's ZipArchiver, compressed file size is 4.43 GB. But when using third party app – 7zip, the result file is ~11% smaller (3.94 GB). My guess woul be that ZipArchiver uses different libararies for compression. Maybe it is possible to use 7zip libraries in ZipArchiver, when compressing files?LZMA compression won't work in this case, because I need to be able to extract archives with built-in Windows extractor.

When I trying to build of lines from points, I get some thing like this:I am using LineBuilder, and group by attribute (each group of points has a different name), but I don't understand why I also get connect line (green one) between them ?

Hello,I've made a FME to raterize some point cloud into elevation raster but I'm not satisfied with the result. I would like to be able to specify in the transform parameters which point is used to color the raster (min z, max z, etc ...). Indeed when we have power lines for example it is desirable that the point used for coloring is that of the line and not that of the ground. This makes it possible to highlight it in the Raster.Do you know if there is a way to control the coloring in this way? Example :That is what FME give me (left) and what I want (right)You'll see the difference on wire and tree Regard,Arnaud

I'd like to read a text file containing several lines of user defined variables given in the following format:var_name = "var value"There are many lines, each one contains one single variable with one single value:var_name0 = "var value0"var_name1 = "var value1"... I read the text file using an AttributeFileReader to which I connected an AttributeSplitter. My results come as one single concatenated line which is obviously not what I want.  In the Delimiter field of the latter, I tried inserting `\n` `\r` or`\r\n` without any success.  I also tried inserting a single newline by pressing one time enter in the "Editor" as discussed here (2013): https://knowledge.safe.com/questions/2361/use-attributesplitter-with-a-carriage-return.html without much success.  I'm using FME(R) 2020.0.0.1 (20200316 - Build 20202 - linux-x64) on Ubuntu 18.04. Thanks.

I'm trying to convert a bunch of building wall tiles from SHP to DWG. The tiles are already polygons, but I coerced them into fme_polygon anyway. Then I use the DWG styler, with Area: Hatch, Fill Pattern: SOLID. The Inspector shows what I expected, however when I write the data, what I actually get in AutoCAD is just line-thin hatches, with some even missing. Also, when I open the file in the inspector, it just shows the lines on the ground, or everything got flattened.. do I need to manipulate the data further? I figured I could leave it as polygons, but AFAIK AutoCAD still interprets those only as the boundary lines, i.e. not opaque surfaces.

I need to find all empty folders. Any hidden system files do not count (for example, Thumbs.db). I tried using Python, but unsuccessfully. Can someone help me on this?import fmeimport fmeobjectsimport osif len(os.listdir(feature.getAttribute('path_directory_windows)') ) == 0:    feature.setAttribute('Value', 0)else:        feature.setAttribute('Value', 1)

Hi all,I'm trying to read an .fbx model exported from Infraworks. It appears in the data inspector with textures mirrored and the following warning : "FBX_1: A texture used by mesh in node 'Mesh N' references a UV set named 'default', which doesn't exist"I've tried to re-mirror the appearance but nothing seems to work and I don't know how to reference the UV set ... Do you have any idea what am I doing wrong ?The area in Infraworks :The area in DataInspector:the fbx file and others : Regards,Louis 

I have inherited some older workbenches/server workspaces and am noticing some issues with writer parameters, specifically where ArcSDE connections are concerned. For examples, I found that "accidentally" saving an old FMW in FME 2018 Desktop when the FMW leveraged fme_where without the explicit setting in the WHERE field, wreaked havoc by turning some updates into inserts. I have fixed that by cleaning up the workspace.1) Now, I'm looking at a workbench that is doing versioned editing in SDE and has the Writer set to 'INSERT' and 'CREATE IF NEEDED'. Yet it's doing updates. How is that possible - what am I missing?