FME Form

I was following this example to write/update the metadata from SDE.https://community.safe.com/s/article/working-with-geodatabase-metadata-writing-to-xml READER features: from SDEREADER metadata: from SDE WRITER: GENERIC (4 options: SHP, FGDB, DWG, KML) I was able to write both spatial features and their metadata to FGDB (using ArcGIS Catalog to view both features and metadata).But when I picked the output as Shapefile, the features were written out with a boundary (for lines, but not for points). E.g. I have a point file with 722 features it will be written as 722 features. If I write a line file with 1000 features then I will end up having 1001 because there is a boundary linework written as one of the spatial features.Also, the metadata wasn't included in the shapefiles (using ArcGIS Catalog

Hi all.I'm trying to expand an existing workflow, that outputs Shapes and TABs (and FFSs) just fine with an option to output GeoPackages as well. This does not go well.I'm using dynamic schemas, and merges the relevant schema information onto each feature. Then I use FeatureWriter with "Schema from schema feature" to output the data to a file, to be attached to an email. I normally use ZIP, but in this case I just want to use GPKG.The first problem is, that the writer ignores the request for dynamic schema, and attempts to output any and all exposed attributes.The second problem is that each attributes gets the data type TEXT(200).Is there a trick to have FeatureWriter outputting a Geopackage with dynamic schema ?Cheers.

Hello,i tried to read a mesh model in the format .osgb, but it doesnt work.The osgb-files are made with the SURE Software.As information it says "OSG Reader: Ignoring unsupported node".Regards Isabell 

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 su

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 Featu

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 Serv

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=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

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 sa

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

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 lo

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 =

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.

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