Data

Dear FME-Community, We have a customer who wants to update an excel-file regularly with data.  The customer placed the file on his onedrive account and shared the link with us to be able to read the data. Now we want to directly process and read the data of this Excel online file using FME. Is it possible? I couldn't get the Onedrive-Connector to work, because we don't want to use any files on our own account, but want to use the shared link of our customer.I also had a look for possibilites, to download this Excel file on a regular basis on our server. Also with no success...  Thx for any tips or hints.. best regards, Chris

I tried to read data from postgis reader and write to a geojson file. I only use two translators, a postgis reader and a geojson writer.I encounter the "Error running translation." every time when feature number is about 40,000,000. I only use two translators, a postgis reader and a geojson writer. The translation seems to have no issue if the feature number is around 10,000,000. There was no other error message.I also tried to turn on the debug log but still had the same error message. I am using FME(R) 2019.2.1.0 (20191202 - Build 19813 - macosx). Thank you!

I have a need to take stacks of documents and upload them to SharePoint Online and organize them in respective Libraries and Doc Sets.My idea is to have the 1st page of the scanned document, which is saved as a PDF, read the contents, then rename the file based off the text found on the 1st page. Uploading those files into a Content Organizer, based from file name, will accomplish SharePoint challenge.Any ideas of: Read content of file, then rename file from that content?

Hello there, I am a bit new here. Thus this might a bit of a simple question, but I'd really appreciate it if you could point me in the right direction. I have a GML file from which I only need the heigh and area of the buildings. I'm trying to use the interpretability tool from ArcGIS pro. But somehow the transformation is not working properly. Any idea what transformations I need in order to extract to a shapefile/database the info I need?

Currently trying out FME in demo mode and am definitely green at FME so this is a beginner question.I currently have a workbench setup to read a single dwg, run it through a tester to filter out only the desired layers, and then write it to shp format with the dwg_name and layer_name as attributes.I have also discovered the PATH reader which I have configured to search a drive and all sub-folders to generate a list of all of the dwg files I want to run through the above. How do I combine them?There is a related question 80618 "How to iterate through a list of .dwg file in order to convert them to .shp format" but I am not quite following it, and I have multiple sub-folders.  

could i ask how to extract from oracle file specific city and the neigbohrs of this city.from the 4 side if available .should i write code in ql statement or what should i do . i do not want to have only one city ,i need also to get the neighbor cities so when i have lines intersected in specific city and neighbor city ,so i could know which neighbor city and intersected with which point .thank for any help

could i get intersection between lines and points in oracle files one of them is spatial and another oracl not spatial just i do not want to load all oracle files in spatial and it will make the workspace slow so i was thinking to to import one spatial oracle file and another not .spatial .is it possible to find intersection between both of them or should i load all oracle files only in spatial .Thanks

I cannot connect to an ArcGIS Server Feature Service though either a reader connection or a feature reader.The service I am trying to connect to is:https://services.thelist.tas.gov.au/arcgis/rest/servicesI have not problems connecting and accessing the data through ArcProI am using FME 2019.1.0.0 (20190710 - Build 19608 - WIN 64) with and Oracle Floating LicenceAnd also have FME 2015 installed, which i need to keep until we have updated some legacy processes. There is probably something very simply I am missing but for the life of can't see it. Below is the translation log from when I try to connect to the service with an ESRI ArcGIS Server Feature Service Reader ( I have highlighted the errors in Bold): Starting translation...FME 2019.1.0.0 (20190710 - Build 19608 - WIN64)FME Desktop Oracle Edition (floating)Permanent License.Machine host name is: TN4405Operating System: Microsoft Windows 10 64-bit (Build 18362)Copyright (c) 1994 - 2019, Safe Software Inc.Safe Software Inc.2020-03

Hi,I have an ArcSDE geodatabase on postgres. Im using a feature writer to insert records in an existing feature class.While doing so, I get the below error 'ERROR: null value in column "objectid" violates not-null constraint'When I drop the table and create new while writing, I get no errors.Logically, the sde should autogenerate this objectid field whenever I insert a new record. Am I right or where am I going wrong?Please suggestThanks

I need a workspace that will convert DWG to SHP. I get DWG files all the time and my Mapping software imports shape files. So I need shp files rather than DWG all ineed is the lines in the DWG not so much any data. I need help. I've tried different things with bad results.

Hi,I'm re-projecting some 3D AutoCAD drawings. After converting them the filesize goes from 4mb to around 40mb, this is using the deault settings for the reader and writer, so not sure why they have increased in size with re-projecting the data from snakegrid to OSGB.What are the best read and write settings when reading and writing AutoCAD files?Adam

Hi list.I'm tasked with creating an XML, that is compromised from many different sources (database tables/views). I'm plannning to use a number of XmlTemplater's to accomplish this.But each feature from some of these sources is represented in the final XML as a bit of GML wrapped in special tags.FeatureWriter will collect all input features into a single GML file. This is not what I want.Is there a way to make FME output the GML representation for each feature ?Cheers.Lars I.

