Data

Hello,I Have an error when I want to use a reader to a Non spatial Hana Database (see image below)I have a user that can only access table IFLOT for readTo you have any idea ?I use FME Desktop 2019Thanks

Good day,I have a working FME Server 2019 environment and would like to use the FME DataExpress app on my phone to access FME Server (and server apps). Our company uses MobileIron to secure Apple-devices and set up tunnels for communication.This way it must be possible - at least theoretically - that the IOS-app can connect to our FME-server that is behind our corporate firewall and NOT part of our DMZ.At the moment, it doesn't work and I made an appointment with our system and network engineers. I think we might open some ports in our firewall. Is there any technical information available about the communication (IP-addresses, UDP, ports, etc.) we need to know in order to configure the firewall.Thanks in advance,Frank van Doorne

Hello everyone,I've got a certain problem that I can't solve for many days.  I'm trying to find the overlaying areas between an IFC file and an ACAD one.  I explain the idea, the purpose is that I've got 2 readers as entries : one for IFC and one for ACAD. then the we need to find the spatial relation between each objects of the IFC and the zones drawn in ACAD. --That point is OK. Then for the objects which have 2 _related_candidates, I would like to calculate the overlaying area with each zone to keep only the one with the biggest overlaying area. My problem right now is about that second step that I can't solve for the moment. I hope it's clear enough and you'll be able to help me with this matter. Regards,Clem

Hi, I use a polygon > boundsExtractor > OSMDownloader but i get error OSMDownloader_HTTPCaller (HTTPFactory): HTTP/FTP transfer error: 'Couldn't resolve host name'OSMDownloader_HTTPCaller (HTTPFactory): Please ensure that your network connection is properly set upOSMDownloader_HTTPCaller (HTTPFactory): No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered.  What did I miss?   

HI,For test purposes I'm reading from two ESRI FileGDB with a FFS writer (no further transformations).Now I recognized that the FFS writer wrote an additional .fts file. It's binary and larger than the.ffs (e.g. 5MB vs 11kb).What is the meaning of .fts files?thanks, Klaus(FME Server 2017.1)

I already have a lot of 3ds files with textures for building. I'd like generate CityGML LOD3 data from these 3ds files.For LOD3 data generating, I think the first and the biggest problem is how to classify Window, Door and Wall.I think it is possible to crop or edit the window or door in 3D MAX.But I don't know how to assign the properties such as Window, Door and Wall.If you have any idea or experience, please share your experience.      

Hi, we have SmallWorld 4.2 and would like to automatically export data to another database using FME server on a daily basis. As stated here, the connection service to FME is started automatically in SmallWorld 5.x, not in previous versions. I need to know if it is possible to automate the start of the connection service. The idea would be for example to start automatically the connection service at 1 AM everyday and then start the export workflow on FME server at 1.05 AM. Is it possible with version 4.2 of Smallworld ?Thanks in advance !

Is there a way to retrieve the URL of documents within sharepoint?

I've been working with Minecraft maps and FME for a while, although I'm struggling to develop a way to use change detection for a batch of 40 Minecraft maps, compared to a single map. My main issue is related to improve processing, because processing Minecraft maps as PointClouds is almost impossible due the large files it generate.  How could I use change detection in Minecraft maps in optimized way?

I have osm file for my city, I am using Libosmium to read it, and I'm storing nodes of each way as Vertices of My Graph, and making edges between each 2 adjacent nodes in each way, and calculationg eucledian distance between them, the problem is that : The ways are not connected with each other ! I can't reach my destination from my target, even though there is a route, but there is no node intersect between the ways (No common nodes) so I can't reach my destenation ! What nodes should I add to my Graph, and how to bridge them correctly ? so I can reach my destination from My Node ?

I have a user that requires a non-spatial SQL Server Table provided to them as a Tab Separated CSV file. I have found the CSV writer, but cannot find an option to output as tab separated instead of the Comma Separated.Does anyone know if this is possible?Thanks very much for your time.Cheers

I have two inputs that I'm trying to write to multiple pdfs, one is constant and the other changes with a fanout. But I can't get it to put both inputs on one pdf. I'll try and explain with an example:Input one is a roads dataset, input two is a neighborhood's dataset. I'm using a dataset fanout to produce a pdf for every neighborhood and want the roads to also be on each pdf. I can't seem to combine the two, at the moment I get a pdf for each neighborhood and a separate one for the roads. What am I missing?I'm new to FME, so apologies if this is something really simple that I've missed!Andy

Hello,I am trying to migrate PDFs with the FileCopy writer. I have destination path and file names with lengths from 260 - 300+. They fail, but if I change the path to be shorter they all succeed. Am I mistaken in thinking that FileCopy limited to 256 as its max pathname character count? Is there a way around this? Has anyone else run into this issue?Additional info:FME(R) 2019.0.0.0 (20190328 - Build 19238 - WIN64)Windows 10 Thank you for your advice,Andy

