Transformers

Hello, I asked the above question in the New To FME forum, but no takers. Lets see what happens here. My goal is to join CAD wall lines that are collinear and have a gap where the door is located (usually 36"). The LineBuilder does not have a conditional option.  Two ways I can think of pursuing are:Group collinear lines that have a gap of 36" between end-point of one line and start-point of another. Lines have all been changed to a positive vector, so end-points are followed by start-points on X or Y axis.Use the CAD Door layer to locate prospective lines. These door symbols are blocks with an insertion point at the hinge. Very standard. Here is a screenshot, attached, of a typical hallway. There are large gaps which should be ignored and others that are approx. 36". On the left, you see two door setbacks. It is not a problem to separate horiz and vert lines if needed. Any help

Hello FME Experts that are far smarter than me, I have a very interesting text file that I need to isolate columns for to map points via lat and long values. Below is the URL to the dataset, it relates to fire weather conditions that are updated daily. https://www.wfas.net/images/firedanger/fdr_obs.txt I need to isolate the Colorado-related records and put all the values into their designated columns. If I use the standard text file reader, everything is mashed into one column (see screenshot). I tried using the CAT Reader, but can't seem to get that option to the right place. Does anyone know a better Reader or combination of Transformers that could help delineate these columns of data? 

KML output written in kml_schema_data,I am not able to write in kml_data as shown in expected ouput image    

I attach a visual example, from the visual preview, I want the blue tick row to merge/duplicate the attribute while the row with the yellow mark to keep the attribute value from the original value. Any help or guide will be appreciated. Thank you.

Hi , I have geospatial pdf has coordinates and I have shape file with other coordinates . i have read the pdf file with reader geospatial pdf and i can see that it has many layers and some data at pdf does not exist in my shape file and some exist  i would like to change coordinates of geospatial pdf to same coordinates as shape file .How could I achieve that ? the shape file consists of lines and polygons (Buildings) and points some of buildings and lines ,i can find also at pdf file but in other coordinates .it locates far away of each other . i have used pdf reader ,parameters coordinate page point and enable non spatial read meta data objects ,Map frames The type coordinates of geospatial pdf is unknown for me .which transformers could be useful to move geo pdf to same location of coordinates as shape file ? i am thinking if there is any transformer to compare

Hi Team, I have a electric lines and electric devices . I want to split the lines where the device exist . I used the point on line overlayer with 0.001 tolerance . But its creating many new lines with 0.001 feet (less than a feet) lines .Ideally this shouldn't be . Its creating the issues when building the Utility network . can you please help me on this ?  

Not sure if, while renewing, the new license overwrites the older one or do we do it manually?If the license is ok, is there a mistake in how I am using workbench?The license we have is a temporarily renewed free trial license. The error message in the image shows that. Please advice on the same.

Hi all, I have created a Choice user parameter and am importing the contents of the choice list (or dropdown) from a spreadsheet.The Import appears to decide itself how it wants to sort the contents of the list. Is there a way this sort can be turned off?I have already sorted the contents of the spreadsheet into the order I want, but the import kind of ruins this order, and then I am forced to manually reorder with the up and down arrows. This isn't too bad with a very small list, but is pretty frustrating with a much larger list (which I have). Plus I know I am going to have to refresh the contents of this list semi-regularly in the future.Does anyone know of a way around this? thankskeith 

I am trying to extract the 1st and 4th word but it just keeps grabbing the first 4 words, I've tried without the ^ and it doesn't work

I have situation wherein I need to add fields to all the feature classes within a SDE. I cannot seem to figure out how to loop through the SDE, and operate on one feature class at a time, though. My first thought was to generate a list of all the feature classes in the SDE using two FeatureReaders, but then I was not sure how I would iterate through that list.  Any assistance would be greatly appreciated. Thanks!

So apparently, FME does look for fields that might be a good candidate for creating a point geometry in both Excel and CSV readers (see https://community.safe.com/s/question/0D54Q000080hfENSAY/excel-format-of-attribute). This means that if in an Excel or CSV file, there is a row with column names such as X and Y, FME will automatically try to create a point with the contents of these cells. In the top-rated answer of the above link, it is mentioned that for the CSV reader, this will only occur if the option "Scan for types" is activated. This option does seem to be missing for the Excel reader, though, or am I overlooking something? I have the problem that I am using a FeatureReader to dynamically read from an Excel file (the specific file

This is not a real question, it's more an assesment. In FME 2022, it seams that every query run with SQL Executor/Creator is run as a prepared statement (see here for more information on PostgreSQL https://www.postgresql.org/docs/current/sql-prepare.html). The problem is that only certain query can be prepared, not every one...Some of my queries can not work anymore like every "CREATE" queries that can not be prepared into PostgreSQL. Is there a way to disable this behaviour ?  For me it's a critical problem because some times we need the queries to be run as we write them, not like the database want to redefine them.

We have one floating licence and it is now stuck on an old laptop and won't release it. Can I force it to release either from the device or from the licence server?

With a postgres writer it appears that if Bulk Insert is set to Yes, if you attempt to write a string value of NULL to a varchar column that has a Not Null constraint it is interpreted as a genuine null and results in a fatal errorError was 'ERROR:  null value in column "value" violates not-null constraintIf Bulk Insert is set to No, the value is written as a string as expected Is this a known issue? This is in FME(R) 2021.2.6.0 (20220727 - Build 21821) so may have already been addressed.

Hi, I'm running into an issue that I don't understand the solution to.Using the geometries attached here, I can not clip the geometries using a tolerance of 0.001 .It does not give an error, it just gets stuck.If I dissolve the clippers before clipping, it does work. So I'm guessing there's something 'wrong' with the geometries (there is a strange pointy shape in the polygon) and the chosen tolerance, but I don't know why it gets stuck. I'm guessing the pointy-bit is too small and falls under the tolerance? I'm using fme 2022.1.2. Workspace attached and data attached.

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 popu

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