General

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 2

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(&quot

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!

I have raster grid from which I want to extract contours. I know polyline contours are fairly easy to extract but what I need is the polygon contours.  Is there any way in FME to extract polygon contours out of raster grid?   Using Professional Edition 64/32 on Windows 7 64bit  

Hi, Seems like a simple thing but unable to get the desired output as yet. There are small segments of roads which have names. Need to join them between intersections and derive another field which would concatenate the Names of the all the small road segments which forms the joined Line. LineJoiner is being used to join, but how to fetch the attributes as a list (or concatenated field) between intersections? SpatialRelator, is not giving the desired result. Thanks in advance, Sani.

Hi,  Is there a way to see which writer stores the most data to disk because he needs to wait it's turn for writing? I suppose which writer is that, but I wolud like to check it.  Thanks!

Suppose I have some census data concerning primary language spoken at home. There would be many fields here but for the sake of simplicity, let's suppose there are only five: Cantonese, Chinese, Mandarin, Tagalog, and Tamil. Each would contain the number of households within a census unit where each language is spoken e.g. 30 for Cantonese, 150 for Chinese, 70 for Mandarin, 85 for Tagalog, and 2 for Tamil i.e. Chinese is the most common language spoken at home within this unit followed by Tagalog, Mandarin, Cantonese, and finally Tamil.  Now suppose I want to create three new fields which indicate the first, second, and third most common language spoken at home. Let's call these fields Top1, Top2, and Top3. In the example above the Top1 field value would be set to "Chinese", the Top2 field value would be set to "Tagalog", and the Top3 field value would be set to "Mandarin". In other words, I want to populate the Top1, Top2, and Top3 f

Hi to everyone,  I am facing a problem with some sets of fiber and coaxial data that are stored in "Bentley Fiber V8i" product. I need to export this information to Smallworld PNI database. I am not sure if this product is supported by FME Desktop, indeed it doesn´t appear in the list of recognized formats.  But, since "Bentley Fiber V8i" product uses an Oracle database, it is possible to export data to DGN, and Microstation is fully supported, i ask myself if it could be possible to set up somehow the source enviroment in order to extract data from Bentley product using FME Desktop.  Had anyone the chance to work succesfully with Bentley "FIber V8i" and FME Desktop products? Do you think this task could have an easy solution? If I cannot read data from the first one using FME Desktop, I do not know how I could get the data features i need to load in Smallworld.  Thanks for you time and help!

Hi, I want to read from an Oracle-Database and some Shape-Files (same schema), doing an reprojection and then write to SQLite (dynamic writer). Just before the writer the features are okay, but in the destination file an attribute (ORIENTATION) now has a value of 9999999999999999600000000000000.0 which was originally 100.0. The reprojection does not take effect on this (when removing it, it still resets the value). Does anybody hav a hint on this?  Thanks in advance!