Data

I am trying to upload to our Open Data site powered by Socrata. I did enough research that I saw I would need to change the data to something Socrata would accept. But if I tell the writer it is a 'calendar_date' field, the schema is uploaded, but no records are created.

Hello, I have a dwg file in Reader with existing layers. I would like to know if you know how to match the Dwg file in Writer again. I use ShemaMapper this to have worked, however in output Writer I always have the same layers. Please help me if you know a solution.

Hello,I'm trying to merge a GeoTIFF orthopotography file and a CityGML file with into a single SketchUp file.With FME Workbench, I have visually the result I want in SketchUp: Do you have an idea of how to do this?Thank you in advance!

I'm in a serious dead end - whatever I do, I can't export files with FME that would show in Blender. I have tried to export both in OBJ and FBX, but they don't appear. I can import the file, but nothing shows. My original file is in WFS format and looks just like it is suppose to in the FME data inspector. When I create a writer it makes the files and they appear in the folders they are suppose to. However when I try to open them with Blender, Unity or with Autocad I can't see any buildings that I exported. I can just see the contollers, looks like empty game/3d object.  Can someone share their workflow when importing to blender 2.8? Is there some tickbox or selection that I should use?  Oh the same file OBJ file I have managed to open with 3D Builder, but the 3D builder asks me to locate every singe texture surface (over 20 in one element) separately. Does this give any hints what I'm doing wrong wit

Workspace has just ESRI Geodatabase reader and SHAPE file writer (FME 2019 version) as I'm trying to write to a shapefile.In Shapefile writer, few attribute definition names are being shortened(truncated) but retains the same data type(as reader). Tried to rename those shortened attributes(in writer), but still it reverts to shortened version. Thereby causing difference in schema definition between reader and writer.This is the case for all different types of Attribute Definitions - Automatic, Manual, Copy from Reader..I think I've tried possible workarounds, but still same issue. Any thoughts please? Thanks!

Can anyone explain the purpose of the extra xsi_nil attributes that accompany a Web Feature Service (WFS) data source?For example, when I create a WFS reader in FME for the topp:states demo layer of a stock GeoServer, the resulting table schema in my FME workspace includes extra attributes - one for each native attribute - named <attribute>_xsi_nil. Here's a screenshot highlighting the fields in question:The data type for all of these xsi_nil fields is xml_boolean. This happens for all WFS layers I consume from a GeoServer.What is the purpose of these extra fields?And is there a way to configure the reader - or the GeoServer layer - to not cause these extra fields to be created?Thanks

Hi,I'm working on creating a workspace with ESRI Geodb reader(or Feature reader) and writer for creating zipped shapefiles (with dynamic naming convention to zipped shapefile like yyyymmddhh_export for every run on schedule). The idea here is to have 'yyyymmddhh' dynamically updated for filenames whenever it is created on a schedule.Finally upload those files to SFTP server on a schedule.I've tried this in FME 2019.2 with using FeatureWriter and ZipArchive transformers, but not quite there yet. Finally to upload to SFTP, not sure if FTPCaller is better option or Automation with 'Upload to SFTP' action is viable options. Please suggest if any ideas. Thanks!

Hi FME Community  I have encountered an issue that I cannot find the solution for.  I have a Reader -> Writer setup. Reading from a MSSQL db and writing to a Postgres.  When reading the table and making a preview, everything looks as it should be. Then I run the transport and looking at the preview of the writer after a successfull termination of the task.  And this is what I see Even though I've made a Scheme called 'dbo'. and the DB-connection setup is successfully co

Hello.I have a next situation.I own a list in Excel with the streets of a certain area of Romania (Bacau County)I take the example this streets : AGUDULUI, ALBA IULIA and ALECU RUSSOOn AGUDULUI Street I have the even numbers from 2 to 10 on one side of the street and on the other side of the street are the odd numbers from 5 to 13.Tabel 1.Where:MIN_EVEN – the lowest even number on the streetMAX_EVEN – the highest even number on the streetDCOUNT_EVEN – the number of even numbers appears on the streetMIN-ODD - the lowest odd number on the streetMAX_ODD – the highest odd number on the streetDCOUN_ODD- the number of odd numbers on the streetTabel 2.I would like to create

