Skip to main content
  • EN

Best Answers

10387 Posts
A
anne_shanahan
asked in Transformers
how to select by location and field calculate

I wish to replicate the following workflow from ArcMap1. delete unnecessary fields from dataset table2. add in new fields and put a default value of "no"3. Using select by location, filter data that overlaps with another dataset and the field calculate the overlapping polygons with "yes"I need to do this for 40+ intersecting datasets and am new to FME. I have steps 1 and 2 complete but step 3 has me stumped. I've tried SpatialRelator, Spatial Filter, AreaOnAreaOverlay with no luck.

8972
A
R
raghunaren
asked in Authoring
Add a prefix to field values

Add a prefix that is a constant to all values of a certain field (attribute). For example: Name, Age are 2 values of a field then they are to be replaced by Old_Name, Old_Age

5102
R
E
edttom
asked in Authoring
How to update multiple attributes based on keywords?

Hi all,  I would like to update attributes bases on certain keywords. My reader consists of XML files, writing to an Access DB.I'd like to do the following:If in the column Official_name a certain keyword is detected I'd like to have the columns Category_main and Category_sub updated by various values.E.g. Official name is "B&B; FME City" - keyword B&B; is found and Category_main should be updated to Hotel/Motel, Category_sub is updated to "Bed & Breakfast & Guest Houses" Official_name Category_main Category_sub B&B; FME City Hotel/Motel Bed & Breakfast & Guest HousesMany thanks,  Ed

174
E
D
danielc
asked in Data
Why do I receive log message, "No AutoCAD Template file specified"

My workbench uses an s3downloader to acquire a DWG, then uses a FeatureReader (Autocad DWG) to read in model space data, then I add a few layers to model, using a FeatureWriter (Real Autocad DWG) with original DWG as a template, and finally upload updated model to s3, using an s3uploader.The workbench completes without any errors in the log, but my updated model does not contain any of my original layers. It only contains the newly added layers. Further, the log states the following, "No AutoCAD Template file specified". Yet, the FeatureWriter has a template file specified (I save the template file as a parameter).Any thoughts? Thanks for your support!

2116
fmelizard
Safer
fmelizard
Safer
fmelizardSafer
asked in Transformers
Speed up my translation using information from the FME log file

How can I learn how to speed up my translation using information from the FME log file?

71
fmelizard
Safer
E
ejmpost
asked in Transformers
Dissolver does not merge all geometries

Using FME Desktop 2016When I use the dissolver to merge geometries based on the same id I still get non-unique id polygons. I use the group by parameter on ID. Why could this be failing?

242
E
arxit
Contributor
arxitContributor
asked in Data
ArcSDE Geodb Writer - Write existing features to attributed relationship class

Hi,I'm trying to write existing features into a relationship class with the new SDE writer. My source and destination features already exist, and I want to populate the relationship class with the known PK of each features, but it seems impossible with this writer. I follow this article : https://knowledge.safe.com/articles/28340/working-with-geodatabase-relationship-classes-atta.html, but it seems we can only write to relationship class if we also write the corresponding features in their tables.Is there any way to write to a relationship class like a regular table?Thanks

475
fmelizard
Safer
X
xavigarciamar
asked in Authoring
Extension name

Hi everybody ,When I configure the Fanout output for a FME process like in the attached image , It generates me correctly the file , but without extension.Anybody knows how can I give the extension DGN to the output file ???.Thanks !!

72
X
lazarlubomir
Contributor
lazarlubomirContributor
asked in Transformers
Missing, null and empty string

Hello, Im still thinking about differences between attribute status... I understand difference between empty string value of attribute and null value of attribute, but what does "missing" value of attribute really mean please?Thank You so much for explain!

7031
david_r
Celebrity
X
xavigarciamar
asked in Authoring
Batch deploy for 2 inputs

Hi ,I have 2 input readers , a GDB an a DGN files , and 1 output DGN file , and I need to execute the process in a batch deploy , with a input directory and a output directory , but I don't know how can I do it if I have two inputs.With one input is easy , with a path reader sending any path input to a workspaceRunner , but with two diferent inputs ?? any idea ??.thanks for your help !!

