Using readers and writers to extract and load data.
Recently active
Hello Everybody, I have seen some examples to open geodatabase metadata directly in FME using Feature Type Mode (metadata) but I cannot see this in FME 2016 version. I want to open the metadata of a SQL server based feature class/table's in FME and want to export it into our own metadata schema. Please guide me. Thanks
I have an ESRI Feature Class with 4000 records, of staff and the location they are each based at, in a field "Location." So for arguments sake, there are 50 different locations. What I would like to do is symbolise in ArcMap using proportional symbols the number of staff at each location. Is there a way in FME that I can set up the Feature Class to enable me to do this ? So for example, say of the 4000 staff records there are 1000 based in London (simply populated "London" in the "Location" field) then I wish to then symbolise this proportionally (based on that 100 figure), and likewise for other cities too.Thanks
Hi guys,I'm trying some autocad text features formatting. So, I have a number of text features at their insertion coords. I want those to be formatted like they are aligned in some text editor and I want it in DWG output if possible. I have:100 200 390 420 210 333Of course, this is only a sketch. There can be up to 300-400 text feaures at their locations.I want them to be aligned like this:100200390420etc.Possibly in DWG format. If not possible, some other solution that can be copied to DWG is also an option.Thanks in advance.Best regards
HI, i am hoping someone is able to help me.I am building a html output and i am using the fanout expression to build individual html documents. My question is does the fanout expression need to have values from within the html content or can i use attributes from a attribute manager to set the fan out expression?hope that makes sense
I'm using the Cesium 3D Tiles Writer to export some CityGML data to Cesium. Although I can export and interact with entire buildings, I would like to model and interact with buildings as a hierarchy of individual parts (e.g. walls, roofs, etc.). The 3D tiles spec appears to support specifying such relations in the batch table (https://github.com/AnalyticalGraphicsInc/3d-tiles/tree/master/TileFormats/BatchTable#batch-table-hierarchy).I'm looking to achieve something similar to this: https://cesiumjs.org/Cesium/Apps/Sandcastle/index.html?src=3D%20Tiles%20Batch%20Table%20Hierarchy.html&label;=3D%20TilesI've looked and can't find any information on how to write this type of information to the tiles using FME. Does anyone know if this possible using FME? Are there any examples or documentation I could use?
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 rowcount columns with values>0 and store in a column called countfor the values > 0, add them and store in a new column called anim_locreturn the names of the column title that has values greater than zero and store in a column called anim_namesPlease 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/validatorThis 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 mergedVariations tried so far on writer (feature type definition):- all of themMore 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 criteria90 to 100100 to 110110 to 130I 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 the
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
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:maximumL
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
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 - Win32Would greatly appreciate your expert advise on the matter.Thanks in advance! Wilfredo