Hi, I am new to FME and am excited to get started. I have a task that should me simple, however I am not sure how to go about it. Here i attached one picture where the White color is full of my study area. I do not want to see this color. I have to inform that i make a boundary to my dxf file when it is converted in kml file may thats why it is full of White color in my study area beacuse other part is not fyllup with white color.Do you have some good solutions?Thanks!

Fail when converting ecw file. Got error message after FFS writer: Completed 100% of intermediate processing____________________________________________________________FFS writer: Completed 0.18% of intermediate processing... Last line repeated 3 times ...ECW reader: Failed to retrieve data from the source datasetStored 1 feature(s) to FME feature store file `J:\\FME_TEMP\\wb-cache--PNXtVL\\Main_EsriReprojector -1 3 fo 0 REPROJECTED 0 66d791aea5c163f33c7ab04cb5e7a95a424ee21e.ffsupdating'Saving spatial index into file 'J:\\FME_TEMP\\wb-cache--PNXtVL\\Main_EsriReprojector -1 3 fo 0 REPROJECTED 0 66d791aea5c163f33c7ab04cb5e7a95a424ee21e.fsi'Finished saving spatial index into file 'J:\\FME_TEMP\\wb-cache--PNXtVL\\Main_EsriReprojector -1 3 fo 0 REPROJECTED 0 66d791aea5c163f33c7ab04cb5e7a95a424ee21e.fsi'EsriReprojector_REPROJECTED Feature Recorder -1 2147614723 (RecorderFactory): Failed to write featu

Hello, I create a workspace from DWG to an Excel File with a Template File.  I fullfill columns CODE, X, Y and Numero.  I wish to complete in the header the values below with attribute I have from a Block in DWG :  - N° mesurage - Affaire(s) - Commune de - SectionCan you help me to make this or can you give me an other way?  Thank you  Best Regards  

Hello everyone,I've had a problem with Object Data readerfor a few days now.There is a file with objectdata on it that I want to process, and keep it as AutoCAD Map 3D Object DataThe problem is that no matter what I do, he always gives me this error message:Even if I'm not doing anything in the process, just passing from reader to writer.Does anyone have a clue what it could be?Attached is the DWG file I want to process.Thanks!

Hello, When I open my Dwg file in autocad I notice that I no longer have any vertex in my output Dwg file after performing the transformations, can you help me recover them? here is my FME file if you could correct it for me or add the transformers necessary for it to work. thank you in advance

Hi everyone, I'm a new user of FME. i'm trying to create a CityGML LoD0 and LoD1 based on a study area in DWG and point cloud data.I have followed the steps in the links below that are related to my task:https://knowledge.safe.com/questions/56991/citygml-file-with-lod1-and-lod2.htmlhttps://knowledge.safe.com/articles/1353/point-cloud-to-3d-terrain-model-with-buildings-dwg.htmlI can preview the data before the writer and it looks OK, with the footprint and the solids highlighting when one feature is selected but the writer is giving me the error: CityGML Writer: Geometry conversion error - Unable to convert the 'IFMEAggregate' into a single 'IFMESolid' geometry, because the aggre

Hi there,  I'd like to insert data into a postgis datebase. The destination table is already created. Unfortunatly, the translation fails due to a geometry problem :    Bulk copy failed on table 'az.eu_collecteur' using delimiter ':'. Error was 'ERREUR: Geometry type (LineString) does not match column type (MultiLineString) CONTEXT: COPY eu_collecteur, ligne 1, colonne geom : « 010200002015550000020000007B14AEC7C07C2041AE47E17ABE0403410681...' A fatal error has occurred. Check the logfile above for details    How can I transforme my source data form LineString  to MultiLineString ?    Any ideas ?    thank's in adavance.

Just spotted this problem in my corporate data extraction workflow.So it is pretty straightforward, a dynamic ESRI Geodatabase SDE FeatureReader that dynamically reads the schema of the Target Feature Classes/Tables from the SDE server.However, it appears to struggle when there is a Domain on the Field. Where the option to "Resolve" the Domain to a separate "_Resolved" attribute is used that contains the Domain Description values, it instead reads the Schema for the relevant base field as TEXT rather than as LONG (meaning both Base attribute and the Resolved attribute get a TEXT data type assigned in the Schema Feature)That creates an issue when flowing that to a Dynamic FeatureWriter which uses the (incorrect) Schema Feature Data Type to write it out to a Text field rather than a Long.Anyone got any Workarounds? I'm thinking the only way to do it is to manually override the Data Type Attributes in the Schema Feature by doing a sep

Hi everyone, I'd like to divide (extract) my point cloud data (LAS, forest) by elevation of points, e.g. one dataset would be points from 0-2 meters, 2-5, 5-10, etc., please share a good and simple tool in FME, thanks in advance!

Hi, I guess the title is pretty self explanatory, here's some screenshots.Went from this surface model, that has been clipped by shapefile of buildings with average Z value of pixels within each of polygonsto this... (tilted view)and need to extrude the point cloud to preferably ground or at least a fixed value that will go through the ground (might clip them later, not really necessary). Basically trying to to "extend sides to ground" function from Google Earth Pro but with point cloud (I do have the terrain DEM as well, doing this approach because I don't want vegetation in my final result and the terrain DEM has better resolution)

I am reading a large ECW version 3 file into FME and then clip it. After this I want to write in to an ECW version 2. Everytime when I do this I get the following warning: ECW writer: Existing value for creation option 'ECW_FORMAT_VERSION' was '2'. Overwriting with the new value '3'.Is there any way I can turn off, the automatic overwriting of the version number? I really need the final output to be an ECW version 2.Thanks in advance!

UPDATE: The error was not any hidden files in FMECloud - but rather that the process using AzureFileStorageConnector downloaded a whole FOLDER instead of individual files. So instead of downloading a file of size 0,5 GB - it downloaded all the files in that folder (50GB). Havent figured out why yet, but might be something between the screen and the person sitting in front of the computer.  I have a FMECloud instance with 100GB Primary disk, and it seems according to the Dashboard that 97GB is in use. I can only find roughly 60GB in the DATA-folder. And FME Cloud seems to run the cleanup. So i wonder where the missing 40GB of data is. The projects uses a lot of raster-data, so I wonder if they are cached somewhere, or if the FFS is somewhere. But cant seem to figure out what to empty.Moving to a larger instance might be a solution, but Backup 100 GB, download, start new instance 200 GB and restore takes some time....Would be GREAT to be able to RESIZE the

When attempting to use an existing table in a PostGIS database, the PostGIS writer is coercing my 3D geometry objects into 2D. I have not seen this issue with a PostGIS writer that uses automatic table creation and the data type for the geom column is defined as GEOMETRY in both cases.I have seen 2 different warnings regarding this:POSTGIS Writer: PostGIS existing table has a 2D constraint, changing input data into 2D datacoerced to 2D in table 'cad.cad_geom'Why are the objects being coerced?Are there writer settings to prevent this from happening?Here is the table definition:CREATE TABLE IF NOT EXISTS cad.cad_geom( id                      BIGSERIAL    PRIMARY KEY, created                 TIMESTAMPTZ  DEFAULT CURRENT_TIMESTAMP, updated                 TIMESTAMPTZ  DEFAULT CURRENT_TIMESTAMP, xchg_ts                 TIMESTAMPTZ  DEFAULT NULL, _refid                  BIGINT

Hi all,I'm trying to create a workflow for creating LoD2 CityGML from a shapefile of building footprints (and forcing a height attribute) and I am struggling with few issues. I would like to have the buildings composed of wall, roof and floor surfaces but I haven't been able to work out how to compose the surfaces within a single building while also generating the relevant semantic feature types for these surfaces. I'm aiming for something similar to what I want is the LoD2 sample in CityGML 2.0 examples: http://schemas.opengis.net/citygml/examples/2.0/building/Building_LOD2-EPSG25832.gmlSo far, I am simply offsetting a the shapefile to create floor and roof geometries. I also generate a UUID for an gml_id (for the Building) which I thought I could reference from the roof and floor surfaces LoD2 features in order to nest them. However, upon running th

Hi guys, I do have an issue working with KML on FME. 1) I have a shp file with loads of features and I would like to transform each one of them in one specific kml file. The pic below show us the features I have:I do want to transform them into individual kml files , with an specific name ( i have this information on the file). And I also need that the kml looks like this: I couldn´t manage to make them hollow like this. Can anyone help me? 

I did everything right to set up the Teradata format in FME. I followed closely the documentation here: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/teradata_jdbc_spatial/teradata_jdbc_spatial.htm. However, when I start FME, I'm still not able to use the Teradata format. What gives?