Using transformers to modify data.
Recently active
Checking this, but surely this has to be a Bug? FeatureJoiner in Left Join Mode and Right Hand Side Conflict Resolution is overwriting LHS Attributes with NULLs where:a) There was no matching Feature on the RHSb) The Attribute Name exists on both the LHS and the RHS I would have thought that for any Left Feature that did not match any Right Feature, there is no "conflict" to resolve and it should exit the Transformer with the same Attribute Values as what it went in with?
I have simply transformed an IFC file to OBJ format, but the default result is that everything has the same flat grey colour. I notice that I can edit the created "materials.mtl" file afterwards to change the different material types, and when I then import the created OBJ file into Blender, I see that the new colours are there. I would like to automate this however, for example making all walls a certain colour, all floors a certain colour, etc., or even changed their colour based on attributes. Is this possible? I see under the OBJ Writer parameters that I can specify a custom Material Library File, but I don't have one to start and I would prefer to simply generate it dynamically, just with the colours for each feature that I specify. How can I do this? I tried using a ColorSetter transformer just after reading some specific feature types but that didn't do anything.
I'm trying to group together polygons from a single dataset that are in close proximity to one another (0.5 metres). I've used a NeighborFinder (Candidates Only) which gives me a value for distance and have set it to give me a Close Candidates List so that it returns more than one neighbour. However, it is not clear to me how I can tag the features that meet the criteria for belonging to the same group and I have no attribute that I can group by
I have a simple workbench that reads a postgis database and outputs an excel file based on a user parameter in which the user enters a filename that filters the input table into one record. This works fine within FME, however I'd like to create a batch file that runs the workbench from the command line. The problem I have is getting the batch file to prompt for the user parameter. It just runs the workbench with the last parameter I set within FME. I'd like to be able to run the batch file and get the prompt for the parameter in the command line.
I'm trying to analyse an area/DEM with these two criteria: -Even sloping terrain steeper than 1:20 and total slope height > 5 m.Finding areas with slope of 1:20 (5%) could be done with the slope function. But I can't figure out an easy way to filter these areas to only include areas with slope height over 5 meter. I.e. the total vertical height form start of slope to top should be at least 5 meters.Anyone have any ideas or thoughts on this problem? Background: The criteria are to identity possible land slide areas (quick clay), so it's already clipped to only include areas of old marine sediments. https://www.ngu.no/en/topic/quick-clay-and-quick-clay-landslides
I have a shapefile or esri geodatabase file of Appraisal data that I need to join to two different appraisal data tables based on a single field and add the table fields to the original file. What transformer(s) should I use?
My inputs are 3D point shape files and 3D point clouds in LAS format. These have been re-projected from OSGB to London Survey Grid using the transformer - SnakeGridProjector. The XY positions of the data are converted correctly but the Projector is set up to handle 2D data and the elevation values pass through untouched. It is a 'black box' projector so can't itself be manipulated to incorporate elevation shifts. Ideally a fixed value needs to added to the elevation to complete OSGB/LSG re-projection. We can apply the Z shift in alternate software, but would like to add this stage within the FME workspace if possible.
Hi All - I am attempting to take a geo polygon and shrink, rotate, and offset the polygon to the correct location. For this I was attempting to use Affine Warper. The polygon I'm trying to change is the "Observer" and I have a geojson polyline with 2 points as the "Control" that I want to shrink the polygon down inside. No output is given in the Affine Warper.
Day one in FME... Coming from an SSIS background. What would be the approach to dynamically set a reader location based on the results from a transformation? I'd like to take the Joined results I have and for each filepath start a whole new batch of work. The readers have me stumped as I'm used to being able to set the source locations using an expression. I can see I'm not able to add a reader in a custom loop. Just looking for a push in the right direction. (see below). Could be I need to re-wire my brain for FME use too!
Why does the FeatureMerger flip some line directions when supplying their geometry to another feature? It seems that only features that begin running in a southerly direction are flipped. Here is the transformer: Input:Output:
Is it possible to use a dynamic writer to update? I want to read multiple feature classes, join each feature class and then update the joined records in a different database. Matching columns are not available when selecting Update feature operation.
I am a very new user to SAFE FME and I am still learning the tool. What I am trying to figure out is how to publish a .hyper data source file to our on-prem tableau server. I am using the 2020.1 version of safe fme with the new .hyper writer. My basic question is how do you do this. More specifically what I need help understanding is: (1) how to write the XML into Safe FME to do this per tableau (see this document: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref_publishing.htm); (2) can I do this without having to save a .hyper file locally; (3) can I create a macro to make this easier for others and adjust the settings (like append the data, replace the data, etc.). Thanks in advance, Greg.
Does anyone know if it's possible to write with multiple DWG templates. I've tried making a published parameter and defining the template fil as AutoCadSource but it seems it only applies the first one. I need each corresponding template to be the original file that I'm reading in because they're all different and have different block names within them. Thanks! /Jacob
I'm trying to rename an attribute based on a user parameter. For this, I used the BulkAttributeRenamer since both AttributeRenamer and AttributeManager don't seem to accept user parameters as valid inputs for an attribute name. This worked fine for the first time, renaming the attribute appropriately to the value of the user paramter. However, when I change the value of the user parameter, the new name doesn't seem to propogate through to the output. In the picture you can see I try to replace _2 with _$(YEAR_2). The first time I ran this, I used a parameter value of "2010" whch worked fine. Now when I change the value of this parameter, the output still shows only _2010 instead of the new value. I need to do this so that the output file has the correct attribute names, instead of the temporary ones I use during the workflow. Does anyone know how to accomplish this? Thanks!
Hi,I upgraded from 2018.1.2.1 to 2020.0.0.1 on windows 10 machine.I have a workspace that reads feature classes from the SDE, inline queries, attribute keeper, FeatureWriter (1 per FGDB, SHP, DWG, GEO, CSV, KMZ), before file copy inserts a text disclaimer into the zipped folder. Previously this process worked flawlessly (years), now the featurewriter deletes the previous zipped folder before the FileCopy writes/inserts the disclaimer. If i remove the disclaimer the featurewriter deletes the previous zipped folder, if rerun with nothing in the workspace, it correctly writes out.I get the warning below when it deletes everything when overwriting.MULTI_WRITER: Skipped adding of some files to zip file '\\\\ncservfile\\database\\xx\\xx\\xx\\Recreation.zip' because they already existBelow is a sample of the workspace. Any help would be greatly appreciated!
I created a Choice Multiple parameter and when i start the workspace i can check some values. But how can i test on the checked values? I tried a tester but that doesn't seem to work.
Hi I run for the first time the trainer then I run the classifier now I would like to add new records to the trainer to improve/refine the results How can do this ? Thx Francesco
The FME version is 2019.2
I have a python caller that is failing and giving me a key error here is the log message:2020-09-01 10:34:39| 636.8| 0.0|INFORM|Found 561025 features2020-09-01 10:34:39| 636.8| 0.0|INFORM|Consisting of 26411 transformers, 160252 nodes and 374362 bits of conductor2020-09-01 10:34:47| 637.9| 1.1|WARN |Python Exception <KeyError>: u'5405483'2020-09-01 10:34:47| 637.9| 0.0|WARN |Traceback (most recent call last): File "<string>", line 119, in closeKeyError: u'5405483' 2020-09-01 10:34:47| 637.9| 0.0|FATAL |PythonCaller_2 (PythonFactory): PythonFactory failed to close properly2020-09-01 10:34:53| 643.8| 5.9|ERROR |PythonCaller_2 (PythonFactory): A fatal error has occurred. Check the logfile above for details The python script is attached The thing is, it ran perfectly OK one day and then the next day when i ran it and ever since it has kept failing. No changes to the workbench,but data updates overnight. The value referenced '5405483',
Hello, I have created a workspace that works as it is in FME 2018.0.However now, when trying to upgrade, I seem to be getting validation errors, which I have not encountered before. After examining the outputs, they are different, as seen on the image.When running the translation in FME 2018.0 every feature is treated as FeatureMember, since 2018.1 it is behaving as seen on the right side, it's one giant FeatureMember. Any help how where can I fix this in newer versions? Thanks for any help,Radek
I'd like to know if it is possible to use Topology Builder/Shortest Path finder in some combination (or other transformers) to assign a value to point attributes that represents the number of hops to get to a point with a certain flag attribute. For more detail, I have a point dataset and a line dataset. The point dataset has a column with a yes/no flag. The line dataset is a network that connects all the points, one segment per point pair. I'd like to add a new attribute to the point dataset that is the shortest number of hops a point with a "no" flag is away from a point with a "yes" flag. In the attached image, I am trying to get the blue point on the far right to have a value of 1 assigned to it. A bonus would be another attribute which tracks the number of unique paths to a point with a "yes" flag. Ie. the blue point on the right would have a value of 2.
Hi there, I have a spreadsheet where I need to replace a string of text. I have attached the spreadsheet with the original text and what I would like to replace it with. I'm having trouble coming up with the correct syntax in the 'Text To Replace' in the 'Parameters' dialog box. I can get the first string to replace but not the second. Please see attached screenshots. Thank you and have a nice weekend :)
I have a workbench that I am trying to run in command line. When I run it directly from workbench, it runs fine. When I try to run it from a .bat file I get the following error message: "The clause 'TEST @EvaluateExpression(STRING_ENCODED,<at>Value<openparen>Sort<closeparen>,TestFilter) = 1 ENCODED' within 'FACTORY_DEF * TestFactory FACTORY_NAME TestFilter_TestFactory_0 INPUT FEATURE_TYPE TestFilter_TESTFILTERINPUTLINE_0 TEST @EvaluateExpression(STRING_ENCODED,<at>Value<openparen>Sort<closeparen>,TestFilter) = 1 ENCODED BOOLEAN_OPERATOR OR COMPOSITE_TEST_EXPR <Unused> OUTPUT PASSED FEATURE_TYPE TestFilter_attribute OUTPUT FAILED FEATURE_TYPE TestFilter_TESTFILTERINPUTLINE_1' is incorrect. TEST must look like: TEST <value> <operator> <value>" I can't quite tell where this error is coming from. From the log file, it looks like it is reading the first sub directory for the Source_Dataset but fa
Hi fellow experts and users,I apologize if this has been asked already but I have not been able to find the topic.I have only been using FME for a month and struggling to figure out how to manipulate data within FME. I've watched and followed exercises about using FME to reading in map data but it is confusing and overwhelming at the same time.Basically I'm trying to convert a PDF representing buildings and runway and convert those points into georeferenced positions. As an input I have a georeferenced shp file containing a runway with the intention of being able to match the runways together and then being able to figure out where the PDF buildings need to be placed.The scale of the PDF runway and the shp runway may not be the same but I was thinking it may be possible to compare each point of the polygon one at a time to figure out the distance and create some kind of scaling. I coloured the runway in the PDF as a purple line so that I have the PDF runway polygon and the s