Data

I am converting geodatabase data to JSON and using the HTTPCALLER to upload to an API. The JSON output from FME is adding square brackets[] as the first set of brackets but the API is looking for curly brackets{}. Is there a way for FME to output curly brackets instead of square brackets?The API is also looking for some additional text between the first and second open brackets. Can I insert additional text between the brackets in the JSON output?For example the FME JSON Writer is writing [{json text}] but the API is looking for {site:{json text}} Thanks, David

When converting a 3D model to GLTF (2.0) which has png textures with an alpha band the output looks pretty weird in most viewers. The alpha value in the textures is at the Max (255) so it shouldn't be transparent, however, FME sets the alphamode to 'BLEND'. While I understand the logic in this I think in practice a better default for the alphamode would be 'MASK'. In the image below you can see that the inner cube is rendered even though the outer cube has a texture which has no transparent pixels. In my situation the issue can be solved by simply having jpegs as textures, however, this is often not possible to get.  In other situations, for example billboard trees, you want to have transparency, but in the form of a 'MASK' not a 'BLEND'. I would argue that in 90 % of cases the 'MASK' option would be better than 'BLEND'. I've attached the model for inspection.  Note that this seems to get rendered the same in all the renderers I&

I am having an issue with a specific MapInfo TAB file that when I put it through it's different attribute and geometry filters, it is outputting the wrong size text. The last transformer the file is going through is a DWGStyler where I have a specified height. The strange part that is confusing me with all of this is that the single line text is outputting the correct specified height I have in the DWGStyler, but any multiline text is being outputted as a combined text height. For example I have the height set to be 0.4. The single line text displays as 0.4, a two-line multiline text displays each line with a height of 0.2 thus adding up to the specified 0.4. This to is the same if it three lines of text where it displays as 0.13 for each line. I have tried toggleing the Text Entity Type from multi-Text to Text with the same outcome. Any suggestions would be great. I am more Autodesk than FME. I have AutoCAD Map3D 2014 and am aware that I can import these MapInfo files, but the dat

Hi, I would like to write tagsets for linestrings with display set to 'yes' out to a Microstation DGN file with the bottom-left corner of the tagset being located at the start of the linestring.  When I write the tagset with offset set to 0, some of the tagsets appear at the beginning of the linestring, but some of them appear in seemingly random places. I'm assuming this is related to the radius of the curve of the particular linestring. I have tried following the advice in this article (https://community.safe.com/s/article/writing-microstation-dgn-tags-with-fme) and using a CenterPointExtractor followed by a CoordinateExtractor, followed by an ExpressionEvaluator, but this doesn't put the tagsets in the correct place. I'm wondering if this is because this method only works for polygons and not linestrings? Does anyone know how to calculate the offset of tagsets for linestrings so they are placed at the start of the line? I guess in other words, where does FME put

I worked with one of our interns on developing a pretty simple workbench that queries records from a REST service using a project #, styling the popups and icons, and writes it out to a KML that is then downloaded from FME server using the data download service. I have exposed the attachment from ArcGIS Online and have the process worked out for converting them to base64. The next part that I'm needing help with (why I posted this) is determine the best way to embed the photos in the popup, which are varying content subtypes of image (image/png, image/jpeg, image/jpg, etc). I've attempted (unsuccessfully) to embed the base64 image in html, but it doesn't seem to load. I think the best way would be to save the images in a folder, and somehow reference the local image path in the kml popup... Both the KML and Images would be downloaded through the published data download service.

Hi There,I am using FME to convert data into DWG by using a predefined template. This works fine but has the limitation that I cannot dynamically create layers since they will not match with the template definitions and creating the layers in the workspace has its own disadvantages. I cannot add all possible definitions into the template since the data and therefore the splitsing of the layers is different per conversion. I would appreciate any ideas or other ppl experiences trying to achieve this. Cheers, Itay

I'm working on a project where I need wave models created in MatLab. I have download them but when reading I get rotated coordinates.For some reason, wave models operate with rotated coordinate systems as opposed to conventional ocean models (rlat, rlon). How can I manage to read and rotate this data with FME? 

Hi,I am writing out line geometry with a tagset to a Microstation DGN file. I can't work out how to change the level of the tagset to be different to the level of the line geometry to which it is connected. Is there a way to do this?Thanks,

I want to prepare the mapping from 1 oracle database (11) to another (19). Problem is that the 19-database is not installed yet, and the only way of preparing the migration is from Oracle 11 to a fgdb, which have alle the attributes lower case. Thanks.

Hi, I am using FME Desktop version: FME(R) 2020.1.1.1 (20200817 - Build 20614 - WIN64) Using the SQLExecutor (version 9) against an Oracle Spatial Table, I am running  a SQL statement such as below:select "LINE", "COLOUR" from "SCHEMA"."TABLENAME"  This statement 'runs successfully' when tested but when I expose multiple attributes using the 'Attributes to  Expose' field, this does not work and a single attribute with all the field names concatenated with a comma is being output:  If I expose a single attribute only then the output is correct.  Is this a bug with this version of FME Desktop 2020.1 and or SQLExecutor Version 9, as it does not happen with previous versions of FME Desktop and SQL Executor?Thanks!

I have a google spreadsheet template located on my google drive that I want to make a copy of and move to another folder in Google Drive. The drive connector doesn't allow me to copy or download gsheets. I was able to have a gsheet reader and writer create a copy of the original spreadsheet however the styling isn't preserved... Does anybody have a work around for copying googlesheets and preserving styling?

Hi, In workspace app after I upload data (gdb,shp), I would like to see the fields that can be selected by user? Can anyone suggest any ideas?

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)