Skip to main content

Transformers

Using transformers to modify data.

  • 12,966 Posts
  • 51,742 Replies
10000 Posts
G
georgefloros
asked in Transformers
Geometry Coercer generates additional geometries when converting to IFC

Hello Everyone, So I am working on some IFCs and this is my workflow: -I am extracting the "Body" geometry of IFCs -I am using the Deaggregator (Flatten 1 level) -I am using the GeometryCoercer to convert to composite surface. So, the input in the Coercer can be show in figure named "Original". The output of the Coercer can be found in figure named "Coerced". It duplicates specific parts and I have noticed that these parts are CSGSolids, while the parts that are properly coerced are BRepSolids. Any ideas on how to tackle this? The reason I am converting to composite surfaces is to convert to CityGML. Thank you for your time. Kind regards, George Floros

350
daveatsafe
Safer
G
geojulien
asked in Transformers
Apply password protection from fme command-line

I've read about the encryption of FME files (see this topic). I would like to know if it's possible to encrypt FME files (especially *.fmw) with a password from the fme command-line. I tried to run: fme PROTECT ./in_clear.fmw ./out_encrypted.fmw but i didn't find any password parameter and no prompt either. Use case: batch fmw encryption of a set of workspaces after development work and to deploy.

320
mark2atsafe
Safer
T
travisd
asked in Transformers
workbench shortcut view

Hello I am fairly new to using FME. I do however use multiple FME workbenches. I generally access them via Windows Explorer. I'd like to see display page in FME that shows all of my workbenches as shortcuts where I can run each separate workbench from. Effectively click on the the shortcut button and run the workbench. Cheers TravisD

40
mark2atsafe
Safer
G
georgefloros
asked in Transformers
Keeping unique values from multiple Excel columns

Hello, I have an Excel file that consists of 171 columns. I would like to keep the unique values for every single column. I tried the DuplicateFilter but it returns me the unique values of only the 1st column. This means I would have to repeat the process for 171 times. Do you reckon that Python is a one-way road? I would appreciate your thoughts on this. Thank you for your time. Kind regards, George

1470
jdh
Contributor
hansgm
Contributor
hansgmContributor
asked in Transformers
DWG TO DWG - Reproject Dimension

Hi i want to reproject a DWG with dimensions and write to a new DWG. (RealDWG) I use the CsmapReprojector and the Data Inspector Shows that all coordinates are reprojected, but in the DWG the dimensions remain at the old coordinates. Polygon is projected and written to the new coordinates, as it should be. Does anybody know why? Did i forgot any Option on writing? Template is attached. Workspace is FME 2017.1 but 2018 produces the same result. Thanks

900
hansgm
Contributor
L
lemzip
asked in Transformers
HTMLReportGenerator - Map position

Hi All, Hopefully an easy one. Using the leaflet map option from the HTML report generator. Is there a simple way to position the maps centrally instead of width 100%? Thanks

272
L
4
40_eme
asked in Transformers
AreaOnAreaOverlayer Mystery

Hello, I send 2 shapes each containing a fully populated field for each record in an AreaOnAreaOverlayer. I get a shape with the table below. Each of these 2 fields comes from one of the 2 shapes. I do not understand why not all records are filled in for each of the 2 fields ? Thank you

190
mark2atsafe
Safer
aron
Supporter
aronSupporter
asked in Transformers
Selecting square-ish donuts

I have depth zones where there are some square-ish polygons that once where covered by depth labels. These labels are no longer used and the square areas have become an eyesore. They are not terribly important so I would like to remove them all together. Please note that there are other areas and donut holes that should not be touched. My question is twofold: * How do I mark only the square-ish areas? (for later deletion) * How do I mark only the square-ish donut holes? (to be closed with donutbuider)

140
mark2atsafe
Safer
jwbroadhead
jwbroadhead
asked in Transformers
Does TwilioSMSSender only allow 1 phone number at a time?

I tried to provide 2 phone numbers separated by a comma but it looks like it just removes the comma resulting in 1 long numeric string - which fails. Also tried with the full +1... in front with comma and space and same thing. It parses out all non-numeric characters/spaces. Is it possible to adapt the transformer to allow CSV?

50
mark2atsafe
Safer
Y
yzthr
asked in Transformers
How to transform .rvz BIM data into 3d-tiles cesium.js format?

Hello, i'm new in FME. I don't know how to transform .rvz BIM data into 3d-tiles cesium.js format. I use FME-revit plugin to convert the .rvt to .rvz. Next, I add a reader in FME to read the converted .rvz data(IFC). Then i add a transformer(writer) to write the data into CESIUM3DTILES format. But the translation failed.

