Transformers

I have been working on this challenge of using two HTTPCallers to update the assets' spatial data in the AMS (Asset Management System) via an API in the form of uploading the GeoPackage files into AMS. And here how the two HTTPCallers are set up: The first HTTPCaller uploads the GeoPackage file into AMS and in that process, it has to save a string value in the "_response_body" attribute in the FME Workspace - However, at this stage the upload is not working at all due to lack of the string value in "_response_body". Then the second HTTPCaller takes the string value in "_response_body" as a Job ID to do the validation of the file and after that begin importing of the data. And therefore, if the first HTTPCaller can't return a string value in the "_response_body", neither upload nor import of the GeoPackage happens. When I tested the API in Postman, it works as expected.

Since it almost exactly matches what I’m trying to do, I started with the workspace posted by @trantatsafe here https://community.safe.com/s/question/0D54Q000080hPh1SAE/agol-attachments-what-are-you-doing-with-the-attachments-after-youve-read-them Problem 1)There are 3693 attachments in the dataset.  When attempting to put them through this workspace, only a suspiciously even 2000 come out of the ListExploder. The others fail with the message MISSING_PARAMETER_LIST. Since they exist (visible from Esri), they must have attributes, don't they? Or am I missing something here? I hate to muddy the waters but there is also second iss

I have a DGN with linked word/excel/pdf documents and I am wanting to extract the filenames and connect to the relevant geometry within GIS. When I open the DGN in MicroStation I can see the linked documents but when I open in FME Inspector, they disappear. See attached image of links in MicroStation. I thought they may be pulled through into a 'linkage' field but they don't look to be.

I have a workspace that reads other workspaces, to do an inventory. I have looked for the Startup Python Script but I can't find it, does the FeatureReader not read that information?

I just started using FME and my first goal is to compare values from DWG attributes and Excel rows. Each Excel row corresponds to a DWG file, I use AttributeKeeper to filter out the same number of columns in each transformer and would like to test each column in the DWG file to the Excel file to see if they match. If they don't I want to add that row, where one of the columns is filename, to a new Excel file and output it.  I've searched this forum extensively but can't find a topic that matches my specific question. Some help on how to continue would be appreciated.  This is an example of my input from both Excel and DWG. I want to know if "Value1" in File1 of the Excel file is the same as "Value1" in "File1" of the DWG file, and so on. The filenames are always the same but the column names differs. 

FME Desktop 2021.3 Python Interpreter ESRI ArcGIS Python 3.7Hi I am trying to pass a user parameter that includes the ampersandi.e. username@domain, which I then use within a python caller to login to ArcGIS PortalWhen I look at the value of the parameter, I get username<at>domain hence I am unable to connect to my portal.I have tried to format using string functions str() and strip(). But it doesn't work Any suggestions ?? 

