Transformers

I have a floating point number (i.e. 41165.2823011227) that I need to convert to year, month, day, hour, minute, second.  All I've been told is that the floating point number is the number of days since January 1st, 1900.  After a little bit of research, it looks like you can convert these in Excel (make sure you have 'Use 1904 date system' unchecked under Advanced Options).  When I enter the floating point number and format the cell to Date, I get 9/13/2012  6:46:31 AM which looks correct.  Is there a way in FME to accomplish this same conversion?  More info on the 1900 Date System here: http://support.microsoft.com/kb/180162

Hello, I have a db table with a field called CSTSTARTDATEDA. In the db table, an example of a value is '8/16/1999'. In FME, I am using a SQL Server reader to pull all the data in the table, and FME is showing the date as 19990815000000.000.  I need to convert the date to milliseconds format (a requirement for a data migration project). If I were doing this in SQL, I would convert the date to a BigInt, then subtract 25568 and multiply by 86400000. This would give me 934848000000 ((Convert(BigInt,[CSTSTARTDATEDA])-25568)*86400000). I tried to do this in my SQL statement in FME, but FME would not accept it.  Is there another way to do this? I'm open to using a Python caller, but I'm not too familiar with Python.  And the final result has to be in this format. There is no way around it.  Thanks for any help/ideas!  Erin  

(i need to choose one dataset from many dataset in geodatabse)

Hi,Which combination of FME transformers would I need to use for splitting an irregular polygon into convex partitions (and possibly also minimizing the number of resulting parts). The following figure illustrates what I am trying to obtain:I have come up with an approach based on the Triangulator which can be described as follows:Sorting all interior lines from the triangulation by decreasing lengthConsider the first occurrenceIdentify the 2 adjacent polygonsDissolve those 2 polygonsCheck convexity of resultIf convex, keep resultIf concave, discard resultThe process should for instance escape the loop when all interior lines have been consideredI created an FME workspace which does this.The initial figure:would become like this after triangulation:And ultimately the end result would be the following where all parts are convex:However the iterations are hard-coded for the moment because the custom transformer I tried to create contains blocking transformers and multiple loops which are

I’m fairly new to FME and need help to get started on a workbench. I have a text file i need to convert into a readable format. Each line has information about a specific device and should be parsed into separate columns. The blank spaces also need to be removed. What transformer should I use? Any help is appreciated!

Hi fellow experts and users,I apologize if this has been asked already but I have not been able to find the topic.I have only been using FME for a month and struggling to figure out how to manipulate data within FME. I've watched and followed exercises about using FME to reading in map data but it is confusing and overwhelming at the same time.Basically I'm trying to convert a PDF representing buildings and runway and convert those points into georeferenced positions. As an input I have a georeferenced shp file containing a runway with the intention of being able to match the runways together and then being able to figure out where the PDF buildings need to be placed.The scale of the PDF runway and the shp runway may not be the same but I was thinking it may be possible to compare each point of the polygon one at a time to figure out the distance and create some kind of scaling. I coloured the runway in the PDF as a purple line so that I have the PDF runway polygon and the s

I have a line that I try to divide in smaller parts of 5 m each. The line is is from a shapefile. When I try to use the chopper it divides the line in random parts, varying in length from 7 to 113 meter, but in not a single case in 5 meter. Am I doing something wrong or is this a bug in the transformer?Hope someone can help.

Hi all,I'm new to FME and am trying to deal with a datset that has duplicates in. However each duplicate contains some information that I need to preserve into new columns. A simplified version is something like this: PropertyIDAddressContact nameContact details00011 High StreetMr Smith0121232800000011 High StreetMr Jones0121232800100022 Low StreetMr Birmingham0121232800200022 Low StreetMr Warwick01212328003 And what I need to end up with is more like this:  PropertyIDAddressContact nameContact detailsContact name 2Contact details 200011 High StreetMr Smith01212328000Mr Jones0121232800100022 Low StreetMr Birmingham01212328002Mr Warwick01212328003 It's been suggested to me to use FeatureMerger after multiple DuplicateFilters, but I can't figure out how to bring each set of filtered duplicates back in to a single dataset whilst preserving the data out of the duplicate entries.Any help, pointers or example workspaces would be greatly appreciated.Cheers, Mark

