Transformers

Hello, I have a feature class from an geodatabase that contains larger and smaller features that overlap one another. I sort these features to have the larger features come before the smaller features. The attributes of the feature class are: Id and date The goal is to union the smaller and larger overlapping features, but only keep the attributes of the larger overlapping features. Since there is one feature class the overlapping areas share the same attribute names.  Therefore, I use the AreaOnAreaOverlayer transformer, with accumulation mode set to Use Attributes From One Feature.  However, I am unsure of the behavior of Use Attributes From One Feature accumulation mode. Which attributes are copied over to the resultant feature when the overlapping features are unioned? The document mentions the following for the Use Attributes From One Feature accumulation mode: "Takes all attributes from one representative feature" How does the AreaOnAreaOverlayer determine which of the

 Workflow description·        FMEServerJobSubmitter Version 3 in Desktop starts a sub-script with for instance published parameter /GeoBIM/Konfiguration styrfil·        If I run the script FME Server runs the script with parameter /GeoBIM/Konfiguration, styrfil So as you can see there has been input a comma sign which is not correct·        And furthermore - if I try to change the FMEServerJobSubmitter Version 3 published parameter the transformer automatically (without me telling it to update) updates itself to FMEServerJobSubmitter Version 4 leading to:·        When I then try to run the script with FMEServerJobSubmitter Version 4 it ends up in Rejected with error ERROR_INVALID_INPUT_PARAMETERS and Reason - invalid input parameters for workspace X'Hence I will now create a library with FMEServerJobSubmitter Version 3 preset transformers in version 2021.2.4 (where editing parameters works fine) so that I can copy these into our scripts in 2022.2 to make this work I'm surprised

I'm not sure what I'm doing wrong, but I'm trying to move data from a editing GDB environment to a production GDB. Everything else works fine, except when it comes to importing the relationship class for my attachments. I get the error:  "Unable to create table/feature class/relationship class of type 'geodb_invalid'. Creation of this type is not currently supported by FME, and must be done through Esri tools" Does this mean I can't import the relationship in FME and should be doing it in ArcGIS Pro? Thank you.

Line:01020000A0E610000005000000E040A17B843554C0C987F51E7593414000000000000000006CDB4900853554C0AFD3A0F17893414000000000000000002D2683FB813554C0D677B1BD8E93414000000000000000005A484B8E7F3554C025457646AB9341400000000000000000C4B449797B3554C01A0A32C8AC9341400000000000000000 Using SQL the wkt converts to these 5 points:  -80.83621111628918 35.15201174725332 0,-80.83624274456605 35.15212841370464 0,-80.83605850036174 35.1527936092895 0,-80.83591039039439 35.15366440558345 0,-80.83566124151099 35.15371038859685 0 Lat and long are also reversed in the output. I would like to do this conversion in FME for spatial analysis of the full data base. Thank you,Matt 

I have this equation in Excel:=A2-($A$2-$G$2)*B4/SUM($B$4:$F$4)this A2 and B4 has to change every row. so that the value I just got from the current row calculation needs to be used in the next step.9.83,8.82,7.56,6.41,5.41,5minus0,1.01,1.26,1.14,0.99,0.4it starts with 9.83-0, then 9.83-1.01, then the result which is 8.81-1.26 and so on.how can I write this equation? or how can I get the result of previous row calculation in the current row?

Hi community, A client I am working for recently upgraded their FME Desktop/Server installation from version 2018.1 (20180717 - Build 18520) to 2021.1 (20210730 - Build 21619). I upgraded the workspaces and I am currently in the process of testing. I noticed that a workspace ("gdb2gml.fmw", attached to this thread) behaves differently in FME Desktop 2021.1. The purpose of this workspace is to read a File Geodatabase, map the attributes to a specific format and write to a GML. The output file (GML) is validated against an XSD file (XSD-file and input GDB also attached to this thread).  The validation in the GML writer should fail. The File Geodatabase contains an illegal feature (a multipart polygon) which is not allowed as a geometry for this feature class. In the GML writer, the setting 'validate output file' is set to Yes. In FME Desktop 2018, this multipart feature is detected by the validation and the workspace fails. This is the expected behaviour. In FME Deskt

With FME upgrade to 2021.2.0.1 my workbenches are failing . I have used aggregator and geometry Validator . Also it gives application error if I try to run it from Command prompt.

Greetings,What is the best way to duplicate a writer? Using copy/paste only duplicates the annotation. Thank you. TylerFME 2022.1

