FME Form

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

 Hello , I have dots and texts in my workspace. My writings must be attached to the point data. In the picture, the correct text in the 1st example is attached to the point data, but in the 2nd example, the text is not attached to the point data, how can I detect the non-adhesive text or point data?

Hi, I'm not sure how to remove lines within a multiline attribute. I have made an attribute by concatenating several features into one attribute (via lists). The problem is that sometimes the lines are blank in the list before I concatenate it. This is because as I'm making my groups of list some of the original lists have say 5 features and others 10. So when I concatenate them together there are 5 blank lines. I have l looked around the community and not really been able to find a solution. This post was the closesthttps://community.safe.com/s/question/0D54Q000080hfOlSAI/remove-blank-lines-from-an-attribute-values I'm not sure if the string replacer or attribute trimmer would work, but I've had no luck so far. I've attached a picture so you can see what I mean If you could help that would be great. I hope I've explained it clearly

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'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

How to display who are the “followers” or “following”? I’m wondering if there is a way who are the “followers” or “following” 

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 !!!

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?

Hello, I have a 3d file created with Speckle, in json format (attached). Can you help me to read the geometry?  I have been able to extract the mesh data using the JSONFragmenter, but am struggling with making geometry from it. I have tried the GeometryReplacer but cant seem to find the right encoding option. The data is the sample revit model, and should look like thisMany thanks,  Owen

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

What transformer would I need, to stop the RasterDEMGenerator from filling in areas that should be void, or what other transformer(s) should I use? I am using a CSV with XYZ values as my input and in some cases there are voids/no data/holes in the data see pics. How do I stop FME from interpreting data that isn't there? Output is a Geotiff.

I’m using Interop via ArGIS and have developed 9 ETLs that need to run in order. I want to make things streamlined and run all 9 at once with one run command? I tried adding ETLs to a model but ran into problems.

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

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!

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.

Looking for a way to load in files using their path stored in a csv column. I have several different file formats (.mif, .tab, .dem, .grd) that I need to reproject in FME. I've generated a csv that contains the full path location of each file on a new row. I'm wondering if it is possible to import these files directly from the csv, preferably separated by their file extension. I'm a complete beginner, so appreciate any advice. Cheers, Angus

Hi all, I have been given a csv file containing a GeoSpan column representing line data. Any idea how I read this into FME and create the geometry from the GeoSpan? ThanksN

I have a large number of text files of traffic count locations that contain both header information with necessary attribute fields and 2 fixed width sets of data that I also need to bring in as attributes. I am looking to ultimately create a table where the info from each text file is one row/feature in the table so I can join it to an existing point feature class with the Reference Number being the join field. I could do multiple tables if I have to also. I can't seem to figure out a good way to get both the Header attributes as well as the fixed width attributes.  A sample of one of the text files:They are actually .tam, .tpm and .tms files (no idea what those file formats actually are and google was not really any help) but they can be read as .txt files. I have attached one that I saved as a .txt as a sample

Supports geolocation the new application for Android?

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

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

Hi. I would need to deal with a completely banal thing, but I'm stuck. I need to load this excel, but only the first line of attributes reads it to me on the reader. I need to load all the attribute rows. Nowhere in the settings can I find where I'm making a mistake. I would also need the first row to be already an attribute and not a column name.Thank you very much

Hello!I have a json text which I got from airtable HttpCaller.I want to read the attributes as normal attributes, and I have some hard time with that.I think I know what should I do:Format it, and then expose the attributes with JSONFragmenterBut It does not enter the attributes into my fileds:What should I do?I tried to do a lot of variations in the JSON Query, but noting helped.. I attached here the work sample..Thanks you all!

Hi I'm trying to download data from Ordnance Survey using their API. I've got this working successfully but the downloaded files do not have their correct filenames.  I've used JSONfragmenter to create a column called "url" for the download location and another called "fileName" for the filename. Can anyone help explain how I can rename the downloads with the name from fileName please? ThanksRob

 I have a basic list of guids to iterate over and get the related object, append to another list, then use in a function as one of the arguments. Here is my script:import fmeimport fmeobjectsimport uuidimport timeimport tempfileimport ifcopenshell class FeatureProcessor(object):        def input(self, feature):                create_guid = lambda: ifcopenshell.guid.compress(uuid.uuid1().hex)                 # Obtain references to master file        filename = FME_MacroValues['OUTPUT_FILE_PATH']        ifcfile = ifcopenshell.open(filename)                owner_history = ifcfile.by_type("IfcOwnerHistory")[0]        building_storey = ifcfile.by_guid(feature.getAttribute('storey_guid'))                   guids = feature.getAttribute('_guids{}._guid')               guids = [ifcfile.by_guid(x) for x in guids]                   # Relate the wall to the building storey        ifcfile.createIfcRelContainedInSpatialStructure(create_guid(), owner_history, "Building Storey Container", None, guids,