Using readers and writers to extract and load data.
Recently active
Hi allIm converting an AutoCAD drawing into a GIS map in FME 2016, the AutoCAD files contains a number of texts that I will be using as labels. This is fine but when I read in the dwg files FME creates a box around the texts that interferes with the rest of the map. These boxes are difficult to remove because the have the same color/size/layer/geometry type as other data that needs to stay so I have on easy way to filter them out.Is there any way to read only the texts without getting the bounding boxes?
Hi guys,In a workbench, I need to create an excel file as a sort of validation that all data has been written how it was supposed to be. I need to compare input and output and highlight differences in red. I'm able to create the excel file where all input columns are next to their output.For the highlighting part, I created an excel file containing all column names in the A row, and conditional formatting that highlights cells in red if output <> input. I tested it directly in the excel file and everything works ar it's supposed to.So, I added the excel file as a template. I tried every configuration I could think of, but every time I launch the workbench, it results into a copy of my template, without any data written.How do I insert values into the excel file, while using a template file?Thank you(FME 2015.1, EXCEL 2013 file format)
I am trying to use FME to create ArcGIS Online Feature Collections instead of Feature Services. I assume I need to write some Python script for it but wanted to see if anyone else had perfected this process.-Mark
We're trying to write data via "ArcSDE Geodb" writer in SDO_GEOMETRY format and make it readable for non-ESRI software. We're using ArcGIS for Desktop 10.3.1 on an ArcSDE 10.2.2 on Oracle 11g with FME Desktop 2015.1 (but the same problem apperas in different combinations of software versions as well).Our main problem is that in the oracle geometry metadata entries the axis-definition can't be set correctly no matter how we're trying it. SQL:select DIMINFO from user_sdo_geom_metadata WHERE TABLE_NAME = 'SDOTEST_FME_WRITERCRS';RESULT:MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT(NULL,3447000,3467000,0.001),MDSYS.SDO_DIM_ELEMENT(NULL,5422000,5440000,0.001))As you can see, both axis are defined as "NULL" instead of "X" and "Y". Is there any way to tell the writer how to set this up correct?
Curious question w/ FME making strides in the industry. Does it have capability of extracting lets say a manhole cover using PointCloudStatisticsCalculator (or any other transformer) with an average Z value and intensity?
Hello,I have problem with shapefile with line features. I can´t read it, because log shows me following info:"The DBF file seems to contain less records than the Shape file"It looks that in shapefile are more features than in shapefile. How could I exctract these problematic features from shapefile please in FME?
I have a large KML file that I would like to split into several smaller equal size KML. My original KML file has 311,055 polygon records and is too large to open in Google Earth as is. I would like to create several sub files from this file (e.g. 5 KML files with 62,211 records each).
Hi,Not sure if this is a bug. I've found that the PostGIS writer's SQL Statement to Execute Before Translation can accidentally double encode the SQL such that it results in a fatal error on trying to write.As a process;Enter this SQL code in the advanced editor (by clicking the elipsis button on the writer's Edit Parameters pane);FME_SQL_DELIMITER ;DROP INDEX IF EXISTS "TEMPSpeciesSightings_Catalogue_Number_Index";DROP INDEX IF EXISTS "TEMPSpeciesSightings_Conservation_Index";DROP INDEX IF EXISTS "TEMPSpeciesSightings_Date_Modified_Index";DROP INDEX IF EXISTS "TEMPSpeciesSightings_Spatial_Index";DROP INDEX IF EXISTS "TEMPSpeciesSightings_stateConservation_Index";FME encodes this to;FME_SQL_DELIMITER<space><semicolon><lf>DROP<space>INDEX<space>IF<space>EXISTS<space><quote>TEMPSpeciesSightings_Catalogue_Number_Index<quote><semicolon><lf>DROP<space>INDEX<space>IF<space>EXISTS<space><quote>TEMP
Ou comment changer la profondeur de codage d'une image (série d'images). Trouveé aucun transformer qui fait ça !
When I set a shapefile Reader , i found that it can only read the shapefiles which have the same Feature Type, but i want to load shapefiles with different Feature Type by one Shapefile Reader, how can i do ? By the way, i want to publish it to FMEServer, and i can read the shapefiles upload by website, which may have different Feature Type. How can i do??? Thanks!!
I have multiple feature classes that are in one geodatabase. I want to merge (append) these feature classes over a given schema to a separate file geodatabase. What transformer do I use?
Hello Users,I use the Reader Smallworld 4 and in my just one connexion on this Database i have two diferents features types.I would like use a Where clause parameters to filter dates but with two conditions:Condition 1 to feature type [Electricity] cable where Known_as = "Upper Milton Road LV" Condition 2 to feature type [Gis] min_road_centre_line where Road_type = "A-Road"Its not working when i use the Where Clause for both tables:
Hi. Every quarter I convert a shp. to TAB and GDB and compare the size of each file to see if I had an increase or not. This quarter I converted and I had an decrease on the size of the shp. and GDB, except for the TAB file: I open the TAB file and nothing is corrupted, so my question is shouldn't the size of the TAB decrease also. Please let me know your comments. Thanks in Advance
I have the Smallworld-Pathway-Training-2014 training material that Mark Stokes was gracious enough to send to me. I am looking for any other documentation that is out there. I am currently trying to translate Microstation into Smallworld. I have had success with simple features but need some more help with the rest of it. Specifically deriving Smallworld Text data from cell names and Microstation text. and placing multiple objects (one with no real geometry just a join) using a single point from Microstation.
Hi,I have a LAS file in version 1.4 and FME desktop 2014.When reading the file I get following error: "version minor out of range".Is FME desktop 2014 compatible with LAS version 1.4? In the reader/writer documenattion I read "FME supports LAS versions 1.0, 1.1, 1.2, 1.3, and 1.4".Or could this be a problem not related to versions?Thanks,Rob
Hello Team,I would like to generate a PDF file and through the transformer PDFPageFormatter i setted the the Page Object:I would like to know if is possible the FME read my Source Data Polygon ( in meters ) and insert inside the above settings ( BoundingBox ) and calculate the scale automatic showing like a attribute.I saw the link https://knowledge.safe.com/articles/19757/creating-pdf-cartographic-output.html but the user choose the scale when run this Workspace.Thanks in Advance,
I want to extract information from a WFS service, but the WFS services has a limitations of 10.000 features. The WFS service is: http://afnemers.ruimtelijkeplannen.nl/afnemers2012/services?SERVICE=WFSThe number of features is around 40.000: http://afnemers.ruimtelijkeplannen.nl/afnemers2012/services?REQUEST=GetFeature&SERVICE;=WFS&version;=2.0.0&typename;=Bestemmingsplangebied&resulttype;=hitsSo I thought I could add multiple WFS readers to the workbench each with a different setting at the 'start feature' and 'max features to read' (see below)Parameters reader 1:Parameters reader 2However when I run the workbench the request is still limited to 10.000 features; as you can see in the screenshot below.Does anyone know how I can workaround this limitation?Another option would be to perform an attribute or spatial selection on the WFS reader, because I only need a selection of the features. For instance only the features where the attribute 'datum'
Hello FME! I have some data in the Esri shapefile format that consist of rivers and lakes, using data from Kartverket.Originally they were in the SOSI format, used by Kartverket. What I've done is that I've taken the polygons and the polygonlines and converted them to the Esri shapefile format using QGIS. What happens after I add them to my workspace and let them combine with the DEM, is that they won't drape, and they also seem to remove/hide some land from the DEM if it's on the same level (or below it)I looked at the example from Bowen island, but it required some additional data.Workspace:http://i.imgur.com/6wwtHgr.pngThe world with lakes and rivers:http://i.imgur.com/u7FiZ1h.pngWithout:http://i.imgur.com/rAma8dN.jpg
Hi All,I have a Workbench and running it in 2014, it work perfectly reading from AGOLbut since i've converted it 2016.1 it fails reading. There no option anymore for the datasetBoth instances options are set use system proxy.
Hi,I apologize for the previous post on reducing the ECW linked with dysfunction of my PC. I would reduce the size of an ECW file 10GB composed from images in 24-bit to 8-bit. Would you have a solution?Bests regards,
Hello, I'm using the AutoCAD Real DWG reader to read in a dwg which contains an XREF.The xref, (dwg) is in the same folder as the main dwg and resolves when opened in AutoCAD.The "Read External References" param in the workspace is set to Yes.When the features enter the workspace the xref has an autocad_xref_status of unresolved.I use the "Explode Blocks into Entities" param so I can output to DWF and toggling this param has no effect on the xref.I've changed the path options on the xref in the main dwg; none of which makes a difference.Looking for ideas on how to overcome this limitation.Thank you in advance!Brek
I have a polygon shape file containing a few dozens of rows. How can I split the shape file into many shape files, each containing only one row?
I have tried PoinOnRasterExtractor but this does not work. I have tried to use the PointCloud transformers but still no luck. I must be missing something but can't see it.
I would like to add Layers to my Geocortex Essential Web Map, via a Geojson in FME. What Writer should I use to connect and configure?
I'm trying to write to different columns using the XLSX writer. I want my first group of features to be written in the first column, second set of features written in the 2nd column, etc...I think this should be possible using the writer's "Format Parameters > Sheet Settings > Row ID Attribute" and "Format Parameters > Start Position > Start Column".I'm having trouble dynamically assigning the former. I think I can use the Count function here, but I'm not sure how to reference the feature's (only) attribute's name to use as the domain name for the count.