Best Answers

A popup(FME has stopped working. A problem caused the program to stop working correctly. Please close the program) occurs and then after clicking Close. I see "Error running translation." in translation log. No clues about what would have gone wrong. How to debug these kinds of issues. 

Is there a setting to suppress fme_rejection_code attribute creation with DateTimeConverter Transformer? Thank you, TylerFME Workbench 2022.1

It seems like this should allow for more itemized day selection, week selection, month selection. We want to setup multiple automations and it does not seem like I can do that, exactly.

I need to transform an Oracle geodatabase using st_geometry to postgresql using postgis. Ultimately it will be moved to the cloud (RDS on AWS). Is FME the correct tool for this sort of conversion? Would it be fast (roughly 15GB database(

Greetings, Do you have a best practice for adding a 'status' attribute populated with the value of the join status such as 'joined', 'unjoined_left', 'unjoined_right'? I can imagine using a 'create attribute' transformer outside of each join transformer port, but that seems heavy on transformers (four total). Let me know if you have a more efficient solution.  Thank you, TylerWorkbench 2022.1

The writer seems to be trying to write '00000000' for these features rather than leaving it as null Is there a way to stop this behaviour? In a standard workbench I could set a default value but it feels like I shouldn't need to do that as postgres can handle null values in date fields and I don't know how I could change the values as it's a dynamic schema. Errors in log:Value of attribute 'createdate' could not be converted to type 'date'. Feature will be logged and skipped Attribute(string: UTF-8)      : `CREATEDATE' has value `00000000' ---Schema definition for field:attribute{8}.fme_data_type fme_dateattribute{8}.name CREATEDATEattribute{8}.native_data_type dateThe next line is missing for features that do not have a value:CREATEDATE 20031118 

I will like to automate my weekly ftp download. Mapinfo reader example url (as zip with multiple mapinfo files): ftp:// ftp.data.com/Geodata_202103159999 .zip  'Geodata_' is always there, '20210315' is the data that changes (every monday when data is downloaded) '9999.zip' is always there  In my logik the easiest would be ftp://ftp.data.com/Geodata_*.zip But it doesnt work. 'Geodata_' must be there can be multiple zip files on the server.  Any suggestions on this problem?

Hi folks, I have some CAD files (dwg, dxf) that have custom line type information (so line types, the engineer defined by himself/herself. I know that the DWG format has some attributes to be exposed that indicated a "DASHED" line etc.I can read out lets say the linetype "FENCELINE" or any custom made linetype in an exposed attribute (I guess it is called "Autocad_resolved_linetype").  problem: While the complex linetypes are defined in the "acad.lin" files, the custom linetypes a user can create are just visible in AutoCAD. Is there a way to display those custom/complex linetypes to get this automated somehow?problem: I know the "LinePatterner" helps creating the simple line types. But how can I created a complex line pattern? Something with circles or characters in between?Many thanks if somebody can share his/her knowledge 😄  Best,Ferid

I stumbled across the following challenge in FME:how to deal with NULL values if you want to perform a calculation for a new attribute. For example, I want to sum up values (could be any other kind of arithmetics).The expected result is fine as long as no NULL Value is involved. FME turns any calculation into a NULL result if any NULL is involved (see documentation).   The question that haunts me is, how to treat those NULL values as 0 in the calculation without changing the value to an actual 0 (as the NullAttributeMapper would). The result I am looking for is the following: If all values are NULL i want the result to be NULL, otherwise I want the NULL value to be treated as 0. Furthermore, I dont want the NULL values to be changed to 0, so I can distinguish between NULL and 0 in further calculations.

I would like to download all shakemap files. I can download one based on event ID but how do I download all of them. I have specified a folder for them to download to but I have tried a few combinations to get all of the files to download however no success. So the 2022p955929 could change and there are many zip files to http://shakinglayer.geonet.org.nz/api/v1/events/2022p955929/latest.zip I have tried this and the $ sign but they don't workhttp://shakinglayer.geonet.org.nz/api/v1/events/*/latest.zip

Recently I had to move FME to a new Computer where I cannot use the same Windows-User for FME Authoring and Batchs.This way, I had to change my Database-Connections to Public, so that the Batch-user can successfully execute my FME-Batchs.I did the same for my Onedrive Web-Connection (change to Public).Now the Onedrive-Connection works in Workbench directly, but not as a Batch (with my Batch-User "fmebatch") Log:2022-12-13 10:13:29|   0.4|  0.2|ERROR |OneDriveConnector: Invalid connection, make sure your install path for FME is in your system environment variables2022-12-13 10:13:29|   0.4|  0.0|ERROR |Error encountered while calling method `input'2022-12-13 10:13:29|   0.4|  0.0|FATAL |OneDriveConnector_CALLER (PythonFactory): PythonFactory failed to process feature2022-12-13 10:13:29|   0.4|  0.0|WARN  |An error has occurred. Check the logfile above for details2022-12-13 10:13:29|   0.4|  0.0|INFORM|Translation FAILED with 3 error(s) and 2 warning(s) (0 feature(s) output)2022-12-13 10

FME Server 2021.2.6 We have an automation which downloads attachments from an email to an UCN path. When the automation is triggered, it logs the following error:2022-11-28T16:43:49+01:00 | 809004 : \\uncpath\image002.png : Failed to download email attachment. Download location "{1}" is not available and could not find an appropriate alternate location.But when we look in this specific folder, we see that the attachment is downloaded successfully.Questions we have are:Do we try something which is not supported?Can we solve the error log?

Using the instructions, we were unable to use Chrome create the .cer file. We had to use Internet Explorer. In the Verify HTTPS configuration step, localhost produced an insecure connection although using the hostname produced a secure connection. How can this issue be corrected?

How do I upload/post PDF files to Survey 123 Portal? I tried using both the put & post options in HTTPCaller transformer as well as FeatureWriter. It appears to work as I did not encounter an error message but the files don't get actually written in the portal. I guess it could be the HTTPCaller settings but I'm at a lost how to set it. Please advise what I'm doing wrong , or any sample FME script with httpcaller settings would be greatly appreciated. Thanks in heaps! Wilfredo  

Can someone please suggest something to  improve the performance?

Hi team,with the deprecation of Basic Authentication coming up in October later this year (Deprecation of Basic authentication in Exchange Online | Microsoft Docs),it's been suggested we move across to OAUTH for accessing emails via FME Server Automations. I'm a little stuck on how we can do this? There doesn't seem to be any OAUTHcapability within the templates? Any suggestions on how we can achieve this?

In the new, fantastic, InlineQuerier (2023 beta), a geometry column can be selected. Is there a way to call directly the geometry of the feature without geometryextractor? On the same topic, is there a way to define the ouptput geometry without using an ST_asText followed by a GeometryReplacer?

As far as I understood from the documentation, the self-hosted FME Server (installed on my own server) can be also licensed by CPU (Dynamic Engines)?That means that I have a full control and security (especially in terms of data privacy, etc) of FME Server like self-hosted FME Server with standard engine(s), however in terms of license it acts similar to FME Cloud?So if both questions are correct then the difference between self-hosted FME Server licensed by standard engine(s) and self-hosted FME Server licensed by CPU (dynamic engines) in regards to license is that the client pays for an extra standard engine only once, but for CPU Usage as long it in hours takes - continuous payment?

Hi, I have tried to follow the suggestions in this thread to connect to Mapillary API without success.https://community.safe.com/s/question/0D54Q00008vZLePSAW/hi-have-anybody-succeeded-in-connecting-the-mapillary-api-v4-with-fme-workbench-i-get-stuck-on-an-internal-server-error-when-i-use-httpslocalhost-as-redirect-url-in-the-oauth-20-webservice-authentification I am using these settings:I am just getting a login page when I test the service: Any suggestions? The result is the same with http://localhost and https://localhost. It is the same when adding Authorization under HTTP Header for Retrieve Token Parameters. Anyone got any suggestions on how to connect to the API and for example get coverage tiles.

Hello, I have the following date string(s):...which I need to convert to datetime objects. They appear to be 'iso datetime with offset', however I continually get invalid format with auto detect or manual choosing format. I have tinkered with several other input formats to no avial.  Any ideas?  Thank you, TylerFME Workbench 2022.1

I want to extract specific lines from a log file, based on an regex. However, instead of getting a whole line as match returned, or even better a list of matches, I am getting <null> returned. What I want from the log file are all the warnings. I used an AttributManager and set the Attribute Value for the new attribute to @SubstringRegularExpression(@Value(_log_attr),^.*\|WARN\s{2}\|.*$,0,0,5)The last parameter is already misleading, since I usually do not have an idea of how many warnings there might be in an arbitrary log file, but for the sake of my test it would work.I would expect that the first match (out of 5) is returned. Ideally, a startIdx of -1 would give me the last of the five matches, but that doesn't work either. For the fun of it I was testing the same expression within a StringSearcher and here, there is a match. However, the attribute containing the matched result, who is supposed to return "the portion of the original search string that matched the regular expr

Hi.I am wanting to utilize a webhook to kick off a process and have set up a sample site based on Send Source Data to FME Server with HTTP POST (safe.com).This example uses a text file to kick off the process but I am wanting to use the webhook URL with a parameter (key field). Is this possible? If so, what would I use as the initiator of the workspace and how would I pull in the parameter?  Any help would be most welcome! 

Hello everyone,  I am trying to round the x, y and z components of Pointclouds to a precision of 3. I have tried the coordinaterounder but as is already stated in the Coordinaterounder documentation (http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/coordinaterounder.htm) the behaviour of this transformer can be erratic. For some points I get far more then 3 decimal places, while for others it is rounded to an integer. I have also tried the Pointcloudexpressionevaluator as in this solution (https://community.safe.com/s/question/0D54Q00009HJ87MSAT/rounding-ifmepointcloud-xyz-components-with-pythoncaller) but this also does not seem to work for my data.  Is there another option I could try or is there maybe something I might be missing from the previous solution?  Thank you in advance!  

Hi all,  I have a strange error message in FME Server. I try to create a sqlite file, but it says it is locked. This file did not exist before running the Workspace. Transaction starts at 0.73 2021-12-2 16:37:35 | SQLite 3 Writer: Opening `\\fme-server******\resources\data\GIPOD\GIPOD_Beta_Token.sqlite' for write operation74 2021-12-2 16:37:37 | SQLite 3 Writer: Failed to open database '\\fme-serve********\resources\data\GIPOD\GIPOD_Beta_Token.sqlite'. SQLite3 Engine error: `database is locked'75 2021-12-2 16:37:37 | SQLITE3 writer: A fatal error has occurred. Check the logfile above for details76 2021-12-2 16:37:37 | JSONExtractor (JSONQueryFactory): A fatal error has occurred. Check the logfile above for details77 2021-12-2 16:37:37 | HTTPCaller_3 (HTTPFactory): A fatal error has occurred. Check the logfile above for details78 2021-12-2 16:37:37 | AttributeKeeper (AttributeKeeperFactory): SQLITE3 writer: A fatal error has occurred. Check the logfile above for details79 2021-12-2 16:3

Group ID should start from 1 for each unique Attribute 1 value and the smallest value of Attribute 2 for each Attribute 1 value should get it as follows: