Data

Hi,I want to read google sheets with FME, in order to update AGOL feature service.On my Google drive, I have a folder "HEBERGEMENTS", with 9 spreadsheets.In FME, I defined a Google Drive Connection, and I use the GoogleDriveConnector. I can access to the folder HEBERGEMENTS, but when I run the connector, it reads nothing...Is there a option to see files ?I don't understand...Because the goal of that is to run my workspace with a batch.Thank you very much for your help !Christine  

Currently, I have a dataset which looks like this:I am wanting to produce something that looks like this:Rather than having each different activity displayed as a separate field name, I simply want to convert this into a single field name "Activity" then list the different activity types as a value on separate rows instead of the field header. I then want to apply the relevant frequency field to each activity. Anyone have any ideas? Thanks in advance

When I add a feature type reader from AGOL, I get the coded values and not descriptions. How can I expose the domains on the reader for AGOL?

Hello There I have features that intersect with each other I want to create a group based on their interconnection as you can see in the picture there 3 group each group has features that intersect with each other to create a chain Thanks 

Hi, I am using FME Desktop 2019.2 64bit so cannot use the esri layer file reader (I am not sure this would give me the info I am after anyway as I want to interrogate the data source). I want to open an xml file within the .lpkx file to get the data sources from it (these are all buried in Portal with no way to get that detail using the Rest API - it seems). I have found them on the file system. Now I know I could use some python to unpack it - but using command line and 7-zip (or maybe one of the transformers on FME Hub) but didn't really want that extra step and then delete the unpacked version afterwards. So I guess my question is: Is it possible to change some configuration file in FME itself to recognise .lpkx as an Archive file? If so I would also need to do this for FME Server. This is probably not an ideal solution and the safest would be to just unpack it, then delete it afterwards? Kind regards John

I am currently processing a bunch of DWG files where the majority of them are working fine. There are a handful that result in the above question title as the error message no matter what transformer I use, how few or many CAD layers I involve, whether it is a new blank workspace or not. The error even shows up when I select 'OK' in the 'Add Reader' window and before I even select what layers to load in the following individual feature types window.  Any ideas on why this might be happening for some dwgs and not others? TIA

Hello, Is there a way to read Garmin format TCX and FIT ? I can't find any info regarding readers for these 2 formats. Thanks

I'm using an ArcGIS Feature reader to read a layer with two tables. After reading the two tables, I join them. I add and remove many attributes. The last step of the workspace is to use an ArcGIS Feature writer to populate a layer.  In the past when I've done this, the ArcGIS Feature writer created the ArcGIS feature service. Can I write to an existing feature service? ArcGIS Online (AGOL) field names must be 31 characters or less and not have spaces or other special characters (underscores are fines). Display names are also supported which can be longer than 31 characters and have spaces.  Ideally, I'd like to specify a list of attributes with data types for the feature service.  Questions:Can I create an FME workspace to write to an existing ArcGIS feature service? This is an ArcGIS question, but I'd like to easily create ArcGIS feature service based on a list of field names and data types

When writing a KML-file all characters with '&' are written as '& 'This also happens with '<' and '>' which will be exported as '<' and '>' This is the result<SimpleData name="sign">Electrical & hydrogene</SimpleData>But i need<SimpleData name="sign">Electrical & hydrogene</SimpleData> Is that possible?

Is it possible to DELETE files using the WRITER "File Copy" ?  UPDATE:I have created a custom transformer that uses the solution (FeatureWriter in MOVE to null) and uploaded to https://hub.safe.com/publishers/sigtill/transformers/filedeleter Feel free to send any feedback related to this.

Is it possible to create a bar chart with space between the bars? Currently they are merged together?  

Hello everyone, I noticed that FME does not read the AutoCAD 3D element types- mass element - mass group (which is composed from mass elements)at all. On the other hand, 3d solids are read in. Below is an example of this.  Is there any way to read in mass elements from AutoCAD files with FME (e.g. by suitable parameter settings on the reader)? Alternatively, is there any way that with FME, I can detect if there are mass elements in an AutoCAD file (a simple yes/no would be sufficient for me)? Here is the example: I have some DWG file containing four 3D objects, one mass element, one mass group and two 3D solids, one of which is the mass group converted to a 3D solid: When I now read this DWG file into FME (Autodesk AutoCAD DWG/DXF reader with standard parameters), only the

