Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 7,078 Posts
  • 26,071 Replies
7078 Posts
bwn
Evangelist
bwnEvangelist
asked in Data
GEODATABASE_SDE Dynamic Reader - Reading Long Data Types as Text?

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 separate Schema Reader to override

120
bwn
Evangelist
K
kairat
asked in Data
Extracting LAS by elevation of points.

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!

780
K
A
adam5514
asked in Data
Raster of surface (buildings) to point cloud extruded to ground

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'm pretty new to FME, so simpler, more begginner-ish solutions would probably be better.

330
A
E
evieefkeeef
asked in Data
Reading ECW version 3 and writing ECW version 2

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!

1470
jakemolnar
sigtill
Supporter
sigtillSupporter
asked in Data
FMECloud - disk space usage

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 PRIMARY and Secondary disk of F

360
sigtill
Supporter
jspratt
Participant
jsprattParticipant
asked in Data
PostGIS writer: converts 3D geometry to 2D on existing table

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       DEFAULT NULL, autocad_block_name      TEXT , autocad_block_number    INTEGER, autocad_entity_handle   TEXT, au

1830
M
J
julian_
asked in Data
Citygml LoD2 from shapefile with floor, wall and roof features

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 the workspace, it appears only the Building feature is written out and the RoofSurface and FloorSurface features are ignored.Ca

1260
D
G
grazielatm
asked in Data
How to work properly with kml

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? 

290
ebygomm
Influencer
fmelizard
Safer
fmelizardSafer
asked in Data
Teradata Format Greyed Out?

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?   

170
rahulsharma
Safer
C
conzai
asked in Data
Issues with writing to versioned ArcSDE geodatabase

Having a couple of problems writing to a versioned ArcSDE Geodatabase:  1. When trying to import an existing feature type from the Esri Geodatabase (ArcSDE Geodatabase) writer I can connect to the geodatabase successfully and browse to the existing version to select the table I want to write to, but when I attempt to add the feature I get an ArcObjects error that the version is not found.  I can import features successfully from sde.Default but none of the versions.  This occurs when using a direction connection with OS Authentication, but I can import features when using an sde connection file that specifies the version, but it’s not ideal and I’d like to determine why I’m having issues.  2. When using the ArcSDE Geodatabase reader with the option to create a child version and then do a reconcile and post + delete the child state options on the ArcSDE Geodatabase writer, the edits and the reconcile and post are successful but I get an error when the translation attempts to delete the

700
brublanc
Contributor
S
san
asked in Data
Transparency issue while transforming OBJ to GLTF.

