FME Form

Hi I am using FME Form 2021I am passing a ArcGIS portal login (including domain) as a user parametere.g. username@sss.co.uk When I try to get the value in pythonCallerportalAdmin = str(FME_MacroValues['ArcGIS_Portal_UserName']).strip() It is coming asusername<at>sss.co.ukI am unable to use this to login to my portal in pythonCaller. Any idea how to escape the @ sign ?

Five months ago, I created a small FME application that would login to a state controlled secured FTP server and download a file to a local drive.  Putty was used and files were generated for local use and for the state. That application was working fine, however, the agency that made the request was not able to approve the process in the interim.Now, five months later, when I run the application in FME, the login is rejected.If I use the exact same parameters to manually download the file with WINSCP I am able to login and download the file without a problem. Nothing has changed in the setup of the FME.In the attached image, I show the three transformers and their parameters that I used to download the file.  Five months ago it worked.  Now it does not.  Manually, it works.  Via FME it does not.I am not sure if this is problem in the FME, an issue with my local network security or an issue at the State ftp site.The error message is as vague as described in the documentation. 

Hello FME community, I have an issue I'm working on and can't seem to figure out the solution. I have two Excel tables. One with different kinds of certifications and the score each is given.Certification Score Certification_A 1 Certification_B 5 Certification_C 7 The second one contains Applicants with fields defining the various certifications and links to said certification. One applicant can have multiple certifications. We need to determine for each applicant which is the highest scoring certification.Applicant_ID Certification_A Cerification_B Certification_C 1   URL to file   2 URL to file     3   URL to file URL to file  In the second table I want to add the scores and then determine the highest score for each row (this i can do in a new field with the max(Value1, Value2 etc) function) and write out the applicant_id, the highest scoring certification name, it's URL and the score.Can anyone give me some pointers how i can solve this case?T

I’m trying to repeat the same process on each group of features that represent each door (every door consists of many features having the same value of door_id) . on the other hand , the process that i want to create is detecting that line on green for each door and drawing it using the LineBuilder  .So for exemple ,if in my input i have : 200 features , every 30 or 40 features share the same door_id value (so there are say 6 doors in total )my output : 6 features (each feature is that green line , with the attribute door_id) 

Hi FME-community,I want to use the HTTPCaller to upload two JSON-files in one multipart PUT request. Just using two HTTPCallers separately works fine with Headers defining content-type application/json and Upload Data to Specify Upload Body with the JSON-content in the Upload Body. However, in future it will be convenient to also add different file-types in one PUT. Therefore I have the following Multipart PUT request:As you can see in the example I leave the Content Type blank, because there's no option "multipart/mixed", but consequently it interprets the upload body as plain text resulting in a binary file uploaded. Without success I also tried to set Upload data to multipart/form data with two separate String Uploads which results in the following error: "This FME edition does not recognize the `' function. Please ensure that the current platform supports this function, the function name is spelled correctly, and that you have installed all required plug-ins&

Hi All, Is there any writer for AutoCAD Civils 3D (.dwg)?There’s definitely an AutoCAD Civils 3D and Autodesk AutoCAD Map 3D Object Data Readers but can’t find the same writers?

Hi All, I’m trying to read an Autodesk Civil 3D file in FME(R) 2023.1.2.0 (20231110 - Build 23641 - WIN64) but gives me the following error, see below:AutoCAD Reader: An error occurred for dataset 'filename.dwg', in function C3DReader::processAeccAlignmentEntity. Exception thrown: 'Invalid input' (Invalid input) I have left the default setting to read Autocad Civil Files, see below: 

I have a process that uses a change detector transformer to compare address data from one database and update the data in a second database based on differences in the dataset. It works great normally but the other night it updated, but I had an extra 85000 records that ended up being duplicates of existing records. Both these databases are SQL server ESRI Geodatabases and are using the same SQL server instance. What I think happened is that the database instance was failed over while the FME process was in the middle of running, which disconnected the session temporarily and when reconnected started reading records again which looks like it started reading the records from the start but still included the records that were already read in addition. Is there something I can do or set when a database is failed over in the middle of running a process to prevent this issue?

Hi, we have tiff files with rgb values. Is there an easy way to transform this tiff file in hsv color space?Something like inside the transformer “rasterexpressionevaluator”? thanks in advance 

I recently upgraded to FME Server 2022. As I'm creating new workbenches for publishing or modify existing workbenches, I'm transitioning to Desktop 2022 as well.I have a process with three (3) identically configured Feature Writers (ESRI SDE/SQL Server) that first truncate three (3) tables and then insert into those tables. I have updated and republished this in 2022. When I try to run it in my new environment, it stalls at TRUNCATING one of the tables... literally sits there for almost 2 hours, then resumes. I should add that this is not a super large table - 150K records maybe. My understanding of TRUNCATE does not suggest this size would have an impact, nor have I seen this before.  Nothing has changed about the database/table. Nor the Writer configurations or workbench "logic". What could be causing this hang-up? Has my Writer gone south?   

Hi everyone,An inquiry concerning the FME Forms(Formerly FME Desktop) supported SMB (Server Message Block) version was sent to me by an infrastructure technician. Since the word was unfamiliar to me at the time in FME, I started looking it up in our community as well, but I was unable to discover any information.At last, I retrieved the SMB2-enabled version from the FME Forms installation server and distributed it to them. Are there specific details available regarding the FME desktop supporting version?I'd like to share this here in order to gain some clarification on this, and others who are in a similar circumstance might find it beneficial.🙏🏼Explore, Learn and Share it with all.. 