When "Overwrite existing file=No" in a text file writer, new data is appended to the end of the file. But if the file output is gzipped then existing file is overwritten. I am testing:The first output is gzipped and the second one not.If I execute the workspace () several times, the .txt file grows but the .txt.gz not. Any suggestions?

I'm having trouble combining contours onto a geotiff raster prior to draping. Can anyone help me to find a process to get the contours onto the Geotiff, preferably with labels on the contours.I've tried the contour generator and a shape file but having real difficulty projecting the contour data onto the raster successfully.

Hi,I had fme desktop 2018 with a fixed license, then i switched to fme desktop 2019 with a floating license, and now i can't open my old fmw files.Once i try to open an old fmw file it gives me an error : File cannot be opened : user may not have sufficient privileges to read the file. (but i still can lunch fme dekstop).Any ideas ?Thank you,Soukaina

Hi, I need to create pdf report(as the attached), would you tell me what transformers that I need to use.the reader is AGOL or sde database. I cannot use HTML2PDFConvertor because we not allow to load WKHTMLTOPDF.exe. thanks a lot 

I have an AutoDesk Recap Mesh file(.rcm extension) is it possible to translate this to an Esri I3S file using FME Desktop?

Hi,I'm relatively new to FME and am coming up against an issue when setting up user parameters that will allow a user to specify an individual geodatabase feature class.I want to allow a user to select a specific feature class from a geodatabase, similar to how you can specify individual feature classes within ArcGIS when using geoprocessing tools. While I can specify which feature classes should be read when reading a geodatabase, when this geodatabase is set up as a user parameter, the user can only specify the input geodatabase and FME will then look for feature classes using the names that I used during creation of the workbench.Also , If I have taken two feature classes from one geodatabase and another from a separate geodatabase, I will only have 2 user parameters available; one for each geodatabase. Ideally, for the user, I would want three user parameters, one for each feature class and for it to not matter if these feature classes are in the same or separate geodatabases.C

I am trying to make an overview of crosssections of infratsructure (a levee). I would like to plot all crosssections in 1 graph in excel. I managed to make 1 excel per cross section, but I would like to plot them a bit like this: This is made in Fme, but has 2 problems for me:- 1: I can't 'turn off' certain cross sections since it's a png (that's why I want to do it in excel)-2: I made an attribute column with cross section number, an x-value (-50 to 50) and a z value. I grouped them per cross section number. This causes the graph lines to go straight back from 50 to -50 on the next profile (the straigh lines). I would prefer not to have those lines.So: how do I get 1 excel graph with all cross sections on top of eachother without the 'return lines'?

Hello,I'm trying to split a CityGML file into multiple OBJ files based on gml_id. For exemple I have a gml_id like this : "BU_69381A"(A to Z)"39" and I want to split at every letter in brackets.Do you have an idea of how to do this?Thank you in advance!

Hello,I used FME Workbench 2017 to generate an IfcSpaces from shape file with footprint polygon and height information. I managed to create space geometry but I could not create longitude and latitude for IfcSite. These values were empty ($). Is there a way to fill theses values with FME Workbench 2009 ? Knowing that today I use a not very powerful method which consist in replacing the text of the end line of IfcSite definition : .ELEMENT.,$,$,$,$,$) by another one with right values : .ELEMENT.,(42,45,2,206849),(0,-25,-12,-380875),0.,$,$) Or perhaps is there a way to write ifc_object_placement for IfcSite which could be another solution to have correct placement ?? Thank you in advance for your help Best regards Bruno

Hi,Soon I will migrate the graphical data (shape and Oracle Spatial) to the ArcGIS feature class on SAP HANA (ArcGIS Pro 2.4). This test migration should be done with FME Desktop Workbenches and the productive migration from FME Server. Question: In case of using FME Desktop Workbenches, must ArcGIS Pro software be installed on the computer or are there workarounds (copy DLL's,...)?Any feedback would be appreciatedThanks and many greetingsEwelina

I have a dynamically generated list called comments as shown below using json templater and sql creator transformers. List contains several objects and I want to generate id for every object as one of the attribute of the same object.I also want to set an attribute called solution as a boolean true or false. But the attribute lies inside the object and cant set its data type. Is there any solution for this? I am transferring the data to Mongodb by creating a json file from sql based data.Capture4.PNG JSON Templater code 2 is -[fme:get-json-list-attribute("_list{}.commentObj")]Here after mearging data from Oracle and Mongodb in Feature mearger, I am creating a json object using first json templater using below code -First JSON Templater code -{"user": {"user":fme:get-attribute("TKT_NOTESUSER"), "username":fme:get-attribute("fullname_notesuser"), "_id":fme:get-attribute("mongodb_id") },&qu

I am having problems writing to I have the following workspace It reads in the following file