Data

Hi,I need to generate a single TIF file from multiple DTM files. Any advise please.Thank you

Hi all,This works in SQL Developer.Why does this not work in a SQL Executor/Creator?select to_date(736845 + to_char(to_date ('02-01-0001'),'J'),'J') t1,to_char(to_date ('02-01-0001'),'J') t0from dualoutput:T1 T031-05-18 1721425Fme executor insists `ORA-01843: not a valid month'which is totaly not true!  It appears that the 'J', julian format is not recognised.  Is this a error or am i missing something?Don't suggest out of sql solutions, i wan't it to be done in the executor. Be aware i will issue demerits !! ;)  SQL answers required. Greets an txia for your answers.

Hello everybody,I have met troubles with values in igds_snappable attribute of cells. In my source datafile (v7), insert point of cell is snappable, but elements of cell are not. When I open datafile in FME Data Inspector, it shows me that insert point and all elements are not snappable.If I change value of igds_snappable in Microstation for just 2 elements of cell, the insert point in FME Data Inspector is snappable, interesting...Is it bug or not? Have You ever met the same problem? I´m using FME Desktop 2017.1.2.1Thank You so much!Lubo

Hi,I'm after creating a series of profiles / cross-sections using a mapinfo table containing the lines to be driven through a DEM of the LAS point cloud. The output txt file should contain x, y, z, and chainage (from the zero point of the profile, (which should increase at 0.5m spacing)), and profile_ID (derived from the mapinfo table).Any guidance on how to achieve this would be much apprieciated.

Hello beautifull people, i have to make onversion from buildings from CityGML lod2 to IFC . but i get a the end of conversion in the Data inspector NO Geometry !!! i need your help how can i do it and why does not go ? Thank you

In the doc: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/citygml/citygml.htm?Highlight=citygmlThe part where the limitations are listed:The CityGML reader reads all parts of the Thematic and Appearance CityGML models with the exception of the Digital Terrain Models (DTMs) ImplicitGeometry and xlink:href resolution.is not really clear. Is there a comma after '(DTMs)'? Or do ImplicitGeometry are not read? (They are, I just tested!). Same for XLinks, they seem to be resolved (at least those internal to the file). So I'd like to know the limitations, if any.

Hello I am Looking to export the Geodatabase schema ( manay tables) without the data to an excel sheetcolumn 1: table nameColumn2: attribute nameColumn 3: attribute typeColumn 4:width

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