Transformers

I have these parameters for database Uploader transformer and I'd like to do the same thing on a python shutdown script so I don't need to have a parent and child workspace for capturing log information. Looking for some python samples to do this with SQL Server. Thanks. 

I was using this question to help with launching workbench from shutdown script but I kept failing.https://knowledge.safe.com/questions/93753/how-to-execute-a-workbench-from-python.htmlThe error message I get is.BADNEWS: FME_END_PYTHON failure class StatusInfo *__cdecl FMETranslator::translate(class FMETValOrderedVector<class ObsoleteString>,bool &,void (__cdecl *)(FME_MsgLevel,const char *),void (__cdecl *)(const char *),bool,bool (__cdecl *)(void *,class ObsoleteString &),void *,bool)(c:\code\fme\foundation\kernel\fmetran.cpp:1369) - class StatusInfo *__cdecl FMETranslator::translate(class FMETValOrderedVector<class ObsoleteString>,bool &,void (__cdecl *)(FME_MsgLevel,const char *),void (__cdecl *)(const char *),bool,bool (__cdecl *)(void *,class ObsoleteString &),void *,bool)(c:\code

 Hello Guys ,i am misunderstanding this point ,i hope some one explain to me what is the difference between group elements by Geometry and Schema numbersi mean when i choose geometry i got lines feature seperately but when i do schema level names i do not have same feature type lines or another names as geometryi have lots of numbers and when i connect with inspector ,what i got from schema numbers i could not find the same amount numbers that i knew it before from lines (Geometry) what is important for me ,lines and polygon too find intersection but when i extract geometry , polygon collections what i got from geometry it seemly not working or misunderstand for me,bcs when i connect with inspector i see nothing so i was thinking to try something else as schema numbers iam totally new in program bu

Hi,I have lines and points near lines. I need to move point perpendicular (vertical) to line and break line at that point. Any ideas?

Hi all,  I try to redefine the outer boundaries of the red and green polygons. As you can see in the picture, they are not up-to-date anymore. However, I have tried different transformers, in different order like GeometryCoercer, LineOnLine Overlayer and a clipper, but the outcome is everytime a mess of lines criss-crossing (second picture), Basically I want to get rid of everything on the 'inside' and just keep the outer boundary of both red and green (or in-and outside of green ofcourse, but then I have another problem with different symbology on both sides...). I don't need any of the attributes, just the geometry will do. I am relatively new to FME, any help much appreciated!  Thanks.  

i have output of transformer l , it looks like the above table. in the inspectori want to split this table automatically depends on the amount of cells in ID column .as here the table has only 4 rows but sometimes i got another output with different rows ,but any table has idso i want to divide the output of transformer to many seperated output and each output has his own id with his row bcs i want to do some actions later and connected seperately with some transformer .i need the output looks like the picture as down , but i want to create way automatically whatever the amount of ID ,get me the result output seperately .exactly , i have lines with different id and this is the output as shown above. Thanks for help 

 as you see in photo no amount of numbers get out of polygon so i will not see anything if i connect the polygon with inspector so what should i do ,both of them get from the same file,is that normal or there is transformer should i add before work on it .thanksbut if click inspect on polygon it hows me in display control,ellipses and lines and multi text and points and shapes and text .but if i create inspector and connect with polygon it shows nothing,it does not give me the fme data inspector to see how it looks like ,what is important for me i want to find intersecton between lines and polygon but lines show me amount of numbers on output but polygon show nothing so the ouput is wrong .i hope,i find answer.thanks

@takashiGreetings FME sensei, good to see you're still around! I had a question about a Python script I'm using as a Private Parameter linked to two published parameters to generate log file folders that include the local user and date in the folder name, then generates time/date stamped log files within those folders.Here's the script:# Scripted (Python) Parameter Example # Create log file path with time stamp. import fme, time, os d = FME_MacroValues['Log_File_Dir'] # directory path w = FME_MacroValues['User_Name'] # workspace name t = time.strftime('%Y%m%d%H%M%S') # time stamp f = FME_MacroValues['Folder_Name_Date'] # date in folder name # If the workspace name ends with ".fmw", remove it. if w.endswith('.fmw'): w = w[:-4]  # Create a new folder which has the name of the workspace. dir = os.path.join(d, w, f)

Is there any transformers to aid in  MultiPolygons to simple Polygons.  I'm going from ESRI Geodatabase to SDF.  Chris

