FME Form

I am tyring to insert into a PostgreSQL table where i have a primary key defined as serial (auto increment).   I want the database to increment this field and not have to supply the value from FME.  FME keeps failing due to the Null constraint on the field.   I have tried suppling 'DEFAULT' and 'NEXTVALUE('Seq_name'") as a string to attempt to fake it however both complain that an integer is expected and not text.    I am using FME 2011.  Any suggestions?

I have a jp2 and jpw file. Reading the jp2 results in the data inspector showing the resulting data in the wrong location. How can I fix the location? I've tried setting the coordinate system on the reader but that doesn't fix it. I know the j2w file holds information about the location of the jp2 but I don't know how to read it along with the jp2. I know I'm likely missing something simple so I appreciate the help.

Hi folks, I started using the Tygron API, which I used to extract building information for a specific location/site. However, when I request the building information, the response body is a JSON Array with JSON Objects of which only approximately 1/3 of the JSON Objects are actually about buildings. To determine if a JSON Object is about a building, I'm checking if it contains a "BAG_ID" attribute. Below is some a sample_json Array that illustrates the data structure I'm working with:[ { "id": 1, "name": null, "attributes": { "type": "Bridge" } }, { "id": 2, "name": "just a shed", "attributes": { "type": "Shed" } }, { "id": 3, "name": "just a house", "attributes": { "type": "Building", "BAG_ID": 1.5010000000035E14 } }]In the real world data, the JSON Array contains a lot more features and data.  Initially I queried out the JSON Objects on buildings using the following steps;JSONFragmenter (create features for individual JSON Objects),JSONExtractor (Extract BAG_ID at

I've created a workflow to update, delete, and insert new records to an hosted feature service. The delete and update have been throwing log errors like:ArcGIS Online Feature Service Writer: 'updateResults' error for a feature in 'Job_Line'. The error code from the server was '1019' and the message was: 'The specified feature could not be updated or does not exist.' In the reader, I'm making sure to include arcgisonline_globalid and arcgisonline_objectid in the format attributes window. These appear in the Joined output for the FeatureJoiner (for updates) and the the Deleted output of ChangeDetector (for deletes). I'm really scratching my head as to how to the OBJECTID's can be incorrect in the writer when the reader is the same online source. The parameters for the Writer have Use GlobalID = No and Preserve GlobalIDs=No.For the layer, parameters are set to Writer Mode = Update (dont think this matters with fme_db_operations) and Trunca

I want to calculate distance from aspect and slope on a raster. Both raster have same resolution. Could someone help on this? I am novice on raster dataset in FME. Thank you in advance.

When dealing with JSON data, I sometimes like to use the JSONiq XQuery extension to manipulate JSON data a bit more directly. For example to be able to directly query for only relevant data (see e.g. this question), or directly setting list attributes for portions JSON without the overhead of fragmenting/flattening the entire JSON structure (see e.g. this question). I've been quite happy with the flexibility that the JSONiq XQuery extension seems to bring me, but as I'm using an XMLXQueryExtractor for this, this seems like a bit of a hack, and thus it might be that JSNOiq is not officially/fully supported. For example, I also came across the situation where I wanted to check if a JSON value was equal to null or not. At first I had a look at the JSONiq specification page. There in the Revision History (at the end), I found this line below Revision 1-1;Removed the function jn:is-null() because it is redundant with the "eq" and "instance of" operators which sup

hi, I want to slice a osgb as pagelod ,but cant find any way,who can provide some advice

Hello all,It's Wednesday, so it's obviously time for the latest FME news. This time I'm dividing it into what my colleagues at Safe have been working on, what you beautiful people have been working on, and what I've been working on. Our Week in Webinars, Blogs, and Customer StoriesWhat have our marketing and support teams been up to at Safe this week? Here's a quick review: Blog: The Difference Between Geocoding and GeoreferencingBlog: Coordinate Systems and Earth MovementsWebinar: Coordinate Systems in FME 101User Story: Visimind and the Polish Power GridThis story links to a partner's blog on the project and is - I think - worth a read, especially if you work in utilities.  Tutorial: A major update to the KML Transformations Tutorial  I believe I wrote a lot of this tutorial (as part of a training module) was back in the early 2010s, so this was due an update!  It's important to know that KML is not just a data format but stores all sorts of formatting and

Hello, I have the following dataset (See picture "Before"):- one layer of lines. Each of the 10 lines belongs to a group (a,b, c etc.) which is saved as an attribute. the first and last vertex of a line is highlighted in black.- one layer of points. Displayed in blue on picture.I would like to aggregate all lines that belong to the same group to one line except if there are intersected by a blue point. So all lines of the same group shall be merged into one till they are intersected by the point layer. My final result shall look like "After" attachment which means 7 lines in total. Thank you for your help.

FME Desktop 2020: How to concatenate based on a particular field when working with “AreaOnAreaOvelay” tool? When performing the “AreaOnAreaOvelay” tool, I wanted to create a field at which the values of the “autocad_color” field are concatenated as per the screenshot below. How this can be accomplished?           

Hello,I am using Aggregator with FME 2018.I restricted my data to only one feature. So literally there no aggregation but the transformer is taking 10 min to proceed.Is this normal? Is there a way to optimise it?

FME Desktop 2020: How to filter all features that are “not equal to” a particular value,  For example, in the screenshot below, I wanted to filter all polygons that autocad color doesn’t equal to 10. How this can be performed in FME?      

Hi. I need to convert V7 dgn file to work in V8 Microstation. I don't know how to do it. Im new to the FME. If someone could give me instructions on what buttons to push? :D

I have created one text attribute using the AttributeCreator transformer and by default, its length is 50, there is no option to change this length in FME. This attribute is created for the feature class to save filename which is over 50 characters.

I receive an empty shapefile from our client and if I don't add any features, have to rename it.Since FME is feature based it won't write to a new shapefile if empty. The shapefile can also not contain a null feature so the NoFeatureTester or a null Creator is not an option.I'm currently on FME version 2019.2.1 How can I write empty shapefiles?

Hi! I'm trying to get the effing per-cell formatting to work in Excel but I'm not succeeding. My excel output doesn't come out with a yellow background. Please check my screen dumps and help me figure out why!

Is it possible in FME Server to run a workspace with workspacerunner that starts a workbench on another server in fme desktop? (and uses that license)

While converting Ecw the following error will appear ECW writer: The ECWJP2 SDK only has 200.0 MB of memory allocated to it and this is not enough to compress this dataset. Please set the SDK's memory limit above 304.7 MB

I am setting up a brand new installation of FME Server 2021.2.0.1 and I can't authorize any ArcGIS Online connections. It gives FME Server OAuth Service Failed. It doesn't matter which user I try to authenticate. This works in my other 2019.1 server, so I know these connections should work.

i am using Mapnikrasterizer transformer ,i have input polygon and some lines over it . i would like to keep the output of this transformer without any scaling (without any compressing )as original input .which parameters should i choose at this transformer to do this work ?as info :i am wiriting the output in excel file .but i found it looks not great when i use scaling ,it seems to me that it compress the input and looks not good in excel file . so i would like to have another solution Thanks for help FME 2018 

I've had a workflow that did what it was supposed to with several Revit files, now when trying to work with a new batch of files I am getting the following error:   DataRecorder (RecorderFactory): The clause 'PATH_TO_AN_FFS_FILE.ffs'  within 'FACTORY_DEF * RecorderFactory FACTORY_NAME DataRecorder FEATURE_FILE PATH_TO_AN_FFS_FILE.ffs MODE RECORD' is incorrect.  The parameter to FEATURE_FILE must be a constant value, a value-of (&) attribute, or an FME function call The clause 'PATH_TO_AN_FFS_FILE.ffs' within 'FACTORY_DEF * RecorderFactory FACTORY_NAME DataRecorder FEATURE_FILE PATH_TO_AN_FFS_FILE.ffs MODE RECORD' is incorrect.   The parameter to FEATURE_FILE must be a constant value, a value-of (&) attribute, or an FME function call Revit Native Reader: Failed to create persistent feature cache A fatal error has occurred. Check the logfile above for details A fatal error has occurred. Check the logfile above for details(the path has been replaced to the text in caps lock)Also I

My input has a lot of Ring looking objects in it, when viewed from Autodesk everything is smooth but the FeatureReader doesn't see them as rings, but some dumbed down rectangular shape. Reader: How it should look:How it looks: What I've tried was extracting coordinates and rebuilding with Python and Scipy and it seems that for some reason it has ~380 coordinates in it but 12 duplicates of each exactly at the points where the ring seems to 'break'(coordinates only appear there, nowhere else), could this be source of the issue? Or where should I look? I'm trying to write these to a Cesium Tileset but I don't think that should be relevant since the rings show up like that the moment they get read and not just in the output. Thanks in advance!

I want to read all features in the mxd or gdb and write to gdb. How can I do this with only one reader and one writer

Hi guys,just wondering when using AreaOnAreaOverlay on single input, can it add attribute to show which records's overlap which? Currently i only get the overlap count option but ideally I'd like each record to be added as an attribute field and with a return value so i can see. Thanks in advance 🙂 

When I tried to update existing hosted layer in ArcGIS portal, periodically , I got this error message when trying to access the data by ArcGIS portal feature service readerAnyone seen this before or please help me to fix this error?