Hello,  We recently upgraded from FME version 2022.0.0.0 (20220428 - Build 22337 - WIN64) to 2023.1.1.1 (20231011 - Build 23636 - WIN64).After the upgrade one of my tools gives the following error: GEODATABASE_SDE writer: The encoded string is not a valid US-ASCII string: ''AsfaltverhardingPlaatsori\\xC3\\xABntatie'' This happens at a GEODATABASE_SDE writer. The writer uses the following settings:Feature operation: fme_db_operationTable handling: Use ExistingUpdate Spatial Column(s): YesActions preceding the writer determine what kind of db operation is needed Problem: It tries to process a 'ë' but fails to do so After some debugging and looking at other similar questions on the forum, I think it has to do with the locale/character set. In FME 2022 the process encoding was set to UTF-8. When I look at the locale/encoding used in our ArcGIS Pro enviroment (

I am creating a flow that runs a number of tests on an Excel spreadsheet and spits out the results into another Excel spreadsheet. The incoming spreadsheets will almost always be in different folders (same parent directory, but each project has its own folder within that), and I would like the outgoing spreadsheets to go to the same folder as input, and have the same filename but with the suffix of 'FME Test Results'. I am currently managing this manually, and wondered if there is a way to do it using FME.I have found several answers that seem to get partway to my goal, but don't seem to fully get there.Thanks,

I want to create a workbench that accumulates the flowrate through a drainage wastewater pipe network which has some flow monitors in between pipes and some at branches. I want to accumulate the flowrate such that: The flowrate of a pipe leaving a branch (with no flowmonitor) is the sum of the flowrates of the two pipes entering the branch (leftmost diagram)The flowrate of a pipe leaving a flowmonitor is the flowrate recorded by that flowmonitor (middle diagram)The flowrate of a pipe leaving a branch that has a flowmonitor is the flowrate recorded by that flowmonitor as shown in (rightmost diagram) 

In SharePoint you have the ability to add file attachments to records in a List object, can FME access these at all? I've tried the FME List Reader, which just gives a Yes/No field on if an attachment is present, and the SharePointOnlineConnector, but I can't seem to get it to view List objects at all.

It looks like it displays the correct value but for some reason when you click on it or look in the "Feature Information" it looks like it's the truncated version of my string. When I try to preform other operations it'll use that truncated version too which sucks.

Hi, I have a polygon feature class, and want to process each polygon one by one, sending it to a fme flow job submitter. I tried writing out each polygon as a shape, and process then as a path file *.shp, but there must be a better way. Rudy

Hi guys,im using a csv file (with sde feature class names and etc.) as initiator to read various feature classes from a Esri sde database.however i also need to setup a spatial filter on this feature reader to limit the number of record being read. is there a way I can get this setup? I tried add another initiator into same feature reader transformer but seems this is not working.. Thanks guys!

I have a linear network that I have processed with the TopologyBuilder. I have a second linear network that I defines the from-to lines for the ShortestPathFinder. My concern is that the polylines in the two linear networks are segmented differently, for example, the Topology Edges are segmented at intersections and the From-To lines are segmented at mile markers.  Is it necessary that the segmentation of the two networks aligns or just that the From-To vertices correspond to points on the Topology_Edges?

Hello All, Currently I'm converting CityGML 2.0 from IFC4. The IFC file is a building model. So normally the exported CityGML feature types should be under Building module, which are named with "bldg" as the namespace prefix, e.g. bldg:Building, bldg:BuildingInstallation, bldg:WallSurface, etc. However, I found some feature types of the exported CityGML were assigned to Bridge module. Although I can turn on "Add XML Namespace Prefix to Feature Types" (found in the parameters of CityGML Writer), and make the feature types "brid:Door"/"brid:Window" to "bldg:Door"/"bldg:Window".  I'm just wondering why th

Hi, I will create a military grid (10m precision) for an area. I have seen that there are some transformers in fme. I think the "MGRSGRIDGenerator" Trasformer is what I need. As input any 2d polygon feature is allowed. I runs successfully but does not generate any output!  Does anyone have experience with this trasformer?  

I have a shape file containing for each 100m a line segment representing a 100m segment of a railway line. I would like to create for each line segment a buffer polygon that has no overlap with neighbouring buffers in railway lines to corner.  Creating an indivdual buffer for each 100m line segment results into the following buffers:As you can see the buffers are having gaps wen the line is cornering. In order to avoid the gaps I created a single line using the LineCombiner and then using the Bufferer to create a single polygon. Next step would be to 'cut' this single polygon into polygons with a length equal to the original 100m line segment.  Following the result of the LineCombiner and the Bufferer:

I am trying to get FME to compare all fields (no key) and only insert uniquid rows.On initial insert all works great but when I go into excel and change a few field values of a rows or two, FME does not update. Instead it inserts them as new rows.How can I overcome this? ThanksB

Hello,Did anybody resolve a problem of writing character ???ŠŽ ( part of Latin2 / cp1250 codepage ) to Geospatial PDF Writer ?Regards Mišo

Hi, does anyone know a workflow for detecting green areas based on aerial images? We have true orthophotos (with NIR-channel) as input. Perhaps there are already instructions or someone has had experience? hope someone can help me! Thanks in advance! 

For example:  I have an external table that has regions for column headings (North, South, East, West) and part numbers for row headings (Part#001, Part#002, Part#003, Part #004,...). A part number in a specific region has a cost as shown in the in the image.  Also, I have another table with the attributes Region and Part Number in FME.  I want to make a new attribute that searches the external table based on the two attributes in my FME table: region and part number and returns the cost. How can I do this?    

Quarter 1 is April, May and June; Q2 = July, Aug, Sept; Q3 = Oct, Nov, Dec; and Q4 as Jan, Feb, March.If I need to run a workbench at regular intervals throughout the year, which transformers will I need to identify features from the current month, and current quarter?I have converted the dates to FME format, and I guess I need to add a DateTimeStamper to get the current date. Then what do I need to do?Many thanks in advance for any pointers you can give me.RegardsStu

I have a PDF Writer which generates PDFs with 4 layers:Frame, Basemap, OldLine, NewLine.NewLine is an interactive layer (hover over it to see attribute details). I would like to also do the same with OldLine - which has a gap that NewLine fills nicely. However when I make them both interactive then, in the resulting PDF, I either get to see just the first part of oldLine or the whole of Newline... Both lines are visible in the sidebar bookmark and the mouse pointer changes when I hover over the invisible linework. I have tried various layer orders (guidance says interactive are always at the top anyway) and many other settings, but can't get a decent output with both layers fully visible and interactive. Is there a hard restriction to one interactive layer? Cheers

I'm sure this will be something really simple I am overlooking (as usual!)I have some excel data of personal information, including age.I need to:1.       group ages, 0-17, 18-25, 26-35, 36-45 and so on.2.       count how many each category / group has.3.       Display data in ExcelFor point 1, I have used the Attribute Range FilterThis gives these resultsSo far so good! For point 2, I use the statistics calculator to do the total count of each group:Then into Attribute manager to rename the column