FME Form

Using the Esri Geodatabase (ArcSDE Geodb) Reader and Writer what would be the best settings to get the best performance to truncate and insert annotation feature class records to a writer. These annotation feature classes are not versioned

Hi,I have a dynamic pdf with a large number of questions. This file will be filled in by different people and we will recover these files once the investigation is complete.Then we want to compile all the answers from these files and we would like to do it in Excel.Is it possible to convert dynamic pdf file to Excel with FME?Thanks a lot,Have a nice dayMatthieu

Each month I have a spreadsheet I would like to split into several separate spreadsheets based on values in one of the columns. This column contains peoples names and I would like a spreadsheet per person to be written out. To complicate matters the values in the name column can change each month so the process would need to be dynamic. How would you achieve this in FME?

I have a right-of-way polygon (ROW) that I generated a 3-foot buffer with the intention of selecting all parcels within this buffer. When using a SpatialFilter in FME not all of the parcels with in this buffer are selected as they should be. A sample of the parcel and buffer data is attached and the Parcel with OBJECTID 85 does not select. When using the same data in ArcGIS Desktop the parcel does select. Note, the buffer is created at 3 feet, a larger buffer results in false positive results. I also noted that when viewing the data in ArcGIS Desktop and FME Data Inspector the parcel is clearly within the ROW buffer; however, when viewed in the Visual Preview in FME desktop, the parcel is not within the buffer. Screen shots below of the same area in all three viewers. ArcGIS Desktop:  FME Data Inspector:

 i would like to write different numbers for input parameters 2354 or 6985 or 4893i mean ,i want to add different input numbers and inside the workspace i have added test filter for the input user parameters if specific attribute has 2354 or 6985 or 4893 should do function .so my question : how could i add input parameters more than id numbersFME 2018 ,thanks in advance

I am using FME joiner to join tables. the joined tables do not show all fields from the source table. I was wondering what could be the reason. Any help would be greatly appreciated.

A FeatureReader typically outputs data features on defined data ports, plus the "<Schema>" and "<Initiator>" ports.I know that "<Schema>" features gets output before any data features (from that schema), but what about "<Initiator>" ?Does this feature get output at the very end, i.e. after all data (for this initiator) has been output ?If not, is there a way to initiate a downstream transformer _after_ all data has been output ?

Is there a reader which will locate all the JSON URL endpoints on a webpage for me? I wish to acquire all the attributes related to spatial features contained within the webpage.

I'm using the JSONTemplater and have an attribute list. My (sub) template is {"id": fme:get-attribute("sumo_id"), "crosswalks": fme:get-list-attribute("_list{}.poly_id") }Which works fine if i have multiple list elements,  but becomes a string if I only have one. {    "id": "390335938",    "crosswalks": ["225790", "2833648", "15808"]  }, {    "id": "126630292",    "crosswalks": "1243410"  } when I'm looking for {    "id": "390335938",    "crosswalks": ["225790", "2833648", "15808"]  }, {    "id": "126630292",    "crosswalks": ["1243410"]  }, Is there anyway to force the JSONTemplater to keep the array, or baring that what is the best way to post process the templater results?

Hello everybody, If you have seen the image, the labels displayed near the points they mention the order or the route of GPS, I would like to know is there a possibility for example to eliminate the segment which is near point 70, because in real life it should snap on the other segment. https://zupimages.net/viewer.php?id=21/27/j24o.png

