Transformers

Hi community. I have run into something that I am trying to automate but falling over at the last step.The process I have is:Download data-set names from FTP.Split data-set name list into attributes.Download data-sets from FTP to local drive.Read downloaded data-sets using the feature reader.Dynamically write data-sets into SQL server. The last step I have missed is setting the primary key attribute for each data-set (fortunately it is the same 'ATTR_STR_1' for each data-set) as the dynamic writer is reading from the schema attributes coming out of the feature reader.Has anyone had success with setting a primary key in dynamic writing?I have tried a few things:SQL To run after write: alter table landmap_polygon add primary key (ATTR_STR_1)Error here is that the column is already populated and not set to no 'nulls' and I would need to set this for each table (we won't know table names until after the fact).Read schema from existing table (after setting primary key).T

Hey all,I am trying to set up a workspace to update, insert, and delete a heap of our ArcGIS Online feature layers once a week or so.I have been able to set it up once using the AGOL feature reader into the change detector in a similar way to How do I write updates to an existing ArcGIS Online feature service? (safe.com).I am unable to add dynamic layers using the AGOL feature reader, thus limiting my ability to update multiple features using it. My question revolves more around how to cycle through multiple layers and add to the change detector.I have tried setting up a CSV with the required information and then using a standard feature reader, but that does not bring the attributes that are used to compare in the change detector.Has anyone done a similar project or have an idea on how to Have it work? Cheers 

I have a dataset with a messy 'comments' column. I want to extract numbers from these comments, but only when the come before a ceratin word. For instance, a comment could be: on januari 21, 16 boats passed or21 boats passed on januari 12 2017 I only want the numbers when they come beofre the word 'boat'. Is there a way to do that?

Hi all,Is there any suitable transform for following scenario?. Like I have a shape file which have data with some attribute and I have an excel file which holds same attribute data like present in shp file attributes. I want to filter those attribute matching feature.all related suggestions are welcomes!Thank you in advance,Saravanakumar 

Hello. I saw that in the latest version of workbench 2021.1 that the sorter doesn't work well on number values. The sorter stops at 99 while the highest number is higher. Now i filter all values below 100 and then the next stop is 999, etc. Do you recognise this problem? Greets, Jacob

I've got an issue with the stringsearcher. It does not seen to work as I expect it do do. It might be my regex skills, but I think I tried all possibilities. What  I've got the following text: "324324" "maatvoering; hoogte; bouwhoogte; maximum bouwhoogte (m)"="8", "maatvoering; hoogte; goothoogte; maximum goothoogte (m)"="4" asdfasdf sadfsadfsf 343244 In this text I would like to find the first number after it finds the word 'goot' in the text. In this example this should be the bold number 4. I'm trying to do this with the following expression: (?=goot.*")[0-9]*(?=") But it does not give any results as you can see in the screenshot below. Any ideas what I'm missing here? 

 We may not have the certificate on the date we plan on doing the installation.

Hi All,  I'm trying to find a way to snap a point on a line segment to a point on one of the line ends, based on whichever one is closer. The points on the line segment and the line itself share a common asset ID, but the points on the ends of the lines are strictly geometry. The only attribution is a unique ID, but it doesn't relate to the line or the point on the line at all.  Right now I am using a spatial relator on the lines and end points. I now have, per each line segment feature, a list of end points that touch it.  I want to find a way to use NeighborFinder (or anything else - i'm open to ideas) to say "ok, where the line asset ID and the on-line point asset ID match, find the closest line end-point from the list. I've attached a small diagram/graphic to illustrate what I'm on about.  Any help would be appreciated!

Hey All. I've been looking through the tutorials to set up custom transformers because I wanted a programatic way to define workflows and I was planning on encapsulating/stitching together a Reader, GeometryFilters, and Writer into one custom transformer that took input files, output folder and various other runtime arguments as parameters. The reason for this is to be able to dynamically define the links between workflow steps, whereas now it would require a lot of manual UI work to define a workflow that worked for a file with 1 specific set of features. Is this the right way to be thinking about this problem?

Hello, I'm trying to snap two line feature layers to one of two separate point feature layers. In the line layers there is a owner1 field and a owner2 field, on the point layers there is a ownerid. Hopefully the screen shot below helps clear it up a bit. I tried using the anchoredsnapper using the owner1 and owner2 as the group by and a snapping tolerance of up to 75 feet which is much larger than I should need. I had the line layers going into the candidate and the point layers in as the anchors. I have not used this transformer before so I'm not sure if i'm using it correctly. I'm getting features to snap, but most com out as untouched. I expected that to have far more of the lines snap. Any help of ideas would be appreciated, thanks. field. I want the point features to be what the lines snap to. Either of the owner fields in the line layers can match the owner field in either point layer.

Hello  I have a number of connectors which touch a main line but do not split it.  I want to be able to select the connectors that are not currently attached to a node and snap their vertex to the closest node point as shown by red dashed lines.  I assume I have to form a relationship between the connectors and the main line and then the main line and the node points?  Or can it just be undertaken using X,Y co-ordinates and proximity.  Any help greatly appreciated.    

i would like to ask :i want to snap several small lines to closet point ,i have around 20 point but i have problem with only 2 point .each small lines connects to different lines around each point First point : 6 lines around 1 point around 1.30 mSecond point : 5 lines around 1 point around 1.50 m For First point : i used snapper but i got the problem ,i have to use maximum 1.3 because more than it ,it will snap the second line instead of the first line close to the point . but i need to use value higher than 1.30 ,around 1.5 to snap the second point but it is not working well with the first point , because it snapped wrong lines . i tried neighbor finder with generate list ,i found it gives me alll lines around it and each line that i have around this point small line connects to lone line and it give me each lines connected around this point . i tried alot but i am not sure how could i manage snapping between this 2 points FME Version 2018Thanks in advance for any help    

I am trying to write ArcFM data to an ESRI file geodatabase. I have created a workspace that reads a feature class, a relationship class and feature linked annotation and writes it directly to a file geodatabase. There are no transformers. I am trying to preserve the relationship between the feature class and the feature linked annotation. I have added a python script that checks out an ArcFM license so that I can write to an ArcFM object. The annotation writes the data just fine, but the feature class gives me a 'Table not found error'. I also import schema from the source database. The writer also has the Create Table If Need option selected. I have attached the log file. Any help would be appreciated.

Morning,I'm using the SpatialRelator to find what points (a site) relate to lines (sewers) to find the type of sewer is joined to the site.Despite configuring the SpatialRelator to Requestor intersects / touches the Supplier the output is showing no relationships: Can anyone let me know if this is correct? Do I need to apply a tolerance?Both features come from the same GIS system, with the same coordinate system, and that GIS does not allow features not to join each other in the connected network, so there is definitely a relationship between the point and line. Cheers

I have some workbenches authored in FME 2020 which contain a FeatureReader to read a SpatiaLite database. The spatial filter is set to read features that intersect with the initiator (a simple polygon). This was working well in FME 2020. When updating my workbench in 2022, the input format has to be updated from "SPATIALITE (GDAL)" to "SPATIALITE_NATIVE". When the featureReader is updated, the spatial filter no longer works.  Is this expected? ===UPDATE:On further testing I found that spatial filter works if I specify a table to read in 'Feature types to read' but does not work if 'Feature types to read' is empty. If this parameter is empty I would expect the reader to read all tables. Is this a bug?

Using the CKANConnector to Create Resource on OpenGov, works great the issue I'm having is how do you reorder the resources ( or place the new resource at the top of the ordering) by default the sequence number is Max + 1 placing the new resource at the bottom of the listing. In this case we have a few hundred Resources under that one dataset.

Hi all, Good morning, The challenge we have is: to put a signature (image) in a particular cell in a table in an MS Word document. We have got something working, but we would like to have your kindly advice. Situation:The signature is read from an AGOL attachment as a blob and with a RasterReplacer and a RasterResampler it is turned into a JPEG (which is visible in the Graphics window). To put this image into the Word document we could use an MSWordStyler where we set Image Source to From Feature.But because of the very specific location of the image in the doc (in this particular cell in this particular table) we use a Python docx solution in a PythonCaller. Question:The solution we have now is to temporarily store the image and then retrieve it to put it on the right location in the doc. And this works... But, but, but wouldn't it be possible - inside the PythonCaller - to read the image "From Feature", like in the MSWordStyler...Any ideas would be highly appreciated. C

counter_Expressions

Hello all, I am trying to merge two different layer data from DWG file. In that one layer is line geometry and another layer is point (text) . Here I wish to connect text to nearer line geometry but I tried different transformers but I could not !FYI - I tried spatialfilter, Neighbourfinder Thank you for advance!

Wondering how to create a hyperlink that will show the blue underlined text value in a field and when you hover mouse over the text you will be able to click on a url. My Writer is to file geodatabase. I have a single url that I want to associate with the text values in a field. Attached is what I have done so far using the AttributeManager Conditional Parameters. I do not want the actual URL to appear in the field.  

I have a bunch of CSV spatial data that have no street location allocated to them. I was wondering if FME can import a basemap of google earth or google maps of my location and using an attribute apply a street name to my csv points?

My Reader is Excel. My Writer is ESRI File Geodatabase. I use AttributeManager to rename the fields. How do I add field name aliases to the Writer in this situation?

I am struggling to convert a polyline ( 2d & 3d ) to Esri feature class. I have used a geometry filter + Elevation Extractor + 2d Forcer + Area Builder. However half of the result of Area Builder transformer appears to be incomplete. Any idea as to how to convert all the polylines in to a polygon successfully....?   Thank you

Hello, I'm using a string searcher to find "Dates" out of a "Comments" field. I have a column of all matches (Screen shot attached). How can i extract the most recent date out of all matches? Probably would help if I change "/" to another symbol.

I need to scan an existing but unpopulated (i.e. no data) file geodatabase (GDB) and determine which feature classes have attributes whose names match a given regular expression. I then need essentially to extract the pairs of feature_class_name/matching_attribute_name and in some way to use those pairs subsequently in the translation. So:What transformer would I use to scan an unpopulated GDB for attribute names matching a regex?How best to configure and to capture information from that transformer to use subsequently in translation?[Related to the beginnings of a solution idea in my head ...] If I use, say, a FeatureReader to extract schema features from an unpopulated GDB with Ignore Relationship Info unchecked, will the schema features carry format attributes (similar to geodb_feature_has_relationships on data features) indicating feature classes and attributes that participate in relationships? Thanks, all, for your ideas on this.