Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,711 Replies
10000 Posts
sivaram81082
Participant
sivaram81082Participant
asked in Transformers
How can we avoid error while writing to smallworld?

I have read polygon features from esri file geodatabase. And then writing them to smallworld. The following errors are observed in translation log and the workbench session is terminated with a failure message. Smallworld Translator Error: The hole is not within a sw:pseudo_areaSmallworld Translator Error: Primitive sw:sector_rope:[1-1].sector failed status 1376267(0,21,11) Too many intersections Is there any way to identify these records before we pass on to writer? Or is there any setting we can choose or process so that FME will skip these kind of features and write log. Kindly help. ThanksSiva Bulusu

630
sivaram81082
Participant
K
kewaljani
asked in Transformers
I want to convert DGN and extract certain features from the DGN file and then after doing operations on the extracted content of DGN I w again want to visualize. It would be great if anyone can help me with this.

I want to convert DGN and extract certain features from the DGN file and then after doing operations on the extracted content of DGN I w again want to visualize. It would be great if anyone can help me with this.

350
jovitaatsafe
Safer
V
virtualarchitec
asked in Transformers
How can I fix an issue with Excel Reader writing values in column as missing

I'm reading an Excel file using the Excel Reader. The reader works well for all fields except one. It consistently marks all the values in a particular numerical column 'Number of meters' (column G of each sheet) as missing. The file is open data but a copy has been attached for convenience: https://www.gov.uk/government/statistics/lower-and-middle-super-output-areas-gas-consumption

290
geomancer
Evangelist
alc33
Contributor
alc33Contributor
asked in Transformers
Extract file properties without reading it

Hi!I have a lot of pictures and I would like to extract the date of creation.But when I use the Reader it's too long.So I tried with PathReader, but if I do that, the properties of the pictures are not avalables.Does someone knows how to do that?Thanks !!!

1770
alc33
Contributor
clowncutie
Contributor
clowncutieContributor
asked in Transformers
How to conditional value in ExcelStyler

Hi, I have a row based information like  Price Sold2022 InStockRow 1 252 Yes NoRow 2 59 No Yes I saw example on how to color individual cell, but there cells where named A B C etc so I didnt really understand, my feature attributes are Sold2022 etc and will be written to an excel and I want for example the  Yes = Green cellNo = Red cellPrice over 100 = Red I was thinking creating temporary attribute like p_price to mark the color, also I could conditional format in excel for Yes or No but if I want to color above or below price 100 then I would loose the value in the cell. Also saw example of cell.format() or similar to add to the writer.  Just need more guidance because I really don't understand how you set the cell you want colored in the ExcelStyler. should cell = attribute?

1870
clowncutie
Contributor
lazarlubomir
Contributor
lazarlubomirContributor
asked in Transformers
JSON Templater - how to export attributes with value?

Hello everybody,please, Im trying to automate creation of JSON and I need to get exported JSONs only with attributes, which are exposed and have values (not null etc.). Please, does anybody know how to solve this problem via JSON Templater?Thank You so much!Lubo

985
outlook
Contributor
arthy
Contributor
arthyContributor
asked in Transformers
Tolerance for transformers such as LineOnLineOverlayer in FME 2016

In recent version of FME, it is possible to define a tolerance value when using transformers such as LineOnLineOverlayer.  We are having an old FME server (2016) and I would like to know how can I proceed to define a tolerance value when overlaying two lines datasets in FME 2016? @Takashi Iijima​ @Mark Stoakes​ @jdh​ and others

250
redgeographics
Celebrity
W
watts
asked in Transformers
Hello, I have an Excel table with data in separate worksheets (i.e. each worksheet is a grid). I'd like to export these grids/worksheets into separate pages in a single PDF or MS Word document - assistance needed!

My attempt to export to PDF seemed fairly impossible, so I changed my approach to export to MS Word instead. I've made some progress; I've managed to create a single table that has all records from all of the worksheets - I need to be able to split the data out by these grids (i.e. separate sheets/tables for each grid). I also need these sheets to be in landscape rather than portrait orientation. However, I'm a bit stuck and I'd appreciate any advice that can be offered on how to achieve the result I desire! Thanks!

520
debbiatsafe
Safer
hugues
Contributor
huguesContributor
asked in Transformers
Change detector with XLSX files and delete line

