FME Form

Hey guys, I have XML Meta data files which I read and aggregate to one table to write them in a ArcSDE. The SDE is an Enterprise Geodatabase and the platform is SQL Server. To Connect to that SDE I need username and password. I use the FME Workbench directly in ArcGIS Pro and my connection to the database is existing. When I use the Writer "ArcSDE Geodb" FME is asking me for "Connection file". How do I get such an file? Or is there another way to publish the output directly in the SDE? Thank you in advance! Take care Cheers, Fabian

I'm trying to take a simple shapefile and transform it to citygml. I've found a couple solutions that suggest all I need is what it defined in my attached workspace but the output doesn't seem to honor my extruded geometry. Any ideas what I'm doing wrong? And here is a picture of the workspace if that helps.

I have an old autocad drawing which contains static labels in the 'Banen_Detail-regnr' layer. I wish to convert this to dynamic labels with map annotation templates. In case an object's metadata value (from the Object Data) changes I wish to update this label automatically (CMD: _mapannrefresh / Stringsonly) I can find the attributes values in fme_attrib_info{}.field_name & _value but I cannot write this to a block nor can i link it to the object.

When writing to a csv file with the following settingsIf writing a value such as 18" pipe the field is written to the csv file as 18" pipe This is different behaviour to the 2015 writer where this would be represented as "18"" pipe" It looks like the 2019 writer doesn't consider the presence of a single quote character to warrant the field value to be quoted (although i would consider it to be an unsafe character) Is this expected?

