Using transformers to modify data.
Recently active
Hi,I have a process where I am using a DEM to apply values to vertices of polylines using vertexextractor, point on rasterextractor etc (see below). But I end up with gaps where the z value has been attributed as -32767. These have occurred where the vertices are just outside of the clipped DEM - is there anything i can do to interpolate?
Hi all,I have a lengthy workbench running. I can see the temporary files being written to the relevant 'wb_run...' folder specified in the translation log. The workbench has just finished writing outputs of an AreaOnAreaOverlayer, and those outputs are now being used as the input to a Dissolver, which is in progress at the moment. I can see a 29GB file named 'FME_OBJC_DissolverInputAreas...'. Is this a temporary hold of the AreaOnAreaOverlayer output features? If so, is there any way to use this temporary file and access/export the features in it? In case it is relevant - I have feature caching turned off. Thanks!😀
I am looking for some suggestions on how I could create a workspace that would detect no intermediate junction between linear objects that share connectivity between them and are of a different asset group and/or asset type. an example would be a HV conductor connected to a LV conductor without a point feature in between.All suggestions welcome.thank you :)
GeoCode transformation working very slow its take whole day to get the result just only 28K records is there any way to run faster
We update hundreds of shapefiles quarterly. The data we use comes from many sources, but we transform all the data of a single type into a standardized "Master" schema for that type (for example we get Parcel data from 70 counties, each having their own schema, and we translate and transfer that data into a standardized "MasterParcel" file). Using the above example we currently use 70 different workspaces containing 70 different instances of AttributeManager. To hopefully make this process much more efficient, we have developed is a database table containing rows like "ProviderSourceTable", "SourceAttribName", "SourceAttribType", "SourceAttribLength",...."TargetLayer", "TargetAttribName","TargetAttribType".... basically all the data AttributeManager needs to do the job for each data provider/data type combination. The only problem is we cannot figure out how to use this data to dynamically populat
Hi, With an http caller I execute get requests. This is done in a loop to enable pagination. Sometimes the server that receives and handles the request has trouble handling it and returns an error message. Is it possible to put a decelerator after the rejected port of the httpcaller and then redirect it to the inport of the loop so that the last get request is executed again and the workspace continues?
I have 10000 GML files that I have read in as a single merged feature type. The task is to convert them into FBX files, maximum of 300 MB per FBX files. How do I accomplish this? I have tried modulocounter but doesnt seem to work.Also, I have tried fanout, and am trying to see if I should run a script to separate those files into folders first, prior to FME. Any ideas?
I have a fairly straightforward workspace writing out one AGOL feature class with a large schema (American Community Survey data). After running the writer the translation log shows 26 features successfully written, however, the resulting AGOL feature class only has one feature. I am stumped as to why this might be happening as I've worked with AGOL writers pretty frequently and never encountered anything like this. Any advice?
When using the AzureEventHubsCOnnector to receive in stream mode, the documentation states "Stream: The connector continues to receive messages indefinitely. The translation needs to be terminated in order to stop reception." Am i missing something here? how do you send a termination to it? In python this is straightforward...
Dear All, in the attribute "id" I have strings that have the following format411d8e4d-2de6-0f5b-e100-00000a4c0a0dI would like to remove the dash in an AttributeManager (I know, I could do it with StringReplacer). I've tried the following formula :@ReplaceString(@Value(id), "-", ""))but it does not work (id remain unchanged), whereas the formula with FindString here below gives the expected result (8).@FindString(@Value(id),"-") Why the FindString is working but not ReplaceString ? What am I doing wrong ?I was also able to do it in the regular expression-way, @ReplaceRegularExpression(@Value(id),"\-","") but I don't understand how ReplaceString works. Has anyone an explanation ?Thanks in advance
This might be an easy one but i could not find a way around it, I have two files File A (lines with geometry) and File B CSV file(lines without geometry). Both files have ID,START,END columns as shown below. So i was wondering how can i merge them on ID as the first key and also specify the range of the start value as the second key, (any other approach is welcomed)so what i expect is the first two values of FileB be given geometry from the first value of file A, and the third value of FileB be given geometry from the second value from FileA.Thanks ,Keller.
Say I have data like the following;sequence_path (string: UTF-8): 1.2.3.4As a result I wanted to fetch the parent from this sequence_path (i.e. '1.2.3'). In order to do so I wanted to do the following;Use a reverse search to find the position of the last '.' in the string, Fetch the (Left) substring up to the position of this last '.' To perform the first step, I thought to use the FindString() string function (with a negative startIndex). So, at first I thought that @FindString(@Value(sequence_path),.,-1) could be used. However, that returned '-1' (not found). However, somewhat unexpectedly at first, I noticed that '@FindString(@Value(sequence_path),.,-2) ' did return the desired value. Upon second reading of the String Functions documentation: "If startIdx is a negative integer, FindString() returns the index in str starting at startIdx from the end of string , then matching strToFind going forward (from left to right)." I now notice that the search is still from left to right (forwa
Hello, I wish to write to a specific version in a versioned feature dataset, by default the arcgis portal feature service writer writes to the SDE version aka the main/base version. Where can I configure which version the writer will write to? Thanks.
Hey there,I have to download several CSV Files from a website. I do it with the HTTPCALLER Transformer. It works perfect. I get ALL the data (several columns and lines) in one "cell":I need the informations in lines and columns, so that I can manipulate the data. I have tried with Pythoncaller, ListExploder, AttributeCreator,... but it doesn't work.Do you have any idea, how can I get that? I think the problem is the configuration of the HTTPCALLER or of the other Transformers but I have tried a lot of things and nothing works. Many thanks in advance!
I have two POST API calls to the Microsoft Graph API in my workspace. The workspace functions as intended on desktop ,but when I upload it to FME Server the POST call on the second HTTPCaller will fail saying that there was no token provided (message below). "message":"Access token is empty.","innerError" How can it work on one POST call and not the other when its using the same Web Connection? Also why is it functioning fine on desktop and not FME Server? Thanks
Hi Darren. I'm a new user of FME and am interested in your 2014 post about translating to DWG as 1km grid squares. Do you have anything you could share that would help. I see in the post you say you got it working. ThanksChris DickinsonNorth Yorkshire County Council
PDF to SHP with Text embodied in pdf
The error message shown is "XML Parser error: 'unable to open primary document entity '\\1_Src\\Bag\\Inspire_data_NLD\\9999STA*.zip''Failed to obtain any schemas from reader 'GML' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. "
Hi all I have buildings polygones with height attribut. when the height was calculated some of buildings were cutted in two. So now, I would like to dissolve those buildings and keep the max height of both. I can dissolve easily because they share an identificator, but I dont know how to keep the maximal height of both. Thanks you all
Hmm, I am struggling with this for a day now and I tried the tutorials, but it seems I am doing something wrong.So, basically I have an xml file out of which I want to put certain elements into an Excel output. But here is the issue.I want those outputs in a certain order - and no matter what I do, FME will always write the columns into alphabetical order. Which just will not do for this application. The transformation is a simple one: But somehow I always end up with the same output.As You can see, I already renamed the attributes with the numbers, trying to sort it that way, but no matter what I do, the output then looks like this:(Also with those weird widths for those columns) Can this be somehow changed? Thanks so much in advance.
I am upgrading from FME Desktop 2016 to 2021.2. I am facing a issue with my FME script, getting error as "SCHEMA_DATASET" not found. I don't want to supply data set sometimes so haven't fixed it's value. In my script I have only one schema reader and it is causing issue as I see I can't give null dataset to it.I have tried enabling "Ignore Failed Readers" to yes and "Rejected Feature Handling" to continue translation.Any help would be appreciated
I added a FMW file that shall create a PDF page with the names Arnold and Sylvester. It creates the page but with nothing on it.
Hi,I've a polygon feature with an attribute "LEVEL" containing values from 1 to 10.The polygons can be overlapped. I want to dissolve the polygon grouped by "LEVEL" and only keep the polygon with the lowest "LEVEL" value. It's easy to dissolve the polygon grouped by "LEVEL" but how to only keep the polygons with the lowest value ?Here is an illustration of what I'm trying to do, the number correspond to the attribute "LEVEL":
All,Need some help. I have a httpcaller hit a webpage but the package it brings back is only a partial response body. The first file attached is the response body from the HTTPCaller and the second is from copying the html using the Chrome developer tools. Do I just have a setting wrong? Using FME 2021.1 with the default HTTPCaller settings for 'Get'@Takashi Iijima
HiFairly new to FME!I have connected to my AGOL account and downloaded the data through the AGOL reader. I wish to change the date format from the AGOL default yyyymmddhhmmss.sssss to something more sensible i.e dd/mm/yyyy hh:mm:ss I have tried using the DateTimeConverter to output but whatever combination I try the Attribute (Survey_Date) stays the same. Any help or advice would be great