Hi all.I'm trying to consume a WFS service (Geoserver), which for some reason only works as version 1.0.0. This even though that the capabilities document clearly says 2.0, and accepts all versions.In versions 1.0.0 (and 1.1.0?) the parameter "typeName" is used to specify the layer (feature type), but this is later renamed to "typeNames" (with an S).I get an HTTP error 401 from the service when attempting to fetch data in version 1.0.0, but the very same URL works if I just add an "s" to "typeName".Can FME be tricked into instead using or adding the "typeNames" parameter?Actually, URLs may contain both "typeName" and "typeNames" parameters with the same value, which would make the requests robust against version problems. Can this be achieved?Cheers.

I'm trying to convert datetime values in ISO format to FME, because PostgreSQL database refuses to write that value as "timestampz". I have tried to both autodect and %Y-%m-%dT%H:%M:%S$The preview show correctly the conversion:But the ouptup stays the same:Any hints? Thanks

Hi Safe team, Do we have an idea on which formats support mesh vertex colors? I can't see Information in the quick facts area for formats (e.g., OBJ) about vertex color support. It seems like it's becoming more an more common to see mesh objects with vertex colors instead of a texture. I'm just wondering what formats FME can read and write to where vertex colors are supported. So far form testing I can see OBJ supports reading them? A follow up question, is there anyway to convert these to regular appearances or a texture atlas for formats where the vertex colors aren't supported? Perhaps @daveatsafe​  has an idea? 

Hello all,I come from the BIM (Building Information Modeling) world and I have been looking for solutions to extract data from 3D models for a long time now. Recently this implied I had to try extracting data from 210 Revit models with an average file size of 200Mb. After different tries, I'm now on the FME desktop path, to which I'm fairly new to..., for testing with IFC (open source) files extracted from Revit models.Essentially there are a few key parameter in Revit Basic sample project in IFC from Revit (I think you guys call them attributes) that I would like to extract. Unfortunately, I see those parameters in different "viewers" (Navisworks, Solibri) from the same files I'm using for FME Desktop but I have no luck with the latter. I can expose those attributes but never get

How can I extract MI_STYLE and MI_PRINX from the mapinfo tab to the writer? I am trying to write mapinfo tab files to SQL Server but it doesn't extracting these two columns. In past we used to use mapinfo easyloader. Can anyone help me? Thanks Mona

File Encoding is Unicode 8-bit.Tried changing the Write Byte Order Mark for Unicode to 'NO'. Still facing the same issue.Cannot make any changes to the receiver of this file. Can you please suggest how to get rid of these characters? Thankssresree

Hi, I have looked into several posts here but not really found similar results. I tried to write my DWG into a Map 3D dwg to for example write attributes like creation instance into my DWG which worked really well: Writing attributes to AutoCAD User Properties (safe.com) However, I want to be able to add / edit attributes for my features that are readable by Bentley Microstation . Every result I found is DGN but the format must be DWG. Is there any way to write attributes to a DWG which is readable in microstation? Result above has no attributes or properties so doesn't work. Originally the results I don't want in block but that rule can be bent so every single features can be a block if that is the only way.

hi fellas,I'm trying to translate a dgn file, but it fails to load correctly. when i open the file with Bentley Microstation Connect edition I can see the design, but when i try to open it with fme data inspector it fails to load the design (it loads all the features but they are not shown graphically).attached are pictures to illustrate what I get when trying to open the design with Bentley Connect, and with FME Data Inspector (using v7, v8 and xfm v8 readers).can you help me with the issue? best regards,Sharbel

In the conversion process of using the same educational model note that using the system Epsg4326 The examination is correct When adding the converter as it is in the lesson, converting from the canvas and using the reader and writer’s coordinate syste

Good morning,I’m trying to transfer data from ESRI to PostGis.Unfortunately, I encounter the following error:Error was 'ERROR: value too long for type character varying(50)I understand that the created field is too short but I can’t change it...Thank you for your help.

I have tried the RasterDEMgenerator and the ImageRasterizer but both give errors regarding the input features or geometry. I have tried different feature settings but to no avail.

I want to use the PythonCaller to read a value from the header of an ECW file. The value I am looking for is four characters long, starting at the position of 37. I want to then print the value. This is the code I have so far; import fme import fmeobjects # Template Function interface: # When using this function, make sure its name is set as the value of # the 'Class or Function to Process Features' transformer parameter def processFeature(feature):  pass   # Template Class Interface: # When using this class, make sure its name is set as the value of # the 'Class or Function to Process Features' transformer parameter class FeatureProcessor(object):  def __init__(self):   pass  def input(self,feature):   pr

How would I build a workspace with an ECW Writer transformer, followed by a Python script that modifies the ECW image file after it has been written?