FME Form

I am trying to parse an SLD file (which is XML) and generate a CSV output based on the rules within it. The following is a sample of the SLD structure <?xml version="1.0" encoding="ISO-8859-1"?><StyledLayerDescriptor version="1.0.0" xmlns="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc"xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.opengis.net/sld http

Hi all,I'm trying to download files (in this case zip files), which are in a parent folder on an ftp. The folder name changes once a week, when new updates are uploaded. I would like to automaticly download the updated files once a week, but it seems that the ftp caller has some limitations in that department - (asterix and subfolders). I have searched the forum for answers, but haven't really found a solution yet. I've seen suggestions using python caller and ftp caller combined, but I dont really do python :-) Any suggestions? Thanks

I have geotiff tiles and some need te be partially blurred, because of military terrains.  I mainly use the rasterresampler to resample the pixels in those area's to 3 meters and then resample them back to their original pixel dimensions.  The problem as you can see in the picture is on the edge.   The black edge is 1,12 meters, so the resampler doesn't have the space to make another 3x3 cell there, so he doesn't.  How can I solve this? I had the idea to make the geotiff tiles canvas bigger (see picture), let it resample and then clip it back with the bounding box of the original tile.But I don't know how to make the canvas bigger.    @Takash

I am trying to generate a JSON message to update editing templates on an AGOL Feature Service. I've got most of it complete. I am having trouble with the last piece though.  Each Editing Template has a list of fields and defaults like this: I am trying to generate 27 unique editing templates based on unique pairs of 2 attributes. The portion of the JSON text I am struggling with is the ["types"]["templates"]["prototype"]["attributes"] section. I have the correct number of "types" (27). I have the correct fields and corresponding default values.  As you can see, I am getting an extra pair of "},{" between each field as co

Hi, I'm new to MongoDB, and I'd like to use FME to import data into it. Can someone please provide me with an example that shows how to set up the connection, specifically the connection Name, Connection Type, Protocol, Host, Port, Database Name, Name and Value parameters? Harry

Hi,I want to read with FME the data from a database oracle.I can connect FME to the database but I am not able to read the linear objects. I use the ORACLE_SPATIAL reader. I have the following message : “Error - Cannot have NULL value for 'z coordinate'” Do I have to parametrize FME to be able to read the null value of Z ?Find attached the text.log oracle_spatial.zipThanks,

Hi all,I am trying to convert fbx file to FME AR. I am getting the error below."FME-AR_FBX' of type Directory, expected a dataset of type Regular file"I tried to deaggregate to see if it works workout but no luck. 

Im having trouble configuring a JSON Reader to pull data from a REST API (JSON formated). The problem is that in order to successfully call a query to the REST API (via a URI), there first needs to be sent an authorisation request as separate formatted URI sent ahead that contains a UserID code and a 'Secret' code (ie password) within the URI. The JSON reader has a single web address field (which works well for other applications). To solve this particular problem there would have to be two URIs sent - one to send the Authorisation request and generate a session ID (with the authorisation held in cookies or similar), followed another to submit the data query. I tried the 'Network authorisation' entering the userID and secret into the respective field without success. Have also tried the HTTPCaller and JSON transformers. I dont know enough about FME or API calls to configure this properly, so wondering if there is some advanced use o

Hello, Let's say i have an excel table containing multiple attributes and features, and I would like to output in an excel table a summary of the unique values for each attributes. Using duplicate filters I managed to get the results but they are ordered in rows in order of arrival instead of being nested for each attribute. Example with three attributes:ID ----- Name ------CityA1 -----Mark -------MoscowA2 ------Paul -------GlasgowA1 -----Joanna ---CapetownA3------ Paul -------Glasgow  Then in excel I get three columns but the results are spread in the order of arrival of results for each column unique values: Column A -- Column B -- Column CA1A2A3--------------Joanna--------------Paul--------------Mark --------------------------------Glasgow---------------------------------Moscow--------------------

Hi All, I have a complex polygon with smaller polyons within a bigger polygon, multiparts and lots of overlap issues. I want to be able to desegregate, remove multiparts and be able to select each polygons individually. Any thoughts will be helpful.

