Data

I have a feature class in a file geodatabase with a Raster data type field, whose values I want to write to an SDE feature class with an equivalent Raster field.When I use the GEODATABASE_FILE reader, the raster column is not listed in the resulting feature class. Likewise with the FILEGDB. To make sure I wasn't missing something I tried the GEODATABASE_FILE_RASTER_DATASET and GEODATABASE_FILE_RASTER_CATALOG readers, which, as expected, would not recognize the feature class.When I use the GEODATABASE_SDE writer the raster field is also omitted. Again, trying the raster readers, GEODATABASE_SDE_RASTER_CATALOG and GEODATABASE_SDE_RASTER_DATASET did not recognize the feature class.Does FME handle the ArcGIS geodatabase Raster field type? Using FME Version 2019.0.1.0 Build 19253

Hi!I am familiar with the consept of reading IFC and writing IFC in FME. I also have successfully created a workspace that can read various geometry formats and write to IFC with custom propertysets. Now I'm trying to create a workspace that can read IFC, modify or add propertysets and write back to IFC without breaking the structure of the IFC file. For example, I have a IFC with slabs. I want to add some propertysets to the slabs and write it back to slabs. I have seen the example where you can modify properties for spaces, but I'm having problems applying the workflows to IFC. All in all I think FME has potential for improvement in handling IFC-files in an intuitive way. Does anyone have any good examples of workflows for the described purpose that can be shared?

I’m using FME 2020.2 (FME(R) 2020.2.0.0 (20201027 - Build 20787 - WIN64)) and I have ArcGIS Pro 2.6 and ArcGIS Desktop 10.4 (with 64 bit background geo-processing) installed. I have a File Geodatabase (FGDB) that FME is unable to read.  The error I'm getting is : “It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro-compatible ArcGIS Sever and 64-bit FME." This FGDB contains a relatively new ESRI field type called contingent values on a feature class.  ESRI notes this makes the FGDB incompatible with ArcMap and releases prior to ArcGIS Pro 2.3 and ArcGIS Enterprise 10.7.x. It appears that FME is defaulting to using the ArcGIS Desktop libraries rather than the newer ArcGIS Pro libraries when both application are installed. The only work around I have identified at this time is uninstalling ArcGIS Desktop.  Once I do this FME will read the File Geodatabase without any errors

