FME Form

Hello,I have a georeferenced dwg file with lines, polygons and text that I'd like to convert to kml for view in Google Earth complete with the AutoCAD layers. I have been successful with creating a KML file that opens in Google Earth but still some problems. when viewing in FME Inspector everything except the text shows and the layers are missing. When I open the file in Google Earth only the points show and on the Places bar each object is shown on a long list, I want to see the layers like in Autocad and do not want to see the individual objetcsLooks very promising otherwise.Thanks

Hi,I'm using the TopologyBuilder to create relationships between water mains (the edges) and the valve furniture (the nodes). Our corporate GIS (Gwater, Oracle based) has an start and end node for each feature to show connectivity, but ARCGIS does not . These values do not exist and I have to create them to align the two GIS systems.So far the results have been good, as the corporate GIS feature can only connect to two other features. This doesn't happen in ArcGIS for one particular type of feature called a cross valve, which connects 4 mains pipes.I can find the 4 pipes a cross connects to, but not the direction in which they connect to create the east-west and south-north connectivity. There's nothing in the topologybuilder output which suggests this relationship:  I was wondering if I can use the spatial location of the pipes that the cross connects to to determine which one is easterly of the cross, westerly and so on:Any idea how this might be achieved? I can then use

I have set up a http caller with query string parameters. It would appear that the server throws a 500 error when its finished returning the records. Does not appear to affect results but would like to get rid of error.

I can not access views in my oracle DB neither with the oracle non-spatial reader nor with a SQLExecutor.Is there a workaround?The FME Help also talks uniquely about tables, never views.Oracle Non-Spatial Reader Parameters (safe.com)

Hello Sir / Madam,​I have many files (more than a hundred of files in .json format - text). I would like to extract certain text from each of the .json files and put all the text in a single text / csv file for further study.​I am just wondering if it is possible to do it on FME? Or what transformer I would use?​Here is what I really want to get for my report.​File name; errors number (spacing for "no error"; it could even better if I can output "no error" instead of spacing)​Output sample as follow:banana_report.json;102;203;204;303;305;306;307;a_report.json; ;​My .json file sample is uploaded for your reference. Basically, the information that I need is at the "all_errors: []"​Hope somebody would give me a hand on this issue. I am really appreciate that.​Thank you very much!​Zach

I have been trying to change a file extension from .bil into .flt based off this link https://community.safe.com/s/question/0D54Q000080hEslSAE/how-to-change-filename-extension-via-fmeBut I cant get the FeatureMerged to merge what am doing wrong?There will be other files and different file types in the same Folder so not sure yet, if this process/workflow will change the other files as this would not be desired.But for now I'm just trying to get the FeatureMerger to work.