900
virtualcitymatt
Celebrity
V
vazquezsuarezyo
asked in Transformers
RasterExtentsCoercer in a directory with multiple raster

Hi, I am trying to get the footprint of multiple rasters that are stored in the same directory. I am using a Directory and File Path names to read the directory and the RasterExtentsCoercer transformer to generate a shapefile with all of them. But only works when the reader is a single raster. Any idea? Thank you

290
mark2atsafe
Safer
fer_ruiz
Contributor
fer_ruizContributor
asked in Transformers
point to raster

hi, i read some question from other user. But i don´t read what i need. from to xml i create vertex and i don´t know what i do to create the raster. i use "imageRasterizer" but i have a error and no create it. is the log file.

1070
fer_ruiz
Contributor
A
avansickle
asked in Transformers
Working with Archived Non-Versioned ArcSDE data in a SQLExecuter

I am trying to use the SQLExecuter to identify records from an archived ArcSDE database where the ID does not exist in another table by utilizing the _matched_records output. My SQL Statement is this: Select SCRD_ID from gis.STREET_CENTERLINE where SCRD_ID = '@Value(SCRD_ID)' I know that SCRD_ID: 3745 does not exist in the STREET_CENTERLINE table, but because this data is archived it is coming back with a _matched_record count of 2 instead of 0 Does anyone know how to only read/query the CURRENT data from the ArcSDE database?

170
A
J
joy17
asked in Transformers
how to duplicate shapefiles X times and join data from table(s) to the shapefiles

Hi everyone, Here a newbie queston. I want to duplicate a shapefile 18 times (instead of manually duplicating the shapefile) and then attach information from 18 tables to those shapefiles based on the key value: NamePark. I tried the Cloner, however then instead I got a shapefile with so many features, so I was wondering what to do instead So basically I have two questions: 1) Is there a transformer available to copy/duplicate a shapefile X times 2) How can I join the tables to the shapefiles based on a key value. I looked at featurmerger, but I cant find the key values. I have attached an image of my current workflow

260
gio
Contributor
R
regulusdeneb
asked in Transformers
How to copy FME format attributes

I am using FME Workbench 2018.1.0.1 in Windows 10. I am inputting a kmz file. The only parameter I am reading from it is PLACEMARK because I see no reason to read the others. I need to copy format attributes kml_name and kml_description to NAME and CAPACITY, respectively. I don't see in the AttributeCopier transformer where I can do this. Its Import Wizard does not seem to be made to do this

130
mark2atsafe
Safer
M
mariofederis
asked in Transformers
Calculate difference in hours between two strings

I have two string fields (TimeStartedCTZone, TimeEndedCTZone) formatted as shown below. How can I calculate the difference in Hours despite having strings as inputs instead of datetime data types?

31920
M
P
peterx
asked in Transformers
Error in DateTimeCalculator

In 2016.1.1, when trying to add 10 hours to a DateTimeCalculator I receive the following error: DateTimeCalculator_DateFormatter: @Tcl2 -- failed to evaluate expression `DateTimeCalculator_DateFormatter_formatter {FME_NULL_VALUE}' -- wrong # args: should be "string range string first last" What am I doing wrong? Screenshot seemed to fail upload. Attribute(encoded: utf-8) : `Last_edited_date' has value `20180601010111'

440
gio
Contributor
H
hannesfpaulin
asked in Transformers
Set time limit for specific workbench or transformer

I have a script which is fetching multiple images with an imageFetcher. Sometimes the external services stops responding and the script never stop running. See pic attached showing the last rows from the log. To avoid building a never ending queue I would like to limit this specific script to 15 minutes but I don't find any built feature. I have tried some python callers like timer and time.sleep but nothing really matches the requirement. Any suggestions?

420
H
J
johnwk
asked in Transformers
Joining polygons together until an attribute range is satisfied

Hi, I've been racking my brains trying to think of a solution to this problem for a few days and no inspiration is coming my way! I have a series of polygons containing populations. The goal is to create bigger polygons from these until they are all within a certain range of population (e.g, between 2000 and 10000). It does not matter if these become multipart polygons. I have used Dissolvers and Aggregators to combine where polygons are touching, however sometimes the populations in the resulting polygons are either: too big (where there is a large cluster of intersecting polygons) or, too small still (because they are not intersecting any other polygons). I have thought about using some form of looping transformation where there are iterations of joining polygons together until the population range is met, then filtering those out and performing the loop again with the remaining polygons. Sorry, it's a bit of a specific question - but if anyone has any ideas around this I will be mos

1010
J
F
fariyafarhad3
asked in Transformers
Finding beginning and ending intersecting streets