I am receiving this error below when I try to retrieve the getJSON variable:Python Exception <Exception>: Unable to update feature service layer definition.Object reference not set to an instance of an object.(Error Code: 400)Error encountered while calling function `processFeature'PythonCaller_3 (PythonFactory): PythonFactory failed to process featurePythonCaller_3 (PythonFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsJSONFormatter (JSONFormatterFactory):This is the code in PythonCaller (simplified for readability):import fmeimport fmeobjectsfrom arcgis.gis import GIS def processFeature(feature):   getJSON = feature.getAttribute('JSON')   gis = GIS(profile='username')    lyr = gis.content.get('item_id').layers   for lyr in gis.content.get('item_id').layers:      lyr.manager.update_definition(getJSON)I know getJSON is giving me issues because if I replace lyr.manager.update_definition(getJSON

Hi,I am having a large set of DWG files in which all the texts are referenced to a native Autocad font file called XARB.SHX, when I try to read it through FME desktop the fme_text_string shows something which is unrecognizable as FME is referring windows fonts.I am unable to read the autocad (XARB) style applied to the text in dwg file.It will be very helpful If anyone can suggest me some workaround.Thanks in advance.IMRAN

Is it possible to write object data to a dynamic block with AutoCAD RealDWG writer?

I've tried Attribute Reprojector, but that doesn't seem to help. I just need the lat/long.

My dataset contains date attributes per day that work was completed. My output needs to have the count of attributes that fall within any given week - example week 40 has 25 attributes - going back to the start of the year. I'm new to working with dates in FME so any help would be appreciated.

Hey guys, https://community.safe.com/s/question/0D54Q000080hBYOSA2/reconcile-and-post-issue Just following this here to reconcile our versioned ArcSDE in a workspace. I have the basic flow set up: Creator --> AttributeCreator --> Writer and i've set the parameters based on the thread above. My question on the writer is what geometry type and row selection information I need to fill in to get it to trigger? I didn't see this addressed in the two threads on this I found searching.Thanks

Reference: Extracting a schema subset for dynamic schemas SCHEMASUBSET.zip contains 4 fds files, is there any difference each of them?All the 4 fds files when opened in FME Desktop, giving the below warning.@hollyatsafe​ 

Occasionally the Folder (existing) parameter will change a backslash in the folder path to a forward slash when the feature is is shown in the table. This creates a major problem for reading, writing and comparing to this folder. Is there anyway to make sure this doesnt happen?

I am looking for suggestions for a user friendly database editing tool. A client of ours has a deliverable in Excel format. We feed data to it via FME from a SQL Server/SDE database. However the client does edits in the excel file and the edits never make it back to the database. I know, we can load the edited data back to the DB via FME again, but preferably, the users will edit the data directly in the database. The client is used to the editing functions in Excel so we need to offer them something very similar/easy to use. The data to be edited is a non-spatial table but related to a parent spatial object.The tool must have:Allow for bulk editing (replace drag functions in excel). Must be user friendly/no code. We have tried MS Access but it is too complex. From the user perspective they just need to:access and filter a subset of the data eyeball the values and add comments in one column.Good to have:Track editor idRead and write by FME We are flexible on the database so if there is

Has anyone experimented with connecting to "Databricks on AWS" data sources? If so, which reader format or transformer should be used to make the connection and browse the available data?

What format can I write to using FME so that my vector data can be read/processed with OpenCV?I'm in the early stages of an image segmentation project to identify impervious cover data from aerial imagery but we're having some early issues getting my vector impervious cover data into a format that my computer science counterpart can use in OpenCV. It seems like XML or GeoJSON would work, but I don't have any experience with OpenCV. Any ideas?

Hi,I want to read google sheets with FME, in order to update AGOL feature service.On my Google drive, I have a folder "HEBERGEMENTS", with 9 spreadsheets.In FME, I defined a Google Drive Connection, and I use the GoogleDriveConnector. I can access to the folder HEBERGEMENTS, but when I run the connector, it reads nothing...Is there a option to see files ?I don't understand...Because the goal of that is to run my workspace with a batch.Thank you very much for your help !Christine  

Currently, I have a dataset which looks like this:I am wanting to produce something that looks like this:Rather than having each different activity displayed as a separate field name, I simply want to convert this into a single field name "Activity" then list the different activity types as a value on separate rows instead of the field header. I then want to apply the relevant frequency field to each activity. Anyone have any ideas? Thanks in advance

When I add a feature type reader from AGOL, I get the coded values and not descriptions. How can I expose the domains on the reader for AGOL?

Hello There I have features that intersect with each other I want to create a group based on their interconnection as you can see in the picture there 3 group each group has features that intersect with each other to create a chain Thanks 

Hi, I am using FME Desktop 2019.2 64bit so cannot use the esri layer file reader (I am not sure this would give me the info I am after anyway as I want to interrogate the data source). I want to open an xml file within the .lpkx file to get the data sources from it (these are all buried in Portal with no way to get that detail using the Rest API - it seems). I have found them on the file system. Now I know I could use some python to unpack it - but using command line and 7-zip (or maybe one of the transformers on FME Hub) but didn't really want that extra step and then delete the unpacked version afterwards. So I guess my question is: Is it possible to change some configuration file in FME itself to recognise .lpkx as an Archive file? If so I would also need to do this for FME Server. This is probably not an ideal solution and the safest would be to just unpack it, then delete it afterwards? Kind regards John

I am currently processing a bunch of DWG files where the majority of them are working fine. There are a handful that result in the above question title as the error message no matter what transformer I use, how few or many CAD layers I involve, whether it is a new blank workspace or not. The error even shows up when I select 'OK' in the 'Add Reader' window and before I even select what layers to load in the following individual feature types window.  Any ideas on why this might be happening for some dwgs and not others? TIA

Hello, Is there a way to read Garmin format TCX and FIT ? I can't find any info regarding readers for these 2 formats. Thanks

I'm using an ArcGIS Feature reader to read a layer with two tables. After reading the two tables, I join them. I add and remove many attributes. The last step of the workspace is to use an ArcGIS Feature writer to populate a layer.  In the past when I've done this, the ArcGIS Feature writer created the ArcGIS feature service. Can I write to an existing feature service? ArcGIS Online (AGOL) field names must be 31 characters or less and not have spaces or other special characters (underscores are fines). Display names are also supported which can be longer than 31 characters and have spaces.  Ideally, I'd like to specify a list of attributes with data types for the feature service.  Questions:Can I create an FME workspace to write to an existing ArcGIS feature service? This is an ArcGIS question, but I'd like to easily create ArcGIS feature service based on a list of field names and data types. I think that I can do this in Python, but I don't know Python.

When writing a KML-file all characters with '&' are written as '& 'This also happens with '<' and '>' which will be exported as '<' and '>' This is the result<SimpleData name="sign">Electrical & hydrogene</SimpleData>But i need<SimpleData name="sign">Electrical & hydrogene</SimpleData> Is that possible?

Is it possible to DELETE files using the WRITER "File Copy" ?  UPDATE:I have created a custom transformer that uses the solution (FeatureWriter in MOVE to null) and uploaded to https://hub.safe.com/publishers/sigtill/transformers/filedeleter Feel free to send any feedback related to this.

Is it possible to create a bar chart with space between the bars? Currently they are merged together?