FME Form

FME API version of module 'NULL' matches current internal version (3.8 20200115)FME API version of module 'NULL' matches current internal version (3.8 20200115)Loaded module 'LogCount_func' from file 'D:\\FME2020\\plugins/LogCount_func.dll'FME API version of module 'LogCount_func' matches current internal version (3.8 20200115)InputStream::decompress(): No such compressor zlibError running translation.

I have to combine 30 sql tables into 1 while preserving globalID unique identifiers. These tables have slight differences in column names (i.e. GlobalID vs globalid or JobsiteGlobalID vs JobGUID). These need to be mapped during the insert. I want to be able to run this multiple times so I'm looking for an "if not exists" append transformer. Any recommendations? I've looked as FeatureMerger, but it doesn't seem to work with 30 readers. I've tried a simple append, but re-running causes issues.Thanks.

Hi folks, When working with XML files, often I find it really usefull to be able to use the XSD reader to directly structurize the XML in FME feature types, AND to be able to use the known XML schema to generate the correct schema (attribute names, list elements, data types etc). However, when working with the XSD reader, I noticed something peculiar, which I think might be a bit of a bug.  The thing is, when you select a feature path, FME will generate a feature type with all attributes/lists that are contained at that path.What I think is quite nice and usefull, is that when you select both a feature path and a subpath of that feature path, the attributes/lists that belong to the subpath, are not included in the feature type of the parent path.  So in my case, when I select only 'msg:GMW_PPO' for the feature path, the feature type contains all contents of that feature path, including a list attribute for the subpath 'msg:GMW_PPO/msg:monitoringTube'.If however I select

I have a layer with 75 parks. I need to buffer all of them with 300 meters. But after this I need to clip the buffers with roads and railways(barriers). When I done this I only want to keep the polygon that are on the right side of the road. Sometimes these areas intersect an other park. So if I go for spatialfilter areas are kept even though they should not be. On the pictures below I only want to keep the selected polygon(yellow) because that polygon are intersected of the orgianal park. I've tried group by i spatialfilter but get no success. Is it possiable to solve this? Have attached my workbench with orginal data.  best regardsJesper

I PyhtonCaller that renames some feature classes/tables once they have been loaded to SDE database and checked using arcpyWhen I run the workbench on FME desktop I have not troubles, but when I publish the workbench to server the feature classes/tables can not be found. The Error is ArcGIS Pro: 000732: : Dataset does not exist or is not supported. As the arcpy works on my desktop, this would indicate that the paths are correct, but I may be missing something needed on our server.The environments areDesktopFME 2021.0ArcGis Pro 2.6.1Python 3.6.10FME ServerFME 2021.0ArcGis Pro 2.4.2Python 3.6.8 One of the paths is \\\\tnad.tasnetworks.com.au\\share\\Applications\\ArcGIS\\SDEs\\Dev\\BaseData_gisadmin_gisdbsdev1.sde\\BaseData.DBO.land_district Only difference between the paths is the feature class/table name and some have a Feature DatasetI have tried variation or relative and named paths and backslash forward slashesThe values are passed to the python from attribute values, so I don't

Hi, are there any plans for implementation of the following raster formats in FME: • USDZ • 3dsMAX • PLN (ArchiCAD) • 3dm (Rhino) • C4d best regards Thomas

Is there a way to read SAS tables without the Stat/Transfer application?

I have a SQLExecutor that runs fine on Desktop but does not output any results on FME Server. The Server log file indicates that the SQLExecutor created results but that they are not being output to the downstream workspace. Any idea why Server might be behaving like this? Here's some log output from Desktop:2021-11-02 12:06:53| 492.3|  0.2|STATS |SQLExecutor_4_RESULT Feature Counter -1 361 (TeeFactory): Cloned 132885 input feature(s) into 132885 output feature(s)2021-11-02 12:06:53| 492.3|  0.0|STATS |SQLExecutor_4_INITIATOR Feature Counter -1 2147680433 (TeeFactory): Cloned 1 input feature(s) into 0 output feature(s)2021-11-02 12:06:53| 492.3|  0.0|STATS |SQLExecutor_4_<REJECTED> Feature Counter -1 2147745969 (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)Note that it says "Cloned 132885 input feature(s) into 132885 output feature(s)" And here's the equivalent section from the Server log:806 2021-11-2 04:10:34 | SQLExecutor_4 RESULT Transformer Output Nuker (Te

How to calculate lat long of this lines corner vertex points in FME with help of any transformer or any other useful method with any projection of the shapfile.Anybody can help in getting this Lat long or XY co-ordinated for this four corner positions of any randomn area with any projection.Just need to extract XY Co-ordinates. how can we generate or extract it. Please find below snapshot for reference to understand it better.

Hi,I am trying to complete this trail where it is requested to connect to a FME Server in order to upload the workspace. To try that I started a VM on stringo. But I dont know which FME Server Parameters I have to enter now to connect. Also I would like to access the web interface of the server in the VM but I didnt manage to login, maybe you can tell which login credentials are neccessary?Cheers,Merlin

Hi, I have a postgresql database I am writing to it has the following fields:    changedetect_date timestamp without time zone NOT NULL DEFAULT now(),    changedetect_uuid character varying(36) COLLATE pg_catalog."default" NOT NULL DEFAULT uuid_generate_v4(),    pk_index integer NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ), All these fields do not need to be inserted into by FME but FME is trying to insert NULL's into them even through the fields are not explicitly set in my feature writer (set to automatic and does not have these fields). When it inserts postgres gives an error 'ERROR: null value in column "pk_index" violates not-null constraint DETAIL: Failing row contains (...'POSTGIS writer: A fatal error has occurred. Check the logfile above for detailsSuccessfully closed POSTGIS database writer=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- What can I do to get around this? I tried using ma

I have two arcgis online feature layers (jobsites and trees) that are in a 1:M relationship. On the trees reader, I've set where clause as "EditDate" >= CURRENT_TIMESTAMP() - 7. The resulting features in this reader have the globalid attribute found in the jobsites layer. I would like to read just jobsites with globalids found in the trees reader. How do I create a dynamic where clause for the jobsites useing a unique list of globalids from the trees layer? So far I've used Listbuilder, DuplicateFilter, ListConcatenator, and StringReplacer to get a list of unique globalid's - '{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}' The first issue is how do I make the string say the following:GlobalID IN ('{28F268A5-7390-4FF

Is it possible to resample a raster so the values left are one of the existing band values? If I use the raster re-sampler with the average 16 interpolation type, I get an average of the 16 cells but what I need is the value that occurs the most in these 16 cells.

I am unsure as to why I'm not able to connect to NetSuite via the ODBC connector in FME. I have Windows 10 (64 bit), FME Desktop (2019.2 b 19801 64bit) with the ODBC (64bit) driver installed. I have verified that the connection works in ODBC Source Administrator and also in Excel.  The error I receive in FME is: Error connecting to databaseDatabase Generated Error Information:Database Error Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedDatabase SQL Statement Text:SQL State: IM002Variable Information:ODBC 3.x Reader: Failed to connect to databaseI have verified the data source name matches with the username and password in the reader parameters, but I am unable to connect. Any ideas as to what I could do to get it to connect? 

I've just finished the Academy Exercise: Improving Workspace Style. In the tutorial, the supplied workbench included a Creator transformer that fed into a FeatureReader which references a geopackage   Why is Creator used in this context? Why is this pattern used instead of using a GeoPackage Reader? I've read the doc page on Creator and searched for blogs but I haven't yet found anything that explains why Creators are used generally, or in a scenario like above specifically.  Is there a link to some good explanatory documentation or training? Thanks

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?