Data

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

I was wondering if there was further documentation on the FME server database. I'm looking to create a REST service from the database that we can use in conjunction with Operations Dashboard to show statistics about FME server in real-time (specifically things such as last time a job was ran, the status of the job, errors from the job (if any), run time, etc). Currently I'm harvesting data nightly to get a summary of the performance over the day, but it would be nice to be able to create a rest service that would show all the data together without having to heavily use an FME engine to push data to ArcGIS Enterprise (Portal) or ArcGIS Online.

I have a large GML dataset (200.000 features) In FME Desktop (build 19630) it runs great in a FeatureReader set up for GML (both ignore application schema yes and no) but in FME Server it stops after the 1034th feature with a message that it has an unexpected end of input (for both ignore application schema yes and no).I did notice the XSD that is provided had too a short a field for certain values (but shouldnt matter for ignore application schema = yes)https://www.aerius.nl/files/ftp_upload/habitatkartering.gmlThen if I run a generated workspace from GML2GML in FME Desktop and ignore the schema the resulting GML will end in FME Server (build 19630) with an unexected end of tag.Bug or I'm missing something? FME Server and GML haven't proven me yet  

Hello,I'm trying to set the ground and all the building to 0 elevation in my CityGML and keep the buildings in 3d.Do you have any idea how could I do that?

I have an Excel file which has the header on the 3rd row. The first and second rows have additional information. My actual data values start from row 4. Is there any way in FME to remove the first two rows and use the 3rd row for attribute names? I have attached my example file.Thanks in advance.

Hello,I try to migrate a dataset from MSSQL_JDBC_Spatial into the writer GDB.The writer GDB is GDB with imported XML Workspace Dokument-only Schema from Dataset SSQL_JDBC_Spatial (created in ARcGIS).In reader I have got feature classes, attachments and relationships.During the running of Relationship classes, I´ve become an error. Somebody any Idea?Thanks

Hi, I'm converting a file from XML to GeoJSON. The conversion goes fine, but I want the coordinates to be in a line ("geometry":{"type":"LineString"...). I'm somewhat new to FME Workbench and can't figure out how to do it in the conversion, is it possible? 

Can I not "zoom to selected feature" in the workbench?

Hello, I was wondering if there is any way I can save a report from SQL Reporting Service into a shapefile? This lit building report has lat/lon and If I can grab from one of the formats it exports and then convert to a point shapefile, that would be my end goal. I have tried saving the excel using HTTPCaller to a folder then writing that to shapefile, but it has not been able to get the file. Is there another way that I should be going about this if it is possible? I would most likely not be able to get access to the backend database due to IT Assurance.

Hi, so my FME 2017.1 (32 or 64 bit) crashes when trying to save workspace. Bizarre, right. Anyway, here are some pics for info. Hopefully this will help. I can't post workspace since it crashes.   Cheers,Zelimir

I noticed some strange behaviour while exporting some simple data to shapefile: when using the "tech preview" (writer of featurewriter) my attribute name and values are trimmed to one character...I've read this format is still under active development, but as i couldn't find it as a known issue: is this a bug or am i doing something wrong? expected output (using the 'classic' shapefilewriters): tech preview output: using FME(R) 2019.1.3.0 (20191007 - Build 19642 - WIN64)example workbench:

Hi everyone,im trying to set the color of an ifcProxy object. (see workspace below an attached) (input: )i had a look at the following question:https://knowledge.safe.com/questions/71502/how-to-set-the-color-of-an-ifc-object.htmlbut the implementation for an ifcProxy object doesn't work!--> there is no line with "IFCSURFACESTYLERENDERING" in the exported file, which should exist to apply a color to an object. how to define the color of an ifcProxy element? Best regards 

I'm trying to bring a geotiff into an Azure sql spatial database and it only seems to give me a polygon. Any thoughts.

I'm using the Smallworld Edition of FME 2018.1 and trying to read in data from Smallworld v5.2.1 but it isn't working. It reads 5.1.9 fine. How can it get it to work?

Hello Forum,I want to use a shareable link from my Google Drive, that I want to integrate into my Workbench, because I'm planning to share my FMW with other people. My link refers to a folder containing data.I don't want to share with others my account connection informations though.I'm looking at the GoogleDriveConnector and I don't see a way to download files from a shareable link.Then I thought about the HTTPCaller, but I can't figure how neither.Is it possible to do that? If not, what option do I have? AWS, Azure, Dropbox, I'll probably have the same issue?Thanks! 

Hi Folks,Is there a confirmed release date for 2019.2?I understand that this version support ArcGIS Pro 2.4 Python.Kind regardsSteve

I currently have an excel containing a few hundreds of addresses and information, which needs to be put into multiple PDFs. Each PDF need to contain an introduction letter and a map. This map is generated in ArcMap and exported as png. The excel contains a path reference to a folder where all the png's are stored. So, each excel value (letter) has it's unique png.I'm trying to create a PDF page for each png, for this I am using the pdf_page_formatter. I succeeded in generating a page for each map (by using pdf_page_number). However, the png will not show-up in the PDF. Is there a way that FME will load the png in the PDF, using only a path reference?For example: C:\\Temp\\output\\105899887_RDK02K4525.png