Data

Hi, I am using FME Desktop 2017.1 and I would like to be able to write a photo in JPEG format to output into a cell in an Excel spreadsheet.Does anyone know how to do this?Thank you

I have 55 .gdb files in a single path and each .gdb file has 5 to 6 files. I have to read each file from each .gdb.file can you please suggest me solution?

I have a problem with conversion of 4 bands GeoTiff into ECW. I'm quite new to this. For me seems that ECW can hold up to 65k bands, so I think this should be possible. The bands are RED8 GREEN8 BLUE8 UINT8 - if I write only RGB it works, as well it works then I only choose UINT8 band.How could I write all the bands to ECW file ? Any clues ? I took a look at this reply: https://knowledge.safe.com/questions/66914/ecw-writer-this-format-does-not-support-writing-th.htmlBut unfortunately it didn't help.

i could do a list of layers of geodatabasae, but if are some layer empty, i don´t know to do read the name of this layer an export to writer.

A quite a few ffs files of ours will not open any longer. I only noticed this a week or two ago. Is this a common issue? And is it possible to salvage them?Here is one example:I tried och open them with several versions of FME and the latest was with 2018.1

[Using FME Server 2018]I am reading in a large volume or MicroStation files and want to limit the levels that are being read in. In a previous step I created a an Excel file of all of the unique level names in the DGN files for the user to review and give categories to. The user can then delete what they don't want and make sure the categories are correct for the rest. In the next step these categories will be assigned to each of the level names. I realize that I can just remove any feature that does not have a category assigned to it later in the process but that is not efficient. Since the DGN reader can populate the features to be read, I thought I could just read the list of level names from the newly reviewed Excel file and use that to limit which levels I read in. The difference is not minor. If I read in all of the features unfiltered, that would be over 1 million features. Filtering it first can bring it down to under 700,000 features.I was thinking something with an Excel

I have services into ArcGIS Server with the cache enabled.I use it as my basemap into applications, it is super fast, cuz it's tiled.Can I view those tiles into FME?When I try to read the service with Data Inspector, I only see the vectors, without the symbology! And it takes an eternity to read! The tiles are created from millions of vectors.I'm using the usual link from ArcGIS Server : http://MyServer/arcgis/rest/services/MyBasemap/MapServerGot an idea? Or it is impossible right now?This is my closest scale.

Hi,I am using the WFS Reader for downloading data. The reading of spatial and non spatial feature classes works. Spatial feature I can filter applying a search envelope. I am now facing the problem that the reading of the non spatial feature classes ends (successfully) after 100.000 datasets.My first question:Since I did not set the maximum number of features to be read I wonder where the limitation to 100.000 features comes from? Maybe from the server side?My second question:How can I filter out only those records that meet a certain criteria. I assume it has something to do with the XML-filterencoding?

Hello!We have noticed that FME 2018 seems to using locks more often than we previously experienced. Is this expected? or is it an issue on our side? It seems to occur mainly on desktop.

I have converted a textured Collada model into .kmz-format in FME (still using v 2016.1 due to IT-related questions). I have converted several buildings and I can see them all when opening the resulting .kmz-file in FME Data inspector and Google earth. However, when opening the file in Sketchup and another visualization software we are using it only reads one model from the file. Anyone bumped into this problem before?

How can i transform Bently .dgn BIM model to multipatch.GDB File ?

I have ArcGIS online Point Layer, each point location 10m by 10m image with point symbol need to be export in word document.ThanksVenu

I have a user that has a KML file that has utilities added on top of Google Earth. We need to pull out some of the data and translate it to either DGN or DXF. I created a workspace using the KML file to a DGN. It said it translated 2355 features but there was nothing in the DGN file. any help would be greatly appreciated.

I have a 3D DGN file comprising of a building model, I wanted to convert it to ESRI Geodatabase without any geometry and attribute loss. I used "GeometryFilter" transformer however only lines and polygons are created without attribute information lost. Can multipatch geometry be created?? Is there a direct workflow available to achieve 100% conversion from DGN file to Geodatabase?? Please help me with the workflow. I can share a sample file if you can look into it.

Hello FME community!I am currently working on updating the metadata of a feature class using the XMLUpdater. Everything is going great so far but I am running into a little bit of a wall here. I am trying to update the Horizontal / Vertical positional accuracy in the metadata sheet. Theses can be found in Resource/Quality/Report section of the sheet. Here is a picture with the fields in question: As you can see on this example its pretty simple. You set the Dimension and fill the Horizontal Positional Accuracy report in the Description. My problem arises because I currently need two reports, one for Horizontal and one for Vertical and once I create them the XML reads as follow:As you can see both XML Path for the XMLUpdater are the same with the exception of the "dimension". That means that the XML Path for both horizontal and vertical Description read as "/metadata/dqInfo/report/measDesc".My question is: Is there a way to differentiate between these two locations i

Hello to the lovely FME communityI am fairly new to the FME world and am currently working in a small project to update the metadata of a feature class using the XMLUpdater. The process is working fine except for when I am trying to update the XML values of a drop down menu. For example If you go to the Item Description of the feature class and go to "Overview" --> "Citation Contacts" I am trying to change the "Role" from Distributor to Publisher like this:After some trial and error I found that the XML tag for this particular field is: As you can see "value = 011" is inside the tag and I tried different options within the XMLUpdater but it seems you are only able to replace whats after or before the tag(RoleCd value="011"), not what is inside (in need to change the number 011 to 010). I think It is not something I can replace using XMLUpdater (at least to my knowledge) so I was wondering If somebody could provide some feedback and p

