Best Answers

Hi,I have configuration file from which I have to extract attributes headers for excel file.I have managed to bring as shown below...A,B,C,D,ENow I want to convert this to attribute header A B C D Eattached a screenshot for better understanding... Could any one throw some light and suggest me...

I have seen that the version of AutoCAD a dwg file was saved in can be found as per this link, however I'm after ideas for a good, quick way to validate this - e.g. version must be 2007 or newer. I am using the RealDWG reader, and the workspace will have to work on FME Server.I have tried exposing the autocad_version format attribute, but in the file I am testing no value comes through for this. I do note that FME was able to do a version check when reading as shown in the log, in which case this file was found to be AutoCAD 2007.I have thought to perhaps save the file to a temp location, read it back in with a text reader and find the version through that but I'm hopeful of a slightly tidier solution within the workspace.Also been asked to validate dimension type, but again autocad_dimension_type is missing. Perhaps it's just my source data letting me down!

Hi! I'm trying to create a raster based on high density point features (bathymetry data) from ArcSDE. The thing is that I want to control which features enters the NumericRasterrizer/RasterDEMGenerator (or some other suitable transformer) and gets assigned a cell value. The problem is that the point data is much denser than what I want the resolution of the raster to be. In this case I want FME to pick the point feature with the minimum z-value of all the in-going point features and assign it to the cell and ignore the others. Much like you have in ArcMap where you can can choose the "Cell assignment type" in the "Point to Raster" tool. Is there a way in FME to solve this?Thanks!

Hy I read a xlxs file and I exposed the attribute now I need to rename the filed instead of _list0 I want prefix instead of _list_1_ I want Prep Thx Francesco

