Transformers

I have FME workspaces deleting and writing records to the StagingAddress table in an ESRI GeoDatabase. For every agency, the STAGINGADDRESS table is purged using the DatabaseDeleter transformer and then the subsequent workspaces insert records into the STAGINGADDRESS table and then transferred to the ADDRESS table. This process is repeated for multiple agencies.For every cycle, the purging part with the DatabaseDeleter transformer takes the most time.Can I use some other transformer to speed up the purging part? How about using SQL Executor? I am not sure if it will cause any issues, hence asking.

I have multiple layers in my GDBI know I can get the correct projection using share from arcgis pro, but I don't have an arcgis pro subscription for this account, only arcgisonlineI will need to keep updating the layers keeping the projection in arcgisonline 28992 thank you in advance for your help

HiI am using fme to work out the spatial relationship between two polygon datasets. Some requesters will have multiple suppliers and I have enabled the list to store the references for each supplier. Following this transformer, I have use a list concatenator to show these references in one field. This works great when I have only one predicate selected. Where multiple are selected, I have created a second list concatenator for the relationships{}.pass{}. Unfortunately, both these can contain different number of values. For example, there could be two suppliers, but one of these could pass intersect and within and the other just intersect. My difficulty id knowing which pass attribute relates to which supplier. Please can someone let me know what I am doing wrong? Many thanks 

What is the order of operation for fme_db_operations when sending the results to a writer?  If I have a feature counter attached to the Unchanged Port of the Change detector and test the number of records, can I analyze and terminate the workbench before the Deleted, Inserted, and Updated records get processed in the Writer?

Hi everyone,I’m struggling to change/update values of an IFC-file. Example:old PropertySetIfcPropertySet VolumePosition: 1Unit      : m3Quantity: 15  new PropertySetIfcPropertySet VolumePosition: 1Unit      : m3Quantity: 350 I used the GeometryPartExtractor to extract the IfcPropertySets from a IfcBuildingElementProxy geometry. Then I tried to adapt this https://community.safe.com/s/article/updating-ifc-example into my workspace. I used an AttributeCreator:ifc_property_set_name = VolumeQuantity = 350 After that I configured the GeometryPropertySetter and GeometryPropertyRemover. Unfortunately, the original PropertySet Volume will be deleted after writing. In the updated one, Position and Unit are missing. Is there a way how I can keep the traits of the original PropertySet and only change/update one specific value? thxNel 

Hi, I encountered something peculiar last week. I had to compare two datasets about chemical substances measured in groundwater.To compare the datasets, I used the ChangeDetector. While doing so, for one substance an update/change was found for the value of a CASnumber. However, when I look at the originalValue and the revisedValue, I don't see any difference. Also, when I perform a compare using (a plugin of) Notepad++, it also detects a difference in the two CASnumbers. So there seems to be a difference, I just can't seem to spot the difference ;) Maybe some people here can help take a look and provide an explanation? Any feedback is appreciated. The CASnumbers are:CASnumber_1 = '‎483-63-6'CASnumber_2 = '483-63-6' See also the screenshots below for a dummy workspace and the comparison using (a plugin of) Notepad++; 

Hello,I'm very confused, I don't find how to remove the two last elements of a address list and concatenate the other words.I think it's quite easy but even with the ListElementCounter, I dont find the answer!Thank for your help.

(i need to choose one dataset from many dataset in geodatabse)

I am reading some data from a ESRI based web GIS and need to convert them to DWG. The data contains XYZ data, but the Z-values are missing when opening the DWG in CAD-software.  I got Z-values before writing: This is my workspace: AutoCAD: How can I make sure the file contains Z values?

I m reading the data from Snowflake database and there is a date type in timestamp z (9) and when I tried to insert the data in MySQL is giving me the error Date/time string  Snowfleke Data Mysql Data Strcuture

Hi everyone, I have a workspace where I am trying to test some element attributes to see if they match certain conditions/values. So kind of like: Location: Melbourne (fixed for all elements in file)Asset type: various (varies per element) I have around 80 of these attributes to test. The tests parameters are contained in an Excel file, i.e. I have a file that has the following columns: Attribute NameAttribute value (either has a value that I want to check against if Fixed)Attribute type (contains term 'fixed' or 'varies') Other than writing each individual rule into the Tester, is there a more efficient way to do this, particularly as the parameter spreadsheet may update and I want to avoid re-writting all the tests? Thanks in advance for your help! Amit

