Data

When setting the connections to Azure Database in FME Desktop, it does not have an option to use Active Directory Integrated authentication. It has only Windows and SQL Server Authentication. Is there possible to connect Azure Database by using Active Directory Integrate? Any help is very much appreciated.

I am reading a large xml dataset - about 80GB .gz file - and send each feature in a PythonCaller that simply dispatch the content in different .gz files according to the feature type (since multi-writer will keep all the content in memory/temporary files). Seems to work since I can see the size of the different files increasing.  however, Since it is being running for 8 days now (yes, 8 days), I wonder if I could eventually improve the speed of the workbench - parallel reading, processing, ... whatever could help!  Daniel

Hello all, very new user here. New to FME, point clouds, LiDAR, and all related.  I'm having an issue where a LiDAR scan I'm attempting to visualize is only displaying correctly when I select 2D in the FME Data Inspector. So when I load the file in to FME, the following is displayed (I've panned and zoomed to make it more obvious what is going on):There is nothing but a long thin line even though the inspector recognizes I have loaded > 8 million points. However, when I switch to 2D (the button on the toolbar at the top), the following displays:This is in line with what I was expecting, a road with corners and holes in the road where the scanning vehicle passed cars. But again, it only displays like this in 2D.I understand this is likely a scan format issue. This scan is stored in a polar format based on WGS84, so I attempted to convert it to an XYZ format with a python algorithm a friend suggested to me. At first I thought it had worked, but that one was distorted also.

I am highlighting the sql logic i would use in database environment that i am looking to replicate here. It does not accept that logic.

HelloI took CityGML LOD2 RoofSurfaces (~1700) and textured them with an Orthofoto. If I write this to a 3D PDF or glTF it takes 1min and produces output of 50Mb in PDF and 15Mb in glTFIf I write the same data to an ESRI File GeoDB it takes 5h+ and produces a File GeoDB with ~6Gb size .What is going on here ? Do I need to specially treat the surfaces before writing them to the File GeoDB ?

I am working on an AutoCAD to AutoCAD conversion where I am changing the text of text and Mtext objects and writing out the changes. The AutoCAD writer uses the input file as a template as the only parts I want to change are the text elements (whether text/mtext/attributes in a block). I am having a problem where Text entities (autocad_entity = autocad_text) are being written as MText entities in the output which is effecting the positioning of the text. This is happening for all text entities (autocad_text), where I have and haven't made changes Is there any reason why text entities would be written as Mtext, when they are clearly defined as text entities in FME? I have posted some images of before and after below for reference:Text Settings in FME just before writingAutoCAD file read into FMEAutoCAD file written from FME

Hi everyone, I have encountered the following issue: when writing to a Spatialite database a polygon with more than one hole, only one hole is created and the others get lost (see attached workspace). By the way, everything goes fine if I write, for example, to shape or geopackage. I'm using FME 2022.2.5.0 (20230329 - Build 22795 - WIN64). Could it be a bug? Thanks

buffer transformer

Has anyone figured out how to read Overture maps data using FME yet? Looks like it should accept a spatial query but maybe it requires a custom reader. I tried using the AmazonAthena connector but didn't get anywhere... Overture documentation can be found here:https://github.com/OvertureMaps/data/blob/main/README.md#how-to-access-overture-maps-data Thanks in advance!Nic

Hi,hopefully someone had the same problem before and could help me.I'm trying to export annotations and features from ArcGIS sde connection to Microstation dgn. However, the justification of the text are slightly shifted to the right, compared to the original text (see picture below). I've tried many things with DGNStyler and also the attribute igds_justification. None of these helped. It seemed like the calculated origin point is always slightly right. Last but not least, I also extracted x and y of the extent of original annotations and set that to the exported features. But it seemed FME still calculated an insertion point (see https://community.safe.com/s/article/text-justification) when exporting to DGN, so that there is a shift.After that, I thought of calculating the centroid of the original bounding box and set that as igds_insertion_x and igds_insertion_y, but that didn't changed anything.Does someone know how to deactivitate the automated calculation of origin poi

Hi,  I am wondering how it is possible to write generics attribute in CityGML?  Any help appreciated :)  Regards,  Asher

in in FME Json Reader following,{"yourDateOfBirth":"15/08/1987"}become column yourDateOfBirth with a value of 15/08/1987, I need to convert to value 08/15/1987? Thanks

Hi, I am trying to rename feature classes in the gdb. I have found couple posts about this but I got FAILED when I implementing suggested soutions. What am I doing wrong? 

HiI've got ACAD file and need to migrate objects placed by operator on autocad paper space. FME can read paper spaces (parameter 'Read Paper Space') but objects have got coordinates related to paper spaces. Is there something to get georelation for paper space and map data?

Hi, In the FME basic training I am trying to create a PostGIS connection for Exercise 4 'FME Hackathon' (page 430).The Hackathon PostGIS Database should be located at postgis.train.safe.com, but I cannot get a connect with it using the given parameters (below). I followed the steps Tools -> Database Connections -> Add Database Connection.Host: postgis.train.safe.com Port: 5432 Database: fmedata Username: fmedataIn the log window the following error appears:Error connecting to PostgreSQL database(host='postgis.train.safe.com', port='5432', dbname='fmedata', user='fmedata', password='***'): 'server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.'Isn't the server online or am I doing something wrong?My version is: FME Workbench 2017.1Thanks,Koen

I'm have the following error:An error occurred while attempting to open an insert cursor on the table 'SurveyedGeneralLawn'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [GisGeoDbMaint.ASSET.SurveyedGeneralLawn]}It seems to be with a relationship class with attachment TABLE. When i remove the relationship it work fine. I only want to insert records into the feature class and the attachment table. I using an Arcpy truncate function as a startup script.I've looked at previous post regarding this matter, but it don't seem to work for me.Using FME 2014 - SP4Rudy

Hi  I am setting up a job to update data in AGOL using FME Desktop 2020.2.3 I am aiming to have a single job which I will publish to our FME Server to refresh the data on schedule.  I have multiple Feature Services to update and am hoping to use a single Feature Writer to update them.  In my workspace I generate the Service ID and am passing through to the Feature Writer Feature Service constraint parameter. This works successfully when the Feature Writer only updates a single Feature Service however when I try multiple it cannot find the Feature Service, it seems to still connect to the first. The log shows that it maintains a connection to the first Feature Service and does not switch to the second. Are there any issues with this methodology? Suggestions for alternatives? Thanks

Hi,I would like to be able to read the name of the layers from AGOL that are shared with the same group. ArcGISOnlineConnector reads only the genaral name.

What does error message"expression: prevrealnode_->arcinfo_ != nullptr" means?

Which FME version is compatible with SQL Server 2022

Hello!I have a newly installed PostgreSQL database with a PostGIS extension enabled. Because of licencing consideration we want to migrate our oracle database to this database. We are using database side bussiness logic in our views, so i want to write directly to the views without success.We have Postgresql 12 AND postgresql 16 for compatibility testingEvery version of FME from 2018-2023 (mainly using 2018 because we have too many scripts to migrate all) I have tried most of the version combination with the same error every time. This is what im trying:Created the table definition with FMEBased on the created definition created a simple view but the workbench keep dropping this error: Invalid PostGIS metadata detected for table 'public.generated_np_node_view'. Attempting to correct and continuePOSTGIS Writer: Table 'public.generated_np_node_view' does not exist. The inserting with pgadmin or geoserver works fine, the inserting to directly to the table works fine but t

We have an authenticated WFS from Drone Deploy that has an API key. ArcGIS Online and ArcGIS Pro both have the ability to include the api_key in the request. Is it possible to include the custom request in the WFS Reader?  

I've seen lots of people over the community asking how to read AGOL attachments, but I'm curious to find out what FME users are doing with them once they've been read using FME.

If you execute the attached workspace... You get fme_text features with empty fme_text_string (but TextString has a value). Any suggestions? 

Hi everyone. I've a folder with JPEG. I have a XLSX file with the name of the JPEG name and the new name that i need. It's possible to remane the JPEG in Batch ? Thank for help.