Using readers and writers to extract and load data.
Recently active
Like a poster who previously posted a similar question moving from 2015 -> 2016My WFS reader has suddenly stopped working in 2019 moving from 2016.I get the following error message Sending HTTP 'GET' request to 'http://spatial.bom.gov.au:80/cgi-bin/mapserver/users/bomw0296/wxs?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetFeature&TYPENAME=IDQ65470_wtr_lvl&NAMESPACE=xmlns%28%3Dhttp%3A%2F%2Fwww.opengis.net%2Fwfs%29&MAXFEATURES=1000', waiting for response ...Parsing XML document 'http://spatial.bom.gov.au:80/cgi-bin/mapserver/users/bomw0296/wxs?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetFeature&TYPENAME=IDQ65470_wtr_lvl&NAMESPACE=xmlns%28%3Dhttp%3A%2F%2Fwww.opengis.net%2Fwfs%29&MAXFEATURES=1000'HTTP transfer error: 'Couldn't connect to server'XML Parser error: 'Error in input dataset:'http://spatial.bom.gov.au:80/cgi-bin/mapserver/users/bomw0296/wxs?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetFeature&TYPENAME=IDQ65470_wtr_lvl&NAMESPACE=xmlns%28%3Dhttp%
Hi All,I have installed FME 2017 64 bit and ArcGIS 10.5 64bit geoprocessing tools. I am converting SDO geometry to ST_Geometry. While writing the features I am getting Unable to convert value taken from Z_ORIGIN keyword to a float data type issue. I tried all the possible ways, still no luck. Could any one help on this??
Hello, I'm working with a Excel file from an institution in México. It is a list of people, there is 22 registers.It is like this:#NOMBRE1SANCHEZ HERNANDEZ Pedro Antonio In México, people's name is composed of three parts: Fiirst Name + Father's Last Name (FLN)+Mother's Last Name (MLN). Usually the register in an Excel Spreadsheet is: a column "Nombre" (NAME) then we can read in a row, for instance: "Pedro Antonio SANCHEZ HERNANDEZ". It is not useful for filtering using for instance Last Name.So, I want to split this column and creating two news attributes: Apellido and Nombre. where Apellido will contain the Last Name and Nombre will contain First Name. In the spreadsheet, the string begins with the Last Name = The FLN + MLN, then it comes the First Name, usually is a combination of two first names, eg: Pedro Antonio (Peter Anthony). There is a blank space between all the names.
Want to find an equivilent to autocad_layer_plottable attribute for DGN files to check if a level has plot turned on.
Hello,I am new to JSON formatted strings and have spent a few hours trying to split out some content with JSON Extractors and Fragmenters with no luck. I have an array of 10 "items" which I need splitting into separate features. What I need to pull from each item is the publishedParameters list (as a split list) and WorkspacePath. So they resulting objects should be formatted as such:Item# ¦ WorkspacePath ¦ publishedParameters0 ¦ "APIrepository_prod....." ¦ "name": "user_email", raw: "Glenn.sayers@halliburton.com"0 ¦ "APIrepository_prod....." ¦ "name": "cell_size", raw: ""0 etc.1 ¦ "APIrepository_prod....." ¦ "name": "_layers_other", raw: ""1 ¦ "APIrepository_prod....." ¦ "name": "_layers_gde", raw: "present_nonclipp
Hi everyone, I'm new on FME Desktop.I need to create a kml from excel, with some specific format (see screenshot below)I haven't been able to put the balloon code into KML PropertyFormatter transformation tool. Any help would be appreciated!Please find the example kml file attached.Thanks a lot!
Hi,I have a model where the readers change a lot so I have to update regularly but I have noticed that it does not work through the update reader.The only thing that works is save the fme model, close it and open it again.Am I the only one who bothers that?I'm working with FME(R) 2019.0.0.0 (20190328 - Build 19238 - WIN64)
I need to read secured map services (not feature services) from ArcGIS portal into my workspace. Before upgrading to portal, I was able to use the HTTP caller to access the REST services. Now I'm trying to use the Esri ArcGIS Portal Feature Service reader, which obviously isn't working because they are not feature services. Any ideas on how I might access the secured services? I don't think I can still use the HTTP caller because our access is windows authenticated (NTLM), therefore getting tokens is not an option.
When I'm using the Adobe Geospatial PDF reader it seems to me that the Raster Size parameters are always greyed out and can't be altered. Am I maybe overlooking something, or is this a bug?The following screenshots illustrate the issue. When the parameter 'Read Rasterized Pages' is set to 'No', the Raster Size parameters are greyed out (and also the 'Raster Size' 'group name' is greyed out.)However, when the parameter 'Read Rasterized Pages' is set to 'Yes', the Raster Size parameters are still greyed out (wheras only the 'Raster Size' 'group name' changes to an 'exposed state'.).I'm using FME Desktop Oracle Edition, FME(R) 2019.0.1.0 (20190506 - Build 19253 - WIN32).
Hi allI have a simple IFC file which has just 8 IFCWalls and 2 IFCSpaces. When I run a simple query for retrieving all records for IFCSpace elements ( select * from "public"."IfcSpace"; ) , SQLExecutor duplicates all records. For instance, I have 2 records for IFCSpace but after running the query, I'll get 4 records. How can I avoid duplication? (I use PostGIS)
We're frequently being asked to use authentication providers other than Active Directory for securing and providing access to FME Server, eg. Cognito, Azure AD. Has anyone attempted to use nginx to reverse proxy to FME Server and handle the authentication via SAML? Is there a way to get around the double login (e,g, login to nginx, and then login to FME Server)? Could you create a role that has very limited access (or use a FME Server app with a long expiry token) to get around the double login and provide basic access?User -> nginx reverse proxy (authenticated) -> FME ServerSome more context provided here: https://github.com/safesoftware/fmeserver-nginx @pallegama
When writing to a geopackage, is there a method to add metadata?
Hi, I've set up a workspace that utilizes a SKP feature writer and reader before writing to FBX using a reguler writer. This works perfectly well on desktop, but I'm having trouble adapting it for Server. The workspace stops all features at the feature writer with the log message "Features not written - verify feature type fanout/dynamic settings - (Check that fanout/dynamic feature type attribute exists and has a value)". I've tried many different settings in the writer, also using dynamic schema but nothing seems to work.I've been searching for examples of use of feature writer on FME Server on this forum but have been unable to find any. I would really appreciate some tips, in the meantime I guess I have to split up the workspace into several workspaces and run them with a workspacerunner...
Hello You,Do you think it would be possible to add text on a curved line or a circle?Just like this.
Hi all, I'm using a feature reader to query a feature class stored in portal using a where clause, however i want to capture and handle the event if no records are returned. Currently fme will just stop and no longer progress if nothing is returned. Any ideas on how to resolve this? Cheers
I'm reading a DWG file with the above reader and I'm finding that some features have different values for fme_feature_type and autocad_layer. Example: fme_feature_type = RR ALIGNautocad_layer = 0 From reading the reader description here I assumed that fme_feature_type is created from the AutoCAD layer name which is held in autocad_layer:"In AutoCAD, the layers are used to store collections of logically related entities, attributes, or symbology. In FME, the AutoCAD layer and the type of the feature are treated synonymously, since there is a one-to-one correspondence between FME feature type and AutoCAD layer." Is there a reason why sometimes these two attributes do not correspond or is there a bug? Thanks!(FME Desktop 2019.1.3.1 19643 WIN64)
Encountering issues while reading FGDB from .zip files stored under resource folder:-"Unable to connect to File geodatabase. Please make sure the correct file name was specified..."
Hi, I have a lot of DXF files and want only specific layers from this data. Additionally I have an excel file with all layers I want to filter in one column.How can I use the excel file as kind of a filter for the DXF files? The names of the DXF layer are pretty long and it would take to much time to write them all in a testfilter. Thanks and best regards
In Oracle, i have a column called GEOM of SDO_GEOMETRY type. After running FME, GEOM column containing NULL values it is not getting populated.Could you please help me?
Hello,Trying to create a web connection for Google Sheets in FME desktop 2019.1. The email I'm using for authentication is a shared email address. Getting incorrect password alert returned. I know the password is correct.Is it possible to use a group inbox to create a web connection to Google Sheets? Or does the account need to belong to an individual?Thanks
Bonjour,Dans mon workbench, j'ai plusieurs sortie (Writer) qui doivent toutes s'enregistrer dans le même dossier : j'ai 4 sorties CSV qui fonctionnent sans probléme.Mais j'ai 2 sorties qui ne veulent pas s'écrire, j'ai le message d'erreur suivant :"TEXTLINE Writer: Cannot create dataset: 'C:\\Users\\B09278\\Documents\\2_Projet\\6_DATAPOSTE\\2_Moulinette_integration\\Fichier_integration' of type Directory, expected a dataset of type Regular file"J'ai essayé plusieurs formats de sortie sans succés (CSV, XLS, Txt). Je n'arrive pas à comprendre pourquoi ces fichiers ne s'écrivent pas.Pouvez-vous m'aider?Merci d'avance, ~~~~~~~~~~~~~~~~~~~~~~~~~~Translated: Hello, In my workbench, I have several output (Writer) that must all register in the same folder: I have 4 CSV outputs that work without problem. But I have 2 outputs that do not want to write, I have the following error message: "TEXTLINE Writer: Can not create datas
Hello,I Have an error when I want to use a reader to a Non spatial Hana Database (see image below)I have a user that can only access table IFLOT for readTo you have any idea ?I use FME Desktop 2019Thanks
Good day,I have a working FME Server 2019 environment and would like to use the FME DataExpress app on my phone to access FME Server (and server apps). Our company uses MobileIron to secure Apple-devices and set up tunnels for communication.This way it must be possible - at least theoretically - that the IOS-app can connect to our FME-server that is behind our corporate firewall and NOT part of our DMZ.At the moment, it doesn't work and I made an appointment with our system and network engineers. I think we might open some ports in our firewall. Is there any technical information available about the communication (IP-addresses, UDP, ports, etc.) we need to know in order to configure the firewall.Thanks in advance,Frank van Doorne
Hello everyone,I've got a certain problem that I can't solve for many days. I'm trying to find the overlaying areas between an IFC file and an ACAD one. I explain the idea, the purpose is that I've got 2 readers as entries : one for IFC and one for ACAD. then the we need to find the spatial relation between each objects of the IFC and the zones drawn in ACAD. --That point is OK. Then for the objects which have 2 _related_candidates, I would like to calculate the overlaying area with each zone to keep only the one with the biggest overlaying area. My problem right now is about that second step that I can't solve for the moment. I hope it's clear enough and you'll be able to help me with this matter. Regards,Clem
Hi, I use a polygon > boundsExtractor > OSMDownloader but i get error OSMDownloader_HTTPCaller (HTTPFactory): HTTP/FTP transfer error: 'Couldn't resolve host name'OSMDownloader_HTTPCaller (HTTPFactory): Please ensure that your network connection is properly set upOSMDownloader_HTTPCaller (HTTPFactory): No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered. What did I miss?