Best Answers

The WSG transformer gets following error when I try to upload files to Projectwise: ProjectWiseWSGConnector: Uploading file "testfile.shp" to Bentley ProjectWisePython Exception <AttributeError>: 'NoneType' object has no attribute 'encode'Traceback (most recent call last):  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 227, in input  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 1129, in _handleException  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 200, in input  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 467, in _doUpload  File "webserviceconnectorfactory\webserviceconnectorfactory.py", line 511, in _uploadFile  File "bentleyprojectwiseconnector\bentleyProjectWiseConnector.py", line 320, in uploadData  File "bentleyprojectwiseconnector\bentleyProjectWiseConnector.py", line 282, in _uploadNewData  File "bentleyprojectwiseconnector\bentleyProjectWiseConnector.py", line 233, in _upl

Hi I am not sure what to do at this stage and was wondering if anyone had any insight. I tried to enrol to do an online course and created an account using my work email. I have not received any emails to verify the account and I have tried to have a verification and password reset email sent with no luck either. I have sent an email to info@FME with no response as well. I tried to recover my old password from a FME account using my home email address as well with no response. Email addresses are correct, and I have check SPAM folders. Any suggestions on who to contact at this stage? Regards Mark

My workbench creates a number of excel spreadsheets. Sometimes it fails due to users having one of the spreadsheets open when the workbench runs during the night. Though that spreadsheet cannot be updated due to the lock, it would be very useful to still be able to update the other spreadsheets rather than the entire workbench stopping completely.Can a writer error be bypassed or ignored?

FME Configuration: FME_PRODUCT_NAME is 'FME(R) 2023.2.1.0' HelloFeatureHolder is suppose to wait for all feature to arrive then process then further but as shown below it’s not working.I’m basically re-adjusting the first part of my FME App.Get Path location / file extension Hold Features Check if file is correct then proceed further File is correct then check is .SHP file extension existsWhen I run my workspace, it stops here:  Not sure what’s going on or if I misunderstood the process.Thanks

Hi,I’ve got a strange issue.I am using a FeatureMerger to match values from a lookup table.Then I use a DuplicateFilter to check that all the terms from the lookup table are used. And strangely, with certain non ASCII caracters, there are duplicates coming out the Unique port ! Another strange thing is that these duplicates in Unique port dont appear when I check for duplicates immediately on the lookup table.So what happens in the FeatureMerger that makes the DuplicateFilter dysfunction ? Here’s what the Excel lookup table looks like. When I replace the non ASCII caracter, the problem doesn’t appear.What to do ? 

Hi All,Is there any way to read multiple GDBs saved on the company Sharepoint? Does the Sharepoint need to be publicly accessible? I get an error when try to use the URL link and load the GDB,  Also I would like to know a workaround to read individual GDBs, Any Ideas? The GDBs are saved in individual folders so need to iterate thought these, example of the folder structure below: Example of the individual content folder below:  

Hi Guys..I need your Guidance to accomplish above scenario..I was able read a GDB and Excel as source from Feature Reader and also able to do required Results Now , At attribute Manager , I want to add around 52 new field names along with field alias from importing it throughexcel and this would be new field and then i want to write a GDB , so All field along with other New fields which has alias name to be written to GDB.. How can i do this ? Anyone , Kindly Guide..Thanks

Hi All, I had a case with FME flow where I could create automations and run them, but received an error when trying to turn them off : We fixed the issue by updating the JDBC drivers and everything worked fine.I then moved to a different environment (production) and assume that this fix had been applied but it hadn’t. I created an automation and then could not turn it off, so I deleted it.When I look at the automations page I can see that there are no automations, but the one I setup and deleted is still running jobs on its scheduled interval (every 10 minutes). I had to delete the workspaces from FME flow to avoid these from running. Does anyone know if I can go into the FME SQL Database and delete the automation from one of the tables? I don't know if there is any dependencies on Primary/Foreign keys and don’t want to corrupt any tables. If this is possible could you please advise the table as I don’t have access to view these and our IT team will want to know exactly what to delete