How do I convert .osm data into shapefile using FME?

Converted ArcGIS Pro Annotation (geodb_pro_annotation) to Standard Annotation (geodb_annotation) with the help of Dynamic File Geodatabase reader and Dynamic File Geodatabase writer. Enclosed the developed FME workspace template for your reference. However, when opened the generated output Standard Annotation (geodb_annotation) feature class in ArcMap (version 10.8.1), getting an error saying "One or more layers failed to draw". Please refer to enclosed screenshot from ArcMap and help to advice how to handle this situation.  Found no issues with the output when used Static File Geodatabase reader. However in our case, need to use the Dynamic File Geodatabase reader only. Thank you..! Note: Enclosed FME workspace created using FME(R) 2022.1.0.0 (20220704 - Build 22618 - WIN64)

I have made a workbench that contains an Emailer. I did not notice this directly, but the Emailer is a Package. I saved the workbench to a network location so my colleagues can run the workbench as well. And wrapped it in a Workspace Runner workbench so the workbench is not open for editing when colleagues run the workbench. But since this year I notice that the WorkspaceRunner fails because the Emailer package is not installed. This Emailer is installed as soon as the Workbench containing the Emailer is opened. My workaround now is adding a Emailer Transformer to the WorkspaceRunner workbench so the Emailer is installed when this workbench is opened. Hope this helps others that use WorkspaceRunners and Packaged Transformers in there workbenches. 

Bulk copy failed on table 'tv.vagnat_framtida' using delimiter ':'. Error was 'ERROR:  invalid byte sequence for encoding "UTF8": 0xc3 0x3aCONTEXT:  COPY vagnat_framtida, line 33This error kept me busy for some hours exploring character encoding in shapefiles, FME and PostGIS. Which did not help. Not until I did some data digging and found the error.The data in a shapefile apparently comes from a qualified geodata store, and some long text fields have been truncated in the conversion to shape, leaving what appears to be incomplete character codes. And this causes PostGIS problems. The error message comes from deep within PostGIS. I have tried to cut a few bytes from the string with SubstringExtractor, but then the whole string became HEX. Very strange. Since it is invalid data, there seems to be no way of catching these characters with any of the FME string tools. And the error appears only in the Postgis writer, not before so it cannot be logged.Basically, I am looking for suggestions

Hello, I am trying to create a Json schema using the Json Template but I receive the error: JSONTemplater_2 (XMLTemplaterFactory): The following error occurred near line 21, column 20 of the query:JSONTemplater_2 (XMLTemplaterFactory): invalid expression: syntax error, unexpected ":", expecting "," or ")"JSONTemplater_2 (XMLTemplaterFactory): An error occurred while executing the 'PROPERTIES' queryJSONTemplater_2 (XMLTemplaterFactory): The following error occurred near line 6, column 9 of the query:JSONTemplater_2 (XMLTemplaterFactory): An error occurred while executing the process-features functionIf I validate my Json on line seems to be correct but in FME doesn't work.Do you have some suggestion?Attached the file that I am using ThanksMax 

I have brought in an FBX as I need to carry out some coordinate transformations to it as part of our workflows. This is the fbx model in navisworks, units in metres, modelled in EPSG:27700: The model is orientated north, and the top left point is (330213.690, 376187.218, -2.7) When bringing this into FME, the coordinates are multiplied by -1:The same point within FME's data inspector is (-330213.6044, -376187.4125), which is equal (ish) to the above point, but multiplied by -1. The orientation is incorrect but this will be due to the coordinates being multiplied by -1. Is there a reason FME has inversed the coordinates when reading the FBX? Is this typical for reading FBX files? Also - what transformers would be required to make the coordinates positive / *-1 for each xy? Not z, it looks like the z coordinate has the correct sign. Thanks for your time,Tom       

Hello,  i have strange behavior of transformation raster from bil ESRI to ECW in version2. In previous version of FME script was working correctly, but now i receive raster in inncorrect EPSG :6619 instead 3006. In attachment i send simple sample. I need to use version 2 of ECW - due to clients requirements

I have a company website, to which i log in to get my data, the webpage is a .PHP that has several drop down menus for example Data 1, Data 2 , Data 3 etc, if you select Data1 for example, you get a sublist with more files,at the moment i choose a file from the sublist then i click a download CSV button. I have to do the same for over 100 subfiles. I am trying to find another way to achieve this. I was wondering whether someone could have an idea of how i can achieve this in fme? Maybe download the mainfile instead of the subfiles. Thanks,Keller.

