Transformers

I'm trying to update/delete from an SDE featureclass using fme_db_operation, The changes are grouped in 4 groups: 2 delete and 2 updates. The Deletes work fine, the first update group (updates both geometry and attributes) works fine.But the the last update group (updates only attributes) does not write data to DB. There is no errors, there is 5 exspected warnings (non existing keys) but for the rest of the +70.000 records there is no indication of anything is wrong - except the data is not updated.Best regards  

i need to reprojection from (wgs1984-utm-zone39n) to (KSA-GRF17 )but don't find KSA-GRF17 in coordinate system?

I want to merge small polygon (<0.01) to adjacent large polygon same the same commune. Could you tell me how to make it? Thank you

The workflow looks like this: I'm downloading a .zip file via an API and unzipping it using the ZipExtractor. Connecting the ZipExtractor 'File' output to a Feature reader, I was hoping to be able to upload the gpkg-file from 5 different output ports to 5 tables in a postgis database. This works fine if I specify the geopackage file manually in the 'Output' section of the feature reader. Is there a way to use a transformer or to edit the FeatureReader to make it read the output ports directly/automatically from the gpkg-file in the folder the ZipExtractor has unzipped?  Thanks!  /Alex

Hello Sir/ Madam, My goal is to run a batch processing so that I can count all the attributes in each input excel file in a particular folder. Then, I would like to output the result in a single excel file. Is it possible? My caseData - 2 excel files: A.xlsx & B.xlsxWorkbench: "Value count" by using statisticCalculator transformerOutput : 1 single excel file Problems that I encountered:1) I try to run the "Batch Deploy" in the workbench and it returns the result files indivdually. Can I group all the output into a single excel file? 2) In my workbench, May I ask how can I count all the attributes values? The "StatisticsCalculator" must defined the attribute name in order to do the counting. However, I would like count all the attributes in the excel file. It is because my input excel files may have slightly different attribute names in it. Thank you very much. Zachary

Could anyone help me understand why I get the following error. It currently occurs at a junction but if I replace the junction with a normal connector then it just occurs elsewhere so it doesn't seem to be related to the transformer. Junction_139_Output Feature Recorder -1 2147615843 (RecorderFactory): File C:\\Program Files\\FME\\metafile\\ffs.fmf could not be openedFile C:\\Program Files\\FME\\metafile\\ffs.fmf could not be opened I've tried running FME as an administrator in case that helped but got the same result. I also googled and found a similar issue but that related to just \\.fmf file and was apparently caused by databasejoiner which I'm not using. I've also uninstalled and reinstalled FME. If I disable feature caching then the workspace runs fine but that means I can't debug anything unfortunately.

Hello!  I have a CityGML dataset consisting of MultiSurfaces - atleast that is what FME tells me:  an example of a surface:  I would like to extract the surfaces' triangles, so each triangle has its own feature/record in the output.  So far i have tried 3 methods: using the deaggregator. Looks like it didnt do anything. using the geometryPartExtractor. I have extracted the "IFMEface" geometry-type from the surface, but this just looks like original geometry, where all triangles are one geometry. Afterwards i added another geometryPartextractor and tried to extract the IFMEPolygon - but this seemed to just remove the triangles from the geometry. using the Triangulator. Using the triangles output, input these into a geometryPartExtractor where you extract the newly created faces. This worked somewhat, however the triangles it made do not always correspond with the original triangles. the example from above gets a new triangle: If possible i would like the original triangles

If I have a date field formatted as month-day-year is there a way to retreive just the month and use it in a tester? I want the user to input a month and then if it matches the month in the date field it will select all of those records. The data is in a geodatabase if that matters.

Hi friends, I have an ESRI filegeodatabase with 3D multipatches. I want to cut out areas there. I have tried this with the clipper, but no result. Not only that, but I also tried extruding the clip extension. But also without result. Does anyone know the best way to clip this? Thanks!

I want the user to be able to select the tables to be read from a geodatabase. I added the reader using the single merged feature type. This gives me a list of tables for them to choose from. What I want to happen is depending on which tables are selected, it will output to a schema mapper which reads the tables and writes to a geodatabase. So, I was thinking I would want a tester but the tester doesn't have the ability to show the tables. Anyone have any idea of how this can be done?

I have a process were I need to create a downloadable zip file that contains a file that has an odd extension. So far I am able to create the folder, but the file copy writer is renaming the folder instead of making it a file with odd ext. I have added a picture to show how the folder displaying how the folder got renamed instead of changing the extension and making it a file.Thanks in advance for any feedback.

Hi.I'm working with a dynamic workflow. I have an ArcSDE reader and in some of my tables (I don't know which ones) I have a date (1899-12-30) that I need to set to null.My idea was to first filter the attributes with a date format, then filter the values and finally set the value to null.I know how to do it with one table because I know which attributes are set to date format. But with a dynamic worflow, how can I detect date attributes in all tables of my ArcSDE DB ?

So I want to delete the duplicates, or find the distinct combinations across two columns.I know I can do that with SQL on a database. But I just have a table here and want to do that directly in my FME script. Does someone has an idea?

