FME Form

I can read tables from salesforce without an issue so it's probably not a credentials problem. But I am trying to write a record from excel to a table in salesforce and I am getting a 400 error. The error messages are pretty vague, only that it fails to write and that the Create Job Must be a POST. Any idea what would cause this issue? Do I have too few fields in the table that would otherwise be required?  Received HTTP response header: 'HTTP/1.1 400 Bad Request' from [salesforce instance here]Salesforce: HTTP 400SALESFORCE writer: A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...Translation FAILED with 5 error(s) and 1 warning(s) (1 feature(s) output)  <error xmlns="http://www.force.com/2009/06/asyncapi/dataload"

Building a data prep workspace. Have only got 2018 desktop, not Server. I have created a (long) list of feature class filepaths from network-located ESRI FGDB's. These feature classes mostly have differing attribute structures, and there are hundreds of possibles (although only a few dozen being updated at any one time).  Is it possible to use Filecopy writer to a) copy the entire feature class based on a filepath pushed into the writer, b) write it into a new FGDB in a Feature Dataset (name specified by a feature attribute) and c) (preferably) zip it up?  New structure would be : FGDB1.gdb feature_dataset1 feature_class3 + feature_class5 + ... (Eventually, this will go up to Azure blob storage, but there are some permissions obstacles at the moment, I think.)  If it is possible, any suggestions on how to configure the writer would be gratefully received.

In QGIS there is a tool to create channel networks across a LiDAR surface. Is there a similar tool or process in FME?

Hi,i tried to merge multiple lines into only one line, but the difficult is, that also connected lines on a course between start- and end-Point should be merged into the "one line"with linejoiner the lines were only merged until the next Connection.has anyone an idea?

Hello, I need to use a variable in INLINE QUERIERThis is valid SQL but I can't get it to run in FME. The print is just for testing. I would ultimately use the variable as a concatenation string. DECLARE @ccount as varchar(20) set @ccount = (select top 1(CYCLE) from CYCLE) print @ccount 

Hello!I connect our Esri Enterprise to my fme workbench and server with the help of the guide here.  But a very strange thing happens: after I close the file, for example at the end of a working day, the connection to the enterprise resets, and the same connection that worked yesterday, no longer works today.So the first time I did the whole process again, and the second time, it doesn't connect at all anymore.Anyone familiar with this problem?

Hello,I have a 2D set of points within which I want that no pair of points stay within a distance inferior to a threshold of my choice. The supplementary points have just to be deleted. How can I perform that? Thank you in advance.

