Data

Hi,My goal is to read multiple (unknown) Hosted Feature Layers (HFLs) from an AGOL group and write those to ArcGIS Enterprise (11.3). I can successfully specify a single HFL in my FeatureReader and using an Automated schema in my FeatureWriter, specify each individual layer and write it to Enterprise. As I need this to work for multiple HFLs, most with multiple layers, I need to use a dynamic schema in my FeatureWriter. As soon as I do this, my workbench fails. Every time I switch to a dynamic writer, using the fme_feature_type as layer name and schema from schema feature, the workbench fails due to these errors:Message Type: fme::internal::_v0::py::ExceptionPython Exception <KeyError>: 'My_HFL_Name'ARCGISPORTALFEATURES writer: An error has occurred. Check the logfile above for details I’ve tried everything I can think of to get this working and cannot understand what I’m possibly doing wrong. Any help would be

 Bonjour,je veux d’automatiser le téléchargement et la mise à jour des données accessibles via les plateformes de diffusion de données géographiques (IGN : BDTOPO, BDCARTO, etc., OSM, DREAL…).Actuellement, je travaille sur la partie automatisation du téléchargement dans FME, qui consiste à moissonner ces données. J’ai déjà fait quelques avancées, mais je sollicite votre aide sur des conseils; liens utiles  ou des pistes afin d’approfondir mes travaux..En vous remerciant d’avance. 

Bonjour, Je rencontre des difficultés depuis plus d'une semaine pour lire et transformer un fichier raster étendu au format ECW (orthophotographie avec une résolution de 5 cm et une taille de 30 Go) sur ue version FME 2020.  Je sollicite des aides.Merci d’avance Mouhamed 

In some tables stored in an Oracle database there are more than one spatial column.The reader can't read all the spatial columns but it reads onnly the first column it encounteres.how to read an Oracle multi spatial column table with FME Workbench?Emilio De Palma 

Hello!I generated a CityGML building model from an fbx model. The model could be opened in FZKViewer but the view is very strange. I could see the textures in the back when I am on the front view. It is like the surface in front of me becomes a very transparent glass.This happens at all of the sides of the model except the roof and ground surface. When I turn off the texture, everything is back to normal. Is it the problem of the texture? How could I check if it is on the texture and how could it be fixed? 

I’m trying to output all property sets from IFC files into separate Excel sheets. So far I’ve found all of the property sets, their attributes and their attribute values. This is my data:What I would like to do is transpose this list into separate lists for each property set like so: After that I could simply write each list to separate Excel sheets, but this is where I get stuck. I create the sheets by feeding the writer from a DuplicateFilter, but how do I join each PsetAttribute to Pset as well as transpose the data so each PsetAttribute is a single column?I need to do it without knowing the exact names or number of property sets existing in each IFC file as well.

Hi,After a migration to Office365, FME is unable to open Access files. The following error is given:Microsoft Access Reader: Unable to find provider 'Microsoft.ACE.OLEDB.12.0', falling back to 'Microsoft.Jet.OLEDB.4.0'. The 2007 Office System Driver might be missing from your system; follow this link for more information: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id;=23734Microsoft Access Reader: Connection failed. Connection string `Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=5;Data Source=K:\\dienst VR\\02_rapporten\\Lijst_SEVESO-inrichtingen 2016.accdb;User ID=admin;Password='. Provider error `(-2147467259) Onbekende database-indeling K:\\dienst VR\\02_rapporten\\Lijst_SEVESO-inrichtingen 2016.accdb.'We tried installing 2007 Office System Driver, as given via the link in the error mes

Host Revit file has 137 linked files.  When I try to read even a small portion of these I get the error.Failed to obtain any schemas from reader 'REVITNATIVE' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information.I’m using a FeatureReader linked to the Metadata.LinkedInformation output of the host Revit file (first strcating the LinkedFilePath and Name attributes).  I get this error even when I limit the input to one record.  Separately, a FeatureReader (along with Creator to initiate) can read one of these files. I saw a similar post where the answer was to change the FME_Temp folder.  I don’t think this will make a difference since I get the error when only trying one file.  I would try this but I need admin rights to set this up on my computer and I won’t be able to get that until next week.  Also, I woul

Is there a way to join two tables using the between operator (SQL). I know I can use SQLCreator but I would like to do this join directly in workbench. sql example: TABLE1.*,TABLE2.*FROM TABLE1LEFT JOIN TABLE2 ON TABLE1.NAME = TABLE2.NAME AND TABLE1.DATE BETWEEN TABLE2.FROM AND TABLE2.TO

I have a database NAME1.If I open them as Oracle Non-Spatial I can access the following tablesNAME1.AANAME1.BBNAME1.CCNAME1.DDNAME1.EEIf I open them as Oracle Spatial I can access the following tablesNAME1.CCNAME1.DD The database contains more than 50 tables. They must be transferred to POSTGIS database with a different schema name: name2I have already looked up some things in the community. But those are old posts and some transformers don't even exist. What is the best way to approach this? in short:Oracle NonSpatial tables and Spatial tables from 1 database to POSTGIS database with a different schema name. Who can help me and or has an example? Thanks in advance

Before the web presentation of Safe and FME changed to what they are now It was possible to find the zipped FMEData. Data that are pointed at in almost every exercise in the FME Academy, community postings and videos.The new FME page does not provide the “knowledge” structure anymore as before and all links in the community etc. are pointing straight into Nirvana.I can see that these resource now can be found at https://s3.amazonaws.com/FMEData, however, I cannot get a listing of the content of this bucket and I always end up with a 403. Without a listing it is impossible to guess the specific file I am interested in…Can somebody point me to an URL where I can get the latest version of the FMEData?

The IFC data was exported using ArcGIS Pro. After importing it into FME Data Inspector, the following errors occurred:ISO10303-21: Skipping instance #50: Instance  is not syntactically valid An error has occurred. Check the logfile above for details Failed to specify the feature index as constraints on the reader  Could anyone please help with this? Thank you!

When trying to read an IFC file, I am getting an error ISO10303-21: Skipping instance #1154: Instance is not syntactically valid. How can this be fixed?

I need to copy records from one hosted feature layer in ArcGIS Online to another hosted feature layer. Schemas are identical. Some of the records in the source data have an attachment (only 1 per feature/record so only in the 0 position in the list). No problem getting all of the records to write from the source to the destination but the attachments are not included. Anyone know how to do bring over the attachments with the rest of the data?

Though experienced with reading WFS's, I'm a little bit frustrated about reading a WFS2.0 in the FeatureReader. It seems it is not paginating. Checking the WFS GetCapabilities, 'FeaturePaging’ is not mentioned.I want to query the WFS with a polygon. So that is my initiator. But I'm not sure whether the results exceeding the 50k or 100k or even 200k. That's why I want some sort of ‘FeaturePaging’. Anyone an idea on how to solve my issue? It's probably simple, but I can't see it at the moment.

Hi, I need help. I have an attribute column X with string values ‘S001’, ‘S002’, ‘S003’, and ‘S004’, all lined up in 1 column with 4 rows corresponding to the string values. I would like the output Y should to be a single row list, having just one column and one row, containing the four values:Y = (‘S001’, ‘S002’, ‘S003’, ‘S004’) Could you please advise how this could be done in FME Form. Greatly appreciated. Thanks, Willy de Vera

Hi, got a question from a client yesterday who wants (with FME2018.1) to connect to a SQL Server 2000 database (no the question is not from a museum: ).FME returns a Fetching Feature Types Error, "... SQL Server Native Client 11.0 does not support connections to SQL Server 2000 or earlier versions".Any ideas the minimum hazzle to get around here? Just to install the SQL Server native client 9.00 and problem solved? I do not have an environment for testing this myself :/ cheers

Hi,I am trying to request information from FMEflow with an httpcaller. I have created a temporary token that allows everything. If I include the token in the URL, the request works fine. (https://<...?/v3/info?fmetoken=abcdefg...)When I put the token in the httpcaller I get a 401 warning. What goes wrong in the caller? 

Hi, I am trying to convert raster data in the forms of .grd, tiff or GRID from ArcGIS Pro into a csv/table. If anyone can point me in the right direction, that would be greatly appreciated.  GRD file loaded on ArcGIS Pro 

version: 2024I am trying to convert data from fgdb to dgn. I used AttributeSplitter and DGNStyler to reassign size and width to each text elements. Single line text is work but seem mutiplate line text attribute igds_text_width_multiplier cannot write to dgn.  Is igds_text_width_multiplier in DGNStyler cannot update igds_multi_text?Remark: I tried FME 2021 is work. mutiplate line text attribute igds_text_width_multiplier can write to dgn.

Firstly I combined my building objs by Aggregator, then I separated them by Deaggregator, finally to b3dm. I have coordinates of those building objs but All building overlapped in Cesium, How can i locate the buildings according to coordinates.

Hi, I have created a gdb with 2 feature classes, strings and points. But it only works the first time. Every time I make changes to the model and run it again I get errors. I have tried changing every setting but nothing helps. The only thing I can do is create a new gdb every time but that is not the intention.I usually use the Insert and drop and create settings   

Hi, I’m using FME 2024.1.I want to write xls files out where my field names appear in Column A (with their corresponding value pair in Column B) instead of in rows. Sounds simple, right?!Writing the data out with an Excel Writer produces a default output like this:Field Names in Row 1, values in the corresponding column....this doesn’t make for a particularly human-readable output when you have 250+ fields in the output dataset.This is the style I would like the output to be in:Field Names in Column A with matching values in Column B.I have tried using an AttributeExploder to create n

Hello : ) I have a Form workbench that first deletes some records from two tables in a geodatabase and then inserts new records into these tables in the geodatabase. This worked fine in FME 2021 but after upgrading to FME 2024 the delete creates a lock on the geodatabase and causes the process to fail: An error occurred while attempting to open an insert cursor on the table 'Total'. The error number from ArcObjects is: '-2147220947'. The error message from ArcObjects is: {Cannot acquire a lock.} Any advice on how to fix this problem would be great. 

Hello FME Community,I am trying to convert annotations from a CAD (.DWG) file to a GIS (.GDB) file in the form of points, in such a way that each line of annotation text is a separate point with an attribute of this text. Everything seems to work fine in my workbench, however, after attaching to GIS programming and loading the resulting points, it turns out that in many cases additional points have been created in each line of text, which prevents me from using them correctly.Has anyone encountered something like this and would be able to help.I attach screenshots of sample annotations in AutoCAD and after conversion in GIS software.FME version: FME(R) 2023.2.1.0 (20240104 - Build 23774 - WIN64)