Data

Hi,I need a text based format that can handle measures values for futher treatment in QGIS. Can GeoJSON suitable for this? I currently does not manage to keep the M-values using GeoJSON as Output port and I currently can't determine if I miss some configuration option or if the format does not handle M-values at all.If GeoJSON is not the answer, what file format could I use? I need to handle custom CRS as well (EPSG:2154).Thanks for your help!

Hello,I need to control the projection associed to a dwg in fme 2018. I have tried to read the autocad_entity : autocad_info in the autocad layer 0 of a Autodesk AutoCAD DWG/DXF reader with the [read drawing system variable to read] checked but it seems to have nothing provide in any of de field.Is anyone know how to get this information?Thanks by advance

Is it possible to append to a json file saved as an Azure blob? AzureBlobStorageConnector overwrites.

FME Desktop 2020: How to permanently reorder the fields of attribute table of geodatabase feature class? In the screenshot below, I wanted to permanently move F3 to be to the right of F1. Which tool can be of help on this? 

I'm trying to read the attached Civil 3D file, extract non standard attributes and certain geometric details such as edge strings. I've attached a screenshot of the file when viewed in Civil 3D, and displayed the 'Property Sets' or attributes I want to get out. I've also attached a shot of what FME makes of the file.  Anyone know how I set FME to read the attributes in the dwg and expose them so they can be worked with in Workbench?

Hi,Is there a way to read Civil3D Feature Lines in FME, without having to explode them to 3D Polylines manually in advance? Jasper

Hi, I am using FME to write a Shapefile to PostGIS and I am wondering if there is a way that you can specify that it writes polygons only? When it is writing into PostGIS it is coming in as an unknown geometry with a warning triange!

I am utilizing FME Cloud (Server 2020) to run a regular ETL pipeline from a Firebird database using their Jaybird JDBC driver. Working with a local instance and FME Desktop seems to have no issues with connecting and running SQL statements.The database cannot have external ports opened due to sensitive data being stored within it. However, we are able to create an SSH tunnel to a jump server that is otherwise locked down which FME Cloud could then use to create a connection. Needing to keep a secure encrypted connection throughout the entire path I have managed to load some external Python libraries and establish a temporary SSH tunnel from the FME Cloud instance to the jump server for the duration of the workbench execution. I have tested this connection by using the Firebird Python library in a PythonCaller to execute an SQL statement successfully.However, when I try to use the SQLCreator or SQLExecutor with the already established to work JDBC driver with this local SSH tunnel it fa

