FME Form

I have thousands of data, and each datapoint has six attributes, which I want to store in one list per data point. Which transformer could be used for this?

Hi, I need to work with a file that uses EPSG:5682 as CRS but unfortunately it's not available in the CS Gallery. I tried to add it as a custom CS, as described in the online documentation but it's still not showing up. This was my workflow:I went to the online tool and pasted the ESRI WKT for EPSG 5682I entered the missing parameters (that weren't already populated from the WKT)I unzipped the files provided by the tool and copied them to ..username\\Documents\\FME (see attachment)After restarting FME, the custom CS is still not available in the gallery. Did I miss something? Thank you for your help!

Hi, We are creating an integration between Smallworld and FME Server. The Smallworld tool will call an FME workspace on our FME Server. The FME Server is hosted internally only and we are using built in authentication.  There is an option in FME Server to create a short lived session token via the api. I've set up a user that only has access to this repository that can be used to generate the token.  There is a second option in the Administrator interface to generate a fixed api token. When is this used? Is it more or less secure? The Smallworld developer notes that if you are using a user name and password to generate the short lived token then the risk is similar:'It seems to me that the API token with restrictions is more secure than username/password. Such a token is long and not recommended. It can be extracted from the Smallworld session and this applies for username/password.' For integration with Portal for ArcGIS we use the short lived token generated by a built in

Example: We have a layer with employees. Each employee has their own unique polygon. We can easily go in and create unique symbology for each person. We can use hashing and colors to allow overlaps.  The issue is finding a way that every time someone new is entered in the employee database, they get symbology automatically setup.  In other words, does anyone know if FME can create a new layer file, symbolized with rules, that accounts for new rows/values. We were hoping to find something in ESRI solutions but haven't so far. So now wondering if FME can just automatically recreate the base layers files that the map service would ultimately consume.  Thanks

I want to change the text alignment of the texts in a dgn with an attribute manager before further editing. Does anyone know the attribute that is responsible for this? Thanks.

I am downloading data through an API from OS open source. The connection is set up correctly and the data is downloading when ran but it downloads several versions of the data in several formats such as SHP file, GML and Geotiff. For my project im working on I only need the shapefiles but I cannot figure out what tool to use to filter the rest of the unwanted data types out correctly. Or maybe its not a tool and its done in the JSONfeature parametres?I have attatched some photos below so I hope it helps clear up any questions.

The above image should explain the issue.  I have tried AreaGapAndOverlapCleaner which fills the donut and dissolves with 1 of the polygons (I have chosen the polygon with the longest boundary at present), which results in below. This is ok but ideally I want the donut evenly split across both polygons. Is this possible? Can anyone recommend a transformer or number of them to get my required output?

I'm doing a basic transfer of Geomedia Text Features from one table to another. In the past I've always done this by exposing the oracle_element{} attribute and exploding the list. This is always worked fine but I'm running into problems with certain features that don't contain the oracle_element{} attribute. An example of what I'm talking about:create table source (id int, geometry mdsys.sdo_geometry);create table destination (id int, geometry mdsys.sdo_geometry);insert into mdsys.user_sdo_geom_metadatavalues(    'SOURCE',    'GEOMETRY',    mdsys.sdo_dim_array(        mdsys.sdo_dim_element('X', 610000, 660000, 0.0005),        mdsys.sdo_dim_element('Y', 5500000, 5550000, 0.0005)    ),    82232);insert into mdsys.user_sdo_geom_metadatavalues(    'DESTINATION',    'GEOMETRY',    mdsys.sdo_dim_array(        mdsys.sdo_dim_element('X', 610000, 660000, 0.0005),        mdsys.sdo_dim_element('Y', 5500000, 5550000, 0.0005)    ),    82232);-- row that translates correctly, sdo_gtype = 2001insert

Hi, I've a bunch of features relative to adresses and associated inhabitants.I've already grouped the features by similar street names and numbers wich results in the "match_id" column.What I need now is to sum each four "total..." column's value (separately) by using the "match_id" as grouping value.The goal is to get the number of peoples, etc ..., living at one adress.I've tried several transformers after the AttibuteManager but none return the attented values. Thanks for your help

Please can someone tell me how to write a WHERE clause in the feature reader that excludes records that do not contain a value.I have thousands of records and some of them have a Global ID - I want to keep these records.I also have records that contain NULL or no value - I want to exclude these values.I can perform this function in a Tester, but a colleague informed me having this clause built in to the feature reader instead will be much quicker. Perhaps someone can confirm this.Thanks, Frank

Is there a way to extract only the non-empty fields of an oracle table?Let's say I have a table like this one,    col_a    col_b    col_c    col_d   col_e    NULL     NULL     NULL     NULL    5    NULL     NULL     NULL     8       6    0        NULL     NULL     NULL    3    NULL     NULL     NULL     0       1and the subtable that I would like to extract should be    col_a    col_d   col_e    NULL     NULL    5    NULL     8       6    0        NULL    3    NULL     0       1Thanks

Hi Everyone, My Question:I am trying to read the Pset of an ifc dynamically. I have looked at a few sources in the forum but have not been able to manage. I would love some help on this topic. I have read a few articles on Dynamic Schemas and Updating Ifcs etc:https://knowledge.safe.com/articles/594/updating-ifc-example.html https://knowledge.safe.com/articles/1136/schemamapper-transformer-tutorial.html https://knowledge.safe.com/questions/32777/how-to-expose-all-attributes-in-generic-way-any-ma.html  My aim is to expose part of a custom ifcpropertyset that are created by an external user. I will know the naming convention, but I want to be able to use Regex or some sort of fuzzy match to catch the Pset incase there has been a mistake in the creation of these Propertysets.  For example if the Custom Pset is called "Pset_Project", I would like to expose it and all its Traits.But I want to make sure that if someone writes "Pset_prject" or "Pset_project1", th

Hi everyone, I need to retexture a citygml file using one (mosaic)image file. But I am facing an issue in the last steps using the Appearance Setter. I started with the WallSurfaces and managed to calculate the (row,column) coordinates of each wall-vertex on the new single image (derived from the previous textured model that used multiple images for one building in the appearance folder). The position of a (sample) wall3D projected on the mosaic-image looks correct, attached a screenshot from QGIS. I rescaled the row column coordinates to a 0,1 scale, with (0,0) representing the lower left corner of the image, and stored them as list-attributes for each wallsurface. I used these lists to set the u,v texture coordinates with the measuresetter transformer as explained in this useful post on texturing citygml :https://community.safe.com/s/question/0D54Q000080heXzSAI/3dcitydb-texture-coordinates Afterwards I used the appearance setter, connecting the imagemosaic to the appearance input, th

Hello I want to automatically add a tree to a class I want in classified point cloud data, how can I do that? Can you write me the order of the FME conversions, thank you very much in advance for your valuable information.

Environment - Ubuntu 16.04 LTS Docker Host, running FME Server 2018.1.1-20190122 images I am receiving an error - There was an error submitting the job - when trying to run a workspace within FME Sever. Digging through the FME Server logs I find the following error within the Resources > Logs > tomcat > fmeserverweb > localhost current log.07-Mar-2019 09:05:10.300 SEVERE [http-nio-8080-exec-1] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [JobRunnerForm] in context with path [/fmeserver] threw exception java.net.ConnectException: Connection refused (Connection refused)    at java.net.PlainSocketImpl.socketConnect(Native Method)    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:3

Hi,I have a MicroStation file (v8) with a table in it that I need to extract to csv. Can someone please advise? I am using FME2020.1 and I have attached the dgn.Many thanks,Chris 

Hi all, I have a couple of point features which are feeding through with polygons (as the points should join to polygons, bar these 2). I've tried the GeometryCoercer and CenterPointReplacer etc but no luck. Is there something I'm missing which could create even a small polygon from a point?

I've encountered this error a few times and can't figure out what exactly is going on. 2022-08-16 08:34:06| 51.4| 0.0|ERROR |Esri Geodatabase Writer: Feature Type Definition 'Output' was requested, but not defined. Please visit https://www.safe.com/support2022-08-16 08:34:06| 51.4| 0.0|ERROR |BADNEWS: GEODATABASE_SDE writer: A fatal er I have an SDE writer after a reader that is reading a PNG. From what I understand it might do with the fme_feature_type being a PNGRaster but if i change or remove it I get the same error.

Hello, I have a (excel)list of points [x,y,z] which was recorded along a cable. The recording was done contiguously both upwards and downwards. Unfortunately without marking the reversal points. The starting point of the cable is the first point of the recording in the list. If I now generate a line from the point list using FME, I get a 3D line which runs both upwards and downwards. My goal is to split this line into two lines, but I haven't found a transformer that will give me the inversion point. My idea for determining the reversal point would be to determine the reversal point based on the distance to the starting point. The reversal point would then be the point from the point list with the greatest distance to the first point in the point list. How could I solve this elegantly in FME?Thanks a lot for your support

I can reproject CSAR point clouds but I can not write them to the CSAR point cloud format, only to ASCII XYZ.

Hello everyone!I have a problem that I don't quite know how to approach.I want to automate the production of coordinate frames in AutoCAD.The idea is to define a work area (by a square polygon) and extract the relevant coordinate frame for it, as attached in the file, and in the picture.The question is, how can I attach the coordinate labels to the relevant places on the frame?I would appreciate advice from those who can give..Thanks!

Hello!I have trouble connecting to the Fme DataExpress app, I enter my login information, and the URL of our fme server, and it gives me this error: I would be happy to help if anyone knows the problem.Thanks!

I'm working on a workbench converting CSV files with WKT geometry into autocad SDF. For some featuretypes i want to allow multigeometry. If I manually make a new feature in autocad map I can select some geomtric types that combine line and surface, point and surface, etc. .If I set the fme_geometry{0} in the schema to FME_point, i get the SDF point geometric type. But if I add fme_geometry{1}: FME_line, fme_geometry{2}:FME_polygon (This is what it looks like when I read a file with this combined geometric type into FME). It looks like only the geometry{0} is read and I also get the Geometric type point.Is there a way to use these other types? like point+curve, point+surface, .. ?screenshot below shows the geometric types available in SDF: