Data

How to extract photo attachments from an fgdb esri file?

Hello, I have a table which needs to be written to PostGIS. One of my dataset columns contains a list of buffer distances for example 300, 200, 100m. It would be ideal to write this as an array to PostGIS for example {300, 200, 100}. If the table already exists with an array column in PostGIS, FME will update the array correctly. If the table doesn't exist I can't see how to set the column type as an array in FME. Is it possible? Thanks :)

I'm looking for a way to upload to an azure file storage with a new filename. I eventually want to expose an FME server app that will allow the user to upload any raster file, and then will upload that file to the Azure Storage and call a few REST APIs afterwards. I have a basic workbench working on my machine that can implement the workflow. The issue is, we can't have any spaces or periods in the filenames in the Azure storage, but I want to allow the user to upload rasters without changing the name. I have not found a way to be able to rename the file before or during the upload. I have experimented with using a Feature writer transformer with the File Copy writer to create a temporary file then using the temp file path in the Azure File Storage Connector but I'm struggling to even rename copies there. I realize I could probably do hacky stuff like use a systemcaller to rename the file, but if I need to do that I'm not sure what the advantage of using FME is, since I could implement

Is FME version 2021 able to work with ESRI Geodatabases in ArcGIS 9.0 and 9.3 formats?

Hi everyone, I'm currently looking to use the Ressource or Network Directory trigger on FME Server automation to trigger a workbench when new file are added to a file. The file type is DWG. With a DWG file, there is 3 other file that are attached to this file. How can I specify to the directory watcher to only look for new DWG file and not the attached file. Right now, my workspace is launch 4 time because of it. Thank you in advance, Ian

Hi, When we try to convert dgn file issued from teigha in FME software, we have troubles with OdDgCellHeader2d cell name. it seems to be an encoding trouble. Teigha used UTF8 encoding and FME try to read an ansi string. Note that there is no trouble with the string linkage of the cell. We have post on the teigha forum and aidan.wessel have answer. We join a dgn file with two ERPTRL Cell, one dropped with teigha library and the other with microstation. inside microstation, we have no trouble. FME is not able de read igds_cell_name for the one dropped by teigha library. thanks for your answer, best regards, G. COSTAMAGNA

Hello, When use Obj Reader,materials aren't appearing properly. .mtl does not refer to additional image resources. Attachment is my obj file. Thanks

Hello. When I loaded the ifc file, I noticed that the position of the text was wrong. The image below is the Inspector View when reading FKZ Haus data (*1) (*2). *1) https://www.ifcwiki.org/index.php?title=KIT_IFC_Examples *2) I specified "Industry Foundation Class STEP/ XML Files (IFC)" as the format. On the other hand, the image below shows the same data displayed with FKZViewer. (I hide everything except IfcAnnotation to make it easier to see) What is the reason for this misalignment? Also, are there any workarounds?

Hello I would like to truncate and write data to a feature layer on arcgis portal. I'm getting the following error and I don't know what's wrong with the workbench.

Hi, In my workspace I work with coordinates in different projections. I store them as numeric values. E.G. Geolat: 52.0324234. I want to write this to a PostgreSql database, which has the same type as is required for the value. Seems all good. But. When I start writing I get an error where it complaining about the input syntax is not of type 'numeric'. I see a query inside the log, Where it changes the value 5.2023617 from Longitude to " E'5.2023617' ". Which is a string. Which I dont require. Does anybody know where to look at or how to solve it?

Any thoughts on why this Transformer would work, and then just stop working with this error when trying to browse Sites in the transformer ? Nothing has changed on eh FME Side, and I do not think anything has changed on the SharePoint side

https://firebirdsql.org/

I'm trying to create a custom transformer 'FeatureCountLogger' which logs the number of features inputted into this transformer. The custom transformer contains a PythonCaller with the following code: import fmeobjects class FeatureProcessor(object): def __init__(self): self.featureList = [] def input(self,feature): self.featureList.append(feature) def close(self): logger = open(FME_MacroValues['Summarylog'], "a") message = FME_MacroValues['Message'] + str(len(self.featureList)) + '\\n' logger.write (message) logger.close() I want to use the logger multiple times, so I created a published parameter 'Message' in the custom transformer, so I can submit the text logged to each instance of the transformer. When I'm running this I get the following error: Python Exception <KeyError>: 'Message' It seems like the PythonCaller can't access the parameter defined in the custom transformer. It can access parameters in the Main (eg. 'Summarylog') Any idea what the problem is here?