Hi, we have raster data (orthophotos) with a ground resolution of 8cm.Is there a possibility to downsample the ground resolution to 20cm? Based on some limitations we sometimes have to use 20cm ground resolution.Does anyone know if something like this is possible with the fme?

Hi! I'm desperately trying to find a way to identify the impact of disabling a specific network on the surrounding networks. So far by using the NetworkTopologyCalculator, I've been able to isolate all my water networks, separated by water valves. But here is an example of what I'm trying to do:If I have to replace the water pipe on the network A, I will close the water valves to isolate it. The impact would logically be that there would be no water reaching networks B-C-D-E. Is there any way for me to dynamically identify this in FME?Thanks in advance for your help!

I want to remove all the extra pipe delimiters after the data. I would do it manually by I have over 10000 records. Please help.

Hi , I have this attribute extracted from an url ressource:<div class="bs-contact__image bs-fixed-size bs-asset--landscape" id="SP-MzI5ODA4MzUx"><div class="bs-fixed-size__raiser" style="padding-top:66.5625%;"><div class="[ js-bs-lazy-image-loading ] [ bs-fixed-size__content ]" data-noscript=""><noscript><div class="bs-contact__picture bs-fixed-size__content"><img alt="Foto:  / Rothe" class="bs-contact__picture__image" src="/leben/schule_bildung/schulportal/schulen/schulen/Abendgymnasium.JPG.scaled/7c140d3a1b0bf9ced7d5c55d4b3864ba.jpg"/></div></noscript></div></div><figcaption class="bs-asset__caption"><span class="bs-asset__caption__copyright">© Foto: / Rothe</span></figcaption></div> <div class="bs-contact__content"> <header class="bs-contact__header"> <h3 class="bs-contact__headline"> Abendgymnasium </h3> </header> <div class="bs-contact__section bs-contact__sec

Building a data prep workspace. Have only got 2018 desktop, not Server. I have created a (long) list of feature class filepaths from network-located ESRI FGDB's. These feature classes mostly have differing attribute structures, and there are hundreds of possibles (although only a few dozen being updated at any one time).  Is it possible to use Filecopy writer to a) copy the entire feature class based on a filepath pushed into the writer, b) write it into a new FGDB in a Feature Dataset (name specified by a feature attribute) and c) (preferably) zip it up?  New structure would be : FGDB1.gdb feature_dataset1 feature_class3 + feature_class5 + ... (Eventually, this will go up to Azure blob storage, but there are some permissions obstacles at the moment, I think.)  If it is possible, any suggestions on how to configure the writer would be gratefully received. 

Hi,i tried to merge multiple lines into only one line, but the difficult is, that also connected lines on a course between start- and end-Point should be merged into the "one line"with linejoiner the lines were only merged until the next Connection.has anyone an idea?

Hello,I would like to create the Geojson output as shown below:{  "type": "FeatureCollection",  "name": "Example_Dataset",  "crs": {    "type": "name",    "properties": {      "name": "EPSG:28992"    }  },  "bbox": null,  "features": [    {      "type": "Feature",      "properties": {        "Name": "AO1",        "Begin K": "0",        "End K": "2.196"      },      "geometry": {        "type": "LineString",        "coordinates": [          [            143267.805,            559438.354,            1.944,            0          ],          [            143268.356,            559439.188,            1.987,            0.001          ],          [            143268.907,            559440.023,            2.029,            0.002          ],          [            143269.235,            559440.968,            2.022,            0.003          ],I have tried to follow this post https://community.safe.com/s/question/0D54Q000080hepZSAQ/create-geojson-arrayand specifically the workspace : build-geojs

Hi everybody, I have 6 values which are standing for colour values for making maps. So each number is standing for a colour. The values are always the same and the numbers are 59, 63, 70, 72, 76 and 77. I have a lot of polygone ESRI shapefiles which are showing the administration of each country (OSM Data for example the states of India, which is the first administration level of India). To have the same style in each map for printing, I would like to use the colour values (59, 63, etc.) for every administration of each country. So each shapefile has a attribute field which is called "colour value". Now the tricky part is: the polygons (so the states of India) should have always one of the values, but the direct neighbour state should have always another value. Otherwise the colour of the states are the same of maybe two of them, which are neighbour states, and you can't see directly the difference on the map after colouring. I put some picture in the attachment, where y