Data

tested it with 3ds, shape and object.the CRS is 25833 GeometryValidator => passed through "Solid Orientation"FME 2020.1  

FME is aware of the file extension .nc, but appears to be unrelated to the file type I am using. Please see attached file sample (note the original file name is louves.NC)

(on FME 2020.2) Hi,  I have a workspace with an Oracle reader in which I want to filter the features to read with a WHERE clause on a column, let's say COLUMN_A. I created a Choice type published parameter named colA, which contains the possible values for this column.This way I can filter the features from my table when COLUMN_A contains the value selected in the Choice list. The WHERE clause is : "COLUMN_A" = '$(colA)'Quotes character are used to handle the values with spaces. Problem : the values can contains the quote character as well !What is expected for the database (Oracle) is that the simple quote in the value should be doubled. For exemple the colA value TES'T should be transformed to TES''T. I tried to find a way to replace the simple quotes with two quotes in the WHERE clause using SQL string functions, without success because it always require to have the doubled quote. The only workaround I found for the moment is to change the Choice parameter to a Choice with alias par

Hi, I have a set of hundreds of shapefiles and another set of hundreds of rasters. I don't want to use ESRIReprojector transformer individually for each reader and writer. What's the most efficient way for batch transforming their CRS in FME?

When using the MariaDB/MySQL in either Update or Delete mode, how to you specify the key to match the record? Is it using the fme_where format parameter because there doesn't appear to be mention in the Writer docs. Does it support fme_db_operation also?

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 the file in FME.  Thanks in advanceJonathan

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), except that one fails when input to ArcGIS Pro.Does anyone have any

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 FME is giving for the records when it fails to write is I have written the compl

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't work either because it