Using readers and writers to extract and load data.
Recently active
I have exported data from PDF file using FME. The output contains lines, polygon and text data. A sample of the text data is attached. I need to combine the different letters in points with the same TEXT_ANGLE and TEXT_SIZE to form a new attribute containing the full text and write it to 1 point feature.
I have a workbench that uses the SurfaceModeller transformer to produce a DEM (DEMRaster output port) from input polylineZ and break lines inputs. The output DEMRaster will be used as an input in various raster math operations with an existing terrain DEM. It is thus crucial that the DEMRaster output match the cellsize and be perfectly aligned to the existing terrain DEM. In Esri parlance this can be achieved using the "Snap Raster (Environment setting)". How can I achieve this with FME? I am using FME Desktop Professional 2017.1.1.1. I have tried using the RasterGeoreferencer as recommended in the Snapping raster output cells to existing raster template cells (same cell size) post. I can either control the extents (using the "Extents" parameter) or the cell spacing (using the "PointAndAngle") but I can't figure out how to control both. Thanks!
Good morning, I'm trying to extract a table from a website, but am having a difficult time doing so. The issue is that the website has a pull down option with multiple tables. I'm able to use HTML Table reader to extract the table that comes up as a default, but I need to pull one of the other tables. The URL that I'm using is https://eds.ospi.k12.wa.us/DirectoryEDS.aspx. In upper left, you have the option to select Reports by either District or School. District comes up as the default; but I am actually interested in the school table. Can someone help me achieve this? Using the HTML Reader, I'm able to see the default table that comes up on the website which is gvESDDirectory. However, the table that I'm looking for is called gvSchoolDirectory. I can see it using developer tools in Chrome. I'm just not able to figure out how to get FME to see that table. Thanks!Eugene D.
I want to read a csv from a URL, but I am failing to connect.I add a ReaderFormat: CSV (Comma Separated Value)Dataset: http://www.bom.gov.au/fwo/IDQ60801/IDQ60801.94418.axfunder ParametersDelimiter Character: ,Field Names Line: 20Data Start Line: 21 but I get the errorCSV reader: Failed to open file 'http://www.bom.gov.au/fwo/IDQ60801/IDQ60801.94418.axf' for reading. Please ensure that the file exists and you have sufficient privileges to read itWhen I use chrome to visit the URL I succeed. The URL and resulting csv file definitely exist.What I want is to read (and process) the csv file using FME
I have tried multiple combinations, but it seems the "Max Features to Read Per Feature Type" value is being ignored. I have 14 Feature Classes selected in my "FEATURE_TYPES" Published Parameter, so hence, if I set the value to 2, it should read 28 records but unfortunately it seems to only read 2 records from a random Feature Class. I am using v2016.1.0.1Refer @mhab's comments in this idea post: https://knowledge.safe.com/idea/25361/add-a-max-feature-to-read-per-feature-type-paramet.html
I've attached () a DWG file, which have 2 layers, I need to create / close polygons using the TRAIL layer, however the TRAIL layer in some sections cross with NETWORK, and so the polygon is not created. How can I create a polygon from the moment that TRAIL touches the first line NETWORK? See the images below: Thank you
Hello,I have a simple workspace that renames and exports pdf documents to tiffs. Its the PDF2D reader, some renaming transformer,s and the TIFF writer. The tiffs need to be 400 dpi. No matter what I do, I only get 96 dpi. Is there a way to control this?I have been able to get the 400 dpi using other software, but it's either clunky or will cost me more money. FME is obviously the preferred method if I can fulfill this one requirement.I appreciate any help.Thank You, FME(R) 2018.1.0.1 (20180730 - Build 18528 - WIN64)
I have two separate Oracle clients on my machine. When I create an Oracle reader or an Oracle writer, it defaults to whichever Oracle client is first in my PATH variable. Is there any way to tell FME to use the other Oracle client?
Dear Community, Last year I created a very large FME Workspace that became even larger in time as new feature requests came in while there was no time to restructure the FME Workspace. At the end the FME Workspace had more than 1300 Transformers and FME Workbench had trouble to open it. (The file was 25 Mb large.) Moreover development work became slow as I had to wait about 10 seconds every time I clicked within FME Workbench. Fortunately I convinced my client to restructure the FME Workspace and now there is time to do just that.With an upgrade of the FME Server from 2016 to 2018 it becomes possible to make use of Parent-Child-relationships. Hence no additional engines had to be bought and that made it possible to reshape one FME Workspace in two FME Workspaces. Unfortunately I was surprised that if I ran the Child FME Workspace alone (which is in that case by definition no Child) a File Geodatabase could be read. (See job 274 in the screenshot below.) If I used however a Parent FME W
Hi, Im trying to Convert a DFX file to a GDB. The CAD file is a repesntation of a Piping System. The conversion runs successfully but pipes that run vertically (along x axis) loose their shape length. For the Reader in the format attribute tab: autocad_color, autocad_entity, autocad_layer, fme_attrib_info{}.field_value are checked. I'm using FME Desktop 2014, AutoCAD 2013, ArcGIS/ArcScene 10.1The DFX is 2007 Format
Hi, I can't seem to read layer descriptions from DWG files. I have tried different versions of FME, different reader settings and different DWG types with the same result. It does seem to read a few of the layer descriptions but I have no idea why it would differentiate them as they seem identical when I open the files in AutoCAD. Has anyone had the same issue? Thanks!
I have an elasticsearch instance that requires a password for writing. Am I understanding this correctly that FME can't write to a secure elastic search?
Hi,I don't find out if there is a rule to manage the execution order between a SQLExecutor and a Postgres Writer.I want that the SQLExecutor is executed before the Writer because it makes a backup of the table before writing.And I can't use the "SQL to run before write" field in my writer because I use feature values in my SQL instruction and this field doesn't handle feature values. The strange thing is that in one of my Workspace the SQLExecutor is executed before the writer and in another the Writer is executed before the SQLExecutor (the second one handles far more data).I tried to change the horizontal and vertical order of both but that doesn't change anything. Thanks for any help,Christian
Hi, I need to set color for Lod2Geometry features (vegetation) to create city GML. Please find the snapshot of the workspace. I am able to view the color in FME inspector but not in FZK viewer
Following is an example I am suffering from now, just don't know how it could happen and the solution for us so far is just to manually move impacted columns back to the right position, which is stupid of course:1. Columns (Latitude and Longitude) are at the begining of the excel file:2. After imported into the FME, the order of these two columns (Latitude and Longitude) changed and moved to the last for no reason:
Hi,I have a 3D polygons file that I would like to convert to obj format. I tried several times but I always have one polygon in the output that is strange.any advice or idea?thanks!
Has anyone experience with moving data to/from ArchiCAD (https://www.graphisoft.com/archicad/) ? Seems to be easiest to work with IFC or SKP for buildings. But havent found the easiest way to work with terrain-data for import/export yet. It seems incapable of importing terrain-data without generating the terrain all over again - but that might be just because I dont know the software :)
Hi all,I'm the version FME 2018 build 18284 Windows and when I write the name of transformer ProjectWiseConnector, doens't show Help information.Whats is the reason?Thanks,Danilo
Our script log files say INFORM|ArcSDE release: '10.0'. Underlying database: 'Oracle' We are running SDE 10.6.1 and our SDE.VERSION table shows the database as 10.6.1. I am wondering if there is something in our geodatabase that hasn't been updated correctly.
Question: Is it possible to have FME write .ovr files with a GeoTIFF (Georeferenced Tagged Image File Format) writer? The Solution I am hoping for:An FME solution for writing .ovr pyramid files2nd best would be solutions to the Python/ArcPy errors I'm getting when running ArcGIS geoprocessing tools3rd best would be another plan for writing .ovr files.My Software:Safe: FME(R) 2018.1.0.3 (20180926 - Build 18552 - WIN64)Esri: ArcGIS desktop 10.6.1 version 10.6.1.9270 with Background Geoprocessing (64-Bit)Basic Background:I am developing a process for a couple thousand tiff images that will be used in ArcGIS (it's not relevant but I'm using a parent workspace with WorkspaceRunner to run this child workspace). Ideally my FME workspace would write GeoTIFF images with pyramids in a format read by ArcGIS (apparently its an .ovr file), that way the features written are a final product for use in ArcMap. The Issue I am having:My problem is that I am not able to get the GeoTIFF writer's "Generate
Hi folks,I have a workspace thatreads in an Excel filejoins it with a KML file to Georeference the entriesuses an AttributeManager to keep just the values from the Excel filewrites the output as a KML fileMost of the attributes end up as blank/missing.Does anyone know what is happening and how I fix this?Thanks in advance,Ian
Hi,Each time I tried to read an SQL database and include a where clause statement in the reader the FME was fails to do so, even when I tested the statement it was running successfully see below.Does any one know how could id solve this error? The error as the following:2018-11-22 16:31:29| 1.8| 0.0|INFORM|FME API version of module 'VertexCreatorFactory' matches current internal version (3.8 20180604)2018-11-22 16:31:30| 1.9| 0.1|ERROR |Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `SELECT [BBSId], [ID], [Entity/Observation], [Observation Date], [Observation Type], [Severity of Observation], [Performed By], [EmployeeID], [Person Observed], [CONT_SVC_PROVIDER], [Not Listed], [CONT_SVC_PROVIDER_Name], [Name_Third_P_Inv], [Group Type], [Safe], [At Risk], [Description], [Longitude], [Latitude], [Location], [OrgAxisId], [Reference], [Workplace Activity], [Offline_CONT_SVC_PROVIDER], [Behaviours], [Company], [Platform], [Crea
Dear Sirs, I would like to extract elevation from a KMT or KMZ file from Google Earth! to use them in Autodesk Civil 3D (to DWG file).Is that possible? I was looking and reading about the Google files inside the FME Knowledge center, but I couldn't find any topics which lead to the answer to my question!I am very new to FME and this is my first time to use FME. I hope someone can help me with it. Thank you so much for your attention and your help.Wishing you a wonderful day.Kindly regardsSalwan Abbosh
Hi everyone. I'm writing a dwg file from an excel sheet and i would like to know if it's possible to select/change the visibility state in a dynamic block. I can create the blocks but they all came out with the same visibility (the first in block visibility list).Thanks
How to cut a uniform distance of 1 km from the right coastline DEM below? please help