Hello! I have a problem while trying to read the data from postgresql (I'm not an expert). Everything seems fine with database connection (test is successful - also I'm able to connect with the same parameters from psql). The reader is created, I can see the attributes of chosen postgresql table. Everything goes well until I hit the RUN button. Then I get two types of errors: Error executing SQL command ('SELECT c.relhasoids AS oids FROM pg_class... Error executing SQL command ('declare "public_xxxxx_crsr" cursor... Does anybody have some experience with this and can share some guidance. Thanks in advance!

I have 2 kind of points that are connected graphically every 2 points with a line. I would like to know how FME can be used to link the attributes of points with associated ones. I am attaching an example for better understanding.

Following some helpful advice from Shannon in the FME Customer Success team, in place of a jobs board on the FME site I was advised to post a current position we are recruiting for here. We are looking for a seasoned FME Professional with Desktop and Cloud skills to support a team of geoscientists and help mentor 5 or so other FME users within the office. The role within Landmark Halliburton is to continue to develop our suite of geoscience products which include a range of 2D and 3D continental and global scale geological representations of the Earth - see Exploration Insights for more information. Within the role you will be working on further innovations to the product range and helping to shape the direction of product delivery. If you have OL3 and GeoServer experience as well that would be a fantastic bonus. If you are interested please apply through: this link The role is permanent and based in the Oxford office in the UK, the salary range will be between £50 - 70k depending on e

Hello. I have a layer of lines and a table of observations on these lines. The line observation table contains the ID of the line on which the observation is made as well as its distance from the line origin. I would like to build a layer of points along the lines containing the information of the observations respecting the distance of the observations to the origin. Do you have any ideas? My research has only allowed me to create points in a regular way without being able to assign the attributes of the observations. I am a beginner in FME, thanks in advance for your answers.

I have several IFC files, each one has its own structure. I managed to save some of the data as a polyhedralSurfaceZ in postGIS, but some of the data structure is more complicated, and saves as a geometry collection of several types. I only managed to save it to postGIS when the geom type is the general "GeometryZ" but then I cannot used the indexing power of postGIS and queries take forever, and some don't run at all ( like st_volume) is there a way to transform the geometry collections to a solid that will be saved as polyhedralSurfaceZ? example of such data: GEOMETRYCOLLECTION Z (CURVEPOLYGON Z (COMPOUNDCURVE Z ((.... some also have PolygonZ , some have POLYHEDRALSURFACE Z

Hello, I'm experiencing difficulty transforming a .las file to Mojang Minecraft format, as I receive an error stating that the Z coordinates exceed the allowed parameters (0-255). I've found no straightforward way to manually set the maximums and minimums before transforming. I've tried to scale the .las, but the feature is imprecise and results in distorted structures. ​Is there a way to set minimum and maximum coordinates prior to transforming?

Hello everyone, is there any way how to write custom file properties (metadata) to Sharepoint, please? Thanks a lot Lubo

An Oracle table with 16339 features is called in a workflow. After that a tester selects items with conditions: CODE begins with RK or CODE begins with PK. All but 4 items are selected. The workflow works without problems in FME Desktop, but fails on FME Server. As an alternative I put an SQL query in the tabel reader: CODE LIKE 'RK%' OR CODE LIKE 'PK%'. To my surprise it - again - works in FME Desktop but fails on the server. So it seems the problem lies in the Oracle database table. Any thoughts?

In a same dataset I have two columns that I want in a same column. How can I do that ? Thanks

For example, as you see on the screen, I would like an only feature for Roda (and Mira too) in a first column and all the color in another column . Here, I have many line for Roda and Mira, I would like an only. How I can do that ? Thanks!

Hi, Im trying to write a scripted parameter to allow only specified EPSG codes from the CsmapReprojector and apply the correct transformation . Based on a chosen source and destination CRS selected by the user a certain transformation is applied. This works fine, except when I try to use the <Auto> parameter. According to the documentation I should "Use the alternative blank string and NULL_FME respectively when passing in as an attribute." Unfortunately when I use "" as blank string in my script, the workspace fails because "Parameter 'TRANSFORMATION' must be given a value." So how do I pass a "blank string" that triggers the automatic transformation in CsmapReprojector? My script looks something like this: import fme if fme.macroValues['SOURCE_CRS'] == 'EPSG:25833' and fme.macroValues['DEST_CRS'] == 'EPSG:31468': return 'DHDN_to_ETRS89/01_local_grid_FME (Reversed)' else: return "" Thank you for your help!

Hello, I am in the process of developing a 3D noise model using FME to process the geospatial datasets ready to convert into noise modelling files. As part of this process, after having draped road centrelines to make them 3D, I need to then generate an elevation surface from the 3D road centreline geometries that will be used to drape bridges and breaklines so that their elevations align (there is a reason why we want to do this rather than draping bridge and breaklines to DTM/DSM which I can explain if required). Appreciate any advice on how best to approach this?

Hello, I'm currently having a problem with my PostgreSQL and Postgis writers. When the feature operation is set to "INSERT", the INSERT is perform on all columns of the table instead of just the columns that are specified in the attribute definition. It result in empty data on columns that arn't defined in the feature attributes but have a default value in the DB. For exemple : I have a table with 4 columns (column_1, column_2, column_3, column_4). The column_3 have a default value ('my_default') In my script, I have a feature to INSERT some data into this table. This feature have an automatic attribute definition (to avoid defining every new column each time I modify my script). But my customer havn't any data for the column_3 and the column_4. So, the feature in FME have only column_1 and column_2 defined in it's attribute definition (beacause I chose the automatic definition option). After I run the script, the result I'm expecting is this one :column_1column_2column_3column_4data1.

I have a batch file which runs a WB nightly. It also write a log file which is great. But is there a "universal" way to control that the workbench ran successfully? Or do I have to make a script to scan the log file for key words? What key words would that be? Hopefully there is a better way?

I have no problem adding the WMS reader to the canvas (selecting layers etc.), but as soon as I try to read the data I get an error: '<WMS> Exception detected for the GetMap operation, requested Content-Type, 'image/jpeg', returned Content-Type, 'application/xml'.' This is the WMS creating the error: https://service.pdok.nl/hwh/luchtfotocir/wms/v1_0?request=GetCapabilities&service=wms The layer is '2020_ortho25IR'. Does anyone know what is creating this error? Thanks. FME desktop 2021.2, W10

Hello, Is there a way to 'fanout' when writing to an SQL Database? The image below shows a simplified example of what I want to achieve , I have a number of target SQL Server tables and their table names relate to the values in Col2 (I actually have dozens of target tables to write to). I'm guessing I could achieve this by writing to a format that is 'fanoutable' (e.g. Excel), then re-importing and then writing to SQL Server, but I wondered if any one knew of a more eloquent way of achieving this? Thanks, RB

Currently, all the values overlap each other, I only need whatever layer/value has the highest qpf at any given location. See the attached screenshot as an example. This one shows at the location I clicked on there are 6 layers overlapping that location (1 of 6).

Hey I have a dataset from a Z+F scanner in ZFS format. The thing is, the data is coming from an MLS system, not from a TLS system, which means that the point cloud is generated by the movement of the car, not because of the rotation of the scanner. This will result that, the whole cloud being exported to a single plain, as one data record. The original idea is, that if the points can be extracted, the points can be synchronized via the trajectory time stamp, but I was not able to extract the points properly. Please advise, on how to figure this one out, to be able to create a proper MLS cloud. If you do not have the exact answer, but you might have some clue, that would be also helpful. Thank you for your help! Bálint

I need to convert the polygonised raster and populate the raster value into the field category features are inserted but not rendering because there are too many can you merge features with similar category as in one multipolygon for each category look at this image it's like each pixel has been inserted separately as a record this is wrong adjoining features need to be merged as a single polygon that way they will represent a single region yes, I should have no more than (1000 Guess) features

hi everyone, I will give some background information beforehand. I have one dgn file that consists of many models (each model does represent a floor of a building) and the dgn file consists roughly of 1.5 million features (yeah, that's a lot for one building). The idea of my current script is that at first the dgn file is read, some transformation steps take place and finally each floor will be written to a seperate dxf file. So far so good, since each floor/model needs to exported to a sepereate dxf file. However, after some time only a few adjustments are to be made (e.g to only one floor and thus only one model is adjusted in the whole dgn file. Therefore I would need to run the script to overwrite the output of that specific model/floor since changes have occured. I would like to know if there is a possibility of reading the dgn file and only taking the features of that one model that has changed within a certain time. This might reduce the computing time of the script tremendously