Using transformers to modify data.
Recently active
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
I have two tables: Room and Furniture. In the Room table, I have room_id, and furnitures attributes, and in the Furiture table, I have room_id and furniture_name...etc. How to link these two tables through room_id, so each room will have a list of furnitures that belong to that room? Thanks for your input!
I have a workspace that has as outputs some 3d models and uploads them onto Cesium. The inputs are a single band raster with elevation as a value. I convert this raster in a TIN and using appearance setter I drape a texture on top of it.Said texture is a 3 band (RGB) raster which is created from the elevation values, matched with a file that tells the ranges of height and the colours to apply. At the moment I generate this raster in GDAL using gdaldem color relief. Does FME have a similar transformer or workflow?
I have been puzzling for a while how to process data available on the Dutch portal www.pdok.nlAfter downloading a gml-file (type Dutch TOP 10 GML), I would like to extract the information stored in elements and convert this information into attributes. Therefore I use the XMLQueryExtractor. This does the job, information is temporarily stored in lists but this is a very timeconsuming process. Examples of elements with multiple values from the featuretype ‘Wegdeel’ are naam, typeWeg ,hoofdverkeersgebruik and fysiekVoorkomen. Is there a more efficient method? I have attatched an example workspace… Many thanks in advance. (v 2019.2.2)
I have two tables: Room and Furniture. In the Room table, I have room_id, and furnitures attributes, and in the Furiture table, I have room_id and furniture_name...etc. How to link these two tables through room_id, so each room will have a list of furnitures that belong to that room?
Hello, I wrote a tool to join 3 Excel spreadsheets (solar data and 2 different meter tables) and an address point feature class. I tried appending this data to a SDE geodatabase feature class called, Distributed Generation. The writer only appended the attributes and not the geometry. I'm not sure why the geometry is getting lost during the translation. (As a temporary work around... i wrote it to a file geodatabase and am manually appending in ArcMap). I have attached a screenshot of my workflow and parameters of the writer. Any help or ideas would be greatly appreciated 😊
In my data, I have 3 Oracle tables (numbered for ease of explanation); 1) a spatial table with geometries of tubes used as casings for HV-cables 2) a spatial table with the geometries of the actual HV-cables3) a non-spatial table with the connection between the tubes and the cables they contain (essentially displaying which key(s) in table 1 is(/are) matched to which key(s) in table 2 What I'm interested in is isolating the tubes which have a cable running through (/on top of) them based on a spatial analysis, but aren't yet connected in table 3. Therefore, I'm looking to exclude all tubes with a key present in table 3 from table 1 before progressing with the other translations (which are going well), but I'm not getting anywhere with Matcher. Is there any other transformer to use here?
Hello,I need to publish SOAP service to receive data from an external application based on a predefined wsdl. I found samples on using REST but nothing about SOAP. Where can I found some samples or hints to start working on this?ThanksRoberto
I have a very simple question, I have two line datasets that cross each other. The goal is to get a count of how many times each line in dataset 1 crosses a line in dataset 2 (total crossing, ie if line 1 crosses line 2 twice, would like to track that). To do this, I was using a spatial relator with the attached parameters. The problem is that the "related suppliers count attribute" is 0 across the board. I have used "Requester Crosses Supplied" and "Requester Intersects Supplier" with no success. Is there a parameter I am missing?
Hi,Im trying to create a best fit line from a list of coordinates on a runway and dont really know how to approach it in FME. Im familiar how to do a linear regression via the R caller but cant figure out how to create a line from the values. Im not even sure that a linear regression is the proper method to do collinearity. Anyone have an idea?Thanks
Hello!I need to get the properties of a big GeoTiff ( 146299 cols x 213475 rows or even bigger)Among these properties I need to extract the ref system, the resolution, splot the bands etc. Apparently, in order to get them FME needs to read all the raster and this process takes forever. Is there any alternative way to get these without reading all the raster?ThanksOskar
Hi, everyoneI wanna export attributes to a word table, so I use MSWordStyler transformer to generate a table element before writing into a Word writer. The pic below shows how MSWordStyler's parameters are set. However, when I run the workspace I got a error says that "Error message: 'AttributeError: 'unicode' object has no attribute 'append'".Is there something I miss or somthing set incorrectly? What should I do to deal with it?💗
How add a group by option in my custom transformer? Example: Another example might be if I put a Counter with local scope starting at 0 inside the custom transformer, then I would like to group by for instance _creation_instance - to get three features out all with _count = 0. In the Custom transformer I see a setting Group by <not set> but I am not able to edit that one (there are no suggestions when opening it). I tried creating a parameter called fme_group_by but that did not work either. How can I do this?