Using readers and writers to extract and load data.
Recently active
Hi, I have a ESRI-JSON file which geometry looks likes this: "geometry":{"hasM":true,"paths":[[[333334.24000000209,6611588.879999999,0], ...Note that the hasM property is true.I am trying to convert that file (among other operations) but when it is read by FME it seems that the third coordinate is parsed as a Z value and not as a measure: Where I should expect something like that (2D but with true measure): Question: how to deal with that data to output a true M-Value? I am thinking of two approches:Find a proper setting in the ESRI-JSON reader what would parse the M-value as a true measure and not a Z ; I did not find that kind of settings if it existsLet the reader as it but find a way to transfer/copy the Z value into a M value using transformers; I did not find the proper method yet Any thoughts about this? Thanks a lot!Jean
Hello all, I'm wondering if anyone has any suggestions for using FME to compress the delta tables of an ArcSDE enterprise geodatabase? I'm thinking it could be achieved using the python caller to run the ArcPy command for executing the compression. Does anyone have and suggestions or best practices in this area? Thanks!
Hi! Is there a way to change the "else if" condition statement to an "if" condition? I want to assign two values to the same element and with the "else if" I just assign the first value.
Hello FME Support,Is there any news on the 'Unsupported Font Issue' in the PDFWriter? https://knowledge.safe.com/questions/2007/unsupported-font-family-message.html We need to be able to read DWG drawings in a range of True Type Fonts but it keeps failing and reverting to Helvetica when writing to PDF.
Hi, My name is Jie, and I'd like to build a geological voxel model as the following picture copied from the question asked by @philip_wehrens . I want to know how to efficiently build a model like this? With this model, I want to export the model for Finite Element Analysis. To be specific, The finite element code is developed in Matlab. All the best,Jie
Hello,I have a table in Postgreql with geometry that I can perfectly load in QGIS but the FME reader doesn't show the geometry. The allowed geometries is postgres_none but they are polygons. What am I missing? TIAJonathan
I have multiple .dwg files and a shape while which consists of polygons (Grids). I would like to clip the dwgs by the polygons and save them to individual new dwgs. I tried Clipper and LineOnAreaOverlayer. However, quite a lot of objects are rejected as I have different geometries in it or objects like in the image How can I clip all objects in the dwg regardless from object types? Thanks in advance.
I am unable to see any ArcGIS Pro python interpreters available in Options>Translation. I have Pro 2.6.0 installed and FME Desktop 2019.2.3.2.
I would like to export the DGN-meshes to DWG-solids.The strange thing is that not all the DGN-meshes become solids in DWG.I don't get it why :-S. Attached is the test dgn and my workbench.Could somebody take a look and change the workbench so I will get all 3D solids in the DWG? That would be great! Thanks!
Hello, I am trying to create a reader to process AGS 4 data but am struggling with it a bit.For those who haven't encountered the data before, I have included an example below.When opened as a text file, the data is all in one column. It is grouped into sections that define a subsection of the overall dataset. These sections always start with the "GROUP" header and end with a empty line before the next group header. Fortunately, the groups always follow the same pattern: "GROUP" = Name of the group"HEADING" = The different data headers (These would be the column headers if brought into excel)"UNIT"= The Unit of the header"TYPE" = The Data type"DATA" = The actual data for each header. "GROUP","GCHM""HEADING","LOCA_ID","SAMP_TOP","SAMP_REF","SAMP_TYPE","SAMP_ID","SPEC_REF","SPEC_DPTH","GCHM_CODE","GCHM_METH"
We have a workspace scheduled multiple times per day, from 6 AM till 6 PM every two hours. This workspace reads information from a SharePoint site (on-prem) using the SharePoint Reader.All schedules are running OK, apart from the first one at 6 AM. We get the following error every day:2020-03-11 06:00:54| 1.0| 0.0|ERROR |Python Exception <ReadTimeout>: HTTPSConnectionPool(host='xx.xx.com', port=443): Read timed out. (read timeout=20)We did some checks on the FME and SharePoint side on the machine, but did not see anything that could cause the timeout. What could cause this?In addition: the timeout setting appears to be fixed at 20 seconds. Is there any way to modify that? FME Server 2019.0.1 Build 19253 - win64 - patch 1FME Desktop 2019.0.1.0 Build 19253 - WIN32
I am merging data from and existing ESRI File Geodatabase with data form excel spreadsheet using globalID. I then want to write that data to new ESRI File Geodatabase, preserving the GlobalID from the existing fGDB. I can see this is possible in SDE. is there a way I can do this in non-SDE fGDB. I am using FME version 2019.1
Hi there, I'm curious as to why the newly created attribute in my workspace is not showing up by default when I go to the visual preview table view. I've had this happen before but I cannot find what governs this. Is there a toggle? The default behaviour should be that it shows up in the table so I can see that it's been created. I can find it in the list of available columns but it is a pain if I'm having to rerun the routine a lot. Anyone know how to change this? Using ver2020.1 but have experienced this issue on previous versions. Below example of my new attribute "Quality Level".
Hello, I have a shape file with few streets and I would like to extract all coordinates forming each line/street inside a new Attribute. Taking a look at picture attached, I would like to copy all sets of coordinates from IFMELine to a new attribute that I will be creating.Any ideas how to solve this issue? Thank you very much!
We use to be able to read data from an Oracle Synonym pointing to a table via a database link. But now we are getting a strange error and are unable to see the attributes any more. Warning: Unable to use schema obtained for Oracle Spatial layer 'schema.table' We are getting the same error from both "Oracle Autonomous Non-Spatial" and "Oracle Non-Spatial" that use to work before. I have looked into this article https://community.safe.com/s/article/working-with-synonyms-in-oracle and executed the command on a test synonym without any luck. Have somebody else seen this issue before and have any knowledge of how to get it working again. We are not sure what happened, suggestions are much welcome. The synonyms work just fine with normal SQL, it's just FME Desktop we see issues. We are running Oracle 12.0.1 on Windows in a test/developer environment. FME 2020.1.1.1 (20200817 - Build 20614 - WIN64)FME Desktop Professional Edition Oracle 12.0.1 Client 64-bit -
Hi, I am very new to FME! I am using the data interoperability extension of ArcGIS pro. I want to convert an IFC file to geodatabase feature classes, any tips on where to start or what tutorials or transformers to use? thanks
i have a model, that has been runned every day, and worked great. Now i am getting an error, while reading a feature layer from database. Can someone help me? Rebooting and ading new connections didnt work. The model stucked, nothing happenes
I have a sample file from a gridded wave model for a small section on the South coast of England, ie it is a lat/long grid covering a few hours with 11 variables (wave height, wave period, that sort of thing) for each hour. I can view the file with Panoply.While the larger spatial overview is great, I would love to extract a time series for a couple of grid cells with all parameters so i can for example compare the data with measured wave buoy data.It should be quite easy as the the output should just be a table with the 11 variables as columns and each hour as a row (in a date/time format), but given the netcdf format this does not seem quite so straight forward - at least at my level of FME understanding :-) .Not urgent but any pointers would be very welcome.Thanks!
Looking to drop a shp file into workspace and extract the data type of each field. e.g. Address.shp may have fields StreetName (text) and StreetNumber (int). I would like to be able to extract the type for each field:StreetName - fme_char(254)StreetNumber - fme_int32 I understand that FME maps the Data Types from different files based on the reader being used to an equivalent FME Data Type https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!FeatureTypeProperties/attribute_types.htm
Hello, I'm trying to get a workspace going to read in a .dgn of some modeled power lines and then write them to a datasmith package. The dgn is read in okay but no assets are written by the datasmith writer. The Udatasmith file is created but there is no info in it and the scene_assets folder is empty.I would also like to set-up a writer to bring a DEM into Unreal so any if you have any suggestions there it would be greatly appreciated. I know it's\\important to have Imagery/surfaces tiled properly for Unreal. Cheers,
Hi I have a problem with overwriting the existing gdb file.. Scenario: There is a new data that I need to insert/update into the gdb file without having to create a new gdb file... I have tried by using shp as reader and gdb as writer (It works) but when I uses gdb as reader and the same gdb as writer (Because I need the updated/new data to be in the same gdb file -FAILED).... I tried to look into the error but there is no clear explanation in the translation log.... Can anyone help me out on this?
Hi FME server experts,When I am trying to run my workbench from FME server which read the data from arcSDE GDB i feced the below error :"Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147220952'. The error message from ArcObjects is: {The Product License has not been initialized}Please ensure the connection parameters are correct (server=`test', instance=`sde:oracle11g:test', user=`lb', password=`***', database=`', version=`SDE.DEFAULT')A fatal error has occurred. Check the logfile above for details I have installed ArcGIS pro software and configure the license configured to it "Advance".I had a test to run the workbench from fme desktop it worked probably but the issue is with FME server.anyone can assist me with this?
I have over 30 dwg files. Is there any way I read all at once but I filter them based their file name (1.dwg, 2.dwg)? I need to create Convexthull per dwg file and find out whether they are overlapping. When I read all dwg file by choosing (Single Merged Feature type) it comes like this .
I created a workspace that reads buildings from an existing CityGML dataset, sets appearance (color) to them with the AppearanceSetter, saves them as a new CityGML dataset, then uploads the dataset to Cesium ion with the CesiumIonConnector. Destination dataset has been successfully created and the buildings are shown with expected color with FME Data Inspector.Uploading to Cesium ion was also succeeded, but the buildings are shown with no color. Is there any way to set a color to CityGML buildings showing on Cesium ion, through FME workspace?
I am using Esri Geodatabase Reader/Writer