Using transformers to modify data.
Recently active
I created a work space with reader and writer and transformers but at the end when I get the result there are many fields which are "Null". I also used the template in the FME hub and got the same result. that would be great if any one helps me with this issue.
Utilizo WorkspaceRunner para lanzar otro proyecto por lotes, lo pongo en marcha mediante un archivo excell donde le digo donde están las rutas y el orden en el que tiene que buscar. Debería darme como resultado 54 Shapefiles, pero sólo me da el primero bien y luego sigue trabajando sin dar ningún error hasta el final pero sin escribir ningún archivo más. Alguien sabe cuál puede ser el error?Muchas gracias por las respuestas.
Hi, I'm trying to execute a query on AZURE Spatial database using SQL creator. and generate features. When I specify Reader options on SQL creator it doesn't give Azure Spatial as an option (only Azure non-spatial). Therefore it doesn't read the geometry
I want is to make an ArcPro Geoprocessing tool from FME workspace that would have functionality for user to input different values for certain variables and do calculations (just like any geo processing tool in ArcPro tool box).I am able to create a Spatial ETL tool in ArcPro and link workspace with that tool, however I am struggling to find a way to make that add different variables as parameters that user can choose or calculate values from. I would really appreciate the help on this subject and surprisingly I haven't been able to find much material online as well (or maybe I am looking at the wrong place). ThanksH
I selected the sworld_scale on the feature type properties attributes in hopes that would take care of it, however I cannot seem to find an appropriate Target Attribute in the AttributeCopier Parameters.
I am trying to find a way to simplify/generalize the dataset below. There are a number of neighbouring plots similar to the one marked in blue. I would like to merge (dissolve) as many as possible of these whilst retaining the overall shape and those plots with more distinctive shapes.The original features are lines, but in the stage shown below I have created polygons and added a centre point. The plots I want to merge are rectangle shaped and of similar size. They are of course not true rectangles, that would be to easy, most have around 7-12 vertices.I tried the FuzzyParallelLineFinder but inner and outer lines where all computed. I want to keep the outer. I have the feeling that dissolving polygons will give me the result I want without having to patch everything up towards the end. But I could of course be wrong about that.If there is a easier way to do this than the one I suggest below, please let me know!My thinking is that in my "rectangles" the distance from the cent
Question time!I have straight lines in 3D, oriented in many different ways, and I want to create cylinders (pipe). I do not want to use the 3DBufferer and I do not want to extrude a buffered slice. Is there another simple way of doing this?Kind regards,Peter
Hi All, One of our customers asked if it's possible to write GML 3.2 Simple Feature Profile level 2 (SF-2) in FME 2019 / 2020 and if not, is there another way and/or when will this be possible? Kind regards, Krien Guijt
I have a database table. This table has an attribute "TEKST" which contains the XML as a CLOB. My questions is, how can I, with FME, extract the XML from the CLOB so that I can process it like any other XML file? Many thanks in advance! :)
Hello, I have a simple workspace that is reading in a feature class from a source geodatabase and writing it out to my target geodatabase. I am using (and need to use) a drop and create table handling method to write the feature class. The source feature class I am reading from is contained in a feature dataset. I don't want this feature dataset to be written out to the target geodatabase; I am only interested in writing the feature class it contains. However, the writer recreates the feature dataset from the source gdb, even though I left the Feature Dataset Table Creation Parameter in the writer null. How do I configure my writer so that only the feature class from the source geodatabase is being dropped and created, while ignoring and not recreating the feature dataset? Thank you.
I have just started using FME. I am working on a Feature class that have multiple fields that has "Year" values. I am trying to bring my multiple year field values into one field and create a new table. I have been banging my head on this problem for few days now but no luck there, so I will really appreciate some workflow to work on with Thanks in advance H
Hi, i have a question which i think should be solvable with fme but i don't know the right transformer(s) to get the solution. I have this table with points and id's. I would like to know the best way to calculate the highest score (1+2+3) but without using one id twice.Do you have any id how to solve this? *** Some extra info: Calculation 1 is not valid, here the sheet pics just the highest values (but picks A twice (not allowed) Calculation 2 Here it picks the value of A (10) because it is the highest value in the table, but overall it is not the highest accumulation of points. Calculation 3 is what i am looking for, Here it picks the value's which calculates the heighest overall points for the table Jan
I need from the left part (attribute name) get the right part.Abcd.EfgT.OpKTs ----> OpKTs When using BulkAtributeRenamer with this Regex, result is the same:Action: Regular Expression ReplaceText to Find: (^[A-Z]{0,}\\.)([A-Z]{0,}\\.)([A-Z]{0,})String: \\3
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.