Using readers and writers to extract and load data.
Recently active
I'm trying to write data to DWG. For this I want to use the symbology in a DWG file here after called the template.When I inspect the template, I can see all different line colors and line widths. However, when writing to DWG everything gets the same linestyle and color, eventhough I specify it differently. My workbench look similar as the one in example 2 within this tutorial:https://community.safe.com/s/article/working-with-the-dwgstyler The only difference (as far as I can see of course) is that I have a different reader type.I'm using FME 2019. I can't share the template or other data.
I have problems with foreign characters (åäö ÅÄÖ) in hyperlinks using the excel writer. This works(no foreign characters in hyperlink path):file_path = 1312-P11-47-00054.pdffile_path.hyperlink = C:\\work\\table_extraction\\fme\\template_files\\FME_2019_04_24-14_38_13.3\\xml\\09_Administrativa foreskrifter\\1312-P11-47-00054.pdf This does not work(foreign characters in hyperlink path):file_path = 1312-P11-47-00054.pdffile_path.hyperlink = C:\\work\\table_extraction\\fme\\template_files\\FME_2019_04_24-14_38_13.3\\xml\\09_Administrativa föreskrifter\\1312-P11-47-00054.pdf In the Excel output I always get something like this when hovering the hyperlink when the foreign characters are in the path:file:///C:\\work\\table_extraction\\fme\\template_files\\FME_2019_04_24-14_38_13.3\\zz.xlsx The excel file seems to link to itself which is wrong. Its quite strange that the start of the chop off is the \\xml\\. I have tried many different things with encodings etc but failed so far. Anyone have a
HelloI have hundreds of very simple vector geopackages (.gpkg) stored in Azure blob storage. I use the feature reader to successfully read many other formats from blob storage but I cannot get the feature reader to read a geopackage from this location. If I download the data, then use the feature reader, everything works as expected. Additionally as you can see in the pictures the feature reader dialog can see the file but when asked to read it fails. Does anyone know of a work around that doesn't involve downloading all the data? Thank you for your time.
HI,We have a client who asks us the following question:I would like to inquire before installing the FME ESRI edition license.Indeed, we would like to integrate data into SDE database which is hosted on a dedicated server, does FME have to be on the same machine? Currently we go through postgis / SDE connections via ArcCatalog.A priori, we can write in the ESRI SDE, even if FME is not installed on the same machine?Does it work a bit like Oracle / PostGIS? Regards.
My current FME 2020.1.3 works with arcpy from ArcGIS Pro 2.5 and 2.6, but not 2.7. Does the latest FME 2021 support ArcGIS Pro 2.7?
Hello everyone, I have successfully converted a LAS point cloud file into a Cesium 3D tile. Now I want to add zoom levels so that my visualization software shows more or fewer points depending on the distance to the point cloud. I want to speed up the display in the browser. The structure of the file structure can be seen in the pictures. Different folders with Tileset.json files and tiling of the point cloud. Does anyone know how I can make such a structure? Does anyone have experience with it? Thank you
Hi! I've built all of our municipality (including terrain, type of terrain, roads, water, bridges, tunnels, buildings, trees and railway) in FME. The kids keep complaining about the slow railway :) So now I've added powered rail on redstone to get faster trains. But the powered rail does not seem to be activated. If manually removing the powered rail and add again manually, the new powered rail get activated and the train goes fast. Is there a way to programmatically activate the powered rail in FME? I've tried using a block state parameter (which is supported in Minecraft) in addition to blockID and blockData. I called the parameter blockState, and set it to true, but FME does not seem to support that parameter. Can you add that support, or is there another way to programmatically activate the powered rail?Best regards, Ken Karlsson
Hello, please, does anybody there any sample of DGN for Bentley Map XFM Design (V8) Reader? I cant find any sample on websites and one of potential customer wanna see how FME can work with XFM attributes in DGN. Thank You very very much for some sample data!Lubo
Hi folks, In some cases I get into the situation that I want to perform an action on all of the exposed attributes in my workspace. For example, filtering features for which at least one attribute has a value (this idea is linked to the idea 'https://community.safe.com/s/idea/0874Q000000j0VfQAI/detail' and my comment in the idea 'https://community.safe.com/s/idea/0874Q000000j0G6QAI/detail'). It would be nice to be able to quickly select all of these exposed attributes. If I make a custom transformer that uses the 'Attribute_List' type of parameter (either comma or space delimited), I am able to specify multiple attributes to perform an action on. However, when I want to configure the value for this parameter in the main workspace, the 'Select <PARAM_NAME> Items' window popus up, and there I can choose both the attribute names (indicated with the orange attribute arrow), as well as the attribute values (i.e. also options for '@Value(<ATTR_NAM
I am trying to write extended data attached to AutoCAD entities such as lines (DWG file format) and am not finding examples on how to do this. I'm not finding the documentation particularly helpful in this regard. Does anyone know how to do this? See image below, thanks.
Hi, I have a postgis (12) table with 2 geometry columns. The first column is defined as geometry (geometry, 3857). The second column is defined as geometry (geometryZ, 3857). Consequently, the postgis geometry_columns view shows 2 entries, indicating 2 dimensions for the first column, and 3 dimensions for the second column. When writing 3D data to this table, I select the 3D column in the writer properties. This gives a warning in the log: POSTGIS Writer: PostGIS existing table has a 2D constraint My data is forced to 2D, but this is not accepted by Postgis, and my translation fails. When I remove the 2D geometry column form my table, all 3D data is inserted without errors.Apart from just using the 3D column and forcing all data to 3D in FME and then back again to 2D in my application, I do not see another solution. Is there another way to work around this? I'm using FME FME(R) 2020.1.0.1 (20200710 - Build 20596 - WIN64) Thanks,
Dose FME require Arcgis Pro or Server in order to be able to write in file geodatabase?
How can I force that first symbol of generated passwords always be letter? I'm using this:import fmeobjectsimport randomimport string def processFeature(feature): length = int(FME_MacroValues['Lenght']) letters = 'abcdefghjkmnpqrstuvwxyzABCDEFGHJKLMNPQRSTUVWXYZ' digits = '123456789' symbols = '!#$%*+-:;<=>?' all = letters + digits + symbols temp = random.sample(all,length) password = "".join(temp) feature.setAttribute('Password', password)
Hi, I'd like to save raster to the JPEG format. The raster includes an alpha band. In order to save to JPEG the alpha band needs to be removed. When the alpha band is there the background appears white in FME Inspector. When I remove the alpha band the background turns black. That's also the background color when I save the raster to JPEG. How can I work around this problem and make the background white when I save to JPEG? With the alpha band. White background.Without the alpha band. The background turns black. I don't want that.
When I clip raster by shape file by using clppper transformer I 'v used it in fme from arcgis pro v.2.5. I notice that the output raster extent could not exactly same as of shape file. They are not identical. Please someone kindly describe me and clue some resolution about this problems.
How do i set FME Workbench to write a GeoTiff with the PixelIsPoint header? Every setting i try writes a world file with the coördinates of the middle of the top left corner pixel and a model tie point with the top left corner of the top left pixel and a PixelIsArea header. QGis and Arcgis pro show the correct position with the current settings but Autodesk seems to shift the file half a pixel. I tried to fix this with the "Ignore Raster Type Key" setting or the "Write esri compatible coordinate system". I tried setting the RasterCellOrigin to 0,0 or 0.5,0.5 But all files seem the same. Loading an ASC file looks correct. This file contains the lower left corner of the file. Center of the attached files is 155000 463000
I've been given a CSV file that has a mixture of line ending types, some are LF and some are CR. The first line is blank with a LF, followed by a header line with a CR then all the data records which are terminated with LF's. The CSV reader is thinking the terminator is LF so thinks the header line is both lines 2 and 3 which is messing it up. Other than reading the file in as a whole and changing the CR to LF, saving it and reading it in again does anyone know how to read this in?
I need this for my post-graduation project and I would be very grateful to you guys if you can do this for me😥 😥
Greetings, One of the sales pitches for FME is that it handles IFC well. Safe also recommends IFC as the transport format from Revit to FME.Imagine my surprise when I get the following message when trying to parse a file containing IFC rebar elements:"The IFC reader does not support the following type: 'IfcSweptDiskSolid'. All instances of this type will be skipped" So, in other words FME has poorer support for IFC than many open source converters? Is this correct or is there any way to augment or rectify this situation?If so FME will remain a viable tool for us, otherwise we'll have to move elsewhere. Thanks in advance!
Hi, I have a trajectory file with GPS time and coordinates from Mobile Mapper Ladybug camera and want to convert to .gpx file. The structure of .gpx seems to require quite a few additional attributes. Anyone has any ideas or suggestions of how to process CSV?Regards,Maksym
Hi, I have a feature reader pulling data back from a WFS The Ignore get feature error is ticked. Yet when I run the task I get the following error: 2019-10-15 10:21:38| 9.8| 0.0|ERROR |XML Parser error: 'Error in input dataset:'https://geoserver.xxx.com:443/geoserver-cluster/wfs?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetFeature&TYPENAME=workspace%3Abasin_provinces&NAMESPACE=xmlns%28workspace%3Dworkspace%29&FILTER=%20%20%20%20%20%20%20%20%3Cogc%3AFilter%3E%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%3Cogc%3APropertyIsGreaterThan%3E%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%3Cogc%3APropertyName%3Echangedetect_date%3C%2Fogc%3APropertyName%3E%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%3Cogc%3ALiteral%3E20180101%3C%2Fogc%3ALiteral%3E%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%3C%2Fogc%3APropertyIsGreaterThan%3E%0A%20%20%20%20%20%20%20%20%3
I have the new version. The old one used to do it easily.
Hi, I often get this messeage when I try to read PDF documents (floor plans) as raster. When I try to read the same PDFs as vector it works fine. But I just want to read the PDFs as raster because I want to convert the PDF documents to the PNG-format. How can I avoid this message? My estimate is that I can only read approximately 25% of the PDF documents I would like to read. I use the featureReader to read the "Adobe Geospatial PDF"-format. The log says: Merged 0 schema features read from 1 datasets into 0 resulting feature typesUniversalReader -- readSchema resulted in 0 schema features being returned
Hi there,I use FME Desktop to bulk-load to elasticsearch. I'm building a new application based on elasticsearch 7.1.1 but mapping types were removed ahead of this version;https://www.elastic.co/guide/en/elasticsearch/reference/current/removal-of-types.htmlAre there plans to update the reader/writer to be compatible with elasticsearch 7?Thanks,Campbell
Should I use any transformers? Can someone help me with the exact inputs I have to give to the software to convert a Revit/IFC file into ArcGIS file