Transformers

Used arcmap to import xml of data schema only from arcsde into a file geodatabase. Using esri geodatabase (ArcSDE Geodb) reader to esri geodatabase (file geodb). receiving error message:An error occurred while attempting to open an insert cursor on the table 'Beacons'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [Beacons]}  

The data needs to output from Row 5 cell A to U. I can see you can use the start position of 5 which works but everything above get's wiped out so I loose the headers. How to I stop loosing the titles and headers from the output in Excel in FME?

Hi everyone,I'm trying to restore a arcgis polygon feature layer (feature 1) (that someone accidently ran a simplify geometry tool on) with the geometry of a backup feature layer (feature 2) from a older copy of the dataset. Problem is that I ONLY want to replace the geometry of feature1 and keep the attributes. The workbench that I build (see picture below) will replace both the geometry and the feature values/attributes of feature 1 Any tips on ONLY replacing the geometry? thanks in advance. 

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 ve

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.

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 clo

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

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