Data

I keep getting this error when trying to write out large amounts of data from a workbench to the Default version of a versioned feature class in a SDE:|Error while retrieving an ArcObjects update cursor for the table/feature class 'ILMOCDBO.gtlf_ln'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]The app domain with specified version id (11) was unloaded due to memory pressure and could not be found.] [ilmoccmp.ILMOCDBO.gtlf_ln]} From what I've learned, that error means that the SDE ran out of RAM on the server that it is installed on. This happens because when FME is writing out the data, it is being written to a view in the SQL and the view lives on RAM while this happens. The error occurs when trying to write out large amounts of data, but can vary depending on the size of the data being written out and the amount of free memory. Wh

I have a published parameter of type "Choice with alias (Multiple)". In this parameter, I import all the towns, departments, regions... of France (like 40 000 lines) from a postgre table. When I run the workbench in FME Desktop, it takes a little time to filter the values according to what I'm writing and to select them but it can be ok. But in FME Cloud, it's very very very long and I can't really use it.I've try with a list without the towns (7 500 lines), it's better but still not usable.... Have you got an idea for my problem ?I know it's a big list for a parameter but it's the goal of my workbench. I have a table of 19 000 000 lines and I have to do a filter according to selecting territory by the user.Thank youDamien

Hi all,I'm trying to process one DWG and create another DWG. There are some blocks inside and I used DWGStyler to make it all right. And that works. But there are also a number of zero-length lines for which I want to stay lines in the output DWG. Instead, they are turned to points and converted to blocks. I've tried to set the advanced parameter "output zero length lines as lines" but it is not working. No matter what I do, they become points and convert to block in output. Their position is identical to block position. I need them to stay there, and stay as lines or points but not to convert to blocks. Any advice what to do? Thanks.

My workspace has two readers - Oracle and Postgres. Sometimes the Oracle reader feature has records and sometimes it doesn't. I'd like for the Postgres Reader feature to be read only when the Oracle reader feature has records - i.e. to be dependent on there being records in the Oracle reader feature. Is this possible to do?

All:I have an issue with the following error on my Windows 2010 R2 Standard 64-bit server running FME Desktop version 2017.1.0.0 (20170731 - Build 17539 - WIN64).When I have the same version of FME running on another PC, the workspace runs fine without a hitch.I can't seem to figure out the problem. Please note, I do have FME 2013 on this same server but the PATH for the environment variables have the 2017 path established before the 2013 path.Please Help!!! :)-----Python Exception <ImportError>: No module named parserCould not create Python Reader `GOOGLESHEETS'A fatal error has occurred

While I realise there are examples of this elsewhere, the techniques outlined don't appear to work for me. I have multiple CSV files that do not have a header, the first row of data is always being read in as the header row (despite me saying that the data is in row 1) and only columns with null data have "colX" so I don't see how I can use a concatenator alongside a dummy CSV with the true header information.Can anybody provide some detailed directions on how I can import csv's into a database using FME where there are no headers without excluding the first row? Thank you!

I am looking to convert an IFC export from Revit to an ESRI FileGDB Multipart Featureclass and would eventually like to view in ArcGIS pro. Any help or start would be much appreciated, thanks! Link to IFC: https://www.dropbox.com/sh/up76utq2soz6tjc/AADd-jppK5pJ6_q9Qtt6Jufwa?dl=0

I need to implement to load one Excel file into AWS RDS Database. And Excel file have multiple sheets and one sheet have 65000 records. And I don't know how many sheets will be come based on dividing sheets with 65000 records for one file. I searched google and FME knowledge. There is the similar answer which is using Generic Reader for loading all dynamic sheets. But it is not working using Generic Reader. Thus, I would like to ask the way to load dynamic excel sheets from one file to load into the database.

Setting the kml_open attribute causes FME to write an <open> tag to the placemark, but I suspect it should be written to the folder the placemark is in. That would make it unsuitable to be a format attribute since it applies to all features in the placemark. I would argue it's better to make it a feature type property.See https://knowledge.safe.com/questions/58958/how-do-you-specify-the-the-kml-open-attribute-to-f.html?&childToView;=59153#answer-59153 for additional discussion

There is a wonderful page that states that this is possible, https://www.safe.com/convert/dwg/postgresql/ , but I haven't found any additional documentation. I am not super experienced with AutoCAD, nor PostgreSQL. The page states that this can be done retaining details "such as annotation and symbology during the DWG to PosgreSQL translation".Ultimately, I am trying to take multiple DWGs and write them to our PostgreSQL DB into a "Master File" that could be imported, clipped, etc. back into AutoCAD for reuse.Any help on what formats to write to, etc. would be greatly appreciated. Thank you in advance.

I´m trying to input parameters (xmax,ymax,..) automatically from a shape. Is it possible?

FME: 2018, build 18220If I read from gdb (Esri Geodatabase (File Geodb)) no features are read with option "Individual Feature Type". With option "Single Merged Feature Type" feature will be normal read. The DataInspector works normal.It's a bug?

