Data

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 techniques I can us

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).

The first time I used it, everything was normal. But when it was used again, there was a mistake.One file is being used by other processes that cannot be accessed. But I couldn't find which process was using it, I tried to restart the computer, but the problem still didn't work out.I hope to find a solution?thanks very much.

Dear Sir/madam,I am student, working on OSM highway(poly_line) xml data with respect to the keys Max_speed and surface for the whole Africa. In this case; I took at first, the Geometry Filter with line and I used 2 list_searchers for max_speed and surface respectively. And also use 2 attribute_creator for output. This way is working to get a Geo-database file which i can use on Arcmap. But it takes a long long time to read the data because of XML data.Could you please help me to find the faster way or model to run the XML data? OR a faster way by using PBF format in this purpose in FME?Thank you.Sincerely Yours,Yasin

Hi, there is a revit model that is normal when exporting ifc, but some models are lost when exported as rvz files. Lost this part of the model is mainly the use of structural framework order to create the components, especially the arc-shaped parts easily lost.IFC4RVZRevit File:revit file_google driverevit file_one driveThanks.

The FME tell me that translation was successful when I converted COLLADA to Cesium 3D Tiles. But I want to look at the model of 3dtiles through FME Data Inspector, it's failed. I tried to apply this 3dtiles format model to the my project, it's also failed. I can ensure that my collada model has no problems.The FME also tell me that translation was successful. I don't know why the 3dtiles format model will go wrong. I want to know where the problem is and how to solve it.