I tried converting a OBJ to GLTF.It got converted properly.But the gltf output is transparent.the mtl of OBJ is:newmtl textureNs 26.4d 1illum 2Kd 1 1 1Ka 0.2 0.2 0.2Ks 0 0 0map_Kd nzl_akl_003.png and the gltf output material is :"materials" : { "mat_0" : { "name" : "texture", "extensions" : { "KHR_materials_common" : { "technique" : "PHONG", "values" : { "ambient" : [ 0.2, 0.2, 0.2, 1 ], "diffuse" : "t_0", "specular" : [ 0, 0, 0, 1 ], "shininess" : 128 }, "transparent" : true } } },The transparency of the gltf is set true by default.How to change this while conversion.I dont want the model to be tr

151
nampreetatsafe
Safer
G
gisbradokla_t
asked in Data
Autocad map od reader entity id attribute being dropped

I have a workbench that I have been using for several days. all of the sudden when I open the workbench it will not run. I discovered that the reader does not show the exposed autocad_od_entity_key available any longer.if i go to a new workbench and pull in the same data the field does appear.

110
G
souryana
Contributor
souryanaContributor
asked in Data
DWG to SHP with associated attributes

Hi, I would like to convert a dwg file to shp file. The problem is that it contains a lot of attribute for each object. I want to convert the dwg file to shp where each object have the associated attribute value. Please see picture below. for example, "CJ" originate from a layer in CAD. I want that layer to have it own column in the attribute table for the SHP file.

2850
souryana
Contributor
A
adeel182
asked in Data
Postgres Database not being written to

Hi guys! I'm new to FME. So far the software seems great but I'm having an issue with the data in my database persisting. I have a setup where I've created a CSV reader connected to a Postgres writer. When I run it, everything is ran fine without errors. In the visual preview it shows that the Postgres database has been written to. HOWEVER, when I do a Select * From database in a separate SQL command line, nothing is showing up in my tables. Its as if its not legitimately writing into the database. The connections are right, and this is happening on a local Postgres database I have running. I'm thinking there may be a step I missed? I did this all pretty straight-forward without tinkering with customizations. If anyone could assist or point me to a step-by-step guide for achieving this I'd really appreciate it. I have found similar guides on youtube but nothing for exactly CSV to Postgres. Thanks all!

2335
david_r
Celebrity
C
cristina_it
asked in Data
Shared surfaces in CityGML

Hello there, I'm quite new to FME, and I'm trying to achieve an effective CityGML model of an historical city center in order to carry out energy analysis at urban scale.After some hard work, I managed to transform my Shape file into CityGML LOD2 by merging a set of tutorials and best practices, and the result is satisfying. But at the end of the process I still have a huge dubt: in my final model there is no trace of shared surfaces between buildings, which are extremely important for computation in my case. Building models are in fact "extruded" one by one, with no knowledge of their boundary conditions.I didn't find any reference about this problem, is there someone who could please help me?Thanks,Cristina

430
C
J
jrphilipp
asked in Data
XML flatten - holding parent ID

Hi I have a problem in FME desktop 2019.2 that i haven't been able to solve for a while. I have an XML response from one server API and i need to restructure it to Post it to another server on a regular time interval. I am having trouble flattening the XML out and holding the relationship to the parent. Sounds like a common question. I can see many people asking similar questions in the forum however I cannot apply the logic to solve my problem. I assume the solution lies somewhere in the reader or flatten settings. The number of children per entry varies as you will see in the example.In summary:Input is an xml file. I have created an example attached.I need to split this into 2 tables. The first is the client information. The second is the contacts. And the relationship needs to be maintained. I was hoping to use the <client> <name> as the unique key in both tables.Output required is 2 tables or XML files.I would really appreciate any help.

550
takashi
Celebrity
L
lucas
asked in Data
Entity problems in Writer of a dwg file under FME 2018

Hello, I am making corrections on dwg files, I currently have a problem in my output file (in Writer) it created several entities () as in the attached photos instead of a single entity () . Do you have a solution to prevent the entities of this layer from multiplying for no reason? the entities added are of the same layer: EP_PRO_SUPPORT The problem apparently comes from the creation of the file in Writer because in the previous step, at the level of the Transformers FeatureTypeFilter I have no problem on the entities of this layer in Data Inspector. In addition I have the same number of entities in Writer and Reader on this layer so there should not be any problems with these new entities which do not come out of nowhere. Here is my FME file to better understand:  thank you in advance

50
L
D
dan_mbc
asked in Data
Excel to ArcGIS Portal problems

Hi all,  So this I thought would be a really simple task, but I am having issues bringing in an Excel spreadsheet into ArcGIS Portal. My end goal for this was to update an excel spreadsheet on our server, and get FME to send them changes through on a schedule to Portal, in turn updating a dashboard we have. Bear with me as I have tried lots of different things but to no avail, this is what I tried in a nutshell:Firstly I tried reading an excel spreadsheet, and then adding it as a new feature to Portal. The parameters I used were layer name as default and set geometry to arcgisonline_no_geom, as it isn't spatial data, and set writer mode to 'INSERT'. The two tables (geodatabase and hosted table) gets added to my Portal, but there is no data there, if I click on data tab or fields it just says "error". Looking at the FME log the only warning which might be the cause is in relation to SSL certificate "SSL certificate verification failed for host... HTTPS connect

150
D
hellenic1994
Contributor
hellenic1994Contributor
asked in Data
polygons become multipolygons when reading

Hi!I have a road network in a shapefile (polygons). When I read the shapefile, all the roundabouts become multipolygons. I assume this is because of a error with island detection. When I read the same shapefile using Civil3d (Autodesk) the roundabouts are perfect single polygons. I already tried it with a sdf and a gml, but the problems persist.Can someone please tell me what I am doing wrong.. This is a problem I have faced a lot of times, any help would be much appreciated! 

500
hellenic1994
Contributor
F
fedor
asked in Data
Failed to write raster images to Azure SQL

I am trying to write raster image to Azure SQL, I need to store four images in each record - the following formats: PNG, JPG, JP2. The writer works well - no errors during the writing, however, the stored images cannot be read in another program (no FME). Any comments regarding the correct way to import images into Azure SQL database... ?Thank you!

50
F
benvk
Contributor
benvkContributor
asked in Data
Can we insert image attachments to an AGOL feature layer?

Hey, I am currently reading a feature layer from AGOL, processing the data and writing the edited data to a new feature layer. I have been able to extract the associated image attachments from my original table, but I am wondering if there is a way for me to insert these images to my output table? Can we write these images, i have a GUID of the feature i need it to be attached to, I just don't know if it is possible through FME.Any ideas?

2210
rahulsharma
Safer
K
kkrajewski
asked in Data
Converting CAD lines back to text

Any ideas how would FME power be able to convert a 'decapitated' CAD file back to text?I have a PDF file which used to be a CAD drawing (not sure if Autodesk or Bentley) and it contains only a 'dropped/exploded' line segment geometry. I have managed to read it into FME as line geometries, rotate the page so that it's 'level' and use LineCombiner to join segments back to 'character shapes'.Now I have geometries as shown below (some are perfect characters, some are in 2-3 parts, like 'd or b') and have no idea how to turn it back into text. I tried exporting it to DGN but Microstation doesn't seem to have a function like that either (i.e. once you drop/explode a text to lines, there's only 'Undo' to help, no function to 'characterise' it again, that I found).Also tried rasterising it with ImageRasterizer and then calling a Tesseract to attempt OCR, but it notoriously returns 'No text found' regardless of resoluti

1290
jakemolnar
J
joe101
asked in Data
Why is Geodatabase_SDE writer trying to write to the source's dataset when I don't want it to?

I'm using Geodatabase_SDE reader and writer with different connection files. I have one database "Operations" with user1 and another database "Data_Sources" with user2. They both support geometric data used in ArcGIS. I try to read from Operations.user1.featureclass1, and write to Data_Sources.user2.featureclass2. Operations.user1.featureclass1 is in a dataset "ops". I'm tryng to just write a standalone featureclass in Data_Sources, so i am leaving the Feature Dataset parameter as blank. However, seems that no matter what i try, the error keeps getting thrown that I can't do the operation because I'm not the database owner. And the log says it was trying to write Data_Sources.user2.featureclass2 to the Operations.Ops dataset.The message is:Geodatabase Writer: Creating feature class `User2.Featureclass2' in feature dataset 'Operations.User1.Ops'An error occurred while attempting to create the feature class 'User2.Featureclass

60
J
K
kimburrows1242
asked in Data
Sort Directory. Need to read multiple file types and write them out.

I'm trying to sort through huge amounts of data. I have already run a directory file reader and have a huge CSV full of all the possible files in a directory including their name, path and extension etc. I now would like to push those file types into a new folder. This is for non-spatial, so a different folder for csv's, xsl, xlsx, doc, jpeg etc etcBy doing this I can then investigate these futher. Work so far: Reader: Read all files in directory and sub-directory that are, for example, a .csv I get an error and it won't create the reader, so I create it as a single CSV and then change the directory to the folder with \\**\\* at the and so it looks through all sub-directories. Writer is set to Dynamic and the same file type. I get errors from any of the above workings. Alternatively I feel like the original csv I have with all the directories included (including file path and extension) could be utilised for this?When I pull that CSV in it shows up like this instead of bro

140
ebygomm
Influencer
fmelizard
Safer
fmelizardSafer
asked in Data
ESRI support on FME Cloud?

A customer has FME Cloud. But now they need to write to GDB (ArcObjects) for raster writing.How should we add ESRI support?

470
G

Badge Winners

Show all badges

Community Stats

31,773
Posts
120,715
Replies
39,397
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.