Best Answers

Hi all, As the title says I need to expose the basename or file name for multiple PDF files I read with FeatureReader. Seems there is no way to expose PDF attributes neither in the PDF reader or FeatureReader where PDF is selected as format?  I use a directory reader to make a list of Word documents that I convert to PDF using an external program and then pass the file name + pdf extension to the FeatureReader. However I'm stranded if I don't find a way to indentifying my input files.  Thanks!  /Jacob  

When I set the WorkspaceRunner Number of Workspaces per FME Process parameter the last batch isn't run. For example if I set the value to 10 and there are 42 items to process then only the first 40 are processed. I have created simple Parent/Child workspaces that demonstrate the problem.I am using the latest Mac build of 2019.FME Desktop 2019.2.2 for 64-bit Mac OS XBuild 19817 / January 7th, 2020.

Hi there!I'm trying to get a Regex search and replace going but my poor regex skills are letting me down. I'm trying to obtain the first 3 (or 4) digits in an existing attribute string and into a new attribute using the StringReplacer but can't get the right formula. I only want the first set of numeric values.PS. I'm sure this can be done in a single AttributeCreator transformer using a string function too? Any help would be appreciated!

Hello,i was succesfull with static R script insede RCaller transformer. But, when i try to include some FME parametres insede R script like this:kr = autoKrige(h~1, new_data = grid, input_data = measures, nmax = $(NMAX), maxdist = $(MAXDIST))I got this error:Error: unexpected '$' in:So this is clear syntax error message complaining about $ inside that script. But is there way how can I pass FME parameters to R script inside RCaller?

Hi, I tried to find a way to change the ownership of an item in FME Server using REST API. There seems to be no possibility?

Hello everyone,I have a little problem with the densitycalculator transformer.Here are the details : - I want to have the density of a road network into a 1000m*1000m grid- I've followed the documentation of the densitycalculator transformer and I don't have any results (all the densities are set to 0 in my results)- I also made a "group by" into the densitycalculator to have the count of road density for each cell of my grid... Do you have any ideas to help me ? Thanks ! :)

Hi! I have an Excel file with ID numbers of different train stops, 20 of them. I wanted to find all DWG files that are in the subfolder Z\\Modell\\.*03.dwg but it takes around 1 h to run, at this point is it faster just to find them manually and run the workspace. Is there any way to improve the search time? The "root" folder is a drive, but all files are within a folder is called "4\\_CAD" so I limit the search to only the subfolders of my starting folder. Trying to make it faster my only use the subfolder I know contain the other folders and files.I was thinking maybe change it to have 2 feature writers after eachother instead, one that only searches for the correct folder then look for the files within the found folders. Change allowed path type to only folders then only files. Other suggestions?Also I figured if I have 60 subfolders, for every feature read it will look in all 60 of them 20 times over, that's probably why it takes such a long time, is there a

I have a sphere geometry floating in the air. When using CE and CPE (both options Boundingbox and Gravity produce the same result), I end up with different XYZ coordinates, with CPE being apparently correct. Why does this happen?  Edit: furthermore, when I use the Offsetter with the CPE-Coordinates to offset the sphere as well as the coordinate to 0/0/0, the sphere doesn't move to the expected spot either. See screenshots:(transparent grid: Hub3DBufferer) 

License server runs on a Windows machine. We have 20 floating licenses. When a user tries to borrow a license from within Workbench we get the following message (both on pc and Mac)

Hi all,A very dumb question: below part gives me what I wanted which is to copy a file from a folder to another location. But how do I control the sequence so that this part is executed first, and then go to other part of the scripts. I meant both "Path" and "FileCopy" don't have a connector (to connect to previous step or to the next step after these are done).

Only Identified End with Upper case latter For example identified below highlighted yellow color indicated words wordsNameIdentification 2 A 2 A 3 D 3 Dhbsv 5 G hbsv 5 G g 6 Gsgdsgg 6 Gsgdsgt 56 Fgdsgt 56 Fgdsgtd 9 Dtd 9 D

Hi, I want to access the property sets a of a dwg in FME.I enabled the 'Civil 3D and CAD Entities' option in the Schema Mode of the Civil 3D Reader.When i attach an inspector to the reader, I get a fatal error.AutoCAD Reader: An error occurred for dataset 'C:\\Users\\wisbeja\\Documents\\AWV\\FME voor dataconversie DAVIE\\voorbeeld data\\DWG solid and prop set\\small_test.dwg', in function AutoCAD2004Reader::read. Exception thrown: 'Invalid ResBuf' (Invalid ResBuf)A fatal error has occurred. Check the logfile above for detailsdwg file is attached.When I read the dwg with a dxf/dwg reader the inspector works. But I guess I am not able to access the property sets with this reader. Any suggestions? Jasper

