Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,721 Replies
10000 Posts
G
gisgis
asked in Transformers
How do I make coordinates invisible on Web Map created with "HTMLReportGenerator" ?

I have made a beautiful Map using "HTMLReportGenerator". This Web Map contains coordinates of points or lines that I dont want to be shared with the World if I publish it online (because of data protection). Is there a way I can somehow make invisible those coordinates so that if I inspect the HTML page I will not be able to see all the coordinates ?

100
nielsgerrits
VIP
jonas_nelson
Enthusiast
jonas_nelsonEnthusiast
asked in Transformers
How to find the objects which are GeometryCollections

I have some database tables which contains a few so called "GeometryCollections". I try to use FME to find which objects are of that type so that I can fix them, but none of the alternatives in GeometryFilter will find the GeometryCollection objects. Any suggestions?

1160
ebygomm
Influencer
ingalla
Contributor
ingallaContributor
asked in Transformers
Split polygon based on nearest neighbour

HelloI have a polygon, which is a single feature and need to clip it where the road name changesThe data i have is the polygons adjacent to the road, and the road centreline. I have created a centre line through the polygon, chopped that centreline into 1m segments and applied the nearest neighbour roadname to them.Any ideas how to chop the polygon where the name changes as shown in the redline on the image attached.Regards 

650
ctredinnick
Supporter
kiabee
Contributor
kiabeeContributor
asked in Transformers
I understand can use the coordinateSwapper transformer to switch Y <> Z values in the wavefront obj file. But can I also change the sign of the y-values (says from -ve to +ve) as well?

I understand can use the coordinateSwapper transformer to switch Y Z values in the wavefront obj file. But can I also change the sign of the y-values (says from -ve to +ve) as well?

60
kiabee
Contributor
pearly1
Contributor
pearly1Contributor
asked in Transformers
How to separate text into attributes?

 Hi, New to FME here. I have been tasked with creating a workbench to convert DWG to GIS (storm water asbuilts). Below is the autocad text string field which contains three rows. first structure name, Top elevation and on invert elevation. I would like to know a way to separate this into three fields. I have created the fields with Attribute manager but have no idea how to parse this out.  I was thinking it could be based on line row number? Since Multiple types of structures and line is always structure name, line 2 is always top, and line three is always Invert elevation.  Thanks! 

9380
nielsgerrits
VIP
Z
zacharylee1204
asked in Transformers
How to compare two columns. If it is matched, change to the new value

Dear Sir / Madam, So I have two excel tables. Mother name.xlsx is the original data and waterbody.xlsx is another table. So I would like to compare two excels. If both excels' column "ModelName" are matched. The mother name excel's model name column should change to newmodelname column. If not, just keep the original modelname. I try to use tester transformer but I am not sure why nothing can be matched. I hope someone can give me a hand. The output that I want is in the Output.xlsx Thank you very much. 

590
nielsgerrits
VIP
N
nassira
asked in Transformers
transfer of georeferencing information between IFC and CityGML

Hello Community, i want to know how is the transfer of georeferencing information is done between IFC and CityGML. Like is there any FME documentation that covers this subject?Thanks in advance.

360
daveatsafe
Safer
Z
z.ain
asked in Transformers
Replace/overwrite layer with a different name in geodatabase and update to GIS map

Hi, I am a new FME user and hope someone can assist with my issues. I have to update weekly utilities data from .12dxml to geodatabase. From thegeodatabase, I have to create a map in ArcGIS Pro and publish it to ArcGISOnline. I just run the FME and overwrite the map whenever I receive data toupdate. I have no issues doing it since I just overwrite the data for everyupdate.However, the team requires me to add the date to each of the layer names e.g.:utilities_electricity_20221025.Previously it was just utilities_electricity.Hence, I couldn’t overwrite the data into the gdb. It will create a new layerinstead since the layer names are different every time I update the dataweekly. eg:utilities_electricity_20221025(for week 1); utilities_electricity_20221104 (for week 2). My questions are:1.      How to overwrite/replace the layer with a different name? E.g.: utilities_electricity_20221025(old data) replaced with utilities_electricity_20221104(new data) in gdb?2.      How to make sure the m

630
Z
M
michaeld
asked in Transformers
Measure calculator is working but need measures on points and lines with identical attribute details

