Data

Hi there,I'm having trouble reading a Sharepoint Online list using FME 2017.0 - I was able to do this in FME 2016, but would like to use 2017 so I can also use the CSV2 reader..The error seems to be something to do with SSL verification. The username and password are definitely correct because this exact same reader works in 2016.Thanks, error message below:Microsoft SharePoint List Reader: SSL certificate verification failed for host 'XXXX.sharepoint.com'. HTTPS connections may not be secure. Disabling verification of SSL certificates. Message: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:590)Microsoft SharePoint List Reader: Error authenticating via SAML. Verify that the username and password are correct, and that this is a SharePoint Online instance. Response message was: ''A fatal error has occurred. Check the logfile above for detailsFailed to obtain any schemas from read

I'm looking for anyone else who might have experienced something similar. I have come back into the office on Monday to find that the FTPWatcher on the FME Cloud has just detected all of the files on our FTP server as newly created....which caused a lot of workspaces to run....  I suspect something must have happened to the FTP Server itself, however, I can't see anything which might have happened. When looking at the files using Filezilla all of the dates and times of the files seem correct.There is this snippet from the ftpwathch.log which seems to be right before all of the new triggered. There is no timestamp on it, unfortunately.it.sauronsoftware.ftp4j.FTPException [code=550, message= Data channel timed out.] at it.sauronsoftware.ftp4j.FTPClient.list(FTPClient.java:2169) at it.sauronsoftware.ftp4j.FTPClient.list(FTPClient.java:2273) at COM.safe.fmeserver.relay.plugin.ftpwatch.FTPWatchPollingThread.retrieveFileInfoRecursively

As an example above, I have 2 files with different attributes as headers like Year numbers.The excel reader reads file 1 with years but If I use the same reader for file 2 then it does recognise the non matching attributes and its values.  How can I read the attributes dynamically irrespective of which excel file I am reading. Any help is greatly appreciated.

I'm using file copy writer to copy gdb from source location to destination. I'm using file copy writer for this. One of the parameters in this writer is Error on invalid destination which I have set it to NO. So, this means that, if there is no valid destination location found, FME should proceed further without terminating the translation (This is according to the documentation). But, this doesn't happen. So, how can I handle the error and proceed further with the translation without terminating it. Could anyone provide some suggestion on this?

Dear Support team, We are trying to import Autocad(.Dwg) file data into Smallworld database by using FME. In FME if we read the DWG file it is not showing attribute data present in source file. If we open DWG file in Autocade the attributes are visible as in image. f we try to open same DWG file in FME workbench. Attributes list is not coming for maping with target database(Smallworld).DWG file in FME Workbench:We request you to please provide steps to read Autocade DWG file by using FME.

Hello,Trying to setup a process to parse and load IIS log files to a database to monitor errors on a Geocortex site.I have a workspace that returns the file path of the most recent log file and that is passed into a FeatureReader with the CSV reader.The data is space delimited. The issue is that the field name header has one extra field (X). So when the text file is parsed, the field names are offset one column to the right. Header: X |1|2|3|4|5 Data: 1|2|3|4|5|I need to remove X in the Field name header, and shift the header one cell to the left.Ideally this could be done in the CSV reader, but I don't see how.Thanks for the help. Much appreciated.-R 

I am trying to read data from an ArcGIS Server Feature Service and am running into an issue with FME accepting the token. When I enter the Service URL into the parameters dialog, put the token in the token field and then test the connection by clicking the button to view the layers list I get an error that tells me it's an invalid token.To access the feature service I have to log into a website using a username and password. From there I have to cut a token to connect to allow FME to authenticate to the ArcGIS Server service. I have no way of validating that the token I generated is correct but I followed the steps outlined in the following ESRI support document so I assume it is correct: http://server.arcgis.com/en/server/10.3/administer...The one suspicious piece of the puzzle is that my token seems to be truncated somewhat. Maybe its standard

ESRI has a Runtime Geodatabase used by Collector for ArcGIS. The file has a .geodatabase extension when downloaded from an iPad or Android tablet. In reality it is a SQLite database. I can query it with SQLite Studio 3.0.6, but not read it with FME 2018.1.

I have a shape file with feature class polygon and want to convert them into an osm file. I've verified the polygons by several transformers in workspace. The result is always an osm file with lines instead of polygons (FME Inspector)???

I am designing a workflow that will streamline our our 911 data to ESRI ArcPortal as well as a local geodatabase. the information fed in is from a SQL server and represents specific apparatus information as related to a particular call, and runs through some calculations for things like response time, time on call, etc.. I've gotten to the point where the data splits off in 2 streams one for apparatus data and another for unique call data compiled by merging apparatus information and aggregating the data by the Call Report number. Everything works fine to this point.The initial run of this yielded over 600,000 features to be written since a dataset of call information didn't exist prior this was expected. This initial dataset was then uploaded to our portal service since the Portal writer appears to only insert, update or delete. I run the script daily to pull the previous days call information and when it got to the point that the data was going to be pushed to our

I know that there is a writer that writes, updates or replaces data in availible layers. Is it possible to write multipatch also? Second question; is it possible to create new layers in AGOL from FME?

Hello FME Community, I have a workspace running smoothly on FME Desktop, but as soon as I launch the workspace on FME Server, I'm confronted with an error message like this: The workspace reads some data from different sources, performs some hocus pocus and finally writes to autocad format. I've replaced the Autocad writer with a simple .txt writer, to ensure the problem is not situated at the writer.The FME Server account has writing permissions to the folder location I'm trying to populate with some data.Since I'm creating a new Autocad-file, I'm quite confused with this error message. The file is generated by my workspace, so it can't be opened in another program.What can be causing this error ?Has anyone experienced this error before ?Kind regards, Dries