I am trying to insert a new item/child into an existing XML element. I want to add: <keyword>USA</keyword> to either the top of this list of keywords (Note this is part of a larger XML document.) I’ve tried to use the XMLUpdater to no avail after a substantial Forum search. Here’s where I am at with the XMLUpdater:I assume my XML/XQuery expression is the issue. Any help would be appreciated. Thanks in advance!Version: FME 2022.2.0.0 (Build22765)

 Hello,  I am updating an existing AGOL Hosted Feature Service with changes in a File Geodatabase. The workbench in the screenshot is what I am using. The Feature Service updates no issues, and it does update the feature service. But I have a question:When I add 1 new feature in the file gdb (Updated FGDB Feature Class Bookmark in screenshot), I run the workbench and in the ChangeDetector it shows 1 record Inserted and 238 records updated for a total of 239 records; The only change I made was to add 1 new feature (which I expect to be in Inserted), but why would there be 238 records in Updated in the ChangeDetector when I only Inserted a single record and Updated zero records, should these 238 “Updated” records be in Unchanged?I then reran the workbench it showed 239 records in Updated (which includes the one I added in the 1st run), but I Updated zero records so I would assume these 239 records should be in Unchanged?  The ChangeDetector Parameters I am using is in the screenshot. 

Hello everyone,I'm facing a challenge in processing data in Excel and I'm seeking assistance. I need a method to search in one Excel table for entries that contain values from another Excel table and then create a new table with the found entries.Specifically, I want to search an Excel table (Table A; 8 collumns) for certain keywords. These keywords are located in a separate Excel table (Table B; 1collumn). When any of the keywords are found in Table A, I'd like to create a new table with these entries.I would greatly appreciate any advice, tips, or examples that could help me solve this issue.Thank you very much in advance for your help! 

Is there a way, similar to AttributeExposer, I can import the columns from a CSV file and use that to identify what columns to keep? I’m reading a number of CSV files into a workspace with different attributes for 3 different file types and there are over 300+ columns. A picklist approach is a bit cumbersome.

Hi.I have millions of XYZ points (as an Space Delimited XYZ file read) and want to build a triangular mesh out of them.Which transformer(s) should I use? Thanks in advance.

Hi, I have many polygons with height attribute. I need to dissolve the adjacent polygons and keep the max and min height of polygons dissolved. The problems it’s the quantity of polygones that are dissolved it’s random, can be 2, 5, 50, 100 or more. I made a dissolve with generate list, then a ListSorter but then I don’t know how to get automatically the min and max. I think to use attributeCreator with Arithmetic Editor after the ListSorter but I don’t know how to set it to get systematically the min and max of entities dissolved Thanks

Hi, I tried it with a mod counter,  Inputs seem to work but no output at all comes out of the custom transformer. I am passing all attributes (not many anyway) into the custom transformer. It makes no difference  I am trying to add a Z value to each point (frorm vertices). With the TIN I get a much cleaner result than with a raster, but it slows down the entire process x4. Thanks in advance for any suggestion.

Hi FME users,  The main purpose of my recent FME workflow is to GET the files from the folder from the FME server using HTTPCaller. Although the process displayed green which means the process is running correctly, the inspector showed the HTTP status code 200, which means the results are rendered in the response body (Figure 1. ) but not created successfully in the local drive. Figure 2 is the basic setup in HTTPCaller. Figure 1. FME Inspector. Figure 2. HTTP Set-up  Then, I tried another URL copied from FME API using POST, /fmerest/v3/resources/connections/Data/download/Logo/CPB_Logo.jpg, then the FME gave me the HTTP error code 403 FME Server is version 2023.2.1FME workbench is version 2021.2.3 Do you think it is because of the Version or some other issues? Thanks,Du

is it possible to  Exporting OLE Civil 3D Objects From Drawings to excel 

