Using transformers to modify data.
Recently active
I have FileGeoDataBase (FGDB) polygons. It's easy to convert them to DWG lines. BUT: I want want to take one polygon attribute and turn it into DWG text. Here is the workbench: FGDB polygon reader -> LabelPointReplacer -> DWG writer. At every insertion point in the DWG file there are now two text pieces: one at the correct scale, another 180 degrees rotated (upside down), huge (humongous), why?
Is there a way to actively monitor FME Cloud data transfer amounts? The dashboard allows transfer rates (Kb/sec) to be viewed but not amounts. Can a report be run to show data transfer amounts broken down into hourly, daily or other intervals?As data transfer and storage is billed as an additional cost to the per hour usage amount, it would be nice to be able to track this.
Hi,We've just recently begun to adopt the MBTiles format for offline map viewing.What I expect is a TMS setup, with every tile level at its optimal resolution, i.e. w/o undue pixellation.I've made some test, but it seems that the MBTiler writer only accepts a raster image, i.e. an already fixed resolution. This results in a pixellated lowest (or highest?) level.How do I create an MBTiles dataset from my vector map data, with full resolution on all levels ?The WebMapTiler also expects raster input, so that's not immidiatedly an option.Any insights are appriciated. Using 2018.1.Cheers
I am sure this is a simple fix for this, but I've been testing this for hours now and going nowhere!In AttributeValidator, I want to FAIL an attribute which contains a certain string. The most logical thing I could think of is to use the Contains Regex validation rule. Let's say I want to 'Fail' every attribute where it contains a string which = FME. I have trawled the internet and got the following expression to work within the Regex Editor:\\b(?!FME)\\b\\S+However, when it runs in the AttributeValidator, attributes which i have engineered to contain FME, appears from the Passed output port.1. Is there a much simpler way within the AttributeValidator to fail any attribute which contains a certain string, rather than regex?2. If not, am I doing something fundamentally wrong with the Regex or validation rule?Thanks
I can get the XY coordinates for a leader line from a Line Callout annotation using the anchor point and the WKT string. But the WKT text string is empty for a leader line of a Simple Line Callout features. Similarly, the "geodb_text_lc_textbox_x1" values are not available. So, how can I get at the XY coordinate values of the leader line?Thanks,Gido
HelloI am trying to clean up some GPS line work before it is loaded into our database. THe lines need to be free of self intersections. I have come close to accomplishing this by buffering the line and then using the centreline replacer to create a smoothed line. The problem is that the centreline replacer is creating short dangles along the length of the line. The actual centreline it is creating is good enough for my purposes I just need to remove the dangles. If anyone has any ideas on how to do this it would be much appreciated.In this screen shot the Green line is the original line with self intersections and the red line is the result of the centreline replacer.
FME 2018 doesn't seem to include the pluginbuilder files for c++. Does anyone know where to get these from?
Hi all,For some reason an application is storing a date/time field as 'Double' - ''201805241214'' in this format, but the Date converter function does not recognise this as its a double field type, any help is greatly appreciated,
Hi everyone,Is it possible to specify the max number of features to be read when using the Data Inspector directly? Currently I use the Workbench to add a reader and then view the selected number of rows by connecting an Inspector.
I have a problem to calculate the heading of 2 points in a line in my template. In the 2 pictures you can see the template itself there i tried to take the start y-value.I used atan2 and also just a simple number. I tried with just 2 and 1 and i get a solution, but not if i use the attribute with "{geom:get-start-y()}".Hope i get some help.
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.