I use XMLtemplater to design my XML file from Excel, but i have problem with the result:This result, it coincides with each output data field: I want to group like this:And this is my model FME:Anybody help me, pls !in my excel file, the fields "table_id" in sheet "table" and "table_id_field" in sheet "fields" are key fields to link these two data tables together

Hi,I'm downloading a bunch of text files from an FTP server and the contents of each file is stored in an attribute. The format of a text file is as follows : Station1;2022-04-12;09:00;Var1;True;30.4;Var2;True;0.5;Var3;False;0.0;Station2;2022-04-12;08:00;Var1;True;33.4;Var2;True;0.5;Var4;True;10.3;Station3;2022-04-12;09:00;Var1;True;27.4;Var3;True;0.5; What I would like to do is transform this text to a table as in the attached screenshot, but I have not found any easy way to do it in FME. Would you have any suggestions? Thanks! 

I'm upgrading from 2016.1.3.2 to 2021.2.5.I have geometry stored in PostGIS -> GeometryReplacer converting from Hex OGC WKB -> optional Reprojector -> Shapefile or FileGDB (both types). According to the log files, for 2016, there's barely mention of GeometryReplacer and Reprojector, but for 2021, there's a significant chunk of runtime devoted to passing through the two transformers. There's minimal changes to make for them to upgrade so it's bizarre why it's adding nearly double the runtime. (See log attachments) For production concerns, jobs are taking several more hours to run. Here's metrics for another dataset:2016:2021: Thanks,Janet

I am trying to covert geotagged photos from a mobile phone and convert them into a KMZ file, every works great except the actual photos are not being inserted into the KMZ file... How do I fix this? 

I have added an extra column in the shapefile using attribute manager. How can I edit the values in that column?

Hi!In the translation log, i have tried to add a specific row (in my case row 85) to attribute table without any result. Is this possible to do it? The pythoncaller script (Esri Arcgis Python 3.7) look like this: import fmeimport fmeobjectsfrom arcgis.gis import GISfrom arcgis.apps.storymap.story import StoryMapfrom arcgis.apps.storymap.story_content import Image, TextStyles, Video, Audio, Embed, Map, Text, Button, Gallery, Swipe, Sidecar, Timelinefrom arcgis.gis import Itemfrom arcgis.apps.storymap import Themes class FeatureProcessor(object):  def __init__(self):    pass  def input(self, feature):    gis = GIS("home")    new_story = StoryMap("9f1567e92c514baabdc2e595776bfdc8")    new_story    new_story.nodes    newFeature = fmeobjects.FMEFeature()    self.pyoutput(newFeature)    print(new_story.nodes)  def close(self):    pass  def process_group(self):    pass arcgis package 2.0.0 in ArcGIS Pro needed to run this script. A similar script without arcgis package 2.0

I am trying to create features out of a large json file that has many objects mixed in with arrays. I can almost get what I need by using the following query:json["Domain"]["Classifications"][*]Unfortunately, it leaves out a crucial attribute. Here is a screenshot of the json file where it has me stumped:Here is a link to the entire file.The attribute underlined in red is what I am looking for. There are hundreds of them at this level, all differently named. I have not yet found an example of this schema type, with hashes within a hash. In addition, the schema is not uniform. I can get to where it will separate the "Psets" attribute into features, but the "IfcActuator" level does not come through unless it is all in one big feature. Here are some screen shots of what I mean:This is the result of: json["Domain"]["Classifications"][*] Add one more wildcard [*], and you get this:What syntax/language should be used to quer

This is less a question and more of a finding to report. In 2016, File Geodb Open API treats date values "1901-01-01" as "19000101000000", but in 2021.2.5, the reader treats the same value as "000000". The effect is the record gets thrown out, despite the writer saying all features are written.We've had to build in a StringReplacer to find all the "000000" to replace with the original date value.Is this a bug? Update:Affects "1900-01-01" as well.

Hi, I have loads of vertices that belongs to polygons and want to change the start vertex so that the polygon always start and ends in the lower left corner. The order of the vertices must stay in the same order so its possible to rebuild the polygon. Spatial sorting works to identifiy which vertex that should be the start vertex but messes up the order of the other. Thanks

Hi, I have a 3D modell as object file. I will convert this to cesium tiles!I tried this way:Reader -> CoordinateSystemSetter -> Writer (Cesium 3D Tiles) But if I import the tiles inside cesium (e.g. cesium ion) I do not get georeferencing. So the model is not display at the correct location.  Is it possbile to assign a georeference to an obj file?

Hello Sir / Madam, So I would like to subtract both "Top Height" and "Rooflevel" attributes. I use attribute manager to calculate the value@round(@abs(@Value(TopHeight)-@Value(ROOFLEVEL)),1) The result is shown as below.However, I want my result to be <null> if either TopHeight or Rooflevel is <null>. May I ask how to do it? Thank you. Zachary

I can see the imagery on the inspector but don't see anything in the GDB package that would hold the imagery. The GDB package has ATX, GDBINDEXES, GDBTABLE, GDBTABLX and SPX files.