Best Answers

Hello everyone,I have a workspace where I'm trying to extract the two different 'styles' out of two attributes. In both attributes there are some strings that have 9 values, and some that have 11. I tried to use a TestFilter to extract these four separate styles into their own output. I've attached a photo of the statements I used. One problem I was noticing was that there was no attributes being cached at one of the outputs, even though the prior transformer output had the attributes present. Inspecting some of the cached features seems to be misleading, and sometimes shows missing values. Could someone tell me what I'm doing wrong? I can attach the workspace if needed. Thanks,Reid

I have a user that requires a non-spatial SQL Server Table provided to them as a Tab Separated CSV file. I have found the CSV writer, but cannot find an option to output as tab separated instead of the Comma Separated.Does anyone know if this is possible?Thanks very much for your time.Cheers

Hello!I've been having some issues with the cumulative output from StatisticsCalculator - it seems to be giving me the complete sum rather than cumulative sum of the chosen attribute. Simplified example:Anyone come across similar issues? Suspect this might be a bug.Cheers!

Hi FME'erI have created a shape file of crime data and I also have a boundary shape file of the neighborhood. I want to create a heat map to analyze which neighborhood has the most number of crimes for which i will be needing the count of total number of crimes that have taken place in that particular neighborhood. But i don't know how should I proceed to be able to do a spatial join and to calculate the count of crime points in each neighborhood polygon such that the output polygon will have an attribute field of the sum of the crime count. Any help and guidance will be much appreciated. Thanks in advance

Hi all. I'd like to populate a new attribute D with attribute C value from a feature of my table, where its attribute B is the same as attribute A of my target feature. So attr D and A, target feature, attr B and C referent feature. Is it possible? Im use to work with 2 readers, not sure how to do it with one. Many thanks!

Hi,I want to convert 1000 jpeg files to pdf format. I have almost managed to finish the script but the one thing that i smissing is that the PDFpageformatter that I am using cannot be adjusted for each jpeg picture. What I am trying to say here is that i want the pdf to be the same extent as the jpg file without doing this manually (since I need to convert 1000 files).Heres a picture of my script in FME

I try to extract values from a Postgresql 12 DB (to populate another pg table) by matching a feature attribute."pk_numart" (column)"editor"."articles" (schema.table)"codarticle" (column) The query : SELECT "pk_numart" FROM "editor"."articles" WHERE "codarticle" = @Value(Mesure) Then I get the following error : Executing custom data query: 'SELECT "pk_numart" FROM "editor"."articles" WHERE "codarticle" = 13.E'Error executing SQL command ('declare "editor_custom_query_crsr" cursor for SELECT "pk_numart" FROM "editor"."articles" WHERE "codarticle" = 13.E'): 'ERREUR:  erreur de syntaxe sur ou près de « E »LINE 1: ...k_numart" FROM "editor"."articles" WHERE "codarticle" = 13.ESeems that the point causes the query to fail. I've tried several combinations, with or without hyphen before query or delimiter, but still no luck. Thanks already for any help.

Hi there,I want to convert an attribute so it always has four digits, and two decimal places. As an example, if I have . 6.5 as the source, I want the output as 06.50.I've used the expression 04.2f in a string formatter, but this doesn't seem to be working for all of my attributesAs an example if my source attribute is 50.7, it recognizes the format and the output is 50.70. But if I have an attribute with one single digit before the decimal place like 7.28 the output is still 7.28 and not 07.28Let me know if you can help.-Reid

Hello everyone, I need help. I got excel with data that looks like this picture. So, I have two blocks in excel name "CR" and "M". I need to compare attribute "Ownerstag" from block "M" to attribute "Location" from block "CR" and if they are the same then I need to write values from attribute M (column J) from block "M" in attribute "Location" from block "CR". Thanks in advance.

Hi, I attempted to use SchemaMapper for the migration of data. In general successful, however, in the Mapping Excelsheet I defined a rule to add an attribute, which uses a string function in the "NewValue" column. I can use the functions @Timestamp and @Value, however, the functions @ReplaceString or @ReplaceRegEx fail, and FME (2017.1 build 17652) is complaining "This FME edition does not recognize the `ReplaceRegEx' function." Is there a list of functions available that are recognized by SchemaMapper? The functions work fine from e.g. AttributeCreator.

Hello,I used FME Workbench 2017 to generate an IfcSpaces from shape file with footprint polygon and height information. I managed to create space geometry but I could not create longitude and latitude for IfcSite. These values were empty ($). Is there a way to fill theses values with FME Workbench 2009 ? Knowing that today I use a not very powerful method which consist in replacing the text of the end line of IfcSite definition : .ELEMENT.,$,$,$,$,$) by another one with right values : .ELEMENT.,(42,45,2,206849),(0,-25,-12,-380875),0.,$,$) Or perhaps is there a way to write ifc_object_placement for IfcSite which could be another solution to have correct placement ?? Thank you in advance for your help Best regards Bruno

