Using readers and writers to extract and load data.
Recently active
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
FeatureReader is supposed to read any FME supported format. I've had succes using it to query against a geodatabase (arc SDE), but trying to do spatial queries against a temporary data set stored as FFS I get zip. Nada. Zero. Of course, I've been doing debugging and relaxing both the spatial and non-spatial options of my featureReader so that every single feature of my dataset SHOULD pass happily through, no matter what. Still I'm out of luck :( My INITIATOR feature is one or more polygon(s). Does anyone else than me having trouble reading FFS files with featureReader? Or is it just me... Or is it some black FME magic I have overlooked somewhere?
I understand that the versions of Civil 3D supported by FME are done so by a third party. Is there any information if libraries will be available to Safe in the future to extend support to newer versions of Civil3D? Thanks,
I have a mixed result opening .ERS file in FME and wanted to know if there is a known limitation for it.
Hello,I'm trying to write an OBJ file with groups. Is it possible to do that? I tried creating an attribute obj_group and then use GeometryPropertySetter with Traits from Attributes. I also tried to Aggregate objects into groups but nothing works so far...I've enclosed and example.Thanks, Stéphane
Hi all, For the moment I'm looking into the functionalities of FME 2012 for postgis 2.0 Mainly I'm searching for what is already supported and what not. I noticed that some new functionalities are coming in the 2013 release. But as also mentioned before by other users (eg. http://tinyurl.com/cwzw438) there is little documentation about PostGIS in FME. Is there someweher a clear overview of what functionalities are already supported or supported in which FME version? Besides that I agree on what is mentioned in the other topic: "So what we need - I think - is fme writer parameters questioning for the used postgreSQL-version and for the relevant configuration parameters and/or regulating the way FME escapes characters. What we also need is an thorough documentation of the postgis writer and/or more information in fmepedia regarding postgis. I have always been wondering why - though so many people use postgis - there is so little information on FME and postgis" Re
All, I'm attempting to issue a WHERE clause on reading an Excel file... but the source worksheet has column names that include spaces. So I can get this to work: Test_me = 'Dave' but this doesn't: Test me = 'Dave' and it returns a provider error: Provider error `(-2147217900) Syntax error in GROUP BY clause. I'm assuming its the space that is causing the issue, does anyone know of a work around, short of ensuring the source data has underscores instead? Thanks