FME Form

Hi I've tried to use The Excel To PDF Writer but i have problemsafter some errors about phyton stuff i have installed pywin32 and pypiwin32  https://docs.safe.com/fme/2021.0/html/FME_Desktop_Documentation/FME_Workbench/Workbench/Installing-Python-Packages.htm fme.exe python -m pip install pywin32 --target C:\\Users\\<username>\\Documents\\FME\\Plugins\\Pythonfme.exe python -m pip install pypiwin32 --target C:\\Users\\<username>\\Documents\\FME\\Plugins\\Python fme.exe python -m pip list it was successfully but again an error message  ExcelToPDFWriter_ConvertPDF (PythonFactory): Splitting bulk features into individual featuresPython Exception <ModuleNotFoundError&g

i have a feature in the sde db that is 1.7M records, the data i am trying to select has a field i want the user to select from. the 1.7M records data set does not have that field so i want to select them spatially, which i am doing now, without all 1.7M records having to be read by the workbench. 1000 or so records to select takes about an hour due to the workbench reading all the records before the spatial selection happens. is there any way to pass my buffer results from the users selection to the reader in the envelope section of the reader before all the record are read?

Draw connectors to point I have a polygon with a pole and demand points. I want to draw lines from pole point to demand points in that polygon as shown in the image. Any help please

i have an excel file with a GPS coordinates that i changed into points using vertexcreatori'm tying to build a line between those 500+ points, i used linebuild but instead of one line i got a lot of emif anyone knows how to fix it please tell me !it should look like this ( same excel file just sorted by Date attribute ) :

hello, i'm interested to know the usual process in reading/getting files from FTP caller.I did make FTP caller run, however, I don't know the next transformers to use to read the csv (not in a zip file) from the FTP server. I tried attribute splitter and list exploder, but didn't work. Can you share a sample workbench for the same case, please?Thanks!

FME Desktop v2021.1.1.0postgresql v11.13 We have an expiration date col that we default to a hard coded high value on INSERT using a trigger and function. The value of that timestamptz col is:9999-12-31 23:59:59.000 -0600 SQLCreator or SQLExecuter will not allow the selection or reference of that column. However, I can select or reference the col in DBeaver without issues. This statement produces this error in FME:select exp_ts from test_table;POSTGIS reader: An error occurred. FME will attempt to obtain more information on the error, but this may cause the translation to be terminatedPOSTGIS reader: An error occurred. Here is the information that FME was able to find on the errorPOSTGIS reader: stk::ex::bad_expected_access Workaround was to change the col to timestamp.Any ideas?      

Hello, I am trying to figure out a way to schedule an ArcGIS API for Python Script form FME environment. I want to be able to use FME environment as a replacement of Windows Scheduler. Appreciate any feedback.  Thanks  

Hello and welcome to What's Up Wednesday,Here are some stories about FME news for this week. Accelerating your FMEI've seen a few training courses recently labelled "accelerators", and obviously, the aim is to bring users up to speed with key technology in a short time. So did you know that there is an FME Accelerator training course?  If you're a long-term FME user, who's already taken several training courses, then this might not be for you. But... it would be very useful for that colleague of yours who has used FME a little bit, yet isn't aware of the full potential of FME. It's 90 minutes of pure inspiration to bring you up to speed with FME potent

I am working with FBX files but this is the error I am getting when I am trying to extract the coordinates x, y, z. Because of this issue eventually I fail to create tileset. @kailinatsafe​ @chrisatsafe​ 

Creating and enclosed polygon of the point data. Hi, I have a pole data connected to houses. I wanted to create an enclosed polygon with the pole and all its corresponding demand points. Can some one help. Attached is the requirement

Hello, i have problems to write data with the Esri ArcGIS Portal Feature Service Writer.The writer is not able to write the date-values into the date-type-attribute. I've did research in the internet and tried a lot of different date-formats but nothing is working.I've also created a hosted feature layer in Portal for ArcGIS to see how the dates are written when i add features. I cloned that date-format in the workspace but this also failed. Is anyone out there who successfully wrote date-data with the Esri ArcGIS Portal Feature Service Writer or has an approach to solve the problem? I'm using Workbench 2020.2.0.0 (20201027 - Build 20787 - WIN64). Thank you very much! Greetings!

I need something like 3*bottle = bottle;bottle;bollte. First table is what I have and second what I need. 

I am writing to a Dynamic GDB writer using an existing GDB with Domains as the Schema Source. I am resolving the domains otherwise just the values come across, but it is also creating a new attribute called "attribute_resolved" which is then being written into the feature class in the GDB. I have tried to use an attribute remover and an attribute manager to remove these attributes prior to writing, but they still get written. Strangely these attributes don't exist in the Attributes To Remove dropdown list in the Writer. Any help would be greatly appreciated.

I have created a 3D object that used as a geometry instance and placed at a set of point coordinates. My input was a citygml exported from an original sketchup model and a shapefile file for the points. I created a final citygml file combining those two with the instanced geometries. When I upload it to cesium ion as the citygml it works perfectly fine and cesium creates the tiles for me.  Since I need the 3D Tile to use in my application, I then also tried to transform this citygml into a 3D Tile with FME. I simply used the 3D Tile writer. It works without errors and I also can upload it in Cesium ion and I don't get an error. However, when I try to use this 3D Tile in my Stories on Cesium Ion, I cannot see anything. My 3D objects do not show up.  Does anyone have an idea what the problem might be? The citygml that I created seems to be perfectly fine and usable in cesium but the 3D Tile that I create with FME does not show anything in Cesium.

