Data

Moin.I think there is a problem with the PostGIS-writer and the new PostgreSQL version 10. In PostgreSQL 9.6 there were no problems. Since I installed the version 10 of PostgreSQL (with PostGIS 2.4.1) the following error is thrown:Error executing SQL command ('SELECT AddGeometryColumn('test', 'myTableName', 'geom', 3034, 'GEOMETRY', 2)'): 'ERROR:  Schema 'test' is not a valid schemaname"test" is not the schema name, it is the database name. The schema isn't recognized in this command.Matthias

Hi,I'm trying to import a Microstation cell library as symbology in QGIS. I've managed to change the .cel files (the cell library) to a dxf file. I've also managed to convert that dxf file to xml in FME, with just a reader and a writer (no transformers). The translation went succesfull acooording to FME. However, when I import the symbology in QGIS, I get an error:Incorrect root tag in style: fme:xml-tables.What am I doing wrong? Should I use some kind of transformer? I just applied the default parameters/settings when translating. Should I change a setting in order fot the translation to succeed?

Hi, I am just doing an simple update on 10.2 ArcFM database using FME in an edit session. It gives me an error: The error number from ArcObjects is: '-2147467259'. The error message from ArcObjects is: {}. I can not figure out why.

I have a FME ETL Tool added to a ArcMap toolbar which calls a workbench I've created.  The tool runs and produces the results I want, but after reviewing the log files that were created, I see there is a comerrors-log-<date>.log file created.  Inside the file it states:  20140508-101739: HRESULT fail in file FMEArcToolboxUtil.cpp at line 111 20140508-101739: HRESULT fail in file FMEArcToolboxUtil.cpp at line 111  I'm not sure if I should be concerned with this or if I can ignore this.  I've googled FMEArcToolboxUtil.cpp but am not finding much about it.  Is this error safe to ignore?   

Hello!I have problems running a SQLCreator through FME Server. It fails to connect to the database with error message:"Error connecting to PostgreSQL database(host='limvir105', port='5432', dbname='geobim_telia_gbg', user='postgres', password='***'): 'FATAL: no pg_hba.conf entry for host "fe80::51ee:2c01:b3b3:c2f8%12", user "postgres", database "geobim_telia_gbg", SSL off"I have another DB on the same server that runs perfectly fine.Does anyone know how to solve this problem? 

How is KML successfully converted to DWG with projected coordinates?Converting from DWG to KML, the DWG's coordinate system is set at the reader, and the objects appear in the right place in GE when loaded. Converting it back from KML to DWG however, the objects are in the wrong place. For the DWG writer, the same coordinate system is chosen as before. I've tried using different coordinate systems in the KML reader, and also left both reader and writer empty and used the Reprojector transformer to no avail.The digits are wrong, so it's not a scale issue.Thanks for any help.

we have a simple workspace MSsql spatial reader and elastic search writer, but we are having this error, attached text file Any idea

I have a old version of arcgis (10.0) and need to connect to arcsde 10.2. This connection used to work but after a oracle upgrade on the server no longer works. My supplier tells me that i now need to upgrade my arcgis version to match, i don't want to buy a new arcgis but i do have access to arcgis engine 10.4. Can i use this to enable the a sde connection in FME?

Hi everybody I desperately need some help!! Here is my problem... So far I've been able to generate a bunch of different networks from my water pipes. I've also been able to use a fanout to extract them all to multiple PDF files, based on their network ID. Now, I'm simply trying to add some PNG images (North arrow, logo, etc.) on each PDF files, without any success?! At this point I've tried many things, but I'm now running out of ideas...As suggested on another thread (https://knowledge.safe.com/questions/2403/adding-a-logo-to-a-pdf-when-using-fanout.html) I was under the impression that by using a Cloner to get as many images as I had networks, then by using the PDFPageFormater to add the images to each PDF files or a RasterGeoreferencer to specify where I want the images to be located on the page, I would be able to achieve that but I couldn't figure out how... And speaking of the RasterGeoreferencer, I didn't find out how to use page units instead of rea

Hi all,I am trying to import AutoCAD .dwg files into Smallworld 5. However, the .dwg files have no specified coordinate systems or coordinates. The solution used before was to convert .dwg to .shp and geoference in ESRI ArcMap based on superficial info such as the street name in the .dwg. But we are trying to simplify and speed up the workflow by converting from .dwg to Smallworld 5.1.3 directly using FME. Does anyone have any idea at all if this is possible?

