Transformers

Hi  Is there an easy way to add a custom transformation with Helmert-parameters to features in FME? Ie A0,A1,B0,B1 - parameters? I have looked through MyCoordSysDefs.fme and articles describing this however it would be nice if there was a Transformer that you could use for this.

I have"year installed" values (1999, 2011, ...) in a CHARACTER field. I need to get that data into a "date installed" DATE field. Best would be YYYY only in the date field, but I could work with YYYY/D/M if necessary. Is that possible?

Hi, I have extracted the list in JSON file to an excel file using ListExploder. However the result didn't come out as expected: Any suggestions on which transformer can I use to get the expected result as attached: Thank you in advance.

Running FME desktop workspaces seems to cause errors in the path locations for custom transformers when located outside of the root transformer folder.

Image attached

HiI am running a workbench to update a single field in an existing table. I have the following settings: Feature operation: UpdateTable handling: ExistingMatch Columns: Set to two fields that identify the record to update I have an attribute manager before the writer to only show the field I want to update and the match columns. Therefore, those three columns in the writer have the green indicator and the rest are red as they are not connected. My question is, will this writer write to the match columns too? I know by definition of them being match columns, it will only overwrite with the same value, but I would prefer it to leave them alone altogether. Is this possible, perhaps if I remove the match columns in the User Attributes tab, is there another way, or should I just trust it and leave it as it is? Many thanks

HiI need to add a field to a SQL table as the schema has changed. However, all the instructions indicate I need to drop the table. As there is data in there already, I cannot do this. Is there a way to add the column in FME, or should I just go into SQL Server Management Studio?

The most recent info I have been able to find is from 2017, do later builds have a solution? The methods I have seen so far:Call 7 ZIP and extract the archiveConvert to htmluse a pythoncallerPythoncaller is probably the simplest solution, but I would like to try and achieve this using native FME if I can, as this is a training exercise in the software. https://community.safe.com/s/question/0D54Q000080hDL7SAM/read-microsoft-word-file

Hey community!How can I fusion differents DEM togheter?I need to merge a DEM for trees with other DEM

Dear FME Community, I would like to create a mesh from a xyz-pointcloud. Does anybody know what settings I could use so that it looks nice and just like the original point cloud? Any help would be greatly appreciated! With kind regardsChristian Lendl   These are my settings at the moment. The mesh looks like there is a hill, but in the original point-cloud there is no hill...   here you can see the preview I get from the original point cloud. There is not much elevation in the back.

Hello,I have consecutive Oracle LRS geometric segments in several locations that I would like to concatenate (see attached or the description below). First LRS Geometric Segment : from distance a1 to distance b1 Second LRS geometric Segement: from distance a2 to distance b2 with a2=b1 Third LRS geometric segment: from distance a3 to distance b3 with a3 = b2 ...Nth LRS geometric segment from distance an to bn with an= bn-1 I'm able to write a query to merge all the N geometric segments and to compute the distance from (a1) and the distance to (bn). How can I create the corresponding LRS geometry which will be the concatenation of all the touching geometry segments in the right order? 

HiIs there a way to have the AttributeRangeFilter create the Output port names in a new attribute that's called like '_attrRangeFilterOut' and the values being whatever the name of the output port is? So instead of having the AttributeRangeFilter followed by a bunch of AttributeCreators which basically sets the new attribute 'range' to the value that's similar to the output ports of the AttributeRangeFilter, is there a way to just have the AttributeRangeFilter do that for us?

Hi FME Community,I've recently been given quite a big task of migrating, renaming and sorting documents. I have naied the moving and renaming part by using a mix of FME and SystemCaller for Robocopy (as FME would output the PDF files as folders, for some reason). So, the moving is all good, but is there a way I can use FME (as I am quite constrained by my working environment, such as python being stock and FME version) to say - "if a file exists in folder A, but also exists in subfolder X, delete the file in folder A" I've tried with a DuplicateFilter, which gets a few, but misses others (attached screenshot). Been going mad with this one

Dear FME community,I'm trying to run the CsmapReprojector transformer to modify the vertical reference and projection system of a LAS dataset.The change of projection system seems to works well, but the change of vertical reference does not. I use a .grd file that I made with a workspace to transform an Ascii Point Cloud to a grd format that would be more suitable to transform it from the https://community.safe.com/s/article/creating-vertical-adjustment-grid-files-for-use-wi help.I can provide this .grd file if necessary (as well as .las test).Do you know if this transform works in a particular way?Thanks in advance and have a nice day.Julian. 

Can somebody explain the process of how to add a Coordiante system to the FME Coordinate System Gallery. I have the .prj of the new one I would like to add, I do not know how to edit the "MyCoordSysDefs.fme" file in order to implement this.   

