Transformers

Can anyone advise the most efficient way to bulk extract attribute string lengths?

I've used the AUTOCAD_OD Reader to get the table and Attribute Manager to add the column and this seems to work. I've even output to an Excel spreadsheet to see that the column has been added, but I can't figure out how to get the change back to the Original drawing. Any suggestions are appreciated.

Hello, I am looking for the equivalent to the "Append Fields" tool in Alteryx, where many rows from one table are replicated for each row of another table. For example:Table 1:Table 2:Target Table:I've searched and experimented, but can't seem to sort it out in FME. Any advice? Thanks!

I have an FTP Caller that keeps throwing the error: FTPCaller (FTPFactory): FTP info: Failure establishing ssh session: -43, Failed getting bannerFTPCaller (FTPFactory): FTP info: Closing connection 0FTPCaller (FTPFactory): HTTP/FTP transfer error: 'Failed initialization' I can access the file on the ftp site using other ftp clients, and I have tried different configurations of the FTPCaller but I can't get this to work and I can't find much info on the error. Has anyone seen this before? Thanks!

I have multiple tables and need to check if their schemas conform to specs which are specified in text files containing field names separated by line breaks. How can I compare if the field names are mapped correctly?

I have set up a http caller with query string parameters. It would appear that the server throws a 500 error when its finished returning the records. Does not appear to affect results but would like to get rid of error.

Hello Sir / Madam,​I have many files (more than a hundred of files in .json format - text). I would like to extract certain text from each of the .json files and put all the text in a single text / csv file for further study.​I am just wondering if it is possible to do it on FME? Or what transformer I would use?​Here is what I really want to get for my report.​File name; errors number (spacing for "no error"; it could even better if I can output "no error" instead of spacing)​Output sample as follow:banana_report.json;102;203;204;303;305;306;307;a_report.json; ;​My .json file sample is uploaded for your reference. Basically, the information that I need is at the "all_errors: []"​Hope somebody would give me a hand on this issue. I am really appreciate that.​Thank you very much!​Zach