Is there a way to connect to a mysql server using an SSL connection?We are working with FME 2016 1.3.2, Windows version.

Hello allAm new this type of work(Conversion of BIM models in to GIS)Hope ill get answer here...Please look in to following work flow we are using1. We are preparing BIM models in Revit2.We are converting this BIM model data in to RVZ files by using FME converter.3.We are converting this RVZ files in to GDB data4.We are adding this GDB in to ARCGIS This is work flow we are following My problem is:Parameters(Type and instance) seen in Revit project are different compared to GDB propertiesFor Example: single doorParameters am seeing in Revit are not totally covered in GDB data and am getting extra properties in GDB data which are not in Revit.So where Problem is happening in which conversion...Please help me out from this issue..Thanks a lot in advance.

I have footprint of buildings that have attribute base elevation and point cloud of buildings .https://knowledge.safe.com/articles/1353/point-cloud-to-3d-terrain-model-with-buildings-dwg.html from this tutorial I can create only city lod1 . I want to know how to crate shape roof .Thank you

Hi all,I'm sure I'm missing something simple here but I can't see a way to limit the number of features that are read when the Reader is pointing to a folder of files eg. c:\\folder\\**\\*.jpgAs far as I can tell, the Max Features to Read options are only applied within a dataset, not across a number of datasets. I'm currently using a Sampler to throttle the number of features that are being processed at any one time but it still has to read every file into the workspace first. As the folder in question has thousands of image files, I would like an easy way to ensure that the process doesn't collapse!Cheers,Barrett

I am trying to automate an ESRI Enterprise Geodatabase Compress with FME Server. The problem I have run into is with using the Server Parameter FME_SHAREDRESOURCE_DATA I have stored my SDE connection files in a folder there. When the workspace replaces the variable with the path to my FME Data Resource it is including two extra slashes / between the FME Server folder and the resources folder like this ...FME Server///resources/data/ I know I can fix this by replacing that in the workspace or hard coding the path rather than using the variable, but I'm wondering if there is a way to fix this so I can use the system variable straight up?

Hi,Having some major problems trying to read all the IFC attributes using the Revit Reader. In summary, I cant exposed an attribute called Identity Data.Keynote and also cant see it in the data inspector. It is in the IFC.Ive put together a document to explain better in the attached.Any help would be appreciated and apologies for already uploading this question in response to another

From this Q&A;: Revit Reader - IFCPlateIt seems that this question is the same case as C130891 (PR#69269) I reported this Sept.Could you please check this? @DaveAtSafeI heard that this issue is planned to be fixed in FME 2018, but it doesn't seem to be implemented yet in the latest beta build 18213. It's a critical issue for a customer, and they (and I) wait for 2018 release.Hope it will be definitely fixed by 2018 official release. Thanks in advance.

Hi!  I have a successful workflow going to convert excel files to geodatabase feature classes and I'm trying to create a similar workflow but with CSV input.   I have hundreds of files that will need to be converted but am testing with 8 for now. I set up everything in the same way as XLSX -> GDB but with my CSV workflow every single field in my GDB shows up as text, despite the fact that some (most) of them contain purely numerical data.   Is this normal for CSV formats? Is there a way to prevent all these text fields?  Thanks!

The file formats for my model are COLLADA and OBJ.When I read the file with FME, I noticed that I could not pick a single entity on the model. The FME will automatically integrate the model into a whole, is it?In this case, my model exports files in other formats(as 3d tiles) via FME, and can I separately pick a single entity on the model?

I have an interesting dilemma and was hoping to get an idea of how FME peoples would approach it. I have an Oracle 12c DW with multiple data sources being loaded into it (FME is handling these well so far). However I have a data source with some interesting restrictions...it is a MSSQL 2008 data source that (for a variety of reasons) I can't directly connect to and the only manner in which I can get this data is via it's scheduled backups. Backups are done as a weekly full backup and incremental backups for each day until the next full weekly backup.As far as I'm aware, FME is unable to read these backups directly (please correct me if I'm wrong there) and I would have to restore these backups to an intermediate MSSQL server and then I can connect to that using FME as I have for the other data sources. This incurs a cost (sql server license and hardware) that I'm not entirely sure if my client is willing to absorb. Are there any other viable technique

It seems you can notify a user by using @sigtill. I struggle to write the @ and always need to copy it - when doing ALT GR + number 2/@ I only get large letters instead of the usuall @. Also it does not seem to notify me or any other when I use the @sigtill. Is this a known issue?

It seems everytime I run the Revit Exporter to .RVZ file, it's extremely slow. I've tried many different things to try to see it up but doesn't seem to make much of a difference. The latest attempt is I turned off as many elements as possible in the view and export only elements visible in view, and still take a long time. I am working on big model files and not sure if there's any way other than to just run the export and go get a cup of coffee (or two).