FME Form

I have a field with a code (number) and I would like to know if a feature haven't a number code in her line (maybe a message like "error" or other but with letters). Thanks for helping

Hi all, I've published a workspace to FME Server which updates some rows in Excel. When run on FME Workbench, the rows are correctly updating (using fme_db_operation = UPDATE) at the correct row number, which starts at row 10. I've set the row number by using a counter for xlsx_row_id with a Count Start set to 10. Weirdly, when published to FME Server, the workspace ignores the xlsx_row_id attribute and starts writing at row number 1 (even though it gets the correct column positions). Is this a bug in FME Server? Does anyone have a workaround? I've tried different options in the Start Position parameters of the FeatureWriter (both "Named Range Start Row" and "Start Row") but no success... Any advice gladly received, BI

Hi,I have an ifc file and there are attributes like volume, width, height etc . I can't see them in fme. I even tried to expand the format attributes. Does this mean that reading IFC files is limited to a certain number of attributes? How can I turn on the visibility of these attributes? Is it possible? I've attached a screenshot. The attributes I want to process are in a red box. Regards,Aneta

I have 16 polygons (zone) and a feature of points. I would like to clip points by zone and write to points in each zone in a separate shapefile. that means as a result I have to get 16 shapefile from points. Attached you can see the workbench I tried dynamic and fanout. anyway i only get one feature from punkt.

Dear All , We have a line and we need to add an arrow to it , as shown below we need to add the blue line , it looks that we need to use 2d pointer adder but how to get the exact location from the end point and draw two lines

How do you design a simple architecture on Revit and import the IFC file to FME and then convert it to citygml format. Thank you so much.

Vertex normals removed due to application of non-invertible matrix,Error running translation. when I try translate the 3d .obj model to 3dtiles,the error Appear，of course not all obj appear the error

Hi, I am new for using FME to create PostgreSQL database and having trouble updating schema or adding columns to the existing table. so to explain in detail: 1) I have different councils 3 waters pipe data which I want to add to my database2) I have already done extracting, and transforming of data but now I want to load data coming from different councils into a single PostgreSQL database3) So I am using FME writer format "PostgreSQL" and table (say Table1) definition as "Automatic" and ok till I have added the data from one council having 52 columns4) Now when I am trying to add data into same postgresql database table (Table1) from other council having 79 columns in it ... my database is not accepting data from those new columns came from new council 79-52= 27 columns into my existing database table Any comment or recommendation on this will be great!

There are GML/FGDB dataset with "round conner polygon" or multilines geometry which is mixed "curve and lines". It can't be written into GPKG file.src dataset geometryThe output geometry is IFMENullHow can fix it?

My workflow regularly compares files stored at path X with prefix Y with files stored at path Z with prefix Y. I'd like to set up the workbench in such a way that I'd copy the workbench for a project and only have to edit the Y parameter for it to read in the required files, i.e. Read: $(Path_to_X)/($Prefix_Y)*.csvRead: $(Path_to_Z)/($Prefix_Y)*.csv Can this be done, and if so, how?Thanks!

Hello, would anyone know how to group data under one airport? I have 32 airports, each airport has x UUID_departure and each departure UUID has x departureLegs and each departureLeg has two points. DepartureLeg has a unique ID and each departureLeg point also has a unique ID (it can be a variant of startpoint and endpoint). I have finished the connections, now I just need to somehow pair all departure legs under one UUID_departure and not connect individual points to these departure legs. Connect this whole thing to the airport. Is there any such transformer outside of featureMerger? I am attaching the WS on the download link, it is too big with data. Thank you!!!download link: https://www.uschovna.cz/zasilka/AQ2HU24BLI9F2R6D-XCY/

basically what i. want is that the outer polygon should be a doughnut-like shape, currently, its area is also covering the higher value qpf polygon inside (darker colours) it should have multiple polygons, just none that overlap the shp file needs to be clipped by itself

Hi I am interested in understanding the standard pattern to develop web services in FME. The standard use case is an external application post data to an FME server endpoint (e.g. polyline GeoJSON), have FME transform it (e.g. add a buffer around line), and return data back (e.g. GeoJSON again). I am trying to get my head around repositories, workspaces etc. Looking at it now it seems like the above needs to be accomplished with mulitple steps? Potentially posting data to FME server first, then submitting a job, then getting the results, then getting the final data? Thanks in advance,Nick

Hi all,  I was wondering if somebody could advice me a good tool that can be used for good version control of FME Workbenches and FME Custom Transformers. Any suggestions? Preferable an open source tool.  There are some  tools available for this, but most of them offer also automated "merge" and "compare" functonalities and in my opionion  this doesn't work well on .fmw en .fmx files, therefore I prefer not to have this functionality.  In case there is a difference, the user should be the responsible to choose the local version or the version of the server to decide which one to keep. Also multi-user-editing of the same workspace is not something that works in an FME environment (yet). But I do have interest in the back up functionalities, the compare functionalities, have a single repository of the main workbenches, being capable of taken the models locally and run them locally,...  I experimented with GIT version control, and It helps, but it is not exactly wh