Hello, I'm trying to create geometry from Sql Server geometry Blob to shapefile. I'm trying geometryextractor but it is not working. (I can not create geometry in Sql server; I can only read data). Thanks for help

FME 2021.2.3.0 (20220131 - Build 21812 - WIN64) I want to query an OGC API feature service by an attribute, to be precise, by a list of attributes. In my case, I‘m trying to query the cadastral parcel service of North Rhine-Westphalia by cadastral parcel numbers: https://ogc-api.nrw.de/lika OGC API - Features (WFS 3.0) Reader: Defining the parcel number as static parameter value works fine. Injecting the parcel number as published parameter works as well. But the 2 ways above are static. I have a list of cadastral parcel numbers to be processed. Normally the FeatureReader transformer is the method of choice to inject attributes into a reader. But this time, it fails! Obviously the FeatureReader doesn’t compose the query the right way and sends a bulk request to the service: https://ogc-api.nrw.de/lika/v1/collections/nutzung_flurstueck/items?f=json&offset=80 What’s going wrong? Best regards Oliver

I've read the documentation on how to connect to Google Maps with an origin and a destination parameter; https://developers.google.com/maps/documentation/urls/get-started Now, let's assume that I have an Excel sheet with columns for origins and destinations, for maybe 100 posts. Is it possible to use FME to send these to Google Maps and then get each of the calculated travel times back, to create a "travel time" column for the excel sheet?

With the DGNStyler you can set a fill color, but is has to be a value. In Microstation there is an option to set 'No Fill' (see screenshot below). Is it possbile to set a no fill directly in FME (with the DGNStyler or otherwise)? I tried a few things with 'igds_fill_color' and 'fme_fill_color'; however so far no success.

I have parcel boundaries, And i need to create outer boundary for parcels using some attribute name. In my group there are 4 types of attributes will come (attribute value a,b,c, and d) so i need to create 4 outer boundaries.NO OVERLAPS on outer boundaries. and are gaps between parcels and sometimes parcels are far from each other. Pls anyone can help me? i tried hull , but hull overlaps some cases.

Aside from 2 sparse mentions in FME docs and a video discussing how to use the JSON Reader to parse a STAC that might be hosted out on the net somewhere I don't see anyone talking about FME and STAC - Spatial Temporal Asset Catalogs. Is anyone been working on tools, in or out of FME, that build said catalogs? We've got ~20 years of imagery stashed here and there on our servers. It would be good to get them indexed in a STAC to increase discoverability within our org. (And for those which are not contemplating building Stacs, what are you doing instead?)

Hello, I would like to transform LAS files to LTF files using FME. I read that LTF format isnt supported in FME unless i install Leica Geosystems TPS Reader extension. Can someone tell me how to do that? thanks

If I use a PostGIS Reader, to inspector, on a table, it shows the geometry. If I use a SQLCreator using POSTGIS format, doing a select * from same table, it shows fme no geom, is that normal for a SQL to not show the geometry ?

I try to use the new CSW Reader. At the moment i only get the summary version of the metadata. I´m looking for a way to set the get-Parameters, so i can specify: &resultType=results&outputFormat=application/xml&outputSchema=http://www.isotc211.org/2005/gmd &typeNames=csw:Record Maybe some of you has an idea. best regards andylicht

Is there a way to convert an fgdb point file with attachments to sqlserver? Should the photo attachments be stored outside of sqlserver in a separate file? I can convert the point file but how to handle the associated attachments is the problem. thanks

Hi, I run a workspace in FME Workbench 2021 that outputs text files to D drive of the Computer. How do a enable FME to output text files to a server (file director) location?

Hi everyone, I am stuck with the FeatureReader and I manage to read a table out of the database when I keep the WHERE clause empty, however when I fill in the WHERE clause based on the user choice of a choice list saved in a parameter "NAAM_BUURT" and I want to match it with the column also called "NAAMBUURT" I don't get an output. I just get schema data, while I also indicate that I want data features. Does anyone might know what I might be doing wrong? By th way I am using FME Desktop 2022.2.1.