The equivalent tool to “pivot table” of ArcGIS in FME,    I couldn’t figure out which tool is equivalent to “pivot table” of ArcGIS in FME. I have a layer and I want to rearrange the attribute table in a specific way  The following picture shows my need    when i use the pivot table tool the table is look like this        Thanks in advance  Best

i have numbers in String format but need to translate to numericlike belowOriginal StringNeed to be convert One 1 Two 2 Three 3 Four 4 Five 5 Six 6 Seven 7 Eight 8 Nine 9 Ten 10One Hundred and Fifty Nine 159Five Hundred and Nineteen 519Nine Hundred and Fifty One 951 Two Thousand Four Hundred and Eighty Six 2486 Two Thousand Six Hundred and Eighty Four 2684 Six Thousand Eight Hundred and Forty Two 6842 Eight Thousand Six Hundred and Twenty Four 8624 Eight Thousand Four Hundred and Sixty Two 8462 Thirteen Thousand Five Hundred and Seventy Nine 13579 Thirty One Thousand Five Hundred and Ninety Seven 31597 Fifty Three Thousand One Hundred and Seventy Nine 53179 Seventy Five Thousand Three Hundred and Nineteen 75319 Ninety Seven Thousand Five Hundred and Thirty One 97531 Note: I'm getting value upto 7 digits.

I have the following that worksSDE DATA => Test Filter (Name = Point) > XMLFramenter > Rest works as expected 1 feature coming throughI want to remove the Test Filter and and put an SQL Where clause at the SDE Data level ( Name = Point ) the SQL is valid and 1 feature comes through however the XMLFramenter fails.Looking at the data in both cases for the field that contains the XML data is identical yet it fails in one case and not the other, any ideas?

