Using transformers to modify data.
Recently active
When writing to Autodesk ReCap the RCS output file name is lowercase - how do we force it to be all UPPERCASE?
I have downloaded a non spatial table called OpenbareRuimteLabel. In this table a column imgeo_openbare_ruimte_naam is included. In this column the name of the street, location of the label (in RD-coordinates) and the angle to be used for placement of the label is described. It is no problem to extract the streetname (unique value), however the elements 'pos' (coordinates) and 'hoek' (angle in degrees) can have multiple values. Is there a possibility to create a row for each individual location (point) in a new table? Many thanks in advance. Kind regards,Pim van der Zwaag.
I have a workspace with an User Parameter of type Choice (List). When I put this with AttributeManager into an attribute I can see that the choices I made (checkboxes I ticked) are listed. However, when I use that same Custom Parameter inside an embedded Custom Transformer it doesn't reflect anymore my choices.Does anybody know if I'm doing something wrong or if I stumbled upon a bug?I'm using FME 2019.2.3.1
I have a building box 3d model create from ketchupHow to I export feature include geometry is bottom face of model and propety is height of model from a 3d model?The feature template"type": "Feature", "properties": {}, "geometry": { "type": "Polygon", "coordinates": [ [ [ y, x ], [ y, x ] ] ] }
I have a 3D stream feature class. Each vertex has an elevation representing water surface elevation for a 100 year flood. I want to create a new point feature class at the inflection points along the stream profile, where elevation changes by 1ft. Here is my stream in profile view and some examples of where I want to create points: My idea is to store the starting value then look at the next vertex, if less than 0.5, skip and move onto the next vertex. Continue this till I hit a vertex that is 0.5 or greater from the starting point. Then create a point at this vertex. Then, move to the next vertex and compare with the last created point. I'm pretty new to FME, can this be done? Thanks!
I have a Workspace (Child) which is supposed to runs as part of another Workspace (Parent). When I run the Child Workspace as standalone, it runs fine. But when I run the Parent Workspace, it never runs?
Hello everyone,I've created a workflow analyzing text within a pdf-file with the Adobe Geospatial PDF reader. To limit the amount of data to what im intressted in i've tried to use the "page ranges" field to specify which pages to read. The problem is that the pdf index the first page in each file as 0, the second as 1 and so forth, and the Range field returns 0 as an incorrect value. If i put in page range 1-2 the reader reads page 2-3 in the data. Is there someway to use this field with my dataset?
I initialize my workflow with a SQLCreator that queries an Oracle Table, transforms the data and update the table back in Oracle. When I insert a new record thru a sqlplus/Toad into the Oracle Table, after that I re-run the Workspace in FME Workbench, the records from the SQLCreator does not update, it keeps the same records as when I first ran it. What am I doing wrong here? Any help is appreciated, I've been trying to run this for the last 2 days with no luck.
Hi, I want to export multiple pictures to JPG or BMP out of a Oracle-non spatial table. These pictures are stored like: FFD8FFE000104A46494600010101006000600000FFDB00430006040506050406060506070706080A100A0A09090A140E0F0C10171418181714.....In a different table there is an unique explination of this picture (ie street and number)Is it possible with FME to convert and to export this table to a directory on my network with pictures with format JPG or BMP? I need this pictures to provide an external office so they can use these pictures as offfered.
I want to download a zipfile using an URL and continue with the GML file which is within this zipfile. The following URL contains the zipfile:http://geodata.nationaalgeoregister.nl/top100nl/extract/kaartbladen/TOP100NL_33W.zip?formaat=gml I tried to use the HTTP caller first with these settings:HTTP method: GETSave Response Body to: Attribute ..then I used the FeatureReader to open the output of the HTTP caller.However, I got stuck. The HTTP caller did not generate any output. Could you advise me in this?
As a new user of FME, I would like to understand if it can extract tables from PDF to excel sheet?
Hidoes anybody know of a good alternative to the spatial filter? Due to the volume of data involved it doesn't seem feasible to use the spatial filter but I can't really see an alternative. Unfortunately I have around 3 million polygons to pass through a filter of around 1 million polygons. I have used a feature reader to break up the data into manageable chunks, which makes the workspace run at a reasonable speed but this requires me to rerun it multiple times with each chunk. I was hoping to be able to run it in one go. Using a workspace runner has also helped with processing, but again, still not feasible to run it in one go.
I have a baseline and I want to offset it to create several lines. With these lines I would like to create a surface and convert it to a solid.In my opinion it is a very simple model, but to run it, it takes a lot of time.What do I wrong? thanks!
I am looking for ways to create 2 bypass lines and point. Refer to the attached screenshot. 2 lines and 1 point in black are existing. Looking for ideas on how to build 2 bypass lines and point red in color.
Hi guys I was wondering if FME could be used with automating what I need. It's easy to do manually, but potentially need to do this 100's of times. Basically I need Shortened "Share" Google Map URLs from a GPS bearing, and a QR code of the google maps. So e.g. I put in GPS beraing: 55.982017, -4.258112 Then I get these results: would be great to set up a simple web site to have a form for this
Hello FME Community, First time posting here! Hope to explain my problem better with screenshots of my current situation and what I hope to achieve. I have 3 empty columns I like to them to be filled with values from Status_Percentage.sum based on the feature's status (e.g. Built, Intended, Interim). The result should look like this:The image shows values from Status_Percentage.sum filled to each empty columns based on the feature's status. I've looked into AttributeManager and conditional values but not getting what I want. I've been advised to look at VariableSetter and VariableRetriever but am not familiar with the transformers. Any help is appreciated! Thanks in advance.
I have data in the following structureI need to get it into the following structureAfter the data has been transposed I intend to carry out some transformations on it so ideally this would be part of a workflow rather than the end of it. And the exact name, type and number of attributes will change with each run so the workflow needs to be dynamic.I've been going round in circles with AttributePivot, AttributeTransposer, AttributeExploder, Aggregator to no avail. Anyone got a way of doing this?
So I have some areas that have gaps. I used an area amalgamator to combine them. It works really well. However, it makes the polygon/area have tons of points. Is there a way to reduce the number of points on the polygon? In the screenshots, before Amalgamation, the number of polygon points is probably 10-20. After, there are probably a hundred points that make up the polygon. All are very close together and could be removed and still keep the shape
In the SQL Creator transformer, what is meant by 'attributes to expose'. When do I need to use it? For example if I have a query which extracts fields, wouldn't the attributes be exposed from the query itself.
Is the UUIDGenerator using the algoritm to generate IETF UUID version 4 (random) ? If so, can you add to documentation with reference to the IETF standard ? If it is version 4 (random), can you explain which library is used as seed for the random number?
I looking to filter a classified las1.4 LiDAR file, to extract the model key points (classification_flags = 1) on classification = 2 (ground). Although classification_flags doesn't seem to be an attribute and is null if i expose it.-LAS reader-PointCloudFilter (class =2)-AttributeExposer > classification_flags (returns null)-PointCloudFilter > should filter by flag here. Any helps would be much appreciated.
Hello, I have a shapefile with various polygons on land parcels. I've been tasked figure out the dimensions of the polygons and display them on a map for engineers and planners to examine. How would I go about this using FME 2018.1?Since some of the polygons have curves, I figured I would use the PolylineAnalyser tool from the Hub and use the Segment output. Then use the Sorter to first sort by the ObjectID and then by the angle of the segment. Then I wanted to merge line segments that are within a 2-3 degrees range of each other so I would get a continuous line, instead of a bunch of small lines to make up a side of a polygon. Perhaps I'm going about this entirely wrong and there is an easier way to do this. Any help would be appreciated. Thank you
I am using a test filter to filter out all the different values of a feature type. In this case there are 21 different values, so I have to manually create 21 different test conditions. Is there a way to automatically create the test conditions? I also have features with more that 50 different values, which would be a lot of work to filter out manually.
Hi, I'm trying to use the XML Flattener to extract the attributes from an xml response_body: <loggers><summary><APIVersion>DatagateAdmin V2.48 (14-Sep-2020 12:38)</APIVersion><accountID>5279</accountID><accountName>Main Account for all SWW loggers</accountName><accountOwnerId></accountOwnerId><accountHighestMessage>4526752363</accountHighestMessage><accountUpdateTime>2020-09-28 08:39:17.6</accountUpdateTime><accountNumLoggers>2563</accountNumLoggers><CentreLongitude>-3.86433819774539</CentreLongitude><CentreLatitude>50.6236029248117</CentreLatitude><MinimumPhoto>0</MinimumPhoto></summary><logger><loggerid>74508</loggerid><mobileNumber>447924658356</mobileNumber><dateLastMessageReceived>2019-12-17 16:00:00.0</dateLastMessageReceived><type>FW-102-001</type><serialNumber>80823</serialNum