FME Form

Hi community! I've been trying to formulate an efficient workspace that would:Extract feature service URLs from an excel sheet (many have the item ID number at the end)Download the GIS data from each feature serviceTransform the idea with typical cleaning upWrite out to a file GDB on a local server drive For steps 1 and 2, I've been experimenting with HTTPCaller and FeatureReader but haven't yielded a successful extraction yet. I think 3 and 4 will be straightforward, but if there any any suggestions (specifically with getting from 1 to 2) welcomed, and appreciate any feedback in advance!

I want to Run FME process through task schedeuler. The fme workspace is reading data through postgresql. I am able to run it through any specified user. I want to run this through LOCAL SERVICE in Task scheduler.But it is showing error. My 0objective is the process become independent of user  Error connecting to PostgreSQL database(host='', port='', dbname='abc', user='', password='***'): 'fe_sendauth: no password supplied Thanks

Trying to free up some space on our existing FME Flow server and noticed that there is a folder on the root C: named “FME” that have various FME installations folders. In each of those folders, there is .cab and other installation (.msi, .exe, .log) files. The total file size of these folders is ~50GB on the server!I cannot find any documentation that states that is okay to remove these files.  Does anyone have any information about these?Thanks for any help!-Cameron

I am reading dynamic data and sometimes there is text fields that contain newline characters and I would like to replace them with just a space. How would I go about this?   

I want to loop through the list ‘attribute’ in a PythonCaller and change some values, but I get an error. Line 34 is the for-loop.   File "<string>", line 34, in inputPython Exception <TypeError>: 'NoneType' object is not iterable Can you see the error?  def input(self, feature: fmeobjects.FMEFeature): feat = feature.getAttribute("attribute{}.attribute") for obj in feat: if "fme_varchar" in obj.fme_data_type:  

Dear FME friends,Welcome to What's Up Wednesday. For reasons of space, this is an extract from the full version of this newsletter, which you can find here on LinkedIn. Streaming to a DatabaseThis week I saw a question about writing an incoming stream of data to a database: "I have a workspace that runs continually in streaming mode (receives from a connector). I want to write to a Spatialite DB while the workspace is still running. I've tried a FeatureWriter, but nothing is written out while the workspace is running. Is this normal behaviour for Workbench?" So there is a great article on the knowledge base about

Hi all,I see some strange behaviour when converting a simple 2D box from PostGIS to Geopackage in a dynamic mode (using schema). I have attached a simple workspace which demonstrates the strange behaviour. A simple box is created in 2D and writen to PostGIS as a postgis_polygon. I ckecked the table in the database and is has the correct definition for  the geometry (geometry(Polygon, 28992)). After the creation the table is read wit a FeatureReader of type PostGIS with the same connection parameters. It is set to read the schema and the features. The result is directly written to a geopackage with a FeatureWriter. Geometry is from schema definition. When i open the result in the Data Inspector i see the geometry type has become geopackage_multisurface where i would expect it to be of type geopackage_polygon. At the

Hey all,So I upgraded FME Desktop to 2024.1 (through ArcGIS Pro installation) and opened up an exisitng workspace I had created in a previous version. When it opens I get the message stating:Transformers are used that are not installed: 'CenterlineReplacer (version 6)'https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/centerlinereplacer.htmWhy is this happening? I have no option to upgrade the existing transformer and it disappears from my workbench and when I try to search to add another ‘CenterlineReplace’ transformer, it is missing from the list.I have ran a repair on the installation but it is still missing.

Hi,I have a annotation class in a file geodatabase. I want to convert it to a polyline or point in a file geodatabase. I could not fine any transformers in FME.  I really appreciate your assistance.

Hello Safers! Please, is there any way how to read file information about excel document?And if there are defined footer of pages, is there any change toread value of footer?Thank You so much!Lubo

I need to write an existing feature class to a new feature class (with some modifications) in an Esri SDE database and require that the attachments to be included and properly linked. When I write out to the new feature class, none of the attachments appear to be persisted in the __ATTACH table. What do I need to do so that the new feature class retains the attachments?

I have a workspace that I am using a JMSReceiver to receive JSON files from ActiveMQ. I am then using a JSONFlatterner to parse out the JSON fields. When I write the output to an email the attributes get sent to the email body as expected. But when I try writing the same output to a geodatabase feature class or a text file the attributes do not write. In the case of the text file the variables are identical to the variables for the email body - works for the email but not the text file. Am I missing a step that is causing the output not to be written to the text file or geodatabase?@Value(P_LINK_ANNTENUATION)@Value(P_LINK_ANTENNA_AZIMUTH)@Value(P_LINK_ANTENNA_HEIGHT)@Value(P_LINK_ANTENNA_TYPE)@Value(RTU)@Value(SCADA_DB_RTU_ID)

Hello everyone.I have a bug in a process that reads a NetCDF file and makes a Crop using a clipper transformer and then compare the result file with the original file using QGIS, compare point to point and some values ​​coincide but others, in the file result file do not coincide, it has a negative value and the difference between that value and the original file for the same point is a constant, for example in the result file the value is -0.588 and in the original file it is 0.436, the difference is 0.436- (-0.588) = 1,024.The clipper parameters are like thisIf someone has had this problem and can help meThanks in advance

