Data

We have a server running FME Server 2017. Are we able to install ArcGIS server 10.5 on the same machine or is it something that should be avoided? What is the rationale either for or against installing them on the same machine? We are running it on a VMwareWindows Server 2012 R2 with 16GBRam

I'm trying to convert a CSV into separate JSON files, one JSON file for each row. The CSV has about 15 columns and is plain text.I'm hoping for each file to end up with JSON looking like this. { "type" : "kb", "id" : "1", "data" : "xyz" } But instead, the JSON data is embedded in an array. In my case, I need each file to not have the array or the files won't import successfully to ElasticSearch.Here is how the JSON is coming across.[ { "type" : "kb", "id" : "1", "data" : "xyz" } ]My ConfigurationI've tried this multiple ways but the latest attempt is very simple. A CSV Reader reads the CSV file and then connects to a JSON Writer. The JSON Writer has the "Fanout Dataset" checked and the Fanout Expression is "@Value(id)" which is a column in my CSV that I want the files named after. One thing to note is that the files wer

I have an Excel Table with two columns as shown in the picture below. Additionally I have a bunch of features which holds an attribute named INFOTEXT. I would like to compare this attribute of each feature with the SOURCE-column of the Excel. If the string of INFOTEXT and SOURCE is equal I would like to add a new attribute with the content of DESTINATION column on the same row. Is this possible with FME?

Hi,I'm exporting numbers to an EXCEL template. When I open the file in Excel some cells are marked with a green triangle and the following information is displayed: "The number in this cell is formatted as text or is preceded by an apostrophe".This only happens to those cells for which I perform a division in FME. Other cells where I only have numbers or sums are not affected.The problem also occurs if the template is just an empty Excel file.Any idea how to avoid this? Is there any setting in Excel writer or do I need re-format those numbers before they are written? I tried already to explicitly convert the numbers beforehand (@double(<float>)) but to no avail,Thanks, Rob 

Not able to read GDB database file..Database file link - http://fargo.nserl.purdue.edu/RUSLE2_ftp/NRCS_Base_Database/Latest%20Base%20Database%20and%20Updates/Database file name - BASE_NRCS_MOSES_03302016.zipActually my objective is just to read gdb file and transfer its data to postgres database.

Hello, I have DWG file and I was wondering if I can somehow transform it to a GeoTIFF or just TIFF? Thank You in advance

We want to use FME server in order to copie/backup files , Application , database and store it in safe area , at the oment the task is done manualy , each time system admin will have to go trough all those files , and backup the to the specific location

I used the reader ( directory and path file name ) and writer ( file copy ) to move all file from folder A to folder B, is there a way we could move also the subfolder in A to B and keep, instead of creating a reader for each subfolderis it possible to write it a zip file all this is used to backup dataThanks

Hello,I am looking for an easy way to get the user select the tables that they want to read and translate before the workspace runs. Is there an easy way to set this up using FME transformers or it has to be done resorting to other methods (i.e python scripting with specific postgis drivers) and if so, could I get some help on how to accomplish this?At the moment I have a creator, an SQL executor that extracts all tables from the schema I want the tables to be selected from, how can I convert this list into a parameter and then let the user select the tables they want to be then submitted to the PostGIS (or generic reader maybe) to then work with only that subset of tables?

I am trying to convert Excel file to KML. There is a column RPN# with the project number like RPN-123456 and also hyperlink embedded in it that opens local folder on the server. I have done this before with AutocAD file but I am having issues exposing attribute in Excel file. I attached pictures of the workflow. When I run translation I do not see RPN# in KML file, what am I missing here. Instead the dot representing RPN# shows generic kml_1 or something like that.Thank you very much.

I'm pretty new to FME and could really use some help on this. I am reading OBJ files and writing DWG files. I need to expose two "traits" in the source OBJ to re-use them in the target DWG. But I'm unclear how to access the traits.What I found so far... The two traits in the OBJ file belong to Geometry Type: IFMEMesh. The traits are GeometryTrait(string): 'obj_group' and 'obj_object'.My goal is to read the obj_group to write autocad_layer_name - and read the obj_object to write autocad_block_name. Guidance on accessing the traits will be greatly appreciated! And here's an example OBJ file:

Folks,This may or may not be an FME question so anyone with AutoCAD skills may be able to point me in the right direction.I'm writing Mapinfo to AutoCAD and one of the objects is a polyline. The specified requirement is to set he polyline Format Attribute start_autocad_width and end_autocad_width to a value of 0.25.I have achieved this.However the result in cad is poor. Some polylines show with a width, some polylines show some segments with width. Upon inspection the Autocad object property "Global width" is null. If this is set to 0.25 the issues noted above are resolved.However the "global_autocad_width" is not an available format attribute.I did read this may be a DWG template drawing variable PLINEWID but setting this has zero effect. Any thoughts?

Hi all,I have read that the Excel writer supports colors for font and background.What I can not find is how.I have this scenario:Based on the value of an attribute ("Yes" or "No") I want to color the font (or background) black (if "Yes") and red (if "No").I would use the Conditional Values in the AttributeCreator, but can not find what to set for the color.Is this possible, and if Yes how.Any help is appreciated.Erik Jan

I want my workbench to automatically create a value in an attribute table depending on the type of polygon it is. For example, if the value in autocad_layer is KVARTERSM_CENTRUM, I want it to automatically classify the attribute as "KC".I have multiple attributes I want to automatically classify. The problem is that when I'm searching for transformers and choosing a layer, only "autocad_layer" is available. Reader must be based on single merged feature type. I attach an image with my workbench. The first choice I made is that I chose the reader dwg and single merger feature type. I will add an image with my choices in parameters. I also have added "autocad_layer" in the "feature attributes"In areabuilder have chosen to use "autocad_layer" in the "group by" option. The rest I have not made any choices in. Then I create writer OGC geopackage and select "feature option: insert", "table action: create if needed&

Hi,I am writing arc element in ESRI shape file (Polygon type) from ESRI ArcSDE . But the writer stroke the arc and rendering as line string. I am using FME 2015.1.2.1 and even tried in FME 2017 also. Kindly let me know how to resolve it?Same thing I tried to write in Microstation DGN writer, it is converted as Arc as expected.ThanksK.Jayakumar

Hi, Can someone advise whether this is possible? Im looking to use Excel to edit an xml file and want to use FME to perform the exchange. I can see an xml reader and writer to excel, but cant work out the return. Am I hoping for too much?Xml file below

Hello,i've got this XML schema and i want thisPRENOMNOMEMAILtest prenomtest nomtestemail.comi've tried lots of thing s with XML flattener but nothing succeed.can you help meThx

Hi,I have a Problem placing shared cells in a V8 DGN.The Cell i'm trying to place has different x- and y-scale and is rotated.I used the DGNStyler to define the settings.The result in MicroStation is shown below:On the left you see the Library Cell and that's how the Cell should look like. It was written with the same Settings in DGNStyler except Cell Mode.On the right you see the Shared Cell which Scale and Rotation is wrongSo the Library Cell is placed correct, but i have to place Shared CellsCan anybody help me ?

I have A csv file with more 10000000 records how can split into 5 smaller csv file (each with + o- 2000000 refcords) to performafter my actions ?

am learning FME Workbench/ Data Inspector etc. But exactly I have a question, which I could use some help. My question is: I am working with a GML file. It has uploaded in FME Data Inspector. From this file, which includes BRepSolid 3D objects, I would like to get the exact heights (as an feature). Than I want to save this data as a shapefile/geojson or something which I can than use in Qgis. Untill now I have not had any succes. Can you give me some tips or links to tutorial(s) to learn this? Topics: heights / .gml file / into writer (for example shapefile)

Anyone have some tips working with FME moving detailed buildingdata to and from 3D Studio Max?https://www.autodesk.com/products/3ds-max/overview

When I enter $(user_parameter) as user attribute name, it will be replaced to $_user_parameter_

Is there a reader for PDF documents?  I would like to be able to use FME to batch convert a number of PDF documents into another image format, like JPEG, so that I can georeference the content.

Hello!  Writing to an Oracle Spatial Database I get following error:  Oracle Writer: Abnormal channel cleanup required, likely due to previous error  What could be the problem?   Thanks for your help, regards  Isabell

Hi GuysI am looking for a workflow to Create SHP file attributes from an excel spreadsheet. The problem I am having, is I can only see a way to extract column headings as Attributes. How do I take attribute titles from the cells below the column heading. I hope that makes sense....Basically, I have an Excel document with Standard Asset data that needs to be included in our SHP files according to discipline. So I have used FME to Test for "Subclass" & "Item_Name", which works great, then I want to extract that list in the "Attribute_name" column to SHP attributes.ThanksMartin