Best Answers

We are trying to set up an AWS SQS and are hitting an issue when trying to send a message to the queue.  The following warning is being displayed "The request must contain the parameter MessageGroupId". We have tried adding this in to the message attributes along with the value we have but still no luck. We can manually create a message using the AWS console and can also get a response in FME using the SQS Message Counter so credentials etc. are correct.  Has anyone hit this issue before? Any help would be appreciated.@olivermorris

Hi all,I'm the version FME 2018 build 18284 Windows and when I write the name of transformer ProjectWiseConnector, doens't show Help information.Whats is the reason?Thanks,Danilo

What am I missing here?I'm using FME 20180926 - build 18552 if that matters.I want to merge two data streams in the Feature Merger and I know that there are duplicate suppliers so I've marked the "Process duplicate suppliers" option. Still the complete merged data isn't output on the "Merged" port as it should be. Here's an example script.Here's my example data:Here's a screenshot of the script after I've run it once:Here's a screenshot of the transformer settings:What exactly am I missing here? I've tried both with my regular data that I want to handle and this example data and I just can't get it to work as I expect. As far as I can tell none of the settings under "Process duplicate suppliers" matter when you're only using data and no geometry.

Our script log files say INFORM|ArcSDE release: '10.0'. Underlying database: 'Oracle' We are running SDE 10.6.1 and our SDE.VERSION table shows the database as 10.6.1. I am wondering if there is something in our geodatabase that hasn't been updated correctly.

Question: Is it possible to have FME write .ovr files with a GeoTIFF (Georeferenced Tagged Image File Format) writer? The Solution I am hoping for:An FME solution for writing .ovr pyramid files2nd best would be solutions to the Python/ArcPy errors I'm getting when running ArcGIS geoprocessing tools3rd best would be another plan for writing .ovr files.My Software:Safe: FME(R) 2018.1.0.3 (20180926 - Build 18552 - WIN64)Esri: ArcGIS desktop 10.6.1 version 10.6.1.9270 with Background Geoprocessing (64-Bit)Basic Background:I am developing a process for a couple thousand tiff images that will be used in ArcGIS (it's not relevant but I'm using a parent workspace with WorkspaceRunner to run this child workspace). Ideally my FME workspace would write GeoTIFF images with pyramids in a format read by ArcGIS (apparently its an .ovr file), that way the features written are a final product for use in ArcMap. The Issue I am having:My problem is that I am not able to get the GeoTIFF writer's "Generate

Hi,Is it possible to set RasterReplacer raster format from attribute value ?Raster format has already been detected and saved in an csv file with raster filename.i want to read this csv file resample raster and save it.thanks in advance 

Hi,On the FME Server trial download page, if I choose the win-64 option, my browser starts downloading FME Server 2017.1.2.1-b17725. But reading the Licensing Walk-Through, I get the impression that I can request a trial license for any version of FME Server starting from main version 2016 and later versions.Question; Will I be able to download and install FME Server 2018.1 from the customer download page, and request a 60-day trial license for my FME Server 2018.1 installation by following the steps in the Licensing Walk-Through? Or are 60-day trials only available for FME Server 2017.1.2.1-b17725 specifically? 

Hi, I am trying to apply texture for the building , it looks fine in FME inspector . If I try to open in FZK Viewer texture is not applied to the building. I also set the texture property in FZK viewer to "Entity".Please find the relative snapshots. 

