General

hi!I have an excel file with 2 colums : on A : the name of the attributeson B : the valuesI don't succeed to create the attributes on FME and to associate the values.I tried with ListBuilder, Exploder, Aggregator, but I don't succeed.Can you help me?Thanks !

MapnikRasterizer fails "Failed to rasterize data. The error was: Image area too large based on image dimensions" due to memory problems according to a post I read in here. The solution was to tile the layer and use groupBy "column,row" but thats not working for me. If I try that I get following errors "no input data for layer..." I know I can change cellSpacing but I really need a high resolution map. One option I can think of is making an oversight map and make a grid where each grid is its own map, but I dont know if I can do that with only 1 mapnikRasterizer. I attach a workspace that kind of resemble my original data, in the workspace you can see that I tiled the map and group by column and row but it fails. Thankful for any help or input.

Hello everyone,Welcome to What's Up Wednesday, your weekly spot of FME news. Training Season is Open!When looking for FME news, I found a lot of training being organized for the near future. But I suppose just after a new FME release really is prime training season. At Safe, we've just released updated content for FME 2022. That includes the trails FME Desktop Basic, and Integrate Data with the FME Platform; plus work is taking place on updating

I am using the GeometryExtractor transformer to extract the geometry as WKT (OGC Well Known Text, version 1.2, precision 64-bit). The geometry is created by FME using the Dissolver, Sorter, Aggregator and GeometryRefiner transformers based on a geometry from ArcSDE Geodatabase - on Oracle DB. Vertices are aligned using ArcSDEGridSnapper and CoordinateRounder, so there are no issues with vertices geometry, as all of them are matching. An example of a WKT created by FME is the following: MULTIPOLYGON (((22.5462822 47.250064,22.5467275 47.25037864,22.546993 47.24920386,22.5468165 47.24918507,22.5463433 47.24908748,22.5460432 47.24890993,22.5459305 47.24885194,22.5455702 47.24880224,22.545533 47.24879591,22.5453175 47.24953065,22.5459866 47.24989446,22.5462822 47.250064)),((22.5493802 47.25255987,22.5494253 47.25113137,22.5494042 47.25081984,22.5494009 47.25078482,22.5487585 47.25060518,22.548664 47.2507213,22.5477242 47.

My team is relatively new to using FME Desktop, so our technical knowledge is limited for troubleshooting issues. We've created a basic workspace with a Reader Feature type, to read Microstation V7 files (IGDS), connected to a Writer feature type to output shapefiles. We've also create a "Master" workspace with a series of Workspace Runner Transformers to pass a few thousand files from multiple directories automatically through the original workspace. The problem that we're having is inconsistent results and outputs from the core workspace.The expectation of the core workspace is to read each layer of the Microstation file, and output it as a shape file. The output of each layer should also be fanned out based on the "IGDS_Basename" and create separate shape files for each layer based on the different geometries within the layer. An example would be layer 19, which contains text, line, point, and polygon as different geometries. In an ide

Hi, I have a list of unique values. Next, I want to search all attributes to see if a value from the list is found in any of the attributes. Without creating a feature merger per attribute.Is that possible?

Hello, I am supposed to solve the following problem with FTPCaller.I need to call ftps://hostname using port 21 (implicitl FTP).  The FTPCaller help says the following: "The transformer will use the explicit mode in the following cases: The URL begins with ftpes: ftpes://hostname/pathThe URL begins with ftps but also sets the port to 21: ftps://hostname:21/path" How can I call ftps implicit with port 21 in FME?It works fine with FileZilla. Thanks, Zoran

Hi, can i somehow parse this file? I would need individual codes separated by a hyphen as the values of one attribute, for example the column name will need ICAO and each code will have one row.Thank you very much

 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 cou

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

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

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.

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

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]

I'm trying to run a workspace in FME Server and I'm getting a message: "The workspace has Python Compatibility set to 'Esri ArcGIS Python 3.9' which requires ArcGIS Pro...." I have ArcGIS Pro installed. The workspace runs fine in FME Desktop.

Hi list.I have a dataset with mixed date/time formats in a single field.I want to create a cascade to transform these, i.e. "Try this format", and if it fails, "Try that format", etc.HOWEVER, when data are output on DateTimeConverter's rejected port (signalling a data error), the field value is cleared, rendering a cascaded approach impossible. Why is that ??Is there a way to avoid this unwarranted nulling of a possible valid field value ?Cheers.

Hello!I have a challenging work to do. I have 3 differents vectors data (DataVector1, DataVector2 and DataVector3 ) which i've extracted from a pdf file. And, I have also from the same pdf file, the location of the three Datavectors (boundaries). The boundaries is also a vector data that i've extracted from the pdf. However, the boundaries boxes are smaller compared to the limit boundaries of the Datavectors. Now, I need to scale and shift all my 3 Datavectors into the boundaries boxes. How can i do this ? knowing that the coordinates are in local values ( fake coordinates from PDF). After that, I'll do a manual georeferencing, since I know real coordinates of 3 points over the whole 3 Datavectors.Anybody, have some hints ? Thank you in advance !

Hi,I'm using the TopologyBuilder to create relationships between water mains (the edges) and the valve furniture (the nodes). Our corporate GIS (Gwater, Oracle based) has an start and end node for each feature to show connectivity, but ARCGIS does not . These values do not exist and I have to create them to align the two GIS systems.So far the results have been good, as the corporate GIS feature can only connect to two other features. This doesn't happen in ArcGIS for one particular type of feature called a cross valve, which connects 4 mains pipes.I can find the 4 pipes a cross connects to, but not the direction in which they connect to create the east-west and south-north connectivity. There's nothing in the topologybuilder output which suggests this relationship:  I was wondering if I can use the spatial location

Hello FME'ers,A slightly late What's Up Wednesday because of the webinar I was in yesterday. But it's still packed full of fun and useful content... FME Community WebinarOur FME Community webinar was yesterday. If you're interested, you can find the recording on our website or on YouTube. We also have a blog about it too.  We showed how to use FME to crowdsource data for an ArcGIS Online map (even if it did get a bit slow at times), and we played a City Guesser game that was pretty cool. Dale and I managed to describe and demonstrate the FeatureTypeFilter transformer