Using readers and writers to extract and load data.
Recently active
Hello,I have a dgn file containing a 3D model of a ground surface. From the dgn I created a 3D polygon shapefile, extracted the vertices to points and assigned Z values to the points. I would like to interpolate between the points I extracted to create a DEM. This process works well in ArcGIS, using the Create TIN tool and I'm able to create a DEM raster that closely resembles the original 3D model. I've been trying to replicate this process in FME but I can't seem to generate a TIN similar to that of the original model. I've tried using TINgenerator, DEMgenerator, RasterDEMGenerator and Surfacemodeller. With all of these methods it appears to interpolate a surface but the faces are missing (looks like a greenhouse with the glass taken out). Or the interpolation is so course that it creates huge triangles, which is something that the Create TIN tool in ArcGIS appears to overcome. Is there away that I can generate a TIN with solid faces and a higher resolution of interp
Hello everyone, As said in the title, I'm having trouble converting an SDE Polygon feature class to a KML file in FME 2017. When I do the translation on FME, I can see the geometry and attribute in the inspector, but when I add the KML to Google earth, there is no geometry! I was also using a KML Property Setter and KML Styler, but that shouldn't have any effect. I've made sure to check the coordinate system, and I've re-run the workspace In many different variations, and even tried doing the conversion in Arc, but no results for getting the KML polygon. Please help! One thing I've noticed is that the polygon KML is a very large file when compared to the other KML's generated in the workspace, both of which have many, many more features. The data that is not 'working' is the writer ending in '_Area'
Hi all, I have a dwg file with a lot of layers. Some of the layers are named in Latin alphabet some are not. The ones that are not are shown like this \\U+041A\\U+043E...............I have two questions:1. How can I see the layer names properly?2. How can I create a list of all layers, in the format dwgname,layername and write out as csv file?
I'm puzzled how to set up tokens for external applications in server 2019.We submit workspaces in server from an external application. (Internal WebGIS.) We manage users (who is allowed to do what) in the WebGIS user management. Only backend users connect with server.Previously we had one authoring account and one api account in server. We maintained workspaces using the authoring account. The api account had submit only rights on specific repositories. When a user started an action, the WebGIS application requested a token using the api account credentials and submitted the workspace.Now we have server 2019 with AD connected. But I'm not sure how to use it correctly.- When I create something under my own account, my colleagues can't maintain it. Yes I can give users or roles full access, but I need to do this every time. And I can't transfer ownership?- When I create an API token it is assigned to my account. This means my name is logged when a job is submitted from We
Has anyone tried to write to an In-Memory table such as a PostGIS temporary table?
hi,how to set attributes (strings) on the objects IfcPerson and IfcOrganization with FME?like "FamilyName" (IfcPerson) orlike "Name" (IfcOrganization)
Hi All,We have a lot of workbenches on our FME Server and the configuration of a fileserver with shapefiles has changed. Therefor I want to have a list of all fme workbenches that contains a reader with format Esri Shapefile or a writer with format Esri shapefile.I also want to know the path of each esri shapefile reader or writer.Or even better: i want to have a list wih the connection parameters of each reader and writer of every single fme workbench on the server.Can anyone help me with this?Thanks a lot,Francis
Hi, i like to define the upperBound and lowerBound for an attribut with Property Type "Bounded value" defined with the IFCPropertySetDefinitionCreator. (see below) How to set the domain (value range) for the PropertyType "Bounded Value" ? Is it possible to set de upper and lowerBound with FME? The definition of the attribute value is already defined by using the attribute creator. (see below) Test_Attribut_03 = 'test' Best regards LuHu
Hi, i like to define the permissible values for attributs with Property Type = "Enumerated Value" defined with the IFCPropertySetDefinitionCreator. (see below) How to set a liste of permissible values for the PropertyType "Bounded Value" ? Is it possible to set de upper and lowerBound with FME? The definition of the attribute value is already defined by using the attribute creator. (see below) Test_Attribut_21 = 'Testwert 21' Best regards LuHu
Hello Community, i'm struggling with this Question:Is it possible to write a B3DM-File (Writer: Cesium 3D Tiles)from "KMZ with Textures" to "Cesium 3D Tiles WITHOUT Textures" ? If the answer is YES - How should my workbench look ? With best regardsMichael.
This is probably a simple question to many of you. I wonder is there a way to read multiple feature classes in one reader (from a single file geodatabase), put DateTimeStamper on it in one single transformer, and split out multiple feature classes in one dynamic writer?Please see my attached file. I would like my writer to have 991 features for the AGG_Inspector_Juris, 5630 features for the AGGSite_Authorized_Active and so on. I don't want to have merging features of 8988 in each of the 3 feature classes.I understand that I can do a one to one (Reader, DateTimeStampler > Writer). However, it would save me so much time if I can just add one transformer to this tool and then somehow split them to appropriate tables.
What transformer would I use to query an AutoCAD file's paperspace properties (specifically the MVIEW viewport's WCS xy center point, the viewport height and width, and the custom scale)? I don't need any of the graphics features per se, just the viewport information to construct a minimum bounding polygon for the plot-displayable "meat" of the drawing file?
Hi, When I start FME Desktop Oracle Edition (floating) (FME(R) 2018.1.0.0 (20180717 - Build 18520 - WIN32)) I can see all my Oracle readers and make use of them. But when I quit FME Deskktop, start SQL Developer and then start FME Desktop again. The readers are greyed out. At this moment I am unbale to make use of the Oracle readers. Is this a bug? Is there a solution? Kind regards,Lucien Davids
Hi All, I could use some assistance on the problem I am facing. The data I have looks something like this. R-AMT517 C-ACB941, C-ACB942, C-ACB943 I want it to look like this. R-AMT517 C-ACB941 R-AMT517 C-ACB942 R-AMT517 C-ACB943 How would I go about doing that? Regards, Sahil
Hi fme guys ;-) I have to create an export tool that will have as reader an excel file... The problem is that the worksheet used won't have the same name everytime... The structure will remain the same... It's only the name of the worksheet that changes... My question is, how could I handle this problem... Thanks for you help...
I am trying to work out the actual scale of the viewport(s) in AutoCAD DWG to make sure they conform to a particular scale. Attached is an example DWG that I am trying to determine the scale of the viewport. Any assistance would be greatly appreciated. Regards Dean
Hey folks, Happy New Year.I'm performing a very simple data conversion but something "bug like" seems to have cropped up in FME.I have a DXF file created by QGIS v 3.4.2I wanted to then open this in AutoCAD LT 2019. For some reason this failed a couple of times AutoDESK are looking into it.Anyway I whipped out my trusty FME 2018.0 and performed a really simple DXF > DWG conversion. No DWGStyler.This worked faultlessly except I got a lot of hatches along with the polygons.So I added a DWGstyler. The only setting is "Area" as polygons. No other styles or templates.When I went to open the DWG this time in AutoCAD I got the following dialog.If I accept this, the DWG I get does indeed have the hatches suppressed but since the writer came from FME I'm wondering what bit is being set incorrectly to have it being detected as a "Student Version" of the drawing?Research on similar issues related to DWG's being "infected" with objects from Ed
Hi, I'm rather new to the INSPIRE data format but basically what I'm trying to do is to create some natural risk and natural hazard maps (floods) that are INSPIRE compliant. Preferably I would like to store them as coverages (which is basically the INSPIRE raster format if I understand it correctly). When I try to add the RiskCoverage and HazardCoverage feature types I notice that the Hazard Coverage is present but only in the theme 'NaturalRiskCore (v3.0)', not in NaturalRiskCore (v4.0). The RiskCoverage feature type is not present in either themes. The RiskZone and HazardCoverage feature types (both used for vector data) were always present. From the INSPIRE data specifications website I was able to download the latest xsd schema. (I've added the xsd content as a plain text file to this question because FMEpedia does not allow me to add xsds as attachments)https://inspire.ec.europa.eu/Themes/140/2892I've checked the content and the RiskCoverage is specified. H
Hello!I need to write in EDIGéO format, but it's not in the format list for writer. However, we can find it in Reader!Can someone help me please.Thank you.
Hi there, I'm still a bit new to FME so this might be dumb question. Sorry for that.What I'm trying to do is read a CSV file which contains X and Y fields and then after a few transformations write to an Esri Geodatabase (Postgresql with SDE).First I've set my reader as described in 1st Method here.Now at the end of my workbench I wonder what to do so that the ArcSde Geodb writer writes the Geometry point to an attribute named Shape (of type st_geometry) which is not in the csv ? Do I need to add this field in an AttributeManager ? If so what should the value be ? Thanks in advance.
I am trying to write new both single point and multipoint features from a multipoint geometry Esri SDE feature class to an Esri ArcGIS Online multipoint geometry feature service and keep getting this error in 2017.1.1.0 (20170929 - Build 17650 - WIN64) Workbench:<type 'fmeobjects.FMEPoint'> cannot be converted to esriGeometryMultipointThe only transformer I have in the workbench is a 'reprojector' to go from our custom LRS Lambert Conic projection to WGS84 Web Mercator (3857) projection. We use this all the time, so I'm not too concerned about the reprojection piece of the workflow.Any ideas on how to resolve this?Thanks in advance.MarkSDE Version 10.4.1
Hello fellows, I have the samples workbenches in the instance of a FME Server 2018. The earthquakesextrusion.fmw has the following advance configuration:If i trigger an execution of this workbench with wrong parameters i will get a Failure: When I check in the topic monitoring I don't see any change, despite the fact i am monitoring the JOBSUMMITER_ASYNC_JOB_FAILURE: 1. Am I misreading the configuration of the workbench, and the behavior is the one expected?2. Do I require to make some additional configuration in order to see the topic in the monitoring? Thanks for any help.
Hi, Is there a way to read an oracle blob file within FME. I know the structure and can read with python, is it possible to do something with FME? Is it possible at least to read in the blob with FME then use a python caller to extract using the struct library?Many Thanks as always,Olivercursor.execute("SELECT BLOB_DATA,DATATYPE,BYTES_USED,BLK_NO FROM {}.GEO_SHAPE WHERE VID={}".format(xxx,19971))ORACLErow = cursor.fetchall()for row in ORACLErow: print row print struct.unpack('>d',row[0].read(1,8))[0] print struct.unpack('>d',row[0].read(9,8))[0] print struct.unpack('>d',row[0].read(17,8))[0] print struct.unpack('25s',row[0].read(25,25))[0] print struct.unpack('>i',row[0].read(50,4))[0]
Hello Team,I tried to run the custom transformer PDF2TextReader but the output port ( TEXT_Data ) bring the attribute text_line_data empty.Informations about my FME Desktop and XpdfReader:Attached my Log file - Attached my pdf file - Thanks,Danilo
I'm using FME Server and I'm trying to switch some notifications over to an automations. In the old notifications system, the JSON object that you can pass into the published workspace parameter has the path of every attachment in the email. In the new automations systems, it looks like the "Email Attachment" variable only has a single attachment path passed (the first attachment in the email), instead of every attachment path. Is there a way to pass all the attachment paths into the workspace input parameter using automations? Thanks