Hi, I am new to FME. I would like to concatenate two columns into one by simply putting the names of the title of columns together in the text editor in attribute manager. It is always successful in 2018 but keep failing in 2022. The two columns are ordinary character type of data without any special characters like * or / etc. Thank you for the help!!!

Hey community! How can I create DWG blocks with related attributes? I need to create topographic point blocks with various attributes, such as point number, point type and other attributes Thanks

I have an excel file, it has a sheet with quotes inside its name:I created a workspace that includes a  feature reader with the following configuration: and use an Attribute Creator transformer to pass the correct information about the file path and sheet name:When I run the workspace, I receive :Opening the GENERIC Reader on dataset `C:\Temp\problematic_excel.xlsx'Excel Reader: Output cell formulas: 'false'Excel Reader: Output cell formatting: 'false'Excel Reader: Output cell comments: 'false'Excel Reader: Force full datetime values: 'false'Excel Reader: O

Hi Guys,for sure someone has aked this before but i didnt find an article.....it is a very simple questioni have to handle with a lot of excel sheets i have to select always the first sheet in any excel file.....but sometimes they have different namesso how can i select the first one.... Greetz and Cheers Franco

Hello,Ourorganization has a server specifically set up to run FME desktop workbenches. Wehave made the GIS connections public and have made every effort to have thesame user that saved the workbench also be the user that is triggering thewindows task scheduler. There is an excel file that is located on anotherserver that FME can access when the workbench is run manually. However, when itis run with window task scheduler there are two errors. 2021-07-3012:01:24|  7.9| 0.0|ERROR |Excel Reader: Failed to open thedataset '\\\\vmcognos\\GIS\\COT Inter Department Meters Consumption Accts-en-us.xlsx'. Errormessage was 'Permission denied.' 2021-07-3012:01:24|  7.9| 0.0|STATS |Stored 1007 feature(s) to FME featurestore file`C:\\Users\\COTAGS~1\\AppData\\Local\\Temp\\CIS_GIS_Bridge_EDITSDE_GISFCTableCreation_PROD_120104\\inspector.ffs'2021-07-3012:0

I want to delete the input data in my script with the help of the Featurereade and the hub FileDeleter , but only when all features have been beforehand wrtitten to an export map in the FeatureWriter (see image below). So I don't want featurereader and the FileDeleter already running when not yet all files have been exported . I was wondering how that can be achieved in FME desktop? In case my question is a bit vague, just let know.

I am reading data from a file geodatabase in my workspace. The data is huge and takes time to process data. I have set up a query to only filter data that ends with .2022 but the workspaces are still slow. Therefore, I intend to set up a query on a Date Modified column and a Create date column in the file geodatabase. This will filter only data modified and created within the last seven days. I can't figure out how to set up a query and filter data from the last seven days in FME. Any help and advice would be greatly appreciated. Thank you, 

FME 2021.2.2 on Windows 11 To use the win32com module with a PythonCaller, I have installed the module with this command.fme.exe python -m pip install pywin32 --target C:\\Users\\<user>\\Documents\\FME\\Plugins\\Python cf. Installing Python Packages to FME Desktop In the PythonCaller script, use the module with this code.from win32com.client import Dispatch This error message appears when run the workspace.Python Exception <ModuleNotFoundError>: No module named 'win32api' I believe that the script is not wrong, since the workspace can be run if I install the module into an external Python interpret

I have one shapefile with polygons representing a cartographic sheets at some scale. Each polygon has an unique identifier (IDn). I have used SpatialRelator transformer (see attached image) to look for neighbor sheets for each of them, and ListConcatenator to save for each polygon the list of neighbor polygons identifiers.  The attached example shows that selected polygon (ID0) has 3 neighbor polygons (ID1,ID2,ID3). The IDn is the identifier included in the shapefile name located in some directory following this pattern: .\\IDn\\*IDn*.shpI have to merge the 4 shp corresponding to ID0, ID1, ID2, ID3 to output only one shapefile.  I have used Directory and File Pathnames READER in other context but here I don't know how to look for these files. Maybe using WorkspaceRunner or PythonCaller? Please, could you give some advice?  Thank you in advance! 

Is there a way to set-up an email notification if our FME engines have been running a job longer than 24 hours? All of our other FME jobs have not run since 7-11 due to our 2 Engines being clogged up by 2 hanging jobs (I cancelled these just now).

Hi Community, does anybody know a way to force FeatureWriter to wait for completion of a writing task of a feature type before the next writing is triggered? I'm trying to delete features on a database (Oracle Non Spatial) with constraints on the affected tables. So I must enforce a specific delete order. Currently I use a rather complex mechanism with mutiple FeatureWriter transformers in chain and would like to tie them down into one FetureWriter.  If a FeatureWriter could be configured in that way it would also be great to do the action within a single transaction. Is this possible too?