Using readers and writers to extract and load data.
Recently active
Hello,I am transforming DGN files to ESRI shape using (Attached bellow). I have a problem with shared cells elements. I am transforming them to point shp but I am losing attribute NAME. I am suspecting that some of the format attributes are not checked. Any ideas how to get attribute that i need?
I am converting dataset from ESRI geodatabase to shapefile, but I am facing the domain problem how could we expose the domain , I am still getting only the code thanks
A customer who is using FME to connect to our recently upgraded database is reporting that a process for pulling data that was working before the upgrade now seems to just hang after a few minutes. We have SQLNET.EXPIRE_TIME=4 in the server's sqlnet.ora which means we check for dead sessions at 4 minutes. The FME log does not report any errors. It just stops logging and performs no more work.
Does anyone have experience getting data from Petrel Studio with FME? Any tips appreciated!Petrel E&P; Software Platform https://www.software.slb.com/products/petrel
I am trying to convert a drawing from Autodesk Plant3D to *.IFC format for consumption by a third party BIM viewer. I want to bring over as much of the intelligence from Plant3D as I can (part names, etc). When I convert from the FBX, all I get are the surfaces as a part name. If I convert from the dwg, everything is still lines. Is there an established method to get from Plant3D to IFC?
i need to classify the lidar point cloud to building alone. in las classify tool it classifies into building trees etc. how to classify only building?
I used a CoördinatExtractor and a ListExploder to get the Coördinates. I create a attribute to write the x and y coördinates in one line. Now the question is how can I create the last line whit only end?example:pnt 111223, 513248pnt 111225, 513256END
Hi I'm trying to split a series of raw point cloud files into files named by Ordnance Survey 500m tile reference, which are provided via a MapInfo TAB file. The point cloud contains X,Y,Z & Intensity. I've tried using the tiler tool, but that only splits by a certain number of rows and columns, any help would be much appreciated.Many Thanks in advance!Dan
Hi, I have a oracle spatial reader setup to read a number of tables. All the tables can read except one table and the reader stops automatically with a error message in the log - Error - Cannot have NULL value for 'x coordinate'. I tried to filter the bad geometries with a where clause like this - SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT( G3E_GEOMETRY, 0.005, 'TRUE') = 'TRUE' . That did not work either and the same error followed. Surprisingly when I used this sql statement at SQLDeveloper, it results in a set of valid records. I am not sure why FME is not able to read these valid records. Appreciate if you could help me out with this.
The idea is that an Excel document with file-paths is used for pushing updates.
The IFC reader needs to have an actual IFC file as its dataset when it's created. How can I create a reader that's able to handle any IFC file that's uploaded to the FME server?After the reader is created it seems that I can change the dataset to be given in a parameter, but I don't understand what the meaning of the IFC file given to the original dataset is.
Our team names have changed and I'd like to clean up the category names. Is this possible without recreating the scheduled jobs? Have I overlooked something simple?
If I leave it as sheet 1 all the hyperlinks work. I have multiple sheets that I will add to the excel file so this function should work fine and has in the past version. Could someone help?
Hi I want to update a view on ArcGIS Online, does anyone know if that is possible?My plan is bring in the data as a feature service and filter the data I want in the view and publish to an existing view? Any help would be appreciated
I'm trying to use views/tables from a PostGIS database that uses the encoding UTF-8, while my system encoding is ISO-8859-1 / Latin-1.It works alright until some views named using exotic letters are run through e.g. the LineOnLineOverlayer transformer, which produces a Python Unicode Error (ordinal out of range).Can I somehow specify in the FME PostGIS reader that the database uses another encoding, or should I submit this behaviour as a bug report?
Hi, When I would like to insert a new table to Postgis, I am getting below error. For existing table is ok. Its means that, it is inserting a new records, but if does not exist table, it does not allow to create.
I try to load data from this wfs : https://www.vaarweginformatie.nl/wfswms/services?SERVICE=WFS&VERSION;=1.1.0&request;=GetFeature but it gives some errors. I use the wfs reader in FME desktop 2015, I see and can select the different feature types in the wfs but it won't load the data. The reader generate the next error : The top-level element declaration referred to by the 'substitutionGroup' attribute is missing from the XML Schema QName: 'gml:AbstractFeature' | namespace uri:'http://www.opengis.net/gml' What is going wrong?
I have a large number of file geodatabases with one feature class in each in a centralized location.This large number of FGDB's are not a constant one. It may add new FGDB or remove from other process. i would like to add all feature classes into one new file geodatabase and reading can be dymanic. Could any one suggest how to achieve this?
I have struggled both with samples and without samples trying to understand what stops the FME job. It’s an transformation from SWEREF99 to RT90 coordinate system that works fine if running directly in the FME server web environment. When I run it from a js-routine and even when I simulate the calls in Postman I get the same problem.It ends with:Shape Reader: No Shape files found in specified folder '.'. Check if folder specified is validError fetching dynamic schema definitions from reader `SHAPE_1'. Error reading from `.' reader.MULTI_WRITER: Error fetching dynamic schema definitions from reader 'SHAPE_1'I have attached the log-file if you can see anything from that.Best Regards johan
Hi,I am not having much luck with my loop. I set it initially to 4 and hope to iterate through a table which there where filter for level = dropping by 1 each time from 4 to 0 where there loop then completes. Unfortunately nothing is being written at the moment out and I am none the wiser. Can anyone see from the workbench what I might be doing wrong.Many Thanks,Oliver
Hello FME expert,I try to read a file (ZRM.csv) into Oracle db but my result looks like output.xls I don't manage to get rid of the seperations |~| and [||] and [ with my reader because I have only 1 Delimiter Character in the CSV reader. Is there a better way to extract and read only the items that I want?Many thanks for your reply
Hello, I have a multiple PDFs that contain image in them self. Beside the image there is annotation and I would need to crop the image, to remove annotation and after that to mosaic these multiple PDFs. Is that possible to finish in FME? I tryied RasterMosaicer but it is not working. Thank You in advance. Dejan
I get an Oracle connection error using FME Server 2017.1.2 - Build 17722 - win64 to import data to an Oracle Spatial 11g or 12c database. The server OS = Windows Server 2008 R2 The following Oracle Server settings are present:tnsnames.ora is set via an environment system variable to a certain drive mapping:TNS_ADMIN %O_DRIVE%\\OracleO_DRIVE \\\\srv_name\\environment\\appORA_HOME not set Locally tnsnames is NOT set via:<<Installation_Drive>>\\app\\Administrator\\product\\<<versiono of Oracle>>\\client_1\\network\\admin\\tnsnames.ora When I copy tnsnames.ora locally FME SRV connects without problem (which we don’t want), if ORACLE_HOME is set or not doesn’t matter.When tnsnames.ora is set via TNS_ADMIN variable and NOT locally FME SRV oracle connection fails. FME Workbench doesn’t have this problem, it connects to TNS_ADMIN without problems.Is there a solution?
Is it possible to use input from a .csv file to populate the service and layer parameters in an ArcGIS Online writer?
How to extract fields that has values or records if single record also need to exclude the fields that has no value (empty or Null or missing) that is show in yellow color that need to be exlude in the selection Filed1Filed2Filed3Filed4Filed5Filed6Filed7Filed8 5216603901NotABackRoad3 HighMedium 5387238226NotABackRoad4 MediumMedium 54 NotABackRoad Medium 5573780123NotABackRoad6 HighMedium 562878137NotABackRoad0 MediumMedium