Data

Hi, does anyone know how to fix the "Geom" field and turn it into appropriate coordinates? I downloaded the CSV file from the city of Vancouver open portal and ran it in the FEM workspace without changing any parameters, but I couldn't see any point features after. I was wondering if I should fix the attributes as the coordinates are within the same field? Thank you!

Is it possible to get an additional attribute from a las file in FME. Indeed I have an input point cloud in las format with a vertical distance attribute on each point.I need this attribute to make statistics.How to get this attribute directly when reading the las file (or other) without passing "PointCloudCoercer"?

Is there a work around to be able to import Datamine, gOcad and Leapfrog 3D objects within FME to be able to automate queries and manipulations on these objects?

Hi there,  I have a 3D object in .las format which contains RGB values for each point in the point cloud. The goal is to get this object into an Esri .slpk format and keep the RGB values so the final object is colored correctly.  The .las file doesn't have a coordinate system but has relative xyz values; seems like the object is centered at 0,0. When using the CoordinateSystemSetter, it doesn't seem to change the XY values at all. This is just part of the problem.  The other problem is when I try to write out to .slpk using the Esri SLPK writer, I get this error: The layer requires triangular mesh geometries. Features whose geometries cannot be triangulated will not be written How do I convert the .las file into a triangular mesh so that it can be written to SLPK? Is this possible? Do I need a different input format? Other options could be .xyz or .pcd for the input file.  I haven't really worked in this space before so any guidance for working with 3D would be helpful. Tha

Hello!I have a set of points representing the location of the tree trunks. I also have a 3D model of a tree that i want to be copied to each of the points locations. And here is the tricky part, I need them to be instanced geometries, so they do not require to much space (and rendering power) when I export to fbx, skp and dwg.I tried to read up on the GeometryInstantiator-node but I must admit, I don't quite follow what it is supposed to do. Is there an example for this availible anywhere or do anyone have a clue?Here is a screendump of my script, but it only manages to place the trees as individual models which creates a 30MB file from copies of a mere 15KB geometry-asset.:Sincerely,Robin Nilsson

Hello,question about SSO for FME Server 2020. Is the SAML protocol supported?ThanksRoberto

I have an ArcGIS feature layer with two tables that I'd like to backup daily. I've created workspace with two readers and two writers. The Esri ArcGIS Online (AGOL) Feature Service Readers read from the two tables. The Esri Geodatabase (File Geodb) Writers write to the same geodatabase (.gdb) folder.  This works great. For the GeoDB writer I'm using Insert for the feature operation to append rows onto the destination table. Since I'm writing to the same GeoDB folder, over time I don't think that this is not the same as creating a copy. I'd like to try to append the date to the file name such as fileName_220503 for today so that I have a new gdb folder. I'm not sure how to do that. Ideally, storing no more than 30 or 60 days of backups would be best. So, maybe appending a number (instead of a date) would be better. I plan to run this from the Windows Task Scheduler (which I have not used before). I'm not sure how to limit the number of backups to 30 or

Hi, I'm creating a workbench to make some audit on GIS files. First my workbench list all files that are into a directory (including subdirectories).Then, I filter theses files to keep only the one I want to audit, for exemple every shapefiles.Finaly I get the schema of every shapefile with the <schema> output of a FeatureReader. It works really great but if I have two files with the same name in two different subdirectories my problem comes : only 1 schema is kept.That's how FME works, it unions feature types with the same name. But in my case, I need to analyse the schema of every layer even if they have the same name. This is an audit so these file can have different schema even if they have the same name. I want to have an automatic workbench and not having to create one FeatureReader for each directory. Is there anyone with an idea on how to get the schema of two files with the same name in two different subdirectories ? Thank you

Hello, please, I have met issue that I read DWG Layout in FME. But unfortunately FME is not able to load raster which should be in Layout. I use parameters "Read Paper space" as You can see in attachment. Is it bug? Or is there any workaround, how to read raster in DWG Layout? Its very uncomfortable, because I need to transform DWG Layourt to PDF. Thanks a lot!Lubo

I have a workspace that is updating about 100,000 records online. It will do a couple groups of 1000 updates before the rest service returns an error:"The error code from the server was '1000' and the message was: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." Is there a way to get around this error? I was thinking that reducing the number of records updated per rest call would help but I dont see a way to change the number from 1000. Thanks!

I have a feature layer with two tables in ArcGIS Online. It constantly receives new records from Survey123 survey. I'd like to join the tables together in FME them regularly import data to a new ArcGIS Online feature layer (with one table). Is this possible? Are there examples on how to do this? What transformers should I look at? Thanks.

ZMap writers have headers and within that there is zmap_format_name which by default is set to "ZMAP DEFAULT " Is there any way of writing out a different value? Thanks, Glenn

