FME Form

Hello - I am retrieving value from "date" field using ArcGIS portal services . It seemed to be in this datetime format ( YYYYMMDDHHMMSS like below screenshot) on UTC time. I would like to change this to local time. Please help on how this can be achieved. Tried using datetime converter, but does not seem to work . Thanks, Naveen

I am writing to MSSQL using a dynamic featureWriter. But I can not understand why it fail to write to an existing schema. Warning: Cannot find a matching schema named 'dbo.MyTable' in the known set of schemas: ''. Known schema sources are: 'MSSQL_SPATIAL_1'. Please verify writer feature type configuration Error: Microsoft SQL Server Spatial Writer: A feature has arrived with 'fme_feature_type' of dbo.MyTable, but the feature type is not recognized. Halting translation MSSQL_SPATIAL writer: A fatal error has occurred. Check the logfile above for details. The fme_feature_type here is "MyTable". In the writer I use dbo as table Qualifier to match the existing table in my database "dbo.MyTable". What is it I am not getting? I have set the Schema Definition Name to the default option because it should use the table definition for the fme_feature_type "dbo.MyTable". I will try to prefix the Schema Definition Name with the dbo. prefix but I just assume that should not be needed beause we have

I'm looking at some floating license logs for FME, hoping to build a reporting tool for it. What I've noticed is several cases where one user/machine checks out a number of licences in a short amount of time and check them back in after a while: I assume this is either the user starting multiple instances of one of the FME application on the same machine (or Workbench and Data Inspector) and/or using a WorkspaceRunner. Can anybody confirm that? And more importantly, does every checkout correspond to a checkin? I also assume that as long as there is at least one checkout active for a user/machine that counts as a concurrent license being used, correct?

I have two sets of address data that I'm trying to match up using the CRCDetector as described here https://community.safe.com/s/article/creating-a-unique-identifier-crccalculator. Geometry isn't a concern so there are only the 3 fields to match up but I'm getting different CRC values for things that should be the same. Some of the algorithms will give a handful of matches but no more that a couple of dozen (out of about 12,000). I've checked for trailing white spaces. What else is making it think these things are different? Thanks

I am trying to segment a line dataset at every intersection with a polygon dataset. Instead of breaking the line at the true intersection, the transformer appears to generalize the polygon first, then break the line at resulting intersections. The result is as seen in the image, in this case a dangle of about 7'. (candidate line left to right, original polygon in brown, and Intersector's drawn line from bottom left to top right. Selected blue line should end at polygon boundary.) I've tried LineOnAreaOverlayer, Intersector and Clipper with similar results. I've manipulated the coordinate systems of each dataset and changed their source type with no differences. What am I doing wrong? Thanks!

Calendar to activate in Arcmap, selecting the date highlights all the objects corresponding to the selected date. Calendar tool to activate on demand.

Pretty simple data export, I have a reader referencing some SDE data and then a writer to a file geodatabase. But reviewing the attributes in the file geodatabase I see that the domain attributes are the codes (1,2.3, etc) not the descriptions (copper, steel, PVC, etc). Is there a way to write the domain descriptions and not codes? The same is true for the subtypes, it is writing the code (1,2,3) and not the description (tap, bend, saddle, etc).

Hi, How can I expose the information that are visible in the Properties/Source tab of feature layer

I am joining 3 tables together. There will always be a record in the first table and there may or may not be a related record in the second. If there is a related record, there may or may not be a record in the third. I always want to have the record from the first table. The relationships are as follows: Left: Table 1 primary key - Right: Table 2 foreign key Left: Table 2 primary key - Right: Table 3 foregin key When I try and set this up using FeatureJoiner transformers, it works ok on the first, but if there is no record in the second table, it cannot join to the third as there is no left key. Is there any way to pass records with a null left key in FeatureJoiner? If I did a similar workflow in a Microsoft Access query I would still have the record from the first table. I presume I could use a FeatureMerger and pass Merged and UnmergedRequestor into the input of the next transformer. This could work ok but I do much prefer the FeatureJoiner Many thanks

Hello Community, I have a points dataset containing 17 records. Some at stacked at shared locations. Some are isolated in one location… I need to separate this into two different streams. Stream one: all records that are at shared locations (i.e: sharing an XY co-ordinate pair)… Stream two: all records that are the only records at that location… How is this achievable? Thanks,

Hi, I have simple workbench where outcome is saved as dynamic schema. Somehow, additional columns are added to attribute table of the feature classes in gdb. Any clue what is going on?

Hi, I was wondering if there is a way to format text that is used in the "Message" User Parameter in FME Form. There is no Text Editor available for the "Message Configuration" option and when I use the Parameter in a FME Flow App, line breaks are removed, although they show up when prompted in FME Form. Is there a way to keep line breaks?

