General

Hi FME'ers,For a little challenge this week, I thought I'd point you to the quiz that appears at the back of the FME training manuals. It's not an exam or anything, just fun FME-related trivia.The quiz questions are simple ones like "name a format whose name has a space-related theme"; to which you could answer PlaNet, Sun Raster, STAR-APIC, or maybe even Danish UFO!The twist is... your score is the number of times that answer appeared in our FME usage statistics, and the lowest score wins! So your answer should not just be correct, it should be the format or transformer you think was used the fewest times in 2015.Each answer scores between 0 and 100 points. There are four questions so the best possible total score is 0 (zero) and the worst possible score is 400. If you get zero - without cheating - then you are the most awesome FME'er ever (and you should check out our careers page!)Post your scores below (and your answers if you like) and good luck! PS: If t

Hi,we are installing a new FME-Server on a new server.We was allowed to use the drives C: and D: at our old Server. On our PC's we're allowed to use D:, F:, I: and so on. So I use the folder D:\\Anwendungen for my Config-Files and those files, where a couple of workbenches can read results or write results.Unfortunally we are allowed to use drives C: and E: for reading and writing at new Server. I thought about to use the shared directories of the FME-Server, but how can I use these folders with FME-Desktop on my PC ?Thanks for IdeasBarbara

I want to .CSV data into Smallword by using FME. In my CSV file ï have coordinates "x y". I want to combine these two coordinates into single point.-->"x,y".CSV formate Data:IN FME Workbench:I want to combine X and Y values into single Attribute.Actually i tried by using "CoordinateConcatenator"  But i am unable to combine the X and Y values.

Hi,I am having an odd and seemingly random problem: I have downloaded a Workspace Runner example (WorkspaceRunnerExample - posted by @takashi in 2013) but, after unzipping, when I browse (from Workbench) to find the .fmw files that were downloaded, the .fmw files do not appear. In fact, when browsing form Workspace, I don't see the WorkspaceRunnerExample folder at all. I have actually had this problem previously, also with files downloaded from this site.Can anyone help me troubleshoot this - I am at a complete loss! I am using FME Desktop 2014 sp4.Thank you,katie

Hi!I have a DWG-File with an area-layer, containing geometries and i want to seperate triangular areas (see Screenshot). All geometries in the Screenshot are in the same layer. I tried to extract the triangular areas, but didn't find a way that works.Facts: - the triangles are not identical and have different areas (calculated by ExpressionCalculator) and different number of vertices (count by ExpressionEvaluator) - all triangles have more than 3 verticesSo, I can't select these geometries with a Tester by area or number of Vertices...Is there a way to calculate the angle of geometries or a another way to seperate these triangular areas? Thanks for help!Juli

The log entry is "FACTORY_NAME Router and Unexpected Input Remover COMMAND_PARM_EVALUATION SINGLE_PASS MULTI_READER_KEYWORD SDE30_1 ..." Which looks like a call to the reader but I have no idea why the parameters generated by the task scheduler would be different than those built by the workbench

Hi everyone,I want to start an FME process within another (using the "workspace runner"), but not before the writer of the first process is done. I have tried to trigger the second process with the "creator" transformer and the switch "Create At End: yes", but the second process still starts to early. Does anybody has a solution for this?Best regards, Ron

I have downloaded Ordnance Survey Integrated Transport Network , and want to create a Junction Datasets from the information if possible

I need to read stored procedure from SQL instead of each table. Please assist. Thanks.

Fill in the details...

hi I am trying to compare two datasets by calculating the CRC value for (building number , streetname , suburb name) for each of the datasets and running through the feature merger (unreferenced port) to pick up new updates . This has picked up quite a few records that already exist . the building number could be like 37-39 or 25A etc . Can the CRC calculator handle this ?

I have about 15 FME 2014 scripts, that I want to convert to 2016, obviously this is a huge jump, any obvious examples for making this update much easier?thanks,

FME used to have the ability for the user to add transformers to the toolbar. I found this quite useful because I can just click on the icon for AttributeCreator and not have to type it. Is this functionality in 2016? I don't see it.Thanks

Hi FME Users,I have a GDB file. There is a line feature class which have line+arc+line. When we select it selects as 1 feature (just like polyline in autocad). I want to divide as line,arc,line.Any suggestions...Thank youPratap

I'm reading from a dataset that represents boolean values as a "-1" for true and a "0" as false. I'm attempting to write these values into a dataset that represents booleans as a "Y" for true and a "N" for false. I can make the "-1" -> "Y", "0" -> "N" conversion by using the AttributeValueMapper transformer, but that only works for one attribute at a time. The source dataset has about 20 boolean fields, so creating a transformer for each of those would be a time consuming and tedious process. I was wondering if there was some transformer I could use to map all these boolean values at once, or if there was a whole different approach I could take.

