FME Form

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 "&quo

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.1data1.2

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 renderingbecause there are too manycan you merge features with similar categoryas in one multipolygon for each categorylook at this image it's like each pixel has been inserted separately as a recordthis is wrongadjoining features need to be merged as a single polygonthat 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 treme

I have some 3D Data with existing appearances - I just want to make a few of them brighter. I can use the AppearanceExtractor to get the unique appearances, and I can see that with the ApprearanceSetter I can apply one based on a trait I can also see that it's possible to just update an existing appearance. I just can't figure out how to just update it based on the appearance name as this doesn't seem to be a trait For some reason I can't figure out how to do this - has anyone achieved this?

Hello! I am trying to create a service area from polygons. I need to create an area that can be achieved during xx minutes with average speed xx km/hour. Is this possible with FME Workbench? (Or do I need to transform the polygon -type into point-type etc.)? I hope you understoor the question and am happy to inform some more.

Apologies for asking what I expect is going to be a very basic question. However I would like to read all files of a particular format (eg dxf) in a folder, apply a coordinate reprojection to them and then output them to a different folder. To read the files from a particular folder I believe I would use the Directory and File Pathnames Reader? To apply the reprojection transformation I would use the csmapreprojector, however to write the many files (eg dxf) out to a different folder I am not 100% of the methodology (and or writer) for that.Many thanks in advance

Hello, Im working with this WMS:https://service.pdok.nl/kadaster/netcapaciteit/wms/v1_0? When I access it with a feature reader then it gives me these layers here:And when ran it just gives me a white area cover of where the data is in the world (right place and all, just no symbols). I am accessing the same data in ArcGIS Pro and there I can query "IndicatiefVerzorgingsgebied" based on symbology and see that it has some 8 sublayers: So my questions are:How can I query and expose these sublayers in FME and make them appear as something else than a white area coverage? And bonuspoints if there are any ideas how to expose the feature specific attribute values as well, such as station, netbeheerder, status, totalecap... and so forth

nID='1' nOperTime='2022-07-31 23:51:56' szUserName='default' EventType='Save Config' Remarks='Saved -P2P- config.IP:Local LoginUsername:default Group Name:user' I want to split this into nID, nOperTime, szUserName and EventType I've tried using the KeyValueAttributeCreator transformer to do this with:- Key,Value Delimiter: =Key,Value Separator: <a single space> After this runs I see thousands of columns created with name 1,2,3,4... which appear to be the value of nID rather than the key. I wonder if the issue is the quotes and if so is there a solution that will see quoted fields as a single value?

Hi ! Keeping an eye one your website is not an easy option to be up to date on what is going on. I'm searching RSS feed for these items :Forums (one feed for all post + one feed per forum)Knowlege base (same as forum : one feed for all + one feed per topic)IdeasUser groups (one feed per group)BlogDo they exist ? Thank you

I am trying to find a way to get the data from IFC file and import it to postGIS data. I tried to do it using a reader of IFC and a writer of postGIS, but then instead of saving 3D data - I get only 2D. When I tried changing the geometry type to geometryZ - I get "Error geometry type parsing" I tried to convert first to GML, and from GML to save to postGIS, but that also didn't work. I would appreciate some help hereThanks,Elyran  

 FME Desktop Build 22304: Moving attribute fields up and down through the “attribute manager” is slow, I couldn’t figure out why moving attribute fields up and down is slow    Is this by design?

I am fairly new to FME and am having a tremendous issue with attempting to transpose columns into rows. I have tried the other fixes to transposing rows to columns but to no avail. Here is the sample sheet I am trying to transpose. And under the inspector it tabulates into thisThe issue is that I am wanting to combine the rows of A and C into columns and having rows B and ROM status falling underneath these columns stated above. Columns E, F, and G are not needed. I have tried using the transposer transformer as well as attribute pivoter with an aggregator but does not work. Any help would be greatly appreciated, and will answer anything I did not clarify.

come si esegue un INTERSECT tra un vettore polygon ed un vettore point?

Hello,I made an FME script to automate modeling when importing new coordinates.I have two column plots "NUM_PARC" 409 and DP139 which fail to create the polyline correctly. Some points with the same numbering are taken from parcels outside the zone.I can't create a link with my area "MOVD_CAD_TPR_PRF_S"(NUMERO:2) and my final result.Can someone help me?Thanks