Transformers

Hi All, I've had something that I've been wondering about for a while.In this example, I'm reading 11 SQL tables in using a feature reader and all of them contain a WKB column. I need to run these through a geometry replacer to assign their geometry.   I tried running them all through a single geometry replacer, and using an attribute filter to return them into their own streams, but running them all through one transformer ruins the schema. Is there anyway to return the original schema? Or do I need to create 11 different geometry replacers and keep each stream 'seperate'? I'm aware that I can define the output attribute definition for each layer but I wanted to know if there was a less 'manual way. Many thanks, Sam

Hello  It says Translation is Successful, but i dont't see the any out , am i doing something horribly wrong or missing some setup ?  Python Caller  import fmeimport fmeobjectsimport numpy as np class FeatureProcessor(object): def __init__(self):pass      def input(self, feature):           def myfunction(L, F, DX, DY, DZ):       DLF = [0,0,-1]       ULF = [0,0,1]       NLF = [0,1,0]       SLF = [0,-1,0]       ELF = [1,0,0]       WLF = [-1,0,0]             if L == "D":         UAP = DLF       elif L == "U":         UAP = ULF       elif L == "N":         UAP = NLF       elif L == "S":         UAP = SLF       elif L == "E":         UAP = ELF       elif L == "W":         UAP = WLF               if F == "D":         FAP = DLF       elif F == "U":         FAP = ULF       elif F == "N":         FAP = NLF       elif F == "S":         FAP = SLF       elif F == "E":         FAP = ELF       elif F == "W":         FAP = WLF                 VAP = np.cross(FAP, UAP)       DU,DV,DN = np.linalg.inv(n

Hello , i habe two source data first source data contains attribute calledid 3839464 3937793837390389304——second source data contains cable network attribute 3839464-hsld282-owuwpw37394-283994383894-Jagdhorn-2839463389304-hdjskd-dddjf how could I search at attribute cable network by using id attribute ? i would like to know if any of id value exist in cable network attribute .fme 2021 thanks in advance

Dear fellow FME users, I am trying to delve a bit into the Rcaller in combination with asking data from a website (CBS). I have a bit of R experience, but not so much with the Rcaller. With Rstudio the code works without a problem, however I don't manage to succeed in FME desktop 2022.2.1.0I am running the code below. I am aware that you need to adjust the R code a bit before making it work in FME desktop, so I was wondering whether I have to adjust the current code. In my case the Rcaller is running and it seems like it's doing nothing or stuck. I therefore I assume that the code is probably not working. Can someone else test and see how I have to adjust the current code?  Furthermore I am looking for blog posts that delve into the Rcaller. I would like to learn more about the rcaller and make myself a bit more proficient.# Run once:install.packages("cbsodataR") library(cbsodataR) # Downloading table listtoc <- cbs_get_toc()head(toc) # Downloading entire dataset (can take up to 30s

example of text string Bike :SS Lightning;NDIS #:;Prefname:Jacob;GEOG CODE:46429;Referred By: Newsletter;NDIS Planner:;Continual EOI:;Customer Type:46021;Date of Birth:;RidingCommunity:Short stature;Support Co ordinator:;notification_billing:1;notification_reports:1;Allied Health Company:;Allied Health Contact:;Allied Health Position:;notification_marketing:1 not all features contain all of the field names. I want to end up with columns Bike, NDIS#, GEOG COde etc and the data for each attribute in a excel spreadsheet. Thanks

Looking at article Working with Geodatabase Field Aliases: Altering Alias Values (safe.com) I am trying to run the same directly to an AGOL hosted feature layer. I have created the requisite "_alias" field to match those that I need alias values for, but no dice. Also tried adding the same fields (matching the attribute manager) to the writer attributes (manual setting) but the result simply created additional fields with the "_alias" suffix. Is this possible with this writer?

I have a workspace that was just pulling data and joining schema from two feature classes from an enterprise geodatabase. Then, we had a business need to add two new fields to the output feature class. (I cannot add them to the input feature class). Now, when I run the workspace, it overwrites the edits to those two new fields. Does anyone have suggestions on how to set this up in FME so that the two new fields (flagged and flagged description) aren't overwritten? Here is a screenshot of the workspace. Thanks!

Working Key: 1472_3_81445Not Working Key: 1472_E2b_81445 

Python = np.cross(XYZ, ABC) ????

I am working on a web application project and will like to include energy consumption, inlet flow and outlet flow, temperature readings visualizations in the 3d model buildings in Cesium

The firs one query is  And the second one is Then I need to do a join with this second query and create a list with the results.I dont know if with the SQL Executor transformer I can replicate this two querys.  Any idea? Thanks

