Transformers

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 overview of the workspace in question:

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",&qu

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":http://docs.safe.com/fme/2016.1/html/FME_Desktop_Documentation/FME_Transformers/Transformers/workspacerunner.htmSecondly, the locking issue can often be

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.Popen(["powershell.exe",  "\\\\fileshare\\scripts\\RunAsSvcAcct.ps1"],  stdout=subprocess.PIPE) self.scr

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!

I could use help getting FME 2019.0 properly set to transform data from Canadian vertical datum 1928 to 2013.My starting points are https://knowledge.safe.com/questions/99317/adding-vertical-coordinate-systems-to-fme.html and https://knowledge.safe.com/articles/29325/creating-vertical-adjustment-grid-files-for-use-wi.html.From Safe I have downloaded and installed the extra Reprojection Grid Files.From NRCAN I have downloaded the 8 archives from Geoid Models, and unpacked to `C:\local\geo_grid_shift_files`.I see 8 .byn files:# CGVD2013 CGG2013ai08.byn         CGG2013an83.byn# CGVD28 HT2_1997.byn             HT2_2002v70.byn HT2_2010v70.byn# 1928 to 2013 conversion HT2_1997_CGG2013a.byn HT2_2002v70_CGG2013a.byn HT2_2010v70_CGG2013a.byn3 of these are already present in FME Reproject folder treeCGG2013a - CSRS and ITRF versions (CGG2013n83 & CGG2013i08 respectively) HT2_1997 - FME has it, though using the old name of HT2_0 according to a note on GPS-H page (ref). I understand the next s

i want a way to get the wrong coordinates (example : easting 3628623.38(7) digits and northing 4565105.96(7) digits to be comes as rejected output and the others which needs to b swap between x column and y column

I’m trying to convert a SWG (CAD) file to import it into Blender. When I run the program, in FME, nothing actually saves to the target folder, even though it says that it has been saved. How would I go about doing this?

Hi all,I have a question about the PDFpageformatter. I generated a point using a creator (with coordinates 0 0) and used a textadder to add text to this point. The text is automatically put top right of the point. Then I use a PDFstyler to give color to the text and put this into an PDFpageformatter. In the PDFpageformatter I created a box where I want to put this text. When writing it to a PDF it seems that the text is written in the bottom on the left side. But it would be more beneficial for writing a letter if the text would start in top left. Is there a way to make sure that the PDFpageformatter will start writing text in the top left corner? 

Hello thereis there a way we could extract the mapping relation between reader and writer of a workspaceI mean, attribute name: parcels in a reader is connected to attribute name: Parcel in the writerwe need to get a report concerning those relations between writer and readerexample

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 need to extract the coordinate which are wrong and does not make sense like easting in utm should be 6 digits .because i have some coordinates in x column for example (easting = 7 digits 3628623.384 ) which is wrong it should be 6 digits. is there any way i can calculate the digits in coodinates column before the decimal point

Dear FME members,For a WebApp Viewer, I'm having the following question:How can you upload a GEOTIFF to a SQL Server Spatial, and add a new GEOTIFF to the same SQL Server Spatial file every time you run the model? Current situation: In my model (see attached file), it is possible to upload a GEOTIFF to a SQL Server Spatial file, but only once. After running the model, the GeoTIFF becomes visible in the WebApp Viewer.Next step: adding another GEOTIFF to the same SQL Server Spatial file (raster or mosaic, what works best).Now, when I select another GEOTIFF in the reader and rerun the model, there is an error saying "layer already exists."So in the ideal situation, I select another GEOTIFF, which is added to the existing SQL Server Spatial file. Now, we tried raster and mosaic. So in the end, I would like to have one SQL Server Spatial file, with all the GEOTIFF files. If there will be a new file in the future, I would like to simply add it in the same file, without adaptin

Hi everyone,Does anyone know why my query is not working?I have a SQLite database and I want to find the closest point in the database to a point. Thanks in advance!