- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Unanswered questions

10000 Posts

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!

2020

2 years ago

jbradforContributor

asked in General

PostGIS > SQL* - Issue with timestamptz

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?

Launching ArcGIS API for Python Script form FME.

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

580

2 years ago

mark2atsafeSafer

asked in General

What's Up Wednesday (20-July-2022): Accelerating your FME, Co-Founder in the News, Conference Updates, and UV Maps

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 potential and functionality. Anyway, I mention this because we have some upcoming Accelerator courses and because our New Zealand/Australian partner, Locus, is now also offering the FME Accelerator. That's great news for all your FME beginners outside of the Vancouver timezone limits. So check it out, and

2 years ago

rishi1804Contributor

asked in General

Why CoordinateExtractor is generating error. What does this error mean? I am attaching the screenshot of the translationlog for FeatureReader as well as CoordinateExtractor

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

2 years ago

daveapeggContributor

asked in Data

How can I stop the Dynamic GDB Writer from writing the "_resolved" attribute after resolving the domains?

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.

2 years ago

j.jeuschede

asked in Transformers

How do I properly convert a CityGML with instanced geometries to Cesium 3D Tiles?

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. I would really appreciate some help

940

2 years ago

chlaw2001Participant

asked in Transformers

Concatenate texts from two columns in text editor in attribute manager

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!!!

1060

2 years ago

giuseppecfgeo

asked in Transformers

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

430

2 years ago

xtian79Contributor

asked in Transformers

How to handle quotes in a Excel's sheet's name a generic reader

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: Opening dataset 'C:\Temp\problematic_excel.xlsx'...Excel Reader: Reading sheet ''OSVAT-42"''...Excel Reader: Internal error: Could not find any sheets to readCreating reader for format: Generic (Any Format)Trying to find a DYNAMIC plugin for reader named `GENERIC'FME API version of module 'GENERIC' matches current internal version (3.8 20210203)Generic Reader: No valid reader name specified, guessing reader name from dataset 'C:\Temp\

390

2 years ago

franco69Contributor

asked in Transformers

Select first sheet in an Excel File

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

Getting a permission error when using window task scheduler, but not when running FME desktop manually.

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:01:24| 7.9| 0.0|INFORM|Saving spatial index into file'C:\\Users\\COTAGS~1\\AppData\\Local\\Temp\\CIS_GIS_Bridge_EDITSDE_GISFC

880

2 years ago

ronnie.utterContributor

asked in General

Do I need a ArcGIS installation on the same server to be able to write to sde.

I should know the answer and I should be able to answer it by my self. But the costumer need an answer asap and I think its quicker to get help from this fantastic community with all this amazing brains and experiences. I know that If you have a FME desktop Esri Edition installed and want to write to a SDE och gdb you also need an ArcGIS installation installed for the license. Is it the same requirements as with FME server and are there in that case any way to change a setup file and point to the installed ArcGIS so that you dont need to install the softwares on the same machine?

230

2 years ago

joySupporter

asked in Transformers

How run the next transformation only when all features have gone trough the transformer beforehand?

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.

2 years ago

fme_can_do_itSupporter

asked in General

Filter Date columns in file geodatabase

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,

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).

150

2 years ago

whkartoContributor

asked in Authoring

Cascading writing in FeatureWriter

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?

Issues with data streaming service timeouts on the web client, but not in server

We have an automation that runs and outputs a report result as a HMTL page using the data streaming service. Our testing did not have any issues, but in our production system, it appears if the job is queued, the web client times out, although eventually the job completes on server. If there are not jobs in the queue, or the job is a quick job it completes without error. Does anyone have any ideas on why this is occurring?FME server 2019 with 3 engines.

BLOCKS 3D WITHOUT 3D INFORMATION

Hey community! I made a script that creates 3D DWG blocks for me but the elevation information does not match the 3D position of the blocks, why? Look at the picture!

2 years ago

rclarkenzContributor

asked in Transformers

Can I make the WMTS Reader stream rather than download tiles?

We're experiencing issues accessing raster data through WMTS from a particular provider. After discussing with the provider what the issue could be they said that seeing FME is downloading all the tiles rather than streaming them, it places a massive request so it is blocked.Is there a way to make FME stream rather than download?

8712

2 years ago

chris28

asked in Transformers

Update table - SDE Geodatabase

I have a ESRI SDE Geodatabase that was created using an identity field. So, to update the table I am using the Microsoft SQL Server Non-Spatial Writer. For some reason though it won't update the table. The table parameters I have are as follows:Feature Operation: UpdateTable Handling: Use ExistingWhere Clause: **Set to the unique fields necessary**Insert into identity column: Yes Is there anything else that needs to be set to update a record?

1255

2 years ago

bschweiger

asked in Transformers

Surface Normal of citygml roof surfaces

Hello,I am loading citygml data with the OGC Citygml Reader and afterwards I want to calculate the normal vector of each roof surface.How can this be done in FME for a big data set? Using the SurfaceNormalExtractor I get some errors that result in stopping the calculation. After sorting out that surface I have to restart the reader and the surface normal extractor. Is there a better workaround?Thank you for your help in advance!

810

2 years ago

bubblebebContributor

asked in Transformers

More efficient aggregation

I have a dataset with 29m polygons some of which have the same attribute (say Key ID). I need to aggregate them by the Key ID but the dataset is not ordered. After nearly 12 hours of run time it has only aggregated 1.1m features. I need to find a better way of aggregating. Any ideas? The data is being read from about 10 shapefiles as the source data. I have access to Postgis if that would help.

Trying to retrieve files via SharePoint Online (safe.microsoft-sharepoint) always results in an access token expiration on FME server

Hi When my published workspace on the FME Server makes a call against Sharepoint (graph.microsoft.com...) in order to download or upload files, it always results into a SharepointRESTAPIException and needs to republish the workspace with a reauthenticated web connection again and again and again in order to make it work: 2022-7-12 16:17:49 | Python Exception <SharepointRESTAPIException>: SharepointOnlineConnector: Error making request to https://graph.microsoft.com/v1.0/sites/[TENANT].sharepoint.com,[MYSHAREPOINTSITE] Access token has expired or is not yet valid. This way, an automation is absolutely impossible since manual actions are required. Our admins tell that the registered app on the Azure AD cannot be changed regarding the refresh token timeout:https://docs.microsoft.com/en-us/azure/active-directory/develop/refresh-tokens#refresh-token-lifetime The request parameters in the web connection definition looks like this:client_id=[CLIENT_ID]&client_secret=[CLIENT_SECRET]&

Automate Download, Extract and Prep as .csv for FME Job

I have a process I need to automate.Let me describe what is usually done manually 1) I go to this website. I download a zip file. This is not a true FTP as it was suggested to be. So the automated download does not work. What is the way to figure out the javascript behind this? Or is there any other way to do this?2) I extract the zip file, but it's in the .tsv format. All I do is rename it to .csv The job cannot read that .tsv file. Perhaps it's not a good representation of the .tsv file. It's very clunky .csv, however usually works3) Once it's ready for csv the FME job updates the parcel data based on this csv Where to start with this? I was suggested to look into selenium, but I am open to anything

820

2 years ago

Page 191 / 400

Badge winners

ohagand1has earned the badge Welcome Back
holdsyhas earned the badge 12 Days Participant (2024)
ibeezumahas earned the badge FME Certified Professional
stefan_kutachas earned the badge Welcome Back
tim.albert.vaahas earned the badge 12 Days Participant (2024)

Show all badges

30,194: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.