Hi team, While transforming the tables from Reader ArcSDE to Writer ArcSDE . At the Writer end, didnt write any features and getting following error."3.1| 0.0|ERROR |Could not unregister GlobalID column 'GlobalID' in table 'DBO.Publish_Test_Cables_2'. The error number from ArcObjects is: '-2147215875'. The error message from ArcObjects is: {Table is already locked [TCS_TEST_PUBLISH_SYNC.DBO.Publish_Test_Cables_2]}" At Writer end, follownig parameters are used.1.Preserving the Global IDs parameter with Unversioned ArcSDE table 2.Trasaction type is "Non-versioned edit session" Highly appreciate for the solution!! RegardsVIPLAW

hi,I want Conversion   osgb to obj .when Multiple osgb to one obj ,how Merge textures image to one

Hello, I'm doing the unit "Publish your Self-Serve Workspace to the Web" as part of the training "Integrate Your Data with the FME Platform". That unit tells me to change the parameter "Destination Generic (Any Format) Folder" of the writer, to a location on the FME Server. If I change that parameter to the FME Server, and run the workspace locally, it seems to store the output in the same folder as the workspace. I would like to store it in a different local folder when running locally. That way, I can use the same workspace both locally and on the server. Is it possible for the workspace to detect if it's running locally? If so, then I can configure it to save to a specific local folder. If not, I can configure it to save to a specific FME Server folder. So far I've tried:Log File. Potentially the workspace could see if "FME_HOME is 'C:\\Program Files\\FME\\'", which i

I am new to FME and going through the unit "Quickly Create a Conversion Workflow " of "Integrate Your Data with the FME Platform". In that unit, we create a reader to a PostGIS database. My understanding is that what we see on the canvas is just the "feature types" of that database, aka individual tables. I thought that they would all connect to the same "reader" in the background. But when I added two new readers to the canvas (marked 2 and 3 in the image), they created brand-new readers in the navigator. Even in the case of reader 3, which has the exact same parameters as reader 1!Can you please suggest if there's any way to modify the feature type marked 3, to make it use the reader marked 1? When I open the feature type's propert

I run features through an AttributeFilter Transformer in order to split the stream for specific manipulations downstream. If I test this in Workbench everything works as expected. If I call the workspace in BATCH from a DOS script all features end at the AttributeFilter (identical data).In FME Log of the BATCH run I see lines likeAttributeFilter_9 AX31001 Transformer Output Nuker (TeeFactory): Cloned 818 input feature(s) into 0 output feature(s)AttributeFilter_9 SD41000 Transformer Output Nuker (TeeFactory): Cloned 1154 input feature(s) into 0 output feature(s) What is going on here ? Why are the features not passed ... very,very confused 👿 😮 FME 2021.0 up to 2021.1.3 all the same 

I have an attribute called "Status." The coded value is an integer and the domain value is a character. When I do not resolve the domains in the reader, then the automatic writer sets as an integer field, but when I resolve the domains, then the "Status" attribute and the "Status_resolved" are both characters. Is there a way to get "Status" field as an integer and get the "Status_resolved" attribute? I don't want to have to use a manual writer because I have >100 fields. 

I have a use case that is not covered under the three snapping modes available in the anchoredSnapper.My candidates are a set of lines, the anchors can be either lines or polygons, but for this discussion will be polygons.The lines need to have their end points (and only their endpoints) snapped to the nearest polygon segment. The rest of the vertices of the line should remain untouched. Currently I am developing the following workflow:Create a unique id for the lines.Extract the end points of the candidate lines, send them to an anchoredSnapper with the polygons as the anchor, use snapping type Segment.Take the original lines and send them to a second AnchoredSnapper with the points as anchors and snapping type End Point, grouped by unique id. Is there a better solution I'm overlooking?

