Data

I am just one week into FME (a friend recommended it to me) I want to loop through a 761,000 rows by 25 columns excel document, for the each row count columns with values>0 and store in a column called count for the values > 0, add them and store in a new column called anim_loc return the names of the column title that has values greater than zero and store in a column called anim_names Please how can i achieve these with FME.

Good morning. This week has been released the new INSPIRE validator: http://inspire-sandbox.jrc.ec.europa.eu/validator This tool allows you to validate a GML file. I have several GML that I got using the INSPIRE GML writer in FME. To validate them, I just checked them against the XSD provided by INSPIRE. That validation was always OK. But with the new validator I'm getting this error: cvc-elt.1.a: Cannot find the declaration of element 'gml:FeatureCollection'. I have attached a sample of my GML. There is a FeatureCollection tag... Does anyone know if I have to change something of the INSPIRE GML writer to build a proper FeatureCollection? Thanks!

My workflow is pretty easy, I drag and drop a CityGML file in the workbench and then add a CityGML writer and connect it. FME proudly tells me it wrote features, but when I open the file there's no geometry. Do I have to add a bunch of transformers? Variations tried on reader: - all features - single merged Variations tried so far on writer (feature type definition): - all of them More info: - the source CityGML file is fine and displays without errors in the inspector - no errors are reported during the translation

Hi Team, I have a simple example attached and it contain just a Reader and i would like to generate another shapefile. The problem is: the Writer ( using the transformer FeatureWriter ) needs contain one Attribute: @Value(De_Produto) I tested to get the value from the source attribute De_Produto configurating the Writer, but without success: How can i get the value attribute and transform the value this attribute as Attribute Name my Writer? Thanks in Advance, Danilo

I have a shapefile that I need to convert to JPG. The shape file has an attribute with values ranging form 90 to 130. I need to give different colors for this attributes in JPG based on the following criteria 90 to 100 100 to 110 110 to 130 I tried using image rasteriser, it shows "This format cannot support more than 3 bands. Please remove the extra bands and try again" I am new to FME so please explain it even if its a trivial question

Folks, I've been converting Mapinfo to AutoCAD and largely successful. I have a fully defined template drawing I need to adhere to so I have almost no flexibility. I have successfully labeled lines with an attribute. However I'm tasked with the requirment to repeat a label at some defined interval along the length of a very long line. Is there a convenient way to have a repeating label text along a line with a "distance" parameter?

I am currently looking for a solution to change my data set (Excel) into multiple Excel files using a template file. Each file(or tab) should contain information about one tree. The data set contains data about 250 trees (ID, name, year planted, height, LAI and photolink number). I made an excel file with a nice format that looks something like this: Tree research information fact sheet:Name:Year:Age:an Excel formula generating the current ageHeight (m):LAI: I'm currently using a template file and know how to format the data to the correct font type but can not find how you add the information for attribute to write to the the specific cell. Tree 1 Tree research information fact sheet:Name:Quercus roburYear:1942Age:an Excel formula generating the current ageHeight (m):15LAI:3and so on for all the other 249 records. Short question: How can i write the information of one record to specific cells in Excel so that it fits in my format.

I have a TIFF file I am converting from 32Real to JP2 16Uint. The TIFF has NoData = -9999. I run a RasterCellValueReplacer to change -9999 to 0 and set NoData to Yes. Next is the RasterBandInterpretationCoercer to make it a 16UInt. When run, the JP2 has edge chatter with pixel values that were NoData now having values from 1 to 10. What is causing this edge chatter and how do I remove it?

My source data is the multipatch model data in ESRI File GDB format, I use FME to convert it to Cesium 3d tiles one by one, everything is good, but the generated b3dm no attributes, how can I solve??if i don't convert it totally?the b3dm file contains attributes,but the models are not Seperated?

hi, i installed the fme server version 2017.01 in Ubuntu 16.04, the server can start, and I can access the system from localhost:80?but when i run the fme server console in Clients/FMEServerConsole?i got the errror "error while loading shared libraries, libboost_filesystem-fme.so.1.58.0: cannot open shared project file: No such file or directory", i have not got any satisfied answers from google, anyone can help? thanks.

Hi all, I'm currently having some trouble updating a file geodatabase. I have a workspace that uses a regex to create individual feature classes in a file geodatabase. I have set the 'Feature Class or Table Name' in the writer to: @ReplaceRegEx(@Value(Actual_URL),^.+/(.+?)\.zip$,\1) It works fine on the first run but when I try to run the workspace a second time with 'Overwrite Existing Geodatabase: Yes' it gives me the following error: "Unable to connect to the File Geodatabase at 'C:\Test.gdb'. Make sure the correct filename was specified, and that the geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-2147024894'. The error message from ArcObjects is: {}A fatal error has occurred. Check the logfile above for details" From what I've read here it may be because the overwrite relies on the spatial indexing from the original file geodatabase. Perhaps there is a workaround where I can set the workspace to delete

I am trying to convert shp file to cityGML. In shapefile I have building footprints with attributes "storey" as number of storeys. I want to match this attribute to number of storeys attributes of cityGML buildings class. How can I make this?