Hello, is it possible to set the cell/column width in a dynamic Excel Writer. I can imagine to precalculate the width for each column or to use a auto mode. Hendrik

What type of Autocad drawing was used in training that showed road names and other information as attributes. Usually DWG does not have any attribute unless we use AutoCAD Civil 3D etc. I need to tell my AutoCAD staff to provide me CAD data in that same format so I could easily convert the DWG into feature classes with useful attributes directly coming from the source DWG.

Hello, please, I wanna ask. If I wanna export many viewports of DWG in FME Desktop, is there any way how to define which layers will be frozen in each viewports? I need little bit different composition of layers for every viewport. Thanks a lot for tips!Lubo

I have created a workspace which has a prompt for user parameters, as I want the user to be able to run the workflow on different sets of data. The workspace reads in a set of CSVs which have identical schema, performs some transformations and then writes the data out into a single CSV. The process works for what I want it to do. The problem is when the prompt comes up to run and I choose a different set of CSVs, these CSVs have the same schema as each other but not the same schema as the previous set of data. The attributes that are used in the transformations are the same but other attributes are different and this data does not get read in. I want the reader to read in the new schema each time, but it always retains the schema from the first set of data I used to set up the reader. How can I fix this?

Hi, I've configured a FeatureWriter to dynamically write feature classes to an ESRI Geodatabase, but I need to be able to write different feature types to different databases. I've configured the FeatureWriter to get the connection file from an attribute, but it only uses the first connection file attribute it receives, it doesn't change connection based on the attribute value of the incoming features. Is there a way to get it to do this, or do I need to setup a writer for each possible database connection?

I made a simple workflow to compare two datasets using the Change Detector and make the changes to one of those datasets using a writer. The process works fine, but it takes roughly a second per records updated. Is that a normal speed? It's alright for small numbers of changes, but this dataset can have thousands of changes from day to day, which would make the workflow run for over an hour, and that's only one dataset when we need to update dozens of them every night. I've looked at the performance tuning article and it either doesn't seem applicable or I don't know enough about the software to know how to check it. My data isn't versioned so I'm using a Transactions writer; I saw another question that had this problem but the answer was to not using the versioning writer. The writer is set to fme_db_operation (so that the updated, inserted, and deleted ports of the Change Detector will work) with Use Existing as the table handling. If there's other inf

Hi all!I have a workflow when I read and download image attachments from ArcGIS Online. I have used the AttributeFileWriter to download the image to a unique filename and it has always worked smoothley.  Now I am trying to do the same with image attachments from our ArcGISPortal and it works fine to read and download the files, but when I try to open the files it says that “It looks like we don’t support this file format.” If I go to ArcGISPortal and manually downloads the image file, it works fine. Does anyone recognize this phenomenon? Best regardsJohan 

I've been trying to access some internal data which is being published from TopDesk via an OData feed. This is the first time I've tried to use odata... I'm using the OData reader, and parameters provided by the TopDesk administrator here. I have a url, a username, and password. I'm using basic authentication. After clicking the browse button beside Feeds, I get the error message "Failed to retrieve feature types."  Does anyone have suggestions on what I can do to successfully connect? Note I also get an error when trying to connect to it from Excel 2016:This sounds like a problem with the account.However, I am able to connect to this odata feed successfully using power BI, and using the same url and credentials as above. During the connection process there, the only difference in dialogues that I can see allows me to choose the "level" at which I wish to apply the login settings to (I chose the root portion of the url).This then lets me view t

i have used DGN Reader to read DGN File and it reads great but to modify the font size that read from this file , i use attribute creator and change the value in igds_text_size but i have no effect . could someone fix my problem , why i got no effect of the font size ? and is there other method that i could use to modify the Font size of text ? FME 2020 Thanks in advance

When I convert a GeoTIFF to ECW, the bright colors of the GeoTIFF are not preserved in the ECW output. Is that possible anyway, to convert it and preserve 100% of the right colors? Searching the knowledgebase, I have found some directions to a solution: How to preserve exact colors in raster conversion .ecw to .tiff? (safe.com) But in the end, how could it be done? Does someone has experience with it? Find examples below of the original GeoTIFF and the ECW output.the faded example is the ECW filethe bright colored example is the GeoTIFF file

I have created a 32 bit DSN ODBC connection using the progress/openedge 11.7 driver which connects successfully. I am trying to then connect via FME 2020.2 and choosing the ODBC option to connect but I am getting a message returned as follows?The specified DSN contains an architecture mismatch between the Driver and Application 

When I load my excel file I want the Day attribute to be read as type char so I can split it with string functions (Left/Right). The problem I have is that FME insists on reading the attribute as a 64bit real. I have tried removing the reader, purging the temporary files, saving the workspace, closing FME, and then add the reader again. But I keep having the same result. Are there any suggestions or is this standard for the Exel reader?