Transformers

I am trying to establish a connection to a MS SQL Server through FME Workbench installed on a Unix and/or Linux box - that uses Microsoft AD credentials. I have downloaded and placed the lastest MS SQL Server JDBC from https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-2017#available-downloads-of-jdbc-driver-for-sql-serverAnd I placed the driver v10 jar in the /User/<user>/Library/Application Supper/FME/Plugins/Java directory. As suggested in the "Getting Started with JDBC" article. https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/jdbc/getting_started_jdbc.htmWhen I create a new Database Connection within FME Workbench using the JDBC driver. But when I click "Test" I keep getting an error either that my user login did not authenticate or that is could not pull back the database schema. Not sure if I have setup everything right for FME Workbench to use the MS JDBC driver correctly. I also see a

So this is a problem that keeps coming up...we need to report text differences between two versions of reports. I can access the before and after fields and read them into FME, but I am searching for ways to analyze the strings and report the differences (additions and deletions).The ultimate goal is to format a report with additions (green) and deletions (red) clearly marked. As a start though, I have to find some method to analyze the two strings and perhaps break things down enough to be able to re-assemble a properly formatted string, perhaps with HTML. Nothing is jumping out right now as a simple answer, so I suspect it is not as easy :)I have looked into the custom workspaces "FuzzyStringComparer" and "FuzzyStringCompareFrom2Datasets", but I don't think they will help me much with the above. I thought about a process of chopping a string into individual words and do some repetitive looping using Regular Expressions to determine which chunks existed before

hello. FME tells me that the Command-line to run this workspace isfme.exe abc.fmw --SourceDataset_DGNV8 "abc.dgn" ^--SourceDataset_LAS """"""10.las"" ""11.las"" ""12.las"""""" When executing in dos window only the first las file is processed.any help would be greatly appreciated.

Hallo guys!I have a good question about the if statement (pls look on the pictures). I wanna check if the line is the first one (with Count) then i set my s1=0, after that i want that the next s-value is s2=lenght(first line) and on the next line i need s3= length(first line)+lenght(second line). Its just a straight road so i just have straight lines. I have now the question how can i get the lenght from the last object to fill up the s-value from the next one? My next question is if i try the "if Statement" it include the word "xmlns" into the file and i have no idea why. I hope anyone have a answer for me. Thanks !

I have one line that express one bus route and would find the bus station within 375 meters. There is other transformer besides NeighborFinder should I use?

I have a set of touching polygons representing physical spaces and lines representing the doors on the polygon boundaries dividing the spaces. I want to dissolve only the polygons that aren't separated by a door. Not sure how to group the corresponding shapes. The doors are only a small segment of the boundary.

Is there a way to create a transposed table in the MSWordStyler? I'd like to have attribute names in column 1 vs. attribute values in column 2 like this:So far I only managed to create a table like this:The horizontal presentation isn't really useful for Word documents, especially when listing lots of attribute values.I've tried creating several individual tables that I concatenate when writing but there will always be a line break between them. I've also had a look at the msword_table_col_header{0} and msword_table_col_value{0} format attributes but it looks like they don't allow for more than one row either.Is there a solution?

Hi,I am trying to overlay 7118 points on 3 lines using the PointOnLineOverlayer transformer.Every time I run the the workbench, it crashes with a FME EXE has stopped working error message at the point in the log where it says: "Creating spatial index of 1787 point featuresCompleted spatial index creation".I have tried the workbench in both FME 2016 and FME 2017.0 Desktop versions, and I get the same issue.Anyone know what could be causing this?Thanks,

Hello. Looking for some suggestions on how to fix geometries. These unnecessary vertices are the result of import from MicroStation cadastral based DGN files. The unwanted vertices are on a cadastral grid line.First case, lines with extra vertex that should be removed:Second case:2 line segments that should be merged, assuming they are colinear. Would need a test for that, right? In the screenshot below, the short segment south of the green highlighted segment should be merged with the green highlighted segment and defined by 2 points (again, assuming they are colinear).Third case: polygons with extra vertices like in the line segments. Pt 4 (and others at cadastral grid lines) should be remove (assuming colinear segments):There are ~25000 lines affected and and similar number of various polygon features.Thank you for any direction!!

Hello all,I am trying to add one UUID for each CAD file entering the workbench. Is there a way to set a parameter so when a new filename enters the workbench, each feature with the same filename receives the same UUID character? I have tried using a the filenameextractor followed by the attributecreator and using the @uuid() function as the new attribute value. But that just gives each feature a different UUID instead of the same. Any assistance would be appreciated.Thanks,David

Hi,I think FME does not treat some arc during transformation.I have a polygon in a dwg containing a long arc:What i see in acad:What i see in FME Data inspector: the main problem is that some function like spatial relator (IE: "Requestor is within supplier") don't see the circle in the polygon.In acad, all my circle are inside other polygon, here is what spatial relator see, the highlighted circles are misinterpreted.If i use a dwg writer to ouput data, the arc seems correct in acadIf i use a shape writer to ouput date, the arc is like the one in FME data inspector.I attached the minimal workbench and dwg to this post.Any hint?David