Hi folks,I have multiple images I need to extract blob data for. When I input my individual feature types into the Raster Extractor (eg. 32 JPEGs, as shown in image below) the raster extractor seems to duplicate the first image for all of the feature types, so I end up with a blob of the first image for all of my individual feature types:This results in the first image duplicated, as a blob, for all 32 features - when I require a unique blob value for each input feature. The only workaround I’ve found is to have a raster extractor for each feature type, which is not suitable.Any help is greatly appreciated. Kind regards, Aaron

I have successfully POST Authenticate using postman. But have no luck using HTTPCaller? Any idea please? 

Hi I have a requirement to connect to the new Ordnance Survey (GB) WFS service in FME, their system responds with 100 records at one time, there doesn't appear to be an option in the reader to facilitate this paging implementation as in other products Any help to be able to access this API would be greatly appreciated

Hello, Im using FME form on macSilicon and ran into an error trying to run simple workspaces: /Library/FME/2024.1/fme is trying to execute itself. Aborting to avoid infinite loop. I managed to solve it temporarily by reinstalling the whole package, but after a while it started giving me the same error.Ive tried different workspaces from the tutorials with the same result, I imagine is something about the setup. Any suggestions can help, thanks!

I am using a python Caller to determine if a value is in a range of two other values which are read from a csv file.For Example:  Is SearchValue LMH_HNR_Z in the range of value PTOa and value PTOb? If yes, set the variable Fall = B3, if not set it to B3f.LMH_HNR_Z = 5, PTOa = 1, PTOb = 10 should return: Fall=3B, LMH_HNR_Z = 11, PTOa=1, PTOb=10 should return: Fall=3Bf  The Code in this picture is part of a bigger function where I discovered the problem but I narrowed the problematic part down to this. The row where the problem happens is this:if (min(PTOa, PTOb) <= LMH_HNR_Z <= max(PTOa, PTOb)):What happens is, that this request randomly returns false even if the search value LMH_HNR_Z is in the range of PTOa and PTOb. The output of some tested values and ranges is also visible in the lower part of this post. I can’t really see a pattern there, maybe one of you?Is som

I have a list of Attributees{}.name That contains attributes for each feature. the element count is variable.I am also using the ListElementExtractor and like how it works but i need from  15-258 attributes to put the list into.is there a way to get the list values out as attributes? or at the very least mmake the list populate (i.e. attr1, attr2, - attr258) in the destination attributes? I am reading the schema from a (blank) gdb with coded domains and WAY too many attributes to use AttributeManager. the purpose is to get the attributes with the correct domain and values so a different schema can be fed into this format and output as gdb with domains intact.

Hi,I have seen a few articles about updating metadata using the ArcSDE writers, which involve writing data and adding metadata simultaneously. However, what I want to do is just add new metadata while leaving the existing data unchanged (without accidentally overwriting it with nothing). I already have my metadata and types formatted as described in the articles I’ve read.xml formatted for esri importHowever, I am struggling to determine the exact settings needed for the writer. Since we don’t have a test system, I want to ensure I’m on the right track before proceeding. That said, I can create some test tables to trial the process. This is a related article which also update the data: 

Hi Everyone, I am working on a project for school and am reading in CAD data and outputting it as GIS data. However, the File Geodatabase writer is not outputting any features. I am setting it up how I’ve always done it in the past, but it is not creating the GDB where specified as the translation log says no features are being written. I have no clue on why this is happening nor how to fix it, so any help would be appreciated. Thank you in advance.

A while back I was informed that I needed to update the feature type name of a GPKG that I created with FME.Instead of generating the complete dataset again, I wanted to use a dynamic reader/writer to update just one of the feature type names, and leave the rest intact. However, upon doing so, I got the feedback from our 'data broker' that the GPKG no longer met the geometry requirement (should be single geometries).  When I investigated a bit further, it seems to me that a dynamic GPKG writer assumes multi geometry (in my case multi point), in case the writer is configured to use the Geometry 'From Schema Definition' (fme_point). Ok, I can get my head around that.However, when I then manually set the geometry in the dynamic writer to 'geopackage_point' or 'geopackage_multipoint', the geometry_type_name in the underlying SQLite DB (GPKG is based on this), returns 'GEOMETRY' (I think tied to 'geopackage_geometry&

For my process, I use pythonCaller and I have a JSON-type attribute. However, since the setAttribute function doesn’t recognize the JSON type, I have to use json.dumps() to convert the JSON into a string. I then connect a featureWriter to the output of pythonCaller to write the result in JSON format. However, I don’t understand why the featureWriter reformats the JSON on input. How can I have a correct json formatHere is an example of the file from featureWriter [ { "result_json" : "[{\"millesime\": [{\"2022\": {\"echelles\": {\"Y\": {\"max\": \"20.39\", \"min\": \"18.11\"}, \"X\": {\"max\": 461.0, \"min\": 0}}, \"resultats\": [{\"distance\": 0, \"pixel_value\": \"20.39\"}, {\"distance\": 425.0, \"pixel_value\": \"19.76\"}, {\"distance\": 265.0, \"pixel_value\": \"19.4\"}, {\"distance\": 461.0, \"pixel_value\": \"18.11\"}

We have merged Ascii grid and then classified the Raster using “RasterExpressionEvaluator” the Interpretation is set to UINT8  The color values have been assigned defining the interpretation of the palette as RGB24 using an AttributeCreator and then adding the color values to the RasterPaletteAdder.   

Hi all, I would like to use an existing FME reader to open a file with an unsupported extension. Is there a workaround to achieve this? Alternatively, how can I clone an existing reader and modify it to support the desired file extension? Thanks a lot! 🤓hp