Data

I have a workflow that needs to bring data from an ESRI geodatabase, do some standard transforms, run a complex Excel model, and summarise in a final Excel output. Clearly FME will write to the model input sheet. But can I get FME to run the model as if it was a transformer, then pull the results out to the final summary? Thank you.

About possibility in FME Workbench to write in Microstation DGN XFM format, linear elements (polylines) with attributes for a dataset that have lines with elements but other format not supported by Microstation. I need to be able to see in Microstation Bentley Map the polylines and their attributes. Currently, I have the lines and their attributes in MS access format for Geomedia and ESRI and would be great to be able to export them in DGN with XFM attributes. DO you have any advise on that? Thank you! Lavinia

There is a Reader from DGN8XFM files, dgn with attributes linked to elements, but no writer to be able to obtain a DGN file with attributes to graphical elements? How to create a FME schema that writes DGN file with XFM attributes?

In the next few months we will be migrating from an FME Cloud instance (2018.1) on Linux to Windows Server 2016 and I haven't been able to locate any information on the proper way to migrate this. Trying to get a game plan together before we attempt this. We will still have the FME Cloud instance running while we perform the migration. Will the FME Cloud backups work with the FME Server on the Windows server platform?  If anybody could point me in the right direction, or have any useful links, that would be much appreciated. All I can find is migrating from FME Server to FME Cloud information, so I wasn't sure what hurdles might be in the way in doing this the other way with different OS's.

I would like some features in PostGis database, there is one field called 'dt_desc' with the value (2018-09-04 19:00:20).But the WARN messege showed in my log: 'dt_desc' cannot be convert to timestamp, and none features is recorded.I tried change the format in FME writer to timestamp, varchar, date...but the problem continue againIn my PostGis database the format for this field is timestamp.Somebody can help me?Thank´s

How is the  status to read/write gbxml format in FME?

Hello Everyone,I have 17,000 TIFF files(~3Mb each) that I need to merge to make just one file. While I create the workbench and read the data as Single Merged Feature Type, it takes a lot of time to read the data (feature types to read) and once I run the wb, it ends up crashing or the output(zipped) is not merged. Any solution for this?

HiI have to migrate a bunch of FME scripts from PostgreSQL/PostGIS to MS SQL Server for every Reader and Writer. The straightforward way would be to just replace any Reader and Writer with its MS SQL Server version, and to modify any SQLCreators and SQLExecutors. Many days of work... Is there a more efficient way to handle this?Regards, Tobias