I want to run the workspace by command line. But my workspace don´t have source dataset and output dataset. I´m using just creator and HttpCaller for download the zip file.I haven´t experience to run workspace by command line. I was created the batch file like this:fme.exe C:\\Users\\FME\\Desktop\\Workspace\\download.fmw LOG_FILENAME c:\\fme.log But nothing happens..:(

Hello,I want to to use the NetworkTopologyBuildrer. However, this transformer requires that the network must be topologically noded. How can this be achieved in FME ? Thank you very much

Table of attributes I want to merge with Group By: FILENAMEInputAggregatorOutputDesire

Is it possible to alter a workspace's output before it is zipped and made available for download through the data download service? Specifically, I'd like to output a shapefile, then alter the .prj file using a python shutdown script. All of this before being made available to the user as a zipped download.

Hello. I have face type geometry planes in 3D space. I would like to split them at intersections. It's trivial task in 3D modeling software like SketchUp, but I'm not able to do this in FME. I can't find solution in existing forum posts or other online resources. Any help would be appreciated :)

I am trying to create a Private Parameter Value from an Attribute Value. What I Have is a SQLCreator that is pulling two columns from a table. ROUTE_ID SYSTEM_CODEThe SQLCreator is using a Published Parameter to query out the data associated the user defined SYSTEM_CODE. What I want to do is assign a Private parameter from that result as the ROUTE_ID value. This would allow me to run other queries based on the Route_ID which is a unique number.

Hello,Here is my issue : I have a feature containing buildings, with a height value. By merging the buildings and extracting holes, I get another feature which represents inner courtyards. Courtyards have a unique ID. I want to get the minimum height of buildings touching each courtyard. I tried to use a SpatialRelator combined with a StatisticsCalculator (grouping by courtyard ID) :(not the real workbench, which is quite a mess, but this is close enough)  But I get an issue : the SpatialRelator only seems to compute an output for one building and one courtyard. So when a buildling touches several courtyards, it is only used once to determine minimum heights. Here is an exemple, height are displayed on buildings, and computed min height on courtyards :As you can see, the building north-west to the wrong courtyard min value is not taken into account, as it migth be used for the elongated courtyard which also is adjacent to the building. Am I being clear enough ? And do you think of any

I have a dataset of bridges and I have a road network. I want to create reroutes for each bridge. So I want to clip the bridge part out of the roads to use the shortestPathfinder to get the new route . But I want to send the bridges one by one to this process. I got the workspace working as I want as long as I use just one feature but I need the to do the calculations on all the bridges, but one at a time. I´m really stuck on this one...

Hello,  guess this question has been asked here many times, however I still struggle with finding a good answer.     Basically what is happening: this is a table that shows records all possible values of all possible attributes, from all possible objects. However I need to create a table, where column names will be values from the column 'attribute', where each row will be singular object. Real table has much more columns, this is just an extract.  Resulting table should have one row per 'object_id', attributes created from 'attribute' column and the attributes created should be filled with values from 'value' column. There are going to be a lot of attributes created, not each of those objects has all of those attributes.  Any help is really appreciated.  Radek

I´m using this comand: cd / "C:\\Program Files (x86)\\WinRAR\\Rar.exe" x-y "@Value(_response_file_path)"The file is downloaded correctly but the unzip process don´t work properly.Thank´s

Hi,   I'm trying the FME Trial to convert a JSON file to an ESRI Shapefile, but I'm having issues with the conversion.The JSON file contains 354 polygons, and each polygon has a list of information (features?).How to configure the Readers and Writers to perform this task well? Thanks a lot!

I have a set of points that have no order of collection and I need to connect them together to form a polyline. I have been working with the neighbor finder transformer, but having some issues coming up with the best way to have them drawn correctly. I'm thinking I might need to designate a start point and then remove each point from a list that was previously used to connect?   What I would like to achieve is one polyline connected from PT4 - PT1 - PT3 - PT2. Any ideas on a good way to achieve this result? The example below is just a sample, as the full job would contain hundreds of points that need connecting and are all out of order, so I can't use the line builder.

Is there something wrong with the Inspector? Here is the layer(s): http://cmnmaps.ca/mapguide/mapagent/mapagent.fcgi?REQUEST=GETCAPABILITIES&SERVICE;=WMS&VERSION;=1.3.0& The BC Mines Layer works with Gaia but the others don't for some reason. I am using FME desktop 2018 thanks

I use FeatureMerger with Requestor and Supplier having 1:m relationship. The FeatureMerger gives me "merged" features with an attribute, which is a list of values fromthe matched supplier. How to check a list of values for an attribute before moving to next feature?I don't want to use ListExploder afterwards.