Our data is in the cloud and there is possibility for increasing the performance of our network disks on the cloud. However doing so, will lead to much higher costs. So if the performances of the fme scripts are mostly determined by internal memory of the computer, then maybe we wouldn't need to increase the performance of the cloud services.

Hi altruist, I am having an issue in after using AreaOnArea overlay operation. I have overlaid two polygon datasets and ideally the output should have attributes from layer when there is _overlap field have 2 and more. This is what happened for other overlay operations. However, in the following cases I do not see the attribute from one of the polygons after the overlay operations: This is the attributes before overlay:The overlay operations:After the overlay:Does anyone have idea why that may happen?

Hi everyone,I try to put the "responsibleOrganisation" and " annotation" in my AIXM 5 writer. My workbench seems to have an issue but i didn't find where is the problem.I tried with an older version of FME (2017) and everything is good. I put here the 2 versions of the workbench. ( 2017 and 2022). With the written files output. If someone could help. Something seems to ne wrong with the "geometryPropertySetter", with the "XMLTemplater", and probably with the writer AIXM5. 

Hello!  I am trying to write to an MS SQL DB and some of the feature classes have a primary key where the column name is longer than 30 characters.  On the writer feature types, I can set the default primary index colum to a length longer than 30 characters, but when I look under the user attributes, the column name gets truncated to 30 characters.  When I try to write the features to the DB, it fails because the field names are no the same.  Does anyone know if there is a work around for this, or how I can get a column name longer than 30 characters to be recognized under the features user attributes?  Thanks! Tristan

Hey guys, is it possible to perform an INSERT/UPDATE/DELETE operation (fme_db_operation) on GeoPackage using an UUID which isn't an integer?The UUID was created by UUIDGenerator. If I execute the following workspace, I'll get this error message:e.g.OGCGEOPACKAGE writer: Cannot perform Delete on feature type 'original' by matching attribute 'UUID' since value '{48fb8445-ca8d-4f74-94ed-b0ce6c89ffdc}' is not an integer. Skipping feature. Workspace:Writer-Settings (unfortunately in german language) Thank you very much!

I'm trying to import different IFC modells via IFC Reader and for some it happens that the walls do not contain the respective openings where the windows are (see Screenshots of BIM Viewer and FME Inspector. I tried different import settings, and thought especially "Subtract Opening Geometries" should solve the problem but it still didn't work. I'm having a hard time finding a solution as I'm not entirely sure how FME cuts out these openings.  Any suggestions what might casue the problem?

I'm currently exploring MapBox and their Tiling Service, which is currently in Beta and I'm trying to figure out how to create a line-delimited GeoJSON output so I can upload via their Tileset API.  The data/file needs to take the format as per the example below: Normal GeoJSON{    "type": "FeatureCollection",    "features": [        {            "type": "Feature",            "properties": {                "name": "Melbourne"            }, "geometry": {                "type": "Point",                "coordinates": [                    144.9584,                    -37.8173                ]            }        }, {            "type": "Feature",            "properties": {                "name": "Canberra"            }, "geometry": {                "type": "Point",                "coordinates": [                    149.1009,                    -35.3039                ]            }        }, {            "type": "Feature",            "properties": {                "name": "Sydney"         

I am trying to read the following URL (https://eprostor.gov.si/ods/atom?id=1&type=data) with a FeatureReader transformer so that it will download the zip file and process the data within. This works fine with many other URLs I have used in this way (e.g. https://services.cuzk.cz/gml/inspire/ad/epsg-4258/583723.zip), but not for this one.The error is:XML Parser error: 'Error in input dataset: 'https://eprostor.gov.si/ods/atom?id=11&type=data' line: 1 column: 11 message: invalid byte '�' at position 1 of a 1-byte sequence' I have attached an example workbench and associated csv containing a successful and failing URL in a list. I'm wondering if anyone else has ever come across this issue, and/or if anyone has any ideas as to what is causing the problem, and if it can be resolved in some way. The only thing I can think at the moment is the fact that the URL that is failing does not contain `.zip` at the end of the URL, or is maybe passing in some mis-information in the headers - t

Feed Detail (safe.com) I search a question about cesium 3d lod, but The description is not clear，who have some advice?

Hi All, I'm trying to write Bag-ids (adress ids of the Netherlands) to an Excel or CSV file. However I'm unable to write it to these formats without destroying the data.  Source data example Bag_id _ 0735200000017598 1735200000017598  If I write it to CSV i'm losing the prefix 0 (while using varchar type).If I write it to Excel the numbers without the prefix 0 are rounded (while using the string type) See appendices. The only fix i'm able to come up with is prefixing everything with " ' ". But that of course transforms the source data. This I don't want. Does anyone have a solution for this? I have added my test sample in the appendix aswell (e.g. source_data_v3)

FME Desktop 2022.1 Build 22618: How to perform the “AttributePivotor”? I couldn’t figure out how to apply the “AttributePivotor” in order to derive the “R” table from “Q” table as per the screenshot. The data is attached