Transformers

I am using Esri Geodatabase (File Geodb Open API) Reader to read a gdb file where some attributes are mapped to domains. If gdb contains any value not matching with domain, then reader is reading it as null.  For example: gdb has one column Citizen with domain value - 'Yes', 'No'. If any row contains 'yes' then reader is reading it as NULL because its not matching exactly with defined domain value. I am using FME(R) 2020.2.5.0 (20210510 - Build 20827 - WIN64)

Hi everybody I'm using FME to merge several different spatial feature classes to create a new one. The user of this product is one of our partners in the office who doesn't have the possibility to view the data with a GIS-system. Therefore the output should in form of an excel. At the end of the workspace I use two writer: one for the excel and one for the GDB. When I compare the two results regarding the total area of the features, only the GDB one is correct. It is important that the area-values in the Excel are correct because they are used the analyze the other attribute using Pivot-tables and so on... Thanks in advance for you help :-) 

Hell FME Community, i am trying to write the data into existing Oracle Spatial Point Cloud table. However, the translation fails with the following error: "ORACLE Writer: writing the point cloud failed because it has 3 extent dimensions, but the table 'AHN_BLCK' column 'BLK_EXTENT' contains data with 0 extent dimensions. The number of dimensions must match for all point clouds in a table."The "BLK_EXTENT" column has the SDO_GEOMETRY data type.Does anyone have any ideas? Best regards

Hi, I have two lines I would line to join together. However they do not intersect with each other so I can't use the line combiner. The lines are 3D and I want to preserve the dimensions so a neighbour finder might not work because that is 2D They are lines along the centre of a rail line but there is a small gap (see picture). I would like to join it so that it forms one line. The direction of the lines is the same. If anyone has any ideas how I could do this I would be very appreciative Thanks

An example would be a spreadsheet with 2 columns such asNeighborhood activityA RepairB InstallA RepairB Remove Ideally, I could get output grouped by Neighborhood (A and B) and show the Activity values as column headers such as Neighborhood Activity.Total.Count Repair.count Install.count Remove.countA 2 (activities total) 2 (repairs) 0 (installs) 0 (removes)B 2(activities total) 0 (repairs) 1 (installs) 1 (removes) Should I expect to be able to do this with FME Statistics Calculator? If I need to use a parameter, I don't know how.. Any guidance would help.thanksJim

I would like to extract things like concrete driveways, road surfaces, any other hard surfaces, to calculate areas. The Rasters I have, are taken several years apart and would like to calculate the change in surface areas.

I'm trying to get the last 8 Job ID workspace details and I'm using an HTTP caller and string searcher. Can anyone tell me where I'm going wrong? Httpcaller Setting String Searcher

Hi All,I have a polygon that I want to split by a line feature. I'm rather surprised to find out that there don't seem to be any tools that do this, or at least, none I've found yet. There are a lot of questions about this, but no consistent answers, or simple way of doing it.Clipper - The Clipper feature needs to be an Area. Mine is a line.LineOnAreaOverlayer - splits the line, not the area. :-/Intersector - output is lines that don't reflect input areas nicely.So, have I missed something? Is there a transformer for doing this? This is GIS 101 level geometry handling, so I'd be surprised if there isn't, but where is it hiding?Thanks

Hello. You don't know which transformer to use. I tried testfilter, but there you can't combine two lines and featuremerger, it's also not quite ideal. I need to filter data in a database with a condition:- all data with the same uuid- a point that has the same value of validfrom and validtovalidto changes to a value of -1 second downThe result should be validfrom 20220908000000 and validto 20221005235959 in the first lineIn the second line validfrom 20221006000000 and validto 99991231235959Thank you very much.

The workbench below is incomplete. It aims at checking schema of a requested GeoJON before writting data to GDB.I would like the writer to proceed only if 'Updated', 'Inserted' and 'Deteled' ports of ChangeDetector does not output anything. In other words, I would like the workbench to terminate before writing if those ports are not empty.How could I achieve that please ?