Hi all. I've got the measure calculator working with the standard measure generator/pointonlineoverlayer/measure extractor routine. In many cases points are close to two or more line however there is a common attribute between a point and the line. How do I go about using the common attribute detail to calculate the measure. That is a want the measure of Point 1,2...n with attribute "x" calculated on line 1,2...n with attribute "x". Kind of like preventing them from snapping to the incorrect line. The other issue is not all points fall on the line but are very close so a tolerance needs to be introduced. Hope that makes sense. Thanks,Michael

70
maica
Contributor
pkno
Contributor
pknoContributor
asked in Transformers
Fanout with dynamic tables in HTML Report

Hello everyone, I have a dataset with a lot of columns which do not contain data in every row. It is structured something like this: What Im trying to do is create HTML-Reports for each Row but excluding the empty columns in each individual report, basically creating something like this: Table in HTML Report 1Table in HTML Report 2Table in HTML Report 3 Group Processing gets me halfway there but sadly keeps unnecessary columns. Is there a way to do this in FME? Any help appreciated.

234
ebygomm
Influencer
karloz9999
Contributor
karloz9999Contributor
asked in Transformers
Hi, I have an attribute by the number 0821 and similar which I want to add next to another counter attribute that starts on 01 and goes on 02, 03 etc. My attrbute KnKod_1 looses the leading 0 to the left. See expression in Arithmetic ed. in the pic

Hi, I have an attribute by the number 0821 and similar which I want to add next to another counter attribute that starts on 01 and goes on 02, 03 etc. My attrbute KnKod_1 looses the leading 0 to the left. See expression in Arithmetic ed. in the pic.

45
nielsgerrits
VIP
P
prateek
asked in Transformers
Convert Date in format 2023-09-13(YYYY-MM-DD) to Timestamp in milliseconds

We want to convert Date in format 2023-09-13(YYYY-MM-DD) to Timestamp in milliseconds 1694563200000 using FME Transformer but no FME transformer is able to convert date to milliseconds.For example 2023-09-13 -> 1694563200000

972
ebygomm
Influencer
thijsknapen
Contributor
thijsknapenContributor
asked in Transformers
HTTPCaller results in SSL connect error, but HTMLExtractor works, why?

Like the title states, a while back I encountered a situation in which I obtained an SSL connect error when using the HTTPCaller.In my case I wanted to fetch some 'table information' from a website, and I noticed that using the HTMLExtractor for this job did work for me.  In the end the HTMLExtractor sufficed for my usecase, but I'm still curious on why the HTTPCaller resulted in the SSL Connect Error. Also, I can imagine that maybe in the future I would like to use the more advanced functionality of the HTTPCaller here (e.g. 'Retry Failed Requests' or 'Rate Limiting'). See below screenshot and attached workspace for some more information.Is there maybe someone that has a clue on why I obtain an SSL Connect error with the HTTPCaller? Within the HTTPCaller, I tried tweaking the settings a bit, in particular the 'SSL/TLS Options' and the 'HTTP Client Options';SSL/TLS OptionsChanged 'Verify SSL Certificates' to 'No'Changed 'M

370
matthieuv
Enthusiast
J
janghanie1
asked in Transformers
A problem of flipping CityGML Appearance

Hi guys, I am working on a 3d building model conversion to cityGML​I have several openings and I tried flipping them with their original geometries​I set the gml_geometry_reversed attribute and used GeometryPropertySetter(gml_geometry_reversed, xlink_href) to make the orientableSurface as followsthe orientable surface was successfully generated but when I open the file with the inspector its appearance was flipped in wrong waythe windows and doors are supposed to be like this I GUESS the appearance part in the document must be written incorrectly(specifically, <app:inFront>fasle</app:inFront> part)this is true part​and this one is false partthe order of the coordinates is the same for both parts...I am not sure this has something to do with the flipping issue I have no idea how to edit the transformers and fix this problem please help me solving it...!!😂  

150
J
M
minjoo
asked in Transformers
transform dxf to gltf

want to know detail process convering dxf to gltf

610
saraatsafe
Safer
J
jkh
asked in Transformers
Hi, Can please someone help me with calculating percentage change (X2-X1)/X1*100 for column Value when grouped by column Category. More specifically, how can get table 2 from table1.

In table 2, the percentage change was calculated separately for each category of A, B, and C. I'm using FME2022. Table 1Table 2

590
J
vimva679
Supporter
vimva679Supporter
asked in Transformers
Suitable READER for LEICA Equipment data .....?