I want to test my GML file against a schema to make sure that it is valid. To do this, I am using an XMLValidator transformer. I am not sure how it works.When I add a reader for my GML file, it loads all the different feature types. I also selected my .xsd file containing my schema. Connecting these to the XMLValidator goes excruciatingly slowly and everything seems to fail anyway.If I select my GML file as the "XML Filename" parameter for the XMLValidator, and then my .xsd file as the Schema Location (Validation type "Syntax and Schema", and then unconnect the Feature Type readers, it seems to work, but I have inspectors connected to the "Passed" and "Failed" ports on the XMLValidator and nothing seems to go through either of them, even though the workbench runs successfully. Am I using it right? 

For example, I am splitting 'label' - TCY/D/N3000000. In this case, I only need the 'TCY' to be part of the list. I have multiple labels with different values instead of 'TCY'. I then need to display these as row names in Col A. upon writing to Excel as below: (Col B should count how many 'TCY' labels in the dataset. DA_List CountTCY 150BGS 20CUR 50

Hello, I want to extract roof textures from an imagery raster. In input I have a raster and a polygon.In output I would like to have the image I could use to texture the polygon. Is there any transformer for that? Thanks!

I am trying to use a colleague's web connection to truncate/load several SDE feature classes to AGOL using parameters for the feature classes and connection files. (Ultimately, I want to create a workspace for specific users to access to update any desired feature service)Everything works fine in FME Desktop. However, after publishing to FME Server, the web connection disappears. Once I reset the parameters the connection shows up but does not persist. How do I resolve this issue?Exhibits: 1a - published2a - after Reset

I want to convert a dgn file to a gdb. The information of the cell color and the line width and the style are lost in the process. For example the colur of the cells are suddenly white and the line style is different. Can I put a dgn seed file and a dgn cell library on the reader to keep the information?

HiI am passing a polygon dataset to the area on area overlayer and some of the features seem to be ignored completely and do not pass through the transformer. Surely all polygons sohould pass through with a count of 1 (or more if they intersect other features in the dataset)? Also is there a way to tell the transformer only to intersect with a second dataset and not itself?

I am trying to use the HTTP caller to post the zip file via FME server Rest API. If someone has any starting tips, I would appreciate it. Thanks

Hello, fellow FME-ers!  I have a question for you. When I use the HTTPCaller I want to send a request and then control the time out length before I receive an answer. From what my college and I can read in the documentation there is no way to do this?

I'm using a DatabaseJoiner to look up rows in an Excel file. This Excel file has about 6,000 rows and about 20 columns. I have an integer FME attribute that finds a matching field in a row in Excel. About 5 'Fields to Add' are concatenated into a new FME attribute. This works great!  I have 4 more FME attributes that contain 1 to 5 comma separated lookup values. One sample value looks like this: 13045,52136,38010. I need to look up a row in the Excel file (for each of the 3 values in this example), then cancatentate the 'Fields to Add' then cancatentate the three final strings into one big string. Do I have to expand "13045,52136,38010" into three new attributes then use each of them in the DatabaseJoiner and create a string attribute for each of them?  Since I have 4 FME attributes that contain 1 to 5 comma separated lookup values, this means that I'll need to add 20 (4*5) integer attributes for lookup and 20 (4*5) string attributes for output? That i

Hi everyone, I want to search for all Feature Classes in our SDE and list out only the ones that have a field name 'SDE_UPDATE' (date field) with a criteria that queries the ones that have been updated in past 10 days. Any example workbench to share?

We have done:Register an app and make sure the FME has permission to use the app.Make sure the user is allowed to access the data. 

The file gdb is a handy conversion template that avoids a lot of painful domain reformatting.

It is to identify the sum of which group. Otherwise, the result is a list of values (for sum) but not possible to identified which value is for each group of features.

Is it possible to generate a horizontal bar chart with the HTMLReportGenerator?