Transformers

How to install NTv2 grid files? Following the instructions at http://docs.safe.com/fme/2019.0/html/FME_Desktop_Documentation/FME_Workbench/Workbench/options_coordinate_systems.htm I've copied the `NTV2_0.GSB` file I acquired from NRCAN into "C:\\Program Files\\FME\\Reproject\\GridData\\NTv2".From FME Options I select Coordinate Systems. Now what? Which of the listed items do I edit? I tried NAD83_to_CSRS. I'm able to use the down arrow to select the NTV2_0.GSB file from previous step, but the [OK] button remains disabled.

Not so much a question as bringing together a few things...I'm using a Workspace Runner to call a Workspace which writes to an ESRI File Geodatabase (FGDB). In testing, I had the FGDB Feature Class open in ArcCatalog which caused the translation to fail because the target was locked. Also, the Workspace Runner was reporting success, even though the Workspace it was calling failed.There are two things here. Firstly, "Wait for job to complete" was set to "No" which meant that the Workspace Runner would report a success even if the Workspace it called failed. "No" enables you to run concurrent Workspaces which is something I did not want to do because I need to process a series of input datasets in order, not in parallel. The solution is to set "Wait for job to complete" to "Yes":http://docs.safe.com/fme/2016.1/html/FME_Desktop_Documentation/FME_Transformers/Transformers/workspacerunner.htmSecondly, the locking issue can often be

I have a workspace that kicks of a PowerShell script via a PythonCaller that kicks off another script under the context of another user. This works perfectly on my desktop but once uploaded to FME Server the second PowerShell script fails to execute. The issue arises somewhere after Start-Process begins executing. The log file to which I am redirecting output is wiped out after I write to it when I create it. This is the first thing Start-Process does when RedirectStandardError parameter is used. The problem is my second log is never created which is the first step in my second script. However, no error is produced not in the FME job log or Windows Log on the server. Has anyone tried to use Start-Process on FME Server? Are there configuration steps required by FME Server? PythonCallerclass FeatureProcessor(object): def __init__(self): self.scriptOutput = str('') process = subprocess.Popen(["powershell.exe",  "\\\\fileshare\\scripts\\RunAsSvcAcct.ps1"],  stdout=subprocess.PIPE) self.scr

We have FME Server 2018 on premise (Express Installation). I am trying out the Data Streaming FME Server web service to make a .json file available to out web developer to build an app. I am having trouble getting the Data Streaming service to work. After publishing to FME Server with the Data Streaming service enabled, I can run the job and it downloads the .json file as a file download to my browser. However, I want to be able to provide a url to the web developer to be able to query by feature id, etc. for that .json data that was output. Can someone please help me to understand how to make this happen? Thank you!

I could use help getting FME 2019.0 properly set to transform data from Canadian vertical datum 1928 to 2013.My starting points are https://knowledge.safe.com/questions/99317/adding-vertical-coordinate-systems-to-fme.html and https://knowledge.safe.com/articles/29325/creating-vertical-adjustment-grid-files-for-use-wi.html.From Safe I have downloaded and installed the extra Reprojection Grid Files.From NRCAN I have downloaded the 8 archives from Geoid Models, and unpacked to `C:\local\geo_grid_shift_files`.I see 8 .byn files:# CGVD2013 CGG2013ai08.byn         CGG2013an83.byn# CGVD28 HT2_1997.byn             HT2_2002v70.byn HT2_2010v70.byn# 1928 to 2013 conversion HT2_1997_CGG2013a.byn HT2_2002v70_CGG2013a.byn HT2_2010v70_CGG2013a.byn3 of these are already present in FME Reproject folder treeCGG2013a - CSRS and ITRF versions (CGG2013n83 & CGG2013i08 respectively) HT2_1997 - FME has it, though using the old name of HT2_0 according to a note on GPS-H page (ref). I understand the next s

