Transformers

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.

Hello, I have one dataset, the epoch time on that is approx. 5HzI have another dataset with epoch time and that is in 20Hz, it covers several different 5Hz datasetsThese two features do not share a perfect match in milliseconds.I want to merge the 5Hz attributes to the geometry of the 20Hz. NeighborFinder does not work since the 20Hz has geometry from several different datasets in close proximity.Both datasets contain timestamps which merges succesfully in FeatureMerger, however these matches are sporadic.I cannot round the milliseconds to more than 3 decimals, since that will degrade the solution of the 20Hz.I was thinking of an inlinequery with an SQL query that performs an epoch timematch based on a 0.005 second in range since that would be the unique identifier. However I do not know how to fully structure such a query. Regards,Robin

Hello everyone,I would like to move some points labels which overlaps each other. The source files is a DGN.You can see on this picture the overlapping :My wish is to move these labels so that they dont intersect each other or with the network below.I tried to parameter the transformer without success. I contacted Veremes and Safe without success too...Your are my last hope :) Thanks for your help and have a good day.BRNicolas

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

I want to read the contents of a SEGY file. FME has a SEGY reader which displays the content as Binary. I need help converting the binary content into something useful.

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 have a bunch of polygons (grid squares) and points.Each point has an attribute to qualify its type (1, 2, 3, 4...).  First I tried to create in each square an attribute with the number of points it contains.This I achieved using a PointOnAreaOverlayer. Now I want to create on each square X attributes with the number of point by type.GRID_IDTYPE1_countTYPE2_countTYPE3_count...XXXXXXX0122 YYYYYYY1122 ZZZZZZZ1284  The thing is I don't know inadvance which type I'll get. I can have types 1/2/3 one time but then 1/3/4/6.Two questions I ask myself about this: How can I ventilate the features by type not knowing in advance the different types (with the testfilter I need to know the types in advance...)How to ge

Subject says it all. Trying to determine if there's anything in it I want to test and/or evaluate.

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  

Afternoon, Does anyone know a way of calculating working days between dates? I have used the DateTimeCalculator to work out the calendar days but the department that is asking for the work to be completed are asking for working days as it is linked to processing times. Thanks in advanceDarren  

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.

Hi!I have 2 attributes, one with the value to test and one with the test.I would like to do an automatic test based on this 2 attributes in order to keep or not entities.I tried expression evaluator and attribute validator but I don't find the good syntax.Indeed, on my second attribute I could have a mathematical test like ">50" or a range like "[50-60]".It work for ">50" on expression evaluator but I don't suceed with the range.Do you have an idea?Thanks!

