Using readers and writers to extract and load data.
Recently active
Hi everyone, I'm trying to read WFS Datas. In order to have a smaller flow, I use a XML Filter. If I read just one Feature Type, it is OK, I get all its features.But I just ask for two Feature Type, I get no features and the following message :Here is the XML Filter I use :<Filter xmlns="http://www.opengis.net/fes/2.0"><PropertyIsEqualTo><ValueReference>WM_VERSION</ValueReference><Literal>0</Literal></PropertyIsEqualTo></Filter>Is there something wrong with it ?I could get a WFS Reader with its XML Filter per Feature Type, but it will be boring ;o)Many thanks if you can help me !
Hi,We 100+ years of rainfall data that we would like to find 3 consecutive days where the rainfall is greater than 50mm after a certain date. I can do this in Excel but I can't for the life of my figure out how to do it in FME. Does anyone know if it is possible?In excel adding three consectutive days rainfall is pretty simple =SUM(F2:F4) and fill down the column.Cheers,Dale
I was wondering what workflows people use with FME workbench to take a classified point cloud and transform it into a DEM with contours, DSM, and DTM.I'm working with a dataset that has around 30Million points with low,med,and high vegetation. This objective is to take all the vegetation, transmission line, and transmission tower and display it as a 3D surface onto Google Earth.
Hi,I want to use Scheme(Anyformat) for reading WFS structure, it is working fine for excel, csv,shapefile, FileGeodatabase and even ESRI FeatureService but not WFS.I want to use generic reader, so I have to use this reader for all of them and I know FeatureReader can read WFS without issue.Has anyone had this problem ? Any solution ?Regards
Hi,I am using FME 2015 version.I am developing a web service application to read data from ArcSDE database using 'GEODATABASE_SDE' reader. While reading the feature from the reader, it throws an exception as 'No definition was found for coordinate system 'ESRI(ESRI)'. The log file information is shown in the attached image: But, I tested the same code in windows forms application and it is working fine. It finds the matching projection and read the data successfully. Its log file information is shown in the attached image: Kindly clarify how to resolve this issue. Thanks Sivakumar
I was interested to see the new PowerPoint writer and transformer for FME 2018, but I cannot find any documentation on these items. Is there any?
Hello, Does anyone know how to read mesh objects from a dgn? I need to create solids from these features, but the meshes all seem to come in as 2d lines, nowhere near the rest of the 3d lines where they should be extruded. Would be grateful for any assistance with this! Thanks, Owen
Hi, I would like to create a workflow to download and merge vector data from a WFS. The city of Vienna provides building footprints in shape format via WFS. Due to the large filesize it is recommended to reduce one download to a tile of 2x2 kilometers or smaller. As I need the complete dataset I try to create a workspace to download all tiles with getfeature requests (e.g. https://data.wien.gv.at/daten/geo?service=WFS&version;=1.0.0&request;=GetFeature&typeName;=ogdwien:FMZKGEBOGD&outputFormat;=shape-zip&SRS;=EPSG:31256&BBOX;=2748,341794,4516,343209) and then merge the tiles into a File GDB. Is it possible to dynamically create the request by inserting the necessary bounding box coordinates and then merge data directly out of a ZIP file. Thanks for any help.
I have multiple csv files that i need to combine. Table structure looks like below. I want the output to look like Table 3 and 4. I have tried to used to the columns to rows transpose but the input tables are not fixed and can change with new lines added etc, so not exactly sure how to do thisTable 1LineAtt1Att21X 502X 493X 334X 895X 906X 45Table 2LineAtt1Att21Y 232Y 143Y 514Y 785Y 346Y 78Table 3Line123456Att1 (Table1)XXXXXXAtt1 (Table2)YYYYYYTable 4Line123456Att2(Table1)504933899045Att2(Table2)231451783478@takashi
I am creating xyz files from a DEM Raster using the RasterCellCoercer to create a point feature containing heights from the DEM. I am writing first into an ESRI geodatabase, and then using the coordinate extractor to write X,Y,Z fields to a CSV file then renaming it to *.xyz.Is there maybe a more straight forward way of doing this? Could I cut out the ESRI Geodatabase and write directly from the RasterCellCoercer into a xyz?
I have two files in a common directory with the following naming scheme{Know prefix}_{variable suffix} {Know prefix}_{known infix}_{variable suffix}ex. ABC_123 ABC_XYZ_123Is there an easy way to read in only the file without the infix? The standard wildcard {prefix}* will pick up both files. Currently I'm testing the fme feature type to see whether or not it contains the infix, but ideally I would like to not even read it in.
Hello,I am unable to read attachments from my hosted feature service on Portal, using the Esri ArcGIS Portal Feature Service Reader. If I set "Include Attachments" to no, I am able to read the hosted data without attachments, but when I set "Include Attachments" to yes, my translation fails, and I get the following error:Here are the reader parameters used when the workspace fails:Does anyone have any ideas on why this isn't working? I have attached the full log file (run with debugging turned on) in case that helps.Thank you,Courtney
Hello, I am trying to make a Shape file from my DWG. I am trying to use only one layer from DWG because that is all I need. Basically I am trying to close all the polygons in that layer, and calculate their area and to write their area in shp. I am not getting a good result and I have no idea what could be the problem.Also, I was wondering if I can get a result written in form of "P= "number" m2". Now I am getting this from screen shot.
HelloI write solids to KML and want to give the borderlines/wireframe of the solid a different color/alpha in order to get better visibility of the solid.I try KMLStyler with Color 0,0,0 (black) and Opacity 1 and Fill Color set to red and Fill Opacity set to 0.7.I don't see any effect however. There is no wireframe visible, like I used to get it years ago with the first version of KML writer ...Any hints what maybe wrong ?Seems like I need to duplicate the wireframe as independent feature ...
Hello, I am trying to make a raster from two SHP files. It is a bit specific so I would like to ask you if maybe somebody has any good idea what is the best idea how to solve this. I am having two input Shape files that have multiple attributes. In one file, I first want to take only two classes from one attribute (ROADS: Motorway and Residential) and give them specific thickness, all the others can be normal width. (I was wondering if the best way to solve it is Tester ---> AttributeCreator).After that, I would like to prepare that for printing. Best way would probably be transforming it to raster. (MapnikRasterizer???) I would need to specify the window that I want to be printed and I know that it can be done with MapnikRasterizer. I am looking forward to all good ideas and suggestions how to solve this.Thank you all in advance!
Here's a tricky one. We're using an excel marcro-enabled (xlsm) file as a template and in the script we're populating it with various info from textfiles and more. When we try to open the resulting Excel file with Excel (2016) the file doesn't open. We're getting an error message saying there's something wrong with the file and would you like to try to fix the errors? The offered fix isn't good enough. I'm thinking this might have to do with the xlsm-format or maybe it's a language issue. We've had help from SAFE resaving the file and then this would sometimes remedy the situation. Anyways, this is just to check if anybody has encountered the same problem and have any ideas as to what in the excel template can cause this error. We have macros in the file and from what I can gather no other strange things.Thankful for any suggestions.
I am trying to go from an IFC fil to cityGML in accordance with the BIM to GIS (Basic) | IFC LOD 100 to LOD 2 CityGML tutorial. I am currently tying to replicate all the 4 steps within my own workspace with my own readers. However in step 3 "Set Attributes and traits" my AttributeCreator doesn't work and I find the tutorial lacking in showing how to set it up.So how do i setup my transformers in step3?Both the AttributeCreator and the GeometryPropertySetter
When I use an attribute value in SVG Writer "Feature Type Name", it seems that layer style attribute doesn´t work. The layer style custom value doesn´t appear in inner SVG <g>. Futhermore, allow an attribute value in layer style attribute would be fine (now only a text string).
I have created a workbench that transforms DGN cells to AutoCAD blocks. In this process I am trying to set a feature to the defpoints layer but when I aggregate to a block it puts all features on 0. Is there a way to keep that defpoints layer when aggregating?
Hi!I need help. No matter how I try, it does not read the files contained inside different subfolders. I was told to set the path so in the Dataset appears like this: <pathname>\\**and replace the pathname with mine. I have 2 readers combined together, and excel sheet and the subfolders inside a main folder. I have set it so there is an error report in the end and it keeps on telling me, that the files are not inside the subfolders. The files formats are different: pdf, dwg, etc..Thanks for your help in advance!!
When I use FME Quick Translator to convert CityGML file to IMX, I get this error. How can I fix it?
Could someone recommend the best transformer for converting 2 point clouds to a geotiffs so that they can be compared for differences in elevations? Also what is recommended to use as a surface tolerance and output dem x and y spacings using the Rasterdemgenerator? I have two point clouds representing 2 different years. I would like to compare any differences in elevations by calculating the difference in elevations. The area is very flat and differences can be less than 1m. Any guidance appreciated. thanks
Hi all the data in the column looks like its in a binary format but everything i try fails, please help. Here is an example of a record. 30303130010000000700000075B5157B9CB80F4187EB51B8CEEA08414282E24755B90F41EE51B81ED9EA0841D36F5F477DB90F41EE51B81ED9EA084132772DE1C6B90F41808CB9EBD9EA084132772DE1C6B90F41F6FDD4B882EA0841E27A14AE9BB80F41AB13D0847FEA084175B5157B9CB80F4187EB51B8CEEA08410000000000
hello all,i have created some customer parameters in Revit and would like to expose them in FME as attributei have tried to use the Revit read as it does expose more attributes then the IFC reader, but it still only shows the default Revit parameters, i am sure AttrivuteExposer or GeometryPropertyExtractor would do the trick, but i am really strugging to expose the data. any help with this would be greatcheers,James
I want to create LOD2 objects from LAS file. As input i only have 2D buildings as polygons, representing boundary of building, with no roof-ridges or other roof details, only polygons (without elevation)I want to create roof-ridges and roof surfaces.How do I use FME to make areas to represent roof sides? So i need the maximum and minimum elevation inside the boundary but how to do to make roof sides ?I used a clipper between las and boundary and after a pointcloudcalculator but after i use a geometryreplacer i don't understand all geometries exit rejected why ?And after it's necessary to use 3d Forcer, i need help !!Thank youNat