Is it possible to delete an entiere sheet in a Excel document? While a writer allows me to delete input in a certain sheet, I can't find a way to delete a whole sheet.  Thank you,

I have a general question about the way FME is able to read data. Right now I have data stored on a fileserver, which I want to read into FME directly.What would happen if someone else is accessing this data, either directly or through another application, while I was reading the data into FME? Would this cause an error in FME? Or could simultaneously reading the data from the fileserver, while someone else is accessing or probably editing this data in another apllication have a negative effect on the performance in the other application?Now, I just copy the files from the fileserver each time I want to read them all. However, I'm trying to find out if this is really neccesary or if I can just load them directly without causing other problems.

Which fme attribute data type to use in the schema definition file, that dynamic writer will be using to output the ms access tables? When I am using fme_char(65,536 ) and fme_varchar(65,536), workspace truncates fields to 255 characters...

Hello, I am trying to get data from a IFC File into a Postgresql Database. Preferentially I would like to work with a java code which reads the IFC File and writes the attributes in a Database similar to the ODBC Export from Revit. But I am not able to do that.  Does anybody have any suggestions? Thank you in advance.@daveatsafe

Hi,When I´m trying to read a layer using the ArcGIS Feature reader it´s resulting in the following error:Creating reader for format: Esri ArcGIS Server Feature ServiceTrying to find a PYTHON plugin for reader named `ARCGISFEATURES'Loaded Python module `arcgisonlinefeatures' from file `C:\\apps\\FMEBeta\\plugins/python27\\arcgisonlinefeatures\\__init__.pyc'Python Exception <ImportError>: No module named parserCould not create Python Reader `ARCGISFEATURES'A fatal error has occurred. Check the logfile above for detailsThe weird thing is that in the scripting parameter the Python compatibility is set to Python 3.4+ but still it´s using the Python 2.7 plugin?I´m using the latest build (20170517 Build 17494).Christian

Hi, Looking to create a 3d sphere from the XYZ coordinates in the attached CSV and then add the "Filename" property to each sphere. Can someone help? Ive tried the Hub3DBufferer, but I cant get the geometry created. Happy with an AutoCAD or similar output. CSV file attached if anyone can help me

 Hi FME experts,I have stored polygon objects in an Oracle database. The geometry is in the GEOM field. For an interface, I have to convert the GEOM field into a text field. The GEOM field looks like this:select geom from VIEW_RIWE_2016_BORIS where fid = 70118sdo_geometry(2003,25832,null,sdo_elem_info_array(1,1003,1),sdo_ordinate_array(510843.904449149,5369878.15541307,510782.847025386,5369803.95356616,510757.074323074,5369773.29550141,510804.270134531,5369734.73477362,510819.559582734,5369752.69084497,510863.309430839,5369806.93171413,510890.267651986,5369838.63447086,510843.904449149,5369878.15541307)) The TEXT field must later look like this:POLYGON ((32563549.456 5934230.837,32563553.002 5934219.989,32563552.58 5934219.778,32563542.348 5934220.82,32563537.637 5934221.725,32563533.431 5934221.663,32563522.282 5934224.668,32563543.799 5934230.72,32563549.027 5934230.188,32563549.456 5934230.837))With a bit of text editing, I

Hello, I was asked by a colleague if I we can use FME to create a report with 3D Thumbnails like this:And I'm not sure? Is there a way?I guess I would have to create the thumbnails externaly and join it back together to create a pdf? 

HiI am clipping a LAS file and writing to a new LAS file. I have noticed in the LAS Header the following fields have not been updated and contain info from the original LAS file:system identifier generating software file creation day/yearWhen I clip using lasclip these fields are updated so I wondered if there is a reason FME doesn't?TIA 

I have approximately 170 tables from a sqlite database that I need to convert to geojson and save as @Value(fme_feature_type). I have a workflow to process each table individually but I need a way to automate the process. Passing all tables through the same workflow merges the schemas of all input tables. It isn't practical to pass each table through its own set of transformers when dealing with this amount of tables. Some type of loop control seems logical to pass tables through the workflow one after another while ensuring that output schemas are refreshed after each iteration. I'm fairly new to FME so any help would be truly appreciated.

I received a sample of IFC data and was asked to import it into MS SQL database spatial database.I was able to import the data but no geometry. How do I get the geometry? This is new data for me. @DaveAtSafe

Hi there,Probably a fairly simple one for you, but I'm a total novice!I have hundreds of thousands of files in PDF and TIF formats hosted on a server - lets call it Server 1.In a SQL2008 database on another server called Server 2, I have over 100000 records which contain a specific reference number which links these files individually (so that one reference number might be linked to several PDFs or TIFs using the same reference number, e.g. Ref number 19994321 on Server 2 will be related to PDFs/ TIFs with the Ref number 19994321 on Server 1).In an Excel spreadsheet, I have a list of the reference numbers on Server 2 that I want to retrieve files for from Server 1 and I need to call them using two field names in the SQL database which defines the PDF/ TIF- under either 'Subject_Name' or 'doc_Type' and containing certain words as a parameter to narrow the search: 'Site Location Map' and/ or 'Location'.I want to th

Hello. I'm currently trying to figure out a way to extract 3D layers from a project I have online. I'm able to extract the parent layers, but I'm having trouble trying to get attributes from the child layers. I'm using a JSONFeature Reader, ListExploder, and a FeatureReader, but perhaps my parameters aren't correct. If anyone has any suggestions on a workflow, I'd appreciate it. Thanks!