Transformers

I have a COLLARS table with the following columns : hole_number, X, Z, Z; I also have a SURVEY table with hole_number, depth, azimuth, and dip. Currently I use the QGIS "Geoscience" plug-in with those tables, it does a nice job but it's static and I can't really schedule it. Any thoughts?

Hello, I have been sent a SketchUp model that includes roads, cars, trains, buildings, and other features. I do not have a SketchUp license. Viewing with Inspector, all of these features are aggregated as one, so I cannot select individual buildings. What is a potential workflow to extract the individual buildings from this mass SketchUp model? My end goal is to incorporate these buildings as COLLADA (.dae) format to be used in an ArcGIS Pro Scene for land use planning and visualization. I know an appropriate workflow may be difficult to determine without having the attribute information, so even suggested potential transformers to use is appreciated. Thank you.

Hi everyone,This is a very specfic question and is targeted towards the persons who work a lot with dgn files in FME Desktop. I ask this question on behalf of my colleague.  He is reading in a lot of dgn files in FME Desktop made by other persons from other departments and some drawings have a global origin that is not x = 0, y= 0 such as in beneath image. My colleague would like to derive these global orign x, y and z values so we can move the global origin of these dgn files to x en y =0. Does anyone thus know if the global origin x and y values are stored in some kind of parameters? When reading in the dgn files in fme desktop the global orign x, y and z are known (see image below). So it looks to me that these values are stored in some kind of variables. 

 

I don't see the grid in email body when I use table in htmlreportgenerator and emailer

I have an MSSQL database, where new rows will be added on and off. I have setup a workspace that will be run nightly, that checks the database for rows with null in the field "email_sent_with_data" and sends it in a beautifully formatted email and it works wonderfully.  However, I would like to send along a map, either a pdf or a shapefile or similar containing the three geometry columns in the row. Any ideas for solutions to this problem?

Dear Sir / Madam, I have an indoor data set. As shown in the figure below.  Red line represents network path.Blue circle is the POI (Point). Black dot is just the vertex. As I have an indoor data for the entire building. I would like to find network that is unnecessary (not linked with any POI), as shown as Yellow Circle. I am just wondering what transformers I can use to find these path?I cannot just simply break the lines as some vertex are necessary for turning. I would really need some hand. Thank you very much!

I am creating PDF reports from ArcGIS Portal Features w/ attachments. The workbench is set up to write to a word doc to use the template doc functionality (custom header/footer) and then converting to PDFs with a PythonCaller. It seems that when writing more than 2 images (from the feature attachments) to the MS Word document, it corrupts the file. Two images or less works correctly and the documents are able to convert.  I am writing out images from attachments to a local drive using the BinaryDecoder and AttributeFileWriter. Then specifying them for the word doc using the MSWordStyler --> Image Source = From File. I've tried using a PythonCaller after the the AttributeFileWriter to compress the images (jpeg and png) and resize them before being written to the word doc, but that doesn't seem to help. Any help/ideas would be appreciated.

Hi, Is there a way to modify execution order of a sub part of a workflow to obtain a full execution of an arbitrary long chain of transformer on a given feature.alike: transformer1 execute row1 - transfomrer2 execute row1 and output 10 row - transformer3 execute row1 to 10- then -transformer1 execute row2 - transformer2 execute row2 and output 5 row - transfomer3 execute row11 to 15- then -transformer1 execute row3 - transformer2 execute row3 and output 7 row - transfomer3 execute row16 to 22 this even if there is merge or agregate transformer. The issue is: I have is that I have to sequence operation on an external web service that some time "loose itself" when for exemple I create all invoices then further in the workflow I create all invoices_lines for all invoices, I need inside of a more complex workflow to create the invoice then create all line for this invoice then create next invoice and so on... I allready know that I can use a workflow runner to achieve this but it

I have this problem:In the workbench there are many writers. Two of them should be in the same zip folder. This happens when I run the workbench in FME Desktop, but when I run it from FME server I only get 1 of the two files in the zipped folder. I use fanouts:@Value(field1)_ExportacioGIS.zip\\SortidaDXF.dxf@Value(field1)_ExportacioGIS.zip\\SortidaDWG.dwg Where "field1" is the same value for each file. In the desktop I get the expected output:But when it runs from the server I get only the DXF file. I try it using a Job Submitter and a Data Download services. Any idea why it does not work from the server?