I would like to import the Control points from Leica TS10 into FME https://leica-geosystems.com/en-gb/products/total-stations/manual-total-stations I would like to import the Point cloud from Leica RTC360 into FME https://leica-geosystems.com/en-gb/products/laser-scanners/scanners WHAT KIND OF READER I use to read the data into FME , I didn't find any so if anyone is aware of ???

1070
kailinatsafe
Safer
ebygomm
Influencer
ebygommInfluencer
asked in Transformers
AttributeValidator - setting all invalid attributes to Null

Is there a straightforward FME way to set all attributes exiting the failed port of an AttributeValidator and listed in the validation message list to null? I have a very straightforward bit of python to do it, but my brain is failing me this afternoon on an FME methoddef FeatureProcessor(feature):    for i in feature.getAttribute('_fme_validation_message_list{}'):        attrname = re.search(r"(?<=Attribute \')\w+",i)        feature.setAttributeNullWithType(attrname.group(0),fmeobjects.FME_ATTR_UNDEFINED) 

1634
ebygomm
Influencer
sc1
Contributor
sc1Contributor
asked in Transformers
Is it possible using FME / Python to detect a number in a PDF file and copy that number to the file name of the PDF and change it accordingly? Subsequently write the PDF file with the changed file number as output and save it on a specified location.

The number always begins in the PDF file with "Registratienummer: the number I want to copy"

120
kailinatsafe
Safer
edward_skanska
Participant
edward_skanskaParticipant
asked in Transformers
Is it possible to truncate a sharepoint list within FME before writing into it?

Hi there Just as the title says. I know how to do this with a shapefile within the writer but I cant see the same options within the sharepoint list writer Thanks in advance-Ed

110
j.botterill
Influencer
angwan
Contributor
angwanContributor
asked in Transformers
Setting up user parameter to auto populate attribute values of a particular field associated with a specific parameter when one parameter value is selected(chosen)

For example, projectname: X has a MethodType:Vegetation. When one chooses Project name X, MethodType:vegetation should autopopulate. This ensures correct method type gets picked up without spending time to identify the methodtype for that projectname especially if there are many methodtypes.

170
joepk
Influencer
deanhowell
Influencer
deanhowellInfluencer
asked in Transformers
Group By result not as expected with PointOnLine and NeighborFinder

FME Form 2023.0 I have four datasets, three line datasets which I add an attribute to distinguish it from the others, this attribute is called MaxLength. The forth dataset is a point dataset. The three lines datasets are run together and then run I a pointonline with a groupby using the MaxLength attribute in the line datasets but I get no matches. If I remove the groupby then I get results.  Is the above possible with the group by or do I just need to run the pointonline with each line dataset separately?  

240
deanhowell
Influencer
lsugumar
Contributor
lsugumarContributor
asked in Transformers
Transpose attributes values into column names

Hi, I am trying to automate creation of template file from different forms into Excel spread sheet. There are many forms to extract information from. I am trying to first create a template of the column headers for each form into separate excel spread sheet.​I managed to get all the column headers as a feature within each form_id as seen below.As you can see there can be many forms (form_id is unique for each form) and within each form_id i have column headers (label). how can I transpose these labels as column headers in excel (1 excel template for each form) and write them out in excel? I have seen e.g. transposing columns into headers, but I'm not sure what I can do when I have dynamic number of forms and each form can have dynamic number of columns. Any help is much appreciated!

3050
debbiatsafe
Safer
A
arashjazini
asked in Transformers
Hi, I have two line features and would like to update an attribute on feature "A" from feature "B" if they are intersected to each other, is there any specific transformer or work flow fo this task?

80
A
hermann
Contributor
hermannContributor
asked in Transformers
Can I // How can I use the AttributeFilter transformer, without _prior_ knowledge of the AttributeValues?

For eksample: Features with the same UUID shall be used later in the workflow. But I don't know what UUIDs will be in the Input data. I can geneate a list of unique UUIDs at runtime and would like to use this list in the AttributeFilter, defining the AttibuteFilter-ports. Would // How would this be possible?Thank you.

130
pratap
Contributor

Badge Winners

  • Welcome Back
    armando_amadorhas earned the badge Welcome Back
  • Teacher (Bronze)
    probert1968has earned the badge Teacher (Bronze)
  • Webinar Watcher (Grey)
    arxit_cbuhas earned the badge Webinar Watcher (Grey)
  • German Speaker
    janakhas earned the badge German Speaker
  • English Speaker
    janakhas earned the badge English Speaker
Show all badges

Community Stats

31,818
Posts
120,852
Replies
39,447
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.