Transformers

Hi! I am working on trying to automate a fanout for individual maps based on one point layer in ArcGIS Online. The maps should show one point per PDF with parcels and streets labeled in the background. So far I have been able to have a one page write out per point feature but the scale in the PDFs is extremely zoomed out to the point where all the point features would be shown. Additionally, the parcels and streets don't show on every page unless the _order field is set to the same number as the point feature. I am new to writing out PDFs and PDF transformers. I have tried using the PDFStyler, PDFPageFormatter, both Bounding Box transformers, and the sorter so far. I have tried to use the MapFormatter and was hoping if someone could tell me if that would be my best shot at getting the scales fixed. My two questions are: How do I set the scale for each individual PDF to be zoomed in to each point feature? How do I Include the streets and parcels in the background with labels? Than

I am working in an ESRI SDE geodatabase (SQL). I have a table with X/Y coordinates I successfully transformed to a point feature class. SDE is the owner of the feature class. New records have been added to the table but I am getting an error that the new records can not be added to the point feature class.I wonder what parameters I have incorrectly set that the new records are not being translated.

Hi, today I get a little bit of confused by the new Sorter Mode "Natural":Please, can somebody explain me, why the Mode Natural work like this?Thanks!

Hello everyone!My problem:I have a list of points, each point (of course) has coordinates and a timestamp. I would now like to create individual lines from the points and each line should store the two timestamps of the two points it was created from.I've already tried the LineBuilder, but there I get a polyline.  Source:Point a, b, c, d Result LineBuilder:Line 1: from a to b to c to d Result I want:Line 1: from a to b, Attributes: Timestamp_A, Timestamp_BLine 2: from b to c, Attributes: Timestamp_B, Timestamp_CLine 3: from c to d, Attributes: Timestamp_C, Timestamp_D Any ideas?

Hi. I have a geotiff (.tif) and i want extract the cell with value >50 and create a new goetiff with the selection.Can you help me. Thank you

I'm new to FME.I just installed the workbench.I've run Exercise 1 in "FME Desktop Basic Training Manual - Exercise Exploring FME" and the run succeeded.I encountered 2 unexpected phenomenons:1.After the run, I wanted to see the preview, so I cliked on "View Written Data" but instead of seeing some preview, I got error message (with duplicated lines...):File C:\\Program Files\\FME\\metafile\\.fmf could not be openedFile C:\\Program Files\\FME\\metafile\\.fmf could not be openedThis FME edition does not recognize the `' reader. Please ensure that the current platform supports this reader, the reader name is spelled correctly, and that you have installed all required plug-insThis FME edition does not recognize the `' reader. Please ensure that the current platform supports this reader, the reader name is spelled correctly, and that you have installed all required plug-insFailed to open the dataset 'C:\\FMEData2019\\Output\\Training\\LibraryReport.ht