I`m trying to open a xml file with the xml reader, but I`m getting a XML parser error. Attached is the sample xml file. Who can help me?

Hi,I have a Workspace that Read two ( 2 ) files Polygons from Shapefile and generate with Success in ElasticSearch, but in Point geometry:My question is: How can i respect the geometry from my Polygons and write polygons in ElasticSearch?Attached the log file and Workspace template ( .fmwt ). - Thanks,Danilo

Is the FME Work Bench or Quick Translator able to translate ESRI shapefile to a Model Space AutoCAD format? If so, what is required within the shapefile?

I have a folder full of unzip (.shp) mixed shape files Points, Lines, and Polys. Can I read in only the points somehow?? If not can anyone recommend a way to restrict to schema to only that of the point shapes, which I have found two different ones so far?

Hi, I am facing an issue with converting GeoJSON data of building surfaces, directly to Cesium 3D Tiles. where the output is incomplete. A lot of the surfaces are missing.I was recommended to do an intermediate step of converting to CityGML i.e. GeoJSON >> CityGML >> Cesium 3DTiles. And this works fine, except that the output tiles.json does not contain the (maximum and minimum) values of the attributes, which I can generate in the former direct conversion method.   So here are my questions: 1- Why does the direct method (GeoJSON >> Cesium 3D Tiles) generate incomplete buildings? 2- Is there a way to edit the parameters in the conversion from GeoJSON to CityGML to Cesium 3DTiles, where I can still end up with the max and min values in my tile.json? 3- My GeoJSON are exported from my PostgreSQL database, so initially I start my data as database tables! Is there a method to connect FME to my PostgreSQL database and get a direct conversion to Cesium 3DTiles?    Thanks,

Hi, I am new to FME, need some help please.I need to convert AutoCAD dwg with some polylines and text into KMZ. Text includes hyperlink to .dst (dataset) file. How can I include hyperlink in KMZ file?Thank you !

Hi,I am trying to export sql data into an excel report template. for example: I need to pass a particular attribute to the cell A24. Any pointers?Thanks so much

In Microstation there is an attribute called "View Dependent" It has a toggle to either be dependent or independent. Is there a way to set the view dependencies during translation? Right now it seems to always translate as independent.

Hi,I am using FME 2017.1.0 (Build-17539) 64 bit on windows 10 64 bit.I am unable to use GEODATABASE_FILE writer, when i am trying, i am getting the following error message:The "Esri Geodatabase (File Geodb ArcObjects)" format is unavailable because it has unmet dependencies. Please check that FME and your installed, licensed ArcGIS are both 32 bit OR both 64 bit. Then contact http://www.safe.com/support if the problem persists.I have installed ArcGIS Pro as well on the same system. (Screenshot attached).Please help me with this issue.

Hi I am trying to write from one feature class, three separate tables to one file geodatabase but only the last table is saved. I do not know how to keep all three tables in the database. I am fairly new to fme. I am using FME 2015. I have tried with Format Parameters-Feature Operations, Update and Insert but both with same results.

we want to save data in one excel document but with multiples sheets, each one will have a specific group of featuresplease sheet the attached Image

I'm not getting the full geometry data after converting from shapefile to tde, as I did before, only getting a single row for each polygon in the input file, not the granular, ordered, list of geometry points.

Hi,I Would like to read a directory with 76 LandXML with one alignment each.Replacing the current name of each Alignment name with the basename file.and Place all the result in one LandXML or separately- I used the StringReplacer and replace the feature Name for the basename.Its working fine on the Inspectorbut cannot exporting the landxml file.I try to export all LandXML in one file and export all LandXML in basename alignement file..But having problem with LandXML exporter.Do you know how i can merge it ? Thx!

According to the Elastic documentation: "The 'nested' type is a specialised version of the 'object' datatype that allows arrays of objects to be indexed and queried independently of each other." Nested objects allow you to filter on multiple fields within the same objects in arrays.Is it possible to get the ElasticSearch writer to write the properties as "type : nested", as shown here:PUT /my_index{  "mappings": {    "blogpost": {      "properties": {        "comments": {          "type": "nested",           "properties": {            "name":    { "type": "string"  },            "comment": { "type": "string"  },            "age":     { "type": "short"   },            "stars":   { "type": "short"   },            "date":    { "type": "date"    }          }        }      }    }  }}