Using readers and writers to extract and load data.
Recently active
Hello - part 2 of an XML thread. I have a bunch of nodes in an XML document that look like this;<nodes> <node> <properties> <property type="field_name">first_name</property> <property type="field_data">Ben</property> </properties> </node> <node> <properties> <property type="field_name">last_name</property> <property type="field_data">Potts</property> </properties> </node></nodes>And I want to get those out as variables to use down the line in an FME workbench. At the moment I am relying on the order of them in a Test Filter (i.e. If @Value(_attr_name) = nodes.node{0}.properties.property{1} = first_name then put it on an output port of 'first_name') - however I hate relying on the order and I'm sure there is a better way of ge
Hi All,I'm getting a fatal error that I can't figure out the source of.2019-04-12 11:44:31| 1.2| 0.1|FATAL |Precondition failed at stfchainsegmentmodifier.cpp:1093. Expression: prevRealNode_->arcInfo_ != nullptrI think it occurs as the result of either a Geometry Extractor or Snapper transformer I don't understand what it means. Any ideas?Thank you!Katrina
Hello, I am dealing with large LAS file that is output of AgiSoft Photoscan. I need to generate break lines and isohypses. In this question I have seen the potential solution but I think this can't solve both of my needs. I hope I can get some hint. Thank you all in advance,With respect, Dejan
How to set the colour of the linetype of text to be 'by layer' in a DWG? I learned from https://knowledge.safe.com/questions/30155/how-to-set-bylayer-color-in-a-gis-to-cad-transform.html that autocad_color = 256 will set the colour by layer, not by entity (which doesn't make sense, but apparently is the answer, and it does work for me). However, this only works for lines and arcs - for text, the text is still coloured 'by entity'. I am transforming a DWG to a different configuration of DWG (seeing layer names, colour, splitting by an input layer, etc) so no major changes. I just can't figure out how to manipulate this particular item
If using the DGNV8 reader and choosing to Drop Complex Chains/Shapes is there any common attribute between features that originated from the same complex shape?
Greetings for the day, I am working with IfcOpenShell and Python on the extraction of IFC entities. I have developed a Python code which I want to use to extract the structural model from the architectural model. But there is an issue which I am not able to understand and resolve because I am a beginner. When I try to extract the entities which do not contain any entity written in bracket the code runs accurately. for example:- #1=IFCPERSON($,$,'',$,$,$,$,$); #2=IFCORGANIZATION($,'',$,$,$);But the issue occurred when I want to extract the entities with previous entities written in Brackets for example:- #3=IFCPERSONANDORGANIZATION(#1,#2,$);The issue was that when I try to extract the entity for example "IFCPERSONANDORGANIZATION", the code will extract the "IFCPERSON" and "IFCORGANIZATION" twice if I have already extracted these two entities as done in the code given below.Please help me with this issue.
Hi, I hope someone here can help me out.I have ArcGIS Pro Advanced license plus Data Interoperability license.When I was using Pro 2.2, there was no problem. But since I upgraded Pro to 2.3 and Data Interoperability as well, I keep getting FME Desktop License Assistant when I launch Data Interoperability.Has anyone experienced same issue?I really need this tool for my UNME work.Thanks for your attention. Regards,Min
Authentication fails when attempting to connect to ESRI ArcGIS Online feature service writer. After entering organizational credentials for AGOL, the error states "Failed to Obtain Refresh Token: Error retrieving access token". The translation log reads "java.lang.NoSuchFieldError:INSTANCE". I experienced this problem with FME desktop ESRI Edition v2017.0 and after upgrading to 2017.1 the issue still persists.
Hi, I have a Geopackage raster tileset that contains a raster with multiple zoom levels. I want to split this raster into a series of tiles and export each tile as a TIFF file. My first thought was to use the RasterTiler-transformer and simply split the raster tileset into separate tiles based on a specific tile size (e.g. 500 x 500). However, I can't get this to work. When I run the workspace the resulting TIFF-files contain no data (i.e. they are totally blank). I suspect that this has something to do with the multiple zoom levels in the Geopackage raster tileset, but I'm kind of clueless on how to solve it. Does anyone have an idea on how to solve this? Is it possible to split a Geopackage raster tileset into a series of tiles based on multiple zoom levels? Any help will be appreciated.
Hi all,I have some DBF files that need to be converted to something else (MSSQL tables), but have a problem reading these in FME. The dbf files have associated "FPT" files which are memo files.When reading the DBF files in FME, an error arises "DBF Reader: Failed to read memo file record at block number %0. DBF Writer: Error with memo file. Unable to input data from file 'Y:\\Data Transfer\\WATERCOURSES.DBF'. Error in the DBF Reader. Failed to specify the feature index as constraints on the reader.""DBF Reader: Failed to open memo file 'Y:\\Data Transfer\\WATERCOURCES.fpt' for reading"I have then tried to remove the "fpt" file and doing so allows FME to read the DBF. However, there might be some important data in these "fpt" files that we do not want to lose.My question is what is the problem with the "fpt" files and how can it be sorted out in order to get the dbf files read in FME without removing the fpt fil
I'm using the Data Interoperability extension and I'm attempting to read in a csv file that has a column with a string of coordinates in it. I've tried loading it into the Spatial ETL Tool CSV reader, using the coordinate concatenator and then the area builder. I get a rejected feature warning when I try running the tool. Can anyone offer some pointers for this?
For every feature I have a photo. These photos can have different formats, e.g. png or jpg. The photos are on our intranet. I can only download them with a valid Authorization parameter in the request header. I'd like to write the features to an Excel file, including a photo for every row. How should I go about that?I tried following this tutorial, but the ImageFetcher didn't work because of the missing Authorization header parameter (I don't know how to specify the header parameter in ImageFetcher). An HttpCaller does work. I can download the photos to an attribute or file on my local disk. But I don't know how to feed the photos to the Excel-writer. I'd really appreciate your help on this.Willy
Hello,I'm using ExcelToPDFWriter to export Excel files into PDF. It works fine.But my Excel files are huge and many informations are useless (for me). I would like to decide which rows/columns for the sheets I want to export to PDF.Do you have an idea how I could to that? Changing the Python code maybe?Thanks!
I want to create a plugin that will take some data from the small world and send it to another application. How can I get access to the small world database? What kind of problems can I face?
I'm processing a vector data containing 500000 features to a raster data using numeric rasterizer and then writing it in a raster gdb. The conversion of vector to raster happens quickly but writing the raster in to the gdb takes unexpectedly more time. It runs for hours. I'm not sure how can I improve the writing time. Please help!
Hello !Before going deep into this, I would like know : is there a simple way to read a GTFS, then "translate" it into a graph structure, and write the graph into file ? (XML, GraphML, JSON, GraphJSON, other ?) Thanks in advance !
Hi all, I have several PNG-files along with separate georeferenced PGW-files. How can I somehow import those to FME desktop and convert to a format compatible with Google Earth? What I want is to make this map an overlay in Google Earth. I also have the possibility of downloading the maps in in GML (.xml), ESRI shapefile, or Mapinfo MIF/MID. Whatever works best. I just want to import to Google Earth somehow. I'm completely new to map modelling and FME so please give a really simple solution ^^ Thanks, Ruben
Hi, I am trying to create a KML output which extrudes building polgyons and overlays a Flood Map. Unfortunately I cannot get an output with all of the polygons in a uniform color (see attached image), does anyone know how I fix this issue?Thanks,Aaron
Problem:I have a workbench that reads data from a geopackage and writes this to a postgis table. The workbench simply reads data and writes the data with only one attribute. The primary key, called 'fid', should be generated by postgis and not FME so I do not provide a primary key in FME.This postgis table has a column called 'fid' which is the primary and has a not null constraint. It creates the primary by auto incrementing using 'nextval('mytable_fid_seq'::regclass)'. - The workbench used to work, and has stopped working suddenly- other similar workbenches still work on other databasesAn (unwanted) solutionThe only solution that works is to add an SQL Executor before writing the data. However this slows down the progress a lot. The statement is: 'select nextval('treetops_py_fid_seq') as fid'. I'd rather have a different solution.Adding a counter that generates numbers and write these as 'fid' works, until it finds a situa
Hello, anyone having experience writing Trimble JobXML files (.jxl) according to .xsd? Tips, tricks and best practice appreciated?
I have a DWG file with autocad_surfaces.I want to export these to a line, so that I can use it in ArcGIS Pro.How can I convert the features from surfaces to lines in an ArcGIS File Geodatabase using FME 2018?
Can any one explain why FME have recognised the same excel attribute format as x coordinate in FME version 2018
Hello! For an FME Batch process I am working with the Workspace runner. In the two main FME workbenches a conversion from GeoJSON EPSG 4326 to Shapefile EPSG 31256 is made. In the second main workbench there is a conversion in the opposite direction. My question now is the following: In the Workspace that actually runs the two "main" workspaces I am using the Directory and File Pathname Reader. In this reader I defined the folder, where the Input GeoJSON and Shapefiles are stored. (attached you van find a Picture of the Workspace.) This path I connected to the two WorkspaceRunners (1 for GeoJSON and one for the Shapefile Converter. For source (GeoJSON/Shape) I used path_windows). My Problem is that for the process of Shape -> GeoJSON I always get an error '...se_shape_2.shx' lacks the required extension `shp', altough the shx, prj and dbf file belong to the shapefile. Is there ANY way how FME recognizes that these files also belong to the shapefile? Thanks a
For Example:- I am trying to count no of features from multiple feature classes. output is just showing count, however output should be feature class name and then count. Any help is appreciated.
Hi!I want to create a pointcloud in .las based on a .shp file with point geometries. I used the shp-reader -> PointCloudCombiner -> .las writer. The transformer is doing a great job in creating the point cloud but I'm loosing the attribute values when I write the files. In the translation Log you can see: "LAS writer: the following components will be dropped from the point cloud: grid_code, pointid" Why is that? The grid_code has the data typ (float), the pointid (longInt). This link discribes nearly the same problem:https://knowledge.safe.com/questions/53453/how-to-convert-shp-point-geometries-in-to-las-poin.html?childToView=89696#comment-89696 Thanks!!!Sebastian