Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,712 Replies
10000 Posts
H
harshal.gharat
asked in Transformers
SQL Creator: OCI_NO_DATA /fetch out of sequence error

I have sqlcreator which has simplest ever query which selects all fields from a geodatabase table. The SQLCreator does give out the result in an inspector but at the same time throws the following errors.What am I doing wrong here?FME Desktop: 2018.0.1.1

540
dellerbeck
Contributor
R
robinb
asked in Transformers
AreaGapAndOverlapCleaner - how to produce list of issues found

Dear FMExperts,I am using the AreaGapAndOverlapCleaner transformer to find geometric issues within a polygon dataset. I can output a list of all the features affected, but what I would really like to achieve is to produce a list of each instance where a geometric error has been discovered, what the issue is, plus the coordinates for the location.So something like this for each found error:FEATURE_IDISSUEXY123Gap123654244440124Gap123887249486124Overlap6454772757154 TIA,R

190
R
L
laurenceo
asked in Transformers
Multiple instances of attributes missing when reading in XML

Hi, very new to FME so I'm sure there's probably a very easy fix for this but I can't seem to find one anywhere. I have an XML file I'm trying to read, and one of the attributes has a one-to-many relationship with the parent feature. When reading in the XML, the data for this attribute will be read in when only one instance of the attribute occurs. Where multiple instance of the attribute occurs, the field is missing. Example below: The attribute <Activity> is read successfully for instances like this in the XML file:<FacilityReport><NationalID>Example1</NationalID><Activity><RankingNumeric>1</RankingNumeric><ActivityCode>5.(b)</ActivityCode></Activity></FacilityReport> But <Activity> will be missing for instances like this:<FacilityReport><NationalID>Example2</NationalID><Activity><RankingNumeric>1</RankingNumeric><ActivityCode>5.(b)</ActivityCode>&lt

302
L
A
aleksandar
asked in Transformers
SQLCreator as Reader

Hi all,  I used views in SQL Server Spatial as source dataset/format in FME. Inside the views I created geometry column. Now, I need to make Stored Procedure instead of view. My question is: What are differences by using SQLCreator as "Reader" instead of real Reader? What about performance and so on? Is there some better solution or?

1598
jt
Contributor
notmyname
Participant
notmynameParticipant
asked in Transformers
Python caller input feature replace with new feature

Hello,This question is primarily caused by this being my first python class implementation in FME. The basic question is? How do I output a new set of features while not outputting the original ones? Details below:I am reading in a set of features to a python caller -class-appending them to a dictionary which in turn is converted to a pandas dataframe for analysis on the set of dataIssue: I have been having trouble outputting the new data in the way I want to:What I wanted to do was "drop" the original input fme features and create a new set of features with the new values based on the dataframe. I wanted to do this as I thought it would be quicker than matching the new values to the original input featureThe issue is shown in the last loop of the code where newFeature = fmeobjects.FMEFeature() is used to create a new feature and assign attribute values, but in the end I am calling self.pyoutput(newFeature) which I believe is referring to the object created from the input featuresHow c

3280
david_r
Celebrity
K
keplerleee
asked in Transformers
The AreaBuilder not working !

I am going to make CAD into 3D models ,and I encountered some problems in this process.The original data file geojson (pre-transformed DWG into geojson file), fmw has been uploaded, and the WALL layer is taken as an example.The original data screenshots are as follows:Problems encountered:1. For the first attempt, the “Build Internal Edges (Advanced)” parameter in AreaBuilder is set to Yes, and “Snapping Type: Vertex Snapping && Snapping Tolerance: 0.01e” is set. Although all the Features are not lost, there are still some features ,which was no build, and some area with duplicate edges !Why is the "Build Internal Edges (Advanced)" parameter set, but it does not work? Why some area with duplicate edges ? 2. For the second attempt, use GeometryCoercer/TopologyBuilder to convert all the areas into lines, then overlap all the lines, then build the areas with AreaBuilder. The results show that some features in the OutputPort of AreaBuilder are missing, as shown in the

930
K
E
em_fme
asked in Transformers
Fastest way to merge many overlapping lines?

I've got around 15,000 route line features I've generated from a ShortestPathFinder and want to combine these into one feature. Every line overlaps every line as the routes were from lots of addresses to one place. I've tried using a LineonLineOverlayer which works perfectly on smaller datasets but here the merging is taking days.I'm sure there's some clever way of splitting my dataset up and speeding up this process, or maybe there's an entirely different approach to doing this, or maybe even the ShortestPathFinder can be configured to output all routes as one feature?Appreciate any suggestions , Thanks!

2610
E
A
abeklaas
asked in Transformers
How to upload a shapefile or geotiff to geoserver with FME

How to upload a shapefile or geotiff to geoserver with FME

2280
A
thierry
Contributor
thierryContributor
asked in Transformers
Why is FME unable to read AUTOCAD block attributes marked as "constant" ?