Folks,I need to scour some file shares with a python script to identify any data files. I would like to exclude 'non data' files and it occurs to me that one way of doing this would be to compare file extensions with a list of format-specific file extensions that are used by FME Readers...The Knowledge Base does list file formats (https://www.safe.com/fme/formats-matrix/ ) but doesn't specify the associated file extensions.Does anyone know if there is a matrix that lists the file extensions associated with each FME Reader?Many Thanks, Graham

HiI am using the R caller for creating a scatter plot with 2 variables and I would like using 2 different colors for the 2 variables. I am using the following function:plot(wells, col = c("red", "blue"))Yet it comes out black!Any ideas Best regards, Felipe Verdú

Hi, I have achieved the below XML using the following xquery in an XMLUpdater: XML: <base>  <level id="Level-1"/>  <group id="A" category="line">  <section id="A1">  <definition>  <edges>  <edge id="110992"/>  </edges>  </definition>  </section>  <section id="A2"/>  <section id="A3"/>  <section id="A4"/>  </group> </base><base>  <level id="Level-1"/>  <group id="B" category="line">  <section id="B1">  <definition>  <edges>  <edge id="128677"/>  </edges>  </definition>

Hello all, I have a series of flow paths along a network, each with a unique ID. I want to essentially produce an elevation profile graph along each path by sorting the data and writing into an excel template.I have split the single paths at each node, and linked the elevation of that node to each _from_node and _to_node. However, i'm struggling to figure out how to sort the data in the order of the path. Each path doesn't follow the pattern of Node 1 - Node 2 - Node 3, etc. Some will jump around, e.g. Node 1 - Node 2 - Node 13 - Node 7, and so on.The information is contained within the _from_node and _to_node attributes, but i cant figure out a way to sort this data, apart from possibly using an indefinite number of joins on the _from_node and _to_node attributes.Any ideas would be greatly appreciated!Thanks!Jack

Hi all,  Can the AttributeManager perform operations like the StringSearcher?  I would like to extract certain strings from an attribute called RAW_DATA, I'm looking for the value in "value="xxx" e.g. <span class="store-card__value">Mon-Fri 09:00 AM  - 09:00 PM </span> <span class="store-card__value">Sat 09:00 AM  - 06:00 PM </span> <span class="store-card__value">Sun 10:00 AM  - 05:00 PM </span> </p> </div> <div> </div> <div class="store-card__section"> <a class="store-card__action" href="/teststore.com">Store Details</a> <button class="btn btn-tool store-card__action storeSelectButton selectCategoryStore " id="selectCategoryStore_699" name="699" value="699">Store</button> </div> </section> </li>

Pretty sure someone has this resolved. But I just could not find a clean solution to a seemingly basic request...Before we do an overlay operation of Layer A and Layer B, we need to first test if their CSs are the same. If they are not, Layer A needs to be reprojected to the CS of Layer B.CoordinateSystemExtractor is used to extract CS as "Attribute" from the two respective layers. But that was how far we could go: A - How can we compare the CS when the two CS Attributes are in two different datasets? B - How can we set the "Destination CS" parameter in the Reprojector transformer of Layer A to point to the CS Attribute from Layer B?Thanks!

I am using FME workbench plugins in ArcGIS Pro to translate my IFC to Shapefile, where after I assign a coordination system for London it shows many projection error. So, how to solve it? Is there any solution for it? 

hello,i am confused a little bit ,how can i use FeatureMerger correctly.I have two excel on my workspace ,Excel A : has three rows but one of them is duplicate from Excel B ,and two rows not .Excel B has 50 rowsi want to merge Excel A with Excel Band if we have any duplicate row (i mean the one of Excel A) ,remove the duplicates and keep the rest of rows .so As a result,i need to have Excel that contains 52 rows .i read alot the Documentation but iam still confused in adjust properties of Featuremerger ,i will be thankful if someone help me .thanks 

FME 2018.1.1.2 Is this expected behaviour? I've set 2 Lists to be removed from the WorkBench features by AttributeManager. Opening the Partial Results of the Output Port in Data Inspector, they are indeed removed.Yet, in the very next Transformer (happens to be TopologyBuilder) the 2 Lists reappear again on the Features when the Output Port is inspected in Data Inspector, complete with the original list values? Not only that, but trying to remove them with a subsequent AttributeManager, AttributeKeeper etc. does not work, because these Transformers don't think that either of the Lists exist anymore in the Schema and hence won't appear in the selection of Attributes/Lists available to modify! These Lists continue down the Workflow in the Partial Results but remain invisible in the Schema. Further, if I replace the AttributeManager with an AttributeKeeper, the Lists stay removed (and I guess is a workaround?). I'm guess

Hi,I have a bunch of JPEGs taken with a drone that contain spatial information within the embedded exif.I am trying to enable each JPEG with the end goal of georeferencing them so that they can be made into a mosaic. I have tried combining transformers such as the PhotoCoordinateExtracter, CoordinateSystemSetter, RasterGeoreferencer, and the RasterMosaicker to no success.Also tried FeatureWriter to GeoTIFF then FeatureReader to no avail. When I drag them (JPEG or GEOTIFF) to ArcGIS for example, they all occupy the same space.What is the best workflow for this?Cheers

Hello,I would like to tranpose my data into a new table format. I found a similar post here https://knowledge.safe.com/questions/88862/transposing-data-into-a-new-table.htmlBut I am not able to get the result I want. The main difference is that I have much more columns and rows than in the post I mentioned above.The dataset I have:DBKAlCl...10.151.1...20.201.2...30.251.3...............With the 3 dots I want to indicate that it is a large amount of data. So much more columns and much more rows as well.I would like to get the following format:DBKParameterValue1Al0.151Cl1.11......2Al0.202Cl1.22......3Al0.253Cl1.33............... So the three dots indicate that there are much more parameters for each DBK and there are also more DBK's.In the post I mentioned above they use an AttributeExposer at the end. But I d

Hello!I am wondering how can I use FME to analyse graphe?I have points that represent a surface and I would like to analyse these surfaces with local maximum and/or minimum. But the surfaces are not always simple, some of them is almost like a line, but some of them are like a roof - as represented on the picture.Is there any way to fit a line to these points, and analyse the parameters of these lines, like determinant. Or is there any algorithm that could compare these generated lines with sample functions?Do you have any advice?

This one is already solved. Writing is for documentation only as I could not find the solution here.I had to debug a workbench from a coworker which was failing with the following error:WARN  |ChartGenerator: Non-numeric input provided.  Please validate that the values of the "X Attribute","Y Attribute" and "Error Attribute" (if supplied) are numericFATAL |f_24(PythonFactory): PythonFactory failed to close properlyERROR |f_24(PythonFactory): A fatal error has occurred. Check the logfile above for detailsDue to the log pointing to non numeric input in the ChartGenerator it took me some time to find out that the error was caused by something different: One of the attribute names used in the ChartGenerator in the "Y attribute" contained a space.I tested this in desktop 2017.1.1.0 / 2017.1.1.1 / 2018 beta (build 18220).This is a known issue and filed under C133238.