Is there a possibilty to directly read the "styling" properties of a DWG layer in FME? By styling properties I mean e.g. the color, linetype, and lineweight. I know that with the FeatureReader transformer, I can read the so-called "Schema Features". These Schema Features correspond to the layers in the DWG file (also see accepted solution at https://community.safe.com/s/question/0D5Dm000006a48rKAA/read-all-layer-names-from-dwg-files). Unfortunately, at least with standard reader options, these Schema Features do not have any styling properties associated with them: As a workaround, I could read the Data Features of the DWG file with e.g. a standard Rea

Hi;I have FME Desktop 2023.0 BETA (FME(R) 2023.0.0.0 (20230130 - Build 23226 - WIN64))The FME workbench consists of Sql reader, Geometry Replacer, and Dwg Writer.Sql reader reads a simple view from the database. Among others, the field 'autocad_entity' with the value 'autocad_insert' and the field 'autocad_block_name' with the value 'kc'. (I use those fields or fme attributes to create blocks through dwg writer). Reader reads everything correctly. After the reader comes the Geometry Replacer, which works correctly. However, after the Geometry Replacer, the 'autocad_entity' attribute has the value 'missing'. All other attributes are ok. Attributes are read from the database as varchar datatype.Thanks;

 I got the mean and standard deviation of all dataset ( mean: 0.12, sd: 2.84). And also, I got mean and standard deviation of ten sample (mean: 0.10, sd: 0.10)

Hi,I have hourly rainfall data (observed and forecast) and i'd like to calculate a 7 day preceding rainfall total for EACH HOUR. My first thought is to use AttributeManager and adjacent features to sum the preceding 166 features (hourly rainfall totals), but it only allows up to 100 adjacent features. Any help would be greatly appreciated!Thanks.

Surface Model could not find 3 non NAN seed points I am trying to convert a .Tiff DEM to Minecraft format. Once it reaches the Surface Draper transformers the translation fails and I get the above error message.

Hello. Does anyone know how to use a transformer to change the time? I originally solved it by parsing the data via a string searcher, creating attributes and then compiling. This solution worked. It does not work for this date 20221201000000 (year, month, day, time 2022/12/01/000000 ), where I set the desired -1 second. I get 20221200999999 (2022/12/00/999999) in the output, but it should be 20221130235959 (2022/11/30/235959 ). I need a transformer that doesn't stupidly subtract -1 unit, but works with data like time. Thank you

Hi All,I need to identify exact attribute values changes when comparing two sets of data. The datasets have the same attributes but some attribute values are updated overtime and I need to identify which ones. I have been trying workflows with feature joiner and ChangeDetector, but I have to compare the datasets several times, discard attributes that remain the same until I identify which attribute value changed. I would like to find a more efficient way to identify the updates, any suggestion? Thank you

Hi everyone,  I am using FME 2013 for comparing geometry and attribute changes between two Shape files, one being more recent than the other. The two Shape files have exactly the same type of geometry and schema (same attributes names and definitions). They also have a lot of attributes (more than 50 I think). I have set up a logic for reporting significant differences in geometry as well as records having at least one attribute value not matching with the corresponding one in the other set. The attribute matching part can be achieved rather easily with a ChangeDetector, Matcher or CRCCalculator. These transformers will report features containing at least one attribute change among those that have been selected in the transformer properties. Given the great number of attributes I would like to to identify which specific attribute(s) has(have) indeed been modified between the two sets. I don't see an option using the standard transformers mentioned above. I did

I have an attribute that contains location information (text-based) but it will say something like “Lake View, Chicago, USA”. I want to create a column that just tells me “USA”. Note, the data isn’t regular, sometimes there are many locality details, sometimes just a country, and sometimes no country. How do I just pull out the countries?

If I reproject geographic information from geographic coordinates to projected coordinates, and before I convert to geographic coordinates again, the final information has a little displacement regard the original information. I don´t have any other process in between. The displacement is very tiny, but I need to know why is it produced. I´ve make the same process in Arcgis and it doesn´t appear this displacement. I can see the displacement in QGIS because this application allows to make a very big zoom to the information. I think that ArcGis doesn´t allow to make such a very big zoom.

If I remove the template file and write straight to Excel it is successful; with the template, FME crashes at exactly 32,715 records entering the Excel writer. I've tried a different template and a brand new template, but it fails at the same point. To confirm, the workbenches ran perfectly fine on v2018 and indeed it still does. (I have 2018 for the next couple of weeks crossover before it is being removed in favour of the 2021.2 version).  I have looked on the 'known issues with 2021' online, but don't see this issue there (though it notes not all known issues are listed)

I want convert a pure table GDB file(without geometry infomation) to DBase format.It show me success and the result can be read by FME reader.But It can't be read by any open source dbf reader included "dbf view of Microsoft" and "qgis".I studied the document of .dbf from wiki and found that the schema definition of your dbase file is difference from document.You use "I" for integer, But document is "N"Is any way can I solve this problem?Please check the definition of data type in documentThis is hex view of your .dbf file   

I have a workbench that transforms feature classes within the same sde to topojson files for each feature class. Currently I have the same feature in two feature classes that I am writing to topojson. However, the output topojson files are different for this feature. The topojson files are used in Power BI custom maps. One file does exactly what it should while the other doesn't. The issue is with that particular feature that is located in both readers and writers. I checked the number of vertices for this feature in both feature classes and they are the same (3045 - it is a large coastal feature). The output topojson contains different vertices count than the feature classes that is likely expected. But both output topojson files have different vertices count for the same feature: 3431 (topojson file that is not performing as it should within Power BI) and 3421 (topojson file that performs as it should in Power BI). I processed the feature class that produces the

Hello,I want write these in an OGC GML : <fme:AffleurantPCRS gml:id="id0ed4a56f-dd55-473e-a7f2-9ae5bcbf3af2"><fme:producteur>Producteur</fme:producteur><fme:symbolisation><fme:AffleurantSymbolePCRS><fme:angleRotation>142.70918</fme:angleRotation><fme:idSym>ID16da9e5d-ef01-4922-8cf3-a4058f4a888a</fme:idSym><gml:pointProperty>            <gml:Point srsName="EPSG:2154" srsDimension="2">               <gml:pos>619127.353 6753771.724</gml:pos>            </gml:Point></gml:pointProperty></fme:AffleurantSymbolePCRS></fme:symbolisation></fme:AffleurantPCRS> My geometry is in AffleurantSymbolePCRS/symbolisation/AffleurantSymbolePCRS

What would be the best solution for triggering a FME workflow or FME transfomation file instantaneous, when a xlsx file is uploaded/created in an Amazon S3 bucket?