Using transformers to modify data.
Recently active
I have created a workspace to extract data from a series of datasets based on selected land parcels.When I run it from the desktop it works fine, the DWG file is created and a PDF of the data is also produced.When I run it from FME Cloud Server, I get the following error around the PDFStyler. 94PDFStyler_2_CheckLineWidth (TestFactory): The clause 'TEST 1 TYPE NUM ENCODED FEATURE_TABLE_SHIM_SUPPORT Yes' within 'FACTORY_DEF * TestFactory FACTORY_NAME PDFStyler_2_CheckLineWidth INPUT FEATURE_TYPE FeatureWriter_public.ParcelCadastreCombined TEST 1 TYPE NUM ENCODED FEATURE_TABLE_SHIM_SUPPORT Yes OUTPUT PASSED FEATURE_TYPE __CheckLineMiterLimit__' is incorrect. TEST must look like: TEST <value> <operator> <value> [ENCODED]95The clause 'TEST 1 TYPE NUM ENCODED FEATURE_TABLE_SHIM_SUPPORT Yes' within 'FACTORY_DEF * TestFactory FACTORY_NAME PDFStyler_2_CheckLineWidth INPUT FEATURE_TYPE FeatureWriter_public.ParcelCadastreCombined TEST 1 TYPE NUM ENCOD
Hi, I want to find out whether an object with certain coordinates (x3,y3), is within a region that connects two points of a line. See the image below. I have a line between two points (X1,Y1) and (X2,Y2). I want to know if another object is intersected by that line. As the object is just a point, and my accuracy of the points is low, i want to put a buffer on its x/y co-ordinates of like 1m either side (so effectively a square), and see if that crosses it. Is this possible in FME? If so... how?
Hi everybody,I try to assign a specific layer for several attributes in a block Acad (in order to respect our CAD standard).I try to assign dedicated layer with the "Attribute manager" (see attachement), but when the acad file is created, I've only one layer defined by "Layer Name" in DWG Writter.Following documentation, it should be possible to acces this kind of information:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/acad/Inserts.htm But in my case, it doesn't work ... any help ? Thanks Eric T.
I have a CSV file with attributes in several columns and coordinate pair(s) in a single column. The column with coordinate data has X and Y coordinates arranged like this:Y, X, Y, X 430,495,678,272 Y, X Y, X Y, X Y, X 82265,5487539 82479,5487545 82553,5487896 82645,5486795Coordinates may contain one or more coordinate pairs. There is an attribute within the file indicating the number of coordinates pairs the feature has but no attribute to indicate whether the feature is a point, line, or polygon. What would be a way to create correct geometry from the list of coordinates?
I have a python code, here is an example, how will I set it up in a Python Startup Script or even a Pythoncaller. Here is a sample code. I know some might be able to do everything I am trying to do in FME, for the moment I will like to use my available python codes in FME, hence my question.def my_function(food): for x in food: print(x)fruits = ["apple", "banana", "cherry"]my_function(fruits)
I'm using a Spatial Filter and want to understand how the merge attributes element deals with multiple features. In the example attached the 'orange' grid is the candidate and the 'green' features the filter, with dark green feature A and light green feature B in that one dataset. For the highlighted purple square the following is true:The cell would pass, because it intersects the 'green' layer.It outputs the purple square attributes with the addition of A (dark green), (NOT B (light green))My question is - How is it decided which attribute value from the 'green' data set is used (A or B)? the first it intersects, the largest feature or something else? Apologies if this has been asked before I couldn't figure it out from the help file, or how best to pose the question on Google! Thanks.
Hi,I have workspace which I have made with FME 2016. It works ok with 2017, I can run workspace, but I can not edit Joiners. Not even if I upgrade them. Here is error I get:I am able to create and edit databasejoiner in new workspace.Where can I download 2016.1 version? I have backup:)
I have a workbench that Inputs a fileGDB that has a feature class with just a few points. The output location is generated based on the input with a timestamp added. Savings as a new file gdb (Regular API and the open API) ones both work when saving to local C drive but not anywhere on the network and gives the following error:"Unable to connect to the File Geodatabase at 'H:\\Temp\\CAD_Test.gdb'. Make sure the correct filename was specified, and that the geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-2147024894'. The error message from ArcObjects is: {}"Using UNC paths is same resultIf I change the file type to .csv I can export over the network no problem, but filegdb fails and don't know why, have the drop table setting set to yes Any ideas?
Hello FME' users,I'm try to extract some informations from Video ( .mp4 extension ) using the custom transformer VideoPropertyExtractor.First, I downloaded the ffmpeg and installed all packages in the folder.Using the transformer Creator -> I configureted the custom transformer, like bellow: The Workspace executed without success: Attached the log file - FME Version 2019.1 - Build 19608 Command Line is Works: Thanks in Advance,Danilo
Good morning!I have created a very simple workspace to test reading and writing a DWG file with Extended Data.No issue when reading it. I get the extended data as a list:But when I create the new DWG, there is no extended data in the result. I have checked several related questions, but I haven't been able to solve this issue so far.These are my writer parameters:I'm using FME 2018.0.0.2 - 32 bits.I have attached the workspace and the source DWG.Thanks for any help provided!
I have 2 .tif files (1xBounding Box with correct extent and 1xRasterMap image with wrong extent).Please can someone show me an example (or list of tools) how to import or get the correct extents from a bounding box .gif raster file into another .gif raster file (map) with wrong extents. I've tried BoundsExtrractor, BoundingBoxReplacer, RasterCombiner, ExtentsCoercer & Merger/Georeferencer but can't get what I need! The images below illustrate what I mean. Any help appreciated! ScottaidhGeoreferenced tif
Hello,I'm trying to figure out if I can do this in FME:I have to produce an axonometric 2D vector drawing (SVG) from a Revit file (3D room geometry), something like this:We do this for PowerBi dashboards, so people can filter data using the actual rooms, it helps them to undestand the building a bit better...At this moment I have to rely on Rhino and their "make2D" command: http://docs.mcneel.com/rhino/5/help/en-us/commands/make2d.htm It works, but too much work...So, I'm wondering, is there a chance to automate this using FME?
Hi, I’m processing CAD-files in a script and my mission is to repair them to some limit. In one section I’m using the AnchoredSnapper to snap one type of lines to another type of line. Using the AnchoredSnapper bc I need the first set of lines to not move. Worked fine with the first file I ran, but the second time I ran the script with another CAD file, which didn't contain the type I set as anchors, the AnchoredSnapper processed the lines as I was using the Snapper instead, ie snapping the candidates to eachother. My expectation was that every input would pass out through the untouched port since there were no anchors to snap to.Is there a reason for this? How can i solve it? Best Regards, Anna
Hello,I am trying to use AttributeValueMapper to Map values that contain a certain string as "Pending" to an existing field. I am not sure if this is the right approach or If I have to add another transformer, or if I am just using the wrong Wildcards. I have and AttributeRangeMapper that is working perfectly before it. I need to take those values and add a new category "PENDING" to the same field for the strings that contain "PPA", that's why I have those values as default. It is showing the default values but not any "Pending"
Hi everyone,I'd like to create an arbitrary subset of features and can't find a suiteable way to do this. My features have a unique ID and I'd like to select a sample of n-features of it. How can I get n-individual random numbers to test these numbers against my ID and filter the features this way? Or how can I fetch n indices from a list that might be created from the features?Here is some sample data:
I use the below items* Use an attributeFileWriter* Use a dynamic string built up eg -----------------------------------2019-08-14 15:18->Roads in gdb:37574----------------------------------------------------------------------2019-08-14 15:18->Roads in gdb with duplicate removed:37572----------------------------------------------------------------------2019-08-14 15:18->Roads in SDE::37474----------------------------------------------------------------------2019-08-14 15:18->Roads in SDE with duplicate removed:37454-----------------------------------* I log into a txt file* After every ----------------------------------- I have a new line inserted Problem-* When I open the text file, why don't I see the line feeds as I inserted them Cofusion-* when I copy/paste the contend into a rich editor eg browser, Word I can see the line feeds
Hello,I am having trouble reading a dimension feature class (ArcFM Feature - Polygon) using the ArcSDE Geodb,. FME 2018.1 Build 18567 Win 32 provides an error ... both in Desktop and Inspector"Unable to convert row to 'DimensionFeature'A fatal error has occurred. Check the logfile above for detailsFailed to specify the feature index as constraints on the reader"The older reader (SDE30) reads fine, as does the other (ArcSDE Geodb) for all feature type except the 2 dimension classes.Can anyone suggest what I am doing wrong or it this a bug?CheersMatt
Hi everybody !!! I´m having a problem with a Feature Joiner in my project that is losing the fme_text_string value after the processing of 100 rows.To garantee that the problem was not with de data, I already tryed to use diferent sort critereas in my data, but the problem always occurs after the flow process 100 rows, no matter what data is in the 101th row. To no submit all the project I simulate the problem in a smaller scenario for your avaliation. Thank´s a lot in advance.
Hi, I am having an issue with the CommonSegmentFinder transformer. I create polygons from the lines with the AreaBuilder. Then I try to identify the lines that where used to create some of the polygons with the CommonSegmentFinder. It mostly work, but a few lines are not identified. How is it possible when the lines were used to create the polygons in the first place?Thanks!
Hi all,I would like to add a field to my vector data assigning a sequential ID to duplicate values. However I would like to ignore unique values leaving them with a COUNT of 0.This table can hopefully explain what I would like to achieve better than me attempting to write it!VALUECOUNT103051525354607172 I started off with a Statistics Calculator grouping by my VALUE using the Total Count Attribute and the Cumulative output port. This counts each unique value sequentially but it also assigns a COUNT of 1 to unique values.Is there another way of finding duplicates apart from the Duplicate Filter first? The Duplicate Filter doesn't appear to filter the truly unique values from duplicates. As in a the first VALUE of 7 and 5 would go through the unique port then the further 7 and 5 values would pass through the duplicate port.I hope this makes sense to someone! FME version 2019.1.0.0
Hi, I have a set of data, with dates ranging from 2005 to 2019. I use the interval feature in the Date Time Calculator, and am able to calculate the interval between the two dates (14 years). In another table, I have a number of jobs grouped, and I want to use the 14 years calculation to determine the number of jobs per year. (silly example given below) Fruit Total Fruit Fruit per year (ie, total / 14) Apples 20 1.43 Bananas 30 2.14 Cherries 40 2.85 So I want to get the "Total Fruit" and divide it by my _results_interval. But it wont work. I try to use Attribute Manager, and then bring in the _results_interval, but it displays it as a new row. And wont let me bring it into the arithmetic calculator either.
I am having issues where some polygons are not being written to my PostGIS schema when running a workspace.Attached are two screenshots, one from directly before the PostGIS feature writer and one of the same features being read back in from PostGIS. I've checked the geometries are valid, are not too complex and have also written it out to a FGDB where all polygons are written fine. Has anyone experienced this or have any potential solutions/suggestions?
Hi,I would like to fill those Property Sets / Extended Data fields and write it to dwg.I can fill the values, but I can't write it to dwg including those fields.Who can help me? :-) Thanks!
Hi all,I have just been clipping some datasets in FME and I have noticed that it has left some sliver bridges connecting polygons. Is there a way to remove them?I tried using a snapper with various tolerances and using the sliver remover.Attached is a polygon with one of the bridgesThanksFME 2019.1.0.0
Every time I need to run my transalation I have to open the SQL transformer make an edit (i.e. put in a space , delete it ) to get the transformer to run successfully. It is only the first transformer in the workspace that this occurs on the other sql transformers run as expectedThis is the same whether I use SqlCreator or SqlExecutor. Could it be the Sql statement I am using begins with Declare statement?