Skip to main content

Data

Using readers and writers to extract and load data.

  • 7,310 Posts
  • 26,856 Replies
7310 Posts
runneals
Enthusiast
runnealsEnthusiast
 Data
tornbladcarolin
 Data
ganesan
Participant
ganesanParticipant
 Data
venu
Contributor
venuContributor
 Data
robyn_studts
 Data
anushsagar
 Data
semolina0124
 Data
XMLUpdater - Updating values with the same XML path

Hello FME community!I am currently working on updating the metadata of a feature class using the XMLUpdater. Everything is going great so far but I am running into a little bit of a wall here. I am trying to update the Horizontal / Vertical positional accuracy in the metadata sheet. Theses can be found in Resource/Quality/Report section of the sheet. Here is a picture with the fields in question: As you can see on this example its pretty simple. You set the Dimension and fill the Horizontal Positional Accuracy report in the Description. My problem arises because I currently need two reports, one for Horizontal and one for Vertical and once I create them the XML reads as follow:As you can see both XML Path for the XMLUpdater are the same with the exception of the "dimension". That means that the XML Path for both horizontal and vertical Description read as "/metadata/dqInfo/report/measDesc".My question is: Is there a way to differentiate between these two locations i

1081
takashi
Celebrity
semolina0124
 Data
XMLUpdater - Changing values from a drop down menu

Hello to the lovely FME communityI am fairly new to the FME world and am currently working in a small project to update the metadata of a feature class using the XMLUpdater. The process is working fine except for when I am trying to update the XML values of a drop down menu. For example If you go to the Item Description of the feature class and go to "Overview" --> "Citation Contacts" I am trying to change the "Role" from Distributor to Publisher like this:After some trial and error I found that the XML tag for this particular field is: As you can see "value = 011" is inside the tag and I tried different options within the XMLUpdater but it seems you are only able to replace whats after or before the tag(RoleCd value="011"), not what is inside (in need to change the number 011 to 010). I think It is not something I can replace using XMLUpdater (at least to my knowledge) so I was wondering If somebody could provide some feedback and p

932
georgefloros
 Data
IFC to 2D Shapefiles

Hello,I am trying to convert IFC to 2D Shapefiles. What I really want is to get the 2D Exterior boundary of every model. Sometimes it is the footprint, but sometimes is the footprint + the exceeding slabs or a buildingelementproxy. My method is to use a 2DForcer and then a GeometryFilter to extract the Areas in order to write Polygon Shapefiles. However, in models with high complexity the 2DForcer creates many small polygons as attached in the photo, that kill performance. This is partially solved using the Dissolver, but in cases as shown in the photo the process can take 2hours or even more in a PC with acceptable specs (i7, 32GB RAM).I would welcome any ideas on how to make this process more efficient. I have tried the TriangulatedSurfaces but with no luck. I believe it is normal, since IFC's geometries are solids. Should I create composite surfaces and then work with them? But this sounds like too much trouble to just get the footprints of a model. The BoundsExtractor also did

2841
larsatomkeere
Contributor
hk
 Data
tsurveyor
 Data
Replace one text file with another or overwrite text

Related to my question about importing a prj file, I think one of these might be a solution. My inputs are DGN files and my outputs are shapefiles. The DGN files do not have a projection defined so I thought I can replace the prj file created by the shapefile writer. I came up with two different ways to do this but I don't know what will work in FME. Will one of these work for replacing my prj file?create the shapefiles and save in a fanout by a given attribute (category)read in the source prj filerename the source prj file to match each new shapefile and overwrite the existing prj file, effectively overwriting the one created by feature writer. What transformer will I use for renaming the file and saving it?I already have a process for creating the list of shapefile names, will fanout by the same attribute overwrite the existing file?replace all of the text in the new shapefile prj file with the text from the source prj filethis seems the easiest but I don't know how to read i

1696
helmoet
helmoet
 Data
usmanali
 Data
OSM to CItyGML LOD 1