Hi, I've been working with a web connection to Sharepoint Online, created with help from this article:How to Create a SharePoint Web Connection for FME Form [Single Tenant]For SharepointOnlineConnector. It works for a time, but after a day or two there is a problem with refreshing my access token. This was the error message today:Updating access token for 'Microsoft SharePoint Online'Request to update access token failed. HTTP Error: HTTP/1.1 400 Bad RequestPython Exception <FMEWSException>: Type: 3, Number: 1, Message: Failed to get authorization header.If I reauthenticate my web connection It works again for a time.Any ideas what the problem may be?

Is it possible to use FME to monitor servers and services that include the following: Request Failure Alarms (example includes when an internal or external website gets a 502 error) Response Time Alarms (example includes if a website takes longer to respond than usual) Available Storage on a server (example if storage gets to 20 percent then send an email notification) Server Unavailable (example is if a VM goes down) I know I can do these things using VertiGIS Analytics for the GIS side; but am curious to know what FME Form along with FME Flow can do, if it is even possible to do at least one or any of the things I list above? what transformers would be useful? maybe creating a few workspaces and publishing them to FME Flow.    

I have an AttributeManager in a custom transformer (may be part of the problem but thought I would start simple with the AttributeManager) that has the following data (correct) on the input but the name of the attribute (not the attribute values) is assigned in the output.Input Attribute “Public_Water_System_ID” with correct values and output with wrong values:Settings in the AttributeManager is as follows:For data type I’ve tried buffer (default), varchar(20), and char(20). None of the other types seemed to make sense since the values are string.Perhaps a related problem is that this attribute (“Public_Water_System_ID”) is passed as a parameter into this custom transformer and is seems like there might be an issue with the transfer.  However, that being said, the correct values are appearing at the input port of the AttributeManager which is downstream from the custom transformer input. 

I have been tasked with connecting to an FTP site, retrieving a csv file, parsing that file into multiple Excel worksheets within one workbook and then FTPing the Excel spreadsheet back to another FTP site.I have all the component pieces working, in 6 different workbenches, the download of the original csv file, the parsing and writing of the data for each Excel sheet and creation of the four individual worksheets and the upload to the destination FTP site.  However, I have been advised by the local FME Admin that the process should be housed in one FME workbench.  And in order to achieve that, instead of downloading a physical csv file, I should be downloading the data as an attribute so that all of the subsequent processes could be housed within one FME workbench and the attribute data shared by each subsequent process, leaving no artifacts at the conclusion of processing.I have created one FME workbench and copied all of the processes into it and made all the adjustments to User Par

I am using SQL Executer but in the output port I am not getting the attribute exposed automatically. My SQL expression I am only counting the inputs so I cannot expose the attribute using “Populate Attribute from SQL”. I cannot use Attribute exposer every time I am using the SQL. Is there any other way to do this.

I am using FME(R) 2022.1.3.0 (20220928 - Build 22630)I noticed while working with ArcGIS Data (FileGeodatabase), that when I usethe “DatabaseJoiner” Transformer to join attributes with curly brackets inside its values, the curly brackets are gone after joining. e.g. Original Attribute value: {12C300A2-64C3-4494-A1E2-430CC5C5C7A9}joined value by DatabaseJoiner: 12C300A2-64C3-4494-A1E2-430CC5C5C7A9It this a known behaviour? Why would it get rid of the curly brackets? Anything to do against it?

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

Hi All,I’m working on a workflow to project a DWG from one coordinate system to another. The workflow works fine but am having issues to write autocad_oriented_arc into the DWG final output. I did some test to write it to GIS format and those autocad_oriented_arc write ok but for some reason can’t get them to work in DWG format,I’m sure that am missing some settings in the writer because the visual preview shows those arc fine, see below: I’m using the following:FME(R) 2023.1.2.0 (20231110 - Build 23641 - WIN64)Writer Autodesk AutoCAD DWG/DXF parameters as follows: Thanks!