Hello! I could make a 3D buildings with simple roof form, I got SurfaceNormal Z, so I could separate flat form roof. But I have a building with complex roof. So I want to separate the building from certain Z height, above it, it is roof and under it, it is body of the building. Do you have any Idea to get it?

Hi, I am working on translating data from numbers to phrases. I know using the String Replacer and Attribute Value Mapper is the best for this, but I am having issues when trying to map more than one value to one field. An example would be the reason_of_given_set has multiple values, I need these values to populate with given phrases, each number represents a phrase. I provided the parameters of the transformer I am using below. I also tried creating 14 different string replacers to represent each number and each time the output shows blank at the attributes with multiple values. I am probably using the Attribute Value Mapper transformer incorrectly and its not designed to do this, or I have the parameters set incorrectly. Does anyone know how I can fix this?

I have a "Directory and File Pathnames" reader that gives me a list of text files in a Windows folder. I want to pass those folder and filenames to a FeatureReader transformer and be able to read the text lines from them as output for further processing, but I can't seem to get anything out of the FeatureReader other than the results of the Directory and File Pathnames that go into it. How do I get the contents of the text files out?

Hi, I am facing an issue where wall was not rendered properly by the FME inspector as it has direction issue. I tried "SurfaceNormalExtractor" but I didn't get any information out of the transformer. Please find the screenshot. Could you please help me in this regard. Same issue was posted 6 years back https://community.safe.com/s/question/0D54Q000080hfTrSAI/citygml-generation Wall not render properly in FME inspector

I am utilizing the EsriReprojector and am getting limited results for datum transformation options from GCS_WGS_1984 to EPSG:6574. Is there a certain setting that needs to be applied to gain the other transformation options?

Is it possible to write into 'autocad_layer_desc'? A key piece of info/metadata that seems to be unavailable on DWG writers.

When setting the connections to Azure Database in FME Desktop, it does not have an option to use Active Directory Integrated authentication. It has only Windows and SQL Server Authentication. Is there possible to connect Azure Database by using Active Directory Integrate? Any help is very much appreciated.

The documentation for autocad_dimension features says that you can use an attribute "autocad_text_rotation" to rotate the text of a dimension. See autocad_dimension However, I haven't succeeded in rotating the dimension text yet. I use "autocad_dimension_type" = autocad_aligned Any ideas?

Hi, I'm trying to write an XLS file based on a template (according to this help), with complete rewriting of the data (Overwrite Existing File = Yes) and I can't find a way to keep the order of the columns according to the template in the output XLS and not in the order in which FME processes the attributes. For example, I would like that if I invert 2 columns in the template, it also inverts it in the output xls, without setting this with an attribute manager. Did I miss a parameter in the xls output that would allow this or is there another method. Thanks a lot in advance for your answers and best regards. Antonin

We have a client that has a unique need and I'm wondering if it's even possible in FME. There goal is to have a csv or table that contains a dataset name, itemID, and layerID. They also have a GDB file containing the datasets. The would like to have a function to cycle through their csv table, and overwrite an individual layer in an AGOL hosted feature class. The caveat is this hosted feature class may contain many layers and as far as I know you can't update just one layer. We have been racking our brain and FME seems like it may be our last hope. Here's the short version of the workflow Read update table -> Read GDB -> Update Hosted Feature Service Layer Any advice would be appreciated, Chad

PostgreSQL database login details Host: postgis.train.safe.com Port: 5432 Dbname: fmedata User:fmedata password: fmedata (not sure if it is that password) (getting ***)

In an Esri SDE database, fields (attributes) have a property setting of isNullable (Allow NULL). This property determines if the field allows null values or not. I want to be able to set this property in FME when I create a new feature class. Is there a way to set this property with the Esri Geodatabase SDE writer? See screenshot below to see how to set the setting in ArcGIS Pro.

I have a question, i am trying to join in a pythoncaller Only i am getting this error: BADNEWS: Cannot convert null string into an integer (C:\code\fme\foundation\framework\util\stf\stfutil.cpp:347) class StatusInfo *__cdecl STF_stringToUInt(const class ObsoleteString &,unsigned int &) Python Exception <AttributeError>: 'fmeobjects.FMEFeature' object has no attribute 'getAllAttributes' Traceback (most recent call last): File "<string>", line 14, in input AttributeError: 'fmeobjects.FMEFeature' object has no attribute 'getAllAttributes' Error encountered while calling method `input' PythonCaller_FeatureMergerReplacement (PythonFactory): PythonFactory failed to process feature The script i am using is: import fmeimport fmeobjectsimport pandas as pd class FeatureMergerReplacement(object): def __init__(self): # Initialiseer de DataFrames self.primary_df = pd.DataFrame() self.secondary_df = pd.DataFrame() def input(self, feature): # Voeg rij toe aan primary_df new_row = pd.DataFrame([featur