Hello,I would like to create the Geojson output as shown below:{  "type": "FeatureCollection",  "name": "Example_Dataset",  "crs": {    "type": "name",    "properties": {      "name": "EPSG:28992"    }  },  "bbox": null,  "features": [    {      "type": "Feature",      "properties": {        "Name": "AO1",        "Begin K": "0",        "End K": "2.196"      },      "geometry": {        "type": "LineString",        "coordinates": [          [            143267.805,            559438.354,            1.944,            0          ],          [            143268.356,            559439.188,            1.987,            0.001          ],          [            143268.907,            559440.023,            2.029,            0.002          ],

I'm trying to use FME purley through Python and have successfully executed the "WorkspaceRunner.py" sample code, calling it via FME:fme.exe python fmeobjects/samples/Python/WorkspaceRunner/WorkspaceRunner.pyI have since tried to create my own program but which throws an exception that I would appreciate to get some guidance on. Here my code: import osimport sys os.add_dll_directory(r"C:\Program Files\FME")sys.path.append(r"C:\Program Files\FME\fmeobjects\python39") import fmeobjects runner = fmeobjects.FMEWorkspaceRunner()workspace = "testWorkSpace.fmw"runner.promptRun(workspace)Error message:fmeobjects.FMEException: FMEException: 1: Failure running workspace 'testWorkSpace.fmw'Importing the FME modules seems to work and I'm using the same interpreter as with the WorkspaceRunner.py sample. "testWorkSpace.fmw" is an emp

I am trying to access a SOAP service that is password protected. In Soapui I had to set the WSS-Type to PasswordText in order to get the result I wanted. How can I duplicate this in FME desktop?

Hi,I posted this earlier on the Package page, but I'll paste it here to be sure to get an answer.  So, I get this error while trying to authenticate with my Google account: Authorization Error Error 401: disabled_client Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In. Learn more Request Details The content in this section has been provided by the app developer. This content has not been reviewed or verified by Google. If you’re the app developer, make sure that these request details comply with Google policies. access_type: offline approval_prompt: force response_type: code redirect_uri: urn:ietf:wg:oauth:2.0:oob client_id: ERASED.apps.googleusercontent.com scope: 

Hello everyone.I have a problem with writing an SDE database that sits on top of postgis DB.I manage to connect in the FME to the database both from the postgis / postgres readers and from the sde reader.I can read the data, the problem is that I can not write properly.I want to update the database, and no matter what I do, I do not see the changes in th database.It is divided into two parts:When I write directly to postgis, I have a lot of warnings, but I was told that Total Features Written 1As it should be.But in practice I do not see the changes in the database at all!And when I write down to sde, it gives me lots of Errors, but Total Features Written                            1 as it should be,but still no change in the DB.I tried every possible variation in feature operation, insert, update- and nothing changed.Only when I did an experiment with delete, it managed to delete the features for so

I have a road center line and private properties beside(left and right) to road center line.I want to find out the distance between the road centerline and private properties (perpendicular to the road centerline)both the sides(left and right) for every kilometer. Generate points along the road centerline for each kilometerCalculate perpendicular distance from a point to private property polygons(left and right)Add attribute left1=min distance (left property polygon and right1=min distance to private property right side

Hi everybody, I have 6 values which are standing for colour values for making maps. So each number is standing for a colour. The values are always the same and the numbers are 59, 63, 70, 72, 76 and 77. I have a lot of polygone ESRI shapefiles which are showing the administration of each country (OSM Data for example the states of India, which is the first administration level of India). To have the same style in each map for printing, I would like to use the colour values (59, 63, etc.) for every administration of each country. So each shapefile has a attribute field which is called "colour value". Now the tricky part is: the polyg

Hi, I have lots of large raster datasets that I want to resample and save as PNG. The problem is that their rotation is wrong, and trying to modify the angle according to the image properties gives incorrect result. The images are oblique images.The raster in geotiff format read into FME:Doing no rotation gives this result in the final png: The image after rotating it.  RasterPropertyExtractor gives _rotation_x=222.30258951435636 and _rotation_y=223.52422211966618. None of these values give the desired result with a straight image. 

I have a question; how can we turn a IfcGlobalUniqueId to a normal GUID with FME?And is it possible to turn it back in a IfcGlobalUniqueId with FME, because of the buildup of a IfcGlobalUniqueId. I am hoping someone can help me by either passing a bit of Python-code or maybe Safe can create a Custum Transformer to help with this problem? We want to use a IFC for our asset applications and our 3d city-model.So, we can use the IFC from our engineering-team to fill the other applications with attributes. And when we need to develop new streets, we can give them the information back. Beste Regards,Bert @Takashi Iijima​ @daveatsafe​ 

I have an ArcMap MXD file with data driven pages to create a map book. I want to use the map document as my reader. What transformer can I use to export the map book in PDF in FME?

Hello , i would like to combine different values from different attributes then add them in one cell and write string text +value of specific attribute 1 then add new line and write string text + value of other specific attribute .How could I achieve it ?thanks in advance FME 2021

Hi! I'm desperately trying to find a way to identify the impact of disabling a specific network on the surrounding networks. So far by using the NetworkTopologyCalculator, I've been able to isolate all my water networks, separated by water valves. But here is an example of what I'm trying to do:If I have to replace the water pipe on the network A, I will close the water valves to isolate it. The impact would logically be that there would be no water reaching networks B-C-D-E. Is there any way for me to dynamically identify this in FME?Thanks in advance for your help!

We have some automatic data-updates on an ESRI File Geodatabase. I also want to update some parts of the metadata also automatically as part of the update procedure. I want to change Edition, Publication date, Revision date and dataset ID. I succeeded getting the right information to insert in the XML updater, but the XML updater doesn't seem to do anything in the metadata. I don't see any result. Could anybody help me out? I added the workspace to this question.  Addition 9/12/2022:I just discovered that, if I fill out these fields manually in ArcGIS Pro, that this information is not found in the metadata that is read by FME. This is what's filled out and seen in ArcGIS Pro:I used the mehod with the XML Formatter

I am fairly new to Fme server and I have mostly only experience with FME desktop. I was running succesfully a script with Fme desktop. However when I published the script to fme server and I run the script, then I get the following error: I have slightly changed the names of the path due to security issues. DESIGN WRITER: Failed to copy the seed file '\\\\NotRealdomainName\\aplroot$\\A-APLDATA\\FMESERVER\\repositories\\Notrealrepositoryname\\Seed.dgn' to the destination data file 'C:\\Klic_Tijdelijk\\_Bomenanalyse.dgn'. Either the path to destination does not exist or the file is in use by other program I think the issue lies that I wouldn't be have to use hard pathnames in FME Server. Does anyone know how I should define the path names in FMe server? 

Using PointOnAreaOverlayer, I would like to know how to extract polygon IDs and assign them to corresponding points that are within each polygon.

I have comprehensive worskpace to write many tables in PostGIS, where all the target attributes are in lower case. Now I need to migrate this workspace to work also on MS SQL. I was able to change the writer and bulk update feature types table qualifier. The schemas are just similar to Postgres DB, but I'm getting errors because of the lower case of the attributes while writing to MS SQL.Importing new feature types from schemas is not a way because I need to maintain the attribute mappings on every feature type. For example, the table name in lower case is not an issue but column names are. I would need that the writer forces UPPER CASE on writing to DB or bulk change all the attribute names in all writer feature type to UPPER CASE. I´m not feeling to do all the mappings again from the scratch, if the schemas are the same.On the attached picture you can see the attributes from changed writer feature type (PostgreSQL->MSSQL, left) and new imported feature type (r

Sorry if the question does not express what I want to achieve, but of the top of my head I did not know how to ask differently.The issue I have is, that features provided by the very left reader are used to identify raster files they intersect with, which afterwards are mosaicked and processed. There are a lot of raster files and a lot of features coming from the reader, and I would like to run this entire process rather feature by feature, instead of feeding all the features into the process.What is the best way to achieve that? 

Happy New Year all. Can anyone please how can I change a date column (dd/mm/yyyy) from string to date time format within a workbench. The column is originally coming from a CSV file but after reading in FME, its getting converted into string. I want to apply test filter to get values within a certain date period but because the date is in string, I cannot do it. Do you have any idea how to resolve the issue? Thanks in advance.