Using readers and writers to extract and load data.
Recently active
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
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 PortalHas anyone experienced this before?
Is it possible to convert shape file to topojson? I didn't see this format in options, but perhaps it is possible to customize in a way?
I'm new to FME and what I'm trying to do with it, is to (semi)automate a process of combining GeoJSON with a PNG background map (12000x12000 px map tile of the area, with pgw file).Right now I'm doing this process manually with QGIS, and it works, but is a little time consuming.I've already managed to read the GeoJSON and PNG with separate readers into the FME Workbench. I've added PDFPageFormatter in between and then a PDF 2D writer. Obiously the output is just the background map as a whole and the GeoJSON data somewhere in the middle.So what I'd like to get some help with, would be:a) How to crop the output PDF to cover just the area surrounding the GeoJSON and not the whole background map? I've tried this with Clipper transformer, but everytime the whole background map was lost in the process.b) The GeoJSON data contains basically lines and points with different "objecttype" attributes. I'd like to find a way to customize those, lines with
I have a raster surface which I first converted into a TIN. Then I extruded the TIN triangles downward to get 3D objects. Afterwards I used the SolidBuilder to turn them into solids. Now I want to save these as IFC, but the IFC file always ends up empty. I guess I have to define some types, but I don't know where to start. The SolidBuilder only has _is_void as attribute.
Hello,I would like to fanout CityGML-files depending on an attribute. As far as I know, I can use the dataset fanout. On CityGML-data it creates a subfolder and a CityGML-file in it, which have both the same name. The featuretype-fanout won't work (I guess), because I have to define roofsurfaces, wallsurfaces etc. there. So is there a way to fanout CityGML without subfolders having all files in one outputfolder at the end?
Hi, when I try to send sting attibute with UTF-16 encoded string, MYSQL_DB writer shows the warning:"Skipped writing of 1 features due to unmatched non-insert writer type mode when the writer was in insert (only) mode"Is it possible that MYSQL_DB does not convert UTF-18 string into own types?