Data

When I use the Emailer transformer and send an email with a *.xls attachement it works fine but I want to send a *.xlsx attachement. When I do that, I get an error. Is it even possible to send an email via de Emailer with an *.xlsx attached to it?

Hi,My question is quite simple but I don't find the solution:Is it possible to change the schema of a postgres reader, and even the table name ?This field is disabled when I try to edit the reader (see below).The only solution I found is to recreate the reader.Thanks for any answer. Christian

Hi,Can FME read drone log file (UBX, it captures flight path) and convert to sHP/kml?thanks,Wilson

I want to create LOD2 objects from very dense LiDAR data approx 20 points/sqm. As input i only have 2D buildings as polygons, representing outer boundary of building, with no roof-ridges or other roof details.I have tried transformers like TINGeneretor, SurfaceModeller and PointCloudSurfaceBuilder but I can't get a neat result. My main issue is going from the high resolution TIN to larger generalised planar roof surfaces.Main question: How do I use FME to make planar areas to represent a simple roof with two (or more) roof sides? Greatful for any ideas.

Using powershell to get the current token of a user I do not have problem:$uri = "http://myserver/fmetoken/view"$postParams = @{user='Myuser';password='PS78U-w&'}$foo = Invoke-WebRequest -Uri $uri -Method Post -Body $postParams$foo.Contenti receive the token.if I use postman to verify it, there is no issue.but if I want to implement the same action in c# i always have a bad request: var url = $"{fmeServerUrl}/fmetoken/view";var body = $"user={settingsUserFme}&password={settingsPasswordFme}";var bodyencoded = System.Net.WebUtility.UrlEncode(body);var byteArray = Encoding.UTF8.GetBytes(bodyencoded);var responseCode = 0;var request = (HttpWebRequest)WebRequest.Create(url);request.Method = "POST";request.Credentials = CredentialCache.DefaultCredentials;request.ContentType = "application/x-www-form-urlencoded";request.ContentLength = byteArray.Length;var dataStream = request.GetRequestStream();dataStream.Write(byteArray, 0, byteArray.Length);dataStream.Close();WebResponse response =

Hi,I am trying to read a number of excel files. Some of these files have a sheet called content. In cell A1 there is a name which is different for each file with the content sheet. On the second row there are attribute headers, and from the third row each row contains data. The problem I have is that the first file I read from a directory does not have the content sheet. So I can not specify start row 0 when reading attributes. The result I now get is that the first file with a content sheet is read but the first attribute has the name of the value in cell A1. Every file coming after this tries to read the same attribute name as the first one which is missing in this next file.Does somebody know a solution other than removing the first row from content sheet.

I am trying to use FME to produce a json object which can interact to JDE AIS. This requires several HTTP POST calls to perform actions in JDE. I am trying to get a Token which is the first step and is a very simple object. I have used a program call Postman to simulate the POST request which returns me the token successfully. I am trying to replicate this process in FME but i recieve the following error  HTTPCaller(HTTPFactory): Received HTTP response header: 'HTTP/1.1 400 Bad Request' from 'http://Server:Port/jderest/tokenrequest' Does anyone have any ideas as to what i could try to get this process to work?Screenshots below.

Hi everyone, is it possible to write pointcloud features to 3D PDF? When I try to do so all I see in the pdf is the bounding cube of the pointcloud feature but no points itself.In case 3D PDF is unable to display pointclouds properly, is there a workaround for this issue? I played around with 3D spheres that are located at every 3D point - position but that forces 3d PDF to its knees with not more than 10.000 points/spheres which is rediculous less for pointcloud data and therefore doesn't seam to be a suitable way. Attached a small sample of a pointcloud feature

