Transformers

I am reading table name and attribute values from text file. I do not have column names but only table name and values in the list.I would like to insert the values into SQL Server table. How do I map list to destination table schema. The order of column values match with table structure. Following is the example of text file row.I~6000000~PDEN ~A058951~PI~PI~DEHYDRATOR~~261384~~~B&C; COMPRESSOR STATION~802103~~~~~~~~~~~~A~~A~USA~17~027~~61~022033~~~~~~20171001~~~~~~~~N~~~~CONGRESS_PRD~~3~~~~~~~~~~~~~~~~G~LA~~L~~~~~~~~~~~~~~~~~~~~'I' is the transaction type.6000000 is table idPDEN is the table name.Rest of them are Attribute Values.Text file can contain values for multiple tables and it can have update or deletes also.For now I am trying to find a solution for inserts.Please let me know your thoughts.

Hello, JSON-lovers!We've been trying to extract the attributes from this response body but however we do it seems like we need to input the attributes we need manually. This can't be true. We would like to get all the attributes no matter what. We're no JSON-specialist as you can probably guess... Is there an easy way to do this?Response body:[{"ObjectId":507,"ComponentId":3,"Metadata":{"KomponentNamn":"AB+56232=270XO001","Lansbokstav":"AB","Objekt":"56","ObjektId":507,"KomponentId":3,"Area":"2","Placering":"32","System":"27","Underniv":"0","Beteckning":"XO","Nr":"001","Underlitt":"","Beskrivning":"Övrigt konstruktionselement, Polygonpunkt","Entreprenor":"","Le

Hello All I'm new to FME but i think it's a great tool to helpanyway i have this problem that i hope that somebody can help me to solve it I have a TXT file , most of the sentence are not with dot at the end.I need to add a dot at the end of every sentence and then save the TXT file back again with the same encoding settings ( I want to make this thing to go automatically)any help guys thanks

Hi,Is it possible to copy the conditional values from one attributemanger to another? Thx!

I have some point objects that need to be rotated. The source data has a starting position and contains a offset in metres from the origin. This would give me two points and from there I could draw a line between the two and finaly measure the angle of this line using AzimutCalculator. Ergo my rotation value.I need some advice on the best way to construct the line. So far I have tried combinations of the Offseter, VertexCreator and LineBuilder to construct the new point but I have not found a way to pair this with the source object. The features all come with an unique ID, but I have not figured out how to pair the original back to the offset point before drawing the connecting line. Below is an early embryo just to give an example of what I am trying to do.

I can do it in QGIS simply by using "name" LIKE '%LDN%' to sort the data, but this is not working for me in FME using the Attribute filter and text editor. Forgive me if I have got it wrong, this is my first go at using FME.

Hello,I have a network of (+) intersecting lines (There is no (T) intersections). I have also nodes of these + intersections also extracted.I want that whenever there is an intersection, the shortest line to be splitted to 2 lines but the long ones remains as it isCan anyone help me with this ?Thank you very much

Just for fun :-) Try this workspace. Assuming that different two versions (latest one and previous one) of FME have been installed in your machine. (FME 2018.0.0.3)Published ParametersNew Transformers: "<NEWER_FME_HOME>/transformers/fmesuite.fmx" of the newer FMEPrevious Transformers: "<OLDER_FME_HOME>/transformers/fmesuite.fmx" of the older FMEDestination Microsoft Excel File: Excel file which will store list of transformers - Added, Upgraded, Unchanged and Deprecated.In fact, I wanted to know what transformers have to be newly localized in FME localization job for the latest version of FME.

Hi all!I'm trying to do a simple reprojection from ESPG:3021 to ESPG:3006 but there seems to be some kind of problem. The transformer(?) are "flattening" the polygons (zipcode areas) in the north-eastern part of Sweden. Why? And what can I do to solve or work around this?Thank you!:nicklas

I have a workspace producing various outputs, I'd like to produce a further output which details the number of distinct customers and number of distinct products for each output but this appears to be either convoluted involving multiple steps and statistics calculators or slow involving a count distinct in the inlinequerier. Wondering if I'm missing a trick

I have a reader (file geodatabase) that contains about 900 polygons and want to use each feature independently as a clipper in a Clipper transformer, since I want to clip a few rasters based on that clipper. The result should be connected to that input somehow.

I was wondering if anyone has any ideas on how I would approach the below problem.I have a road network where there are short single carriageway centerlines of short distances between dual carriageways. I want to identify where there is a break between dual carriageways that is less than x meters. The image below shows a simple example and it is the geometry highlighted in red which I want to identify.

Hello,How can I copy content of the table?     For instance, my table looks like this: Out of above table I would like to create below table:

Using FME Version: FME(R) 2017.1.1.0 (20170929 - Build 17650 - WIN32)Getting this error in the FME log: |ERROR |BADNEWS: Features of the same type must all use the same coordinate system, given 'EPSG:26782' and 'EPSG:32002' (schemscn.cpp:2014)Each feature has it's own destination coordinate system attribute. Using the Reporjector transformer, I specify the destination coordinate attribute to reproject the feature into a local UTM coordinate system so I can then use the snipper to get an accurate measurement. I get the error above, however, It doesn't stop the workbench from working. I'm afraid it's not reprojecting the geometry correctly. According to the reprojecter documentation each feature is allowed to be reprojected independently. Is this truly an error and if so what do I need to d