Hello We have for security reasons to migrate the application Safe Safe FME Desktop 2016 to our new license server (Windows Server 2016 in the cloud) Questions: 1) what are the steps to installation Safe FME Desktop 2016 on the new Windows Server 2016?2) do we have first to deactivate Safe FME Desktop 2016 on the old Windows Server 2008R or to stop it?3) do You have a documentation for these tasks? Kind regardsPascal BilatEmail:  

I have a workbench to look at changes between a new worksheet and an old worksheet. These data populate three tabs in a workbook: "changed", "deleted", "updated". The intial run populated the deleted tab with a few records that had been deleted. I re-ran the workbench with matching data and the "deleted data" remained on the deleted tab. I would like the data on the tabs to be overwritten each time.

I want to export some data to gml, and I see that I have some complex geometries, which results in different sets of coordinates for each polygon (after geometry extractor). I made a list and each element within the list contains the set of coordinates for each segment of the geometry, but not all the polygons have the extra dimensions. Therefore, I want to make an if-statement where only the extra xml-statement is shown when there is data in the list. I tried using this, but it does not work. Can anybody point out an error in the statement.Not only the line with the statement posList..., but also the other statements around them, I want to delete when the list element is not existing.   If there is another way of doing this (e.g. with a loop), I am open to suggestions. </gml:exterior>  If {(fme:has-attribute("interior_xy_l{0}.part")) then (  <gml:exterior>  <gml:LinearRing>  <gml:posList&g

Hi all,  I have been using a workbench to read in a geodatabase and clip the features to a particular extent then export out to a DWG. However the requirements have recently changed and we need to split the DWG output into multiple smaller files based on 1km tiles. So here is what I am trying to do essentially. Take the geodatabase, use a grid to split the geodatabase features into individual tiles and save each tile as a seperate DWG. So NZ4920, NZ4921 etc. I feel like this should be quite simple to do but I can't find how to do it. One long workaround would be to use the 'clipper' transformer for each individual tile, which would give me result I want but I would have to do this for about 100 tiles, and I am sure there is a more effecient way to do this.  Any help is appreciatedThanksDan

Hello, I've updated FME server V2018 to V2019.2.3Unfortunately nou the scheduling does not run. There are no scheduled tasks in the que.If I manually start a job at the server it appears in the que but does not run at all.Wich services are responsble for the schedular. Do they have to run with SYSTEM?Or do all the services have to run with SYSTEM? thanks for your reply 

Hi, I'm having trouble connecting to a public S3 bucket. I have a file i would like to download from this bucket however when configuring the S3 connector transformer I get the error message 'NoneType' object has no attribute 'lower'. I have upgraded the transformer and i'm using FME 2019.1. Screen shots of the configuration  and translation log error message below.Any help or guidance greatly appreciated.   File "contextlib.py", line 112, in __enter__  File "C:\Program Files\FME 2019\python\pypac\api.py", line 273, in pac_context_for_url    pac = get_pac()  File "C:\Program Files\FME 2019\python\pypac\api.py", line 57, in get_pac    return PACFile(downloaded_pac, **kwargs)  File "C:\Program Files\FME 2019\python\pypac\parser.py", line 62, in __init__    context.FindProxyForURL('/', '0.0.0.0')  File "C:\Program Files\FME 2019\python\js2py\base.py", line 1120, in __call__    return to_python(parent._obj.callprop(meth, *args))  File "C:\Program Files\FME 2019\python\js2py\base.py", line 

Hello !I'm looking for a way to spatially sample a set of points (not a point cloud) in FME.I want for the dataset on the following picture that all points must be a least a 10 meters from another one (by deleting the ones that are too close) because I have a too high density of geometry.There is the "sampler" but it works on random selection and not on spatial constraint rule...I've found a homemade technique to achieve that on the principle of the use of a succession of regular grids, spatial filter and counter to filter and delete some points. But the problem is that require a lot of time to run on large areas and it's not really optimized. I think there is an easy way to do the sampling operation on this type of data but I didn't found it (like we easily do it on point cloud). Do you have an idea of how can I proceed? Is there a specific transformer to do it ? 

Hi There,I am using the JSON templater to create various JSON outputs. One of them is them is "Position" which consists of two decimal / float values - XCOORD and YCOORD. I can use either of the following to output the values:"POSITION":[fme:get-attribute("X_COORD"),fme:get-attribute("Y_COORD")] OR"POSITION":[fme:get-list-attribute("_XY_LIST{}.XY_List_Creator")] (this is a list I have created with the co-ord pair)The issue is, that my JSON schema expects the "POSITION" value to be a numeric JSON array, but no matter how I write out the XCOORD and YCOORD values, it always appears as a string eg."POSITION" : [ "515000.00", "188000.00" ]I've made sure the individual values are indeed numeric. Right before the templator they are coded as UTF-8 - not sure what it is doing to convert it to a string.i've even tried using a Math function to convert in line but with no luck:"POSITION

Dear FME community,I have a CSV file containing points (longitude and latitude for properties) and a neighborhood shape file containing nested polygons. There are three types of the polygons from the smallest to the largest: Sub-neighborhood, Neighborhood and Macro-neighborhood.I would like to join the points to the polygons and append only one polygon ID to each property. If a property falls within multiple nested polygons, I would like to get the ID from the smallest polygon. For example, if a property is in a Sub-neighborhood which is nested in a Neighborhood, the Sub-neighborhood ID should be appended to the CSV file.Currently, I am using the PointOnAreaOverlayer, and I always get the IDs from the largest polygons when there are multiple polygons matched.Which transformers should I use to always get the IDs from the smallest polygons (based on the polygon type) when there are multiple polygons matched?I appreciate your help.Thao 

Hi, Is it possible to download/read an excel file from SharePoint? I can read the contents of the site using the SharePoint list reader, but unsure if I can then actually read a spreadsheet stored there?  Thanks, Sam

I am attempting to use the arcpy module in the python caller transformer in FME workbench 2019. I am using 64 bit FME 2019.1 build (19643), ArcGIS Desktop 10.6.1 with 64 bit background processing installed. I am wondering if there are any suggestions to getting my workbench to successfully access the arcpy module so I can use Esri GP tools inside my PythonCaller transformer. I have tried the following settings for preferred python interpreter and python home:when using this setting it appears that it defaults to FME Python 3.7, the following messages appear to show this in my translation log:0.0|INFORM|Loaded module 'PythonFactory' from file 'C:\Program Files\FME_2019.1.3.1\plugins/PythonFactory.dll'0.0|INFORM|FME API version of module 'PythonFactory' matches current internal version (3.8 20190621)0.0|INFORM|Using Python interpreter from `C:\Program Files\FME_2019.1.3.1\fmepython37\python37.dll' with PYTHONHOME `C:\Program Files\FME_2019.1.3.1\fmepython37'0.0|INFORM|Python version 3.7 

I have a workspace that is trying to upload a bytearray into an existing PostGIS table, into a ByteA column. The data is generated in a python caller.Using INSERT, this works fine. There is no problem, and the resulting data can be read from a different client as expected.However, using UPDATE it fails, stating:Error executing SQL command ('update "public"."mesh_test" set "ogc_fid" = 694,"mesh" = E'\003\000\000\000\212\032\005H\004\362\336H33C@g\032\005H&\362\336H\205\353\021@\354\031\005H\004\362\336H\205\353\021@\001\000\000\000\000\000\000\000\002\000\000\000\001\000\000\000' WHERE "ogc_fid" = E'694''): 'ERROR:  invalid byte sequence for encoding "UTF8": 0x00I can circumvent the error by encoding it into base64, but that yields data I can't interpret from another client.It seems that the update statement is done using a different method than the insert statement, which is odd. Has anyone seen this before?EDIT: Added example workspace, plus sqlfile to create and populate table. Y

Hi,Unfortunately I am still forced to use FME 2014. A lot of webservices that I frequently use have now moved to TLS 1.2, and I find that FME won't connect to them anymore, returning an error "SSL connect error".Based on this: https://knowledge.safe.com/questions/73167/what-http-client-does-the-httpcaller-use.htmlIt looks like the version of FME shouldn't be a problem, since FME uses what the OS provides (in which case I need to get my sysadmin working - we're on Windows 10). But based on this:https://knowledge.safe.com/questions/85353/esris-arcgis-online-is-removing-support-for-tls-11.html It might not be supported, although this sentence "FME has supported TLS 1.2-based connections to ArcGIS Online starting with FME 2015.1.1" could also reference AGOL instead of TLS, I'm not sure about that.Can anyone clarify for me what the problem could be? If the upgrade is the only solution, then I'm out of luck for at least the next few months I'm afra