Due to a number of custom coordinate systems used by the organization - I have to use ESRI Reprojector to set the CRS of some incoming data. So CoordinateSystemSetter is out of the question unfortunately. I used a PythonCaller and Arcpy to generate the string required, based on this help doc - in the format of ESRIWKT|<name>|<esriwkt> where <name> is the coordinate system name, and <esriwkt> is the WKT (Well-Known Text). sr = arcpy.SpatialReference(int(FME_MacroValues['EPSG']))str = 'ESRIWKT|{}|{}'.format(sr.name, sr.exportToString())feature.setAttribute('coordsys', str)But I'm getting this warning, (and the crs applied is not correct). the EPSG code I tested with was 5383.Datum definition SIRGAS-ROU98 does not exist.Ellipsoid definition wkt_auto_1 does not exist.Esri Reprojector: Specified geotransformation `' (forward) may be inappropriate for reprojection from `_FME_0' (GCS: `GCS_SIRGAS-ROU98') to `_FME_0' (GCS: `GCS_SIRGAS-ROU98') using the ESRI reprojection

80192022-6-6 16:37:01 | Unable to flush the cursor for the feature class 'BCNCAR' because the spatial index is too small. Increase the spatial index on 'BCNCAR' and retry80202022-6-6 16:37:01 | GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details Weekly we download all .000 Electronic Charts, run them through a workbench which writes to Oracle. The workbench runs but throws this errors, so were not getting as many records as we should. Attached is the workbench.  FME Server 2021.2.5Build 21816 - win64Oracle 19CArcmap 10.8.1 with 64 geoprocessing extension

Hello FME'ers,A slightly late What's Up Wednesday because of the webinar I was in yesterday. But it's still packed full of fun and useful content... FME Community WebinarOur FME Community webinar was yesterday. If you're interested, you can find the recording on our website or on YouTube. We also have a blog about it too.  We showed how to use FME to crowdsource data for an ArcGIS Online map (even if it did get a bit slow at times), and we played a City Guesser game that was pretty cool. Dale and I managed to describe and demonstrate the FeatureTypeFilter transformer (picked at random by a marble race) and the FME Scavenger Hunt was launched. Oh, and everyone got a free lunch on us. And afterwards... well, these are the bits that got cut out of the official recording! Enjoy. FME Scavenger HuntThe FME scavenger hunt is up and running.   So far we have 37 players, making up 9 teams, including our first company team, "Team Abley" from New Zealand. There are currently 5 missions to complet

Im a very beginner with FME. I've a polygon (gpkg) file, which has several attr. columns. 3 of these column contents should be under one column. I prob. need to create new column where to put contents of these 3 separate columns, right? How? Thanks!

I'm attempting to transform the input Rain Gauge data set to the desired output as shown in the above inserted image but I'm at a loss on how to proceed? The important factors are:The time period is defined by the user, in this example 01/01/2022 - 10/01/2022 and the output table needs to include all days in that range.The input Rain Gauge data only contains data for when it rained so not all dates are included.I need to some how produce a column per Rain Gauge reference, then look up the associated rain fall value for each of the days and populate the new table structure.The number of rain gauges can vary. I have completed the process of creating a list of all dates for the requested time period. I can't begin to fathom how to manipulate the data as shown and explained above.If completing this in Excel I would have created a pivot to produce the table below:  Any help will be gratefully received! Thank you.

Note: only change exact word not combination words .it posible change exact multiple words in StringReplacer and StringPaireReplacerrock=Star  nove=9     RAW sourceNormalized nove9correctnovember9mberincorrectrockStarcorrectrockstarStarstarincorrect

In my attribute table, I have a field named "City" and in this field we have differents cities except a city which is in 2 or 3 fields. But the transformer "Duplicate filter" doesn't display this information and displays cities which are uniques. So I think it doesn't work. What is the problem?  Thanks for helping

Hi everybody, I have a seemingly trivial problem that I can't solve: I would like the name of a file inside the zipfile produced by FME Server data download service to be the same as the one produced by FME Desktop (maybe statically defined or by some parameters/attribute values) instead of a random meaningless name. Any advice? Thanks

So far I can only see a writer for Presagis .flt (OPENFLIGHT), I'm assuming this in nothing like the ESRI binary format

I am having problem writing attributes with swedish characters (åäö) to a mssql table.The characters get replaced by other strange characters instead. I am using FME Desktop 2022.0.0.2 build 22343.The database is set up with collation Finnish_Swedish_CI_AS as it should be.Other programs such as QGis is writing åäö to the table correctly.Is there some kind of setting that I need to do in FME or is this a bug?

Hi I am reading Smallworld data which has internal and external objects. When reading external objects we don't have any problem and all are read properly. In case of internal objects, the geometry is not extracted by FME by reader.  Is there any way we can read smallworld internal objects in FME without Spatial Biz? Thanks Siva Bulusu

Working on a little data quality initiative and would like to use Geospatial PDF writer. So I'm reading some SQL spatial data, then filtering, grabbing a centroid, building a bounding box, using that for the 'Map Extents' parameter in the Geospatial PDF writer after adding some labels. With fanout, I can write a bunch of PDF files that show my feature/label pair.  Is there not a way to append all these pages to the same PDF instead? The section "Adobe Geospatial PDF Multi-Page Support" sure sounds like this should work but I can't figure out how. 😉  Only way I can see is use FeatureWriter and followup with a Python Caller to do this part.Any suggestions appreciated. 

Dear Community,  I have a number of points in one dataset and I would like to draw lines so that I connect each point with all other points (many to may). How do I do this in FME?  Regards, Mats

Recently updated to 2022 and can no longer see a table through a portal connection.I can still see the other three feature classes but not the table. Is this a bug in the new version of SDE or did something change?

*** Will be cross-posting here and on ESRI community/geonet.***  I have an FME process that uses the SPROC's for versioned editing with the .evw views inside an FME SQL Executor...-- Change to the FME version EXEC sde.set_current_version 'myFMEversion';EXEC sde.edit_version 'myFMEversion', 1; -- DO MY THING HEREEXEC sde.edit_version 'myFMEversion', 2;  This has been working great in one database and running in FME Server under a service account. Now, when I try and use it in another database, after creating a 'Public' version called 'myFMEversion', I can run it in FME Desktop successfully where I'm Admin on that DB. But when I run it in server which uses the service account, it fails with this error:360 | Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `-- Change to the FME version 361 | EXEC dbo.set_current_version 'myFMEversion''. Provider error `(-2147217900) Version myFMEversion not found.' 362 | A fatal error has occurred. C

Hi,I have tried several parameters with the "Landsat-8 on AWS" reader, but every time, it returns nothing. I have included on screenshot of the reader. Would you have any idea why it doesn't work? Thanks!

From FME desktop it is possible to write the correct datatime (TIMESTAMP(6) to TIMESTAMP(6)) )when I switch the rows timestamp fme_datetime, timestamptz(width) fme_datetime in file:  "C:\\Program Files\\FMEServer\\Server\\fme\\metafile\\oracleAttrCommon.fmi".From FME server TIMESTAMP(6) becomes TIMESTAMP(6) WITH TIME ZONE...Is there a file on FME server what overrules this modification in the fmi file?

Hi all,I want to read out an Rest API. I examined the contents of the api using Swagger. I first have to authorize myself to use the api. After that I have to login on the API. With Swagger this works all well. How can I do this in Workbench? I started with a creator. Connected to that I use a HTTPCaller to authorize myself. That's working well. Than I use a HTTPCaller again to read out some data with the credentials of the login window. Than I get an error of accessing the url.  What is the best way to work with this kind of "double" authentications?

want to ask about my research, which is about converting IFC data to CityGML and CityJSON formats for 3D Cadastre. I'm having problem converting citygml model to cityjson using fme . The citygml model I got from converting the ifc model on the fzk viewer. The ifc elements I convert to citygml are ifc space . But when I convert it to a cityjson model, the space (room) element doesn't appear in the ninja cityjson viewer (https://ninja.cityjson.org/#). Can you explain why this can happen? does cityjson not support space elements represented in lod4solid model?