With great help from the folks here I've started being productive in writing Mapinfo tables to DWG. However I've run into a problem writing text. I have a number of layers that need to have labels applied. One is a polygon layer. The goal is to write a piece of text in the centroid. To achieve this I've used a LabelPointReplacer to get the something like the centroid. From here it gets bit weird. For the life of me I cannot get the labels to orient with zero(0) rotation. Initially the label wanted to align with the first vector in the polygon so that was understandable. I tried to overcome this by using a DWGStyler but this seems to have no effect. My suspicion is that my source tables are Lat\\Long and the CAD is GRID projected. However there must be a way to set the rotation to CAD zero. Any assistance appreciated.

Hi everyone, I wonder if there is a possibility to figure out the drawing order of features within an AutoCAD-Layer. I haven't found any format-attributes about that. kind regards, Thomas

Folks, Seems I've picked the right tool for the job and probably the hardest forms of data conversion first time out. I've managed to get an acceptable result for Mapinfo to GML after help form here and SAFE support. Now I need a CAD output. I'm super familiar with both MI and CAD having worked with both for over 25 years. However getting started with a highly constrained conversion that I personally won't be performing is presenting me with challenges. The first problem I've run into is the mapping the MI object to the relevant layers in CAD. My naive expectation was pointing the CAD writer to my DWT would expose all the CAD layers available and I could start pointing Mapinfo tables at the destination layers. This doesn't seem to be the case. I looked at the DWGStyler but this looks like I need to configure each and every layer parameter which again seems to allow me to configure layers styles that would conflict with the layer settings in the DWT. The last part is more of a question

Hello, I am trying to read AIXM 5.1 using FME. I am using the Hungary eAIP data sample (https://code.google.com/p/openaviationmap/wiki/Downloads) When I try to read or translate some of the airspaces that are defined by gml:CircleByCenterPoint, FME ignores units of measure for the radius and always takes the radius in degrees of lat/long - ergo if my center point has lat 10°, long 10° and radius 10, FME generates a circle that touches the 0°and 20°meridians and 0°and 20° parallels. Any idea what might be wrong with setting the units of measure? Can it also have something to do with the coordinate system set in srsName of the surface? Thanks for any replies Example: <aixm:theAirspaceVolume> <aixm:AirspaceVolume> <aixm:upperLimit uom="FT">4000.0</aixm:upperLimit> <aixm:upperLimitReference>MSL</aixm:upperLimitReference> <aixm:maximumLimit xsi:nil="true"/> <aixm:maximumLimitReference xsi:nil="true"/> <aixm:lowerLimit uom="FT">0.0</aixm:lowerLimit> <aixm:lowerLimitReference>SFC</aixm:lowerL

Hi, I have what I thought would be a simple FME process to read from an SDE table and change one value depending on an existing field in the same table. The process is 'IF FIELD1 = 10 THEN FIELD 2 = 2' as an example. The table is in a relationship but that shouldn't really need to be involved as this update is all in one table. When trying to write back to the table I receive the below error: "Attempting to write a non-relationship feature to relationship class. Ensure the 'geodb_type' is set to a valid relationship class type" I have tried setting the 'Ignore Relationship Info' parameter on the reader but this still comes up with the same error. I have read the information here but I wouldn't have thought adding these fields was required to simply update one field in a table. If anyone can share some information that would be greatly appreciated. When I initially created the workbench a couple of weeks ago this ran when testing so I'm not sure what has changed with the geodatabase set

I have a feature class stored in an ArcSDE database which is edited by a couple of users via a web application. I want to push this information to a separate postGIS database. It’s important that the new/edited/deleted objects are pushed to the postGIS as quick as possible. So, I’m wondering if it’s possible to do this via FME Server? Are there any features/tools for “listening” to a database, and execute a small workspace each time the database is edited (or something similar)?

Hi, I encountered this error message in FME: "An error occurred while attempting to open the table, feature class or relationship class. The error number from ArcObjects is: '-2147024809'. The error message from ArcObjects is: {Invalid function arguments} A fatal error has occurred. Check the logfile above for details" I'm using FME Desktop 2016.1.0.0 (20160419 - Build 16492 - Win32 Would greatly appreciate your expert advise on the matter. Thanks in advance! Wilfredo

In FME Desktop I have a workspace that downloads a file from Autodesk A360, processes the file and then uploads the result to A360. This process is tested and works fine. When I upload the workspace to FME Server I also upload the web connection. I get a warning that I need to re-authorize the web connection on FME Server. When I try to do that, I get a message that the connection is not authorized. How do I re-authorize the web connection for Autodesk A360? Any help is appreciated.

Hello. I am exploring options for converting Revit data to ArcGIS. Does FME Desktop have this functionality? -Thank you

I have multiple shapefiles in different windows submaps and I want to union them to one dwg file. I tried Workspacerunner but without success. Is there another solution?

I have an automated process which reads/writes data every 15 minutes to an ArcGIS Online feature service. It runs successfully most of the time but is fails periodically (not on any schedule). The failure message is: ArcGIS Online Feature Service Reader: SSL certificate verification failed for host 'www.arcgis.com'. HTTPS connections may not be secure. Disabling verification of SSL certificates. Message: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:590) ArcGIS Online Feature Service Reader: The server at 'https://www.arcgis.com/' does not appear to be an ArcGIS Portal instance. Verify that the host is a valid ArcGIS Portal Has anyone experienced this before?