How to extract start and end name of road from road network ?

Hello , i am using Esri feature service reader to read map service but it does not work with me .when I click on layer to show them ,it is written that token error ,499 error i have admin user and keyword but it does not work to access .could someone advice me ,how could I read map service from ArcGis server ?

Hi, Im struggling a bit with finding nearby points to another point layer. I want the Neighborhoodfinder to find the two closest points within a distance. The output file only includes the nearest point even though I have set the neighbors to find parameter = 2.  I want the output file to include the two closest points and their distance. Any suggestions?Thanks in advance!

I have a shapefile with numerous columns that I need to calculate a mean for on a row by row basis. Within the data there are a lot of values equal to 0 that are skewing the mean - how can I set up a calculation in the ExpressionEvaluator to remove the 0's from my calculation?

Hello everyone! I struggle with understanding how ArcByCentrepoint (and Circle) are implemented in AIXM 5.1/GML. I ingest exactly the same dataset in FME and QGIS. However, in FME everything looks correct whereas QGIS butchers the geometry. I tried this with class C airspaces around Munich and other airspaces. The system behavior is the same regardless of the airspace. These discrepancies are not just ugly, but they also lead to partially invalid geometries. I have attached example screenshots.In FME In QGISI believe that these discrepancies may occur due to each application utilizing a slightly different projection, e.g. UTM, AZMED, AZMEA, and other local coordinate reference systems are probably just part of a longer list. With each projection, the displayed geometries are slightly differently skewed in terms of distances and angles. So far, I have selected Lambert Azimuthal Equidistant Projection for my calculations/constructions, which originate at the circle’s midpoint. In my unde

Hello,I have a workbench that uses a tester to copy files into a folder and zip them based on the create date. This works fine however after I have the files in the new zip file I can't seem to figure out a good way to then use a FTP caller to upload the files since you can't do anything after you have used the filewriter. Looking for ideas of how to upload this zip file to an FTP in the same workbench?    

I have tried using the combination of this transformers to discard or filter out compoundCurve geometry but the issue still persist I would like to find a way to discard these geometry ("CompoundCurve".) to avoid the WB stops when I am inserting data to postgis table. GeometryFilterGeometryValidatorArcStrokcerGeometryRefiner

I am trying to write a bunch of shape files to a geopackage but am getting a strange error.  'OGCGEOPACKAGE writer: sqlite3_exec(CREATE TABLE "table_name" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL' There seems to be a problem when the writer constructs the primary keys for the database, but I have no idea how to address this. There is no id attribute in the source data, I actually tried adding one and the writer handled this by changing the name of the primary key to id_0. Still got the same error though. I am using fme_feature_type to set the table names and schemas.

Has anyone got a method to rebuild a flattened json file using the dot notation? Essentially it would be the JSONAttributePacker but with a iterative approach?

I have upgrade from FME 2016 to FME 2021.2.When I am running the FME script, if I don't give source dataset in SCHEMA READER then I am facing "No Schema Dataset found" issue. But the same script runs fine on FME 2016. I think FME 2021.2 is not accepting empty string (i.e. no dataset) as input.Is there anything I can do to fix this issue ?

I have many vue 3D model, how to convert them to fbx, so i can use it to many applications.

I have a shapefile with 1000 polygon data and shapefile includes 50000 unique lines. I want to connect both lines that are inside the polygon. I used the spacialfilter but it couldn't detect properly endpoint of the lines which are inside of the polygon

Having issues with info being extracted into the CLOSED 45 DAY attribute-that is created with the ATTRIBUTE CREATOR. Thanks for all recommendations.

I need to create an RDF Turtle (ttl) file to CSV convertor for asset data structures. There seems no RDF reader in FME available. What would be the best approach to read RDF Turtle files into FME for further processing ?

Hi. I know it is a basic ask why FME Data Inspector is not opening. But, I have check for visual preview window, task manager for any FME Data Inspector open items, installed a fresh version of Desktop(2022.2.3) and also tried restating the machine. The last window displays 'initializing user interface', and nothing pops-up.Can someone suggest a quick solution to this?Thanks.