Data

When reading a DWG, I am only interested in reading layers with the prefix '_'. Do I have the option to ignore all other layers? I know I can easily filter them after they've been read, but I'm trying to cut down on the initial reading time. Thanks.

Hi everyone,I'm using FME 2017.1.1.1 (20171014 - Build 17652 - WIN32) and I can't figure out the URL format I need to put in the MongoDB Reader for MongoDB Atlas. My co-worker tried with FME 2018 Build 18220, and he had the same issue.For my local MongoDB, the "localhost" works fine.But if I try to connect to MongoDB Atlas, I can't able to connect.I tried:mongodb+srv://gettingstarted-46yzp.mongodb.net/test?retryWrites=true Error is: Cannot connect: More than one ':' detected. If this is an ipv6 address, it needs to be surrounded by '[' and ']'mongodb://gettingstarted-46yzp.mongodb.net/test?retryWrites=trueRemoved: +srv Error still same: Cannot connect: More than one ':' detected. If this is an ipv6 address, it needs to be surrounded by '[' and ']'gettingstarted-46yzp.mongodb.net/test?retryWrites=trueRemoved: mongodb Error is: Cannot connect: no unix socket support on windowsgettingstarted-46yzp.mongodb.net/testRemove

I have a workspace that reads from a source File Geodatabase (.gdb) using the ESRI Geodatabase Open API format. When running the Workspace in Workbench with prompts, the parameter for the Source limits the browser to and/or understands that a File Geodatabase (.gdb) is the only acceptable selection/input.I have since published said Workspace to FME Server and the same parameter has no such limitation/understanding. When browsing to select the input (GDB) it displays the items within the GDB the same as if it were a simple directory (folder). If I click "OK" after choosing not to select anything within the GDB, server places the directory path in the parameter with a "/" at the end signifying that I want to use everything in the GDB as the input instead of the GDB as the input and the Workspace fails. If I manually remove the "/" from the end and run it, it succeeds.What must be done to get the published Server Workspace to function as the Workbench Wor

I need to load some data to AGOL from SDE, with domains. I have been able to load a feature service using FME using system proxy settings, but can't find a way to preserve the domains. Is this supported in FME and if not does anyone know of a workaround?In theory we should be able to share straight from ArcMap (domains and everything) however some complex corporate IT issues are preventing us from doing this, so I'm hoping FME can come to the rescue!Thanks.

I have run into a very strange problem. To simplify work I have created two folders, one incoming and one outgoing. Note that this is on a external disk. I have dropped the files I want to work on in the incoming folder and gathered the results in the outgoing. I recently moved everything FME to an other location on the same disk and proceeded to point the readers and writers to the new locations. For some strange reason I can't get this to work correctly. Everything else is identical and FME claims to write to the new folder but it turns out empty. If I delete the writer and insert a new one with identical settings it works again. Is there some workaround for this?

How do I expose the KML placemark attributes using fme?Here is the file I want to use:

Hello,I'm trying to find a way to store WMS image (URL link) into a file on my PC so I could use them again in my report.Do you think its possible to do that in FME ?Thank you very much for your answers.

I'm attempting to use Esri ArcGIS Portal Feature Service writer in FME 2017. I get the following error: The dataset '*******.*******.com\\portal' does not appear to be a valid domain. Verify that the dataset is a valid host. Records seems to pass along the connector to the writer but log file shows no features were written.

Hello, I was wondering if there was a way to integrate data from an excel table to a sharepoint list using FME? If so how would it go about, if not what other ETL tools can I use.Thank you

Want to analyse compactness of Landuse Plan. suppose each rectangular polygon has 8 neighbors. I want to analyse which polygon has same landuse neighbors. for example say residential is a polygon, so i want to know that from his 8 neighbors how many have same landuse (Residential) and how many don't have same landuses. Please see the following picture.,I am working on Landuse change methodology in Transit oriented development. ,

I want to import a subset of my SDE data into an MSSQL Azure spatial database. I can connect and create a table but the no rows get inserted. what is the proper way to configure this?

I've extracted text from a pdf file but i have to group or aggregate this text now...as you see on my screenshot i have such text as "4.1" or "5.2" etc...but they are all one point with text attribute as a result from PDF Reader... How can i aggregate them to one feature with one attribute which contains "4.1" e.g ?I know its simple but i tried Neighborhoodfinder Neighboraggregator and so on....result isnt right.. So for you specialists no prob i think..Greetz and Cheers Franco

I have a Geospatial PDF with a number of layers in it which I am trying to export into shapefiles. The trouble is that the resulting shapefile have systematically misplaced the items, so I image that I must not be understanding something about how my Reader is reading the coordinate system. The source of the geoPDF is Canvas X GIS, which can export directly to a shapefile, expect that some of the information such as text objects are lost. I export the data into both shapefiles and the GeoPDF in NAD27 UTM 11N. When FME reads the GeoPDF, it assigns the coordinates as EPSG26711, which seems to be correct. I also tried manually assigning it as UTM27-11, although that seem to place the objects in the same place after running the workbench. However when I first read the layers, and then viewed the items within the Data Inspector, it did not seem to assign geographic coordinates. I think that it only did so after I ran the workbench. In the log, it talks about running reprojection engines for

microstation DGN writer: how to set element fill type to opaque in FME

