FME Form

In the workspace I have a geometry extractor transformer, which outputs OGC Well Known Binary format.After geometry extractor, SQL server non spatial writer follows. In the writer, the WKB field is defined as the varbinary (width 8000) type.In an SQL server database, this field is defined as a varbinary (MAX) data type.All translations went smoothly in the latest FME Workbench 2021 version.However, in version 2022, it does not work. I tried different data type combinations for sql server writer and for database, however without success. 1. casewriter data type: database data type:varbinary (8000) varbinary(MAX)  Microsoft SQL Server Non-Spatial Writer: Attribute 'abc' of feature type 'xyz' has specified type 'varbinary(8000)', but existing database table field has type 'varbinary_max'. Information may be lost during conversion.Microsoft SQL Server Non-Spatial Writer: Attribute data '\\x01\\x03\\x00\\x00\\x0\\x95\\xAC!AR\\xB8\\x1EU\\ ... ' too la

We have an IFMEFeature from type FME_GEOM_AGGREGATE.The window "Feature Information" in FME Desktop displays the IFMEMultipoint property with 299 parts of IFMEPoint.How can we get these multipoints in the writer plugin? If we call feature->numCoordinates() we got 598 but if we call numParts () or numVertices() we got the correct number of 299.And if we call feature->getAllCoordinates() we got a list of 598 coordinates, but only 299 of these are correct and the other ones consists of a point with coordinates (1, 1, 0). Where does this point (1,1,0) come from?The list of coordinates starts with1,1,0valid point1,1,0valid Point1,1,0....

Hi list.I got a curious error in a workspace, which I needed to update.I needed to update some schema references (from .../1/... to .../2/...) and thought that it was a good idea to create a private user text parameter, containing the "2" needing to be inserted.However, this yielded a strange error when applied to the root expression in my XMLTemplater. Something like this: "... can not expand namespace prefix to URI"Is it correct that XMLTemplater cannot use user parameters replacements ?And if so, why not ?Aren't these applied to whatever parameters a transformer may have, prior to its execution ?Cheers.

I am wanting to read and write features to a POSTGIS connection however I can't even connect as I am unsure what to do for the schema field. Can someone provide examples of what to add in the schema for table field.

I need to be able to read an existing geodatabase annotation feature class (regardless of whether it is populated or not) and get a value for the "Annotation created with new features" annotation feature class attribute. Is there a corresponding FME geodatabase format attribute? If there is, would FME properly set the geodatabase attribute if I used that format attribute on a schema feauture used to build a geodatabase?

Hi, I have a workspace I am wanting to upgrade from FME 2019.2.3.2 to 2022.2. It creates geopackages that could be read in either QGIS 3.22 (late 2021 release) or ArcGIS Pro 2.6.10. We just tested and they also open in ArcGIS Pro 2.9.5 (Oct 2022 release).Upon upgrading (with or without changing the feature writer to specifically use the new OGC Geopackage writer format) ArcGIS Pro can no longer read the output. QGIS can read it fine.Whilst I presume this is likely an esri compatibility issue, what I am wondering is what the underlying SQLite version is, and what the Geopackage version is - I could not find this in the documentation of the writer (easily - forgive me if I have missed something)?I then have something to check against the esri compatibility as they list out the versions supported. Cheers John

I did a spatial join of two AGOL layers, one is a strip map and the other is parcel data with owner info. I merged the two and created a table with the owner information and its respective page number. Some parcels are on more than one page, however, and I'm trying to make a table that includes these records and doesn't just omit them (there should be an individual record for each parcel and every page it shows up on). I've been trying to use the Spatial Relator with Generate List checked, followed by a List Exploder but it is not working. Does anyone know of a better way to do this? Edit: There is no common attribute between the two layers.

Imagine having a raster with transparent gaps (null) and wanting to fill these gaps with another dataset (presumably of lower resolution). If this second source is placed under the first the secondary data would "shine through" the gaps. This is how one would solve it in Photoshop, and I'm trying to figure out if the same solution is possible in FME. Is it posible to set the layering/stacking order of incoming datasources before running the RasterMosaicer?  (This is a follow up question to: https://community.safe.com/s/feed/0D5Dm000007hjgQKAQ)

Hi, I have a dataset in .dbf format, with 885 rows. When I read the file in FME it reads the 885 rows, but when I use the DuplicateFilter it tells me I have 330 unique rows and the rest are duplicates.  But actually all these 885 rows are unique, I can see that when I look at the file using ArcGIS Pro, and my colleague have looked at the file in another text-application. So it seems FME keeps the total number correct, 885, but changes some unique numbers so they are duplicates somehow. In AGP:In FME: How can this happen? I have tried reading the file both using the "normal" .dbf-writer, as well zipping the file and using Creator > ParameterFetcher > FeatureReader > FeatureReader > AttributeExposer.  

Hello, I have a raster dataset. I need to intersect vector lines with it and then get the average values of the raster cells (pixels) that intersect with the vector line. I have a working solution to do this but I have to convert the raster to polygons with a RasterToPolygonCoercer. Some rasters are larger (8.2M cells) so this takes forever and is very memory intensive. Is there a better way to do this without converting raster to vector polygons? I'm not super experienced with rasters so please explain well.  Thanks in advance!  

