Data

Hello,I get Geodatabase Error (-2147024894): The system cannot find the file specified. Could not open File Geodatabase dataset `\\\\coacd.org\\dfs\\PDRD\\IT_Services\\GIS_Group\\Programs\\Zoning\\test.gdb' for writing when using FME Server. This works on my desktop.I've checked on permissions, and was told I have modify privileges. I tested that by writing a shapefile to the Zoning folder and that worked. As you can see I am also using the UNC path. I've also played with both the arcobjects and API writers. I have a sample workbench that I am testing. I would appreciate anyone looking at that or giving me some clues on this issue. Thanks! 

HiI have an issue with NULL geometry features in ArcGIS. Such point features occur when I write them without a geometry to a ArcSDE DB by using FME. We found out that not only FME has problems reading such NULL geometry features (when using an ArcSDE Reader), but also when reading them through ESRI Mapping Services. However, when using an empty geometry instead of a NULL geometry, no errors occur.In the Oracle database, a NULL and an empty geometry are differently defined:NULL geometry: NULL Empty geometry: MDSYS.SDO_GEOMETRY(3001,2056,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,0,998,1,1,1),MDSYS.SDO_ORDINATE_ARRAY(1,1,1))Is it somehow possible to write empty geometry features in FME (2016/2017)?Greetings, André

I have made an aggregation of lines that I have saved in MS SQL. when I then make a STGeometryType () on the table I find that a GeometryCollection has been formed. I want to avoid this and instead save it as a MultiLineString. However, I do not find any settings where I can control this. (then I will do the same for points and spaces to completely avoid GeometryCollection.)

Power BI allows the developer to access data either by a direct connection to a database or by importing a dataset from a database. The import makes the operations in the Power BI report faster because the app doesn't have to go directly to the database, but the data is not fresh. Are any plans to create an FME writer that could access and write to Power BI to emulate the import process? That way an FME script could be run on a regular basis to refresh the imported 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. What I am

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!