Transformers

 

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.

I would like to extract 'Orientation' >>  Plz any idea what setting i use so that i could see those value in table in filter the data according.  

HelloI want to transform with fme a shape file containing the sewer pipes into a file that can be integrated into the EPA SWMM application with .inp format (text file). Do you know any fmv schematics? THANKS

I have a situation where .dgn linework is being drawn with a custom line style (a treeline). I need to test whether the arcs of the treeline intersect with building edge linework. But when I load the .dgn into FME, the custom linestyle is not represented. It is still present, and (with the correct seed file and rsc and other tricks) I can write it out, but I need to work with the custom parts within FME. Is there any way to do that? A similar option to expanding cells, but for lines? Or some other approach that would work?