Hi, we had the following trouble using FME Server:Could not login using AD user account.Error log shows first Authenticating user using SASL mechanism "GSSAPI" with KDC address and realm "NL"..., which succeeds. After that an exceptions appears "LDAPException(resultCode=82 (local error), errorMessage='An error occurred while attempting to initialize the JAAS login context for GSSAPI authentication: javax.security.auth.login.LoginException: null (68) caused by KrbException: null (68) caused by KrbException: Identifier doesn't match expected value (906)')", and therefore FME Server concludes "Failed login by user due to insufficient credentials."It appears to be due to FME Server not supporting Active Directory servers (for reasons of failover we use multiple AD-Servers). Specifying just one of them (in stead of the domain) seems to be a solution to the problem, however, it would be nice if FME Server would support the multiple AD-Se

Hello, This will be similar to my previous question but it is more structured now and I have more examples.I am working on the DGN to cityGML conversion and have issues converting building roof polygons that contain roof superstructures, i.e where there are one or more higher or lower elements going out from the main roof planes – and where some roof polygons are donuts in the input Microstation DGN and need to be donuts in the output cityGML (blue polygons that are donuts in input DGN must to be Donut polygons in the output cityGML).My input is 3D building models in Microstation DGN format that contains correct roof modelling, i.e. correct donut polygons for superstructures. However, while converting the DGN into cityGML in FME I found two issues: (1) DGN reading does not support 3D Donuts, i.e. 3D Grouped Holes and (2) DonutBuilder transformer – does not fully support 3D data, i.e. no option to build Donut polygons from polygons “that are on same surface”.(1) Issue in FME reading DGN

This is my first attempt to simply read from a SQL Server view and write to an existing non-spatial table. The process runs and reports success and 31 records added to destination table but, on checking the destination table, they are not there. Is there a commit of the transaction that's not happening or something?Log reports "Stored 31 feature(s) to FME feature store file `C:\\Users\\gisadmin\\Documents\\FME\\Workspaces\\UpdatePFEditorsTracking_log.ffs'"Is this FFS the only place the records were added?

Hello! I am trying to write from an Oracle database to an Informix (Version 12.10.FC10AEE) database. I was using an AIX server last week and I was able to write the database. My it group spun down that server and we are now using a linux server. I am able to connect but I am having trouble writing anything. If I am using the built in writer (non-spatial) I get the following error: "Error connecting to databaseDatabase Generated Error Information:Database Error Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedDatabase SQL Statement Text: SQL State: IM002Variable Information: IBM Informix Non-Spatial Writer: Failed to connect to database"If I am using JDBC (non-spatial) I get this error: "JDBC Writer: Failed to create table 'GIS.B$PRI_COND_UG_N'. Error: Only a DBA can create, drop, grant, or revoke for another user.JDBC Writer: Table 'GIS.B$PRI_COND_UG_N' does not existCOM.safe.fme.TableDoesntExistExceptio

Hi,I can read the following JSON data from a file using the JSONFeature Reader and then attach a ListExploder to the list attribute named professionals-involved-in-the-discussion{}. This creates a row for each professional in the data. Perfect.However, in reality this JSON is coming from an attribute named json_data (not a file). If I use a JSONFlattener transformer attached to the json_data attribute, I need to manually create the attributes to expose. I have created a professionals-involved-in-the-discussion attribute, but it is not accepeted by the ListExploder?Any help would be appreciated as I guess I am missing something simple.Many thanks. {  "outcomes": ["testA"],  "party-id": 132956,  "start-date": "2017-06-21T12:38:00",  "activity-id": 10279532,  "assigned-to": 103576,  "completed-by": 103576,  "created-date": "2017-06-21T12:38:24.937000",  "authorised-by": 39583,  &q

Error: Invalid content at [11,58]: cvc-datatype-valid.1.2.1: '5da6322c-9e7b-4e35-a604-e931d7f40072' is not a valid value for 'NCName' Error: Invalid content at [11,58]: cvc-attribute.3: The value '5da6322c-9e7b-4e35-a604-e931d7f40072' of attribute 'gml:id' on element 'tran:Road' is not valid with respect to its type, 'ID'Solution: If am editing the gml file line containing gml_id:5da6322c-9e7b-4e35-a604-e931d7f40072 to gml_id: "any_name"_5da6322c-9e7b-4e35-a604-e931d7f40072. Then it is not showing error. Features will be validated and successfully imported.How to rectify this other than editing manually.Please help. Thanks

I have an attribute of a feature called RTN_NOTES. It contains free text stored in an xml structure as below.I need to merge the values of the <Run> element entries in to a single output text attribute(varchar). I have tried to use the XMLFlattener feature, but this seems to only return the contents of the 1st <Run> entry.  Any help would be appreciated. Thanks, Michael (FME Newbie)<Section xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"> <Paragraph> <Run FontWeight="Normal" xml:space="preserve">I visited Joe Bloggs to discuss how he feels things are going.</Run> </Paragraph> <Paragraph> <Run FontWeight="Normal" xml:space="preserve">Joe is worried about his situation.</Run> </Paragraph> <Paragraph> <Run FontWeight="Normal" xml:space="preserve">I have suggested a follow up meeting.</Run> </Paragraph></Section> 

When I run the statement 'select st_srid(geom) as epsg from my.table' on the psql command prompt, it correctly returns 31468 When I do the same in the SQLExecutor transformer, in returns 0.Doing the same exercise with 'select count(*) as my_counter', the results are identical.What is wrong here? The docs?

I have an application storing PDF's that are uploaded to it in a varbinary field, I would like to reverse this process with FME and extract that data and write the PDF out. So far I haven't been able to get that to work. Any suggestions?