General

Hi,I have a JSON file containing data for last 24 hours api information and want to convert it to excelThe time and api change accordingly depends on the time we browse to the JSON file. I would like to make the first list as the header but in the Attribute Manager we can't edit the Output attribute value.  This is what I got once I used List Exploder and Attribute Manager.Is there a way I can make the first row as the header? 

Hi all, I would like to get a mobile app using FME Server apps. I am trying to see if there is a way a user takes a photo, then once he takes it uploads that information to sharepoint.This photo then contains your Long/Lat information as it has been geocoded along with the time it was taken. Any suggestions if anyone has done this previously?     

I'm looking for a workflow that would combine Addresses/Attributes from a worksheet to either a 2D Shapefile of building footprints or a 3D fbx model (the FBX model is just the 2D shapefile building footprints extruded). I used geocoder to get address points from the excel sheet and need help moving onto the next steps of moving the attributes from the excel sheet to the 3d models they correspond to.

Let you guide you to measure the width of any road

I need to create a csv to load into another application so I'm using a csv writer. That works perfectly but I get an error becauwe FME uses an "," as a delimter instead of a ";". Does anyone know how I can change this?

Hi All I feel like this should be a simple problem to solve but... I have a dataset containing hundreds of points which represent places which require a delivery. I want to divide these into X equal zones which minimise the amount of travel required for the delivery driver. Having done that, I'd then like to order the delivery points within the area so that they're roughly in order - this doesn't have to be very precise so I may just group and sort by postcode unless anyone has a better suggestion? Any advice appreciated - thanks!

I want to replace attributes from Unicode to without accent.For example : Find âÂăĂđĐêÊôÔơƠưƯ --> Replace aAaAdDeEoOoOuUĂn >> AnĐô >> Do Could you tell me how to replace it by python or other way?Thank you

Thanks for any help!

Question of the WeekIt's been a while since I got to highlight a question, for which I apologize. But here is a question that was asked during our recent replay of the Shapefile webinar. "I have a question: I have a large number of shapefiles that I need to turn on some "Format Attributes" like FME_dataset" and "FME_Basename". Is it possible to turn on these format attributes by default when I put the shapefiles on FME workbench?" So let's have a look at how we can do that. Format AttributesEach feature FME reads has three sets of information. There are user attributes and - for spatial features - there is geometry. But there are other pieces of data that aren't stored in such a way; for example the name of the source dataset, the color of an object, or the size of a piece of text. These are stored as format attributes, and they can be accessed and used in your workspace. Exposing Format AttributesNormally you expose format attributes in t

Hello there I am reading for DB point geometry formated as WKB , how can create a vertex from this wkb filedex: (wkb_geometry: 0101000020E6100000F4FFFF87CF5447401BC047148BD43840 ) why the same point read from csv ( lat,lg) file converted to wkb format using geometry extractor transformer has not the same length as the previous wkb stored in database ( 0101000000d81f259db86224417980c06195f54441) wkb extracted (geometry extractor ) thanks

Total novice question when it comes to the Sentinel dataset - I am using the Sentinel 2 open access dataset, trying to play around with getting vegetation index calculations, I am wondering what the easiest way to clip the raster output to remove cloud cover. Which band should I use to identify cloud cover and is there a vector polygon that is already available in open access with this data?  Thank you very much for your help and have a good weekend.Oliver

CSV to CSV, show only unique values?  I know it can be done in excel using Array Formulas. But I need to it on many CSVs, (analyzing IIS Web logs, want only unique hits). There must be a transformer for this.

I have created city buildings from building footprints and have added attributes to them from AttributeManager. Now I know that 3D tiles cannot be set as readers so is there a workflow to update those attributes without redoing the process of creating them again?

I've 2 solids and I want to use a clipper to split them. But I can't get the clipper working (tried all the options) :-S.So it would be great if somebody could help me :-).I've attached the files and workbench. Thanks!

I have filtered air temp into average daily max and min. And I would like to display them in two columns filtered by date and station. In the final table, only the max temp is showing in both columns. How do I show min temp as well?

I an trying to add a geoid height grid constructed with the workspace from this article Creating Vertical Adjustment Grid files for use with FME (safe.com)I get the file EGG97_QGR.GRD (I changed the extension to .txt to upload) witch I place in "D:\Reproject\GeoidHeightGrids\Romania\"I created a corresponding EGG97_QGR.gdc file in "D:\Reproject\GridData\Romania\" with the content:# https://cngcft.ro/index.php/ro/download/download/2-software/2-cod-sursa-transdatro..\..\GeoidHeightGrids\Romania\EGG97_QGR.GRDI have done this previously with no problems. Only difference is that in the new version the grid doesn't have any NODATA pixels. And maybe FME 2021.0...I Get the following error:Corrupted CS_MAP data file encountered.CS-MAP Reprojector: Unable to load geoid height grid '%0'And:CsmapReprojector (TeeFactory): CsmapReprojector: Reproject: Could not reproject the geometry of the preceding feature: CS-MAP Reprojector: Unable to load geoid height grid 'D:\Reproject\GridData\Romania\EGG97_Q

