Transformers

Hey there,I'm stuck! I need to export an Oracle database to a SQLite file. Even empty tables must be in the file. I already tried to understand the suggestions in the articles "dynamic writer to write empty feature classes", "When data is missing, I want to output an empty feature class anyway" and "Copy only Schema to an other database", but none of these helped me. The stumbling block might be the fact that I never know which table with which schema is empty. The NoFeaturesTester might not help here.This is what my workspace looks like so far:To trigger the FeatureReader I read several XML-files to get a list of the desired tables (attribute "FeatureName"). This list is then used as the Reader's parameter "Feature Types to Read". With the output UnusedSuppliers I try to go to the writer directly or with adding a simple point.These are the empty tables (from the output UnusedSuppliers)The SQLite does not contain these empty tab

Hi, I read images from a directory and save them in SQL Server as <image>.I use the AttributeFileReader to create a binary representation of the image which then just gets written into the database (works fine).I also need to create a thumbnail for each image and save it as blob as well. And here my problem starts - I don't know which transformers I need to use:My process looks like that:AttributeFileReader -->RasterReplacer (I need to create an image)-->RasterResampler (I create a thumbnail)-->RasterExtractor (I create binary representation of the image)the result gets written as <image> into a SQL DB table.But when I extract the image from SQL Server (with an different application than FME) the thumbnail is no valid image file (whereas the main image is).For simplicity I uses JPG files only right now.Any idea what might be wrong with my choice of transformers or their order? Many thanks, Rob

HI!I have a published parameter with mulitple choices.When I publish my workbench on FME Server for my web page, it looks like that.I can choose the four options if I want.My choices are sent into an email to some users.The (little) problem is that their aren't any comma between each values. It looks like that : N1 N2 N3 N4Would that be possible to add comma or something else? If I had bigger value's name (like roads name per example), it would be a bigger problem.Thanks. 

Is there any way to assign or place an icon to a coordinate instead of the default "bullet" ? I have the icon, I have the coordinate.I'm aware of the KMLStyler capabilities (in fact, this is pretty much what I need), the trick is I create the output from a generic writer, so we have the ability to create other geo\\cad format then KML. I would like to have my own .jpg icon linked to the coordinate itself, so I expect it to be "see able" whatever the output I've made available.Does it make sense ? Any hint in order to get it done ?Thanks much, regards.

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!

The NeighborFinder has been updated at 2018 to return measures with the near values. But does it?It would be great if it worked as documented, and I vaguely remember using it in the Beta. I don't see any new output attributes null or otherwise. I see a lot of hacks in FME Hub for LRS_* operations, (none of them very appealing). I did find a workaround using PointOnLineOverlayer. I assume the extra parameters on NeighborFinder were meant to do the same without an overlay.Is there a way of getting a measure on a Route without chopping up the line?

When trying to merge different WMS layers together to reduce a PDF file size i'm loosing too much image quality. An alternative option that i build is to just add them as extra layers but the file size is sometimes too big for normal use. So my question is: How can i improve my image quality?The ideal option is to get the same quality as you would normally see when all rasters are send to the the data inspector. Like this:But with with nearest neighbour it looks like this:If i use bi-linear it looks a bit better:and bi-cubic looks even better:But it still loses a lot of detail and line quality in the parts that the lines are semitransparent. Is there a option for merging this the same way as the result shown in the data inspector (see the first image) without all the abundance of data that you cannot see? In the end i would like my PDF with rasters merged to be/look the same as the PDF with the rasters as separate layers. I have taken the necessary transformers from my flow into t

Dear community,I would like to create a halton sequence meaning systematic random distributed points. I found the appended python code. To call it: halton_sequence(10, 3) Now, how can I adapt the code so I can use it in the PythonCreator? I would need a list of coordinates to create the points.Thank you for your help! 

Hello everybody,  I try to solve problem withACAD block. I just wanna add attribute definition into block. This block has not any attribute definition, so it is completely without user attributes. If block definition has one or more attribute defition, there is not problem to add new one via FME. But in case of block without attribute, I cant solve, how to add attribute definition.Could anybody help me please?Thank You so much!Lubo

Dear community,I need to calculate the weighted distance from many points to all the others within a radius of 2000m. For this task I combined the NeigborFinder with a ListExploder and a ExpressionEvaluator to calculate the weighted distance per point.Now, the ListExploder produces a huge amount of elements which causes memory issues, although I'm using a 64-Bit machine with 65 GByte of RAM. Is there another way of solving this task e.g. without ListExploder? I think I need the ListExploder to be able to calculate the weighted distance for every point in the ExpressionEvaluator...Thank you for your help,Vincent

Hello,I have a .cal file saved in python to create a unique identifier. How can I use this in FME? I didn't create this so I don't know how to tie this to the field needed. In Arcmap I could just right click the field I want this to go in and field calculate it, but how would I use this to update attributes with nulls in a specific field within fme. import uuiddef f(): return "{" + str(uuid.uuid4()).upper() + "}"__esri_field_calculator_splitter__f()    

I've offset a number of yellow polys in this example 3 original inputs in the one layer.I would like to subset this by selecting only the polygons that are mutually exclusive i.e. select only the polygons on the bottom left that do not overlap the other 2. Then all the polys on the top middle that do not overlap with the bottom left and right and so on.Here are some of the end results that would work in teal. I did this manually but there would be more of each.

