FME Form

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 

When running workspaces pre 2022 in FME 2022.'GeometryFilter' sorts out Points, Areas and <Unfiltered>, when I send them into GeometryFilter_4 the <unfiltered> features exit through the Area-port. 

On June 24th I downloaded the version for Desktop and Server 2022.0.0.1 Build 22339. I update my system with those products, and validate the functionality of the workspaces as well as the configuration of the server. It looks like everything is ready to be moved to production environment.I give notice to IT that the artifacts can be moved to production and they require FME Server 2022.0.0.1 Build 22339. Now I receive a notice from IT that the mentioned version does not appear in the downloads list of FME. Now I have to make a whole verification with a new version. 

Hello!Is it possible to get the new file name created (or modified or deleted) by the directory watch and send it into an email via subscriptions?If not, how can I send the new file name detected?Thanks.

HelloI'm looking to keep my geometry from my old state. (polygon with arc of circle or building with inner courtyard) I tried with the GeometryExtractor and GeometryReplacer transformers, but my new state changes by a few centimeters and I would like to adapt my geometry from the old state to my new coordinates.

Hello FME enthusiasts, I am slowly getting better within FME – but now and then I simply get stuck. In my example, I load a simple .xlsx File with a borehole identifier (BID) and a complementing link to its online available drilling profile (URL). The goal is to extract the profile for each BID via ImageFetcher and to write it into a single .pdf File via the fanout option. Works great so far, but I just cannot figure out how to provide the BID as additional information (here: headline directly in each .pdf) via the PDFPageFormatter. Whatever I do, only the fetched raster image is written as .pdf File. This is more a general question, as more information could be added to the .pdf File (e. g. date and time of image extraction). Please see my attached FME template file. I am quite sure the solution is simple, but I need some help/hints. Thank you in advance! Kind RegardsAlexander