General

I am trying to connect to a salesforce account with the Salesforce reader. I keep getting an HTTP/FTP error "Could not connect to the server". I assume this is a proxy error where the reader is being blocked by my organization's firewall. To fix it, I would need to submit a Port Open Request to allow the traffic inside my organization. But I have no idea which port or URLs FME is trying to hit with the Salesforce reader. Is there a tool inside of fme that would allow me to see where FME is getting hung up? Or something outside of FME to look at that information?

I am facing one issue is StringConcatenatorGroupBy this function not exist in FME 2016. Any other alternative for this ?

I have a workspace that copies a file from one location to another. Now I want to use the copied file as input to a reader. How do I do that? 

Hi, I would like to remove slivers but not overlaps, is this possible? The AreaGapOverlapCleaner does both and it doesn't seem to allow the separation of these. Thanks for any help.B

Welcome to your weekly dose of FME.  User GroupsHave you noticed a change on the community lately? We’re tidying things up and adding more value to the community. Check out the new User Groups section, where we invite you to join in some casual conversation, as well as regional specific conversations. We’ve also moved our Fun and Games content into this area.   Curated ContentTo help you find more resources in what you are interested in, we have started creating curated content. As a part of a larger project, we have created two new resources for you. Working with CAD Data and FME, which is a collection of all the resou

Hello,I need to refresh six materialized views (Oracle) in sequence. Each refresh must start only after completion of the previous one. Is a chain of SqlExecutor the correct approach or FME will try launching other sqlexecutors without waiting Oracle response? I've noticed that more than one seems to be active at same time. Suggestions? TIARoberto

Hi, I make many requests to a webservice using HTTPCaller, the trouble is that the credentials expire after 5 minutes.  I use one HTTPCaller to obtain a new API token and then I use another HTTPCaller to get the required data back. In that time the token is valid I can run at least 100 calls to the service. What transformers can I use to ensure that after every 100 calls I call the HTTPCaller to get a new API Token and then use that token in the other HTTPCaller to get the data. I was thinking loops and test filters but I can't get the logic this morning. Any help would be very appreciated.  Thanks

Hi all, I'm trying to output some 3D data to FileGeodatabase in order to view in ArcPro. I don't want to use the ESRI writer because we are using FME Cloud and the ESRI writer doesn't work on Linux. I also don't want to use I3S. It must be FileGeodatabase. Anyway the issue I have is that the output MultiArea features get messed up when looking in ArcPro.  Shape Multipatch looks fine but isn't possible with the API version of the FileGeodatabase writer. When running though a GeometryValidator in FME I get a lot of Self-Intersection in 2D - but that is expected given these are 3D features.Perhaps I'm missing something. Does is make sense to create MultiAreas here?

Hi,I am having a mental block on this one (it may just be this time of night!).I am trying to write a single polygon as it's own feature class within a geodatabase using the Geodatabase Open API writer. The Feature Class is being created, but no objects are being drawn within the feature class.I have attached the log file.Cheers.

Hey folks, As per the question itself, I'm really struggling with (what I assumed) would be a straightforward task. (Straightforward in that I cannabalised an older workbench which works just fine and simply switched up the HTTPCaller url and featurereader parameters and thought it would work.) The way (I assume) it works is that the HTTPCaller calls the zip file from an online repository, then the featurereader reads the contained shapefile and I can then go on to do other processing tasks. However, the workbench is failing at the featurereader stage. The logfile has an error message that says:Unable to open shape file `C:\\Users\\[USER]\\AppData\\Local\\Temp\\FME_TempFileStore_161769518366_3180\\dsR_1_161769518367_3180\\DBCALegislatedLandandWaters.zip_161769518367_3180\\DBCALegislatedLandandWaters.shp' for read. I have no idea what the issue is, I've purged temporary files, screwed around with the parameters of the featu

How to upload SSL certificates on my FME server to allow the connection to Kafka with HTTPS?

Hi, I am trying to update the name of my attributes but am having a hard time. Currently I have two attributes (BEC: Revenue and BAC: Expenditure) and I have to update them to BEC and Expenditure respectively. I think I can use attribute manager but I am unable to make the required changes. Any help will be highly appreciated

