Using readers and writers to extract and load data.
Recently active
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
How do I set the text justification when I write to DWG
m trying to generate 3D tiles form shp file. Just simple shp reader directly to Cesium 3D tiles writer. It does generate files, but after uploading them to Cesium Ion it does not work. It cant even generate preview of it.Am I missing some step in FME?Coordinate setting: reader - read from source
@takashi Hi! I'm new to FME, I'll need some help to export my data in ACAD format. My input file is also in AutoCAD format.The problem I'm having is that there is no output file. Actually I want it in the same format and layer style. Thank you in advance.
Hi all,In the "AzureBlobStorageConnector" documentation ( http://docs.safe.com/fme/2019.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/azureblobstorageconnector.htm ) is written that: "The FeatureReader can access Azure Blob Storage directly, without using the AzureBlobStorageConnector. In this case, a permanent local copy of the dataset will not be created". Since I do not need a local copy of the file, I tried to use the "FeatureReader" to access the Azure blob storage, but I am not sure which reader format I should choose. Could someone help about this topic, please? Thanks a lot
I'd like to convert 3ds file to CityGML LOD2 (CityGML version is 2.0). Actually I want to classify roof and outer-wall. I already found similar question in the Community as below as https://knowledge.safe.com/questions/22115/how-to-convert-3ds-file-to-citygml.html But the shared workspace doesn't work. If possible please share workspace .
Hello, I'm using FME Desktop to convert 3D files to Cesium 3D Tiles, and have published the workflows to FME Server. I read the FME Server REST API, and it seems like operating the FME Server functionality, so my question is: Is FME Server provide any web service or api for Cesium client to present 3D data just like Cesium ion?
Hi, im using FME in an oracle database copying data from one table to anotherI am trying to put a published parameter on a "WHERE clause..". If i write the whole query, everything is OK:"DE" in (SELECT CZ FROM REF_CZ WHERE MONO = 'BORË')':but,If i put a part of it as a published parameter i get this error:Query: "DE" in (SELECT CZ FROM REF_CZ WHERE MONO = '$(P1)')Field type is a string.Error is : ORA-01756: quoted string not properly terminated'. (serverType=`ORACLE8i'..........
Hello,I need help in addressing multiple shapefiles in .zip , add some transformers to it and then write it to an excel file with different shapefiles result copying in different sheets in the same excel.Thanks in advance.Mukhtar
Hi @MattAtSafeI want to clip a 3D model with textures in FME. My modell has the following spesifications:.obj format with texturesno coordinate systemIf I use a clipper in FME, it doesn't accept the IFMEMesh. Can you give me some recommendations on how to clip the modell and keep the textures? Thanks!Cecilia
Here's a fun problem! And, as always, any hints or ideas are welcome!I have 3D-point-data with resistivity values and I would like to generate a 3D vector profile with resistivity "areas" like the one below (but as vector data) - if at all this is possible with FME? And just the areas/3D-polygons would suffice. I'm mainly interested in getting the same information content than an exact replica. It doesn't matter if the information is made up of faces, meshes or solids as long as I can get circa the image below in 3D representations in say Autocad.I attach a template file with the data so if you feel like doing some testing you should be up and running directly.Like I said, any ideas or hints are welcome!Peter
I am very new to use this tool and thought some of expert from this forum might help meI have oracle11 database and migrated to MS SQL server 2014I would like to compare data between oracle11->database1->table1 with mssqlserver2014->database1->table1I would like to compare data between each table with cross databasesPlease, let me know steps to do this
I would like to write several sheets into an excel file: on every single sheet there should be data and a chart based on one of the columns. I have tryed it using a template file which already has a chart on the template sheet. I am already using a template file and a template sheet.On the output file i just get data on every single sheet which is perfect, but only get a chart on the first sheet. The chart is based in one of the columns.Any clue on how to get an automatic chart per sheet?