Hi,Soon I will migrate the graphical data (shape and Oracle Spatial) to the ArcGIS feature class on SAP HANA (ArcGIS Pro 2.4). This test migration should be done with FME Desktop Workbenches and the productive migration from FME Server. Question: In case of using FME Desktop Workbenches, must ArcGIS Pro software be installed on the computer or are there workarounds (copy DLL's,...)?Any feedback would be appreciatedThanks and many greetingsEwelina

I have a dynamically generated list called comments as shown below using json templater and sql creator transformers. List contains several objects and I want to generate id for every object as one of the attribute of the same object.I also want to set an attribute called solution as a boolean true or false. But the attribute lies inside the object and cant set its data type. Is there any solution for this? I am transferring the data to Mongodb by creating a json file from sql based data.Capture4.PNG JSON Templater code 2 is -[fme:get-json-list-attribute("_list{}.commentObj")]Here after mearging data from Oracle and Mongodb in Feature mearger, I am creating a json object using first json templater using below code -First JSON Templater code -{"user": {"user":fme:get-attribute("TKT_NOTESUSER"), "username":fme:get-attribute("fullname_notesuser"), "_id":fme:get-attribute("mongodb_id") },&qu

Hello, let's say that I have 2 queues:  DefaultTest each of them has priority set to 5.  And I have 2 engines, each one has both queues assigned. Both engines are in use at the moment. In which order new jobs will be taken? I performed some tests and it wasn't taken based on jobid (this was my assumption).   Lets sayd that in queue there are jobs: JobId Queue 10 Default 11Test 12Default 13Default 14Test 15Default  

Hello,Within the user parameter, with a type of Choice with alias (Multiple), is it possible to retrieve the display name AND the value into an attribute?   

Hello, I need help. I got input data(points) with attributes: LONGITUDE, LATITUDE, AZIMUTH, AZIMUTH RADIUS AND AZIMUTH WIDTH. I need to get output polygons that look like a pie.

I am having problems writing to I have the following workspace It reads in the following file

I was wondering if there was further documentation on the FME server database. I'm looking to create a REST service from the database that we can use in conjunction with Operations Dashboard to show statistics about FME server in real-time (specifically things such as last time a job was ran, the status of the job, errors from the job (if any), run time, etc). Currently I'm harvesting data nightly to get a summary of the performance over the day, but it would be nice to be able to create a rest service that would show all the data together without having to heavily use an FME engine to push data to ArcGIS Enterprise (Portal) or ArcGIS Online.

Hello,I'm trying to set the ground and all the building to 0 elevation in my CityGML and keep the buildings in 3d.Do you have any idea how could I do that?

I have an Excel file which has the header on the 3rd row. The first and second rows have additional information. My actual data values start from row 4. Is there any way in FME to remove the first two rows and use the 3rd row for attribute names? I have attached my example file.Thanks in advance.

Not so much a question as bringing together a few things...I'm using a Workspace Runner to call a Workspace which writes to an ESRI File Geodatabase (FGDB). In testing, I had the FGDB Feature Class open in ArcCatalog which caused the translation to fail because the target was locked. Also, the Workspace Runner was reporting success, even though the Workspace it was calling failed.There are two things here. Firstly, "Wait for job to complete" was set to "No" which meant that the Workspace Runner would report a success even if the Workspace it called failed. "No" enables you to run concurrent Workspaces which is something I did not want to do because I need to process a series of input datasets in order, not in parallel. The solution is to set "Wait for job to complete" to "Yes":http://docs.safe.com/fme/2016.1/html/FME_Desktop_Documentation/FME_Transformers/Transformers/workspacerunner.htmSecondly, the locking issue can often be

I noticed some strange behaviour while exporting some simple data to shapefile: when using the "tech preview" (writer of featurewriter) my attribute name and values are trimmed to one character...I've read this format is still under active development, but as i couldn't find it as a known issue: is this a bug or am i doing something wrong? expected output (using the 'classic' shapefilewriters): tech preview output: using FME(R) 2019.1.3.0 (20191007 - Build 19642 - WIN64)example workbench:

Hi guys,I am using FME2019 and received this in the log:Starting translation...Undefined macro `ChangeDetector_OUTPUT_UNCHANGED_MACRO' dereferenced in file `C:\\temp\\wb-xlate-1538456617178_5428'Program TerminatingTranslation FAILED.I can run a Matcher transformer with the same inputs and outputs but when I use the ChangeDetector transformer on the same inputs and outputs the error comes.Any ideas on what the issue might be?Cheers, Dave.

I'm trying to bring a geotiff into an Azure sql spatial database and it only seems to give me a polygon. Any thoughts.

Hello, I make a Workspace to import CAD Data in Oracle Spatial.  In my CAD file, i have some layer with accented character like 3.1 MP - A désaffecter.  When FME read Autocad Writer i have the error : "ACAD reader: The encoded string is not a valid fme-wwjd string: '3.1 MP - A d\\xC3\\xA9saffecter'"  In other workspace, I met same problem with parameters which contains accented character or with excel files with accented character.  Can you help me? With FME 2018, i hadn't this problem.  Thanks  Bernard Dinon