Hi there,I have a bunch of small polygons that each have an AREA attribute, showing their square footage. These are contained within several much larger polygons.What I need is if Large polygon A contains 3 small polygons, one 100ft, one 50ft, and one 75ft, I want to generate a new attribute in my output that says Large polygon A contains 225ft. The same happens for Large Polygon B, C, so on. My output is essentially the Large polygon layer, but with the additional new attribute.I did try a spatial relator between the small and large polygons, and then a Statistics Calculator outputting SUM and grouping by the unique ID each Large polygon has, but it seems like the output attribute is the first small polygon contained, not all of them together.Any insight in what I can do different here to get the correct results?

I have a few tables that contain point and line features. I can group them but I want to create a boundary polygon for a database so when I need to pull them up I can use the boundary to grab all files. My thoughts were to group the line and points as needed and then run the groups through a MinimumSpanningCircleReplacer. From what I read am I correct in assuming that this tool will do just that and leave me with a polygon at the end that is a outer boundary of the grouped line and point features?

I would like to snap the blue line to the red line. End goal is to merge attributes. I tried using AnchoredSnapper, the problem is that as you can see in some cases especially where the line bends lines can be closer to the 'wrong' red line. Any advice would be greatly appreciated.

Hello:I have an issue that I can't seem to understand. I'm new to JSON (in fact this is the first json output I've ever created). I have a structure that has a ROOT and SUB. The JSONTemplater says my current structure is valid and produces the file. However, when I run it through https://jsonlint.com/ the results are invalid. So, I looked at the output of what another area is expecting and I manually modified the file to see if the updates I made were valid. The short of it is, I need to modify what's in my JSONTemplater to add a comma (,) before each NEW record and add brackets ([ ]) around the entire output file. EVERY attempt I've made in modify the JSONTemplater has failed or I get an error. I'm loosing it! :) I've attached the file I manually revised and the one from the actual results of the workspace. Can someone tell me what's wrong with my JSONTemplater? ROOT Structure:{   "totalInvestment": xs:double(fme:get-attribute("tota

Hi,I'm having problem writing polylines that consists of arcs and lines in AutoCAD. It seems it only happens when using Reprojector or similar. While writing arc part of polyline gets stroked in AutoCAD. Does anyone have any idea what am I missing? Cheers,Želimir

I'm reading a CSV file from the web. The file is served encoded, so I first decode it, ending up with an attribute "_decoded", containing the csv data. I want to use this data to create a table (like the csv reader does), without writing the output to a file first.  Sample format:objid;xcoord;ycoord;name21;123;456;house22;125;458;treeThe solution suggested in the thread linked below doesn't work, throwing the error "Python Exception <Error>: new-line character seen in unquoted field - do you need to open the file in universal-newline mode?", but I can't figure out where to stick the read mode (rU).https://knowledge.safe.com/questions/78520/parse-csv-data-stored-in-database-table.html 

I am working with FME for my thesis project and I am having difficulty trying to find the right transformer to complete a specific task.I am trying to georeference motor vehicle collisions that are located at street midblocks. I have two ESRI shapefiles that contains street intersections for each midblock. I located the intersections using an Address Locator. I am trying to get FME to relate the two shapefiles based on the Accident ID so that FME can create the line segment between them. After I create the line I am going to use the Snapper tool to get the middle of the line segment to get the location. The issue that I am having is finding a tool that will create the lines. I have tried the Line Builder tool and one other that I cannot recall at the moment. If anyone knows a tool that could do this it would be greatly appreciated!

I want to set some system environment variables on my FME Server and I want to do it via a workspace so people aren't attempting to log onto the server machine to do it.I'm using systemCaller and sending this command:setx /m @Value(EVN_NAME) @Value(EVN_VALUE) (the attributes are from a database table)If I'm remoting into the box, I launch the command prompt and runs the command. It's using the fire call account, but the command prompt is being run as administrator.I added the service account that runs FME Server software to the admin group.I can't log onto that box with the service account because it does not have logon privileges so I can't test whether or not that account can even run the command. I know it doesn't run when I run the workspace on FME Server. Error message is: SystemCaller: Failed to Execute `setx /M KMOCShape \\\\hougisproj1\\cmproj\\gis_solutions\\projects\\KMOC\\newfolder'Any ideas what I'm doing wrong? Thanks so much!

Hello I am looking to perform the following operation : - transform the value of my column into a column attribute.  table A ==> table B colA val1 val2 val3 (that's my new columns) val1 val2 val3  How to do it simply? With which transformer ? (actually to my mind I guess it's the opposite of transpose transformer)I know the AttributeCreator but these parameters are static (I dont want to fill all the fields)  thank you

I have read all the SchemaMapper tutorials and implemented what I thought should work for a SchemaMapper and input mapping table, but the feature type in question here is not being mapped at all. I am hopelessly confused, hence the following explanation and question: I have a feature type Safety/Fire (i.e. fme_feature_type = feature_dataset/feature_class) that I want to split into three different feature types based on the value of the Type attribute. The values are FDC, Fire Alarm, and Fire Extinguisher. I also want to put the three new feature types into a different feature dataset, namely Life_Safety. Here is a screenshot of part of the mapping table I am using:  In the SchemaMapper I have set first a Filter Features action with SRC_FIELD = SRC_FIELD_VALUE indicated and with Ignore Blank Attribute Values set. Then I have a Map Feature Types action with SourceFeatureType --> TargetFeatureType indicated. Finally, I have a Map Attributes action with SRC_FIELD --> TargetAttr indic

Hi. I have seen a thread in which they explain that for converting from polygon to multipolygon you only have to choose the geommetry type in the writer parammeters (on FME2019). The thing is that I can't see that option. Is multipolygon not available on FME 2018.1? If not, how can I convert a polygon to a multipolygon? Thanks! 

With the help of the following request url in the Httpcaller, it was possible to get a returned xml output with information about one feature. However instead of retrieving information about one feature, ideally I would like to retrieve metadata of all the items from ArcGIS Online. Does anyone might have an idea how that can be achieved? This url gets me metadata of one feature.https://<companyname>.maps.arcgis.com/sharing/rest/content/items/<Item Id>/info/iteminfo.xml 

Hi Community,   I have an issue using RegEx in the TestFilter. This is what I do:    It never returns any result.  However, when I use the StringSearcher to do the same, The RegEx works well:    Any idea what I'm doing wrong in the TestFilter? According to this article: https://knowledge.safe.com/articles/Error_Unexpected_Behavior/Regular-expressions-that-work-in-one-parameter-fail-in-another, the implementation is indeed different. However, the two websites for testing RegEx mentioned in the article resolve the RegEx well.  How should the 'Right Value' be defined in the TestFilter?   best regards,  Jelle

I want to filter my data to find features where part of an attribute matches a predefined string. How can I do that?

Hi i downloaded FME Trail version and using Workbench. And I am trying to convert WMS "link" to shapefile format.It is reading well but, while writing into shapefile it is throwing error. See the below error information"A fatal error has occurred. Check the logfile above for detailsFME Session Duration: 2.8 seconds. (CPU: 0.2s user, 0.1s system)END - ProcessID: 4020, peak process memory usage: 40856 kB, current process memory usage: 39564 kBA fatal error has occurred. Check the logfile above for detailsProgram TerminatingTranslation FAILED."Please help me regarding this issue.@vamsi krishna

Hello All, I have 2 columns that I need to merge into one. Columns are different attributes of a single feature class. If Address 1 has populated field, then they are accepted. If Address 1 is null, then Address 2 is checked and information from that column will be copied to Address 1. If both columns are populated, Address 1 is accepted. Any ideas of how I would do that? Any help would be appreciated. Thanks

Hi there, I am trying to create a 3D photo mesh using LiDAR and aerial imagery, but find using the TIN Surface produces a more jagged output, even with a higher tolerance. I was wondering if it’s possible to do this using a DEM and if this would produce a neater result. I am using Surface Modeller to convert the LIDAR to TIN Surface. I then remove existing appearance and hook up the result along with the aerial image to the appearance setter transformer.What should I be using to get a neater output or is TIN the only way to go?Regards, Josh