Using readers and writers to extract and load data.
Recently active
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.
I have a 3D building model done in Revit. My objective is to export it in a cityGML format with a LOD 2 and LOD 4. I wish to have only one workbench that can generate either the LOD2 or the LOD4. I am using the BIM to GIS Advanced Tutorial workbench. It work great for my LOD 4. To achieve the LOD 2, I disable some of the writer and it work great, except that my external walls have holes for the windows and doors, or in LOD2 we wish to have the walls plain.If I export the revit file in IFC format, in the reader parameter, I have the option to omit the openings but if I export in rvz format there is not such option in the reader parameter.The BIM to GIS Advanced Tutorial workbench does not work if I used a IFC format as reader, so is it possible in the rvz format to overcome the opening generated by the windows and doors?
HiI have set of Details filled in the excel.i have to connect the Excel in the dgn. for example In my Excel door no was 15 it contains 32 details. in my dgn also the level door no was 15.i have to connect like this,in ArcGIS term like Join and Relates..Advance in Thanks
I have photos attached to a feature type in AGOL and I need to extract those photos. When I read that feature type in FME I don't see where I can expose those attachments. I am only able to view and write the feature type attributes. Is there a way to exposed the attachments to export the photos as .jpg?
Hello All FME Users,I have a workspace and the KML generate a attribute above the icon ( i dont want this schow this attribute ):My Workspace has a transformer KMLPropertySetter.Attached my template file.Thanks in Advance,
Does anyone know what I need to do to read microsoft access db on fmecloud?I am getting the error message below, do I need to upload a DLL to the plugin folder? thanks in advance! Creating reader for format: Microsoft Access 45 INFORM 0.0 0.2 Today at 00:02:22 Trying to find a DYNAMIC plugin for reader named `MDB_ADO' 46 LD_LIBRARY_PATH is '/opt/fme-engine-2016/plugins:/opt/fme-engine-2016/fmecore:/data/fmeserver/Server/lib/fmeutil/fmecore:/data/fmeserver/Server/fme/fmecore:/usr/lib/oracle/11.2/client64/lib' Could not load module '/opt/fme-engine-2016/plugins/fme_ado.so' : /opt/fme-engine-2016/plugins/fme_ado.so: cannot open shared object file: No such file or directory Could not load module '/opt/fme-engine-2016/plugins/fme.so' : /opt/fme-engine-2016/plugins/fme.so: cannot open shared object file: No such file or directory Could not load module '/opt/fme-engine-2016/plugins/mdb_ado.so' : /opt/fme-engine-2016/plugins/mdb_ado.so: cannot open shar
Hello all,I have a workspace that generate a KML file with Folder and Subfolder. The problem is doenst write nothing points inside the Subfolder.Thanks all :)
I am using the Esri ArcGIS Online (AGOL) Feature Service writer and can connect to ArcGIS Online and see existing feature services. However, when I try to write a new feature service I get an error: User folder does not exist. I have copied the folder name from the existing folder names that the writer shows. How do I write a new feature service to AGOL using FME?Thanks
Does anybody know if it is possible to trigger a SQL Server SSIS package from an FME workspace?I have FME Professional Edition but not the version that can write directly into Microsoft SQL databases so I was hoping that a workaround might be to carry out the required transformations using FME, output the results to a file and then have SSIS pick up the file and import it into the database. It's a long way round but I haven't got a hope of getting budget approval for and upgraded version of FME (that would make life far too easy!)I'm not a python programmer but was thinking that maybe the Shutdown Python Script might be of help here?Many thanks
I'm using a SqlExecutor deleting some data in a Oracle database.FME_SQL_DELIMITER ;--feuille 1DELETE FROM G_ADT_AGRI.EXP_INVEST WHERE OBJECTID = @Value(OBJECTID);/*--feuille 2DELETE FROM G_ADT_AGRI.FON_BATI WHERE OBJECTID = @Value(OBJECTID);*/As you can see I commented the "feuille2" part. But I have this error message : An error occurred while accessing a table result for feature type `QueryFactory_SQLExecute'; message was `Execution of statement `/*--feuille 2DELETE FROM G_ADT_AGRI.FON_BATI WHERE OBJECTID = 699' did not succeed; error was `ORA-01742: comment not terminated properlyAlthough I use the right comment syntax. What did I miss?