I have an Excel 365 .xlsx spreadsheet that I am trying to read into a FME 2021 workspace. When I try to read it, it gives me an error message: |ERROR |Excel Reader: Could not open file '...\input.xlsx', file is too large. Try switching to 64-bit FME, or exporting the Excel file to CSV. If the file is exported to CSV, formulas and formatting will be lost...T I cannot change the spreadsheet to a .xls, it has to remain a .xlsx. Any ideas on how to solve this?  The spreadsheet I need to read is 22mb with approximately 93,000 records.  

Adding an ArcSDE Geodb reader, FME Workbench 2019.1 throws: "GEODATABASE_SDE reader: An unknown exception occurred" followed by "Workspace generation failed. Parameter file was C:\\Users\\marsale\\AppData\\Local\\Temp\\FME_1700594969892_10740." It worked a couple months ago and my oracle account is fine (i can see and select the tables in Oracle, the error occurs when its trying to create the workspace).

I have a collection of as built drawings stored as PDF’s and wanted to automate the creation of image files being used as thumbnails in a web application. I was wondering if anyone has done this before. I am currently using the Workbench 2018 PDF reader and attempting to rasterize using either ImageRasterizer or MapnikRasterizer.

I hope this post makes sense. I used a list an attribute splitter -> list exploder -> attribute creator to assign a value based on conditional criteria. I now need to filter the data using the following logic: Take the minimum “_element_index” WHERE “Review Status” (newly created attribute) has a value, else use the MIN(element_index).There would be a Group By: “Project Number”Any help would be greatly appreciated   

Is there anyway to read in attachments while using the FeatureReader transformer. I know there is an option with the ArcGIS Online Reader but I don't know my Where Clause until after certain point in my workflow. Feature Reader was working perfect until I realized I couldn't read in attachments. Any help would be great!

Hi, My workspace has an AGOL reader (reads attachments too). Features are compared to existing SDE records and new features are then processed into the SDE (photos go to our DMS). Unfortunately, all AGOL records and attachments have to be read before comparison - even with our fast internet, it still takes 5 seconds per feature (6 photo attachments). Our test dataset has 1500 records (9k photos) and the production dataset has 100k records.My idea was to read the AGOL dataset WITHOUT attachments and then use an AGOL FeatureReader to just read the new features WITH attachments, but... FeatureReader is (or at least was) unable to work with attachments.The rest of the workspace is fairly involved, so I don't believe this is a case for a WS Runner. Ideas will be much appreciated.Cheers,Mark

 Hi, I have a table with many points, with an ID and two attributs, like this :I need to “dissolve” the points and get just one point by ID and in attributes get “Yes” if at least one of the original points had “Yes” as value, like this: Is that possible with some transformer? Thanks

I wanted to run a single sql query but with multiple variable value depending on my user input (to a parameter).For Example :When I type in VEGETABLE in my user parameter I want to run “SELECT * FROM <vegetable_name>”, where I have a bunch of different values for my <vegetable_name> variable, additionally I want to join all the data procured from running the query for all vegetable_names.

I use the “Esri ArcGIS Layer” reader to read an .lpkx file that contains 2 different feature layers, with different geometry (lines and points) but the reader fails to read both layers. It reads only one of the layers. Anybody with the same issue?FME Desktop ESRI Edition 2022.2.2.0ArcGIS Pro 3.2.0 64bitThanks! 

I am reading two AutoCAD files and sending them through a ChangeDetector to identify the differences between files.  For my updated features, I am trying to write out the attributes to my blocks to displayy the following attributes as extended entity data:Id, Update_1,Update_2, Update_3 (all the way through Update_10)Writer Feature Type Showing all the attributes.​​​​However, when I open the drawing, the Extended Entity Data is being written as such:Block Extended Entity Data is repeated, missed, and “garbled”.Can someone give me some advice as to why this may be happening?

Hi, Is there a way to change the color of the font for the part of the text that matches regex? In the scenario below I would like to put in red only the double spaces in Excell At the moment is highlighting the whole text in excel 

Hi, I would like to create a FME app that will allow users to check the gdb for wrong attributes. Each time the attributes in the gdb will change hence I need to find out how to do it automatically/dynamically.   

 Hello,I have installed a fresh install of FME Form 2023.2.2 on a Ubuntu VM with Azure. When running workspaces on FME Form 2023.2.2 with workbench, everything runs smooth. I have imported a manual license to the licensing assistant.However, I am trying to also install some python packages on this Linux VM. So we can transfer this to our Kubernetes Environment which also runs on Linux. We cannot install these packages on a Windows Machine cause they won't work on the Linux.Script: sudo /opt/fme-form-2023/fme fme -m pip install pandas --system --target /home/adminnordend/.fme/Plugins/Python/python310 After running this command we get the following Error: FME license system failure: FME is not licensed for this machine. Please launch FME Licensing Assistant to install a license. If you require more assistance, please send the following information to your local Safe Software Partner or codes@safe.com. Your registration key is 3-246-191-769. Program TerminatingBut the system is licensed. 

I’m dealing with a rather large JSON file. The issue I have is that some element values contain literal quotes and double quotes, and these are causing Rejections in the JSONExtractor. The quotes/double quotes are not escaped in the original source. Is there a way to escape these automatically with other FME JSON transformers?My efforts to fix thus far using the StringReplacers have resulted in errors throughout the entire JSON string, since quotes/double quotes are native to JSON formatting.