Best Answers

Hi,I'm using the FeatureWriter to export a bunch of data from an SDE FeatureReader to a shapefile format. While most shapefiles are getting created with no problems, there are a few where the attribute table cannot be read using either ArcMap or ArcCatalog. The ones that cannot be read seem to be the ones where I am using a Tester transformer to select only certain features for export.The image below shows the 3 layers that are having the problems. Other layers also use a Tester, but they also use other Transformers as well.The three that are having the issue are the only ones where there is just one Tester transformer in the 'chain'.Spatially, all the data is there, but it's just the attribute table that cannot be read. This is the error I get in ArcCatalog. 

Hi, I have a database table with a date column containing dates formatted as YYYYMMDD. I need to select all records from the table with a date ranging from the current date to 5 years previous of the current date. Any assistance appreciated.

Hello:At https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/spatialrelations.htm the Pattern Matrix for OGC "Equals" relation is filled with some * characters .However, Simple Features OGC 06-103r4 document (p. XXXV) at https://www.ogc.org/standards/sfa defines "Equals" relation with no * characters:a.Relate(b, “TFFFTFFFT”)To follow OGC specifications, shouldn't the matrix be filled up accordingly?Thank you very much

Hi all After processing we are left with ortho tiles in GEOTIFF format. The GEOTIFFS on the edge of the process area have black borders. When we process to area's next to eachother we have an overlap with the black borders.  Normally we work with jpeg2000 and I use the rasterbandnodatasetter and the rasterinterpretationcoercer to convert the nodata to an alpha band.  But now our client wants the orthophoto tiled with their specifiactions and in ECW. This is my tiling workbench. Pretty easy. The rastermosaicker groups by "naam" and puts out ECW tiles.  The result looks like this:As you can see there are black borders in the area's that overlap. What I understand is that ECW wont work with nodata and wont work with alpha band.  How can I solve this? I could convert the original geotiff files to tiff with the nodata and rasterbandinterpretation method. Once I have them I can tile them with my workbench but use a tiff writer instead of an ECW writer.After I have my tiff t

