Transformers

Hello,I am converting a sewer network from CAD to GIS, and am attempting to convert flow arrows to flow direction in the output GIS geometric network. I have already successfully built out the conversion of the actual sewer features to GIS, and all I have left to do it get the flow direction set up.The flow arrows are drawn as triangular solids with separate lines (on the same CAD layer). Does anyone have any advice on how to convert this to flow direction in a GIS geometric network? I'm assuming the workflow will involve snapping the flow arrows to the corresponding lines, but beyond that I'm not sure how to approach this; I'm way outside of my FME experience level here. I'm guessing the Angle attribute of the line component of the flow arrows may come in to play as well. Any suggestions of transformers and order of operations are appreciated. Thanks. 

My duty is to read multiple CSV-Files my means of HTTPCaller from an online source into an attribute each, subsequently zip the CSV-file inside the very attributes, and finally write the binary attribute content (zipped CSV) to a PostgreSQL bytea-Attribute.I know how to read the HTTP source and write into the bytea destination attribute.QUESTION: How am I to zip a CSV-file inside a binary BLOB FeatureType attribute within the FME Desktop Workspace.Hint: I tried to use the ZipArchiver, but that one needs a file as source, as well as destination, but wouldn't work on attributes. Many thanks for any effort!

I am trying to download a specific set of files from an FTP server. First I use an FTP caller to download to an attribute so I can select the filenames of the files I want. Then I use another FTP caller to download teh files. It seems to download fine, but all the downloaded zip files are corrupted. How do I fix this? 

Hi folks,I don't know if it's a "new" bug. when I configure a reader DWG in grouped mode (single merge feature type) but not directly when creating the reader, but afterwhile, in the parameters of one of the faeatures :The number of entities increases anormally ... and do never represent the real number of entities presents in the layer.For exemple, I have 3000 entities (block) in a layer.If I check the box "merge feature type" it increases to 20000 without reason.I am surprised because I used this function a lot of times, without any problem.Does anyone know if there is a problem known about it ?Or maybe I do the bad manipulationRegards

In my workflow, I want to evaluate the intersection of a circle with a set of lines, extract the vertices, do some calculations, then store just the text results in a table. The set of lines remain the same but a new circle is created for each intersection analysis using a different circle center. There are 200,000+ circles whose intersections with the set of lines that need to be evaluated.The workflow I created works for a single circle (using the Sampler to extract the circle) but when I want to evaluate multiple circles, the all start to overlap which doesn't provide the desired results.How can I run the intersection of the circle with the line set one at a time and write out just the text results for each circle? I tried GroupBy in the Sampler2 but didn't get the desired results. I'll try to have the image and workflow posted with the question.

This seems like something someone would have done already, but has anyone created a workflow to generate a point from a PLSS (Public Lands Survey System) description, such astownship 45N Range 43W section 20, NE, SW, NW, SE ? Any thoughts how to go about that ? not all are down to the QQQQ, some are only QQ, etc