Hello Everyone, I have a network of local roads and I need to find the intersecting "from" and "to" streets for select road segments. For example, in the following image, for the circled segment of Hendon Ave, I need to be able to identify that the segment goes from "Grantbrook St" to "Carney Rd". Order doesn't matter. It could be from Carney Rd to Grantbrook St. My network is fully segmented at each intersection. Each segment has the attributes "from_node" and "to_node". The image below shows a typical segment within the network. I am having a hard time identifying the "from" and "to" streets. I tried using spatial relator, which successfully gives me the related candidates. But in a case like this, I will get 4 related candidates. I considered using linejoiners to join Street B and Street A, but I will lose the from_node and to_node information. That information is useful when I have more than 4 related candidates. For example, for 4 way intersections on both ends. The result I need

430
jdh
Contributor
L
lanthar
asked in Transformers
Experiences in moving polygons from file ESRI GeoDB to Enterprise geodatabase SDE with geometryvalidator and geometrypartextractor

This is more to document the trials and issues I encountered writing from a file geodatabase of polygons to an SDE instance with polygons. While one would think that polygons stored in one ESRI format would be fine when written to another and not need validation, that is not the case. Here are the issues i encountered when I switched to FME to find and bypass a bad feature that killed my dataload because of a tiny nearly collinear triangle with area of 1x10^-20... First I tried to just insert straight from GDB to SDE. This gave me the error: An error occurred while attempting to insert a row into the table 'PARCEL_DATA' using a cursor. The error number from ArcObjects is: '-2147215968'. The error message from ArcObjects is: {Linestring or poly boundary is self-intersecting} Then I tried to run geometryvalidator, with these settings, sending both passing and repaired polygons to sde. This gave me the error : Cannot write a non-area feature to an area feature class Further investigation

730
tim_wood
Contributor
tim_wood
Contributor
tim_woodContributor
asked in Transformers
SQL Server CLR error when using SQLExecutor to run STWithin

I'm using SQLExecutor to fire queries like this at an SQL Server Spatial point layer (Geometry data type), except the polygon geometries are much more complex: SELECT Count(MyField) AS CountMyField FROM [db].[owner].[table] WHERE WKB_Geometry.STWithin(geometry::STGeomFromText('MULTIPOLYGON (((527049.5 137150.4,527056.6 137139.7,527063.3 137134.4,527049.5 137150.4)))', 27700)) = 1 However, after about 2400 features have entered the Initiator port, I get this error and the translation fails: "The app domain with specified version id (%d) was unloaded due to memory pressure and could not be found." Ultimately I will be processing hundreds of thousands of features so I need a solution that will work with that volume of data, not just a few thousand input features. I know I can read the point layer in to my Workspace, but SQLExecutor is SO much faster. Any suggestions?

190
tim_wood
Contributor
D
daniellangan
asked in Transformers
Read Data Stored in Log Files?

Hello, Internal auditors are asking me whether any data that is read into FME via a reader is ever detailed in any log files. Does anyone know whether this ever happens? I'm assuming not, but thought it best to check. This is not referring to statistical data that Safe may collect, but data sets we read into FME. Thank you, Daniel

60
david_r
Celebrity
checcosisani
Contributor
checcosisaniContributor
asked in Transformers
Collapse Dual Lines To Centerline

Hi do you know if it's possible to replicate the action Collapse Dual Lines To Centerline in Arcgis also in FME. I tried the centerline repacer but it works with polygons but I have lines not poly (and I don't want to convert lines to polygons). Can you help me ? thx Francesco

1190
pratap
Contributor
K
kai_himself
asked in Transformers
NAS2Shape

Hey, i like to transform NAS Files ((German AAA GML Exchange Format(NAS) OpenData like fachinformation_11001_dba.xml) in a shapefile that can i open with a GIS program. In total, i have 65 NAS Files, the problem i got is, i need for every file a new reader and writer, is it posiible to transform the data with one reader and one writer ? The filename can be the same, like this... fachinformation_11001.xml ----> fachinformation_11001.shx (simplified) Regards Kai

500
K

Helpful Members This Week

Badge Winners

  • I Dig JSON
    takashihas earned the badge I Dig JSON
  • Integrate Data with the FME Platform Training
    mramsayhas earned the badge Integrate Data with the FME Platform Training
  • Teacher (Grey)
    aaannashas earned the badge Teacher (Grey)
  • Welcome Back
    mseagren839has earned the badge Welcome Back
  • Student (Grey)
    aaannashas earned the badge Student (Grey)
Show all badges

Popular Tags

Community Stats

31,148
Posts
118,080
Replies
38,765
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.