Greetings!I wanted to start using FME 2019 today with a new workflow I'ven been tasked to create. It's pretty simple: read polygons from a DWG file and store them in a SHAPE file.The source file has many layers, so my idea was reading all the layters except one (it contains texts I don't want). I have checked the "Single Merged Feature Option" and in the "Feature types to read" parameter I have picked the ones I want:When I try to run this, I get the following error:ERROR |ACAD reader: The encoded string is not a valid fme-wwjd string: 'ELC.02 - AREA DE EXPANSI\xC3\x93N OESTE'It seems the Reader doesn't like the accents in the layer names.If I use "Single Feature Types" instead of merged ones, FME is capable of reading all the features.I still have FME 2018.1 installed, so I have tried the same steps in that version and it works fine with merged features.Could this be a bug of FME 2019 (19238) or is there something new about that reader that I am missing?

I need to use the ASCII 36 ($) character in the name of attributes on a geopackage file. In the direct way is it impossible, because the Use Attribute pane of the Feature Writer for geopackage changes the '$' char into a '_'; same story using an opportune schema in 'Dynamic Schema Definition'.Is this a FME bug? Is there a way to workaround this issue?

I specified a ADE schema file in CityGML writer and tried to export a attribute to a attribute of cityGML difined by ADE.Then the attribute generated as follows: <gen:stringAttribute name="aaa_extended_attribute{0}.aaa_key_value_pair_aaa_key">    <gen:value>1</gen:value></gen:stringAttribute>   <gen:stringAttribute name="aaa_extended_attribute{0}.aaa_key_value_pair_aaa_key_codeSpace">    <gen:value>../abcde.xml</gen:value>   </gen:stringAttribute>   <gen:stringAttribute name="aaa_extended_attribute{0}.aaa_key_value_pair_aaa_string_value">    <gen:value>XXXXYYYYZZZZ</gen:value>   </gen:stringAttribute> The results I'm expecting are as follows:   <aaa:extendedAttribute>   <aaa:KeyValuePair>      <aaa:key codeSpace="../abcde.xml">1</aaa:key>     <aaa:stringValue>XXXXYYYYZZZZ</aaa:stringValue>     </aaa:KeyValuePair>  

I can't connect to a specific ArcGIS Server feature service using a FeatureReader.I get the service layers listed as output ports but when I execute the translation it throws this error:ArcGIS Feature Service Reader: Encountered an unexpected error. The error code from the server was '400' and the message was: 'Failed to execute query.'. Details: '' Using a Reader instead all service layers are read without problem. I don't understand why the Reader connection works different than the transformer. Any idea?Generally I would stick to the Reader connection and forget about this weird thing but I prefer using a FeatureReader here because I need to catch any error and work further with it in the translation.   

Hello, I am trying to save multipolygon .shp file to .wkt file. See attachment. Is it possible to save the output of my workbench directly to the file with extension. wkt? I noticed that .wkt Reader exist, but I cannot find Writer. I know that I could save it to .txt, but it doesn't solve my problem because in the next step of the process I need to seed this file to external tool which reads only file with .wkt extension. I would like to avoid manual step of changing .txt file extension into .wkt as I would need to do it multiple times.

Hi, I have a ESRI-JSON file which geometry looks likes this: "geometry":{"hasM":true,"paths":[[[333334.24000000209,6611588.879999999,0], ...Note that the hasM property is true.I am trying to convert that file (among other operations) but when it is read by FME it seems that the third coordinate is parsed as a Z value and not as a measure: Where I should expect something like that (2D but with true measure): Question: how to deal with that data to output a true M-Value? I am thinking of two approches:Find a proper setting in the ESRI-JSON reader what would parse the M-value as a true measure and not a Z ; I did not find that kind of settings if it existsLet the reader as it but find a way to transfer/copy the Z value into a M value using transformers; I did not find the proper method yet Any thoughts about this? Thanks a lot!Jean

Hello all, I'm wondering if anyone has any suggestions for using FME to compress the delta tables of an ArcSDE enterprise geodatabase? I'm thinking it could be achieved using the python caller to run the ArcPy command for executing the compression. Does anyone have and suggestions or best practices in this area? Thanks!

Hi! Is there a way to change the "else if" condition statement to an "if" condition? I want to assign two values ​​to the same element and with the "else if" I just assign the first value.

Hello FME Support,Is there any news on the 'Unsupported Font Issue' in the PDFWriter? https://knowledge.safe.com/questions/2007/unsupported-font-family-message.html We need to be able to read DWG drawings in a range of True Type Fonts but it keeps failing and reverting to Helvetica when writing to PDF.  

Hi, My name is Jie, and I'd like to build a geological voxel model as the following picture copied from the question asked by @philip_wehrens​ . I want to know how to efficiently build a model like this?  With this model, I want to export the model for Finite Element Analysis. To be specific, The finite element code is developed in Matlab. All the best,Jie

Hello,I have a table in Postgreql with geometry that I can perfectly load in QGIS but the FME reader doesn't show the geometry. The allowed geometries is postgres_none but they are polygons. What am I missing? TIAJonathan

I have multiple .dwg files and a shape while which consists of polygons (Grids). I would like to clip the dwgs by the polygons and save them to individual new dwgs.  I tried Clipper and LineOnAreaOverlayer. However, quite a lot of objects are rejected as I have different geometries in it or objects like in the image How can I clip all objects in the dwg regardless from object types?  Thanks in advance.

I am unable to see any ArcGIS Pro python interpreters available in Options>Translation. I have Pro 2.6.0 installed and FME Desktop 2019.2.3.2.

I would like to export the DGN-meshes to DWG-solids.The strange thing is that not all the DGN-meshes become solids in DWG.I don't get it why :-S. Attached is the test dgn and my workbench.Could somebody take a look and change the workbench so I will get all 3D solids in the DWG? That would be great! Thanks!

Hello, I am trying to create a reader to process AGS 4 data but am struggling with it a bit.For those who haven't encountered the data before, I have included an example below.When opened as a text file, the data is all in one column. It is grouped into sections that define a subsection of the overall dataset. These sections always start with the "GROUP" header and end with a empty line before the next group header. Fortunately, the groups always follow the same pattern: "GROUP" = Name of the group"HEADING" = The different data headers (These would be the column headers if brought into excel)"UNIT"= The Unit of the header"TYPE" = The Data type"DATA" = The actual data for each header. "GROUP","GCHM""HEADING","LOCA_ID","SAMP_TOP","SAMP_REF","SAMP_TYPE","SAMP_ID","SPEC_REF","SPEC_DPTH","GCHM_CODE","GCHM_METH&quot

We have a workspace scheduled multiple times per day, from 6 AM till 6 PM every two hours. This workspace reads information from a SharePoint site (on-prem) using the SharePoint Reader.All schedules are running OK, apart from the first one at 6 AM. We get the following error every day:2020-03-11 06:00:54|   1.0|  0.0|ERROR |Python Exception <ReadTimeout>: HTTPSConnectionPool(host='xx.xx.com', port=443): Read timed out. (read timeout=20)We did some checks on the FME and SharePoint side on the machine, but did not see anything that could cause the timeout. What could cause this?In addition: the timeout setting appears to be fixed at 20 seconds. Is there any way to modify that? FME Server 2019.0.1 Build 19253 - win64 - patch 1FME Desktop 2019.0.1.0 Build 19253 - WIN32

I am merging data from and existing ESRI File Geodatabase with data form excel spreadsheet using globalID.  I then want to write that data to new ESRI File Geodatabase,  preserving the GlobalID from the existing fGDB.  I can see this is possible in SDE.  is there a way I can do this in non-SDE fGDB.  I am using FME version 2019.1​