Hello,I am trying to convert IFC to 2D Shapefiles. What I really want is to get the 2D Exterior boundary of every model. Sometimes it is the footprint, but sometimes is the footprint + the exceeding slabs or a buildingelementproxy. My method is to use a 2DForcer and then a GeometryFilter to extract the Areas in order to write Polygon Shapefiles. However, in models with high complexity the 2DForcer creates many small polygons as attached in the photo, that kill performance. This is partially solved using the Dissolver, but in cases as shown in the photo the process can take 2hours or even more in a PC with acceptable specs (i7, 32GB RAM).I would welcome any ideas on how to make this process more efficient. I have tried the TriangulatedSurfaces but with no luck. I believe it is normal, since IFC's geometries are solids. Should I create composite surfaces and then work with them? But this sounds like too much trouble to just get the footprints of a model. The BoundsExtractor also did

Hello!I have a ifc file(,the model is white color) and I have to export them to gltf to visualize them on Cesium.With FME I can export them to gltf, but when i visualize them on Cesium,it is rendered black color. I found the gltf file lost some things such as "NORMAL" in "attributes",and so on.I don't know whty, can you give some advise? thank you

Related to my question about importing a prj file, I think one of these might be a solution. My inputs are DGN files and my outputs are shapefiles. The DGN files do not have a projection defined so I thought I can replace the prj file created by the shapefile writer. I came up with two different ways to do this but I don't know what will work in FME. Will one of these work for replacing my prj file?create the shapefiles and save in a fanout by a given attribute (category)read in the source prj filerename the source prj file to match each new shapefile and overwrite the existing prj file, effectively overwriting the one created by feature writer. What transformer will I use for renaming the file and saving it?I already have a process for creating the list of shapefile names, will fanout by the same attribute overwrite the existing file?replace all of the text in the new shapefile prj file with the text from the source prj filethis seems the easiest but I don't know how to read i

Hi, we got a strange message when placing an MSSQL tabular reader on the canvas (FME 2017.1 built 17652). Here is the screenshot (and a detail). Any one any ideas on this one?

I would like to convert OSM building boundary to CityGML LOD 1 format.I am successfully converting into KML or CityGML generic object format but When I am trying to convert to CityGML building by adding citygml_lod_name detail it showing following error.CityGML Writer: The 'IFMELine' geometry is invalid for the 'lod1Solid' citygml_lod_name, valid geometries for 'lod1Solid' are: {IFMECompositeSolid, IFMECSGSolid, IFMEBox, IFMEBRepSolid, IFMEExtrusion}, convertible geometries are {IFMEMultiSolid, IFMECompositeSurface, IFMEFace, IFMEMesh, IFMETriangleStrip, IFMERectangleFace, IFMEAggregate, IFMEMultiSurface, IFMETriangleFan}.Storing feature(s) to FME feature store file `C:\Users\....\osm2ogckml_log.ffs'+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `Building'Attribute(string)           : `_uuid' has value `9a3b482d-a204-465f-a73e-e35a6da505c4'Attribute(encoded: UTF-16LE): `building' has value `university'Attribute(encoded: UTF-16LE): `changeset' h

Using FME Server build 18305I am testing the Upload multiple files in the FME Server REST API V3 on my server.The goal is to upload a shape file using the POST /resources/connections/< resource >/filesys/< path > (Upload multiple files) method but getting stuck on using the file due to corruption.These are the settings:The return looks like this:Response Code:200Response Body[  {    "date": "2018-10-22T11:09:43Z",    "path": "/Testwerk/",    "size": 8360,    "name": "waterschapsgrenzen.dbf",    "type": "FILE"  },  {    "date": "2018-10-22T11:09:43Z",    "path": "/Testwerk/",    "size": 428,    "name": "waterschapsgrenzen.prj",    "type": "FILE"  },  {    "date": "2018-10-22T11:09:43Z",    "path": "/Testwerk/",    "size": 170,    "name": "waterschapsgrenzen.shx",    "type": "FILE"  },  {    "date": "2018-10-22T11:09:43Z",    "path": "/Testwerk/",    "size": 960243,    "name": "waterschapsgrenzen.shp",    "type": "FILE"  }]Everything looks OK till now, but when downloading an

Hi,I try to import an Excel file in a Postgres table.But before inserting the rows of the Excel file, I have to delete all records in the destination table where the values of a column from Excel file are matching the values of a field in the Postgres table.I achieved to perform the delete operation with an Aggregator transform that performs a groupby operation on the Excel column and a SQLExecutor transformer that deletes in the destination table all records whose values are matching one of the groupby values.That part works fine.But now, I don't find out how to plug after this the insert operation on a Postgres writer.Because the SQLExecutor returns only the groupby values from the initiator.I don't think I can use a DatabaseUpdater transformer with fme_db_operation for this context.Thanks for any help.

Is there an equivalent reader to the Directory and File Pathnames (DFP) that can take as source parameter a file, or files, including wildcards, and produce one feature for each file, but not actually read in the file.  Essentially it would be the DFP reader that can take a Filename (Multiple) parameter instead of just a folder.  My current workaround is to use the Text File Reader, whole file at once, but it's reading a bunch of data unnecessarily.

Just want to know if FME can convert Excel xlsb to xlsx format? Thank you very much.