I am working on a project that involves sending an email notification to a series of email addresses with a text body and embedded map of the area impacted. I am having a hard time pulling together examples to get this done. The embedded map would include:a background image (either ESRI basemap or using our internal ESRI raster mosiacs)a series of ESRI SDE points, lines and polygons (some having labels)both the image and vector data would be clipped to a specific boundary (usually no more than 1500 acres (~600 HA) I am assuming that the embedded map within the email would need to be a jpeg, png, etc. But I could be assuming incorrectly... The main item that I am struggling with (at least now) is the creation of the map. I am also struggling with bringing in an ESRI basemap or connecting to our mosaics without it reading the entire mosaic. I am running FME Desktop 2020.0 and have a FME Server

We have been using AthenaConnector for awhile and have about 75 mappings developed. Last summer while using FME 2019, the AthenConnector automatically updated to version 1.0 of the connector.  A lot of mappings started bombing. Also see FME Hub Comments. Here is one such error message:2021-11-02 11:18:02|  3.6| 0.0|INFORM|AmazonAthenaConnector: Query ran successfully. Run time: 6.417 seconds. Data scanned: 640595.24 kB 2021-11-02 11:18:02|  3.6| 0.0|INFORM|AmazonAthenaConnector: Query results saved to: 's3:/...' 2021-11-02 11:18:03|  3.8| 0.2|WARN |Python Exception <ValueError>: invalid literal for int() with base 10: 'client_num' 2021-11-02 11:18:03|  3.8| 0.0|WARN |Traceback (most recent call last):  File "plugins.py", line 447, in input  File "...\AppData\Roaming\

We are using a custom Token Based web connection to an external service. The service does not return an expiry time - it is always 180 minutes.  Is there a way to hard code an expiry duration on a token retrieved by the web connection? The UI for defining a Token Based web connection seems to only support an expiry time being returned by the token service.

I'm looking for some help on what I am sure is a common problem hwoever being new to the software I'm not too sure what the correct terms are. I am using the RasterTiler to split a large DEM into smaller tiles and write them to a new format. This is working fine but I would like to have the a coordinate of a corner of the raster written to the filename of the output. You've probably seen similar below, which is what I'm trying to achieve:For reference, this is what my workspace set up looks like:Thanks for your help getting me to understand this new software.

Hello we have an AutoCAD drawing that contains some 'wipe out' features i.e. polygons that sit above other data and hide the information that is underneath it. All of the wipe outs have the 'Display but not plot' setting in AutoCAD but for some reason they are not being read into FME.I have the 'Ignore Frozen Layers' and 'Ignore Hidden Layers' settings in the reader set to No but that does not seem to make a difference.  The snapshot is an example of where the wipe out is used in the sample drawing  Does anyone have any advice on how to read these layers into FME as I need to replicate what AutoCAD does when creating a TIFF / PDF output.

I upgraded OSX to version 12.0.1 last night (Monterey) Now when I try and create a new Reader in Desktop I get the error as follows. Is anyone else seeing this? I am running FME version 2021.1.2.0    

I have a directory structure containing source raster tiles (512x512 pixel png files) in TMS (XYZ) format at level 10. These have been provided to me by a third-party.From these I'd like to generate levels 9 & 8 so additional layers can be shown in a leaflet app. I thought FME and the WebMapTiler would be the answer, but I'm struggling to get this working. So far I have the following in workbench: A PNGRASTER reader that reads all the source files from the existing directory structure.A PythonCaller to calculate the bounding coordinates of the source tiles using a python function from here - https://wiki.openstreetmap.org/wiki/Slippy_map_tilenames.A RasterGeoreferencer to georeference the rasters usign the above coordinates.A RasterMosaicker to generate a single raster.A WebMapTiler (set to GlobalCRS84Scale, Minimum Zoom=8,

Hi, I'm inefficient with CSS selector statements - having no HTML authoring background. I want the CSV download links at this site and only the csv download links:https://data.sandiego.gov/datasets/parking-citations/I can get all 'a' tags and the href references no problem but have to test the result ends with '.csv'. Can anyone give me the right selector syntax for the element I'm after? Thanks all.

Hello,​So I have a data, which is called "Amendment Date". The format is as followDD/MM/YYYY HH:MM:SS. ​I would like to make a checker to check if the input data are correct. I tried the attached steps and it seem ONLY works on correct order. If the data is wrong, it said ERRORS and cannot run the transformer. Would someone please guide me how to do valid the format. Thank you.

I have a .dgn that has a lot of 'blocks' that are made up by Smart Solids (they consist of only fme_lines as far as FME Desktop sees it) and they show up like thisOf all the other parts (Free Forms which are fme_areas) Im building with MeshBuilder and they show up just fine, but these parts are missing. I managed to separate these parts from the working ones because clearly I have to deal with these differently but I dont know how. SurfaceBuilder/SolidBuilder seems to just reject everything, only AreaBuilder (which if Im correct is not for 3D stuff?) outputs something but it is far from what I want, for example:For this input

How do I convert a date such as 12/31/1979 to Julian date in FME?

My reader contains two features: 1 line, 1 point.My output writer is set as Generic and with User Parameters to choose the output options. But the attributes/fields I pick are captured only in SHP/FGDB/KML but not Autocad Map 3D Object Data. Any clue how I can include the attributes I want in the autocad output?

Hi folks, For some unresolved reason, our ArcGIS Server 10.7.1 crashes intermittently. Like randomly after a week or a few weeks or month or two, it just crashes. When I check the Server logs for what appears around the crash timestamp, there are a number of SEVERE errors that follow the pattern of "Error performing query operation Wait time of the request to the service <SERVICE> has expired." It's a specific set of services, enterprise feature classes as their source, usually the same culprits appear in these error messages so I thought it might be associated with some web apps that may be experiencing strangely heavy use at sometimes outside of main business hours. I've already had Esri Tech Support investigate this but they couldn't figure out what's causing the issue either. But I recently changed the source of one of these services to point to a shapefile instead. At the next Server crash, this layer did not have its

I'm working with a client who has all their infrastructure based on IBM Cloud and they are looking at reading and writing files from IBM's version of S3. The docs say that they basically use a complete clone of S3 implementation (actually a copy of the boto3 library for access) so I'm wondering if FME has an OTB way to work with these kinds of buckets? Relevant docs here: https://cloud.ibm.com/docs/cloud-object-storage?topic=cloud-object-storage-getting-started-cloud-object-storage I've given it a shot trying the S3Connector but even when providing an alternate endpoint it still seems to fail to connect. I'm not sure if it's the way the transformer is implemented or if it is something I'm doing.

Hi,I have problem creating an excelfile in a script that I published in FME server. I get an outputfile with type "file" and not ".xlsx". I can use the file to drag and drop it to an empty excel sheet. However what I really want to do is to create an excelfile. I am using a published parameter in my writer that looks like this . Also please check my parameters for the excelwriter.Am i missing something important? The version on FME desktop: 2020.1.3.0The version on FME server: 2020.2.3