Using readers and writers to extract and load data.
Recently active
HiI am trying to convert las files into raster, for that I am using as recommended by Safe the following transformer ImageRasterizer as you can see in the attached image: But I keep getting the same error:ImageRasterizer (VectorToRasterFactory): 338432 input feature(s) were discarded because they were not compatible with any band in the raster. Bands with a color interpretation require vector input features with an 'fme_color' attribute. Bands with a numeric interpretation require vector input features that have Z coordinatesImageRasterizer (VectorToRasterFactory): No valid input features. 338432 input feature(s) processed. 0 input feature(s) with invalid geometry discarded. 338432 input feature(s) not compatible with the raster interpretation discardedImageRasterizer (VectorToRasterFactory): A fatal error has occurred. Check the logfile above for details
I installed FME Server on my Mac using Docker...running using docker-compose. I am wondering if I can connect to the Postgresql database external to the docker image from my Mac. Just interested in using it while testing, but not sure which port/user/pw to use. I couldn't tell this information from the docker-compose file. Any help would be appreciated.
Hey everyone,There's been several topics on reading Civil 3D Property Sets on the FME forum, and according to the release notes for FME 2019 it seems that the the new version offers now this possibility. So I upgraded to FME 2019.2 but I now have a problem with the reader itself. Indeed when I try to read a Civil 3D dwg file with the same parameters as with FME2018 I've got this fatal error : Does anyone have an idea on how to solve it or of where it could come from ? By using an ACAD reader it works properly but of course I don't have the extended properties which are on Civil.Thanks by advance,Clem
Hi forum,I have an IFC file that contains pipe network from 12D model. The IFC export contains pipes and some pit objects as points. I am not sure why this is causing the following object to return an fme_no_geom. i am running the data se through a GeometryFilter and these features are exiting in the null channel.fme_geometry fme_typefme_aggregate fme_no_geom #22 = IFCRELAGGREGATES('1hViQUWInAEPHHSf76Sqog', #2, 'SiteContainer', 'SiteContainer For All Models', #19, (#21));#23 = IFCRELCONTAINEDINSPATIALSTRUCTURE('3NoqxiDnb3pvSwt$HSi04p', #2, 'Building Container', 'BuildingContainer for Elements', (#24, #110), #21);#24 = IFCELEMENTASSEMBLY('2avVmq1XXFtBSLGB9qcGYj', #2, 'P22-02', 'test', 'Super', #13, $, $, $, .NOTDEFINED.);#25 = IFCRELAGGREGATES('0nKhssk3PFoRE08AYptVpP', #2, '', '', #24, (#26));#26 = IFCFLOWSEGMENT('14omJrvZL3jRzNkxjD4bwN', #2, 'P22-02', '', '
Hi I have a workbench that converts Tiff tiles into one jpeg2000 with a transparent background.This is the bench: When I replace the jpeg2000 writer with an ECW writer I get a black background. When I load a jpeg2000 in Qgis, the background is transparent. When I load the ecw in Qgis I have to select in the settings under transparency band 3 as transparency band and then it's like the jpeg2000, but with an extra step. Sadly our customer works with CAD and there I cant remove the black background with a setting.... Am I doing something wrong?
I have a DWG file containing anout 400000 3D building features. Each feature has an fme_feature_type attribute such as "Roof" and "Wall". In the Inspector each feature has 48 attributes such as "autocad_block_number" etc. I'm trying to extract a subset of features to a separate file. I'm selecting an area of features in the Inspector and then using the "save selected" button to save the selection as a new DWG file. It saves ok but when I read it the fme_feature_type and the other attributes are missing. How do I save the extract in the same schema as the original file?
Hello I have a process in which I use FME to take a name from a Table, create a URL (like this "https://SERVER.XX_WFS_NAME?service=WFS&REQUEST=GetCapabilities") out of the name and download the coontent (XML) of that URL. Then a table is built out of that with 3 columns Name, URL and XML and ~300 rows. What I would like now is instead of one Excel file with 300 rows I would like to have 300 XML files preferablly with the tablename for each XML file as filename. I am quite new to FME so I tried out several writers but maybe you have a solution for me. An I currently use FME Workbench 2017 on Win10.CheersHannes
I have two folders with PDF's with the same name. I need to merge the pdf's in folder A with the pdf's in folder B when they have the same name and I can't get it to work in any way. I now have this workbench ( I need a stringreplacer due to errors in file names): The output will not open with acrobat reader. I get an error saying thete is not enough information for drawing a picture. When I open the PDF in a browser it will open, but:- the first page is empty- Some parts of the PDF's are blocked with a black block: (note: this is the exact output, I did not block anything) My questions:- How do I merge teh pdf's?- How do I get an export that will open in acrobat reader?
Hello, I have a LIDAR test data set, where I am trying to determine the power lines. These are currently in class 0 (unclassified). My first approach now is to select all points with a certain height above ground (and class 0). If the classification 0 is possible without problems, I unfortunately fail because of the classification of the points with a certain height above ground. For this purpose I have calculated a grid with the points of class Ground and the SurfaceModeller and then I check if the points of class 0 are on the grid height. If this is not the case, I continue to use them - but that is not possible.Another problem (which I haven't investigated yet) is, how do I convert the selected points into a vector?Is there another approach to extract (power) cables from lidar data?
I am new to FME vs AGOL. I want to use FME to update an AGOL hosted feature layer. Based on this article https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/arcgisonlinefeatures/arcgisonlinefeatures.htm, I created an app on our organizational AGOL using my enterprise single-sign-on, and registered the app to have an App ID and secrete key. But where I use them to connect to AGOL in FME? I don't see any place in the "ESRI ArcGIS Online Feature Service" writer. See attached. I am using FME desktop 2019.2.
Hi, I would like to convert GML files into shapefiles using FME but have no idea how to do this. Could someone tell me where I could find instructions for this? Many thanks.
How could i writ the excedded rows from oracle to excel filesif it is not enough in one sheet can i write all data ins the oracle file to different sheet and eaxch sheet has part of the data from Oracle file till the data finished .Is it possible or which another format could i write the exceeded rows from oracle fiels to Thanks for any help
I have 63 facilities (points) and I would like to create a 20km service area polygon for each of these points using the ArcGISOnlineServiceAreaCalculator transformer. I've never used this transformer before, but was very happy I found it because I had previously been using the Network Analyst tool within ArcGIS Pro and wanted to move my process to FME. I'm not sure if I'm using it correctly. I'm using the same parameters that I would use on ArcGIS Pro but my output on FME is not a polygon - rather it is a point/IFMEMultiPoint. This is a custom transformer so I'm wondering if maybe it isn't compatible with FME 2020 or has a bug? Or am I missing something else? Here are the parameters: And here is an example of the output if I just use 3 facilities:There is only one 'service area' even though there are 3 facilities. The attributes passed through are only for the first facility. However, there are 3 vertices, one for each facility. The translation log retu
Dear FME-Community, We have a customer who wants to update an excel-file regularly with data. The customer placed the file on his onedrive account and shared the link with us to be able to read the data. Now we want to directly process and read the data of this Excel online file using FME. Is it possible? I couldn't get the Onedrive-Connector to work, because we don't want to use any files on our own account, but want to use the shared link of our customer.I also had a look for possibilites, to download this Excel file on a regular basis on our server. Also with no success... Thx for any tips or hints.. best regards, Chris
I tried to read data from postgis reader and write to a geojson file. I only use two translators, a postgis reader and a geojson writer.I encounter the "Error running translation." every time when feature number is about 40,000,000. I only use two translators, a postgis reader and a geojson writer. The translation seems to have no issue if the feature number is around 10,000,000. There was no other error message.I also tried to turn on the debug log but still had the same error message. I am using FME(R) 2019.2.1.0 (20191202 - Build 19813 - macosx). Thank you!
I have a need to take stacks of documents and upload them to SharePoint Online and organize them in respective Libraries and Doc Sets.My idea is to have the 1st page of the scanned document, which is saved as a PDF, read the contents, then rename the file based off the text found on the 1st page. Uploading those files into a Content Organizer, based from file name, will accomplish SharePoint challenge.Any ideas of: Read content of file, then rename file from that content?
Hello there, I am a bit new here. Thus this might a bit of a simple question, but I'd really appreciate it if you could point me in the right direction. I have a GML file from which I only need the heigh and area of the buildings. I'm trying to use the interpretability tool from ArcGIS pro. But somehow the transformation is not working properly. Any idea what transformations I need in order to extract to a shapefile/database the info I need?
Currently trying out FME in demo mode and am definitely green at FME so this is a beginner question.I currently have a workbench setup to read a single dwg, run it through a tester to filter out only the desired layers, and then write it to shp format with the dwg_name and layer_name as attributes.I have also discovered the PATH reader which I have configured to search a drive and all sub-folders to generate a list of all of the dwg files I want to run through the above. How do I combine them?There is a related question 80618 "How to iterate through a list of .dwg file in order to convert them to .shp format" but I am not quite following it, and I have multiple sub-folders.
could i ask how to extract from oracle file specific city and the neigbohrs of this city.from the 4 side if available .should i write code in ql statement or what should i do . i do not want to have only one city ,i need also to get the neighbor cities so when i have lines intersected in specific city and neighbor city ,so i could know which neighbor city and intersected with which point .thank for any help
could i get intersection between lines and points in oracle files one of them is spatial and another oracl not spatial just i do not want to load all oracle files in spatial and it will make the workspace slow so i was thinking to to import one spatial oracle file and another not .spatial .is it possible to find intersection between both of them or should i load all oracle files only in spatial .Thanks
I cannot connect to an ArcGIS Server Feature Service though either a reader connection or a feature reader.The service I am trying to connect to is:https://services.thelist.tas.gov.au/arcgis/rest/servicesI have not problems connecting and accessing the data through ArcProI am using FME 2019.1.0.0 (20190710 - Build 19608 - WIN 64) with and Oracle Floating LicenceAnd also have FME 2015 installed, which i need to keep until we have updated some legacy processes. There is probably something very simply I am missing but for the life of can't see it. Below is the translation log from when I try to connect to the service with an ESRI ArcGIS Server Feature Service Reader ( I have highlighted the errors in Bold): Starting translation...FME 2019.1.0.0 (20190710 - Build 19608 - WIN64)FME Desktop Oracle Edition (floating)Permanent License.Machine host name is: TN4405Operating System: Microsoft Windows 10 64-bit (Build 18362)Copyright (c) 1994 - 2019, Safe Software Inc.Safe Software Inc.2020-03
Hi,I have an ArcSDE geodatabase on postgres. Im using a feature writer to insert records in an existing feature class.While doing so, I get the below error 'ERROR: null value in column "objectid" violates not-null constraint'When I drop the table and create new while writing, I get no errors.Logically, the sde should autogenerate this objectid field whenever I insert a new record. Am I right or where am I going wrong?Please suggestThanks
I need a workspace that will convert DWG to SHP. I get DWG files all the time and my Mapping software imports shape files. So I need shp files rather than DWG all ineed is the lines in the DWG not so much any data. I need help. I've tried different things with bad results.
Hi,I'm re-projecting some 3D AutoCAD drawings. After converting them the filesize goes from 4mb to around 40mb, this is using the deault settings for the reader and writer, so not sure why they have increased in size with re-projecting the data from snakegrid to OSGB.What are the best read and write settings when reading and writing AutoCAD files?Adam
Hi list.I'm tasked with creating an XML, that is compromised from many different sources (database tables/views). I'm plannning to use a number of XmlTemplater's to accomplish this.But each feature from some of these sources is represented in the final XML as a bit of GML wrapped in special tags.FeatureWriter will collect all input features into a single GML file. This is not what I want.Is there a way to make FME output the GML representation for each feature ?Cheers.Lars I.