Hello,i'm trying to solve a problem with AUTOCAD dynamic blocks. I'm looking for the original name when they come with "*Uxxx" name.I created an invisible attribute "HIDENAME", defined as "constant" in each block definition (Autocad user's must not see it). The value of this attribute matches the original name.I don't see this attribute in FME Data inspector ...(ps : I don't want to explode blocks to solve the problem)

850
thierry
Contributor
H
harshal.gharat
asked in Transformers
SQL Creator cannot read SHAPE

I have a point featureclass and a geodatabase table which I have joined using SQL Creator. When I add an inspector and run the workbench, I cannot see any geometries from the featureclass which I have joined in SQL creator. Here is the query written in SQL creator.select a.FCGLOBALID,a.FEATURECLASS, a.OPERATION, a.PROCESSSTATUS,a.MXASSETNUM, b.ADDRESS, b.CITYNAME,b.DIVISION,b.FACILITYID, b.GISSYSTEMTYPE,b.GLOBALID, b.MXASSETNUM,b.MXCREATIONSTATE,b.MXSITEID,b.OPCENTER,b.PATROLNUMBER,b.SERVICENUMBER,b.STATENAME,b.STATUS,b.STREETADDRESS,b.STYLEDEFAULT,b.TOWNGASNAME,b.ZIPCODE, b.shapefrom arceam.pub_to_p_delta a left join arceam.p_metersetting bon a.FCGLOBALID = b.GLOBALIDwhere a.PROCESSSTATUS='N' and a.FEATURECLASS='P_METERSETTING'This query work fine in sql developer but when I run the workbench, the execution is successful but I get following errorsBADNEWS: File C:\apps\FME\metafile\oracle_spatialDef.fmi could not be opened (tabrdr_classic.cpp:2756 - tabrdr::ClassicTableReader::TableRea

5415
H
pflegpet
Contributor
pflegpetContributor
asked in Transformers
Updating JSON - better solution

Hi, I just started working with JSON files and could use some help with a specific workflow. I have a list of addresses stored as JSON where I want to remove certain objects/arrays that match with IDs from a reference list. In the attached example I want to remove the address with the ID 1 from the JSON file. The workspace already works but I'm sure there must be a more elegant solution for what I am trying to to. In my approach I expose the IDs with a ListExploder remove unwanted IDs via FeatureJoiner and then I reassamble the original JSON with a JSONTemplater/Aggregator/AttributeManager. It does the job but its not pretty. I already checked the very informative JSON tutorial but I could not apply it to my problem. Thanks in advance for any tipps on how to improve my workspace.

2600
deanatsafe
Safer
J
jayd3vl
asked in Transformers
Issue with Snapping for Snipper in Measure (Value) snipping mode

Hi There, I am building a workspace that generates point location based on measure using line features, it uses Snipper tools with Measure (Value) as snipping mode (screenshot below). I have two questions:I get this error in one of our datasets, where it shows a warning and FME just hangs. It seems like an issue with generating last point where measure is same as the highest value. I am not sure if this a data precision related issue or a Snipper transformer issue. 2019-04-24 09:43:22| 158.4| 1.7|WARN |@Snip (or FMELine::snip) was given Measures of 49447.77 and 49447.77, which are out of range for a line with min/max measures of 0 and 49447.77. Snapping params to closest valid value.2. How can I make sure that process proceed with remaining data and skips the record that has problems.Appreciate any input. ThanksJay 

840
J
stefanh
Contributor
stefanhContributor
asked in Transformers
How to find the best attribute type and string length?

I have around 35 gml-files, all with many attributes (25 attributes per xml). I am writing the files to an Oracle ArcSDE database. How can I find and set the best attribute type?In the writer all attributes are set to: type char | width 200 or 2048.Some of these attribute are dates or integers. Somehow FME is not defining the correct attribute type. Can this be done? Other attributes are indeed char but not with a width of 200 or 2048. Is there a way to find the string length for all attributes in once?I could set a StringLengthCalculator for each attribute, but that is an enormous amount of work.   

4709
xiaomengatsafe
Safer
I
ixodid
asked in Transformers
How Style DWG file ?

Very new to the FME world.If I have a DWG file that looks like this?What is the workflow to have the buildings and shadows look like this?Let's leave aside the road names and railway tracks for the moment and focus on the look of the buildings.

30
daveatsafe
Safer
T
tlabelleacc
asked in Transformers
Isolate first line of text using RegEx

Hi @takashi, do you have any ideas on how I would isoloate this first line of text in each 'cluster' of text? I have about 3000 to isolate.....The cluster formats are all the same but the first line of text varies in length.This information is stored in a text file at the moment and each clusters is separated by 1 character return.WGS84-YORK_LANDING-CZACDESC_NM WGS84 YORK_LANDING CZACDT_NAME WGS84PROJ LMUNIT INCH WGS84-CASTLEGAR_-CCT3DESC_NM WGS84 CASTLEGAR_ CCT3DT_NAME WGS84PROJ LMUNIT INCH 

3900
takashi
Celebrity
salvaleonrp
Enthusiast
salvaleonrpEnthusiast
asked in Transformers
html extractor mystery

This is my web page:http://solutions.arcgis.com/water/help/water-utility-network-configuration/DataDictionary/DataDictionary/I want to extract the text value of <div class = "agOverview agDetails spacing "> and the transformer finds the class but for some reason any Tag Part/HTML Attribute I use that's on the Property page of Google Inspector results to null. I also tried the drop down options (Whole/Value), tag #text and the result for the transformer is a feature with null value. Any ideas?   

1050
takashi
Celebrity
paalped
Contributor
paalpedContributor
asked in Transformers
Create a custom gml spesification

Hi,This is a bit hard to explain so I hope this drawing shows what I want.  I am trying to create a gml spesification where different geometry segments in a polygon feature is split into curvemembers only containing one geometry type. Basically when you have a boundary of line segments and arc segments, the gml will wrap a curvmember around every geometry type segment. as illustrated.I am using a GMLFeatureComposer so I have the ability to update each gml feature before writing it out with a text file writer. Should I use xmlupdator, or is it possible to do anything with the native geometry structure of IFMEPOLYGON to contain multiple IFMEPATH segments?

380
deanatsafe
Safer
A
akozielec
asked in Transformers
How to create a field that contains the minimum measure value of a polyline

The polyline is already measure aware. The field would be called "Begin Measure"I would also want another field that contains the maximum measure called "End Measure"Thanks

130
A
alc33
Contributor
alc33Contributor
asked in Transformers
HullAccumulator subdivision

hi!I would like to use HullAccumulator to create polygones around group of lines spatially apart, but I don't have any attribute to permit to use "group by" option.Do you have any idea to do that? I don't find a tranformer that permit to give an ID to a group of objects that intersect each other.Thanks!

340
alc33
Contributor
P
pk
asked in Transformers
British National Grid to WGS84 transformation causing shift

first step i have mapinfo tab file projected to OSGB-GPS-2015, when shown against a backdrop in ESPG:3857 a shift is noticeable and expected see below in universal translator  the ogr info for the mapinfo tab file is as below Mapinfo:  FME reads in the following manner FME:   there appears to be a difference in the datums being applied. this causes the shift to remain after transformation. have tried a number of different transformations but it would appear this shift is present on initial reading of the tab file in FME. is there a custom transformation and datum to prevent this shift? if so how would this be applied to a workbench? thanks in advance for any help.

1880
arnold_bijlsma
Enthusiast
zzupljanin
Contributor
zzupljaninContributor
asked in Transformers
DWG writing polylines with arcs and lines

Hi,I'm having problem writing polylines that consists of arcs and lines in AutoCAD. It seems it only happens when using Reprojector or similar. While writing arc part of polyline gets stroked in AutoCAD. Does anyone have any idea what am I missing? Cheers,Želimir

2060
zzupljanin
Contributor
cshir065
cshir065
asked in Transformers
Remove excess vertices on line segments without changing the shape.

I have a large dataset of line segments, which are both curved and straight. The problem is, some of the lines have hundreds (possibly thousands) of vertices. I would like to remove enough vertices without affecting the shape of the line. What is the best way to do this?

4350
cshir065
akeeri
Contributor
akeeriContributor
asked in Transformers
.geo translation

Can FME transform a file called .geo (its from an Topcon gps with Geopad software, Sweden)I cant see it among supported filetypes (i cant uppload it either)

130
canerakin
Contributor
H
har40428
asked in Transformers
Simplify a solid

I have a Revit file created by the design team. The model has a series of hugely detailed objects, hundreds of vertices detailing holes in walls, nuts and even a curved toilet seat. I want to reduce this detail and simplify the solids within the model to be able to import the file as an FBX into Unity where the detail is unnecessary.Traditionally this has been a manual task but being a 2D FME user for many years it feels like there must be a way of achieving this repeatedly within FME. I've tried the usual tools such as generalizer which doesn't seem to alter the model at all, in fact it adds more vertices. Any ideas?

1400
jovitaatsafe
Safer
F
fme_fan_mike
asked in Transformers
Special Step to engage Excel Reader's Bulk Mode in 2019.0?

Hello! I understand in 2019.0 the Excel Reader makes use of bulk-mode. However, I find it only to be marginally faster than 2018.1 when reading in the same large .xlsx file (9 min. 27 sec in 2019.0 vs 10 min. 53 sec in 2018.1). I have tried creating the reader from scratch in 2019.0. Is there a special step that needs to be done in order to engage bulk-mode? BTW, for 2019.0 I'm on build 19238. Thanks in advance!

70
F

Badge Winners

  • Welcome Back
    dcoxhas earned the badge Welcome Back
  • Welcome Back
    mglimsdalhas earned the badge Welcome Back
  • Webinar Watcher (Ruby)
    bchadhas earned the badge Webinar Watcher (Ruby)
  • Webinar Watcher (Grey)
    fme_studenthas earned the badge Webinar Watcher (Grey)
  • English Speaker
    jkenneyhas earned the badge English Speaker
Show all badges

Community Stats

31,806
Posts
120,814
Replies
39,430
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.