Using readers and writers to extract and load data.
Recently active
I'm trying to upload a file from a folder with name luleå but FME change the character å with \\xE5 in the folder path and FME cant find the file and terminate the workbench.Is there something to do so fme does not change the character?
Hello,I've installed FME Desktop 2018.0 Database Edition.When I open an existing FME Workspace with a AGOL Reader I get the following error when I run it:ArcGIS Online Feature Service Reader: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='www.arcgis.com', port=443): Max retries exceeded with url: /sharing/generateToken?f=json (Caused by ProxyError('Cannot connect to proxy.', error('Tunnel connection failed: 407 Proxy Authentication Required',)))'A fatal error has occurred. Check the logfile above for detailsIf I try to add a Web Connection to my AGOL Account; after I enter my authentication details I get a error I am going through a proxy server.Any ideas?Thanks Helen
Hello,I am having an issue with OSM values (in a FeatureReader). For some reason, there are level and layer values set to 0.5. Even if it is quite unconventional, "there is an ongoing discussion on usage of fractional values". Thing is, it seems that FME does not handle this case, I get the following error :|FATAL |Feature Type: `waysStringFormatter_OUTPUT'|FATAL |Attribute(encoded: UTF-16LE): `bridge' has value `yes'|FATAL |Attribute(string) : `fme_feature_type' has value `highway'|FATAL |Attribute(string) : `fme_geometry' has value `fme_line'|FATAL |Attribute(entangled: string): `fme_type' has value `fme_line'|FATAL | entangled to [xml_type]|FATAL |Attribute(encoded: UTF-16LE): `highway' has value `footway'|FATAL |Attribute(64 bit integer) : `id' has value `271462128'|FATAL |Attribute(encoded: UTF-16LE): `indoor' has value `yes'|FATAL |Attribute(encoded: UTF-16LE): `level' has value `0.5'|FATAL |Attribute(encoded: UTF-8) : `roadsWidth' has value `'|FA
I have a pipe-delimited text file for inputThere is no header line of column names. Data starts on the first line.How do I set column/attribute names?I tried AttributeRenamer, but FME gives column names drawn from the first line of data. I receive a new input dataset each month, and the first line of data will change. I want to be able to assign column names based upon their order, not upon the first line of data. I need this process to be repeatable with a new input dataset.
I receive a driver not found error using the URI and when I point to the derbyclient.jar file
Hello everybody,I'm using this template https://hub.safe.com/templates/citygml-create-solitaryvegetationobject-with-implicit-representation to create a CityGML file that contains trees as SolitaryVegetationObjects with implicit representation. The template works fine but doesn’t serve my purpose as I want to use the data in the 3DCityDB which doesn't support MultiGeometry features. Is there a way to change the gml_geometry?Thank you for your help.
Hi, I'm trying to get the links from this URL using the CSV reader but it does not work: https://data.geo.admin.ch/ch.swisstopo-vd.amtliche-vermessung/meta.txt Using an HTTP Caller did not work either. If I paste the link in a browser it works fine. Any idea what I am doing wrong? Thank you for your help!
Hi,I would like to know how I can call an FMW file from my clients website.Thanks
FME 2018 seems to have removed my two preferred methods of using bookmarks: 1) Without a filled background - it's too distracting to be always on; 2) No description anymore. Much neater and compact than annotation and the 2018 examples still waste too much space. Can we please have these back as an optional behaviour? I can't even edit workspaces with description anymore!All you are encouraging me to do is to STOP using bookmarks!
I have a problem with writing the multiple sheet output to excel but keeping only the attributes that are relevant to each sheet. For example (as you will see on the image) SAC_NAME should only be in the sheet named Special Areas of Conservation and should not be present in the sheet Wood Pasture and Parkland... and vice versa the PRIHABTXT attribute should not appear in the sheet Special Areas of Conservation... What I get now are columns of empty attributes.I tried to use PythonCaller to remove the empty attributes but it did not work, since the writing actually happens in the writer and PythingCaller is before the fan-out happens (I imagine that before fanout all is in one sheet and none of the columns is entirely empty).
Hi, was wondering whether there is an option to read all the features from a feature class in a SQL Server geodatabase or SQL Server spatial table before they get written to an ArcGIS Online (AGOL) feature layer when I click the run button in the toolbar. The problem I'm running into in our environment is that part way through writing to AGOL I get an error like the following "Microsoft SQL Server Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `[no query]'. Provider error `(-2147467259) TCP Provider: An existing connection was forcibly closed by the remote host.".Thanks.
Hello,I am having issues when using the GEODATABASE_SDE writer in the below environment. I am referencing the sde connection file from a FME Server resource location and then override the credentials within the workspace. The log shows it getting to the below lines and just hanging forever. When I swap out the writer to be SDE30 it has no issues at all and completes as expected.I am at a loss as to what may be going on. I guess I could use the SDE30 writer but I would really like to understand why the more recent GEODATABASE_SDE isn't working. Last three lines of log:-FME API version of module 'GEODATABASE_SDE' matches current internal version (3.8 20170315) -An ArcGIS license is already checked out. The product checked out is 'Advanced' -Installed ArcGIS version is '10.5.1'Environment:FME Server 2017 on windows server 2012SDE database 10.5.1 on top of Oracle 12cAny help would be much appreciated!
Is there a tool or workflow to remove or classify overlaps in a LAS file?
ESRI file geodatabase into MapInfo TAB format. Partial conversion only in that some records have data missing
I'm trying to build an ECW from OS tiff tiles. I get the Change Only Updates so have several folders with the base data and monthly files with the quarterly changes.What I'd like to do is use the latest tile from each of the folders, but I'm not sure how! Is it as simple as sorting in date order, so the newer file are laid over the top of the older?TIABen
Hello,I noticed while migrating some Shapefiles to MSSQL Spatial that there's a Geom column which is added. In which format it is encoded ? And does it countain all the spatial data required informations to restore and draw all the stored features ?thank you
In a workspace I'm writing to a gdb (api), this works fine. If i use this workspace again it results in an error: FME can't write to the GDB. Parameter "overwrite existing database" = "YES"MDB gives no troubles
Hello,I am transforming DGN files to ESRI shape using (Attached bellow). I have a problem with shared cells elements. I am transforming them to point shp but I am losing attribute NAME. I am suspecting that some of the format attributes are not checked. Any ideas how to get attribute that i need?
I am converting dataset from ESRI geodatabase to shapefile, but I am facing the domain problem how could we expose the domain , I am still getting only the code thanks
A customer who is using FME to connect to our recently upgraded database is reporting that a process for pulling data that was working before the upgrade now seems to just hang after a few minutes. We have SQLNET.EXPIRE_TIME=4 in the server's sqlnet.ora which means we check for dead sessions at 4 minutes. The FME log does not report any errors. It just stops logging and performs no more work.
Does anyone have experience getting data from Petrel Studio with FME? Any tips appreciated!Petrel E&P; Software Platform https://www.software.slb.com/products/petrel
I am trying to convert a drawing from Autodesk Plant3D to *.IFC format for consumption by a third party BIM viewer. I want to bring over as much of the intelligence from Plant3D as I can (part names, etc). When I convert from the FBX, all I get are the surfaces as a part name. If I convert from the dwg, everything is still lines. Is there an established method to get from Plant3D to IFC?
i need to classify the lidar point cloud to building alone. in las classify tool it classifies into building trees etc. how to classify only building?
I used a CoördinatExtractor and a ListExploder to get the Coördinates. I create a attribute to write the x and y coördinates in one line. Now the question is how can I create the last line whit only end?example:pnt 111223, 513248pnt 111225, 513256END