I have read all the SchemaMapper tutorials and implemented what I thought should work for a SchemaMapper and input mapping table, but the feature type in question here is not being mapped at all. I am hopelessly confused, hence the following explanation and question: I have a feature type Safety/Fire (i.e. fme_feature_type = feature_dataset/feature_class) that I want to split into three different feature types based on the value of the Type attribute. The values are FDC, Fire Alarm, and Fire Extinguisher. I also want to put the three new feature types into a different feature dataset, namely Life_Safety. Here is a screenshot of part of the mapping table I am using:  In the SchemaMapper I have set first a Filter Features action with SRC_FIELD = SRC_FIELD_VALUE indicated and with Ignore Blank Attribute Values set. Then I have a Map Feature Types action with SourceFeatureType --> TargetFeatureType indicated. Finally, I have a Map Attributes action with SRC_FIELD --> TargetAttr indic

Recently we installed FME server… And I’ve been banging around in it like a bull a China closet… Nothing is broken… just throwing up workbenches and trying to get things to process in the same way they are on FME Desktop. I’m having some success… but I feel its more like luck than “repeatable success”. I’ve looked on the Safe.com website and read through questions and articles… That helps some… but still needing a little more guidance…   What suggestions do you have? What guidelines/articles/manuals/reference material could you suggest? Here are some of the areas/errors where I’m struggling with…  Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`odeq1', userName=`msaccess', password=`***', dbname=`')  Microsoft Word Writer: Aborting translation: Not authorized to access destination file. Please ensure that destination file is closed and check destination filepath  CSV write

I try to run diffrent workspaces with a WorkspaceRunner. It works with a fullpath but not if I use a AttributeValue or a UserParameter fed by a pathReader. The ErrorMessage contains "An error occurred while evaluating a test parameter: @Tcl2 -- failed to evaluate expression `WorkspaceRunner ..." I run it on Windows 10 with FME 2022.1. I already added FME_Home to PATH environment. With FME 2019.2.x it worked fine. An Example Workspace is provided.   

I want to connect the pipelines to each other in Z coordinates at the place where there is a mutual vertex intersection.

What software do I need in order to use PhotoCoordinateExtractor on a computer. ?

Hi. I would like to know how to apply a custom icon for kml styler. At this moment, I could convert from Csv file into Kmz file with icon that I can select at KML Styler with condition Statement (like value 1 = C1). However, I would like to change these icon into my custom icon (png files). How Can I set? Please kindly give some advise to me.

Hello, I am pretty new to all of this, so I am not even sure in which category to post my question. I have created a small FME Workspace containing a Reprojector. Now I want to include this tool into a Python Script already containing different other functions, and it should be possible to select which data to transform as well as the coordinate systems used. I tried to use the FMEWorkspaceRunner(), but it is only possible to state the Source and Destination Dataset, not to use the FMEReprojector.setCoordinateSystems() funktion. The same goes for calling the workspace over the command prompt with fme.exe it only accepts parameters for source and destination. As the workspace contains some other elements as well I also want to use the existing workspace and not to create reader, writer and all fmeobjects in the python skript every time the function is called.

I am using AttributeManager to write a Conditional Statement. I was wondering what other Transformers can I use that allow for Conditional Statements? I can achieve what I want using AttributeManager, as shown here. But, I am looking for alternatives other than AttributeManager to help me hone my FME skills.

I was watching the  OpenAI GPT-3 seminar the other day and the presenters had some magic turned on that allowed them to inspect transformers without attaching the usual inspectors. See image for a better explanation of what I am after. How do I turn on this feature/s? 

Hello FME Community,I want to control which records have no date format.Does anyone know how I can check whether data records have been saved correctly as dates.

Tested in FME 2019 and 2022.2.2 We wish to connect to items that are shared to the organization but not to a group

Does the FeatureMerger actually work as a blocking transformer when no features reach the Requestor port? I mean, for example in the workblow below, I assume the Creator transformer will go first but after that, will it read the json file, wait to see if any feature enters the Requestor port and then go on through the rest of the flow?  I'm reading and writing the same json file so it's critical to know. It works as expected so far but if anyone knowing for sure could confirm I would appreciate.

Fme serverdesktop version: 2022.1 But if no features reach the writer then I get no summary output. In what way can I solve this dilemma?  The image I provided is not of the workspace itself, but it shows the problem.

There are some postings on this but it does not work for me yet:I am trying to contact an external API via HTTP POST to get a token back.It already works with python. But we wanna integrate the workflow in fme server and Iam sure it will work with fme. Python script:# Parameter_____base_url = 'https://apieco.eco-counter-tools.com'api_key = 'XXX'  # Base64 encoded secrets  # Tokenabrufdef get_token(url, api_key):    header = {        'Content-Type':'application/x-www-form-urlencoded',        'Authorization': 'Basic ' + api_key              }    r = requests.post(url + "/token", headers= header, data={'grant_type': 'client_credentials'})     answer = json.loads(r.text)    token  = answer['access_token']    return tokenHTTPCaller: Erorr Message: HTTP/1.1 415 Unsupported Media Type  Which mime type should I use for the grant_type: client_credentials?

I am having trouble with running a workspace with FME Data Express. The workspace is simple, to test out the geometry parameter on mobile, it just returns the coordinates to screen with an html writer, published as fmedatastreaming. The idea is to use it in a scavenger hunt if possible.When I run the workspace with FME Data Express as fmejobsubmitter, it submits the job, and does its thing.When I run the workspace with FME Data Express as fmedatastreaming, the job is never submitted to FME Server. In App I get the popup "Waiting for Data Streaming", which then goes away, and nothing happens. I checked with two colleagues at work, one with android gets the same behaviour as me, one with iOS it submits the datastreaming job correctly. So it may be an issue with the Android app. I don't know how to debug where the error occurs between the app sending(?), and the FME Server not receiving/rejecting(?) the job.We have FME Server 2022.2. I also tested with the Safe demo server i