General

 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

Im a very beginner with FME. I've a polygon (gpkg) file, which has several attr. columns. 3 of these column contents should be under one column. I prob. need to create new column where to put contents of these 3 separate columns, right? How? Thanks!

Note: only change exact word not combination words .it posible change exact multiple words in StringReplacer and StringPaireReplacerrock=Star  nove=9     RAW sourceNormalized nove9correctnovember9mberincorrectrockStarcorrectrockstarStarstarincorrect

Hi everybody, I have a seemingly trivial problem that I can't solve: I would like the name of a file inside the zipfile produced by FME Server data download service to be the same as the one produced by FME Desktop (maybe statically defined or by some parameters/attribute values) instead of a random meaningless name. Any advice? Thanks

Working on a little data quality initiative and would like to use Geospatial PDF writer. So I'm reading some SQL spatial data, then filtering, grabbing a centroid, building a bounding box, using that for the 'Map Extents' parameter in the Geospatial PDF writer after adding some labels. With fanout, I can write a bunch of PDF files that show my feature/label pair.  Is there not a way to append all these pages to the same PDF instead? The section "Adobe Geospatial PDF Multi-Page Support" sure sounds like this should work but I can't figure out how. 😉  Only way I can see is use FeatureWriter and followup with a Python Caller to do this part.Any suggestions appreciated. 

 Hello I have some result data in FME, I want to export these data to excel, how can I do this (see example jpeg)

I want to be able to present the user with a single input option that will accept either a shapefile or an FGDB feature class. It doesn't seem possible to me because: the generic reader doesn't seem to allow you select an FGDBI can't have a shapefile reader and an FGDB reader in my workspace, but only use one Am I really going to have to create 2 workspace apps, one that processes shapefiles and one that processes FGDB feature classes? FME Desktop 2021.2 and FME Server 2021.2.

Will FME work on a file-system-based control such as Visual Source Safe (VSS)?

Hello there we are a series of building points in each side of the road we need to move all the points to the same distance on each side of the roadActual Status   Target