Data

we want to save data in one excel document but with multiples sheets, each one will have a specific group of featuresplease sheet the attached Image

I'm not getting the full geometry data after converting from shapefile to tde, as I did before, only getting a single row for each polygon in the input file, not the granular, ordered, list of geometry points.

Hi,I Would like to read a directory with 76 LandXML with one alignment each.Replacing the current name of each Alignment name with the basename file.and Place all the result in one LandXML or separately- I used the StringReplacer and replace the feature Name for the basename.Its working fine on the Inspectorbut cannot exporting the landxml file.I try to export all LandXML in one file and export all LandXML in basename alignement file..But having problem with LandXML exporter.Do you know how i can merge it ? Thx!

According to the Elastic documentation: "The 'nested' type is a specialised version of the 'object' datatype that allows arrays of objects to be indexed and queried independently of each other." Nested objects allow you to filter on multiple fields within the same objects in arrays.Is it possible to get the ElasticSearch writer to write the properties as "type : nested", as shown here:PUT /my_index{  "mappings": {    "blogpost": {      "properties": {        "comments": {          "type": "nested",           "properties": {            "name":    { "type": "string"  },            "comment": { "type": "string"  },            "age":     { "type": "s

Hello ,we have more than 300 Geotiff image in a folder we need to pick the right one that fit a polygon we have in shapefile , is there any way we could do that with FMEThanks

 Hello,I have a shapefile that consists of roof, walls and ground in a buildings model. Each surface has it's own ID ('UUID_BYGGN') assigned to it together with building part ('MSLINK2'). I have a workspace where I read in all the features and sort the surface based on attribute ('IGDS_LEV_N') which tells if it's a roof, wall or ground. After this I assign the attributes 'gml_id' and 'gml_parent_id' to each surface but something is wrong in the workspace. I get error message: CityGML Writer: Found a cycle. The ids of the elements which created this path were `GML_01861c27-7df2-4021-bd4b-300c3b496991,GML_01861c27-7df2-4021-bd4b-300c3b496991_1,GML_01861c27-7df2-4021-bd4b-300c3b496991'. CityGML Writer: While determining the CityGML element heirarchy (based on the gml_id and gml_parent_id attributes) a cycle was detected. Cyclic features can't be serialized into a CityGML Docu

I have created a custom transformer for clipping using lastools. My input readers are LAS file and the polygon shape file. When I run the translation, the LAS data is read but my polygon reader is not initiated. Hence when running the command line tool, the polygon file is not loaded and I run into an error. I disabled the LAS reader to check if my shapefile reader is working fine. I get the same error this time but because the LAS is not loaded. (Obviously!) The point is that there is nothing wrong with the reader.So, my question is how to ensure that both the readers are read at the same time when I run the translation so the my custom transformer can get both the input files for its command line argument?

how do you keep the original colour of my dxf file when I want to conver it into a 3D pdf or a .obj file?It converts them all in grey.Thanks,

Hi, We are trying to distribute FME Workbench through Microsoft Virtualization and for that we would like to know how FME detects that GPSBabel is installed. In our current setup GPS-like readers and writers and their feature types are correctly placed in the workspace, however, running the workspace  fails, telling: FME API version of module 'NULL' matches current internal version (3.8 20160224)Creating reader for format: TomTom POITrying to find a DYNAMIC plugin for reader named `TOMTOM_POI'Loaded module 'TOMTOM_POI' from file 'E:\App-V_5\D52C8804-9F50-4D7B-A695-142DCEFE7A5E\87B5596E-AF57-4FA1-B219-EA631F902A79\Root\VFS\ProgramFilesX64\FME\plugins/GDAL.dll'FME API version of module 'TOMTOM_POI' matches current internal version (3.8 20160224)TOMTOM_POI reader: Opening file 'Z:\Temp\Webfleet\gulocPlStr16.ov2'TOMTOM_POI reader: Could not create process gpsbabel -i tomtom -f Z:\Temp\Webfleet\gulocPlStr

I converted Autocad dwg to KML but I am having issues with attribute blocks. In KML file text in the block is separated into 3 entities with each one having a placemarker which I want to get rid of and show only plain text with proper attributes. Also I do not want to show kml_xxx for each poliline.CAD file, workflow and KML file attached.Any help would be much appreciated

Hi all, I need to convert a couple of hundred pages in SharePoint to MS Word format. During the conversion process (aspx to docx) I need to perform following steps: 1. Read metadata from the page 2. Read the text from a Content Editor webpart while maintaining text formatting 3. Read the page Version History 4. Create a Word file and add the metadata that was copied from the page 5. Add the formatted text from the Content Editor to the new file 6. Add the version history to the new file It would be interesting to know if anyone has done any of the procedures above. I think that steps 1 and 4 are quite so straightforward and I expect challenges in steps 5 and 6. Best regards, Halil Radogoshi

Hello everyone,I am a bit frustrated and have done this in the past (April of this year actually) and for the life of me cannot get same results.I have an access database with a large table that has multiple columns and one of the columns is "Town" and I need to export Excel sheets by town carrying all the data for that specific town (from all the other columns).Ive tried Fanout and Ive tried in writer to ask it to create via town field. Nothing is working. Its frustrating.I know the answer is simple and I thank you in advance to who ever can jog my memory.Also dont get me started on co-worker whom deleted workbench!Thanks!Savas

Can anyone tell me the best method to use to scrape the following webpagehttps://historicengland.org.uk/listing/the-list/list-entry/1435084I am trying initially to extract the following data:-NameList Entry NumberI have tried using the HTTP Caller linked to a HTML Extractor but i can not get anything extracted.Thanks in advance

Hi,I use the smallworld 4.3 translator to read data from a Smallworld database in FME 2016.1 32bitIn the SWORLDSWAF reader i enter an alternative that I am interested in (Alternative: |design_top|xxxxx|) and set export changes from baseline = Yes and Baseline Alternative= | to read changes from the top. I then expect to only get the changes made in this alternative in the database.When i run the query early in the morning (close in time to a nightly system restart) I get the expected result with changes from the alternative of interest. However during the day I get more and more data that has nothing to do with the alternative. I seems like there is a session created at my first connection attempt whitch is then used as top and all changes in or outside the alternative of interest is considered a change. Powergrid is the software we use for network design and in there I can refresh the session I work in by clicking a button. This function is what I

I have a support case in on this - C131989 - but figured I’d ask here as well. I have an existing workspace that’s been running fine every night for months. All it does is access several tables in an AS/400 DB2 database (via an ODBC connection) and export these to a SQL Server database. This is about as simple as an FME workspace can be i.e. one reader to one writer for several tables, no transformers. I now need to add a new table. When I try to import the feature type from the reader, I get the list of tables, select the one I want, and then get the following error:Opening ODBC 3.x ReaderODBC 3.x Reader: Dataset = GTCOUNTY.HTEDTA. Username = citywork. Password = ************Connecting to database...ODBC 3.x Reader: The DBMS name fetched by ODBC driver is 'DB2/400 SQL'ODBC 3.x Reader: The DBMS version fetched by ODBC driver is '07.01.0015'ODBC 3.x Reader: Database version is '7.1.15'ODBC 3.x Reader: Cu

From this Question: ESRI Shape files with UTF-8 encoded field names ?The issue is more serious in FME Cloud (FME Server/Engine on Linux).Most users in Japan use Shapefile datasets with the cp932 (Shift JIS - system encoding in Japanese Windows). However, since FME Cloud always treats attribute names of Shapefile datasets with UTF-8 (system encoding in Linux), all the datasets with Japanese attribute names cannot be processed with FME Cloud. MapInfo (MITAB) seems to have similar issue too.I'm afraid that the problem above might be the tip of the iceberg - i18n issues on Linux FME engine.

Say I have a FILE GDB called Fruit with the following feature datasets (Oranges).say there are not feature rows inside Peel or Slices feature classes. how can I extract the coordinate systemFruitOranges (feature dataset) peel (feature class)slices (feature class)In arcCatalog I can easily right click the feature dataset and go to the XY coordinate system tab to see this.methods I have tried in FMETCPL start up script - (here I extract domains and geometry type, but no COORD systems)populating a single row in FME, than reading trying coordinate extractorpython caller - this will not work if feature dataset is emptyThanks,Doug

Hi! I am writing an FME script to insert records into target table. Before inserting a record, I want to delete the record has the same ID in database, if it exists. I made an FME workspace as screenshot to do run a DELETE T-SQL command for each feature, such that all deletions are performed before any insertion.the translation will terminate if any of the deletion fails.However, I considered the following hypothetical scenarios (in practice I never seen any of them happened, but still possible).The 100th feature fails in the SQLExecutor, such that the translation ends with 99 records deleted from database.All feature passes SQLExecutor, but the first feature failed in the writer, such that the translation ends with all deletions done, but not insertion.Considering the importance of data integrity. Is it possible for me to change the workspace, such that:If any feature fails in SQLExecutor transformer, t

The following workflow of comparing tables (in two separate databases) and updating an existing database (SQL non-spatial) is taking for ever. It has been running for 12 hours now to update the database. In 12 hours only 5424 records are compared. I am expecting about 20,000 records to be updated weekly based on update detector comparison. The change detector transformer is in the workbench since I tried that approach as well but failed. How can I make the workflow run faster?

Hi,Im wondering if there is some "best" format for fme to understand?Lets say I want to write vector to raster, but I would like to keep it as smooth as possible to do. Problem normally comes with symbols and different linestyles. For now I've been doing all this with mapnikrasterizer and it works great.Just there is lot manual work to do before it goes like I want. Ofcourse after its done, there is minimal manual work to do. But once you've done bunch of these, I would like to know if there is something I could skip with my workflow? Like automatic symbol reading from other format? Or smthing else. 

I like to write the ouput of a transformer to a new esri file geodatabase using FME 2015. I use the Writer Esri Geodatabase (File Geodb API) and for Parameters a template is asked. I point to a Template.gdbNext is again asked for a gdb but if the fgdb does not exists yet, the same applies for a Dataset. How to import into a new fgdb and new feature class with FME 2015.

I have multiple black and white rasters. I want to mosaic them together and then compress them to make them more manageable. These rasters however are scanned images of historic mapping.This means that I have areas outside the georeferenced bounding box that are white(see image). Most sheets have these white areas, so when I mosaic these sheets together there is overlapping, this leads to part of a sheet being covered by another sheet.As these sheets are georeferenced should the extra white areas not both be forced underneath the sheets they overlap? Is there anyway I can force this to happen?

I was wondering if this is at all possible?