Using transformers to modify data.
Recently active
Thanks to Debbi L for her help today and pointing me to:https://community.safe.com/s/question/0D54Q00008FXAFASA5/i-have-a-100-ft-line-that-curves-and-then-turns-back-into-a-straight-line-how-can-i-use-fme-to-only-gather-the-straight-line-after-the-curve-only-i-basically-want-to-cut-out-the-curve-and-only-grab-the-line-after-the-curve While this helped, I am at a loss as to how to build the rest of this in order to achieve the removal of unnecessary vertices. I was hoping Generalizer would be able to do the trick but it is mainly based upon the distance between vertices. Any help would be appreciated!😉 To expand upon this, I would want to remove the vertices in the adjacent lines segments highlighted in this image:
Hello, How would I remove specific vertices from a feature that are stored in a list, the vertex remover only allows one vertex be removed. I have a list with: Coordinate Index - vertices_to_remove{}.vertice_indexX - vertices_to_remove{}.xY - vertices_to_remove{}.yZ - vertices_to_remove{}.z Thanks
I am really, really new to FME and so trying to wrap my head around everything. Essentially I have a CSV that has multiple data sets one after another, split by a multi line section of header information that it not formatted the same way as the data. I'm trying to read each section of data and write it to a single database table. So for each section I need to read a specific line within the header area (Serial number and Counter Name) and then use that as one of the attributes in the writer. Data should look like : SerialNumber, CounterName, Date, Time, Value When complete in order to write it to the table. From the various posts I've found I think it might involve using a variable setter and variable retriever but I'm not sure how to make that work. Any suggestions are appreciated.
Hello,I have a few ESRI generated json response files from ArcGIS Server feature service that can contain 1 to 200 records per response and these do not have geometry. What I want to accomplish is to add one new parameter "projectnumber" and assign it with a static variable and rewrite the output back to JSON or ESRI JSON file again. Thanks in advance ! Original: { "attributes": { "sapfloctplnr": "MASG-GASD-SA01-SERL-0055647", "lifecyclestatus": 1, "GLOBALID": "{E839E029-529F-4D6B-9C4E-85BD875BC582}", "ASSETGROUP": 1 } }, { "attributes": { "sapfloctplnr": "MASG-GASD-SA01-SERL-0055649", "lifecyclestatus": 1, "GLOBALID": "{A9BF1A40-C1E4-4BC7-A538-7011FA9C55EA}", "ASSETGROUP": 1 } }, { "attributes": { "sapfloctplnr": "MASG-GASD-SA01-SERL-0055659", "lifecyclestatus": 1, "GLOBALI
I'm looking to build a workspace for an FME Server App to read a generated QR code that has a CSV list of attribute values in as an attribute and further transform it. Does anyone have any experience?
Hello,I wish to generate a count of points within Polygons [PointOnAreaOverlayer] but I am unable to generate a count for some polygons because of fme_rejection_code: INVALID_POLYGON_GEOMETRY_TYPEThese Polygons are either Self Intersecting or Multi Polygons. I believe I need to resolve this before I can start counting points inside but Aggregator and Geometry Validator do not seem to fix the issue.Thanks.
I found something back in 2009, but nothing since and no solution built for this. I have Intermedite knowledge of FME. I have a records for every 50 meters along a roadway that contains 3 fields Ride value, Rutting, and Surface condition. These 3 values make up our Condition state of our segments. I want to reverse this and build my segments based on a Rolling average for say 1 km minimum (20 records) where the average IRI = >x, Rutting = >y and SCI = >z. it would then build a polyline or group by averages. This would be a massive upgrade to our current system which involves shovels, hammers, and coffee!!! Sample graph where the red line would be my split, the roadway here groups into 2 segments.
We have a Mapinfo file with customers and we're using this stupid third party geocoder (for now hopefully changing) and we're pretty sure it's having an issue because of the size of the table we're sending it. I was thinking maybe I could get around it by having FME split the table into 3 equal tables and then geocoding them and then combining them back together. Does anyone know of a way to do this? There's no real column info that I could export based on anything it would have to be after X rows or something similar to that. Thanks so much! 😀
I am running a workspace that detects changes in data between an API and Web App and applies only updates to the Web App using a change detector transformer. I am sending a notification to a Slack Webhook but instead of a single HTTP request being made, it makes 1 request for each data record updated. What I Want:"Successfully updated 70 records". What is Happening:"Successfully updated 1 records"."Successfully updated 2 records".And so on till 70... Is there a transformer that will allow me to sum the number of updated records and only send a single HTTP request to the Slack Webhook? Workbench Screenshot: Thanks!
Hi all, I am generating a workspace for a client. A requirement is that output data should be in EPSG:29902. The writers have been defined to use 29902 as the output coordinate system. However, when I open the datasets in QGIS or Arc, the data is reporting as coordinate system EPSG:29903. Is there a way to correct this behaviour? Attached is a simple workbench with a creator transformer and a writer set to use 29902. But the output generated is 29903. Many thanks
I have a list of hyperlinks in Excel that lead to PDF's held in a website. Can FME iterate through this list and download the documents to a folder? Thanks in advance. Sean
I've got a HTTPCaller in a loop that retrieves data page by page (I use offset and limit). I have a tester that tests whether 'has_last_page' is true. This all seems to works ok but the translation does not stop - it just keeps repeating the last URL even though all records have been returned.
I'm extracting some data from a DB that stores values for time periods against a date in a comma separated list (above). I've used a cloner to create the time period for the date. Any idea how I split the csv list (presumably using an AttributeSplitter) and append the value to the desired timestamp? Any help appreciated!Thanks
I have an issue where I have text that contains braces that are inputted into an XMLTemplater through a SubTemplate (and also through ROOT). Since I don't want the XMLTemplater to parse the text, it is referenced as @Value(text) and not {fme:get-attribute("text")}. Still I get an issue as if FME expects a function. The log tells me: "context item": undeclared variableFor this issue I prefer not to escape the braces in my text, which of course would be a workaround.
Hi Everyone, I need your help to solve a problem. I have many no. of points that are not in order if we look at them spatially and in many places, there is a significant gap considering its distribution. I have tried Sort and then Line builder transformer in FME but the output was generated based on the layer drawing order. Another issue is line builder does not consider the gap within point distribution and connects all points to generate a single polyline. Looking for a solution to convert points to separate lines based on their spatial sequence. The attached below screenshot could make you clear about the issue I am talking about.
I am running workbench an FME Server automation that is fired from a SQL Server insert trigger for a ArcGIS feature class that has editor tracking enabled. On the workbench I check previous records for the feature and only want the workbench to complete under specific conditions - it is writing an HTML file. I was considering using the NULL writer but the documentation indicates this should only be used for testing. Looking for the best way to accomplish this. I considered modifying the trigger but this is so involved and much easier and cleaner to do in FME... Any tips would be appreciated.Thanks!
Hello,I am trying to obtain Max OBJECTID value from a database and pass it into Variable Setter.The SQL Creator > Variable Setter is obtaining the correct value (just one record at present) but the Variable Retriever cannot obtain the value I think?I hope this is a simple step or order I am missing.Thanks in advance
If I do not explode, I loose the 3d surface and the geometry is shown as point.
Hi all,I'm trying to download files (in this case zip files), which are in a parent folder on an ftp. The folder name changes once a week, when new updates are uploaded. I would like to automaticly download the updated files once a week, but it seems that the ftp caller has some limitations in that department - (asterix and subfolders). I have searched the forum for answers, but haven't really found a solution yet. I've seen suggestions using python caller and ftp caller combined, but I dont really do python :-) Any suggestions? Thanks
Hi all,I am trying to convert fbx file to FME AR. I am getting the error below."FME-AR_FBX' of type Directory, expected a dataset of type Regular file"I tried to deaggregate to see if it works workout but no luck.
Hello, Let's say i have an excel table containing multiple attributes and features, and I would like to output in an excel table a summary of the unique values for each attributes. Using duplicate filters I managed to get the results but they are ordered in rows in order of arrival instead of being nested for each attribute. Example with three attributes:ID ----- Name ------CityA1 -----Mark -------MoscowA2 ------Paul -------GlasgowA1 -----Joanna ---CapetownA3------ Paul -------Glasgow Then in excel I get three columns but the results are spread in the order of arrival of results for each column unique values: Column A -- Column B -- Column CA1A2A3--------------Joanna--------------Paul--------------Mark --------------------------------Glasgow---------------------------------Moscow-------------------------------- Capetown Instead of having the results over various lines, I would like to get the unique values on top of each column. Is there a way to do so ? Maybe working with lists ?
Hi All, I have a complex polygon with smaller polyons within a bigger polygon, multiparts and lots of overlap issues. I want to be able to desegregate, remove multiparts and be able to select each polygons individually. Any thoughts will be helpful.
I run features through an AttributeFilter Transformer in order to split the stream for specific manipulations downstream. If I test this in Workbench everything works as expected. If I call the workspace in BATCH from a DOS script all features end at the AttributeFilter (identical data).In FME Log of the BATCH run I see lines likeAttributeFilter_9 AX31001 Transformer Output Nuker (TeeFactory): Cloned 818 input feature(s) into 0 output feature(s)AttributeFilter_9 SD41000 Transformer Output Nuker (TeeFactory): Cloned 1154 input feature(s) into 0 output feature(s) What is going on here ? Why are the features not passed ... very,very confused 👿 😮 FME 2021.0 up to 2021.1.3 all the same
I have an attribute called "Status." The coded value is an integer and the domain value is a character. When I do not resolve the domains in the reader, then the automatic writer sets as an integer field, but when I resolve the domains, then the "Status" attribute and the "Status_resolved" are both characters. Is there a way to get "Status" field as an integer and get the "Status_resolved" attribute? I don't want to have to use a manual writer because I have >100 fields.