Best Answers

Hi, I need to write the results of multiple files (let´s say raster data like .jpg) from multiple folders including subfolders into their source directory/folder...I can´t get it working with the proposed solution from this similar question here: https://knowledge.safe.com/questions/108973/write-file-in-the-same-directory-where-source-file.html. It seems that it does not work if I am recursing through subfolders.  Does anyone have a solution?

Hello!I have a line where the first and last vertex contains the real z height (see on photo).I want to set the direction of the line in the that it shows to the lower point, so the 0 vertext is higher, than the last coordinate. Is there a way that can change the original random orientation to fit this rule?Thanks 

Hi there, I have a database with a series of different street names from all over the world.In some regions that use multiple alphabets in their local languages, I have mixes of this. I.e. one name in Latin, and another in Thai, Arabic, Cyrillic, etc.What I'd like to do is pretty simply on paper: Look at each string in my list and determine what the alphabet used is. As simple as a new attribute indicating the language as "Latin" or "Japanese", and so on.I've tried the CharacterCodeExtractor, but checking only the first character is not always useful, especially in cases like greek where some of the letters exist in both Greek and Latin alphabets.Any ideas on this? Thanks a lot!

villepopulation en 2016superficie en 2016maisons en 2018appartements en 2018Paris 1000122591000Lyon2000366555000Toulouse50095200300 J'ai un tableau de ce type (ci-dessus) et j'aimerai le structuré comme ci-dessous  annéevilleles variablesvaleurs2018Paris maisons en 2018 2592018Lyonmaisons en 2018 6552018toulousemaisons en 2018 2002018Paris

Hello,I have a workspace that creates XML content in an attribute and finally uses an AttributeFileWriter to write it to an XML file. This all works fine in FME Desktop 2018.1 (on my Windows 10 machine) and mostly fine in FME server 2018.1.0.3 on "win64". The difference is that the result file written by FME server has a BOM (Byte Order Mark) set and the result file written by FME Desktop does not. We found this only recently when the receiver of the result file (generated by FME server) complained that their software couldn't read it, and we nailed it down to the BOM being set.I know that there is a setting in the "ordinary" Text File Writer which allows to select whether I want the BOM or not. The AttributeFileWriter does not have this option and seems to handle this differently on FME desktop and server.From the logs of the server run of my workspace I saw that it seems that the server uses a text file writer "underneath" the AttibuteFileWriter:Text

Hi,We are using FME Server 2019.1.2 and Desktop 2019.0.2 currently. The FME Server instance is located in a VPC (removed environment) and the workbenches exist on organisation internal servers. We have many workbenches which run fine on schedules, however those with ArcGIS SDE readers/writers are failing due to the following error:Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155559'. The error message from ArcObjects is: {Failure to access the DBMS server} It then asks you to check the connection parameters for the SDE connection file being used.These workbenches have been running fine for months however have failed within the last week.Can anyone assist?Thanks,Grant

I want to create an automation in FME Server for a user to validate his data.He sends in an email with his data as attachement and the topic of the validation as part of the email subject.In the workbench, the email subject is parsed and the topic is kept as an attribute. At the end a logfile is written with the name: topic.log (I do this with a fanout in the writer).This logfile I want to send back to the sender of the email as an attachement. But to attach the file to the email, I have to fill in its path and I don't know the filename at this point. How can I pass the value of "topic" (=filename) as parameter to the Automation, so that I could use it in the "Email Details"?(I'm using FME Server 2019.0)Thanks, Vera

My issue is that I want to bend all lines around a polygon if the line is intersecting it. I understand that there is a huge amount of kombinations of how Buildings and lines can be scattered so my question is reduced to a more generelized question. "How to bend a line around a area object" In my workspace I am sharing fictive objekts and explanation what seletions to be bend. I have also, in red, marked out a costum tranformer that should be replaced with Another method. So dont bother dig Deep into that one. I am also sharing a fictive example of a result to visualize approximately what I want to accomplish.    

Hello everyone.I have a question for my DTM imageries. Resolution of imageries are 0.15m for red bordered area and 0,70 m. for green bordered area. I want to create a merged (mosaicked) and interpolated raster with a resolution of 0,50 m.. By the way; intersection of the two areas must come from the high resoluiton. How i must set the overlapping value and in what order should it be the transformers?I can guess the transformers that i can use (like rasterressampler, rastercellcoercer, rasermosaicker, tester(to retrieving the cells from high resolution for intersection area), 3DForcer, SurfaceModeler, etc.)Thanks. @daleatsafe @daveatsafe @jovitaatsafe @redgeographics @deanatsafe @rylanatsafe @hollyatsafe @lenaatsafe @annabelleatsafe @steveatsafe

Hi!I have a background map on DWG + a set of data. My workbench look for an error on the set and if it found it, a buffer is output.I would like to export the backgroud only when an error is found. Is it possible?Thanks!

Hello guys, Is there a way to find a word I character chaîne with the tester like in arcgis when I create an sql selection. For exemple with the % at the end or beginning or word?

