Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,713 Replies
10000 Posts
gogopotter90
Contributor
gogopotter90Contributor
asked in Transformers
problem with snapping lines to points ,how could manage different points not the same distance around sveeral lines

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    

560
cnero101
Contributor
D
donjensen
asked in Transformers
Writing ArcFM data to a file geodatabase.

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.

450
M
nedwaterman
Contributor
nedwatermanContributor
asked in Transformers
Issue with SpatialRelator

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

1500
M
trembathp
Contributor
trembathpContributor
asked in Transformers
When updating featureReader (spatialite) to FME 2022 - spatial filter no longer working

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?

630
danminneyatsaf
Safer
jpbarnes
Contributor
jpbarnesContributor
asked in Transformers
CKANConnector - Reorder resources within a dataset - Place new resource at the top of the listing

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.

310
jpbarnes
Contributor
egge
Contributor
eggeContributor
asked in Transformers
Handle Graphic of a Feature in PythonCaller (to add image to MS Word document)

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

705
f.kemminje
Contributor
M
mennos
asked in Transformers
Can somebody provide me with a working example or a clear explanation of a module or start value counter in xfMap? The example given in the documentation does not seem to be correct.

counter_Expressions

70
M
saravanakumar
Supporter
saravanakumarSupporter
asked in Transformers
how to connect two different layers data of .dwg file? (point and line)

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!

570
saravanakumar
Supporter
vxn43
Supporter
vxn43Supporter
asked in Transformers
URL with Text using HTML in Attribute Manager

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.  

2601
redgeographics
Celebrity
P
phillip_bowman
asked in Transformers
It is possible to set a base map on FME so I can see the points more clearly? Also is it possible to get data from a base map ie. street name compared to a csv point?

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?

2290
P
vxn43
Supporter
vxn43Supporter
asked in Transformers
Add Aliases to File Geodatabase

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?

6360
dustin
Influencer
gistech_
Contributor
gistech_Contributor
asked in Transformers
Polyline to polygon

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

5000
M
E
egeiser
asked in Transformers
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 symbo

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.

130
M
tcrossman
Contributor
tcrossmanContributor
asked in Transformers
How to search file geodatabase for feature classes containing attributes with names that meet a regular expression?

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.

400
tcrossman
Contributor
L
leif
asked in Transformers
Replace raster cell values by table