I have been given a huge spreadsheet containing countless series of identical columns that are duplicated many times, with a prefix in front of each that indicates some kind of property of the data. I now want to reformat these data so that the duplicate columns are replaced with unique columns and the attributes that were used to separate the columns become attributes in the data instead. Please see simplified attachment (and screenshot, below) which shows the "Current format" and "Desired format" sheets. CurrentDesired I've tried several things, none of which are giving me the results I want:Adding an AttributeCreator to create a separate, duplicated pi

I have a workspace that reads a database table (no geometry) from a file geodatabase from an on-premise subnet server location. When running the workspace from a Desktop VDI, I get read speeds of ~10K every minute or so. When running the same workspace on Server, I am getting speeds of ~10K records every 6 minutes. I tested to see if the location of the FGDB was the issue by uploading the FGDB as a server resource which resulted in the same slow reading speed. In my experience, Server has always been much faster than Desktop. Has anyone come across this issue?      

Hi! This is a general question re: what's possible with FME's SDE capabilities. We have some automated processes whose SDE readers take in large amounts of data, and they take a hit whenever they encounter corrupted or missing indexes. We are considering setting up some 'helper' processes to examine the indexes separately before the data is read in the main workflow. I know, for example, that there's ArcPy methods such as ListIndexes that can be used to check some of their properties for any given feature.  I'm wondering if FME can natively do something similar and without, say, calling ArcPy through a PythonCaller? Are there any exposable parameters or validation tools (or does anyone have an approach) that could be used to examine the SDE's spatial and attribute indexes and flag problematic ones? Thanks!

Hi, I'm using the string searcher to extract some codes out of a text field. I can extract the first match or build al list with all the matches but is it also possible to extract only the second match of the third match?This in an example of the text. When it says "2 opladingen" then I need the first two codes that are in the parentheses, but they can't be in the same field as I have yet to join them with another table. I already found the right expression to find the codes \\d{3}[_][A-Z]{3,}  Er ontbreken nog 2 opladingen voor aanleveringsgebieden: (ZG Beveren aan de Ijzer (rietveld VLM): AQUAFIN (556_AQUAFIN), ZG Beveren aan de Ijzer (rietveld VLM): INTERCOMMUNALE WATERLEIDINGSMAATSCHAPPIJ VAN VEURNE AMBACHT (556_IWVA))<br/>Een inactief gebied mag geen data meer bevatten (ZG Beveren aan de Ijzer (rietveld VLM): VLAAMSE MILIEUMAATSCHAPPIJ (556_VMM) -> Bewerkin

Is there a transformer that creates an ESRI AddressLocator tool?

Hello, I’m looking for a way to classify (order) the lists within a list attribute. Essentially I need all lists that have a “phase” value of ‘R’ to be on listattribute{0}…all list values that have a “phase” value of ‘Y’ to be stored in listattribute{1}…and all list values that have a “phase” value of ‘B’ to be stored in listattribute{2}.  Using List Sorter, I am able to accomplish this as long as there is a list for all three phases. The data sometime has only 1 or 2 phase values (example: Y and B, but no R). If I sort the lists that only have two phase values, “Phase” = ‘Y’ ends up in listattribute{0}. How do a force a blank list value for ‘R’, so that ‘Y’ still gets stored in listattribute{1} and ‘B’ gets stored in listattribute{2}?.... listattribute{0} could remain blank  These lists need to be structured correctly so that I can run them through an XML Templater and have them placed in the

I've got a knotty problem that I can't seem to think out.I've got a CSV file that comes out of system A (the coloured section of the image). It's invoices that need paying against Purchase Orders. An invoice starts with a H (header) and has a number of D (detail) rows.On occasion a PO Item may have it's TAX split and the source system outputs the tax splits.The target system can only cope with a single line per PO Item number so I create a list and group on the appropriate columns and return a list on the ones I need to aggregate...Tax code - first codeAmount - sum of the valuesQuantity - sum of the values So far so good. BUT the DOC_ITEM (blue) must be sequential based on the number of rows in the actual invoice.It's

I have converted a large geoJson into cesium 3d tiles -- wonderful... but not when enabling terrain -- tiles are partially visible obviously due to elevation. Is there something available in FME to consider the terrain?