Data

Hi there,Can you please help me with this? Every time when a new report came in, I’d have to manually open the “FreatureReader” dialogbox and hit “Ok” (to close) so that the new attributes that are added in new report at the new folder location are emerged. Otherwise, it would just read previous attributes from the new report (in below case, up to the end of June, not the July columns). I’m just trying read an MS Access file that is stored dynamically in different folder each month.   

After upgrading FME Server from 2022 to 2023.1 my existing workspaces have started failing due to the following error:Python Exception <TypeError>: init() takes at most 2 arguments (4 given)ARCGISPORTALFEATURES writer: An error has occurred. Check the logfile above for detailsThe same workspace runs correctly locally on FME Desktop (both 2022 and 2023) and I have tested reuploading the WS from FME Desktop 2023 to the Server but without success.I tried creating an entirely new workspace in FME 2023 that should just write a single object using the Portal Feature Service Writer. It failed with the same error on both Desktop and Server when writing to a referenced feature service but was successful with a hosted feature service.In summary:Original workspace (writing to referenced feature service with Portal writer)  FME 2022 FME 2023 Desktop Yes Yes Server Yes No  New workspace in FME 2023 with Portal writer  Referenced feature service Hosted feature service Deskt

Hi I am new to FME and here as well…I am trying to use a PDF that has an image and I want it to use FME ( not sure which one) to export it to TIFF the same as you see in PDF ? Is that possible for me to do that ?

FME kullanarak cad dosyalarını gis dosyalarına nasıl dönüştürebilirim?

Hi,I am trying to extract the four corner coordinates of a tif file using the RasterPropertyExtractor.What I need are the coordinates of the data extent of the image without Nodata, what I get are the coordinates of the full extent of the image. I guess somehow I have to make the existing Nodata “0” to “real NoData”. Any help is appreciated.Thanks 