Hi, I am trying to generate a simple HTML page on FME Server 2017 to start an FME Server Jobsubmitter Job. I use an HTML template where I replace the server part of the URL by $(FME_SERVER_WEB_URL). We are on a secure environment and the FME Server is on URL https://myfmeserver.mycomp.nl:443/fmeserver. But when I use the FME_SERVER_WEB_URL parameter, it returns the insecure version of it: http://myfmeserver.mycomp.nl:80/fmeserver. The service URLs are configured for SSL, i.e., starting with https://. How does FME Engine "know" about its URL? What is the source of the $(FME_SERVER_WEB_URL) parameter? Thanks in advance.

I have a jpg of a historical map (with no accompanying data) that I'm trying to write data for to upload into google maps as a KML file. I know the coordinates of the map, so I started with the RasterGeoreferencer to assign the correct coordinates. The problem is that none of the data that I want to create/ add to the file (for example, a z coordinate with the 3d forcer) shows up. There is a coordinate system assigned, and I can find the coordinates of any point I click on in the graphics window, but the data doesn't seem to be stored in any category.This returns missing data for everything except for the source name...How would I properly write data for my map so that I can turn it into a workable KML file?

When joining file-GDB dataset with GML dataset and then writing to GML the geometry is missing in the output, if I dont join with the GDB the geometry is in the output. Is there some hidden GDB features which causes this ?  Or what is happening ?

I'm trying to write jpgs that are created from a blob directly to a folder in ProjectWise. I'm a newbie at this so maybe I'm just missing a step? Works fine when writing to C:\\Temp with JPEG Writer

Due to the COVID-19 outbreak, we are cancelling the Safe-hosted FME World Tour events this year. We are working to bring them online and will be providing details shortly.Our team here at Safe Software has been closely monitoring the evolving COVID-19 situation. After taking the guidance and recommended safety measures issued by the World Health Organization and health authorities into consideration, we have made the difficult decision to suspend all in-person Safe-hosted World Tour events through to the end of April 2020. During this time we want everyone: our team, our partners, and our customers to look after yourselves and those you care about.While we will most certainly miss seeing you all in person, we plan to share the latest updates in FME 2020, along with time-saving tips and best practices you can apply to your work, during our virtual event. More details about this will be provided soon. Stay updated with the latest news by signing up for email updates below.   For more inf

Hi, I wanted to make Cesium 3d tiles in FME.My source model is textured collada (open collada from 3dsmax).Fme is producing 3d tile files, but in cesium i have problems rendering them.it gave me errors like so:when i'm creating cesium3d tile file in FME with .OBJ source model its just fine (besides materials):but the goal for me is to produce 3d tile from collada wich i believe would give better anti-aliasing/mipmap result in cesium, what is main problem(as seen on screen above).1. Does anyone knows how to export proper Cesium 3d tile (b3dm) using Collada as reader?2. Does anyknow knows how to get proper antialiasing/mipmapping settings in cesium with 3d tiles(b3dm) using OBJ/DAE as reader in fme?Thank you in advance!

have a few shape files that I'm merging together using multiple transformers including LineOnLineOverlayer and Line Combiner and writing to SQLITE Spatial format. The file processing takes a few minutes but the SQLite Spatial writer takes up to half an hour to write 130,000 line features. It must find something disagreeable with the processed features that is over my head. Once the features are in SQLite format, and doing any additional processing, the SQLITE writer has no more issues. I have tried it figuring this out from all angles, but its time to reach out to the pros. I have attached a sample line feature right before and after SQLite Writer. If you need more details let me know.Thanks in Advance.I

Hi,I have a script where I read from a table, lets call it A, to another table, lets call it B. In table B I have added a number of columns (and attributes in those columns) that doesn't exist in table A. This script needs to be automated. However, what happens is that it deletes the attributes that I added manually. I dont want that to happen. What I want for table B to do is:1. ONLY update columns that derives from table A. 2. DO NOT delete attributes that only exist in table BHow should I proceed with this issue?

I have some aerial images that need geotagging from a CSV file. I'd also like to get the world file for each image. I'm new to FME and have tried to read docs/forums on how to solve this problem but am stuck. Appreciate any tips/how to's. Thanks

After upgrading to FME 2020, I went ahead and changed my password. I entered it into my password keeper, copied it from there into FME, and confirmed the change. However, that password didn't stick in my password keeper. So I am unable to login to FME web interface. Is there a way to reset the password?

Hi. I'm looking for a way for FME to check a folder full of GMLs and either delete the ones that don't fall within a shapefile area feature, or move those that do to a different folder, but I assume the first option is easier ... but I could be wrong. So for instance if I had a GML location for each Corona virus case in a folder, I want it to delete those GMLs that fall outside of my shapefile of the UK. Any ideas? Do it for the children - and the elderly! J

 if i rightclick on my excel and look at the Properties i need that date.How can i extract that date so i can work with it?(Origin --> Last save)

I am trying to make a CityGML file from IFC using a slightly modified workbench provided in one of the tutorials for IFC to CityGML conversion. After running the workbench i end up with unexpected input window.