Building an xml with XMLTemplater transformer, some attributes are lists where some element may not exist.For example, I have contact information for 3 organizations and some may not have an individual name:contact{0}.CI_ResponsibleParty.organisationName.CharacterString contact{0}.CI_ResponsibleParty.individualName.CharacterString contact{0}.CI_ResponsibleParty.contactInfo.CI_Contact.phone.CI_Telephone.voice.CharacterString contact{1}.CI_ResponsibleParty.organisationName.CharacterString contact{1}.CI_ResponsibleParty.contactInfo.CI_Contact.phone.CI_Telephone.voice.CharacterString contact{2}.CI_ResponsibleParty.organisationName.CharacterString contact{2}.CI_ResponsibleParty.individualName.CharacterString contact{2}.CI_ResponsibleParty.contactInfo.CI_Contact.phone.CI_Telephone.voice.CharacterString To populate the xml with a contact block for each organization I do this:{ let $individualName := fme:get-list-attribute("contact{}.CI_ResponsibleParty.individualName.CharacterString&quot

Hello there II have an attribute with the values like this (24 16 17.2) or this ( 25 7 17.2) we need to replace the first space with a letter A and second space with letter B and add letter W at the end we should get a result like this (24A16B17.2W) and this ( 25A7B17.2W) for the second caseAny idea, please Thanks 

Hi,Each time I tried to read an SQL database and include a where clause statement in the reader the FME was fails to do so, even when I tested the statement it was running successfully see below.Does any one know how could id solve this error? The error as the following:2018-11-22 16:31:29| 1.8| 0.0|INFORM|FME API version of module 'VertexCreatorFactory' matches current internal version (3.8 20180604)2018-11-22 16:31:30| 1.9| 0.1|ERROR |Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `SELECT [BBSId], [ID], [Entity/Observation], [Observation Date], [Observation Type], [Severity of Observation], [Performed By], [EmployeeID], [Person Observed], [CONT_SVC_PROVIDER], [Not Listed], [CONT_SVC_PROVIDER_Name], [Name_Third_P_Inv], [Group Type], [Safe], [At Risk], [Description], [Longitude], [Latitude], [Location], [OrgAxisId], [Reference], [Workplace Activity], [Offline_CONT_SVC_PROVIDER], [Behaviours], [Company], [Platform], [Crea

Hello, I have an entrance like this.   I would like an exit like this.  How to do it ? with the transform AttributeSplitter ?  Thank you

Hello:(apologies if this is a double post. I wrote it and then signed in)I'm learning FME and APIs and have been trying to use httpcaller to retreive information from an API and convert the information into excel columns. I've figured out the httpcaller portion, but I end up with an excel file with a single column that contains all of the data for each row instead of separating each bit of data into their own columns.Any ideas on how to take the httpcaller API JSON output and convert it into a usable excel sheet? Current sample output is below.Thanks!

Workbench Flow:1. Download files from Source FTP Server to an attribute in FTPCaller.2. Upload these files from attribute to Destination FTP Server .Files in destination getting corrupted. Attached is the workbench & FME log showing more data is uploaded that downloaded for that file. File type tested are .mdb & .zipPlease advise if someone came across such issue.Thanks.

Hey there,I recently tried to run a workspace I created a month ago where I download the latest Sentinel-2 image via the FeatureReader (Sentinel-2 on AWS format) based on an intersection with a shape file. The workspace used to work out fine.Now, the workspace fails early at the FeatureReader with the following error message:Imagery on AWS Reader: Error listing 'http://sentinel-s2-l1c.s3.amazonaws.com/?delimiter=/&prefix;=tiles/32/U/MC/'. Check the reader filters or try again later. The error was 'FMEException: 931363: Imagery on AWS Reader: Error downloading 'http://sentinel-s2-l1c.s3.amazonaws.com/?delimiter=/&prefix;=tiles/32/U/MC/'. Check the reader filters or try again later. The error was '403 Client Error: Forbidden for url: http://sentinel-s2-l1c.s3.amazonaws.com/?delimiter=/&prefix;=tiles/32/U/MC/''Does anyone encountered the same error message? Is it possible that the imagery downloading service is temporarily unavailable or did it changed the permissions (regardi

I have a dataset with various depth zones that I am trying to process by running a DonutHoleExtractor, then removing some of the polygons that I don’t want based on certain rules and lastly rebuilding it all with a DonutBuilder. This works fine for the depth zones but some of the areas that are land, white in the maps below, get turned into depth zones. This is not surprising, but I would like to find a workaround. I looked at using the holes from the DHExtractor to punch holes in the last step, but the ”land holes” get the attribute data from their surrounding depth zone, so I have not found a way to single them out.  Any ideas to how exlude certain areas when extracting donuts? Or maybe you have a better idea for a workaround?  Please note that this is a follow up question to, https://knowledge.safe.com/questions/81896/selecting-square-ish-donuts.html  The brown map is the original data and the green one is after DonutHoleExtractor

Hello,I create the feature class il a gdb automatically every night. I need to fill up the item description in the same time. Thank youBest regards

I'm trying to write postgres data from to a new schema. The table I'm reading has a unique constraint on two columns like this: CREATE TABLE public.real_right(    share_numerator smallint,    share_denominator smallint,    upi character varying(50) COLLATE pg_catalog."default" NOT NULL,    party_id character varying(100) COLLATE pg_catalog."default" NOT NULL,    is_deleted boolean,    CONSTRAINT "PK_REAL_RIGHT" PRIMARY KEY (upi, party_id))WITH (    OIDS = FALSE)TABLESPACE pg_default;If I take a look at the reader it shows me only a primary key at upiWhen I use Table definition: Copy from Reader ...Then the bulk data load fails because of the primary key violation.So the question is: Does the postgres reader supports multiple key constraints?And is there a workaround?thanks in advance

I have a very simple workspace. A DTED reader which is set to read a few thousand .dt0 files. This feeds into a Sorter transformer, which sorts alphabetically on fme_dataset, and finally outputs to an Inspector When exactly 506 features have entered the Sorter, all subseqent features gives the errorERROR |DTED Plugin: Failed to open file Z:\raw\Elevation\Global\DTED0\dted\e016\s05.dt0.WARN  |MULTI_READER(DTED_1): Skipping to next Readerand only the first 506 features are output from the Sorter. This happens regardless of which .dt0 files are read, the limit is always 506 features.This seems like a bug in the DTED reader to me, because a DEM reader does not give the same error.I'm using FME 2018.1.0.0

I am reading a large ECW file and clipping out a section then writing it to ECW again. Does anyone know how FME manages ECW compression. The writer by default is set to 75% compression but the ECW file is already compressed. Does the writer honour the original compression settings or is it further compressing a compressed file? Should I set compression to 0%? Also I can't seem to find a concise answer on whether FME now handles ECW v3 images?

I have a google sheet I am trying to read in that has Timestamp as an attribute, mm/dd/yyyy hh:mm:ss. I want to only read in those features that fall between provided dates and time - say the records between 09/22/2018 12:00:00 to 10/22/2018 12:00:00. This time range will change each month. This all feeds to a monthly report but the google sheet is cumulative.Is there a way to create a user parameter to read in only the dates wanted?The other problem I have is that the reader does not appear to be reading the Timestamp as a date-time format although it is formatted that way in the sheet. Right now I am using a Tester after the reader and set the mode to date/time. When reading the data, the Tester shows "Unable to do a date/time comparison... Comparing as strings instead". None of the records pass the Tester, 74 of them should have passed. How can I set the Timestamp attribute to be read and processed as date-time?

Hi FME experts,I have a number of text files that looks like this (attached). I would like to extract the numbers and store them into different attributes to process them further.A 468832.92042276752B 7175381.1634021383C 2829D 388What is the best way to approach this? So far, I tried unsuccessfully using attributesplitter, substringextractorI tried wresting with regex For instance, the following expression returns \\((.*)\\,everything in between the first ( and the last , but how can I extract each string separately?Many thanks in advance. !table !version 300 !charset WindowsLatin1Definition Table File "a2.jpg" Type "RASTER" (468832.92042276752,7175381.1634021383) (2829,388) Label "Pt 1", (468991.81894034828,7175225.3923977558) (4127,1684) Label "Pt 2", (468917.96947360213,7175142.166946603) (3520,2370) Label "Pt 3", (468878.98707272188,7175056.807626294) (3195,3063) Label "Pt 4", (468691.66407155019,7175209.7422

I've got a table with POSTCODE_FROM and a POSTCODE_TO attributes, constituting several alphanumeric ranges, for example:(from) 7887AA (to) 7887AA(from) 7887AB (to) 7887AC(from) 7887AD (to) 7887AJ(from) 7887AK (to) 7887BBEach feature has a FROM and a TO value and I would like to determine all in-between values, e.g. 7887AE, 7887AF, 7887AG, 7887AH, 7887AI. Does anyone know what (sequences of) transformers are capable of doing this?

Hello:I have an issue that I can't seem to understand. I'm new to JSON (in fact this is the first json output I've ever created). I have a structure that has a ROOT and SUB. The JSONTemplater says my current structure is valid and produces the file. However, when I run it through https://jsonlint.com/ the results are invalid. So, I looked at the output of what another area is expecting and I manually modified the file to see if the updates I made were valid. The short of it is, I need to modify what's in my JSONTemplater to add a comma (,) before each NEW record and add brackets ([ ]) around the entire output file. EVERY attempt I've made in modify the JSONTemplater has failed or I get an error. I'm loosing it! :) I've attached the file I manually revised and the one from the actual results of the workspace. Can someone tell me what's wrong with my JSONTemplater? ROOT Structure:{   "totalInvestment": xs:double(fme:get-attribute("tota

Is it possible to read constant properties from an Autocad block?Constant properties are never changing in a block and can be displayed. This is an example:It shows 1 block, with some dynamic attributes ('12 345'). The 'N' is a constant property, so there is no attribute defining it.My questions is: is there somehow a way to read this information?I am aware it is possible to explode the block and extract this autocad_text entity, but that is not the solution I am after.