Using readers and writers to extract and load data.
Recently active
When I use an attribute value in SVG Writer "Feature Type Name", it seems that layer style attribute doesn´t work. The layer style custom value doesn´t appear in inner SVG <g>. Futhermore, allow an attribute value in layer style attribute would be fine (now only a text string).
I have created a workbench that transforms DGN cells to AutoCAD blocks. In this process I am trying to set a feature to the defpoints layer but when I aggregate to a block it puts all features on 0. Is there a way to keep that defpoints layer when aggregating?
Hi!I need help. No matter how I try, it does not read the files contained inside different subfolders. I was told to set the path so in the Dataset appears like this: <pathname>\\**and replace the pathname with mine. I have 2 readers combined together, and excel sheet and the subfolders inside a main folder. I have set it so there is an error report in the end and it keeps on telling me, that the files are not inside the subfolders. The files formats are different: pdf, dwg, etc..Thanks for your help in advance!!
When I use FME Quick Translator to convert CityGML file to IMX, I get this error. How can I fix it?
Could someone recommend the best transformer for converting 2 point clouds to a geotiffs so that they can be compared for differences in elevations? Also what is recommended to use as a surface tolerance and output dem x and y spacings using the Rasterdemgenerator? I have two point clouds representing 2 different years. I would like to compare any differences in elevations by calculating the difference in elevations. The area is very flat and differences can be less than 1m. Any guidance appreciated. thanks
Hi all the data in the column looks like its in a binary format but everything i try fails, please help. Here is an example of a record. 30303130010000000700000075B5157B9CB80F4187EB51B8CEEA08414282E24755B90F41EE51B81ED9EA0841D36F5F477DB90F41EE51B81ED9EA084132772DE1C6B90F41808CB9EBD9EA084132772DE1C6B90F41F6FDD4B882EA0841E27A14AE9BB80F41AB13D0847FEA084175B5157B9CB80F4187EB51B8CEEA08410000000000
hello all,i have created some customer parameters in Revit and would like to expose them in FME as attributei have tried to use the Revit read as it does expose more attributes then the IFC reader, but it still only shows the default Revit parameters, i am sure AttrivuteExposer or GeometryPropertyExtractor would do the trick, but i am really strugging to expose the data. any help with this would be greatcheers,James
I want to create LOD2 objects from LAS file. As input i only have 2D buildings as polygons, representing boundary of building, with no roof-ridges or other roof details, only polygons (without elevation)I want to create roof-ridges and roof surfaces.How do I use FME to make areas to represent roof sides? So i need the maximum and minimum elevation inside the boundary but how to do to make roof sides ?I used a clipper between las and boundary and after a pointcloudcalculator but after i use a geometryreplacer i don't understand all geometries exit rejected why ?And after it's necessary to use 3d Forcer, i need help !!Thank youNat
I created a workbench to translate from Smallworld to GeoDatabase. In my Smallworld reader, I've specified to export the difference between a checkpoint (base) and an alternative. The difference between the alternative and the base (checkpoint) was 1 insert and 1 update. I used the AttributeCreator transformer to inspect the fmd_db_operation for insert, then insert the object into the GeoDatabase writer. However, it treat both records as insert and inserted both records (the insert & the update) into the GeoDatabase writer.
Hi all,I'm having a simple question about using the Red-Green-Blue (RGB-) values from point clouds. I have a LAS-file, which is already coloured and does display the RGB-values when I open the LAS-file in the FME Data Inspector. However, it seems impossible to use those values in any kind of calculator. I have a GIS-background, and I am used to a strict vector/raster data separation. It seems like a LAS-file is read as a raster, although it can contain multiple points per [xy]-value (e.g. walls, tree stems). I want to use the RGB-values that are already in de point properties. I see how I can keep them (e.g. PointCloudPropertyExtractor), but there seems to be no way to use these properties in any kind of calculation tool. The reason why I want to do this, is because I want to filter some points out based upon the ratio (R+G)/B.Suggestions are welcome :)Thanks in advance,Martin
Hi there. I have just started to use FME and am still learning this super capable software.I have a question regarding vtk (paraview data file, legacy format).I want to read vtk legacy files and convert to different 3D file format like 3D Tiles or IFC. And it is important to keep attributes when I convert vtk files. So far, I am converting vtk files to stl format using a python script but it won't keep attributes (or values). Do you think I can somehow convert vtk legacy files using FME? or Safe Software can somehow develop the reader for vtk legacy format?? I searched community postings but I couldn't find any answers.Thank you!
Hi,Is there any possibility to know the version of AutoCAD dwg file in which it is saved-in...Prtap
We are using following FME product: FME(R) 2016.0.1.1 (20160224 - Build 16177 - WIN32) We noticed that fields of type 'Lookup' are not supported. We get following error: Microsoft SharePoint List Reader: The Field 'Gemeinde' of type 'Lookup' is currently not supported and will be excluded from the feature schema.Are there efforts underway to support fields of type 'Lookup' in Microsoft SharePoint List Reader in a future FME Desktop Version? Or is there a know workaround solving this problem?
I am having different dataset, that i have to convert to CityGML using ADEs. When am trying to do this, TRANSLATION WAS SUCCESSFUL is displayed (eg: 780 features transformed)BUt, when am viewing it in FME Data Inspector, "THERE IS NO GEOMETRY IN THIS VIEW" is shownI am using FME trail version. LOG TABLE shows this: "The 'FFS' reader was destroyed successfullyFailed to display the table contents due to the following error:----------------------------------------------------------------The floating license environment variable LM_LICENSE_FILE is defined, but is ignored by FME. To enable FME to use LM_LICENSE_FILE, set the environment variable FME_USE_LM_ENVIRONMENT to the value YES."please help me..----------------------------------------------------------------
I am using FME Server 2016.1.1 and FME Desktop 2016.1.3.1 to make a workspace for FME Server that will write a DXF/DWG file with the FeatureWriter transformer. I have to use a template DWG file to be able to write the correct linetypes and block names.But I have noticed that the FeatureWriter transformer, when running on FME Server, will simply ignore the template DWG file I have specified, and write in the log that "No AutoCAD Template file specified". However, running the same workspace, with the same parameters, locally on FME Desktop, the FeatureWriter transformer will use the template DWG file as expected.I have tried putting the template DWG file on the server's local C: drive with an absolute path, putting the template DWG file on a network share with an UNC path, and uploading the tempate DWG file when publishing the workspace. No matter what, the FeatureWriter transformer will always always ignore the template DWG file when running on FME Server.The only way I ha
Hi can anyone please help me to find an answer to keep autofitwidth to all columns in xlsx file
I am using SQL executor to get some data from Oracle SpatialData, Im getting the data but is not possible export/output in a shapefile or .gdb (Polylines)...Please advice
Hello! It appears as though an email address can only be associated with a single FME Cloud account... I wanted to add a new user to an existing FME Cloud account, but because the user already began the process of opening a personal account (using the same email address), he was unable to join the company account. He had to first complete the registration of his own account, and then close it, before he could be added as a user to the company account. Has anyone else encountered this? Is there a way around this restriction?Thank you,Courtney
I'm having issues running a workbench on FME Server which publishes to ArcGIS Online. It appears to be an issue with the authentication in ArcGIS Online. I authenticate my Web Connection to ArcGIS Online, and publish the job to FME Server where it shows that the connection is authenticated/successful. If I run the job immediately, it is successful but it appears the connection is broken if I check again in a few hours. The green tick disappears and the job will fail if I try to run it. Is there a step I'm missing to allow FME Server and ArcGIS Online to authenticate with each other? It seems to me as though the token is checked out when I publish the job immediately, and is then revoked by the next time the job is scheduled (daily).
The behavior of File Copy writer reported in this question seems to be a defect of the current version of FME.filecopy writer creating empty folder in same location as fmw workspaceCould you please check this?
I am trying to import data from GTECH data base into a File Geodatabe. when I used the Oracle Spatial Relational Reader , I get only two tables our of hundreds of tables. so I switched to using the Oracle Spatial Object. when I use it I get more tables showing and I am able to import them. however, there are many tables do not show on the table list in the reader though. what would be the reason behind that?
I am trying in many ways to convert an SDE raster dataset into a PostGIS raster table, all I need to do is simply copy the table and its content without any manipulation in terms of data or schema. The native table is in SQLServer and it has only 1 record. I tried in many ways.Using the appropriate readers writers (SDE => PostGIS Raster). it copies only a non relevant schema with no dataUsed the native SQL Server reader (Spatial SQL Server => PostGIS Raster), it reads the feature but when it comes to write it says Failed to obtain raster from feature. Only features with raster geometry are expected. Both with Dynamic and automatic schema definition. Nothing just a schema with empty fields is created.I tried to use SQLCreator and feature reader . the features are read of from the native SQL Server but when it comes to write, again just empty unwanted fields.All I would like to do is to recreate the same exact table, schema and data from a SQL server table that contains the raster
Hello all,I am interested in changed the output format of the entire GeoJSON document. I am converting an ESRI shapefile into a GeoJSON file and my output from that is unreadable in a platform i am using. Is there a way, manually if needed, to create a layout that the file will fit to?
I have created a SQL Server in in Microsoft Azure with a database containing a table with of int, float, varchar and datetime data types.I have a workbench (2017.1) that is using a FeatureReader and the Microsoft Azure SQL Database Non-Spatial to read data from Azure SQL Server and write to a shapefile.his works great in desktop, however when I publish this to FME Cloud I get the below error.Module 'MSSQL_AZURE_SPATIAL' is unavailable for use with this FME editionI know FME Cloud does not run Microsoft ServerIs there a way to read Azure SQL Server database tables in FME Cloud?
I'm trying to create a connection to my Microsoft SQL Server database while setting the connection parameter trustServerCertificate=true. But I see this in my log file:Creating connection using connection string 'jdbc:sqlserver://********' and properties '{integratedSecurity=false, trustServerCertificate=false, user=***, password=************, applicationName=Safe Software FME, database=******, encrypt=true}Is there a way to set this to true?