Using readers and writers to extract and load data.
Recently active
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?
Hello,I have a Microstation drawing with dimensions. However, a part of the dimensions is being converted to a weird output when inspecting it with FME and also when writing it to a PostGIS database.Below is a screenshot of the issue. Does anyone have an idea what is causing this and more importantly, how to fix it? As you can see, only a part of the dimension is displayed in strange characters.The source file does not have these weird characters.If anyone has any idea's or tips, please let me know!Thanks in advance!
Hello,Does anyone know if FME is able to connect directly to an Analysis Services (SSAS) Tabular model. I know it can connect to SQL Server. I also know I can read an excel sheet that is connected to the tabular model, but I would like to connect directly to a tabular model.Thanks,David
I can't seem to write IFC objects that consist of multiple geometries as Multipatch - every time I try, the log says it wrote the correct number of features, but the shp file is empty. The only way I can get the geometries at all is by using the GeometryPartExtractor with Geometry Name = Body; however this separates the grouped items. When I try to use the Aggregator (with unique ID), it joins the parts together, but then I can't write them again! Is this simply not possible?See Screenshot below, I want to write a Multipatch that's grouped like the selection - right now it consists of a separate cylinder and two blocks.
Hi group! I tried to find a way to filter out point cloud points, if they have too big Z difference compared to neighbor points. I couldn't find any transformer, which would do it. I could try using buffering a point, then find the points inside the buffer, then compare the Z with the buffered point and the inside points, but with 70GB of LAS files, I think it's too heavy. Are there any PointCloud related transformers, which could do that? Basically I'm filtering out noise and clouds or errors in Z.
Hi allI've got a simple workspace that's using a generic reader to read an input shapefile or csv file. I've added a csv reader as a workspace resource so that I can set the csv reader parameters and apply them to the generic reader when the input file is csv. Works fine when tested in Desktop. The column names come through as attributes as expected. When I publish the workspace to Cloud and run using the same data, it looks like the workspace resource is ignored, the csv reader parameter settings are not applied and the attribute names come through as col0, col1, col2, etc.My FME versions are:Desktop: FME(R) 2016.1.0.0 (20160419 - Byuild 16492 - WIN32)Cloud: FME Server 2017.0.1.1 - Build 17291 - linux-x64I've attached my test workspace and data.Hopefully someone can test it to either confirm the issue or let me know if I'm doing something wrong.CheersRob
Dear all, I did convert Shape file to citygml but i need to apply the textures to the surface any one help me how to apply the textures.
Hi all, I have a points dataset of planning applications. I also have a large number of environmental datsets as polygons. I have a spreadsheet(excel) with a list of all the polygons. Each layer will recieve a "tick" depending on whetether the point falls within the polygon, ie.yes/no boolean query. Any suggestions much appreciated.