I have a dataset containing different points. To insert them into my postGIS database I need to convert each point into multipoint (but each multipoint is only containing one point)I may not change the geometry-type in postGIS, so I just need to store each point as a multipoint...I already did some tests with the aggregator and geometrycoercer, but can't figure out how to change the geometry from point into multipoint. maybe a bit of a silly question, but I just can't figure out how to do this :(thanks for helping me!

I have a FeatureMerger Supplier with the same attribute fields as are available in the Requestor. When there is a matching Supplier, I want to merge the Suppliers geometry and a subset of the Supplier attribute fields into the Requestor, leaving the remaining Requestor attribute fields unchanged, e.g.,Supplier Attributes Requestor Attributes ActionORG_CD ORG_CD Requestor value retainedSTATUS STATUS Requestor value retainedACCURACY ---------------------------> ACCURACY Supplier value mergedGIS_ACRES ---------------------------> GIS_ACRES Supplier value mergedLENGTH_FT ---------------------------> LENGTH_FT Supplier value mergedCOORD_SRC -------------------------> COORD_SRC Supplier value mergedREPORT_DT REPORT_DT

 Hi, I've got a dwg file with 3D points (layer name : points_3D) and with polyline (layer name : 92040). I want to transform the polyline to polyline 3D by using the points files. How could I realize this operation with FME?

I am a newbie to FME. I need to create nodes from a road network shapefile. Initially in ESRI, I created a network dataset and subsequently nodes. The resulting dataset had pseudo-nodes and dangle nodes along edges and at ends of segments. This wasn’t what I wanted. How do you distinguish between intersection and overpasses? How can I use FME to generate nodes only at intersections? I will appreciate it if you can send me a workflow.

I need to convert to/from FILETIME in FME2016.....So for instance FILETIME=131443544400651329http://www.silisoftware.com/tools/date.php?inputdate=131443544400651329&inputformat;=filetimeWill be converted to:2017-07-12T17:34:00+00:00 Some hints here: https://stackoverflow.com/questions/19801727/convert-datetime-to-unix-timestamp-and-convert-it-back-in-pythonHowever I am curious if there is a simpler way to do this in FME?

HelloDoes anybody know of a way of setting up a multiple choice user parameter to select which source data is read. I need to have two choices where one or both options can be selected. Depending on which option is selected determines which reader is used. The user is also asked to select the location of the source data for both datasets, but a default location is also stored.Hope the above makes sense.Thanks

Is it possible to copy/paste conditional statements in AttributeManager? I have three attributes that I want to calculate values for in AttributeManager. All three are based on the same conditional statement. Is it possible to set up the conditional statement for one attribute and then copy/paste it into the other attributes (under Attribute Value)? The conditional statement has six conditions (A or B or C or D or E or F) and I might change it later so it would be easier and reduce mistakes to be able to copy/paste rather than recreate/change it three times.

Hi,I am using the networl flow orientor to check the direction of digitisation agains a given flow direction.This is a snippet of the script, i have also attached it, together with the 3 lines and the one destination point (fme 2017):I expected all three lines to have the same _direction value "same". However, the one with GISID 3128shows up with the value "opposite". But if one Looks at the coordinate order they all goes towards the destination point. I do not understand the behaviour!

Hi FME'ers,I am currently trying to write OS Mastermap (gml) to an Esri Geodatabase (File Geodb ArcObjects). I get so far before it through's up the error "ArcObjects Error -2147467259 Whitespace is not allowed at this location.The problem is the log file doesn't tell me where the offending whitespace is...So I look through the erroneous record to try find it but I can't see (by eye) what the problem is. Is this an ESRI issue or an FME issue? Thanks,David McDermott 

Hello,I am using FME Server 2016.1 and I need to reference a folder named "farms:. I have added that into the config file and it appears in my resources list, no problem. However, the issue I am having is that I cannot run any workspace when I select the file for processing. If the files are put in other resources like data/myfiles, there is no issue. Below is the configuration I have added into the fmeserverconfig.txt file:SHAREDRESOURCE_TYPE_7=FILESHAREDRESOURCE_NAME_7=riversSHAREDRESOURCE_DISPLAYNAME_7=riversSHAREDRESOURCE_DESCRIPTION_7=This shared resource is for the riversSHAREDRESOURCE_ISMIGRATABLE_7=falseSHAREDRESOURCE_DIR_7=C:/ProgramData/Safe Software/FME Server///resources/data/water/rivers/SHAREDRESOURCE_SECURITY_DEFAULT_ROLES_7=fmeadmin   The error I get on FME Server is:statusMessage Undefined macro `rivers' dereferenced in file `rivers\\shape2shape\\rivers2tab.fmw'  Note, when using the workspace in WB, it works perfectly. If I access to my data from the data

I'm trying to write a Python-Script how tested a Published Parameter. If its FALSE it should stop the Workbench. ________________________________import fme pw = fme.macroValues['passwort'] if pw == "test":  print("PASSWORT RICHTIG") else:  print("PASSWORT FALSCH")___________________________ 

Wherever I first open up FME and navigate to the Database Connections or Web Connections in the FME Options it seems like FME takes ages to load these up (almost a minute!). This is present in both FME 2016 and FME 2017. I Also notice that FME 2017 is slow to start for the first time, could this be related? Furthermore when I add an HTTPCaller to my workspace this takes a while too.

I try to read a csv-file, that contains geometries in wkt as well as attributes and want to convert these in a shapefile.The first two lines look as follows:WKT,fid,objectid,y,bt_nummer,flaeche_qm,name_stat_,x,shape_area,shape_len MultiPolygon(((4469285.3 5337544.1, 4469292.1 5337435.9, 4469311.4 5337437.0))),1,10,5336470.71,12.4,1297528.91423,Münchener Freiheit,4469371.47,,(note that I have shortened and cut the vertices)There are two problems arising:The inspector doesn't show the attributes at allThe shapefile writer (connected directly) gives only empty - but correctly named - columns in the attribute tableWhat am I missing?

Hi, I have two non-spatial features and need to bring together the string values from several records in one attribute. For example: FK1 IDState1CH2US3AU4IT5FR FK2 IDNarrative1B11B21B32C12C23D33D43D53D7 I need to get follow result:IDStateNarrative1CHB1, B2, B32USC1, C23AUD3, D4, D5, D7 How can I do it with FME? Thanks for help

I have a workbench to translate a shapefile to Microstation DGN. In the workbench I have a parameter to let the user specify on with attribute of the shapefile the layernames in the DGN should be based. When I run the workbench in FME Workbench everything works fine and the layers in the DGN are named by the content of the attribute. But when I run the workbench in FME QuickTranslator, the layer in the DGN is named by the attribute itself.Is this a bug?

HiI have a simple spreadsheet that has a month column in text ie January, February.How do i convert this to a number? So for January it would be 01, February 02 etc etc.I've tried using AttributeValueMapper with the following source value;@Value(Month)='January'and a destination value of 01but no luck.Would be grateful if someone could suggest how i can do thisthanksSimon Hume

Hi,I would like to define a private parameter based on a publish parameter. My idea is to use a python script that should return the desired private parameter.import fmeobjectsif (FME_MacroValues['publih_parameter'] == 'val'): private_parameter='val_'elif (FME_MacroValues['publih_parameter'] == 'wal'): private_parameter='wal_'else: private_parameter='zal_'return private_parameterBut this is not working. Any ideas?Thanks

Hi, I would like to round a elevation value to the nearest even number. Is there a way to do this, perhaps using AttributeRounder or CoordinateRounder?I am using FME Desktop 2016. Thanks

Hi,We have a workspace file with a size of 2140kb, when we tried to upload to FME server we are getting a publish failed error:Publish failed - FME Server encountered an error.Request to https://myserver/fmerest/v3/repositories/dev/items returned status code 413.HTTP Error 413 is Entity Too Large, where can I change this restriction on FME Server?Thanks.

Hello,I have the attributive information that the water flow goes from one point to another point. In the figure below, say from 6630 to 6629. The line geometries that describe the way from 6630 to 6629 know that they belong to that path because they all carrry the respective Information, here "6630_6629".From the example one can see that the direction of digitazation (blue arrow) of the lines partly correspond to the flow direction. The yellow marked arrows indicate lines where the lines do not correspond to the flow direction. For these lines I want to invert some information ( i do not want to convert the orientation itself!). Therefore i need to detect from the buch of lines those ones where direction of digitazation and flow direction do not correspond.I have experimented with the topology builder, at least I manage to isolate the candidates for the mismatch. Those lines where the "from_node" value and the "to_node" values match are those candidates B