FME Form

When I update the writer and uncheck "Lower Case Attribute Names" under Table Creation it automatically rechecks it after I close the window. I just want to retain the same field name format from the table I'm reading from.

Hello,In a model that I am creating, i would to expose attribute in the feature reader automatically . The idea is to use the same model for different dataset. I have seen that is not possible to do it automatically but I would ask you if it's possible to do that using the user parameters. if yes, please, can You explain me how to do?Or if there are some other ways.The input file is not stored locally and it's a zip file. Thanks to all. Max 

Hey Everyone,I am a newbie in FME wonderland can anyone help me out how can I convert bson to json. I am using http caller to get data from our asset management system named Alloy by Causeway. Al the data is in bson format and i don't know how can I convert that into usable format. All the data is sitting under _response_body. Let me know if anyone can help or want any more details :)

I’ve been wrangling a large number of Shapefiles recently (almost half a billion!), converting them to a PostGIS database. A small command file calling FME (with return code checking) was just the trick and, after several days of processing, the job was done. The problem is… my record count on one of the output tables is larger than expected. ☹ After some research and experimentation, I’ve discovered that if you pass a polygon with bad geometry (in my case touching rings, which is fine in a Shapefile), it causes multiple records to be written to a PostGIS table! So, if a record has a polygon with 3 rings, not overlapping but touching, it would be expanded to 3 rows in the output table. FME does not report this in its output summary, which makes be suspect it’s a PostGIS behaviour in trying to deal with the bad geometry. Fortunately, in my case, any additional rings are always artefacts in nature and can be discarded, so my main question is how can

Most of our automations are started by a FME-Server Schedule-Trigger. I would like to make a list with all automations and their start-times. I can get a list of all automations with the REST API, but how could I get all the start-times? Thanks, Vera

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've been struggling with the SharePointOnlineConnector transformer for a couple days now. I have set up a web service following the official tutorial (first I've set up one for Sharepoint List, then an identical one from the Sharepoint Online template as well). When using a Sharepoint List Reader I can successfully access the lists, but I can't access anything from the SharePoint Online Connector. I get the following error: "SharepointOnlineConnector: Error making request to https://graph.microsoft.com/v1.0/sites?$select=id,webUrl,name&search=: Access token validation failure. Invalid audience." The app I've set up in azure has the following permissions (might be overkill, but I'm just testing for now):Microsoft Graph (5)Sites.Manage.AllSites.Read.AllSites.ReadWrite.AllUser.ReadUser.ReadW

I have mxd file and I would like to extract layer names and each table names related to each layer FME 2021 Thanks in advance

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

Hello everyone, I'm trying to create a automatization of the Viewshed geoprocessing (a raster and a shape file in input and a raster in output) from Arcgis in FME (because its ModelBuilder doesn't work as well). But I didn't find any transformer or python script by Python Caller about it. Have any ideas or tips for me about how can I do exactly the viewshed geoprocessing but in FME ? thanks !

I have a text file that is created in an Oracle database and output to a folder on a UNIX server file directory. Can a FME workspace read a text file from this type of location?

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.

Basically, I want to match meter IDs from two different datasets: shapefile and excel file. Meter IDs in both datasets might have typos such as dashes, dots, letters, slashes, which I need to remove first. Then I want to match MTR_NO from Excel against Mother_1 , Child_3, & Child_4. My idea is to export an excel table that will include only matching meter IDs.   

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 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?

is there any reader where i read the Google analysis data ?

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 ?

Within ArcGIS Pro 3.1 I am creating annotations with the help of Arcade (a lightweigth expression language). The outcome is as shown below, basically a fractionWhen I read the annotation layer from the file geodatabase, FME does not interpret the HTML tags in the text string, but counts them as part of the text.I there a way to make FME interpret these tags correctly? My final product should be a dgn file with a level holding these 'labels' and I was wondering if that is possible, and if I can achieve this with FME. The 'fracture' consists basically of three parts as I see it:nominator that is underlinedline breakdenominator without unde

Hi I am reading various tables from Oracle each of which contain many date attributes. Is there a transformer that will allow me to filter out all the attributes that are have a type of date as I want to check the dates make sense (I know there are some with some very dodgy data in and wont write out to a sql table) Thanks