Due to a number of custom coordinate systems used by the organization - I have to use ESRI Reprojector to set the CRS of some incoming data. So CoordinateSystemSetter is out of the question unfortunately. I used a PythonCaller and Arcpy to generate the string required, based on this help doc - in the format of ESRIWKT|<name>|<esriwkt> where <name> is the coordinate system name, and <esriwkt> is the WKT (Well-Known Text). sr = arcpy.SpatialReference(int(FME_MacroValues['EPSG']))str = 'ESRIWKT|{}|{}'.format(sr.name, sr.exportToString())feature.setAttribute('coordsys', str)But I'm getting this warning, (and the crs applied is not correct). the EPSG code I tested with was 5383.Datum definition SIRGAS-ROU98 does not exist.Ellipsoid definition wkt_auto_1 does not exist.Esri Reprojector: Specified geotransformation `' (forward) may be inappropriate for reprojection from `_FME_0' (GCS: `GCS_SIRGAS-ROU98') to `_FME_0' (GCS: `GCS_SIRGAS-ROU98') using the ESRI reprojection

I'm attempting to transform the input Rain Gauge data set to the desired output as shown in the above inserted image but I'm at a loss on how to proceed? The important factors are:The time period is defined by the user, in this example 01/01/2022 - 10/01/2022 and the output table needs to include all days in that range.The input Rain Gauge data only contains data for when it rained so not all dates are included.I need to some how produce a column per Rain Gauge reference, then look up the associated rain fall value for each of the days and populate the new table structure.The number of rain gauges can vary. I have completed the process of creating a list of all dates for the requested time period. I can't begin to fathom how to manipulate the data as shown and explained above.If completing this in Excel I would have created a pivot to produce the table below:  Any help will be gratefully received! Thank you.

In my attribute table, I have a field named "City" and in this field we have differents cities except a city which is in 2 or 3 fields. But the transformer "Duplicate filter" doesn't display this information and displays cities which are uniques. So I think it doesn't work. What is the problem?  Thanks for helping

So far I can only see a writer for Presagis .flt (OPENFLIGHT), I'm assuming this in nothing like the ESRI binary format

I am having problem writing attributes with swedish characters (åäö) to a mssql table.The characters get replaced by other strange characters instead. I am using FME Desktop 2022.0.0.2 build 22343.The database is set up with collation Finnish_Swedish_CI_AS as it should be.Other programs such as QGis is writing åäö to the table correctly.Is there some kind of setting that I need to do in FME or is this a bug?

Hi I am reading Smallworld data which has internal and external objects. When reading external objects we don't have any problem and all are read properly. In case of internal objects, the geometry is not extracted by FME by reader.  Is there any way we can read smallworld internal objects in FME without Spatial Biz? Thanks Siva Bulusu

Dear Community,  I have a number of points in one dataset and I would like to draw lines so that I connect each point with all other points (many to may). How do I do this in FME?  Regards, Mats

From FME desktop it is possible to write the correct datatime (TIMESTAMP(6) to TIMESTAMP(6)) )when I switch the rows timestamp fme_datetime, timestamptz(width) fme_datetime in file:  "C:\\Program Files\\FMEServer\\Server\\fme\\metafile\\oracleAttrCommon.fmi".From FME server TIMESTAMP(6) becomes TIMESTAMP(6) WITH TIME ZONE...Is there a file on FME server what overrules this modification in the fmi file?

Hi all,I want to read out an Rest API. I examined the contents of the api using Swagger. I first have to authorize myself to use the api. After that I have to login on the API. With Swagger this works all well. How can I do this in Workbench? I started with a creator. Connected to that I use a HTTPCaller to authorize myself. That's working well. Than I use a HTTPCaller again to read out some data with the credentials of the login window. Than I get an error of accessing the url.  What is the best way to work with this kind of "double" authentications?

want to ask about my research, which is about converting IFC data to CityGML and CityJSON formats for 3D Cadastre. I'm having problem converting citygml model to cityjson using fme . The citygml model I got from converting the ifc model on the fzk viewer. The ifc elements I convert to citygml are ifc space . But when I convert it to a cityjson model, the space (room) element doesn't appear in the ninja cityjson viewer (https://ninja.cityjson.org/#). Can you explain why this can happen? does cityjson not support space elements represented in lod4solid model?

Hi all! This is a follow up from this post - super quick recap is that I have lots of Excel files, and I need to read their column headers into their own sheet.  I was able to get the FeatureReader running (thanks to excellent support agent Trent!) with a single Excel file. However, I'm running into an issue now when I try to run multiple Excel files at once, I get the following errors:The schema did not contain information for sheet 'test_data'Excel Reader: The schema did not contain information for sheet 'test_data'Excel Reader: The schema did not contain information for sheet 'test_data'Failed to obtain any schemas from reader 'XLSXR' from 3 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationFailed to obtain any schemas from reader 'XLSXR' from 3 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See

I'm using a FeatureWriter set to Esri ArcGIS Online Feature Service to publish a Feature Layer having a polyline layer to AGOL. How can I reference the polyline layer URL in FME right after it gets published?

I have converted a DWG layer to shapefile and am in the process of trying to georeference it. I have used the AffineWarper to get the data to the correct location but the scale is too big and I need to reduce it. When using the Scaler it changes the location. I then used the Offsetter but it does not place the features where I need them either!Any help would be much appreciated 🙂Screenshot shows process after AffineWarper with features in right location but with wrong scale.

I would like to switch fields names and their values in Excel . Because for now, fields names are in columns and their values are in rows. Thanks for helping.

I'm trying to separate several years of data based on an install date which is input as a string field.  The data is manually input as a simple string (ie. "2019" no day or month information) and in an effort to keep from having to manually update the entire process at year's end I'm using a test filter with date/time functions that will pull out "Current Year", "Last Year", etc. for several years of data but I'm having trouble getting the string converted to a format that the date/time functions will recognize. I've tried using the string formatter to get the string into a number which I thought would register as a date automatically with FME but that doesn't seem to work either.  Any thoughts? This seems like such a simple issue I can't find a solution for.

Hello! FME newbie here 👋 I have 100+ Excel workbooks, each of which has 2-4 worksheets in them. To prep to do some schema mapping, I'd like to read out all of the attribute names to a new spreadsheet (Excel or CSV, doesn't matter). Could anyone give me some guidance on how to do this? I've played around with the following transformers, but haven't had much luck figuring out how to use them to do what I'm hoping to do:Sampler (with no header on Excel reader)AttributeTransposerFeatureReaderAttributeExposerAny help, guidance, or links that might point me in the right direction would be much appreciated!

I have numerous shapefiles in numerous folders. While I can parse through all of these and convert directly into a GDB I will have 203 separate classes. I would like to use the parent folder name as my feature class name. Each folder has a varying number of SHPs in it but they all belong to their parent folder.

I have to read and process features in several File GeoDatabases and was going to use the FeatureReader to do so. I expect not more then a single feature class in each gdb, and you can see the parameters dialog in the following. It does not matter if I change the output ports from 'Single Output Port' to 'One per Feature Type', all the features in the feature class are read, but their attribute table only returns a single column, labeled <no schema>, while the Schema output port of the FeatureReader contains the structure of the initiator, and an attached ListExploder shows the correct schema. Yet, I do not get any attributes of the objects, due to <no schema>. How do I get the proper schema of the GDBs returned, so that I have the correct attribute values to work further?