Before describing my issue, I already looked into the list of posts underneath:KB-article: Working with soap serviceQuestion: HTTPCaller SOAP issuesQuestion: Help with SOAPQuestion: Connecting to SOAPQuestion: FME desktop SOAP service issue problemBecause I first didn't succeed, I also installed SoapUI, as advised by @daveatsafe. And within SoapUI everything works fine. When I go to FME and use the HTTPCaller, I get an "HTTP/1.1 404 Not found"In the header I already added the SOAPAction (both with and within double quotes) and also copied all the other header elements and values in the header request. But still no difference. I also tried WireShark to look into the POST-requests, but since they're all encoded, I do not seem to be able to find any differences (and I can't succeed in decoding them, which seems to be possible). What I did notice in SoapUI is a different URL the POST-request seems to be send to, but when questioning that at my client, they tell me to

Hi Guys, is it possible to acces a view in an Oracle Spatial database by the Oracel Spatial Object reader? When I try to connect, the table list doesn't show any existing view. In case the reader doesn't support reading views, is there any workaround to get my view as a feature type into FME Workbench? Thanks for helping,Wolfgang

Hello, I'm trying to extract a multipolygon from a JSON file with the model of this topic (https://knowledge.safe.com/questions/40791/json-multipolygon.html) but I don't achive to do it ...It's my first time working with JSON The multipolygon in the Json file is defined like this (I replace real value by x1 x2 etc in the exemple) :{ "stages": { "filters.hexbin":{"boundary": "MULTIPOLYGON (((x1 y1,x2 y2,x3 y3,.... )))I've try with : json["stages"]["filters.hexbin"]["boundary"] in JSONExtractor but it doesn't work , an I don't really know what I need to fill in "JSON Document" ... Does anyone have any idea how to do it? Regards

Hi,I am new to FME Desktop and I would like to get help in order to extract all the street side segments which are located within 5 meters from the standpipes. The resulting segments must also contain the attributes of the standpipes that meet the selection criteria and produce an Excel report of all the selected segments.How can I achieve this task using FME?PS. I'm using FME Desktop 2020 Thank you!

Hello thereTraying to use FME to convert date formatdate : 1591982226conversion :Friday, June 12, 2020 5:17:06pmthe conversion was done using this tool ( https://www.silisoftware.com/tools/date.php?inputdate=1591982226&inputformat=unix ) is there a way we get the same result with FME transformerThanks 

Hello, I'm searching for a way to obtain the external shape of a laz file and turn it into a line or polygon for and shp output.I've found something but it force me to "convert" in fme the point cloud entity to a multiple point entity. The issue with that method is that is that take a long time to process and that is not adapted to my data covers entire cities and has billions of points.Do you have any Idea on how can I proceed ?Here an exemple of the kind of data i have :

I've built an Automation to run a workspace when Server receives an email containing some key text. The problem is that the email remains in the IMAP mailbox after the Automation has run, so in 5-minutes when Server polls the mailbox and finds the same piece of email, it want to run the whole thing over again. How do I make it delete the email once it has been processed?

We're interested in using FME Desktop for automated ETL processes on Kubernetes cloud infrastructure. We intend to use it on "Job" type because it allows us to use our clusters for the shortest possible time, taking only the resources it needs to complete the job, and nothing else. This is why our interest lies in FME desktop for parameterized ETL jobs much more than with FME Server, which requires costly dedicated services that run unused for most of the time.However, we have some trouble Dockerized installs of FME Desktop on newer versions of Ubuntu. This is all fine:ARG UBUNTU_VERSION=16.04FROM ubuntu:${UBUNTU_VERSION}# After FROM all ARGs are wiped, so we need to set againARG UBUNTU_VERSION=16.04# Installing required packagesRUN apt-get update && \    apt-get -y install \        curl# Frontent must be disabled during installARG DEBIAN_FRONTEND=noninteractive# I'm not using the docker ADD command to be able to use cache.ARG FME_MAJOR=2019ARG FME_MINOR=1.2.0.19630RUN curl --f

Hi, I have X,Y,Z,R,G,B txt file that I want to convert it to RGB coloured point cloud. The Point cloud creates fine, however without RGB colour assigned to points. How to assign RGB values to point cloud based on attributes? Any help much appreciated.Thanks, M

I have points with attributes and a line. I have used the point on line overlayer to break the line at each point. however there is not a point at the beginning. I assume that is why the attribute of the point is attached to the line the point is at the end of. I need to attach that attribute to the next segment of line. in other words the begin point of the broken piece would give it's attribute to the following segment. I can think of a long way around by creating a crc with the points coords, then by getting the begin point of the broken segment and creating a crc with it but if there were any round issues it would not find it's match. Any other more elegant method anyone has used?If i simply add a point to the beginning of the line will that offset them all to the beginning?

Hi,I have a workspace which finds the shortest path using the shortespath finder transformer.For some reason this particular network it is not able to find path. I have network created from topology and it has end node and don't see any problem with the network and I have checked it many times but not able to understand why it is not picking up the route.It will be very helpful If you guys can spot the issue.Thanks for you help and time.ZubairSM

Hello all, I have a polyline layer within which each feature is made up of just two segments, and of course just three node points.I'm looking for a method to discover all polyline features that do not deviate beyond a set angle (let's say 20 degrees for arguments sake). In the image below, polyline A would pass this test, but the other two examples would fail. Can anyone provide some guidance? Thanks in advance,RB 

Hello everybody,   My problem : I have a "Description" attribute which contains text with length variable. The lenght is greater than 2000 characters. For each feature of the "Description" attribute, I want to replace all spaces after every 80 characters with "LF" (new line).   So I thank use StringReplacer to write a regular expression to calculate 80 characters intervals and identify the space after each 80 characters. Then I could have replace this by LF.  I helped myself with these topics on the forum: - https://knowledge.safe.com/questions/51531/how-do-i-find-the-first-space-after-the-19th-chara.html  - https://knowledge.safe.com/questions/51514/splitting-attributes-by-number-of-words.html  - https://knowledge.safe.com/questions/40715/count-the-number-of-characters-and-numbers-in-a-gi.html   But I d'ont success it. Maybe I don't really understand explanations....   Do you have any leads ?   Thank you so much !      

Hello,I'm trying to read an OCRd pdf_text attribute and get the text between 2 lines.My regexp is (?=Detail : Verbruik vaste telefonie ).*(?=Detail : Verbruik mobiele telefonie )but my result is strangeIt does not end on "Detail : Verbruik Mobiele telefonie". Is there an error in the RegExp?

Hi,I have different councils Pipe material list with a specific example of say Copper – which different council has a different way to define it.. say for example one council called it “CU”, other council calls it “COP” and some other councils call it with some other name…however, the material is the same…and in general we want to define a common name for it..... say "Copper"? Can we create a data dictionary in FME?...which can identify and recognize the correct name and replace it with a generic name?  

Hi,I have birth days in this format YYYY-MM-DD.I want to calculate their ages.Per exemple, someone born 1950-03-28 would be 70 years old.Not sure how to do that. Any idea?Thanks

Hi, I'm using a FeatureWriter to export a bunch of data from an SDE Geodatabase to Shapefile format. The final product is not including the .sbn and .sbx files. Is there a way the FeatureWriter can include those files, or some other Transformer I can use?? Thanks, 

Hello Just need some guidance:  I'm currently using SystemCaller + AttributeFilter (0 & 1 for error logging) as a workspace to run a batch file daily which does the following:- Delete existing log files- Create WinScp log file- After setting some variables then log in to SFTP server using WinSCP commands- Upload a file, check its existence on remote server and if exist then upload the respective ".Done" empty file from local server. Exit with Code 0. If failure then abort and always exit with Code 1.- Catch error in case of failure and output it to error.txt (it will tell me which file failed)- Script repeats the same process for the remaining 4 datasets.E-mailer attached to attribute filter 1That's working. I want to:Option 1Use automation to achieve the same result albeit SFTP "External Action" fails to validate the connection and states "Invalid - Path not found". For now I've given up on trying to understand so will skip that option.Opt

Hi - I am experiencing a strange error when attempting to update the same table twice which I have narrowed down to be a connection lock or something similar. This is a part of my workbench which updates a timestamps table in SQL Server. Incoming to each of these executes effectively at the same time.If I disable either one - I am able to update the table with no issues so I have isolated any configuration of the writers.I have increased timeouts etc. and no luck. Doesn't look to be related to this. These queries only take a sec or so to run but looks like a connection locking issue. I am running SQL Server 2019.Any ideas what could be causing this? Both of the FeatureWriters using the same connection - SQL Server Non-Spatial Writer.ThanksError - 2020-06-08 19:58:07| 2.6|  0.0|INFORM|Microsoft SQL Server Non-Spatial Writer: Trying to connect using Microsoft OLE DB Driver for SQL Server...2020-06-08 19:58:37| 2.7|  0.0|WARN  |Microsoft SQL Server Non-Spatial Writer: Failed to write a fe

Hello.I'm working on FME workbench 2014. I stumbled upon an issue when creating a writer. It seems like I can't put in a name of an user attribute that has more than 10 characters. If I put in a longer name, FME automatically reduces it to 10. Is there a way to fix this?Regards,Bjorn M

Hi! I hope you can help with this very basic problem of mine..(although too much to handle for me). So, what I want to do is load data into a sde database. It´s annotations, in coverage format. And what I have seen so far of the result when I only use a simple ”in-data to out-data”-workspace in FME is that the texts don´t end up in a correct way. There are overlaps for example. Then I thought that the only way to do it correctly is with the ”Import Coverage”-tool in ArcGIS. So I created a simple Model Builder model which I then exported to a python script. Below is a screen shot of the model and further down is the script. Script from model export:# Import arcpy moduleimport arcpy # Local variables:tx_24_annotation_tx_24 = "D:\\\\Vagkarta\\\\Shape\\\\vk_24_Sweref_99_TM_shape\\\\vagk\\\\24\\\\tx_24\\\\annotation.tx_24"tx_25_annotation_tx_25 = "D:\\\\Vagkarta\\\\Shape\\\\vk_25_Sweref_99_TM_shape\\\\vagk\\\\25\\\\tx_25\\\\annotation.tx_25"sde_gsd_GNG_vk_tx_anno_modelb