Hi, I have a raster in GRAY8 that have cells ranging from 0 to 255. Additionaly I have a translation table with values as such: T pixelvalue≤ -22 0-21,92 1-21,84 2-21,76 3-21,69 4-21,61 5-21,53 6-21,45 7-21,37 8etc...I would like to replace every pixel value with its corresponding value in the T column. I have tried to do the following:1) Trim the "-" sign2) Round the attribute in the T column to remove the decimal values. My thought after that was to use the attributecreator with:if(A[0]=@Value(pixelvalue),@Value(T),And then the aggregator and merge them with concatenation. Then finish it of with brackets to something like this with nested if statements:if(A[0]==0,22,if(A[0]==1,22,if(A[0]==3,22,...And feed it into the RasterExpressionEvaluator. This workflow does not seem to work since I can't get the RasterExpressionEvaluator to accept my nested if statements and write many different colors. Any suggestions on how to achieve what I am after? Color my raster based on the matching valu

1060
ebygomm
Influencer
D
dkirouac
asked in Transformers
Check JSON Coordinates For Correct Order

I have JSON files that I am reading and using GeometryFilter to create points. GeometryFilter is looking for the coordinates as long, lat. Some of the points in the JSON input are incorecly entered as lat,long. Is there are way to read the JSON coordinates and switch the coordinates to long, lat if they are incorrectly set to lat,long? For example:CHANGE FROM"geometry":{        "type":"Point",        "coordinates":[ 29.32991754843333 , -82.16997782090549]TO"geometry":{        "type":"Point",        "coordinates":[ -82.16997782090549, 29.32991754843333 ]Thanks,David

720
D
D
dutchtower
asked in Transformers
I'm trying to enter a user parameter to use in a String Replacer Transformer I've tried entering the values in the Details below and am stumped.

 Value in Source Data:DWGNAME,OLDHANDLE,NEWHANDLE,X1,Y1,TYPE,NEW_IDBDCV.dwg,3F7,16354,2181887.040872167,12004078.93869873,ROUTE,1233345The String replacer is defined like $(DrawPath)@Value(DWGNAME)Output from transformer:If DrawPath Parameter=C:\\ClientMaps\\C:\\ClientMaps DEFAULT_MACRO FME_DATA_REPOSITORYBDCV.dwgif DrawPath Parameter=C:\\ClientMapsC:\\ClientMapsBDCV.dwg I need the output to be C\\ClientMaps\\BDCV.dwgThanks

750
D
john_esk
Contributor
john_eskContributor
asked in Transformers
Symbolize point layer based on attribute in HTMLReportGenerator

I'm using the HTMLReportGenerator to display a map with points. In the "Label Attribute" setting I've combined several attributes. I want the points that contains a certain word to be in a certain color. In my example I have two different words that should determine the color, "KFF" and "SBF". The label attribute is a long string containing these and some other values ("Example: {3553} KFF). Is there a way you can achieve this with StringReplacer? If feature.properties.name contains KFF than set the color to red else set the color to green.

543
egge
Contributor
danii
Contributor
daniiContributor
asked in Transformers
Copy files from folder to another in BIM360/Autodesk Construction Cloud with Default Attributes

I want to copy files from one folder to another in BIM360/ACC with AutodeskBIM360DocsConnector, and in BIM360/ACC there is a Default Attribute column for Description. And when I copy them in FME the Description does not come with.  In AutodeskBIM360DocsConnector there is no option in Attributes to Add called Description.  Any suggestions for how I can get the Description in the copy process? 🙂 

4290
danii
Contributor
geovision
Contributor
geovisionContributor
asked in Transformers
Reprojector: Reproject: Could not reproject the geometry of the preceding feature

Im trying to change the crs of a shapefile. It needs to be in the same as below:When using the Reprojector transformer Im getting an error Transformer parameter:After running the workspace Im getting the following error:Reprojector (TeeFactory): Reprojector: Reproject: Could not reproject the geometry of the preceding feature: Unknown coordinate system 'EPSG4326' specified - abortingReprojector: Reproject: Could not reproject the geometry of the preceding feature: Unknown coordinate system 'EPSG4326' specified - abortingTranslation FAILED with 4803 error(s) and 2 warning(s) (0 feature(s) output) When using the EsriReprojector transformer the workspace runs succesful but the srs is as follows: Question: Is there something wrong with my FME? Or am I using the wrong parameters. Thanks.

6210
geovision
Contributor
joneszero
Contributor
joneszeroContributor
asked in Transformers
Shapefile Writer Issue (missing .prj file)

I'm processing a point feature class (21 million approx points) I'm fanning them out into shapefiles, smaller than the 2G limit. It produces shapefiles, missing the .prj file. Any thoughts on why ?

1370
joneszero
Contributor
dallas2011
Contributor
dallas2011Contributor
asked in Transformers
Database export

Hello, I would like to ask how to solve this problem,that there are several databases. In line, polygon, point and text formats. The question is whether it is possible to create an excel file that contains all database names, as well as what attributes are there as well as attribute names and alias names. In addition to this, what are the results in the attribute table and the corresponding domain names.And export it to xlsThanks in advance

340
danminneyatsaf
Safer
P
prive
asked in Transformers
Does FTPCaller consider sftp/ftps URL the same way ?

Hello everyone, I searched a lot about this topic but nothing matched the same problem. I have a functionnal ftps URL that return the good file in filezila. But when using it with the FTPCaller, it return a timeout. Whatever the parameters are.But if I declare the URL as a SFTP, it does the job.  It work here because the server do accept the query with sftp but if not, I am afraid I'll be block with the ftps only.Does someone face the same problem ? Did you find why and how counter it ? Thanks in advance ! Have a good day.

570
danminneyatsaf
Safer
R
robyn_studts
asked in Transformers
Translating from Smallworld to MicroStation using 2018 works fine but using 2020 the text is not translating correctly. I am using the same FMW file and the same Coordinate file.

I have tried a bunch of different coordinate combinations to find one that may work. Using the one that I have always used the objects translate in the correct location, but the scaling is incorrect. Other coordinate systems the text is the correct scale but not in the correct location. I am translating from NAD27 mm to NAD27 ft. looking for an answer so we can move forward with a software upgrade. See below for coordinate info that I am using. # KB 01/11/2013 - SRP database projectionCOORDINATE_SYSTEM_DEF SRP_AZ_Central_mm               \\ DESC_NM     "SRP Arizona Central NAD27 millemetre"  \\ SOURCE     "SRP GIS"                 \\ DT_NAME     NAD27                   \\ PROJ      TM                    \\ UNIT      MILLIMETER                \\ PARM1      -111.9166666666667            \\ ORG_LAT     31                    \\ SCL_RED     0.9999                  \\ X_OFF      152400305.0                \\ Y_OFF      0                     \\ MAP_SCL     1.0 # KB 01/14/

100
R
vxn43
Supporter
vxn43Supporter
asked in Transformers
Exclude 1st Row of Excel Table

I have an Excel file (table). How do I prevent it from reading the 1st row of the table?

2190
dustin
Influencer

Badge Winners

  • Welcome Back
    osalexhas earned the badge Welcome Back
  • FME Certified Professional
    mkastelijnshas earned the badge FME Certified Professional
  • Teacher (Grey)
    -o3-has earned the badge Teacher (Grey)
  • Student (Bronze)
    bhavyagandhihas earned the badge Student (Bronze)
  • Student (Grey)
    bhavyagandhihas earned the badge Student (Grey)
Show all badges

Community Stats

31,807
Posts
120,824
Replies
39,436
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.