i want a way to get the wrong coordinates (example : easting 3628623.38(7) digits and northing 4565105.96(7) digits to be comes as rejected output and the others which needs to b swap between x column and y column

I’m trying to convert a SWG (CAD) file to import it into Blender. When I run the program, in FME, nothing actually saves to the target folder, even though it says that it has been saved. How would I go about doing this?

Hi all,I have a question about the PDFpageformatter. I generated a point using a creator (with coordinates 0 0) and used a textadder to add text to this point. The text is automatically put top right of the point. Then I use a PDFstyler to give color to the text and put this into an PDFpageformatter. In the PDFpageformatter I created a box where I want to put this text. When writing it to a PDF it seems that the text is written in the bottom on the left side. But it would be more beneficial for writing a letter if the text would start in top left. Is there a way to make sure that the PDFpageformatter will start writing text in the top left corner? 

Hello thereis there a way we could extract the mapping relation between reader and writer of a workspaceI mean, attribute name: parcels in a reader is connected to attribute name: Parcel in the writerwe need to get a report concerning those relations between writer and readerexample

Hi guys,I am using FME2019 and received this in the log:Starting translation...Undefined macro `ChangeDetector_OUTPUT_UNCHANGED_MACRO' dereferenced in file `C:\\temp\\wb-xlate-1538456617178_5428'Program TerminatingTranslation FAILED.I can run a Matcher transformer with the same inputs and outputs but when I use the ChangeDetector transformer on the same inputs and outputs the error comes.Any ideas on what the issue might be?Cheers, Dave.

i need to extract the coordinate which are wrong and does not make sense like easting in utm should be 6 digits .because i have some coordinates in x column for example (easting = 7 digits 3628623.384 ) which is wrong it should be 6 digits. is there any way i can calculate the digits in coodinates column before the decimal point

Dear FME members,For a WebApp Viewer, I'm having the following question:How can you upload a GEOTIFF to a SQL Server Spatial, and add a new GEOTIFF to the same SQL Server Spatial file every time you run the model? Current situation: In my model (see attached file), it is possible to upload a GEOTIFF to a SQL Server Spatial file, but only once. After running the model, the GeoTIFF becomes visible in the WebApp Viewer.Next step: adding another GEOTIFF to the same SQL Server Spatial file (raster or mosaic, what works best).Now, when I select another GEOTIFF in the reader and rerun the model, there is an error saying "layer already exists."So in the ideal situation, I select another GEOTIFF, which is added to the existing SQL Server Spatial file. Now, we tried raster and mosaic. So in the end, I would like to have one SQL Server Spatial file, with all the GEOTIFF files. If there will be a new file in the future, I would like to simply add it in the same file, without adaptin

Hi everyone,Does anyone know why my query is not working?I have a SQLite database and I want to find the closest point in the database to a point. Thanks in advance!

Hi there. I'm looking to add grid locations (GRID_ID) from a polygon feature class to a line feature class dataset in fme, but it does not seem to recognize the start and end of these lines, thus leaving the GRID_ID's the same. There is a lot of transformers and things going on in this workspace, but the two bookmarks are essentially duplicates, just different grid polygon datasets used.

I have an input table that looks like this(input table):Important here is that this table can change in terms of number of rows and names. So the next time the model runs it could have 5 points or 10 or 1, with random names. Names are never duplicated. Based on the input table my fme model then creates an output table as this(table2):I want to create a new table based on the same parameters, with a schema like this(table3): So each row in table3 is a unique date form "DateProcessed" and each value from the coulumn "Name" from input table will get an own column in table3, containing the corresponding DistanceToIce value. The tricky part here is that I want this to happen dynamicly, so that the number of columns that will be created in table3, and their names will follow the input table.  The data will never get large, maximum 10-20 points/names and 14 dates. So recreating Table3 from scratch each time the model runs would be fine. Have read a couple of other answers

Hi, I have some problems to write some georeferenced data to a SKP-file.I have read a lot of the questions regarding the problem with coordinates and Sketchup. My data is a KMZ-file which i convert to a SKP-file i FME. Make som changes and the export i back to KMZ from Skethup.  What i´ve understand, the "Move to Local Coordinate System: Yes" should move the origin to the center of the data. However, when I look at the data in Skethup the axis is at the edge of the dataset. And to confirm the lat/long under "Model Info"-"Geo Location" is the exakt point of the axis. So for some reason the origin isn't in the center of the data.: When I export the data from Skethup to a KMZ, the data have moved a few meters and isn´t i the right place anymore. So one of my thougts is because that the origin isn´t in the center, that might have something to do with it.  Is there any explanation to why the origin isn´t set in the center of the data (why it happens)? And c

I used basic steps to add new Annotation FCL as target feature in FME Workbench:In ArcGIS Pro 2.3Create FGDB Add only one new Annotation FCL with only system attributesIn FME 2019.1.3.1Add new FFS Reader with reference to FGDB (GEODATABASE_FILE)Import feature class from datasetFrom the table list, chose newly created annotation feature classConfirm Import on OKCRASH!In Windows 10 Event Viewer I see following messages for each crashDoes anybode have an idea what can cause such problem?

Hi guys, I have the following attributes:783784AYHI would like to add 1 in front of any attribute starting with 7 and avoid adding to another field. What would be the best transformer to use for this? I have tried and tested the stringpadder but can't seem to get it working. Any help would be great.

Hi I tried Change Detector & Update Detector to compare records in 2 tables based on a unique key. Lets say input tables have 10 attributes in unchanged port output of change detection I get few records but attribute value of all except the unique key specified for comaprison is NULL. Is there anyway I can get attribute values in unchanged port as well As I need to do further processing based on these attribute values of Unchanged records.

Hello all,I have a TestFilter that directs my input data into multiple branches for further transformation and I have dozens of test conditions within this TestFilter, similar to below:If Test condition @Value(field1) = A to Output port 'Road'Else If Test condition @Value(field1) = B to Output port 'River'Else If Test condition @Value(field1) = C to Output port 'School'etc, etc..... Is there a way i can then use these port values to replace the original input attribute value for this field? For example: Replace all attribute values of 'A' with 'Road'Replace all attribute values of 'B' with 'River'etc, etcI'm trying to find a way of avoiding having to create dozens of repetitive transformers after each port to make this attribute value change and hoping to reuse the effort made thus far with in creating the existing TestFilterDoes anyone know if this is achievable?TIA,R

For a customer, I am upgrading a FME 2015 Workflow to FME 2019. At some point, an FFS file with measures is written. In a later stage, it is read with a FeatureReader. It still contains the Measures, 0 for the starting point, 100 for the ending point. After passing through the Rubbersheeter, they are lost. The customer still has older versions available. It still works in the 2016 and 2017 versions. From FME 2018.1 (I do not have the 2018.0 version) onwards, the rubbersheeter does not output the measures. However, it is not possible to upgrade the transformer. It still has the same name. In the 2019.0 version, you can upgrade (adding the group by possibility), but the measures behaviour is still the same. Anyone else having this problem?

When I use the PointOnAreaOverlayer and the LineOnAreaOverlayer on FME Desktop 2019.1, the resulting _overlaps appear correct.When I set the 'Group by' option to group by an attribute on the either the PointOnAreaOverlayer or the LineOnAreaOverlayer, the resulting _overlaps is set to 0 for all features. @steveatsafe

Hello,I am trying to geocode some addresses. The input is excel. But I don't want to use available geocoder services. Instead, we have our own geocoding API key. Is it possible to use it through any of the transformers?

I'm sure the transformer is somewhere, but I simply cannot find a transformer that would accept stream of features with attributesvalue to calculate..and it would calculate this value into the designated field.  Example: I have a statistic calculator that I need a _max value from. I want to feed this value to all the records in the stream into a field _max. I will then use the counter to assign the ids.How can I achieve that?Thank you  

As stated in the title,I want to compare two schemas to see if they have duplicate field names.My idea is to use the Change Detector, but i do not know how to expose field names from an reader Any thoughts?