I'm working with relatively large LAS files and only needing small portions at a time. Is it possible to use a Shapefile to "trim" the excess points before transformation?

Welcome to an extra lucky edition of What’s Up Wednesday.  FME 2021We’re still super excited about the 2021 release of FME! I’ve been playing around with some of the new features, especially the Parameter Manager; be sure to check it out. Also, check out the blog and the unveiling webinar if you haven’t seen it yet.  BlogAlso new to FME Server 2021 is the idea of streaming data. Check out the latest blog to learn everything you need to know about stream processing. You can also sign up for the Intro to Stream Processing Webinar on March 30th.  While you’re there, if you are interested in OGC and Open Standards, see the blog to learn why these standards are so important.  WebinarsYou’re in luck, there are still two more days to apply to be a contestant on “Who Wants to be a Data Extraordinaire” airing on March 23rd.  FME World FairRegistration for the FME World Fair is now open! With the help of our Partners and all of the great speakers who have applied to present, we will be hosting t

Hi, I asked about parquet format yesterday and I had great feedback about my problem (https://community.safe.com/s/feed/0D54Q00008VE8CZSA1) Right now I have a bigger problem - but I think, I have too small knowledge on this topic. I have to connect to azure blob storage (datalake) based on SAS auth, I have permission into SAS key like:ss=bfqtsrt=scosp=rl So, I can create a list and I can read files, also I have SignedResourceTypes like Container, Service, and Object. With parameters like that I see db, I see parquet files, also I can download files via Chrome (link+SAS)But if I want to get attributes (and only it, without download files, because data are too big) - I used this kind of parameters: and I have empty results: My question: Is it possible to get only attribute per parquet file which is existing in azure?Or downloading data is required? What I have:SAS key, which I can "modify", but as I mentioned - I think, I have required permissionsname containeraccount name to S

Hi all.Is there an updated guide for how to change the service accounts running FME Server ? I can only find one for version 2016, and it doesn't apply to version 2020, pointing to some missing installation files.Cheers

Hi all,  I have a workbench which takes a CSV, creates vertex's and then publishes to ArcGIS Portal. This works fine and I can view the data in Portal, but it fails if I try to run the workbench again to overwrite the feature... which is something I need to do every morning.  I get this error: ArcGIS Portal Feature Service Writer: 'addResults' error for a feature in 'COVID_Joined_Tables'. The error code from the server was '10500' and the message was: 'Cannot convert a value of type 'java.lang.Double' to 'SMALLINT'.' I have the Portal writer set to INSERT and to Truncate first YES, which I think is the right setting to be using? I guess it is something to do with Portal converting a field type when it get's created, and it finds a mismatch when trying to overwrite it.  I have checked the attributes of the fields and only one field is down as SmallInteger, so I tried changing that thinking that may have been the field causing the p

Hello everyone! I have a problem with HTTPCaller. I have a request with Russian language in it, and everything in the browser works well, you can see https://geocode-maps.yandex.ru/1.x/?apikey=dee638ec-7943-42fb-85c7-a47699c42211&format=json&geocode=Москва+,+г.Зеленоград,+улица+Заводская,+дом+25,+строения+1,+2,+3,+4,+5,+8 But after HTTPCaller, I have this response: {"response":{"GeoObjectCollection":{"metaDataProperty":{"GeocoderResponseMetaData":{"request":"МоÑ�ква , г.Зеленоград, улица ЗаводÑ�каÑ�, дом 25, Ñ�троениÑ� 1, 2, 3, 4, 5, 8","results":"10","found":"0"}},"featureMember":[]}}}     So what's problem is? I've already tried all response body encoding, but nothing has changed.

Hi,I have more than 50 databases connection configured with my FME Desktop 2019 version. I would like to upgrade to FME Desktop 2020. My question is if I migrate to the new version ( FME 2020) will I lose my connections to these databases or will it keep them?Regards!

I am trying to setup a parameter as Choice with Alias which contains thousands of possible choices. The issue I'm seeing is after running, the choices are no longer selected. Say I choose 10 items, Run the workbench, and for whatever reason, need to run it again in the same session. All parameter inputs are saved, except for the Choice with Alias.