I have a workbench that has to process about 600,000 lines and apply updates to a master dataset (.gdb). The attached workbench is a very small sample of what has to be completed. The main issue I am running into is the update detector is extremely slow. A sample run of about 1000 lines took just over 2 hours. So any suggestions of things I can do to speed it up would be much appreciated. I have also found that when I try to run the whole the workbench with the complete dataset the FeatureMerger rejects the suppliers with the rejection code EXTRA_REFERENCEE_FEATURE. This only seems to occur when the number of suppliers gets quite large. I have seen this same rejection code mentioned in reference to duplicates but I don't have any duplicates in the complete supplier dataset. Any help on either issues would be much appreciated.Sample of bench Pic of whole bench

I'm using RasterTiler to create tiles from a larger raster. However, I noticed many resulting tiles contains only nodata values. How can I avoid writing out these tiles.

Hello,I have a map of questionable quality and I'd like to use the geometry validator. Since there is actually clear warning that this transformer is intended for experienced users, is there a guide of some kind I could refer to?I did see the help section, but I am looking at some simple how to start ... what are the best ways to set up the transformer, if you have no idea what you are doing etc. Few hints really.I have attached sample of the file.Thank you

I am experiencing the following problem in reading data from a SmallWorld Bank from the FME.The coordinates are being read with an extra digit in the integers. the correct reading of the coordinates should be X = 3299524,29749 and Y = 74029835,74061 However, you are reading X = 32995242,9749 and Y = 740298357,4061 On the X-axis, the FME reads 7 integers (32995242) but actually should be 6 integers (3299524). The same is true for the Y-axis, where the FME reads 8 integers (740298357) but should actually read 7 integers (74029835). When you view the data directly on the SmallWorld Bank interface without using FME, the coordinates appear correctly. This erroneous reading of the coordinates occurs only when we read the data by the FME.How can I fix this?Thank´s

I've searched for a solution to this but none of the other posts seem to provide the minor detail I'm missing.My goal: I need to find the distance "as the crow flies" between street intersection points (point geometry features). What I have: Street Intersection points feature set with a unique ID field populated for each point.   What I've done: [1a] NeighborFinder (Street Intersection points as both the Base & Candidate inputs) [1b] Vertex Creator using the Nearest neighbor output ( Mode= Add Point ; _closest_candidate_x & _closest_candidate_y)   [2] LineBuilder (inputs are the original Street Intersection points and the Vertex Creators output points) grouping on the unique ID field. However this process does not output any lines. What am I missing?

New to the forum and FME really... I did some searching around on here and couldn't find what I was looking for...I have blockgroup level statistics and want to be able to perform proportional spatial overlay calculations to calculate polygon level statistics for custom polygons (radius, drivetime, etc.). The approach I am using, conceptually is.... Join the blockgroup boundaries to the blockgroup tabular dataUse AreaCalculator to generate the area of each BGUse AreaCalculator to generate the area of the custom polygonUse AreaOnAreaOverlayer to bring them togetherThat is where I get lost...Ideally I would end up with a list of all the BGs that are within the polygon along with their percent intersect. From there I can apply the proportion to the BG statisticDoes anyone have an example workflow that I could follow along with? I am used to using Alteryx for this kind of spatial work and haven't done anything this a

Hi.I have a database of roughly a million polygons and I have another dataset of 50 polygons which represent areas of interest. Some of these areas of interest overlap.I would like to select every feature from the large database that overlaps an area of interest polygon and write these to 50 individual datasets. I tried to set up a loop using a spatial filter. Some screenshots are belowOverlapping areas of interestMain workbenchCustom transformerI should let you know I haven't worked with loops before in FME before. I was hoping the first area of interest polygon would enter the filter then the large databas

Simplified story: One engine can only use one specific python version. So if you have 2 workspaces running - with different versions of python, they will fail giving this error:The Workspace requires Python version 3.6, but Python version 2.7 is already loaded Workspace requiring Python 3.6 is requested to run on an FME Engine configured to use a Python 2.7 interpreter. FME cannot continue given the Python version mismatchA fatal error has occurred. Check the logfile above for detailsGUI-suggestion on FME Server:Which will result in a warning when publishing workspaces to that server: 

Hello all. I am relatively new to FME. I’ve completed the basic and advanced FME tutorials, but that is where my experience ends. I’ve been struggling with a particular problem for some time now. I’m not sure if FME is the solution or not, but I really enjoy working with FME, so I’m hoping it is. I am a GIS Analyst and I am hoping to not have to fall back on geoprocessing to complete the task. I work for a County Assessor’s office and I’m trying to solve a problem.Our parcel numbers consist of a book number(!), page number and item number (e.g. 999-99-999, respectively). We have polygon boundaries that represent book numbers that were created by a mixture of parcel book numbers, PLSS boundaries and roads. They were created a long time ago and are not to be changed, as much as possible.Parcels are changing continuously throughout the year. For simplicities sake, I have parcels with book numbers A and B. I also have book boundary numbers A and B. When I

I have a set of (thousands) 3D models in KML/Collada file. These represent a geospatial area. I want to mass convert these into a set of OBJ files. This in itself is quite easy, thanks to the KML reader and the OBJ writer.But now I need a way to split the big OBJ into smaller obj files, based on the spatial properties of the files.I tried using the Tiler, but this doesn't seem to work for 3D objects. (Shame cause it felt like this is exactly what I would need)I also tried using the Grouper in combination with the AttributeRangeFilter, but this would just amount to me having to create hundreds of OBJ writers to match the _group_index attribute written by the grouper. Which kind of defeats the purpose of trying to automate it.So is there a way to output multiple Wavefront OBJ files instead of just one? And if so, how?

I’m looking to calculate the total hours of water consumption based on records ON/OFF from a GIS feature class. Each feature can be ON and OFF several times along the month. What transformer can I use to calculate the total number of hours it has been ON.