Best Answers

I have a sql server table that I do not own but have full permission on.I can setup a GEODATABASE_SDE Reader and read it no problem the table qualifier is "abc\\username" When I try to setup a writer for it the Table Qualifier gets set to _abc_username_ When I try to write to it I get an error message statingGeodatabase Writer: Feature Class or Table '_abc_username_.table_nm' must exist when Table Handling is set to 'Use Existing' Unfortunately using FME2018.

Seems like exposing elements in AttributeSplitter doesn't work in FME 2020.0.1 (build 20218). Even exposing attributes after splitter with AttributeExposer is broken.Or maybe it's Data Inspector's fault for not displaying them. Any thoughts on this?

As a rookie of FME, i have an attribute call JEAN i want to create in the attribute , two choices of values in a string to use it in QGis Attribute : JEAN string : Yes or No How can i do please ? Thanks

I have a table (BKR2) with x and y coordinates, but no address.There is another table (GBA_address) with x and y coordinates with address.i would like to search with x and y coordinates from table BKR2 for nearest x and y coordinates in table GBA_address.Is that possible and how? 

Hi, I have tried this method: https://community.safe.com/s/article/cannot-check-out-floating-license-but-have-borroweit didn't work. I have been given 2 accounts by my IT. my normal account, with locked license, I can't return the license because everytime I try to open fme desktop it shuts down itself. licenses are available. But, when I try to open fme desktop with my local admin account it opens just fine. BUT in license manager it shows as I am using 2 licenses?

I have a writer that creates a CSV file to a folder on my computer. How do I write this CSV file to AGOL (ArcGIS Online account)? I already understand how to write data to an AGOL Feature Service. I need to create a CSV file to my AGOL account. I plan to update this CSV file every night (via the Task Scheduler) and share it with others. I'm using FME Desktop (not FME Server). Thanks.

Does anyone know how to tell FME Server which DNS server to use?Thanks.

I have workspace that currently has one choice dropdown input parameter that lists regional utility companies. The parameter dictates where the input data is read from and where the output data is written. On FME Server, I have setup separate Users for each region. The client has requested that I limit access of each regional User to it's own region. So, say we have Region1 and Region2. Region1 shouldn't be able to run the workspace by selecting Region2, and vice versa. My thought is, if the FME Server User accessing the workspace is available at run time, I could essentially do away with the drop down, and let that dictate which data is processed. Is this possible? If not, what would be my best course of action to accomplish that separation. My second thought was create separate repositories for each region, but then I would need to make copies of the workspace only allowing a single choice in the dropdown. This doesn't seem very efficient, and would pose an issue when upd

Hi all,Just a quick question:What I try to do today is to write a hyperlink from my workspace to a word document. I am compiling a Word document with a bunch of MSWordStylers and one of the paragraphs contains a hyperlink... I have been looking around, and it looks like it is currently not possible to insert a hyperlink to a word document using the MSWordStyler. Is that still true, or did I miss something? And: would there be an alternative route to accomplish this? Any insights will be highly appreciated. Cheers, Egge-Jan

Hell everyone, I apoligize if this has been answered already but I haven't had any luck trying to find a solution. Basically I have a URL in HTTPCaller that I need to append a value at the end of so that I can run multiple GETs. The values that I need to append are stored in an AttributeManager column. I understand that I may need to create some type of looping function that will go through the list of attributes, append the first value to the end of the URL in HTTPCaller, run the GET request, save the results, get the next value in AttributeManager, append to the end of the URL, run the request, etc.. but not sure how this could be configured in FME. Ultimately we will need to place the results of all the GET requests in one data set.

In the documentation I see that Appearances are planned for a future release. Just wondering if this is already on a timeline somewhere: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/cityjson/quick_facts_cityjson.htm @deanatsafe​ - perhaps you're the one to ask?

Hi, I have 25000 dgn files and I want to convert all of them into a single shape file and want to add the following attributes in the shape file File name of the dgn as attributeLevel name of the dgn as attribute I would like to convert only the line geometry from the dgn files. Please help

