Data

Hi Can someone advise me what the easiest method there is to select only certain records from an excel spreadsheet, based on one column?I have a simple excel spreadsheet listing bin deliveries to addresses as individual cases from our CRM system. One of the columns is whether the case is Open or ClosedOne of my FME workspaces is configured to map all these into SHP format, which i've succesfully doneThe other workspace now needs to also map these, but only where the case is Open.I've tried the Attribute based Transformers, but can't get the correct outputAny help much appreciatedthanksSimon Hume

Hello I am using a WFS reader to extract data, is there any way we could query the WFS to retrieve only specific featuresThanks

My workflow right now is set up to do some calculations on a property boundary then be able to show that property on an aerial image. Where I'm getting stuck is to be able to find a way to set the scale (zoom level) of the google static map so the polygon is centered and at an appropriate zoom level. I'm using the 'google static map fetcher' transformer and have everything working to be able to center the polygon within the google map, just want to find a way to set a scale level to have it adjust to the different size polygons.

Hi, I have a lot of profiles measured as xyz data (points) in RD coordinate system. It's an Excel with all the profiles, each profile has it's own name (1,2,3, etc). Is there a way to convert each profile to a separate .jpg/png file in FME?

Hi, I have set up an Esri Geodatabase on HANA 2 using ArcGIS Pro and loaded data in it using Pro. I then tried to establish a reader connection to this geodatabase from FME 2018 using a connection file created in ArcGIS Pro.The system I am trying this from has ArcGIS Desktop 10.6, ArcGIS Pro 2.1.3 and FME 2018.0.1 installed (b18310, 64-bit). The HANA jdbc driver has been installed propoerlyThe error I am getting is: 'Could not open Enterprise Geodatabase. The error number from ArcObjects is: -2147155361. The error message from ArcObjects is: Connections to HANA to geodatabase in SAP HANA are only supported from ArcGIS Pro and ArcGIS Server sites.I can think of 2 possible reasons:1. The 'Esri Geodatabase (ArcSDE Geodb)' format doesn't support HANA-based Geodatabases (yet?). If so, is this on the FME roadmap?2. FME is trying to establish the connection using the 32-bit ArcGIS 10.6 libraries rather than 64-bit ArcGIS Pro libraries. The reference to ArcObjects in the error

Hi,I am having an issue converting data from an ESRI SDE connection to KML file in FME due to 1.3m shift from the same conversion in ArcMap.My SDE data is NAD 83, UTM Zone 10N (WKID: 26910). I have no issues connecting to the SDE, I get the same 1.3m shift using a Writer or a FeatureWriter. I do get a warning of:NOT changing coordinate system of reader identified by keyword `GEODATABASE_SDE_1' from `EPSG:26910' to `_UTM83-10_0' -- mapping file setting of `EPSG:26910' overrides coordinate system `_UTM83-10_0' read from fileIf I put the SDE coordinate system of "UTM83-10", I still get the same error. Once exported, regardless of which coordinate system i use, the 1.3m shift is still present in the kml. I have exported from the SDE into both a file geodatabase and shapefiles and repeated the same process and I get the same results. If I re-import the KML into FME to a shapefile and compare to the original in ArcMap, there is no shift. If I import the same kml

Does FME have a reader for AIG format rasters?

I've created a spatialite database using FME. It includes layers with polygons, lines, points and tables (no geometry). However, FME 2017 does not seem to offer an option to indicate geometry type. Therefore, the geometry_type table and column is not filled correctly thus layers are not visible in QGIS. After adjusting the table manually the layers become visible. Does anyone know how to solve the problem within FME?

Anyone who knows the solution to this? We are doing a refresh from ESRI ArcGIS SDE to ArcGIS Online and this is the error that was encountered. How to avoid this? Most of the time I encounter this error, only sometimes that the process becomes successful. ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '504' and the message was: 'Your request has timed out

Hello I am getting error: FMEServerJobSubmitter(ServerJobSubmissionFactory): Could not initialize connection to server "<server/LoadBalancer name>". FME Server error: `Communication Error: Failover node detected client request. Request rejected to redirect to active node.' , Please advise.

I am looking to write to a postgres hstore column and seeing if their is a way to use a postgres writer with its 1000 transactions at a time to write to postgres table with a hstore column over using a 1 at a time sql-executor? I have 5 attributes to go into the hstore.

I need to create a workflow in FME Workbench. It should contain following steps:1. Given Point Cloud (.las-format)2. Export as a 3D Model in IFC3. Create a GeodatabaseSo in the end I want my point cloud to be a model that I can import to ArcGIS Pro. Is that possible or is there any other/better solution solving my problem? I am thankful for any comment.

I am am trying to convert a IFC-file into a CityGML-file. For inspiration I am relying heavily on the intermediate guide for BIM to gis. Now when I am trying to convert the IFCDoors entities into CityGML doors i get the following error:Type of writer to use was not specified (WRITER_TYPE was not found)I have to the best of my knowledge not changed the writer in any way except for the output-file path and the projection system. Every other geometry I am using seems to konvert nicely.So my questions are as follow:What does the error mean?How can I solve it?Thanks in advance :D

Hi,   When running a workspace on Cloud I get the following error "BADNEWS: File /opt/fme-engine-2018/metafile/autocadCorrTemplate.fmi could not be opened (foundation/framework/engine/tabrdr_classic.cpp:2756 - open) - (foundation/framework/engine/tabrdr_classic.cpp:1460 - getRow)"  The same workspace works fine in Workbench and even worked on Cloud in an earlier iteration. I have recently updated the workspace and it does contain a DWG reader but I have made no changes to that part of the workflow.  

I keep getting this very vague error message when running my FME. My workspace is simple. I'm pulling down my data from ArcGIS online, I have a joiner to join to other data to get a few attributes, I'm re projecting my data then writing it out to SDE. When I run it all I get returned is Error running translation. I have sent it to inspector and I can see what I want so it appears to be having trouble when it gets to SDE. Any ideas?

@dmitribagh and @mark2catsafe created a railway in minecraft using a spatial relator to examine adjacent points to determine the orientation for the rails. See https://knowledge.safe.com/articles/1064/how-to-make-minecraft-worlds.html. However the "complicated" condition definition for adding the block attributes only works in 2D and does not incorporate in z data for elevation or slope of the rails. Does anyone have some thoughts/ideas about how to expand on the condition definition to add the slope attributes? e.g. 2 Sloped rail ascending to the east. 3 Sloped rail ascending to the west. 4 Sloped rail ascending to the north. 5 Sloped rail ascending to the south.

I have a response from Azure's OCR service, which looks like this (full response attached):{    "language": "en",    "orientation": "Up",    "textAngle": 0,    "regions": [        {            "boundingBox": "316,555,1597,123",            "lines": [                {                    "boundingBox": "1515,555,398,29",                    "words": [                        {                            "boundingBox": "1515,555,82,23",                            "text": "CRMA"                        },                        {                            "boundingBox": "1608,555,154,29",                            "text": "Completion"                        },                        {                            "boundingBox": "1775,555,138,23",                            "text": "Document"                        }                    ]                },                {                    "boundingBox": "316,632,556,46",                    "words": [                        {                  

Hi, I want to add different suffix to different attributes, 'Filename' in a jason-file. FilenameSuffixABC_123DEF_456GHI_789JKL_102MNO_103PQR_104I have managed building a list with the added suffix, and tried unsuccesfullty to replace the array value using JSONUpdater.  Another approach I tried was to merge the generated list using Featuremerger. I get the correct lists, but are unable to write them as a JSON-file. Any suggestions? {"name":"MAP_SUFFIX","type":"FeatureCollection" ,"crs":{"type":"name","properties":{"name":"EPSG:25832"}} ,"features":[ {"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[1,5],[1,2],[1,2],[1,2],[1,2]]]},"properties":{"filename":"ABC"}} ,{"type":"Feature","geometry":{"type":"Polygon","coor

Hello, I have a 2D City Map .*dxf file. I draped my city map on digital terrain model to obtain a 3D city map. It works fine but when I try to use .*dxf/.*dwg writer, ? see this problem. "AutoCAD Writer: Encountered a feature with inconsistent Z values, and type 'autocad_lwpolyline'. For this type, only geometry with constant Z values, or 2D geometry are supported. Dropping Z values"In my output, the geometry which consist of 'autocad_lwpolyline' does not have Z values. Is there any way to solve this problem?

How to download Google Map in KML .

Hi, I have a wokflow that reads PDF files and validates them. The workflow works great on Cloud as well. However the PDF reader doesn't read all PDF files and seems to be dependent on what software they were published in. So if I try to read invalid PDF's there's simply no output. This is a problem if you want to at least get a list of what files are invalid.   The problem was solved by using a directory reader instead along with a feature reader that reads a list of PDF's. The problem is now that it doesn't work to upload a folder to Cloud in the same drag n drop manner I used before.  Is there an alternative way to know what you can't read?

How can I write attribute MSG to a PDF as text ID MSG1inside the polygon2outside the area3close to the event area4comment

I'm using the OSM PBF reader in FME 2018 to extract highways. I want to split the highway lines into segements, so that each line only contains 2 vertices (the "from node id" and "to node id"). What I am interested in are the underlying node ids.I've tried reading the PBF, both as OSM feature types and primitive types, but neither seems to expose the underlying node ids.I can get to the node ids using the OSM XML Reader, but the XML file is far larger and I will need to process the whole road network for Europe, hence the use of PBF.Looking at the forum seems to suggest that either it's not currently supported or to use Python.Is there a simple way to expose the underlying node ids using the PBF reader?

I'm unable to run a Workbench on FME Server 2017.0.1.1 that reads and writes to a feature service at ArcGIS Online. I've read the other streams related to this but can't work out the correct workflow, or if we have some problem with the server accessing the online resources for OAUTH2 from inside the corporate network. The workbench works from FME Desktop 2017.0.1.1 with no a problem.I've created an app at ArcGIS Online to obtain a Client ID and Client Secret with the redirect Uri of urn:ietf:wg:oauth:2.0:oob and this all works in Desktop. These same elements were entered into the "Client Information panel" of the Web Service page in FME Server for service "Esri ArcGIS Online". I then created a new Web Connection "g9k Esri ArcGIS Online02" using the  "Esri ArcGIS Online" Web Service defined above. I can then use the "Authorize" button and enter the AGSOL credentials...After clickiong on Sign In", we get a code string back from OAuth2 Approval with "Please copy this code, switch to your

Hi. I'm trying to read features from a WFS service. I can read the features ok based on a spatial filter but the option to use a WHERE clause on an attribute does not seem to be available. Any idea how to fix this?