I have filtered out polygons and in several cases when using snapper turned two polygon into a new one which lays on top of the old ones. Attached is a workspace and data and an example is an polygon with "externid" "0331>JULMYRA>1:33>1>>>>1" which there are two of but one is a combination of two polygon (mentioned before+"0331>JULMYRA>1:63>1" and hence covers a larger area, (33k sqm vs 15k sqm). I would like to be able to filter out the duplicates and save the smaller polygons.

As a developer completely new to this topic, with very little understanding of how these files work, what would be best way to create a pipeline that could convert .rvt/.dwg/.dgn files (only interested in 3d data) to cesium 3d tiles?Any learning direction is appreciated as well, since I dont know much about these files, I just have to create a workflow that could solve this issue 

I am trying to list the feature classes in a gdb as well as the fields in each feature class. I would also like to know which fields have a domain and if possible what the domain is. I have managed to do create the list as I want using the FeatureReader and ListExpoder tranformers but I cant figure out how to include the domains. Tried ticking the "Resolve Domains" box in the FeatureReader but it doesnt work. I am writing to excel and would really appreciate some assistance.Thank You!

I have 2 shapefile with route ids.I want to select the unique route id and selct by location another shapefile whose route id is same and then it share the bsegment with first shape file and then invert selection , so that missing edges can be found. The problem here is the 2nd shape file has multiple overklapping lines.

I have a legitimate workspace with rows deleted using sql scripting, (delete from table where field = value).I want to confirm the deletion so I'll be using a simple select statement. For my initial testing:I've set up my SQLExecutor as I would to read from LIVE, ran the statement and have a row returned which is what I'd expect from an unmerged workspace.I've repeated the process, this time plugging in the workspace name. Running the statement with the workspace param returns the same row which is not what I would expect. I then added an Oracle Spatial Reader to replicate the process. Running with no workspace, (LIVE) returns row as I would expect.Running with workspace, returns no row as I would expect. Has anyone else seen this behavior since the bug in 2015? Thank you in advance!

A PDF file contains points located using TEXT elements that indicate the Z coordinate for each point.My question is this: How can I obtain a file (WRITER) in DWG format that contains a cloud of points in coordinates X, Y, Z, from the X and Y coordinates of the insertion point of the text and the Z coordinate obtained from reading the label of that text?Another feasible option would be to obtain a CSV file of numbered points (writer)A second question, which is a continuation of the first:A flat map is available in 2D DWG format, which contains contour lines. Contour lines are labeled dimensions (Z-coordinate) every few intervals.How could we obtain a mathematical model (mesh) from the given contour lines inferred and interpreted as lines of rupture with its dimension (Z coordinate) obtained from the value of the text belonging to the contour of a 2D flat file?The attached file in DWG format, has been obtained by filtering a PDF file obtaining as a result the texts. Now what interests us

We have a .dwg input file that we are trying to convert into Cesium 3D Tiles file, if I open up the input .dwg then it is placed in the correct place on the map, but when I try to use the Visual Preview, and also the output it seems to be in the wrong place. There is not .prj included with the input and I'm not sure what could confuse the two applications. Any ideas?

I'm brand new to FME, and I know this is likely a basic question. I am converting a CAD .dgn to ESRI shape files. I want to take the centroids of several cells (polygon features) and export those to shape file. The documentation tells me  x, y, and z attributes are output but I have no idea how to get them to Esri shape file. http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/centerpointextractor.htm When I put together a workflow, I get no output. What am I doing wrong?

Hi, really odd one, I had to update an existing workbench that has been in place for at least 6 months. When it exports data from a sql server table to excel the featurewriter puts in 0's where there should be nulls. Another featurewriter using the same source but writing to csv behaves itself. Any ideas what could be going on? Some screenshots of the data going in and the design are below. I have not upgraded the writer. This is the same if run from desktop or cloud.  

Get distance between multipoints within a feature in meters. Attached is file with testdata.

"Calculatearea" is the file containing the original data, Test1-3 are the different approaches I have tried shown in the workspace.

I have a problem setting up a WMS background maps in FME from this site. https://kortforsyningen.dk/indhold/webservice-liste. I have tried a few different services but can't get any of them to work. AGOL maps work ok. The layer list is read ok so I assume the token is valid but the background map doesn't show when the workspace is run. Anyone got any suggestions how to fix this?

I would like to do this with the on-board resources of FME. The PDF-Reader can read out the metadata, but can I use the PDF-Writer to overwrite it without changing the rest of the file? An idea:How does the FME read out the metadata? If a library such as exiftool is used for this, then this could also be done using a command line with the SystemCaller.

For example: File 1 has 5 users changing data in the file. So data from File 1 would start updating, one after the other (I assume.) Meanwhile, File 2 has someone changing data at the same time. So those changes would start updating File 1. Is there a possibility of losing data between the files? Is this the best practice to achieve the goal. I am worried about losing data between the updates. Does this make sense?

sql creator load the data always ,but sometimes i do not need this data to load and it takes long time .Could i write function inside sql creator that it should delay till we see if another specific transformer (tester - passed) has data or not .if yes so u should work ,if not so do not load ur data . How couldi achieve that ? Thanks in advance .FME 2018

Hello again, apologies for the questions, i am fairly new to FME and this one is baffling me. To me, this is a fundamental question, but through much research, I haven't found a solution as yet. I try to research before I post in forums.  IS there any way to write a bearing of my 3D Object on writing out to KML ?  Maybe I should rephrase this as I CAN actually rotate the object. What I would like to do as an option, is somehow have this parameter/attribute in the KML file so that when you click on the properties of the KML, you can input the Angle/HEading/Bearing at this point.  The ultimate goal would be to get all bearings from a CSV / External Data source, along with the model type to be used, and on writing to KML would have the correct model at the correct bearing. This is a big one actually and fundamental to a particular use case I'm looking at. 

Hello, I'm trying to extract a number out of my comments column. I'm not sure how to write the expression? or if I'm using the right transformer? I'm still new with FME. The number I am trying to extract is 8 digits and is put in comment field with this format "/ 12345678 /" an example of the format is below. VB BLVD / 59208085 / L06-514 / ATT 8547 Is there a way to extract this number?  Thank you!

How in FME would you check that two floats are "close", given testing floats for equality can be a challenge? e.g. "-23.123" as listed in an XLS compared to "-23.12300005" stored in a point feature class? In Python I use the math.isClose() or assertAlmostEqual() Thanks 

Has anyone experienced SMTP email simply not being sent using either the Emailer Transformer or the FME Server Automation Email External Action? I've had each of these things happen to me once, but the same Workspace or Automation run in most instances does send the email. The log file from a sent and not-sent email looks almost identical to me, I've attached both. These are workspace runs with the Emailer Transformer sending the email. I've asked our IT department if they can look into anything, but they can't say much since SMTP is just a relay. Also the fact that it works correctly most of the time makes it difficult to troubleshoot much further.Any thoughts or things to look into would be helpful.Thanks!