I would like to convert OSM building boundary to CityGML LOD 1 format.I am successfully converting into KML or CityGML generic object format but When I am trying to convert to CityGML building by adding citygml_lod_name detail it showing following error.CityGML Writer: The 'IFMELine' geometry is invalid for the 'lod1Solid' citygml_lod_name, valid geometries for 'lod1Solid' are: {IFMECompositeSolid, IFMECSGSolid, IFMEBox, IFMEBRepSolid, IFMEExtrusion}, convertible geometries are {IFMEMultiSolid, IFMECompositeSurface, IFMEFace, IFMEMesh, IFMETriangleStrip, IFMERectangleFace, IFMEAggregate, IFMEMultiSurface, IFMETriangleFan}.Storing feature(s) to FME feature store file `C:\Users\....\osm2ogckml_log.ffs'+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `Building'Attribute(string)           : `_uuid' has value `9a3b482d-a204-465f-a73e-e35a6da505c4'Attribute(encoded: UTF-16LE): `building' has value `university'Attribute(encoded: UTF-16LE): `changeset' h

942
jeroen
Contributor
jeroenContributor
 Data
Data upload via REST makes the dbf of my shapefile corrupt

Using FME Server build 18305I am testing the Upload multiple files in the FME Server REST API V3 on my server.The goal is to upload a shape file using the POST /resources/connections/< resource >/filesys/< path > (Upload multiple files) method but getting stuck on using the file due to corruption.These are the settings:The return looks like this:Response Code:200Response Body[  {    "date": "2018-10-22T11:09:43Z",    "path": "/Testwerk/",    "size": 8360,    "name": "waterschapsgrenzen.dbf",    "type": "FILE"  },  {    "date": "2018-10-22T11:09:43Z",    "path": "/Testwerk/",    "size": 428,    "name": "waterschapsgrenzen.prj",    "type": "FILE"  },  {    "date": "2018-10-22T11:09:43Z",    "path": "/Testwerk/",    "size": 170,    "name": "waterschapsgrenzen.shx",    "type": "FILE"  },  {    "date": "2018-10-22T11:09:43Z",    "path": "/Testwerk/",    "size": 960243,    "name": "waterschapsgrenzen.shp",    "type": "FILE"  }]Everything looks OK till now, but when downloading an

12310
david_r
Celebrity
christian_b
 Data
How to perform sequential delete and insert operations on same writer ?

Hi,I try to import an Excel file in a Postgres table.But before inserting the rows of the Excel file, I have to delete all records in the destination table where the values of a column from Excel file are matching the values of a field in the Postgres table.I achieved to perform the delete operation with an Aggregator transform that performs a groupby operation on the Excel column and a SQLExecutor transformer that deletes in the destination table all records whose values are matching one of the groupby values.That part works fine.But now, I don't find out how to plug after this the insert operation on a Postgres writer.Because the SQLExecutor returns only the groupby values from the initiator.I don't think I can use a DatabaseUpdater transformer with fme_db_operation for this context.Thanks for any help.

2287
jdh
Contributor
jdhContributor
 Data
allensong
 Data
arxit
Contributor
arxitContributor
 Data
AutoCAD Map 3D : Duplicate attributes when exporting points entities to Block with OD

Hi everyone,I'm exporting GIS point data to AutoCAD Map 3D DWG file. On output, I need to have the inserts as blocks and the original attributes as object data. In the workflow, I use the "DWGStyler" transformer with block definition defined in a DWG Template file - original block doesn't have any attribute - and output them in AutoCAD Map 3D Writer with OD.Everything is fine : when I open my output DWG File in AutoCAD Map 3D, I have correct blocks and object data... but block attributes too ! So, I get duplicate attribute information for each object (cf. attachments).This DWG File must be edited by other users and re-import later on GIS, so the duplicated information can be a source of confusion.Is there a solution to insert block without block attributes ?Thanks for help !

1042
jovitaatsafe
Safer
jdbos
 Data
hadhafang
 Data
IFC to COLLAD. How can I specify the feature index as a constraint on the reader?

I have made a workspace from IFC to COLLADA. However my writer doesn't write a working .dae file when I try opening it i get this message:An error occurred while constructing the geometry with id 'g_1'A <triangles> element with a 'count' of '129' contains an incorrect number of indices i it's <p> elementA fatal error has occurred. Check the logfile above for detailsFailed to specify the feature index as constraints on the readerHow can I specify the feature index as a constraint on the reader? and what does it mean?The <triangles> element with a 'count' of '129' contains 388 indices in it's <p> element, I think it should be 129*3  = 387 indices. If I understand the COLLADA specifications correctly Count specifies the number of indices and p are the indices. But reading COLLADAS specefications are unforunatly breaking my brain. The specified geometry looks like this:<geometry id="g_1">      <mesh>        <source id="src_3" name="position">      

1881
venkenk
 Data
martinkoch
Enthusiast
martinkochEnthusiast
 Data
How to use the ArcGIS python library in FME?

Hello all,I want to use the ArcGIS api from PythonCallers in FME, and do that on server.https://developers.arcgis.com/python/guide/install-and-set-up/All works fine on desktop, when I switch to the ArcGIS Pro python.When I install the library, and its dependencies in my Documents/FME/Plugins/Python/python36, and use the Default Python 3.6 for my workspace, I get a message Python Exception <ImportError>: dateutil 2.5.0 is the minimum required versionWhen I doimport fmeimport fmeobjectsimport dateutildef processFeature(feature):    logger = fmeobjects.FMELogFile()    logger.logMessageString("dateutil is version {}".format(dateutil.__version__)) I get dateutil is version 2.4.0Even when I have added the dateutil 2.7.3 package to my plugins/Python/python36 folder. It seems I can't override the dateutil-version and therefore not use the arcgis library.I do not intend to install ArcGIS Pro on our server, as of licencing, overhead, and I want this to run on FME Cloud as well, which is Li

2491
stalknecht
Contributor
gvenhorst
Contributor
gvenhorstContributor
 Data
jake
 Data
bkolubenka
 Data
Show more activity

Badge Winners

  • Welcome Back
    tom_colleyhas earned the badge Welcome Back
  • Welcome Back
    lcoulsonhas earned the badge Welcome Back
  • Welcome Back
    ayanhas earned the badge Welcome Back
  • Welcome Back
    petehhas earned the badge Welcome Back
  • FME Certified Sales Professional
    sashadenysiukhas earned the badge FME Certified Sales Professional
Show all badges

Community Stats

32,868
Posts
124,715
Replies
41,478
Members
Terms & ConditionsAccessibility statement
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.