I have created a mesh in pythoncaller and included already earned uv coordinates. Everything looks good after python, but if I try to write a file to any 3D format, then UV does not hang out. Have used: FMEMesh.appendTextureCoordinates FMEMesh.appendVertex

hello. Im using InlineQuerier in a worbench where I have changed the attribute naming. Therefore, I dont want to read from a reader but from a transformer just before the InlineQuerier. Is it possible? Mnay thanks

Hello,What is the trick to create a polygon from a set of coordinates and make sure FME read the points in the order to create the required polygon where _result field can be used as ID and acknowledge the order in which polygon should be created ? I went thru a bunch of transformers, but I did not succeed with any... I went thru several articles from the knowledge center as well, but cannot figure it out. Hope the question makes sense.Thank you for your inputs, regards.

Hello,I am trying to run an FMW file using a batch script and although I can run the batch file manually and it will run successfully without any hiccups and in very little time (2-3 mins) when I try running the same batch script as a Scheduled Task it takes way too much time to run (I haven't even let it finish as it was running for over half an hour) and doesn't look to run the same way (their log files differ).I would love some help to get this working properly. I know FME Server does this much easier but our office doesn't have the resources (or business requirements) to purchase Server and so I'm stuck trying to make this work with a Scheduled Task. Any help would be greatly appreciated, thank you.

Good afternoon, I am currently experiencing a issue with fme server job submitter and feeding user parameters via a csv file.I have a workspace on a 2018 server that works fine if the user runs the work space directly from the repository and within the workspace the user can select from a variety of user parameters to extract data based on date, format, projection etc.when i try to run that workspace via a server job submitter using a csv file containing all the parameter details it appears that the server job submitter is truncating or moving the parameters to the next parameter. This appears to be happening with part of the date formatting. if i remove the date formatting out of the csv then the server job submitter appears to run correctly. the date format is needed as our data base is quite particular about extracting in that particular format.below is a snip from the log file. you can see that the server job submitter appears to moving the data within the parameter to the next par

Hi everyone,I've got numerous of bridges as Polygones that are to short. I need to extend the bridges along a vector or line feature that I allready got. If the Polygones would only consist of 4 edges I could solve the problem, but they do not. Please help if you got any advice or idea!

Hi,I've got the following script in an SQL Executor:update tbx.ext_compare_person  set   gesnam_d = tbx.diakriet_cip(gesnam_d,sourcekey,'Gesnam'),     gesvor = tbx.diakriet_cip(gesvor,sourcekey,'Vornam'),     gesnam_d_partner = tbx.diakriet_cip(gesnam_d_partner,sourcekey,'GesnamPartner')where organisation = '1234'and   applicationcode = 'ABC'Parameters are:When I execute the script via "Run" (test in SQL Statement) it runs perfectly. It updates the correct rows. But when I run the translation complete, it doesn't perform as tested (it updates nothing).What is the best solution here? Am I doing something wrong?Thanx in advance, Erwin

I am struggling to create an ERS header (using desktop 2015) without the huge datafile when I generate large ECW mosaics, can anyone help please?  At the moment the ERS file is being generated at the point where the ECW file is being created after the JPEGs pass through the RasterMosaiker, I need the .ERS header to go with the .ECW

My features have an attribute _mapsheet. When I use the inspector I can see the _mapsheet attribute is populated when it comes out of the FeatureReaderBut then when I check the attribute after it has been through the RasterExtentsCoercer (which I have named RawRasterExtent in my workspace) the attribute is no longer populated.I had this workspace working in FME 2017. Is this a bug in 2018? Or is there something extra I need to do.TIA

Hi,I have a table of locations that I'm trying to split into from_location and to_location columns as shown below. Starting with: Location1234Want: from_locationto_location122334Thanks for your help!

I have a set of approx 2000 rectangular polygons I need to offset where overlaps exist.Approx 50 have overlaps as below.I'm using a custom transformer written by somebody else in this forum to create offset candidates. This has 2 numeric fields I can use to find the optimal offset location i.e. distance and angle (closest to the right). These could be incrementedin a loop for e.g. until no overlaps exist. e.g try a counter clockwise loop of the closestset and if overlaps still exist then try the same on the next closest set until a non overlapping candidate is found.I've had partial success however I am not sure how to design a workspace thatwill offset 1 polygon at a time. i.e. it needs to select a candidate offset based onmin distance and min angle (closest to the right) then compare that to all otherpolygons (no overlaps) then apply the offset.Subsequent offsets would need to check for overlaps against existing 2000 polygonsbut also against all those that have already been o

I have been supplied a LAS files to extract features from. FME has been able to do a pretty good job at it and I have been able to extract the likes of Road Markings and Signs from the pointcloud. However, I am hoping that there may a few more idea of refining the process to get "nicer" features from the data.For the road marking, I really want a process that looks at the outer points and removes all the vertices in between. I can't seem to find a "generalization/smoothing" that does it nicely. (Thanks to @dmitribagh for the initial workspace)   For the signs, I have just have got to the point to of extracting from the LAS. So I need to create into a vertical surface/polygons. I have an idea to extract the full surface in much the same way as above, although to I believe for each sign, I will:- User Centrelinereplacer to extract the angle of the sign.- coordinateswapper, so that I am looking down on the sign face- Rotate the sign using angle to look at the full

Hi all,I am wondering how is the best way to create a new column in fme with say last modified date and then extract the last time excel file was saved into the column for each record?Thanks