Using readers and writers to extract and load data.
Recently active
I have created a custom reprojection to reproject from ETRS89 to London Survey Grid. However this currently only takes care of the x y coordinates. I would like to create a grd file of the ellipsoid to orthometric height adjustments. I have created a grid of points with the height adjustment values but don't know how to get that into a format that CSMapReprojector can use. Alternatively, does someone already have a grd file for ETRS89 to OSGB?
Hi, I have a dataset with features containing three attributes. Each feature contains a text string such as SAINT PATRICK'S CLOSE (see below)or 'stacked' text, which contains carriage return and line feeds such as Saint Patrick's Cathedral (see below).Using the complex example provided by Safe i've created Tags for each attribute. Basically I need to retain the GUID, FORM_ID and FUNC_ID values on each feature in the DGN. When I write out the DGN file, all works perfectly with the liner text string. It retains the GUID etc tags and values. See below.The feature with the stacked text string gets split into five elements - one of each line of text and one for each carriage return/line feed.This would be ok, but none of the five output elements have any tags. I assumed each element would have retained their GUI, FORM_ID and FUNC_ID tags when written, but it seems all tags have been stripped instead. Is there any way to retain the required tags even though my feature get
By clicking "Download List" button, a CSV file can be downloaded from a web portal. I tried to extract the data by using HTTPCaller. However, the url is not in the html and the CSV is generated with JavaScript. Does anyone know how to extract data? Thanks!
I'm trying to visualize a scene using the FME Augmented Reality (AR) writer.As an Input I have a point cloud, and have shifted the origin with Offsetter. I used a PointCloudSurfaceBuilder to get a 3d object in the scene.The resulting model is full of holes, and the color attribute is not preservered, and although crude the model is with holes.I would like to know if some have had more succes and have been able to add the color information to the model?
I have a csv file that is used as configuration for various database schema attributes. Against each layer name there are a a set of fields and a set of values that are valid for the field.I have a workspace that can check if the database contains values that are outside the permissible range:However, this only works for a single row. What I need to do is to loop through the csv file processing each row individually like a recordset.Is this sort of behaviour possible in FME? I have seen some posts on looping but nothing that really fits what I am trying to do.
Hi! I am converting GIS data to GeoJSON files. Currently the GeoJSON files are within the JSON file. Is it possible to separate the JSON file so I can see the GeoJSON files along with the JSON file. Essentially, it would look like the image attached. Thank you for any help!David
I have backup copies of layers in an ArcSDE database, using two digits for the month (01, 02, 03, etc), in order to detect change from the updated versions. Is there a way to have the reader switch to the next month's backup by checking the system date so I only have to press play and not change anything other settings?
Is it possible to create a 3D model from a PDF?
Hello,I am trying to convert a DWG file with 12 separate solids to OBJ or DAE. The conversion is perfect, but the output is 12 separate files - is there a way to convert it into one OBJ file?I have just found another problem I can't resolve - in AutoCAD I have 6 layers, 2 solids in each layer. would it be possible to export each element as a separate object? (they are grouped) I would be grateful for some help ;)best regards
Hi experts,I had went through all the log files generated by the FME server but could not locate a log file that I could identify the following:1. Which user had logged on and hopefully include the duration.2. What had the user done in the server.Are there ways for me to obtain such information?Thanks.
Hi all,I am a FME begginer trying to load data into a Vertica DB.I am using the JDBC Writer to create table and load data. Table creation works perfectly, but then data are not loading, :JDBC Writer: Connected to 'Vertica Database' version '08.01.0001' using driver 'vertica.jar' version '08.01.0107' built against JDBC version '4.0'JDBC Writer: Connection class 'com.vertica.jdbc.VerticaJdbc4ConnectionImpl' is being loaded from '/C:/Program Files/FME/jre/lib/ext/vertica-jdbc-8.1.1-7.jar'JDBC Writer: Committing feature 0JDBC Writer: Creating table using SQL: CREATE TABLE "bi_core_staging"."events" ("Geometry_AreaInSquareMeters" double precision, "SeasonFieldId" integer, "Source_CallerLineNumber" integer, "Context_User__id" integer, "DateTime" timestamp, "EventType_ProtocolVersion" integer, "FieldExtIds__" date, "FieldId" inte
Does anyone have experience modifying a replica or version of a ArcSDE geodatabase in FME? After I make the necessary edits in FME, and write out to a new file geodatabase, Arc no longer recognizes that the newly created geodatabase is a replica to synchronize and reconcile with the original SDE.
Hi, we searching for a way to read or write .vwx VectorWorks Project Files. Is there a way with FME?
I'm trying to join a Shapefile to another table, but it fails.The joining attribute(encoded: utf-8) has value "41400562015" but during the prozessing it becomes "41400562015????????????????????????"I tried to change the attributetype of both fields into different types, including integer or varchar (12) - but the resulting string is still longer than 12 digits?... I also tried to calculate the string (left 12) into a new attribut or to use the trim-funktion. Nothing works?not to be misleading: the original connection attribute on both sides is a textstring like "BT-4209-0001-2018". No blancs.But the joining failed and i detected something like "BT-4209-0001-2018 ___________ " with empty spaces at the endBecause the connection with strings did not work, i changed it into numbers, so joining in FeatureMerger or InlineJoiner should be . (I have done the same connections thousands of times, thes
Hi, I'm wondering if there is a way to reconnect to a (sql server) DB if a connection problem has occurred. Here's our situation: Sometimes, very rarely, we are unable to connect to our SQL Server DB. It may work for 10 days straight, and then it fails one single time and will work again for a unknown timespan. The error message looks like the SQL Server is down (or the connection attempt is corrupted on it's way through our network):2018-03-21 07:01:18| 1.2| 0.0|ERROR |Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155559'. The error message from ArcObjects is: {Failure to access the DBMS server} 2018-03-21 07:01:18| 1.2| 0.0|ERROR |Please ensure the connection parameters are correct (server=`......) 2018-03-21 07:01:18| 1.2| 0.0|ERROR |A fatal error has occurred. Check the logfile above for detailsWe've created a test environment where we run a FME job, which starts and connects to the DB, every single minute and
I have an autocad file with blocks that have rotation angles (flow arrows for example). I need to translate to igds and retatin the angle.
I am looking to use FME to load some data from a file geodatabase into an existing ArcSDE geodatabase feature class. I had done this in an older version of Desktop but can't figure out how to point the writer at an existing featureclass.
I am trying to access the GEOM column from a MSSQL 2012 Database using FME 2017. I have tried with the ADO, JDBC_Nonspatial und Spatial drivers. In table-view the column GEOM is never exposed. Do I have to manually expose the geometry column? If so, how?
Hi, I'm a Master's student using FME Workbench for my thesis project, and I'm using the Cesium 3D Tiles writer to convert CityGML files into Cesium 3D Tilesets. I am curious how the writer determines which features should go into which tiles? The Cesium 3D Tiles spec states that tiles are loaded roughly by distance to the camera; however, when I convert a large CityGML dataset to a 3D Tiles dataset, the writer scatters features over a large geographical area rather than clustering them together based on spatial location. I was also wondering how the writer calculates the bounding volume property of 3D tiles, as the bounding volume shows up as a very large box tilted at an angle. I would appreciate any insight anyone might have on how the 3D Tiles writer determines bounding volumes and how it determines which features are assigned to which tile. Thanks!
I am trying to update fields in a feature class that is attached to a geometric network. The feature class that I am writing to is a point geometry that is attached in the network to one end of a line. The error message is this: Error while updating feature in the table/feature class 'SDE.wServiceConnection'. The error number from ArcObjects is: '-2147217384'. The error message from ArcObjects is: {} I found a possible definition of the error online: (-2147217384) FDO_E_INVALID_CONNECTION_POINT_GEOMETRYThe geometry for a complex junction point is invalid.It appears that the issue is that my workspace errors out when the line length is less that 0.01 foot. I have tested this by finding one that erred out and then lengthening the line and rerunning the workspace with success. While there are only a handful of these in the feature class and they could be manually fixed, this workspace runs as a scheduled task and therein lies the problem. I wouldn't know when it err
I am running a simple read GDB Write GDB and adding a UUID in the process. I am getting this Error (-3). The source is a 3D line file 60K lines long and has four fields. (survey data). I've rerun the script several times and the error halts writing at different locations in the file.
The current way to convert revit files is to generate rvz files through ifc, but this process is very long and often not successful. Before I saw the official plan to do an exporter specifically for revit, but it seems that it has been a year and I wonder if the plugin will be released in the near future. Thank you.
Why does the shape file reader truncate the names attributes to 10 characters on loading / inserting the reader? I have fme version (FME(R) 2018.0.0.1 (20180328 - Build 18295 - WIN64)) installed.
Hi,Can someone please help me load this XLM file to FME?I am new to this tool and trying to convert this XML to Excel.
I'm trying to expose attribute only 'fill-opacity' from the below json.{"type":"FeatureCollection","features":[{"geometry":{"type":"Polygon","coordinates":[[[-81.0007,29.2057],[-81.0055,29.2029],[-81.0105,29.205],[-81.0107,29.2097],[-81.0059,29.2125],[-81.0009,29.2104],[-81.0007,29.2057]]]},"type":"Feature","properties":{"stroke-opacity":0.9,"fill-opacity":0.9,"hail_size_in_int":0.5,"hail_size_in":"0.5-0.9 inches","stroke-width":0,"fill":"#FFFFC0"}}]}It returns blank values. Can someone please help me ?