Hello,I'm trying to convert an IFC file into a ArcGIS webscene, via I3S. This worked fine for other models in the past, but this time, the writer crashes after using up ~27 gb of RAM.It's a tiny IFC, just some ~40 Mb. Even weirder, I can convert the IFC solids into multipatches via SHP, or GDB. Just no I3S. :(I would really appreciate some hints.

Hello,  Would anybody know if it possible to add hyperlinks to features when writing out to 3D PDF?  We have tried using the PDF Styler, but this only appears to work with 2D GeoSpatial PDFs.  Thanks  

I have several workspaces that work with Caris CSARPC Point Cloud files, I have just upgraded to v2019 64bit from 2018 32bit. I also have had an OS upgrade from win7 to win10. I know a lot of changes...When I run the workspaces now, I get an error "The error was 'Caris error: 139764: Internal error" and "Error running translation", in 2018 I don't get this and it works fine. I can't find a reference to the Caris error number anywhere, does anyone know how to find this?(Note: If I run in Cache mode and step through all transformers I don't get the error???, Also I'm writing all fme temporary files to a file share that has plenty of space) general process at start of all workspaces is:- creator- FeatureReader (CSARPC)- PointCloud Coercer- CoordinateExtractor (just extracting z value) 

Have you had the same problem with DuplicateFilter on FME 2018 I have 209/35k but on FME 2019.1 I have 12k/35k. I don't know how but it works not ok in 2019?

Hi,I have problem with FME 2018 where my workspace processing just stalls at one particular NeighborFinder transformer. The workspace has several NF transformers with fairly similar parameters, but only one is causing problems. It processes either one or none of the features after which nothing more happens, the processing just stalls.I don't get any errors, FME doesn't crash, the last line in the log is Processing base feature(s)... and even though the transformer should process the data in a couple of minutes, nothing happens even if I leave it running overnight.However the workspace runs just fine on both FME 2018 and 2018.1 (32 bit) if I reduce the processing area, but even running the workspace at full processing extent, I don't seem to have any memory issues. Furthermore, I have tried to run the same workspace on FME 2017.1 and 2019 beta (32 bit) and there I have no issues whatsoever. Is it perhaps a bug of sorts in FME 2018?The o

I am trying to find an elegant way of reading content from an AES-encrypted zip-archive which is downloaded from a trusted source.If it were not encrypted or just used cryptozip, I would just use a pythoncaller and zipfile and process the results of a httpcaller. However, zipfile within python seems to be unable to deal with aes.Is there an elegent way around this? Will I have to save the file, run 7zip through a systemcaller and read the contents?  

I need to extract the last two values for "rating" and "score" objects from the following JSON string. So I have an attribute 'rating' with value of 'Unclassified' and attribute 'score' with the value of '8.91'.[{"assessmentReference":"BREEAM-0052-9883","assetScores":{"assetScore":[{"categoryScores":{"categoryScore":[{"categoryCode":"Man","categoryName":"Management","creditsAvailable":"21.00","creditsAwarded":"5.00","score":"2.85","weighting":"12.00"},{"categoryCode":"Hea","categoryName":"Health and Wellbeing","creditsAvailable":"11.00","creditsAwarded":"0.00","score":"0.00","weighting":"15.00"},{"categoryCode":"Inn

Hi I don't understand how have to use the CCS to parse the HTML page http://www.comune.torino.it/albopretorio/alboordinanze.shtml to obtain as output a table with the 7 value (see the picture) I mean the goal is the parse the HTML page to have all value 1 in the first column the nu,ber 2 in the second column and so onthx Francesco 

Hi everyone,I've had trouble with texturing surfaces of building such as wall surfaces, roof surfaces with specific images for each surface. I used AppearanceSetter for texturing surface, and simply all the surface will have the same image texture. My question is how do I texture a number of images to their surfaces. My idea is to create two equal IDs for each surface and its image texture but I don't really know how to do it with the FME transformers. Could anyone help me with it, please? Or any new suggestion or idea will be highly appreciated.Regards,

How to install NTv2 grid files? Following the instructions at http://docs.safe.com/fme/2019.0/html/FME_Desktop_Documentation/FME_Workbench/Workbench/options_coordinate_systems.htm I've copied the `NTV2_0.GSB` file I acquired from NRCAN into "C:\\Program Files\\FME\\Reproject\\GridData\\NTv2".From FME Options I select Coordinate Systems. Now what? Which of the listed items do I edit? I tried NAD83_to_CSRS. I'm able to use the down arrow to select the NTV2_0.GSB file from previous step, but the [OK] button remains disabled.

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":

I have a workspace that kicks of a PowerShell script via a PythonCaller that kicks off another script under the context of another user. This works perfectly on my desktop but once uploaded to FME Server the second PowerShell script fails to execute. The issue arises somewhere after Start-Process begins executing. The log file to which I am redirecting output is wiped out after I write to it when I create it. This is the first thing Start-Process does when RedirectStandardError parameter is used. The problem is my second log is never created which is the first step in my second script. However, no error is produced not in the FME job log or Windows Log on the server. Has anyone tried to use Start-Process on FME Server? Are there configuration steps required by FME Server? PythonCallerclass FeatureProcessor(object): def __init__(self): self.scriptOutput = str('') process = subprocess

We have FME Server 2018 on premise (Express Installation). I am trying out the Data Streaming FME Server web service to make a .json file available to out web developer to build an app. I am having trouble getting the Data Streaming service to work. After publishing to FME Server with the Data Streaming service enabled, I can run the job and it downloads the .json file as a file download to my browser. However, I want to be able to provide a url to the web developer to be able to query by feature id, etc. for that .json data that was output. Can someone please help me to understand how to make this happen? Thank you!