I`m trying to make a strange raster, due to a specific software demanding exactly that format.  It seems to be a GeoTIFF with 1 rasterband (UINT8) that has palettes with 3 values (RGB). See below for more information. I have managed to create the 1 channel TIF with the correct value, however I struggle to add the palette, and add the correct value for each palette to each pixel. Since FME can read the file correctly, I assume it can also create such a file, however I am stuck after examining all the RasterPalette* Transformers.  Any raster-wizards out there? 

Hi, One FME Workbench user in my organization recently had FME Workbench 2022.2.0 (build 22765) installed on his Windows 10 (Enterprise 21H2) machine and it was working perfectly up until a few days ago. He even went on a Basic FME introduction course without any problems. But suddenly, FME Workbench won't even start up. According to Event Viewer in Windows 10, fmeworkbench.exe crashes because of an unknown error in Qt6Gui_fme.dll:  However, FME Inspector runs just fine. To our knowledge, there has been no updates or changes to Windows 10 on his machine. We also tried deleting %appdata%\\Roaming\\Safe Software\\FME\\ but it made no difference to FME Workbench. Does anyone have any other ideas we could try out?

how to generate a value off a partial level name

Today i use the datetimestamper to have my date in a string, but i want to convert to an attribute Thanks in advance and sorry for my bad english ! 🙂

Hi everyone,  I am trying to create a set of new attributes with the Attribute Creator. I would like to use the "import" option to bring the attributes from a CSV file. However, the transformer reads the attribute values as a "text" and not as Arimethic function (See picture for clarification ). Any idea on how to change that quickly? Or any better idea to obtain the same result? I mean create the following attributes:  Name AttributeY1 =A1+B1Y2 =A2+B2Y3 =A3+B3Thanks in advance!. 

Hello, I am reading some attributes from a database. Some are in string format, some in number (int, float etc.). I want to write these attributes to a json file.I noticed that all the attributes in string format are automatically output in quotation marks and the numbers without. In my case I have three attributes: district, lat and long. District is an int, lat and long are strings. How can I change lat and long so that their output is also without quotation marks like the district one (see image) ?

We recently upgraded to FME Server 2022.2 and were having issues adding an emailer to an FME Automation. After inserting an emailer within an Automation, we are receiving an error when attempting to validate the email after putting in the Client ID of the app registration that we created within Azure Active Directory App Registration. We are receiving this error when validating: Is there a walkthrough going over the new Microsoft Office365 email authentication within FME Server? I see the FME Desktop emailer has been updated to use a web connection, and I'm able to successfully create this web connection and send an email, but still having issues within FME Server email automation.

I am trying to add a web service on the FME server (Google Sheets - safe google sheets). I put in the credentials and click authorize, a pop up appears. It says "FME wants to access your Google Account", I click allow. Then the page refreshes and says: Make sure you trust FMESign in or provide access to FMETo sign in or provide access:Copy the authorization code from the Authorization code section.Navigate to FME.Paste the authorization code on the FME screen.Authorization codePlease copy this code, switch to your application and paste it there Where do I navigate to FME? On the Web?Where do I paste the code? I checked my google account's security for FME and there is no option of adding the code.

Hello Everyone..I have an query regarding transpose for the attribute one feature elements are 25 as you can see in ID coumns ..Now my question is how can i transpose the column names to rows and their inforation related to the field..Please find the attached screenshot with the FME template with sample dataPlease provide how can i fix the issue Thank You

I have been given the task of creating an e-mail function. It should send an email when another date is about to expire. For example, a customer receives an email when there are 14 days left on their current booking. But datetimecalculator does not work to calculate intervals of days when it comes from ESRI file geodatabase (is SDE in the original data) I suspect it is the format of the attribute that is incorrect but can't find how to change it to a working date. Is there anyone who can help me? Attaching my workbench and a file geodatabase as a zip file Best regardsJesper 

Assuming I successfully get FME to use an ArcGIS Pro license instead of a Desktop license -- a current problem -- I would like to know how to direct FME to use my cloned and currently active Python environment instead of the default (and unmodifiable) one that got installed with Pro. I have added several modules and site packages to the clone that I would like to use in FME. I read in another post (lost track of it) that FME might only be able to use the original Python environment installed with Pro. It was suggested that maybe adding the paths to the site-packages and bin directories in the clone to my system path environment variable would allow use of the clone. I have done that ... but alas, I still haven't gotten FME to use a Pro license. This brings up another question, though. On a colleagues machine where FME is using a Pro license, the workspace translation log only reports the version of Pro that is being used: there is no indication of which Python environment is

Hello, Is there a transfomer to know the direction a polyline was drawn (forward or backward) ? Thank you

(I have attached the dataset)I have survey points where each point is less than 2Metres from the next point per run, in a run i can have more than one section, as shown in the attached file, but all the points within this one run are still within a distance of less than 2M from each other. The difference in distance between runs is more than 2M. So it is evident when a new run starts and ends. If i had the attribute run within my dataset i would use the linebuilder and create lines from points.So what i am trying to achieve is to group the data per run. So far i have tried creating a new attribute in the Attribute creator transformer using conditional values but to no success. Anyone with an idea of how i can achieve this? Thanks,Keller.