Data

Hi,my wb reads an ESRI-SDE Feature-Dataset-->Feature-Class --> table. I want to write this table as a gdb. (ESRI-SDE-Reader and GDB-Writer) But the gdb has the same structure like the source:GDB-Name--> Feature Class -->table. Is their any Chance to write the gdb with following structure:GDB-name--> table?Thanks for helpBarbara

Hi, I am currently trying FME2017 Beta and especially the 3D-Tiles. My Problem is that I am trying to generate a simple box in the middle of brussel and trying to view it in Cesium. I see Cesium loading the tileset file and the tile, but nothing is shown in the viewer.Is there any example of a working model + Cesium viewer to view the data?Thanks.Vincent.

Hi All, I have ESRI shape files with polygon geometry type, i need to extract the text from them and need to import the text to Smallwrold. In Smallwrold, the geometry type is annotation, i'm using the transformer "Label Point Re placer", features are imported to Smallworld, but when trying navigate to a feature, getting message "The selected object do not have the geometry in the map" in smallworld. Please suggest how to import text from Shape files to Smallwrold. Thanks in advance. @takashi @itay

Hello  I have a GM-access-table that I want to import to oracle. Instead of the original auto-number ID, I want to use an UUID in oracle, which I generate with the UUIDGenerator, and save it in a raw-type field.  How do I do this, as in FME raw-type columns are not shown?  Thanks in advance! Vera

Hi,I'm trying to do some reporting in Excel using FME and an Excel file as a template.The template is quite simple with some formatted fields, a logo, few combined fields.The Excel writer writes the data after the formatted rows (B12).Everything works fine, until I add a formula in the field D11 (as simple as =Sum(D12;D100)). Then, Excel throws an exception when loading the generated files and the formatted fields are no longer formatted.The exceptions I get is in french but could translated to : "Sorry... We found a problem in the file "xxxxx.xlsx" but we can try to recover data if the file is safe". After a data recovery, the data is there, the sum is calculated, but the fields are not formatted anymore (probably because of the recovery...), the logo is gone. The recovery log is stating that the is a major failure at Line 1, Col 0. Nothing more.Any ideas on what can cause this behavior ?Thanks for your help.RegardsPhilippe

The questions speaks for itself. If I simply connect a shp writer the output has no geometry

Ok, so this is the situation:I have a workspace that is completely functioning in FME Desktop. In this workspace, a lot of writers are implemented, creating folders and output. Some examples:- $(FME_SHAREDRESOURCE_DATA)/output/$(DateString)/Validation/Validation.html (for a html writer)- $(FME_SHAREDRESOURCE_DATA)/output/$(DateString)/Delta/ (for a esri shape writer)- $(FME_SHAREDRESOURCE_DATA)/output/$(DateString)/output.gdb (for a file geodatabase writer)De folder "output" already exists, but the folder "$(DateString)" not yet. The DateString is made in a small Private Parameter script.In FME Desktop, this results in all my folders being created and files being made exactly how I want it. However, when I do this using FME Server, only my geodatabase writer seems to write anything (and often not all the features that should be in it!) in my output folder. The other data is only available as a downloadlink after the run (which is not how I need it to be). Any idea h

I have combined a las file with a aerial photo using the PointCloudOnRasterComponentSetter and would like to save the result as a 3d pdf. The results looks great in the data inspector but now i´d like to share it.What would be the best method?

The workspace completes successfully and FME's Data Inspector can select the layer.

I got two layer - one GeoTiff with DTM from Lidar data, the other is a shape file or another surface layer. I want to compare them (in ArcGIS or QGIS) you find procedures like "cut and fill" - in the end you got a summary of shapes and their volumes (positive = fills, negative = cuts). I need this for a couple of projects in my job - plan a road and calculate the bilance of the material or compare Lidar data for change detection. (I hope my English isn't to bad.)Thank you!

Hi,I am creating a process to 'clean up' our microstation v7 dgns - remove duplicates, unwanted data on wrong levels etc.When I read the v7 dgns then write back to v7, I am losing any dimensions. They are changing from idgs_element_type 33 (dimension) to 4 (lines).I have the 'drop dimension' unticked.Has anyone experienced anything like this? Am I doing something wrong?Any help would be really appreciated.KRAmgaad

i have two tables one table of points and seconds of polygon and i want to calculate distance of polygon.

Hi guys, I have a textured .obj file. I would like to add watermark (logo of company or author name) on top of texture and set transparency to ~ 50% to not cover completely my textured model. I was thinking to use appearance setter but i can't find a good setting to achieve my goal. I don't want to edit mesh, change number of triangules or set different coordinate system etc. Anyone have idea how to make it?Cheers, Magda

I have table of polygon from PostgreSQL and i would to transform polygon to autocad so i use fme desktop to generate autocad but when generate autocad i don't get polygon of the pacelle i get just point of the polygon PostgreSQLfmeautocadhelp me please

Hi, In FME 2016.1 and probably earlier releases too, it is found that if the user lacks permission or if a featureclass is unavailable in an ArcSDE Geodatabase thats has been configured in one of the Readesr in the workspace , FME only tends to issue a 'Warning'. I would expect this to be a more serious kind of Error ( Not warning) and report a failure and abort the translation. Is there a reason why the Validation(Checking for existence/permission) of a featureclass in a Reader is not available and not treated seriously?

Hei,The SQLExecutor transformer uses sets of 10000 records (as postgis reader uses as default). Is there any way to increase it?

Hello everyone,I am new to FME, I just turned to it in search for a GIS problem I couldn't solve in ArcGIS and I am surprised by the wide choice of tools! But I still haven't found the solution I was looking for.I am looking for a way to dissolve or even better smooth touching 3D data. My input data is ESRI shapefile (either multipatch or polygonZ). Any workaround would help, and avoiding to obtain a single feature in the output but maintain the attributes of segments (except at crossings) would be a great plus. Briefly, what I have is a street network as 3D polyline shapefile, with a field indicating the width of every street. In ArcGIS I used 3D symbology to create a strip of the right width, and "3D layer to feature class" to obtain a multipatch. However, this operation naturally cause overlaps at road crossings, which are a) not nice, and b) causing many issues when I process my data further (e.g. flickering "Z-fighting" polygons).One idea was to use th

If I choose Frankfurt region, does all my data including backups and snapshots remain only in the Amazon Frankfurt availability zone or is there a backup/ mirroring into another zone (Ireland) or Region (US East)?

Hi Guys,I am new at the FME Software and actually trying to transform an json file to an csv file. With the example i could create such flow that works. I checked the Output and wondering a little bit that the headlines of the json objects are in the fields. Example:{"cruise_nid":413358Cruise_nid is the object name (in a json array) and the 413358 is value. In my powershell script that i actually using for that transformation, the cruise_nid used as Headline. How i can configure the JsonFragmenter to use the objective names as Headlines?The second Point that i got is that on anorther json i got an error that the json is not valid:A JSON syntax error was found at line 39, column 28A sequence of bytes was found which is invalid in the utf-8 Encoding.I checked the json file, but there isnt a column 28 in the line 39. In column 59 i got an umlaut. But i thought that that will be in UTF8 be no Problem. Any tips?RegardsTimo

Hello all,  I am being sent a large number of ESRI file geodatabases.  Within these I need to:  1) check if the individual feature classes contain a specific field (this field, e.g. [Field_x]), should be contained in all feature classes so can be a generic test accross all feature classes). 2) secondly I need to check the fme_data_type, this should always be Integer  I am first trying to test this on one field - however I will have a lot more to test and will need to add and remove more tests over time.  Can anyone help on how to achieve this?  I have loaded the .gdb into FME using the "Schema (Any Format)" translator and I can see the values I need to test agains recorded in the attribute{}.fme_data_type and attribute.{}name attributes - I just can't work out how to test them!  Any help would be very much appreciated.  Regards,  Kevin  P.S. I am happy to share models/data etc if easier - however it is only the second time I have posted on this forum so not sure if this i

Hi,  Can anyone advise me how I can configure a workbench to read all the files into a workbench? However, I do not want to read them all in at the same time (using the 'directory' reader feature) so that the features from different dataset are all running through at the same time.  In essence, I want to read the first file in directory, process and write out the results from the workbench, then and only then read in the next file and process, repeating until all files have processed. (Because the processes I want to run I think it will be too difficult if I try to process all the files at once, therefore I would rather that the datasets are handled in isolation.     Thanks in advance,   Rob   

Is there some way I can make use of the featurereader to clip LAS files with the initiator?

I have been using a workbench for months which writes to a file geodatabase using the 'Esri Geodatabase (File Geodb ArcObjects)' writer. I am using FME 2016.1.3.1 64-bit (I was using a previous version of FME 2016.1 and was hoping that an update to this most recent version might solve my issue) on a computer where ArcGIS 10.4.1 with background geoprocessing and ArcGIS Pro 1.3 is installed. Coincidence or not, since the latest updates for Windows the workbench is not working anymore. In the image below you can see which updates have been installed.On my computer runs Windows 7 Enterprise Service Pack 1.The error I get in FME is: Unable to perform any licensing related tasks.  This is a 64-bit version of FME which requires a 64-bit version of ArcGIS Server. Or download and install a 32 bit version of FME. Refer to this this article http://fme.ly/qua for more details Following the link in the error message I read that I need ArcGIS Pro or ArcGIS Desktop background processing, but that is