96
X
J
jeffshobbs
asked in Architecture
Does anybody have any documentation on best practices for repository naming and permissions?

Hi,As of late I've noticed that we've got a lot of sprawl with the names of our repositories. Does anybody have any best practices/recommendations on how their organization creates repositories/topics/notifications and assigns permissions?One thought I had was to create a repository per application and also per department/organizational group as needed. But I'm wondering if anybody else has any other ideas/thoughts on the matter. In addition, my thoughts really only apply to repositories and don't take into account permissions/topics/notifications.If it matters, my FME Server install only runs on my intranet. I don't need to expose it to the public.Thanks!-Jeff

531
redgeographics
Celebrity
jstanger
jstanger
asked in Transformers
Help resolving error with FME script not running on different environment

This may be due to my inexperience but I have an FME script I have been modifying for a client, no new nodes added, and it throws up an error when the client tries to run it. The script runs with no issue on my own dev environment but when the client runs it using their environment it seems to fail. The error log message is rather confusing to me so I hoped someone here might be able to help point me in the right direction. Unfortunately, I can't access the client's environment so I'm stuck with remote debugging.The error in question that stops the script is as follows:2016-09-12 14:55:16| 1.5| 0.0|ERROR |Labeller_TDUCT_start(LabelFactory): The clause 'MINIMUM_LENGTH 0 REJECT_INVALID_GEOM YES' within 'FACTORY_DEF * LabelFactory FACTORY_NAME Labeller_TDUCT_start INPUT FEATURE_TYPE AttributeRounder_OUTPUT PLACEMENT UPPER_RIGHT LABEL_ENDS yes PLACEMENT_DISTANCE 0.0000001 PLACEMENT_SPACING 0 MINIMUM_LENGTH 0 REJECT_INVALID_GEOM YES OUTPUT POINT FEATURE_TYPE Label

7810
jstanger
L
loganj
asked in Data
how should i go to create contours lines from multiple las files

I have around 1300 las (lidar) files. For these las files i have a few shp files with breaklines and polygons where i should remove the ground. (houses/lakes/rivers)I need to export contour lines for each las files using breaklines and also remove the ground inside those polygons.Each block should have a buffer around them to fix the problem on the edge.So i need to load each block with the buffer around it and generate contours after removing the ground and also to use the breaklines.But here is another problem. i need to drop the lines first and filter them out base on z difference of each vertexes and keep only the original line that fits the z difference.Now what i know to do so far (on a single block):i manage to filter the lines. is there a transformer to simply this? right now i compare each line start z and end z against each otheri know how to generate contours with breaklines.i know how to remove points inside polygons.i know to create a buffer around a tileWhat i don'

9911
mark2atsafe
Safer
J
je6thoma
asked in Transformers
Change Detector - Length Tolerance

When working through determining the differences between line segments for two different Feature Classes, I'm hoping to omit the differences between line segments whose lengths are within a given tolerance values (e.g. listing those Features whose difference in length is within 5 meters as Not Changed). Is there a way to set a tolerance of 5 meters for assessing the difference between line segments from different feature classes?

246
itay
Supporter
X
xavigarciamar
asked in Authoring
Batch deploy

Hi again , Another question please. If I have two diferent readers , one is a GDB file , and the other is a DGN file , how can I generate the batch deploy ??? Actually only let me add one source dataset , the DGN or the GDB but not the two at the same time. Thanks in advanced for your help !!

172
X
A
adriaan
asked in Integration
filtering out duplicate numbers

So I have two main sources:An sql script.And an excel sheet.I want to compare the attribute ADRNR from one source with the other ADRNR1. If its a match then it shouldn't do anything because i didn't hook a writer to that and if it doesn't then it fails and should give me the values that aren't duplicates. I tried doing this with a simple tester but it doesn't work unfortunately. Here is how my tester looks like:the Failed output should give me the values that aren't duplicates.I think its because fme tucks every source nicely under eachother so that it can't compare it with eachother. Is my assumption correct and how can I make this work? Do I need to combine the data from the sources first? I just want to do a comparison between the these attributes of different sources and filtering out the unique ones.The workspace looks like this. Thanks in advance.