After installing Autodesk Revit 2019, I can not seem to get the FME Exporter in my Add-Ins tab. I also tried going to my FME Integration Console (following instructions from this page: https://knowledge.safe.com/articles/597/how-to-use-fme-exporter-for-revit.html), but there I don't have any application in the list to extend. Anyone an idea how to get this working?

Is it possible to convert an E57 file from a bridge or building to a 3D PDF.Only have the scan, no photo and everything in a local coordinate system.

I was trying something with a free IFC dataset containing a terrain model and some linear features (alignments). You can download the data here (click 'Examples' --> Terrain and aligment).The FME IFC reader/writer is compatible with IFC4. I am assuming this does not include the 2 extensions of the IFC4 standard? Anyway, it is impossible to read the alignments.  This means that things like IfcAlignment, IfcBridge, IfcRoad are impossible to work with in FME (read or write?). These features are currently being reviewed for future releases of the IFC standard (http://www.buildingsmart-tech.org/infrastructure/projects).So we will have to wait for the standard to be published and the IFC Reader/Writer to be updated? Or is there somekind of workaround? Your advice is much appreciated.

Is Microstation Connect Version available as a reader/writer in FME and if so what version of FME?

I am trying to write a value to a column in an excel sheet called NEWCOUNT based on feature names located in the column LAYER. I was previously using an old writer (xls_ADO) which allowed the use of SQL but since that is no longer offered, I must use the xlsx writer. How can I use the writer's formatting parameters to do this?

I try to use FME to convert CityGML to glTF, but it shows the export file is glTF1.0.1, how I can convert to glTF 2.0? Thanks

My workbench reads Ids from an SQL Server database using an SQL Creator. Records with these Ids are deleted via an SDE writer that connects to another database. I use an Attribute creator to add the fme_db_operation DELETE to the feature. I also synchronize INSERTS and UPDATES in a similar way with the same writer. I use the SDE writer because I want to utilize the ArcGIS Archiving functionality.This process has always worked as intended until recently I have been getting the following error when doing deletes (inserts and updates still work):Error while deleting feature in the table/feature class 'schema.table'. The error number from ArcObjects is: '-2147216104'. The error message from ArcObjects is: {Shape or row not found}As far as I know the workbench has not changed at all. I have tried adding a new sde writer but to no effect.I have confirmed that the Id I am trying to delete definitely exists, and the record is not archived (I can see it in ArcMap etc.) 'Id&#

Is it possible to use the SharePoint reader to connect to a SharePoint using anonymous credentials? There are a few public sharepoint websites where we would like to mine information from and all of the options in the reader are requiring authentication.Is there an anonymous syntax, option or checkbox somewhere?

I have the SnakeGrid projector so can convert coordinate systems but can't seem to carry the attributes over (I have tried AttribueManager and AttributeCopier). Also, can I input several .shp and run a batch to export as .dgn with attributes carried over? Any help would be massively appreciated.

Hello - I have a Google Sheet that is designed in such a way that some of the columns (8 total) are repeated 10 times. An example of the structure is:Time|Name|Date|Report|From Time|To Time|Activity|Location|District|Neighborhood|Activity|More?If "More" for the data entry of the form is set to "Y", the following columns are repeated for additional data entry:From TimeTo TimeActivityLocationDistrictNeighborhoodActivityMore?When the Google Sheet is added as a reader, the repeated columns have a 00 to 08 appended to them.What I need to do is, based on "More" being set to "Y" for a user (i.e., Name, Date), create N number of rows taking the values from the 00 to 08 columns to create the subsequent rows.I've played with AttributeExploder, Aggregator in my current workspace but I'm stuck! :)A push would be great from the community.Thanks in advance! 

Hi all,I have installed Oracle clients 12.1 32 and 64bit on same machine and I can run my workspaces successfully (using FME 2017 32 bit or FME 2018 64bit)However for other users the Oracle formats are greyed out in your Formats Gallery. Also they are unable to run the same workspaces. They can however connect successfully to the Oracle DB using SQLDeveloper I have the following entries in PATH environment system variable:C:\\oracle\\product\\12.1.0\\client_2;C:\\oracle\\product\\12.1.0\\client_1 etc...I also have TNS_ADMIN system variable pointing to a network path Any ideas?

Good morning,I am having trouble overriding a coded domain value within a GDB. I received a GDB and I do not need the coded domain values assigned to one of the attribute values. Instead of going through each feature class and remove the coded domain option, how can I override the current coded domain values in FME? I am using the GDB API writer with Feature Operation: Insert and Table Handling: Truncate Existing. Appreciate any assistance!David

Dear all experts,I am now dealing with the project that visualizes CityGML on the Cesium web application.My input CityGMLs sometimes have a wrong orientation so that the output 3D tile have the wrong side of the wall. Is there a way to convert with double side facing or to correct the wall orientation?Thank you so much!Best regards,Joe

Hi, I have a big csv file with point data (over 300 million points and z values for a 18 year timerange) , it represent the depth of a lake but the depth measures are made in different years. Some parts are measured once in the hole time range but other parts measured more than one time. From this file I have to made different raster datasets, one of them is the “Last measured depth”. I can read the csv with a CSV reader and made the calculation (See png, “Actual_Value” show the last measured depth and “Jaar” the year where the measuring took place). But reading the csv takes a lot of time and I prefer the efficiency of the “Point Cloud XYZ reader”. With the Point Cloud XYZ reader it is possible to read this big csv real fast but I can only read one z value. My question is, is there a way to use the Point Cloud XYZ reader and do the calculation for the last measured value in the same run? Or is there another way to handle such large data files in FME?   

I have made a connection local with FME 64b to SQL server.This worked for about a half year but now I get the message:Error: COM.safe.fmeserver.api.FMEServerException: User encryption is specified but can't find key to decrypt.and com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host ..., named instance ….,... failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) at com.microsoft.sqlserver.jdbc.SQLServerConnection.getInstancePort(SQLServerConnection.java:3639)According to the DBA-er nothing has changed (ports are ok and there is no firewall inbetween) and when I try to log in with SQL DEVELOPER there is no problem. So I tried different varie

In 2016.1 I use a "Esri ArcGIS Online (AGOL) Feature Service" Reader and login successfully, however when I browse the Feature Services, it does not show the externally-shared services/layers that I need. I can confirm the data is visible in AGOL and accessible via REST using Postman.Is there a possible syntax for the "Feature Service" box I could use? I tried [Feature Layer Name] and [Group Name]\\[Feature Layer Name] without success. Otherwise I guess I'll have cut-over to raw REST/JSON.  

Dear All,I have big text file Like shown below as sample Name / Company 01Location : ABCTYPE : AName / Company 02Location : DEFTYPE : IndustryCategory : ProductionName / Company 03Location : DEFTYPE : IndustryCategory : ProductionManagerID : 01The expected output like shown below, Name,Location,Type,Category,ManagerIDCompany 01,ABC,ACompany 02,DEF,Industry,ProductionCompany 03,DEF,Industry,Production,01 In above in each company there are many new attributes available (around 100+)Please advise. ThanksVenu