Data

I have a workflow in which i convert .dgn and .dwg files to postgis, in this process I spatially join the text to areas, as I need them for attributes. My problem is the text alignment for the dwg files is baseline_left.Even though my colleague centered these. Is there any workaround, or possibility to get the placement to center?I've tried using an offsetter, but the areas are very different in size, so the offset is not uniform distributed between the points.  The .dgn files does not have this problem.  EDIT: The problem is that: the placement of the points are not what my colleague sees in her program, there they are centered. But they are not centered in the areas when I open

Anyone run into this error before trying to write data to ArcGIS Online with the writer (applyEdits)? In this instance, this came from ArcGIS Data Interop running on ArcGIS Server.{"code":1000,"description":"The request limit has been reached. Contact esri support for assistance."}(Also cross posted on the esri community)

I have read http://fmepedia.safe.com/articles/FAQ/Autodesk-AutoCAD-Civil-3D and wonder how you are handling surfaces. Inputdata is a Surface/TIN and I also want to write to a Surface/TIN in DWG-format.  Can you read the Surface in Civil3D as as "triangles" , then aggregate these within FME and write them out as Surface?

Hello, I would like to get the value that comes from a Counter transformer through the Initiator input in a SQL Executor transformer, to make a query that uses this number Here is my request: FME_SQL_DELIMITER ;alter sequence cajxg_CE_sequence increment by '@Value(COUNTER)'; I tried or without the quotes, I also tried using TO_NUMBER and if I replace my attribute by a number, it works But when I perform the query I get the error ORA-01722 (Invalid Number) When I try to do a select with this attribute, it works Thanks,

I have 18 polygons in a database. I want to retrieve the x and y value of each CenterPoint of the shorter side of each polygon (approximately where the red dot is on image). I also want to create a new attribute called sequence. The first polygon on the left should get the value 1, the second value 2, the third one value 3 and so on. How can I achieve this ?

Hello,The following settings of the StringReplacer works for some feature attributes, and doesn't work for others.This is aimed to replace dots for commas (or vice-versa) in a decimal number.So, it normally works for example like 100.5 -> 100,5 But, I just used the very same transformer in a different feature, and the result is zero, for example: 100.5 -> 0 Both columns are 64-bit real. I can see in the the "cached features" in Data Inspector that a valid decimal number goes in, and out goes the zero. Any ideas?Thanks in advance

I have tried reading out to a file geodatabase and then reading that out with the where clause to shapefile but would like to try something more direct

Hi, can FME write PDF/a format files? I don't see any options in the Geospatial PDF writer.

Can any one provide guidance on how to convert a .TML file to a ESRI shapefile for feature class?  Unfortunately I'm not able to upload the .tml and schema to this forum. They can be accessed here: https://drive.google.com/drive/folders/1pnvv5YCRYUE9h5OOt1dNf3jAChWL686F?usp=sharing

Hello,I need to compare strings from two sets of data and to find strings which contains the strings from other set. For example, in first table I have strings: column1ABCABCDABBABBDACCACCD In second table I have stringscolumn1ABCAC I need to compare them and have the result something like this:column1; column2ABC; ABCABCD; ABCABBABBDACC; ACACCD; AC Rows without data in second column may also be omitted. What would be the best approach? 

Hi Community!I'm trying to access and read/upload/download data from a S3 compatible cloud storage. Since the cloud storage isn't an S3Amazon i cannot get the S3Connector to work. The S3 compatible cloud storage is equivalent to S3Amazon storage and should be compatibleDoes anyone else know how to do this? 

Hello all.Last year, I delivered a number of Shape files to a customer, which they had no problems in using.Now I've adapted another of our systems to create Shape files as a supplement to an email message.These latter Shape files cannot be read by their ArcGIS Pro. The error message is "Failed to add data: ... A user-supplied component or subscriber raised an exception (Exception from HRESULT: 0x80040208)". I've also tried to apply Geopackages, but they err the same way. Both output routines uses FME. The former used straight up fixed writers, and the latter uses FeatureWriter, but that shouldn't matter, right ?I cannot see any difference between the two Shape files, and QGIS reads them both without any qualms. Apparently they can read the offending Shape into QGIS, and have it save it as another Shape, that works in their ArcGIS Pro.I cannot see any difference between the two flavors (in QGIS), ex

My last pair of FME socks from the 2017 UC are on their last legs. Probably the last day I'll be able to wear them. I'll have to put them in a safe place until I can put them on for the UC in August. Anyone else need some sweet new Safe swag? 

Which FME requires to connect with SAP HANA ?i have FME Desktop , is there a method to connect with SAP Hanai wish that someone shares his experience to integrate FME with SAP HANA and also which ideas and problems that he faced .Thanks in advance .FME Desktop 2020