Does the connector support parquet? Getting a forbidden error. Any suggestions on privs of the account required.HIVE_CANNOT_OPEN_SPLIT - com.amazonaws.services.s3.model.AmazonS3Exception: Forbidden (Service: Amazon S3; Status Code: 403; Error Code: 403 Forbidden;

Hi all, I'm attempting to set up a custom XFORM_DEF to move between CSRS (1997) and CSRS (2010) using the grid shift file CVG69710.gsb provided by NRCAN, and I'm having trouble getting it to show up in FME Options > Coordinate Systems. I was wondering if anyone might have experience setting up this transformation or if anyone could otherwise spot what might be going wrong. I've placed the grid shift file in Reproject\\GridData\\Canada and placed this definition in the bottom of the MyCoordSysDefs.fme file. I also did a test by uncommenting the ASTRLA66-Grid_to_GDA94 XFORM_DEF in the same file and it shows up in Workbench without issue.Here is my custom definition:I was thinking that perhaps I need another datum to represent either CSRS (1997) or CSRS (2010), but I'm not really sure. There seems to be some ambiguity surrounding the representation of different CSRS realizations within the EPSG code system and I am unsure which is being represented by the CSRS datum I&#

Good afternoon, I have a Multipatch Building Data Set (LOD2) (*.GDB). Consisting of wall and roof areas. Since only the roof areas are interesting for my further work, I would like to extract them into a 3D polygon. Unfortunately, there is no attribute that tells me that the polygon is a roof surface or a wall surface. Is there a transformer which separates the corresponding roof area? If this is not possible, my idea would be to calculate the inclination for each polygon and define all polygons with an inclination of ~90° as a wall. For this I would consider the transformer "SlopeCalculator". Is there perhaps a more efficient way to reduce the calculation of the inclination of several million polygons?Thanks a lot.

Hello FME family,I am new in using FME and I really want to learn more about the software.I have FFS table that I want to write in PDF. Also in the PDF output, I want to show the number of time a feature (string) occur in one of the attribute columns. I will appreciate a tip on how to go about it because I have tried all I know but not working.Thank you.

Hii,I have a .rvt file that I have georeferenced in Revit (epsj 23032 - UTMED50 32N). Now, my target is to visualize that file in FME. I'll show you how I tried to do it:In the first figure I show you about the Revit survey point, and for me it's ok. Because the coordinates values are coerent with the coordinate system of the project.In the second figure I show you about FME reader setting that I have used.When I use the reader to import the file in FME Desktop 2020 the model don't match with the correct location :-(Someone can help me!!!RegardsGianpiero

 i have lines and points ,both of them as input .i want to find which lines intersectes with points and which notand show me the id of each station that line intersected so i tried by point on line layer and neighbor finderand it find correct data of overlapped point but i have still problem,when one line intersected with two points ,the output that i got only id of this line and and overlap 2 and name one of the two station .it did not show me the 2 stations that line intersectedso i noticedthat it checked only by xmin and ymin of the line which point intersected . this is the station that it has chosen and another point at end of the line ,it did not show me bcs it is xmax and ymaxbut the line intersected with 2 point as the output said 2 overlap,so how could i solve this problem .and i get id of each 2 pointand i tried also neighbor finder but both of them works with xmin ymin close candidatehow could i let both of them work with xmin ymin and also x max y maxbcs it means also if i

I am using the jsonfragmenter to expose the attributes "name", "street", "city", "zip" in the following json.I want to also expose the geographicpoint attribute and append the "latitude","longitude" as a field on the same level as the other attributes so that I can obtain the following data structure."name", "street", "city", "zip", "latitude", "Longitude" How can I delve into the "geographicalPoint" attribute and flatten ist further in my schema?  JSON{"name":"Medicus-Apotheke","street":"Walsroder Str. 8","city":"Soltau","zip":"29614","email":"medicusapotheke@googlemail.com","geographicalPoint":{"latitude":"52.9836451","longitude":"9.8358444"},"contactName":"   Andreas Hagedorn","services":[{"service_id":34,"service_name":"Krankenpflege","service_icon":"ico_krankenpflege.png","service_url":"","service_descript":"Krankenpflege","service_longdescript":"Krankenpflege","service_type":0},{"service_id":35,"service_name":"Verleih","service_icon":"ico_verleih.png","service_url":"","service_de

Hello, I have got 2 sets of Polygones. 1 consist of big areas (431) and the second one has the smaller Polygones. Theese smaller polygones includes infos/attributes which I need to write into that larger polygones. The problem is that I get from AOAL too much Polygones, but not this result what I want...I want to get the infos from (many) Polygones in the larger (less) Polygones. Maybe to use a different transformer?Any Idea?Thanks

I am trying figure out how to populate missing date records in a COVID database using the last known value.Here is an example of input data:CountryLast UpdateNumber of CasesMexico3/1/20205Mexico3/3/20205Mexico3/6/20206Mexico3/8/20207Mexico3/9/20207 I would like to generate a record for each day.  CountryLast UpdateNumber of CasesMexico3/1/20205Mexico3/2/20205Mexico3/3/20205Mexico3/4/20205Mexico3/5/20205Mexico3/6/20206Mexico3/7/20206Mexico3/8/20207Mexico3/9/20207 Any ideas on where I would start with this one?

There are some air-quality sensor in the area I work. These are connected with the LORA-network and The Things Network (TTN). Data can be accessed by the MQTT-protocol. However I have no experience with this. I found the MQTTReceiver (which uses an old Python version) and MQTTConnector. I tried both Transformers with the settings I received; like this:Unfortunately it is not working. The error I get  Anyone experience with this? Thanks!Stefan

As per the topic: Any difference in the values calculated by either Transformer when using @Evaluate in AttributeCreator vs ExpressionEvaluator?

Hi  New to FME so please be gentle...  I think the question lines out what i want to do but for clarity, I have several dxf files in a folder on my c-drive. These dxf files are a combination of point, lines and polygons with a known projection. I want to convert all these dxf files to an ESRI geodatabase (or separate shapefiles -whichever is easiest) with the name of the dxf file naming the "shapefile".Additional - if possible I would also like to reproject the shapefiles to another projection - but not that important now.  

I have a *.csv-file with values, I would like to put them in a Autocad block attributes:The issue is that the 'pino'-values which I filled in by hand will come over. The values from the csv won't (value from Sheet Name 2).I can't get it, who can help me please? :-) Thanks! acad_excel2acad_Safe.fmw0002_Sheet Name.csv

Hello, I am looking for the possibility to count all points (3D) within a 3D body/sphere. Using the 3D buffer (it was faster than HUB3DBuffer, but less accurate) I have generated a solid body and now I want to check how many 3D points are inside this body. With the Spatial Relator apparently only points in a 2D space are checked. Is there a transformer in FME that does this job? Thanks a lot.

Hi, I have used SchemaMapper to create two new attributes that have successfully mapped to my output shapefile. I can see them in the inspector in the Feature Information window. However, I want to map these values into my attribute table. When I try to expose these attributes using AttributeExposer they are not there. I have searched through many posts on these forums and can't seem to find an exact answer. Could someone help me with this?ThanksB

Hello everybody,I got one GeoTIFF image and I want to get N ( for example 3000 roofs ) smaller jpg images of point of interest in which every roof is one picture. I started making polygons in the place where are points of interest but I don't know how to "clip" it.

Hello! I would like to build lines between neighbour points. Unfortunatelly the points cannot be gouped by the neigborfinder, as sometimes an other point is closer. But the points are in numeric order as they have an ID. Can I do something with it?

I am interested in zoom meeting if that is possible

I have a "mapinfo" table that I'm trying to load into a oracle DB with SDO_Geometry. My license doesn't let me create a writer in FME as an Oracle Spatial table. So my workaround is to add the tables as "oracle non-spatial" tables. This works fine for address points but when I run the following SQL;This updates successfully. The issues is when I check in "Data Inspector" if its saved correctly (for this particular record which is a multipolygon). I get only one of the polygon objects returning;