Hey guys,  I have one quick question: If you have a polygon with attribute value 0 and its surrounded by polygons with a different value. Is there a way of assign the value of the surrounding polygons to the 0 valued polygon?To elaborate. Im working with postal code areas and sometimes there is an empty polygon surrounded by polygons with one postal code (for ex. 1234AB). Is there a plug in which can assign the postal code of the surrounding areas to the empty attribute?regards,  Bart

For a project I'm working on I work with postal code areas. I still have a few unresolved problems which I would like to ask.  If you have a poly_point dataset. Is it possible to filter out points which have the exact coordinates? For example, if there's a tall building with multiple levels. Is it possible to filter multiple points which lay on the exact same spot in a way that you keep one point?If you have an attribute which contains text attributes in the form of 1234AB (so 4 digits and 2 letters). Is it possible to create a new attribute which only contains the first 4 or 5 digits?And finally: I use the centrelinereplacer (straightskelleton) to make smaller polygons, but when I combine 2 datasets and then run the centrelinereplacer, it doesn't work anymore. Is this a familiar problem, is there a resolution?regards,  Bart

Hi,I export from Oracle (Spatial) to SDF. No tables are created in the SDF file if the table/view in Oracle doesn't contain data. The target application which consumes the SDF files expects a certain table structure - even if tables are empty. Can I force the creation of emtpy tables in writer?Creating a dummy data set in Oracle is not an Option.Many thanks, Rob

Does anyone have any experience of transforming and loading data from Microsoft AutoRoute? I know the product has been discontinued but still have a requirement to extract information. Any ideas gratefully received...

I have a road map (grey shapes) and i want to make axis from it. I use the centerlinereplaces (red lines) but i must connect the centerline to the other centerline. (blue line)   

Hi, Since, I work with spatial data and more into ESRI formats, so I come along with different problems with the same format type, and again, I am stuck with a new problem here. Though, its a bit difficult to explain, yet, let me try: I have a Road Network with Polyline geometry. Each Road Network Element (line segment) has a start and an end node. If we split the line at junctions/intersections and add a point to each start an end node to each Line Segment, there will be a certain number of overlapping nodes (image below). My question is will I be able to extract the count of nodes at every junction? Pl feel free to ask queries if I am not able to communicate properly. 

Have I missed a transformer to convert to/from for instance RGB 20,255,40 to fme_color? 

I'm upgrading to FME 2015.1 from FME 2013 sp1.   We have Desktop only, not server. ESRI Edition if that matters.   I'm wondering if I should be recreating my translation mapping files or if I can just copy them and adjust if necessary.   I read from ESRI data sources with ArcSDE 3.0 Reader/Writer and I think there is one that uses the ESRI Geodatabase Reader/Writer. Other sources are SQL Server non-spatial databases.  I use FeatureMergers, Joiners, AttributeRenamers, Testers, Reprojector, Coordinate Fetcher, AttributeTrimmer, StringFormatter, 2DPointReplacer, StringConcatenator, ListExploder, UUIDGenerator, Sorter, and a TimeStamper.  Mostly attribute manipulation and doing inserts and updates on the target data (strictly ArcSDE data).  I use the fme_db_operation parameter in order to specify doing an insert or update.  Any tips, tricks, gotchas, or other recommendations for me with regards to "converting" these files to FME 2015?  Thanks, Sarah

Hi We have some java code that used FME Objects 2013 and we upgraded it to 2015. Some of our tests started to fail. When I investigated I found that in the log it says  WARN |MS SQL Server (Spatial) Writer: The fme_db_operation attribute value 'DELETE' on feature conflicts with Feature Operation 'Insert'. Rejecting feature  In documentation there is a description of Feature Operation parameter but I tried to specify it in various ways and it still didn't work. For example:  IFMEStringArray params = fmeSession.createStringArray(); IFMEStringArray directives = fmeSession.createStringArray(); params.append("Feature Operation"); // tried FEATURE_OPERATION etc. params.append("fme_db_operation"); IFMEUniversalWriter fmeWriter = fmeSession .createWriter("MSSQL_SPATIAL", directives); fmeWriter.open("fme_datastore_test", params); ... fmeFeature.setStringAttribute("fme_db_operation", "DELETE"); fm

Hi,  I was wondering if there is a way to set up some kind of progress bar in my application which calls fmw file? Does FME know even approximately how much time he needs to finish? Can I use some other information to get estimated remaining time?  Thanks!