I am having trouble connecting to the API at https://developer.vasttrafik.se/portal/. I would like to get the public transport stops (https://developer.vasttrafik.se/portal/#/api/Geography/v1/admin), but I am stuck, I keep getting "HTTP/1.1 403 Forbidden" from the HTTPCaller. I have tried using "Authorization" as suggested at https://community.safe.com/s/question/0D54Q00008WImfCSAT/using-fme-to-call-power-bi-via-the-api-to-refresh-data-sets-dynamically-i-am-stuck-with-the-authentication-piece-for-the-bearer-token, but no success. Any suggestions on what I might be missing?

Hello Brains trust , hoping someone out there can help me. My workspace is as follows.2 arcsde feature readers. sde1 contains records and attributes that are pulled from a number of sources to create areas of interest.sde2 contains one of the source datasets that are used to update sde1. sde2 is also a source of truth dataset so the geometries are the most current.nb - the sde's have been maintained using ESRI not FME - trying to automate the process. My work flow checks the geometries of sde2 against sde1 and were they don't match I use sde2 geometries to UPDATE the sde1 records (i use the fme_db_operation attribute to identify that it is an UPDATE and i keep the attributes from sde1). Simple enough. However, some work and some don't when writing (have been using a process of elimination to narrow down the records that write and don't but nothing in particular is jumping out). The error F

I'm trying to speed up the processing speed. There might be a few different ways to do this. I'm trying to make incremental changes to a workspace and every time I run it, it takes about 40 seconds. I have two tables in ArcGIS and I use a FeatureJoiner to join them in FME. One of the tables has a data field. I'd like to only process a range of dates. I have about 8,000 records total and I'd like to limit it to 1,000 or so records. Once I get my workspace functioning correctly, I'd like to remove this date range limit. I'm very new to FME.

While connecting to MongoDB Atlas I'm getting error TLS Handshake failed. However, when connecting via MongoDB Compass, the connection is successful.  Attached is the screenshot of the error. Could anyone please share MongoDB Atlas is supported via FME? If yes, how to connect to it? Best,Sarthak

I have a workspace which reads rows from an excel file and writes the same rows to an other excel file using dynamic schema definition. Gets the schema from the excel file which is read. My problem is that the first row that is read is skipped in the writer. In the attached example the output will only contain the second row of TestExcelWriter.xlsx

I'm running into a problem with the Google Sheets (V4) Writer. We have a Tableau Public Dashboard connected to a Google Sheets Document. Tableau Public will only daily update it's data when coming from Google Sheets. Other data formats are not supported.To keep our dashboard up to date I'm writing a selection of the last 24 months of data from our internal database to Sheets. About 1,5 million records. Using a 'truncate existing' mode. Only 1 column of data. All columns from B to Z have been removed from the sheet. Writer is set to end at column A . So no extra colums are created.When starting with an empty sheets this runs perfectly fine but after a week of daily truncates the sheet contains nearly 10 million rows. Only 1,5 million contain a value, the rest is empty. So not a real truncate, just a 'delete value' is performed. The next day my workspace crashed because the sheet will exceed 10 million cells...A drop and create won'

I am importing an AutoCAD DWG with multi-leader blocks for asset locations. The issue I am running into is that the value showing up in FME for the "TAGNUMBERS' is the Default value vs. the value that shows up in AutoCAD.  From AutoCAD: I'm trying to extract the 'T9' text from the MLEADERs shown here:  These are custom MLEADERS developed by the drafting department.  After different attempts to explode blocks, expose attributes both in Model and Paper Space, different combinations of parameters, etc. I attempted 13 different combinations to import the DWG and now luck, I keep seeing this in FME:  FME is only recognizing the 'Default' Tag Number.  I've tried to bring in both Model and Paper Space in a single reader to match Entity Handles, but no luck.

As the question suggests I cant seem to find instructions on how to convert LAS scans to GLTF format and retain the color_red, color_green, color_blue values. I've expereince with successful conversion of CAD models to GLTF but the resulting LAStoGLTF refuses to play ball. I've tried various combinations of reading LAS > use PointCloudPropertyExtractor to expose color data and even forced the issue with PointCloudLASClassColorSetter but all to no avail. The resulting GLB is created using default white colors leaving me with non-viewable model. Is this translation just too new a possibility for GLTF writer or am I missing something fundamental here (most probably I hope!). Thanks for any advice.Source LAS from Drone:Resulting GLB model:

module skp/skp is unavailable for use with this fme edition

Hi everyone,I have a series of regularly produced Excel files, each containing a number of sheets. The number and name of the sheets in each file isn't fixed.I can read data from all the sheets no problem by keeping the reader parameters blank - but annoyingly for these files the header starts on row 2 and in some cases junk is written into row 1. As such, FME picks up attribute names from row 1, so for one sheet the attribute for column B might end up named"995" and for the next sheet it might be "376", so I end up with a lot of attributes where there should be one - ideally just called "B".Is there any way to force the Excel reader to always use column letter as the attribute name regardless of how many sheets are in a file and what they are called?

https://www.railml.org/index.php/en/