We are working with simple workflow of reading in data from a SQL Spatial Table reader, setting null attributes to missing , and writing out to fGDB/eGDB/Spatial table. Our end goal is to remove the fields that are empty but there are occasions when these fields may have values. When writing out the features after mapping all null to missing, the fields that are entirely missing still write out when writing to a fGDB/eGDB/Spatial table (they appear as null in the featureclass).  We are unsure if there is a way around this or if it's a limitation of the GDB format.  My only idea of bypassing this is writing out to another format that would remove the field (like JSON) and then reading back in using feature writer and feature reader. This is a poor solution so any other ideas are appreciated. 

I have a workspace where I am reading spatial data from an Enterprise geodatabase, modifying only a single attribute and updating that attribute using a feature writer. I'm reading the data dynamically and want to write it dynamically too. The data consists of points, lines, and polygons. My question is, when updating only a single field, and not spatial data, does the writer ignore the geometry type? Or do I have to split my data up into point, line and polygon before it hits the writer and specify the correct geometry for each type? 

Hello,I have an original table and api result  that I monitor with a ChangeDetector. I created changes {} and do a ListExploder to return each record and write to a DIM table. Now I want to add the dates ValidTo and ValidFrom to the DIM so I can keep a history of those records.Short said, which each Update output from ChangeDetector I need to create a new record and change the dates (in the previous with the same id)  ID     AttrColumn     ValueColumn1       AttrValue1          12       AttrValue2          2DIM_id      AttrChanged     ValidFrom    ValidTo            Active1                  ValueColumn   2021-02-01  2021-02-12     N1                  ValueColumn   2021-02-12  DefaultValue  YHope it's clear..Any ideas?Thanks!  

Hi. I have a FGDB (esri) with coded value. I've tester for field (HorizontalAccuracy). This field must be in some value (Low, High, Medium).I use in for operator but it doesn't work. I've try so with coded value. Can you help me please, I use FME 2018, i don't have cachedvalue :(

I am working with street network data (in Esri format) that has attributes for address ranging. I am going to be splitting the streets everywhere they intersect a crosswalk feature and I would like the address ranging to then be split between the resulting features proportionally instead of being duplicated to both from the original. I've attached a beautifully done MS Paint illustration. Essentially, segments currently have 4 attributes: Left_Address_FROM, Left_Address_TO, Right_Address_FROM, and Right_Address_TO. Right and left are determined based on the direction the segment is drawn.  In the illustration the original segment has attributes:Left_Address_FROM = 1Left_Address_TO = 199Right_Address_FROM = 2Right_Address_TO = 200 If I split the segment at the midpoint, I would need the attributes on the new segments to be:Segment 1 - Left_Address_FROM = 1Segment 1 - Left_Address_TO = 99Segment 1 - Right_Address_FROM = 2Segment 1 - Right_Address_TO = 100Segment 2 - Left_Address_FROM

I am using several ListConcatenator transformers in my workspace. I want to give them unique names, however, when I rename them and run the workbench, it fails and gives me an error. When renaming my transformers, I normally use an abbreviation for the transformer name followed by a colon ":" then some unique name. For some reason the ListConcatenator doesn't work when a colon ":" is in the transformer name.Example: I rename the ListConcatenator transformer to "LC: RunwayNameList" and it throws this error:2020-03-02 08:32:52| 2.2| 0.0|ERROR |@Tcl2 -- failed to evaluate expression `set LC:_RunwayNameList__separator [FME_DecodeText {<comma>}]; regsub -all "{}" [FME_DecodeText {_listAll<opencurly><closecurly>.RUNWAYNAME}] [FME_DecodeText {<opencurly><backslash>d+<closecurly>}] LC:_RunwayNameList__listPattern; set LC:_RunwayNameList__listPattern ^$LC:_RunwayNameList__listPattern$;' -- can't read "L

Is there a specific case, or exercise, about the transformation from DWG to PostGIS that contains data sets?

Hi I have a list of urls and want to download files from each of them. I am using the http caller and extractor to find links to pdf files on a webpage and then another http caller to download the file. The fist part works fine and when I inspect it I can see the urls to the pdf files. However, the second part does not work. FME rejects the features saying the url doesnt exist. I have tried it directly in a browser and it is entirely correct, the url doesnt exist. It only appears to exist whilst the original page is open. Is there a way to keep that page 'open' until the files have been downloaded and the it moves on to the next record? Many thanks

I am using the NullAttributeMapper to set my null values as missing (reading from MSSQL spatial table). This is working, however only for a certain number of rows. The first time run, it changed the first 100 rows. Second time 200 rows, after a few more attempts top 2000 rows. It seems to be processing in 100 row chunks and stopping at random points?  The parameters are very simple;Map: All AttributesIf attribute value is: Null EmptyMap to: Missing That's it.  I have had no other issues of partial completion for any other transformers.  Thanks!

Hi. I have a featureJoiner with 2 tables, from FGDB Esri files. I have to make a query on 1 table. I Can't make the query directly in table because i have other featurejoiner from this table. I hope it's clear. Than for your help. I