Data

I am manipulating a Google Sheet by inserting many rows of data via a Google Script triggered by my FME Workbench. What I wish to do is to read the Google Sheet all over again once all the insertion have been completed. I couldn't think of a way to do this except by pausing the whole workbench while the insertions are being donne.  Is there a more time-efficient way of achieving the same result?

I have a fairly large *.xlsx Excel file (27 MB), when I attempt to open this in an FME Desktop reader, upon selecting the "parameters" button or pressing "OK" the application crashes.If I re save the file as a *.xls file, this removes data and re-saving as an xlsx file doesn't achieve anything either.Any Ideas?

I am a new FME user and am trying to extract a text information from a PDF. Reading this fórum I came up with this: Using attribute filter I choose the page number I need to extract that information and the inspector showed me this:The yellow text is the information I need to extract. How do I do extract that to a excel file or csv?

This problem: " Unable to use format 'Smallworld 4/5'. Format is not supported on this platform (WIN64). Smallworld reader/writer has unmet dependencies. Please contact Smallworld to obtain the Smallworld reader/writer plug-in (Smallworld Translators Suite DVD). Please contact http://www.safe.com/support if you require additional assistance. " how do I solve this problem

 This article says "Note: When translating from DGN to DGN where a complex chain in the source data set has custom line styles, then you have to set the keyword PROPAGATE_CHAIN_ELEMENT_LINKAGES to true to translate the custom line styles properly to the destination format. " What/Where is the Propagate_Chain_Element_Linkages keyword?

I'm using a dynamic workspace with generic writer to create output files in the format that the user selects. When the user chooses to export as ESRI shapefile I would like it to also build the spatial indexes for the output shapefile. I can get it to write the shapefiles just fine but they don't have spatial indexes. Is this possible with the generic writer by setting it in the schema feature somehow? Or would I have to specifically use the shapefile writer which has it as an option?

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 reader 'SHAREPOINT' from 1 datasets. This may be due to invalid datasets or format accessibil

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(FTPWatchPollingThread.java:342) at COM.safe.fmeserver.re

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 but each token I've generated ends in "..". This just does not seem right and I was hoping that maybe someone has experience

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 portal I g

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 could easily edit the field. My problem now is that the SQL