HiI am trying to read a JSON file:{  "meta" : {    "Version" : "1.0",    "Create time" : "2018-08-30 18:40:02 UTC"  },  "units" : [ {    "dn" : "ou=test,ou=Org,o=xyz",    "attributes" : {      "countryName" : "SE",      "createTimestamp" : "20180504113600Z",      "creatorsName" : "cn=improxy,ou=System,o=test",      "hsaCountyCode" : "14",      "hsaIdentity" : [ "test" ],      "hsaMunicipalityCode" : [ "1480" ],      "modifiersName" : "cn=admin,ou=System,o=test",      "modifyTimestamp" : "20180829082917Z",      "ou" : [ "xyz" ],      "vgrAo3kod" : [ "501" ],      "vgrModifyTimestamp" : "20180618080954Z",      "vgrModifyersName" : "cn=user,ou=Personal,o=test"    }  }, {    "dn" : "ou=clients,ou=Org,o=test",    "attributes" : {      "createTimestamp" : "20180503113416Z",      "creatorsName" : "cn=improxy,ou=System,o=test",      "hsaIdentity" : [ "test" ],      "modifiersName" : "cn=user,ou=System,o=test",      "modifyTimestamp" : "20180504030003Z",      "ou" : [ "clients" ]    }  }, {It g

HiThere is this really cool writer called Generic (Any Format). I tried to use this writer to keep my scripts independently from the DBMS I'm writing into. This would enable me to switch DBMS very fast, and just to have one lean script to work with PostgreSQL, MS SQL Server, Oracle, or Teradata.Thing is that I make use of the parameter fme_db_operation in almost all my scripts. Some features lead to an INSERT, some trigger an UPDATE, other a DELETE.I couldn't make the Generic ( Any Format) writer to accept fme_db_operation. It always leads to an INSERT operation.How do I use the Generic ( Any Format) writer with the parameter fme_db_operation?

Hi,I am new to FME. I have asset inspection data in an Excel file and I need to produce a summary report from it. Each row in the table has a unique ID representing an asset. The questions relating to the asset are answered yes & no and a comment is entered when the ansewer is no.I need to produce a summary report for each ID whereby any Question that has a No value will be an over all fail and I would like the Comment to be in the report also. ID Question A1 Comment A1 Question A2 Comment A2 Question A3 Comment A3 Question B1 Comment B1 Question B2 Comment B2 Question B3 Comment B3 1 Yes My A1 Comment No My A2 Comment Yes My A3 Comment Yes My B1 Comment Yes My B2 Comment Yes My B3 Comment 2 No My A1 Comment No My A2 Comment Yes My A3 Comment Yes My B1 Comment No My B2 Comment Yes My B3 Comment 3 Yes My A1 Comment Yes My A2 Comment Yes My A3 Comment N

Hey there! I am going to create my homestate Mazovia in Minecraft. I based on Bowen Island Raster (https://knowledge.safe.com/articles/1064/how-to-make-minecraft-worlds.html).I have everything quite similar but something doesn't work. Instead of DEM I use GeoTiff. After running programm I received a 5 warnings (below) and after translation my world doesn't have any terrain except roads and rivers.MINECRAFT writer: Converting component 'x' from type 'Real64' to 'Int32'. If this conversion is undesired, consider changing the type explicitlyMINECRAFT writer: Converting component 'y' from type 'Real64' to 'Int32'. If this conversion is undesired, consider changing the type explicitlyMINECRAFT writer: Converting component 'z' from type 'Real64' to 'UInt8'. If this conversion is undesired, consider changing the type explicitlyMINECRAFT writer: Converting component 'blockData' from type 'UInt16'

Is it possible, in a translation of GIS to DWG, to insert attributed blocks and fill in its fields?

My goal is to get schema attributes to save to a csv file that I can then use to setup my feature writer user attributes. I am struggling to get anything to work.Every sql I try returns errors, I have tried sql creator and sql executor with no success.

Hi guys,i'm trying to cleaning up some historical GIS data which hasn't been well managed in the past 5-10 years. in that drive, all project related GIS data is saved in each folder which was named by the project name. what i want is to have is to have a workbench to search for shapefiles by certain texts (e.g. survey area, study area, project boundary) and write those into one feature class which have the folder name saved in one attribute table.Any suggestion?Thanks in advance :)

Hi guys just wondering what is the easiest way to write several outputs based on the attribute value of my dataset in reader.Thanks!

Anyone know if Apache Hbase will be supported by FME anytime soon?

Hi all, new in the community. Could someone please provide some advice on the above, perhaps point me something out just to get started. I'm running some searches still no clear to me how achieve it. I'm beginner FME user.I'd like to convert the GIS points in my database to DWG, whereas one given attribute of the GIS point would be within the produced CAD point as text.Many thanks in advanceAlan

I am trying to write attributes for tree locations to a block I have created using a template with the DWGStyler. Do I need to first specify those attributes in the block template or is it possible to write the attributes to the Blocks when I write the new DWG?

WHAT CAN I DO TO REMOVE DUPLICATED GEOMETRIES .DWG, I use the matcher but the geometries are not being detected as equal, they have differences of millimeters. Is there any other transformer?

I have a json array in the structure[{"name":"A","content":"X"},{"name":"B","content":"Y"},{"name":"C","content":"Z"}]how do I extract it as the name/content (key/value) pair so that end up with a feature containing the following attributes: A: X B: Y C: Z  In the actual data there are about 40 attributes, so an automatic flatenning of some sort would be prefered.

Hi, we are migrating mapguide gis using oracle spatial to esri arcgis using sql server. I would like to check if there is a benchmark that can be used as a reference to compute for the loading time?IS there a rule of thumb in terms of number of features, data size?Thank You.

hiI have some data DWG stored in PostGis Database, there is one attribute packed, created by AttributePacker, with all features of the layer, for example line_weight, color in the others. If I use AutoCAD to read Postgis Database, it´s possible to show the colors and the others features stored by AttributePacker automatically?Thank´s

I want to add an image to a Word file. The image has to show a map with road names, house numbers and reserved areas.The map I get from a WMS service. The road names, house numbers and reserved areas I read from our PostGIS database as vector features.I use the "TextAdder" transformer to change the road names and house numbers from vector features to text and use the "VectorOnRasterOverlayer" transformer to create the raster image to use in the MSWordStyler. And I use the "FeatureColorSetter" to set the color of the reserved areas.It works well with the map and the reserved areas - but the road names and the house numbers isn't shown in the map.How do I change the text to raster ?

Hi everyone. I'm researching on how to convert an autocad file drawing to geotiff and found this software but I do not know how does it work. Could anyone help me the basic on how to convert autocad to geotiff?