Best Answers

ok. so there have been a lot of questions about running a workspace through the task scheduler (and the fact that it doesn't work) with running it manually.I have tried all the solutions suggested.Problem:I have a workspace that logs onto an AGOL account, retrieve the data and create an excel.I have no problem running this workspace manually when I am logged on to the server.The issue is when I schedule this to run using a service account. I get this error:ArcGIS Online Feature Service Reader: Connection 'Esri ArcGIS Online' does not exist. Check connection parameter and connection definitions in FME options and try again Solutions I've tried:(moving the data and publick key into a public location) https://knowledge.safe.com/articles/34678/making-database-and-web-connections-public.html(editing the registry) https://knowledge.safe.com/articles/32356/scheduling-software-doesnt-recognize-fme-connectio.htmlset the task to run with highest privilegesset the "Start in&q

Hello everybody!I have a process that on ine libe calculates some values and write out in a text file. On an other line a system caller usues these files as an input data (with lascontrol command).I would like to know how can I define to delay these seconfd line until the file writer is not ready. 'Cause now the command gives back an error like: there is no input data (so the textfile).Here is a screenshot of the process.

Hi,I don't know much about FME, but there is no ESRI support for S57 Data to get a GDB without getting more expensive Tools. So I found a model of FME Workbench from rylanatsafe (https://knowledge.safe.com/articles/570/s-57-enc-hydrographic-data-format.html)But when I run that model,I get the Error:"Could not create a GEODATABASE_MDB writer. Personal geodatabases are not supported with 64-bit versions of FME and ArcGIS. Plugin 'GEODATABASE_MDB' was loaded, but a writer could not be created. Error was #1: A fatal error has occurred. Check the logfile above for details"Is there any way out? So I need the s57 Data as a GDB with the symbologie of s57 data. (ENC) Thanks for attention.  

How to remove spaces in between numeric values.like belowBeforeI need like this0 909a 1 2 ga 12 ga125a125a 1 ba 1 ba 12 5 ba 125 b  

Hi there, I have a record that consists of 10 attributes/columns. I want to remove duplicate from the record. The duplicate would be based on the value of 5 attributes. When I say duplicate, it means that reduce the number of duplicate records to 1. I read the existing thread on the forum where someone recommended to use Matcher. However, Matcher categorizes the record into duplicate and non-duplicate. I don't want categorization. I want to reduce the duplicate records to 1 record. I also tried to use ListDuplicateremover, the problem in that was it only showed the name of one attribute. Any suggestion

Hi, I am trying to print certain things while running a python code through python caller! I found it was working earlier but suddenly I do not get any print command except if i just do a print and no other code is present. Can anybody help?

Hi,  I have a column named DateTime in a table. The format of date and time is as follows:  9/9/2009 21:23:31 25/12/1991 8:3:23  means There is a space b/w date and time. Date Month Year is seperated by '/' and time by ':' Now, I need to seperate date and time. I want two new attributes Date and Time with respected outputs. Thanks in advance. 

Sorting happens mostly by one attribute across a set of features. I would like to sort multiple attribute values (all of type datetime) across one feature and pick out the most recent date (of that particular feature) and assign it to a new attribute. I can imagine a lot of complex Testers, but it seems so obvious to use sorting of some kind. Any suggestions?

Is there a way to control the size of labels within AutoCAD blocks during DWG rendering? The text looks smaller and is misaligned when rendered by FME (and therefore the inspector and, more importantly, the PNG writer), but it's the right size and aligned properly in AutoCAD.Bad in FME (for Linux):vs. Good in AutoCAD: 

The DateTimeParse function is driving me mad (in FME 2018.1)!What is the problem with this...?Failed to evaluate expression '@DateTimeParse(3-Jun-2020,%Y%m%d,repair)'. Result is set to nullI have also tried @DateTimeFormat and @DateTimeCast and things like putting quotes around the input etc. Nothing works.I want to use the function because I want to convert a value of "3 June 2020" to 2020-06-03 to write into a date field in SQL Server. I have already use the string functions to extract the substrings for day (3), 3 character month (Jun) and year (2020). I could go the long winded way and write these to separate attributes then use the DateTimeConverter transformer, but why should I?

mes données de départ  Tableau 1  numéroheure 1 11302124031850414005153069307155081530  ce que je veux obtenir Tableau 2numéroheure1 11:30212:403 18:50414:00515:30609:30715:5083: 30 J'ai essayer avec le transformer StringRemplacer @Left (@Value (heure), 2): @ Right (@Value (heure), 2)et j'obtiens :j'aimerais que quand y'a 3 nombre, il ajoute les " : " derrière le premier nombre ex: 930 devient 9:30 merci.

Hi there, I would like to use a Conditional Region Growing algorithm from the PCL library (See tutorial) inside a workbench. I make some point cloud preprocessing using vector features and then, at some point, I would like to introduce this algorithm and go further with my processing. How can I make use of that? I have tried with Python bindings using PythonCaller but it is not so helpful in this case.Is there a chance that this solution will work? :-> Preprocessing... -> SystemCaller(call .exe file triggering C++ algorithm) -> grab results (still within FME) -> process further Would you like to share some other possible solution?The biggest advantage of FME is that you can construct pipeline from A to Z and you do not have to interrupt it. I can, of course, export results after preprocessing and then that get back to FME but it is not what I would like to have at the end.

Hi guys,I have a line file (1 line) and a point file (Multiple pairs of start/end points). I'm trying to clip multiple line segments from a single line based on a start and end points with matching ID attribute. I have been trying PointOnLineOverlayer but it adds the attributes from only the first point to every line. When I generate a list based on the ID the list includes every point ID on every line, not just the points that the new line intersects.  Is there another way to achieve this? Any help would be greatly aprreciated. Cheers, Dave.

Some really weird has happend to my Win-10 enterprise PC: Starting FME workbench 2018.1.1.2 fails with the "LibraryLoad failed with error 87" error message. Has anyone else had to deal with it? By googling it seems to be a generic windows issue. I can't find any FME - specific discussions about this error.My theory is that some windows upgrade has broken my FME installation.Happy for any help. If I find a solution I'll post a followup.

I think I have the easiest question ever but I've wasted too much time on it and it just won't work.I just want to create a new attribute for each record with the result of the sum of 3 other values. The result of nieuw + renovatie + stroomopwaarts. It looks very easy but i have already tried everything and nothing works. What am I missing? 

Hi, I used to read my ESRI database with the ArcSDE Legacy Reader which worked fine. When I switched to the new GEODATABASE_SDE reader, my ESRI lines that have a cross over that looks like an arc are now read as an IFMEPatch which is a combination of an IFMELine and an IFMEArc. With the Leagacy reader the same line is read as a Line and not as a path of a line and an arc. Is there a way to force it to be read as a line as before? If not possible what would be the best way to convert it as a line? Thanks,Simon

We have FME 2018.1 when you choose “Use system proxy settings” it uses the system proxy ok, but it ignores any exceptions you may have set in Internet Options e.g. for local addresses that don’t use the proxy. The work around I have at the minute is to add each individual server on our local domain to the Custom Proxy Map in FME Preferences as having No Proxy however I can’t use a wildcard to do this the same way it is in the Internet Options exceptions list e.g. server1.domain.com rather than *.domain.com. Is this by design? Exception list in Internet Options Proxy Window and use System Settings in FME 

Heyhey and happy new year, Im fascinated with the 3D PDF possibility of FME and am constantly making some needlessly-over-complicated things in it (of course)Up to now I have mainly just been taking either stuff straight out of Revit for buildings/structures to a 3D PDF or draping TIN's with areal photography or other rasters to make nice 3D landscape.Now I want to include vector data in my landscapes, for example not only drape a TIN with areal photography but also drape it with contours (lines) and areas (polygons) and even perhaps somekind of a structure (based on a point).Ive googled around and tried many things but I just have not succeeded, so could anyone suggest a workflow where I:-Introduce vector data (point. line, polygon)-Set the symboligy of that vector data (color, thickness, opacity...)-Drape a TIN with that symbolized vector data (Use the 'Appearance setter'?)-Export that to a 3D PDF (remembering that I already know how to make it with Raster and TIN, just n

When I try to add data to a timestamptz field in postgres using the postgres writer it gives the following error:Value of attribute 'start_date' could not be converted to type 'timestamptz'. Feature will be logged and skippedWARN Â |+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++WARN Â |Feature Type: `admin.real_right_version'WARN Â |Attribute(string) Â : `start_date' has value `2018-11-13 09:43:58.3875761+01'I'm using FME 2018.1 and postgressql 10.5

Is it possible to combine these glob patterns in one PathReader?*.jpg*scheme*.pdf

I am new to FME. I think this is a simple quetion for you guys. I have a SQL table with two fields Longitude and Latitude and other attributes in SQL Server database. I need to it to Feature class into same database. how to do that? how to setup Longitude and Latitude fields as geometry fields in the reader?

I'm running the WSR with 7 concurrent processes. Is there a way to add information to the opend cmd window to identify which window belongs to which processes?I need to terminate from time to time a cmd as it's hanging but I can't identify know which window belongs to which process and I need to guess.In a batch file I would add TITLE parameter in it. Can something similar be set for WSR? Below screenshot shows 7 CMD's but no distinction between them is possible:The provided command is too long to check in the taskmanager. The part to see the difference can't be set on the monitor:

Hello, everyone. I have points (attributes: X, Y, ID) and I want to merge points that are under 50 m distance and new point should have attributes ( new_ID, X, Y, all id of the points from which the new point was created) and if there is a duplicate point, also making one with attributes ( new_ID, X, Y, all id of the points from which the new point was created) Thanks a lot.

Hi there, I have Incident_no in the csv which I don't want to include into the calculation. Data is coming from the database. Is there any way that I exclude the records that contain incident number present in CSV? I tried with Feature joiner but it didn't give an option of not equal.

Using the logic from this post and this post, I wanted to rename my log file using the Pyhton shutdown script.For some reason, os.rename works only with python 2.7 and not python 3.x.I tried single, double, and triple quotes; used raw, and I can't seem to find a good way to correct os.rename. Used FME_macro and just a string for the source file. Nothing worked so far.# Import modulesimport fme, datetime, time, os# Get current date and timedateToday = datetime.date.today().strftime('%Y/%m/%d')timeNow = datetime.datetime.now().time().strftime('%H.%M.%S')logger = open(FME_LogFileName,'a')logger.write('Date: {}\n'.format(dateToday))logger.write('Time: {}\n'.format(timeNow))logger.write('ProcessID: {}\n'.format(fme.processID))logger.write('Status: {}\n'.format(fme.status))logger.write('Workspace duration was {} seconds\n'.format(fme.elapsedRunTime))logger.write('Total feature read {}\n'.format(fme.totalFeaturesRead))logger.write('Total features written {}\n'.format(fme.totalFeaturesWritten)