I'm reading the data from smallworld environment. We are able to add reader and read the data to some extent but after few hours (6-8 hours) of execution, workbench is getting failed with the error as shown in attached screenshot. It is an issues towards GESW side or FME side, Kindly help...

I received some data where x and y coordinates are concatenated in a single cell. Extracting and connecting these together will give me either a line or a polygon. I have provided a sample csv file belowThe issue with the data I have been provided is that it has displaced field 10 onwards - but I can't tell that field 10 has been displaced unless I remove the all the concatenated geometry fields There are 2 things that I need help with1) extracting the x & y's so I can create geometry2) understanding where Field 10 may have been displaced to so I can create a table that makes sense!Any help appreciated!  

This is my first time working with FME workbench. I would like to convert an E57 to LAS to import into ArcGIS Pro for a class project. I looked around in the Transformer Gallery but could not find the correct tool. Thanks so much for your help!

I have a bunch of points features in input and I would like to sort them by distance between each other so the next row in the excel sheet in output would be the point the closest to the previous row. How can I achieve that with FME?

In other words, there needs to be one FLOOR_ID with it's respective POINT and LINESTRING per row. Please see the screenshot below. Thanks

Hello, We are trying to run a batch file/windows powershell to change the floating license for using a different server name for FME Desktop 2019 edition. The reason is the users do not have any administrative permission on the local C drive - thus they cannot change manually. We would like to do this with a script and also where/how is this licensing information stored on the computer? Thanks !

Is it possible to write data into FME server temporary files folder? What could be the writer parameters or settings to try? Currently I have been testing to write into an existing file (.txt) in temporary files folder on FME server and it will not write any data, whereas when just using FME desktop and writing the file locally to my computer works just fine. My actual dream is that the user can upload data and the server runs it through and displays the result back in PHP.

Hi , I want my FME process to take '0' as 'null' for one of the attribute. Im totally new to FME , not really sure how can i proceed ? could anyone help?

Hello all !  I've a probleme with reading a DGN (V8) containing cell, I want to read the igds_level_name that contain the level name of the entity, i've succeeded into that but the value return by FME is not the right. In fact my cell are all in level named "RESEAU" but when I take a look on it on FME, it says that they are in DEFAULT level ... I think that FME read the level of the entity when it was design (in cel file) and not read the level of the current drawing ...  That is very very problematic for me, i need to have the right level information. Do you have any idea of what is the problem or how to resolved it ?  I attached a little sample if you want to observe  Regards,

Welcome to a lovely spring edition of What’s Up Wednesday FME World FairThe FME World Fair schedule is now live! See what presentations you’d like to attend. Be sure to register to get the full agenda once it’s released directly into your inbox (it’s free!).  ArticlesGetting Started with FME Server and Docker: Learn how to get started using Docker to deploy FME Server and learn why this solution might work for you. 

Hi I want to make a DSM from a pointcloud. I have used the rasterDEMgenerator and the imagerasterize. They both work and I get a good result, but only visual. When I load the DSM in Qgis and start to sample it, I get the color codes or something instead of the height.  I can't seem to find a way to change that.  This is how I I would like it: This is the result I get with: This is how I would like it: this is my result: 

Hello, i'm using a featurereader to catch all items created in another workspace (through a workspacerunner) however i keep getting an error: 2021-04-06 16:39:32| 4.0| 0.0|ERROR |Shapefile reader: Failed to open file 'C:\\TEMP\\pt000019.shp' for reading. Please ensure that the file exists and you have sufficient privileges to read it2021-04-06 16:39:32| 4.0| 0.0|ERROR |A fatal error has occurred. Check the logfile above for detailsI did try using a decelerator and/or featureholder, it doesn't do anything good. Though the files are there when the featurereader kicks in.However if i run the same benchmark a second time, everything works without error. Any advise?

I can’t use the pointcloudcoercer and then group on ”count” since it still need to be in pointcloud- format when writing to Xyz-fileformat. Do I really need to first write to xyz and then bring it back in to split it up? Thanks