I have a 2 XLSX files. I delete some records on 1 file to be identical between the 2 XSLX . But when i apply a change detector, FME seem to considerate the line that i have delete.  Can you help me.

560
kailinatsafe
Safer
fmelizard
Safer
fmelizardSafer
asked in Transformers
Intentionally writing to FME Temp

Hi folks, I was wondering, is there a way to intentionally write to FME's temp location?  I want to create a workbench that's portable and needs to write a lot of scratch data using a few workbench-runners (deleted at the end of the process).  Is it possible to intentionally write to it? There doesn't seem to be anything on http://fmepedia.safe.com/articles/FAQ/FME-TEMP-environment-variable . I've done some testing:  - %FME_TEMP% as the destination just means FME creates a directory called that. - <FMEDrive> in various guises just results in a workbench crash. - Not specifying a directory means that FME writes the file to wherever the workbench is saved. Only if it's an unsaved (new) workbench will this be the fme_temp directory itself.  Thoughts? Is this even possible? I'd prefer not to have to hard-code somewhere, or even bother with a user parameter.  Cheers, Jonathan

370
mattwilkie
Supporter
B
bdel
asked in Transformers
Problem to add dynamically number of rows and columns parameters to MapnikRasterizer transformer.

In the MapnikRasterizer settings, in the Raster Properties section, it is necessary to specify the number of columns and rows of the output raster.  When I enter this information manually, there is no problem. When I want these parameters to be filled in dynamically, i.e. using the number of columns and rows of the input raster (using a RasterPropertyExtractor beforehand to access the attributes), I get this error message:"MapnikRasterizer_2 (MapnikFactory): No values were specified for either NUM_ROWS and NUM_COLUMNS, or SPACING. One or the other must be specifiedMapnikRasterizer_2 (MapnikFactory): A fatal error has occurred. Check the logfile above for detailsAttributeManager_OUTPUT_-1_84_Player (RecorderFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details". The number of columns and rows in the input raster are 32 bit unsigned integer. When I converted it to 64 bit integer via the Attribute

330
daraghatsafe
alsherren
Contributor
alsherrenContributor
asked in Transformers
Can anyone advise the most efficient way to bulk extract attribute string lengths?

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

380
chrisatsafe
Contributor
D
dutchtower
asked in Transformers
I thought I had a simple thing to try out and have been banging my head and can't get it to work: I want to add a column to an AutoCAD Object Data Table.

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.

60
D
N
netsunnix
asked in Transformers
Append many to one, no common attribute

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!

120
N
M
mgregory
asked in Transformers
FTPCaller Initialization Error

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!

1080
sdepriest
Contributor
B
bradosav
asked in Transformers
How to compare attribute schema with a file containing column names?

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?

2860
B
N
nick824
asked in Transformers
Hi all, I am getting a Server 500 error when using Http Caller with Query String Parameters. Any ideas? thanks, Nick

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.

2410
N
Z
zacharylee1204
asked in Transformers
Extract text from (.json) to one single text / csv file

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

6018
Z
gracecai
Contributor
gracecaiContributor
asked in Transformers
ESRIReprojector input : 'datum definition does not exist'

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

1110
daveatsafe
Safer
R
rob_nason
asked in Transformers
Transposing Data - Making Rows into Columns and Naming Columns Based on Attributes

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.

1510
R
L
lachichi_farah
asked in Transformers
How to use "Duplicate filter"?

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

2640
L
A
andrew_n
asked in Transformers
Is it possible for FME to write to an ESRI binary format (.flt, .hdr)? I have an asc input to be converted to an flt

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

400
A
larsk
Contributor
larskContributor
asked in Transformers
Problem with SQL Server and special characters

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?

5790
larsk
Contributor
sivaram81082
Participant
sivaram81082Participant
asked in Transformers
How to retrieve geometry of Smallworld internal objects?

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

460
sivaram81082
Participant
M
mats
asked in Transformers
points to lines

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

140
evieatsafe
Safer

Badge Winners

  • Welcome Back
    mclemenhas earned the badge Welcome Back
  • Welcome Back
    dean.ellisonhas earned the badge Welcome Back
  • French Speaker
    mgardeyhas earned the badge French Speaker
  • English Speaker
    mgardeyhas earned the badge English Speaker
  • Spanish Speaker
    gatojihas earned the badge Spanish Speaker
Show all badges

Community Stats

31,801
Posts
120,810
Replies
39,422
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.