Hi,I currently work with the Cesium 3DTiles writer and stumpled upon some requests asking for support for the DRACO compression.I tried to do apply the compression afterwards using ‘3d-tiles-tools’ with no luck. So I took a deeper look on the b3dm Files using ‘3d-tiles-tools analyze’ and it looks to me like it’s already DRACO compressed. ‘3d-tiles-tools analyze’ gives me:{ "asset": { "generator": "FME 2022.2.5.0", "version": "2.0" }, [...]"meshes": [ { "primitives": [ { "attributes": { "_BATCHID": 4, "NORMAL": 2, "POSITION": 1, "COLOR_0": 3 }, "indices": 0, "material": 0, "mode": 4, "extensions": { "KHR_draco_mesh_compression": { "bufferView": 0, "attributes": { "_BATCHID": 3, "POSITION": 0, "NORMAL": 1, "COLOR_0": 2 } } } } ]

I have three lines coming from CAD, I have read them and I would like to use “Create Routes”, instead I have used the measure generator. However, the measurements are wrong, and I suppose because on the way the vertices of the line were drawn (in an illogical order).By using “Create Routes” I could select the coordinate priority (lower left, lower right, upper left, upper right) to tell it to start counting from that point onwards (because the coordinate priority will be different per line). Is there a way that the same can be done in FME? Thanks!

Hello All,I am using FME Workbench 2022.2 and ESRI UN branch version.  There is an existing branch version that has all the edits to various tables and layers that I want to copy to a new branch version. I have tried to use ChangeDetector but this how cannot detect spatial geometry changes.  Is there a way to copy attributes and geometry changes and as well as other UN related table changes from an existing branch version to another version using FME? ThanksAnthea

Hi,I have a process that begins by going through the AttributeCreator2 transformer, but after some transformers, there is a validation. If the result is true, the features will arrive at the DateTimeConverter as shown in the image below...  I would like the process to restart at the SentinelDownloader transformer after the DateTimeConverter returns, and to consider the features with the AttributeCreator transformer only at the start of the entire process. I guess the process should work like a loop.Thanks

Hi, I would like to create the option to pass a value by attribute. How can I create it in a custom transformer like in the image below?   Thanks  

I'm trying to convert an IFC file to Esri Geodatabase format. Is it possible to convert the properties from IFC group ? If so, how could I do that. The properties set is not visible in the traits or the elements object underneath the group layer. I am not sure if that is possible. But the result is visible from the FSKviewer.  Please offer me help!

I am using a Python Caller to create new features based on counts from a REST Endpoint.  I want to verify the output in Data Inspector, everything acts normally until I click on the record in the table (there is not geometry)When I click on the record, the Data Inspector immediately hangs then crashes and closes.I am using FME(R) 2023.1.0.0 (20230825 - Build 23619 - WIN64)

GML2IFC translation/conversion warnings I created a very simple model where I added a GML reader and I want to transform it to IFC.When I run it, numbers appeared on the connectors. These numbers match with the number of features per feature type. I would assume that the transformation was made, although a couple of warnings appeared during the run of the model (see second image) Nevertheless, when I look for the transformed files, there is nothing on the folder. When I try to inspect the resulting data using the eye, a windows pops up asking for information that was set when i first set the "writers/translator" (see third image) and when I look for the data, nothing was done. I checked about these “warnings” among the FME community, and between not-updated information and broken links, there was nothing there that could help me to find out the reason or meaning or ground for this issue.I have also checked in https://support.safe.com/hc/en-us/articles/25407793929229-GML-Writing  and he

I have an .fmw that reads a series of SQL Server views then writes the returned values to a templated Excel spreadsheet and it worked while using our DEV SQL server (A). When I replace the existing database connection to verify it works on our Production SQL Server(B) the value in one cell is missing in the Excel spreadsheet. I get 0 errors, 0 warnings using (A) or (B) connection. All the remaining view results are there and correct. Verified that the SQL VIEWS exist on both servers and refreshed both just in case-same results. I can select the views via SSMS and get the correct data on (A) and (B). I tried deleting the one failed writer and re-adding it: same results.I tried deleting the reader supplying the view information and re-adding it: same results.Thoughts? Using FME Form Desktop Version 2023.1

Hi, I have a process that im unable to get working and wold like advice on the processesI have a dataset containing a number of records, each with a user and their email address. There are multiple records for each user,The requirement is to identify each unique user in the data and send them an email detailing all the records relating to them. The users could change each time the process is run so i havent set any filters with their names.My thoughts were to create a loop to go through a list of users, filtering their records out and sending the email before moving onto the next name on the list.This would keep going round until there are no names left in the list.I have used the statistic calculator to identify the users and have used the HTML report generator and emailer for the the end of the process but would like some help explaining how the loop should be set up (if this is the best way to do it) and how i can move to the next person in the list each time. Thanks

I have and CSV address data file. There are address number ranges that I could expand it with the help of bruttino. Using Cloner and attribute manager transformers.I need to do another clone and need your assistance.I also have 2 fileds: “Street Address Number Suffix From Code” and “Street Address Number Suffix To Code”. For example, from A to D  I need to copy based on the number of suffix between From and To, then replace the current suffix. like A, B, C, and D for this example. I also have 2 fields: “Suite from Number” and “Suite To Number”, which are combination of number and letter. For example from 2A to 2D.I need to get a result like 2A, 2B, 2C, and 2D.Do you have any idea how to handle these fields?  I really appreciate your assistance.

The preview highlights the letters Op but the Regex only replaces the quotes (as expected): Result:‘Op. test ’ will become _Op. test _

Hi  I have a shapefile representing image footprints with as attribute the image name.I have a shapefile containing multiple polygons with an attribute ‘name’ representing buffered lines. I have a workbench that selects all the image footprints per line and copies the images to a folder, fanned out with the line name. It does that perfectly, but some images exist in multiple lines and my wb only copies the image to the first line and doesn’t copy it to the other lines. How can I solve that?          

Hello,I installed FME 2022.1.1 on my laptop and installed the Oracle client (11_2) but even after several reboots I cannot select any Oracle Database as reader. They are all greyed out. When I open a workbench that contains Oracle it says something about missing dependencies: ‘Oracle Non-Spatial’,Oracle Spatial Object’. When I want to run it, it fails and gives the error: ORACLE Home is not set.  Does anyone has a hint how to fix that?

I need help performing bulk feature service updates using FME.I would like to do what this blog post is doing, under the section "Updating AND Deleting Database Records with FME" but I can't recreate the steps with a feature service in Portal since there is no Row Selection option in these writers. The blog has steps to write to another geodatabase.Essentially, I need to update floorplans data by deleting the old version of the floor plan in the feature service and replacing it with the new floorplan data.The updated floorplans data exist in a geodatabase and it is used to update a feature service in Portal via ArcGIS Pro.Right now, I manually select all the floors that match the LevelID (unique ID we use for each floor in a building) in the update layers.Then, I delete all the features that match and insert the new features into the feature service, using the field mapper to populate necessary attributes.Any advice or help is appreciated. Thanks.

Using FME Form 2024.0 and DGN v8Hello All,I have a DGN file with an OLE Embedded Excel Object. I am able to locate the element that represents the OLE object and can return all the typical IGDS information about the element itself, size, layer, model its in etc. What I would really like to do is investigate tabs, rows and columns content within that embedded Excel. Does anyone know if there is a way for FME to read an embedded Excel object from a DGN  file? 

HiI would like to add a raster to a DWG and have the path to this external reference set as a proper relative path.When you write a raster to a DWG file, the AutoCAD writer automatically writes a PNG in the folder of your output DWG.If you keep this PNG file next to your DWG, it will always open. However, if you insert this drawing in a new drawing, the link to the image breaks.This is caused by the path of the external reference (raster) that is not properly set a relative path.If we look at the created path from FME in Autocad, we see this:If you change the path type to relative in autocadThen the saved path changes to: I have tried to copy this in FME, but no effect:​​​​Any ideas?Jasper

I have created over 200plus parameter fields and the alignment is off but can’t edit them. Not sure how to do this. I’m new to FME Workbenches and can’t see a way to update this. I’m using the CAT so that these fields can be ran into ArcGIS Pro. I have a huge workbench and not sure what to do next. I would love any help.

Hi,How can I calculate NDVIRe, using RasterExpressionEvaluator? NDVIRe=Band 8 (NIR)+Band 5 (Red Edge 1) / Band 8 (NIR)−Band 5 (Red Edge 1)​I don´t know to configure the transformer properly… Thank´s 

Hi!Is it possible to backup a PostgreSQL database (or a specific table) using FME?