Long time listener, first time caller.Newish to FME and was attempting to use a user parameter for the first time to allow the user to input the number of days they need to pull data. I have the parameter and the initial formula working fine. DaysPulled is my user parameter: @DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P$(DaysPulled)D),%Y%m%d) The problem I'm running into is later on in the flow I need to use that user input and add a number to it, effectively turning the user parameter into DaysPulled +1 and DaysPulled+2. I've been beating my head against the wall trying to modify DatePulled using add, sum, +1, etc and can't find the right format to get what I need. Example of failed attempt.@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P@add(1,$(DaysPulled))D),%Y%m%d) Can anyone point me towards a solution?

How to download and save multiple DTM zip files from CSV with URLs. Need help with settings for extracting individual files

I have a workspace in FME Workbench 2022.2 that reads an ESRI ArcGIS Server Feature Service containing 7 layers. It successfully reads all 7 layers and transforms them to the appropriate feature types.  That same workspace in FME Form 2023.1.1.1 is able to read in the number of features for all 7 layers but only able to successfully read in the features for 3 of the 7 layers. On the 4 layers that fail it appears to be failing after the first batch of 1000 records are requested. As a test I created a new project with only the FeatureServer reader in FME Form 2023.1.1.1, again same problem. As another test I tried using the MapServer endpoint for the service rather than the FeatureServer endpoint that failed on the 4 layers. This successfully read in all 7 layers.ArcGIS Feature Service Reader: Got 4222 results for layer/table ID 0ArcGIS Feature Service Reader: Splitting reading of 4222 features into 5 batches of up to 1000 featuresArcGIS Feature Service Reader: Getting feature results 0 

I created a primary key using SSMS for the new table but I still get the error the layer does not have identity properties.

I sometimes have to read from multiple readers. Is it possible to set the maximum features to read to ALL feature types? Not just all per reader? Related, is it possible to set the Search Envelop for ALL readers?

Hi All, I'm trying to create a workflow that iterates through a folder which contains individual GDBs (e.g. 20 individual GDBs) and then merges the Feature Classes with the same name into a new blank GDB.Any idea how to make that happen?Thanks 🙂 

Hi, I have 2 data sets (shape-files). A point dataset with 3d-points or at least points where the elevation is stored in an attribute field (different data quality) and a polyline dataset with 2d-lines whose vertices are identical to the points from the point dataset. Is there a way to assign the elevations from the point datasets to the line vertices and then create 3d polylines from them? Thanks for your help

I have a very simple workspace that just tests whether a string has a “.” Or a “:’ in it and if it does then these characters are deleted. I am using the Testfilter to test for the characters, and then a stringreplacer to delete them and then I must make sure the string is all caps. Is there a way to do these three operations by using the String Functions in the Testfilter? I haven’t been able to figure out how the string functions work. Also, will using the string functions speed up the translation? I have 47 million records to test and right now it takes 4 hours to run. I am using FME2018. I have included the workspace and source CSV file. Thanks.

In the writers, under user attributes we can see the table with name, type, of data, width., etc. Is there a way to copy/pate or export this table in csv? I am tasked with data type for multiple outputs, and it would be great not to do so manually.

We are attempting to use the Automations > Manage Automations as a built-in user, but when browsing to that page it is blank and there are no automations in the popup list. We've made the user a member of 'fmeadmin' and 'fmesuperuser' but it makes no difference. So far only the 'admin' account is able to Manage Automations.What are the minimum permissions required for users to make this work?

I have a feature class with a single feature that I need to convert to a multipolygon type geoJson file. I'm not super familiar with geoJSON, and I'm being told this is a hard requirement. How does one create a multipolygon geoJSON file from a single feature?

I have FeatureReader transformers within my workspace that are configured to read features from an Excel file.  The name and path of the Excel file are variables provided by parameter values, but the Excel sheet name is always the same. The schema of the file is likely to vary every time the workspace is run.  I'm really struggling to get any features to read in, and am a bit unsure of where I'm going wrong. From similar posts in the past (eg; https://community.safe.com/s/question/0D54Q000080hdRJSAY/how-to-expose-attributes-from-featurereader-if-feature-type-is-dynamic) it seems that what I'm trying to do potentially isn't possible without scripting something bespoke in a PythonCaller, but it really seems like something that FME should be able to do. Does anyone have any advice or a working methodology for this sort of problem? Thanks in advance

I have two tab files and while joining them I get this error for one of the row ERROR |FeatureJoiner (FeatureJoinerFactory): The UTF-16LE string 'DOÃƑ±A ANA-HILL' could not be converted to the encoding: windows-1252.

Hello,I have a SQLExecutor connecting to my SDE on a SQL database. I am using the Microsoft SQL Server Non-Spatial Format with an embedded Connection. My SQL Statement is:FME_SQL_DELIMITER ; GO DISABLE TRIGGER gisowner.SEGME_MSLINK_COUNTER ON gisowner.[a10]; GOI get the following errors:Query failed, possibly due to a malformed statement.Provider error `(-2147217900) Incorrect syntax near the keyword 'TRIGGER'.'A fatal error has occurred. Check the logfile above for detailsFailed to read features from dataset 'AHS_GIS' using the 'MSSQL_ADO' reader