278
itay
Supporter
G
gsgoraya
asked in Transformers
Extract text from string in two different attributes

Hello All,I have excel spreadsheet that contains attributes like Trackcomment O: from 105 to 160 O: from U to S on 117 O: from U to S on 135 O: from S to U on 144 P: from 101 to 111OT O: from U to S on 146BDI want to create two new attributes (Columns) that contain middle part of the string (105 or U to S or S to U) and end of a string (160 or 111OT or 146BD) in two different excel columns (Attributes). I am facing two challenges. I used stringsearcher that extracts the last number of trackcomments but missing if there is any alpha character and the second stringsearcher just extracts if it is U to S or S to U but it is missing if the middle part has a number. Please see the attached screenshot. I would appreciate the help.GGoraya

804
itay
Supporter
gpt_geoinfo
Contributor
gpt_geoinfoContributor
asked in Transformers
Ellipses as areas

Hi FMElers,I want to have circles as areas. Therefore I use a Creator to create an ellipse with the same primary and secondary axe. For FME this object is a point with ellipse-properties.How can I change it to an area? I already tried AreaBuilder and GeometryCoercer.Cheers, Maria

2039
fmelizard
Safer
rudy_v
Contributor
rudy_vContributor
asked in Transformers
Split a range address in multiple list addresses

Hi,I want to split an address which are in range (from-to) example 12-24 Collins Street, into separateattributes:12 Collins Street14 Collins Street16 Collins Street18 Collins Street20 Collins Street22 Collins Street24 Collins StreetI thought of doing it with a pythoncaller, but could get it to work wellAny suggestions

506
mark2atsafe
Safer
lazarlubomir
Contributor
lazarlubomirContributor
asked in Transformers
Merging 2 attributes into 1 attribute

Hello,I solve problem with attribute diversity. I need to merge values of 2 attributes into 1 attribute. Check the pic below please:I need to get fully filled attribute igds_rotat - so values should be like that: 0000000296,67How can I reach that, please?Thank so muchLubo

11862
lazarlubomir
Contributor
J
jeff_s
asked in Transformers
Taking data from a point object into a Polygons

Any help on the problem below would be greatly appreciated:I have two MapInfo layers, one is points and one is polygons.Multiple point features may exist within one polygon.I have data in a column in the points layer that I want to copy into the a column in the polygon layer. As there maybe multiple points within a polygon I want to concatenate the data from the multiple point features that are within that polygon into one column in the polygon layer, thus losing no tabular data from points to polygon.Thanks in advance.

92
J
fmelizard
Safer
fmelizardSafer
asked in Authoring
What does FME stand for?

What does FME stand for? Okay, I know the answer, but do you?

3628
mygis
Supporter
T
turner537
asked in Data
TweetStreamer and CSV file flushing

I've created a simple workspace that streams tweets, does a point in polygon and and writes results to a CSV file. Now the Tweetstreamer is a perpetual streamer - i.e. it requires manual intervention to stop. The problem is that the CSV writer appears to flush all the writes only after correct completion of the workspace. If the user manual stops the workflow (as required by the Tweetstreamer) the CSV writes are not flushed and data is lost. Is there any way to automatically flush the CSV writing after each record (or another workaround?)

3810
david_r
Celebrity
J
jimq66
asked in Data
Converting SQL tables to MS Access

I have two sql tables. One contains inspection records as shown:The other contains questions for each inspection as shown:I need to combine these and put them in access as such:InspectionID; InspectionName; Date; InspectedBy; Old_Spill_ID; Spill_Type; etc.Any help is much appreciated!

119
mark2atsafe
Safer
N
nataraju
asked in Transformers
Which transformer best suits for oracle non spatial tables data merge with related data?

Hi, Please see below picture:I have million of records in Table 1 and 2. want to merge to output format with related data based on some conditions. I tried with Tester, FeatureMerger, TestFilter etc, can any one suggest best approach?

77
erik_jan
Contributor

Badge Winners

Show all badges

Community Stats

31,808
Posts
120,815
Replies
39,431
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.