I'm looking for a method to "explode" single features into multiple features based on the numeric value in a given attribute field. Here is an example of what I'm working with and where I'm trying to get to, keeping in mind that there is point data attached to each record here...AnimalNumber_SeenOwl1Deer2Raccoon3 I'm looking to "explode" the features so that there is one point feature for each individual animal...AnimalNumber_SeenOwl1Deer1Deer1Raccoon1Raccoon1Raccoon1 It's worth noting that there are many features on the map for any given animal type, but the observations have been aggregated by the number of animals seen in the group at the time. An animal sighting with a "Number_Seen" = 1 does not need to be "exploded". Does anyone know a good FME workflow to do such a thing? I essentially need to de-aggregate points and replicate the spatial/attribute data so that there is a feature for each individual animal observed. Than

Using Build #19136 of FME Workbench 2019, and the first and last letters are getting cut off for some reason. Source dataset is in ArcGIS Server 10.6 (running on Oracle 12c). Anyone else having this issue?

Hi, I have a table that has 2 fields, one with the name of cities and the other with the date. Features with the name of the same city are repeated, but the dates do not. How can I make a filter to use only each city but with the most recent date?Eg. City | DateDC     20200621WD    20200619DC     20200620DC     20200619WD    20200618 Thank´s

Hi,I have spent most of the morning going down a rabbit hole and really am none the wiser. I am writing out some content to a feature class in SDE. When I run the full process with feature caching on or off I get a failure to write with a very unhelpful ESRI error: An error occurred while attempting to insert a row into the table 'DBO.xxxx' using a cursor. The error number from ArcObjects is: '-2147418113'. The error message from ArcObjects is: {}However if I run it with feature caching on, up to the last transformer and then run to the writer afterwards the content goes into the SDE, no error.If I write to a ffs file then push that to sde. It works. My suspicion is that I am using a feature reader, it seems like SDE doesnt recieve all the right info about the schema before FME tries to write to it, whereas it does when feature caching is enabled?Any ideas very much appreciated.ThanksOliver 

Hello,I have a 10 digit phone number in an attribute (e.g. 0123456789).However, I want to output it formatted to a string like this: 012-345-6789.How would I go about doing this?Any help would be much appreciated.Thanks

Hello,I'm currently working on a road network of ~3000 miles and some roads can go for 100 miles+ I'm looking to assign a value if the roadname is the same and the accumulative distance is 15 miles at most. So 1 road for example can be shown by 6 segments 0-33-1010-1414-2020-2828-35In the scenario above I would like 0-14 in 1 group as it is below 15 miles, then 14-28 in the second group and 28-35 in the next group. Currently a part of the workbench that works on assigning this is:However the issue I'm coming across is after 15 since the accumulative number is beyond 15 but the sum of 2 segments may still be below 15 miles. I'm not sure how to reset it as a reset would assign the whole road the same value. I'm a little stuck here and could really use some help

When I use a HTTPCaller to PUT anything fme_binary, the hexadecimal representation as visible in the data inspector is included in the request body, instead of the actual raw bytes. This results in a bunch of unreadable files on the other end. If I do the put request using the same attribute with a PythonCaller as below everything works fine. The binary data are pngs serialized through a RasterExtractor directly before.Has anyone run into a similar issue before?So, this works: r = requests.put(  url=url,   data=body,   headers={  'Content-Type': 'image/png',   'x-ms-blob-type': 'BlockBlob'})This doesn't:

I have a SDE table in Postgres that was created from data in a Hosted feature layer and MS Access table. Since it was created new records have been added to the the MS Access table. I am looking for the best way to update the SDE table with only the new records from the MS Access table.

I am working with crime data and need to change some fields to full names, M/F to Male/Female. Is the stringreplacer a good candidate for this? I have been using the FeatureMerger and definition tables in .csv format. Just seeing if there is a better way to do this. Thanks!!

I need help with FME Data Streaming Service. I am having trouble serving up a pdf file in a browser. I am using the DataFile writer to write my pdf because my pdf comes in binary form. It all works in workbench, but when I try it in FME Server as a Data Stream it downloads the pdf with the workbench name and a .fmw as the extension. If I change the extension to .pdf my pdf is there and I can open this. I would think that FME should serve up the pdf with the file name I specified in the writer. Any help would be greatly appreciated. 

Hello,I'm intersecting two layers of data (polygon.shp and plygon2.shp). One of them (polygon2.shp) has two completely overlapping polygons. I'm getting this:How to get this:Here is the sample data: .

Hello guys,I have a files in a Esri geodatabase with the county of New York and an other files with "the constraint" its an huge group off small polygon (8 millions) who represent a mix between the slope + forest +swamp, what ever.  I would like to clip the county by the constraint and get the outside flow, it will form at the end the polygon of the county with some holes where was the constraints. So i use the clipper with this two files i think as many of you know it take long time and at the end fme say that i didn't have enough place (i had 20 gb free).  After that i try to create different workbench with 1 million feature to run in each workspace (workspace 1 = 0 to 1 million , workspace 2 = 1 to 2 million, workspace 3 = 2 to 3 million, etc), but im not sur its work to so.  So well my question is for you what is the best way ?

Hi,I am looking for learning the way we can convert excel files into XSD format. Any basic tutorials/videos that can help me to learn this quickly?Regards,Purvi

Hi,I'm creating line with measure on vertex and write it to postgis. When I read the same line from postgis, there is no measure. Is-it possible to write and read measure from Postgis?Thanks