- - Community Resources
Ideas
Product Updates
Events
Blog

EN

Home
Search

Unanswered questions

19405 Posts

Recently active

Most views Most replies

lifalin2016Contributor

asked in Automation

Merging implicit parallelism in an automation ?

Hi.I have built an automation with some business logic consisting of 4 chained workspaces (W4). I duplicate this automation for each new dataset I need to run, using a single global variable to control the data being handled (SQL Server schema name).However, one customer has 4 such setups, which gives me some problems when coordinating the 4 automation runs, and I would very much like to just have to run a single automation for each customer (with multiple schemas).I’m thinking that I could use the global variable to define a separated text with all 4 schema names, using a single workspace to split this into 4 outputs via an Automation Writer feature type, and start my 4 workspace chain (W4) for each value.However I’m unsure how to merge the 4 W4 runs. How will a Split-Merge block (or Merge action) handle such runs ? The content inside the block is just the 4 chained workspaces, but they’re being run 4 times in parallel.Has anyone attempted this, or have any insight into merging works

catherinevachonParticipant

asked in Community Q+A

FME Flow 2023 GDB/GPKG writter with fanout expression not working

Does the fanout expression is available on FME FLOW 2023 ? My FME Workbench works well on FME Server 2020, but on FME Flow, I got an error that mention that I don’t have the permission to write in the specific folder, but I have that permission. For example, the Destination Fanout is $(FME_SHAREDRESOURCE_DATA)/temp and the Fanout Expression is /gpkg/test_@Value(attribut).gpkg.zip. I got this error message:MULTI_WRITER: Failed to create folder '/gpkg/test_hello.gpkg.zip'. Please ensure you have sufficient permissions to create this folderIt seems like Destination Fanout is not taken into account.

fme_dr22_forumContributor

asked in Transformers

looking for a transformer tool in FME to compare two GIS datasets

Hello fellow FME-ers. I'm looking for a transformer to compare two GIS datasets and what has changed compared to each other. Actually, the Symmetrical Difference tool that is present in ArcGISPro. This transformer must be there in FME. Can anyone help me with this? Thanks in advance.

redgeographicsInfluencer

asked in Authoring

Importing database connections in FME on Linux, no gui

One of my clients is using FME on Linux with only the command line interface and is having some trouble importing database connections. Specifically: they don’t know how to do it on the command line.I can’t find much in the way of documentation for this. I suspect that if it is at all possible it may be through the APPLY_SETTINGS command, but other than that I can see that that exists, I can’t find any indication anywhere on what those settings may be and how to set them.Any clues? Anybody with an old manual somewhere? I do have old installation cd’s and dvd’s going back to FME 2005, but I don’t think I have a computer with a cd or dvd drive anymore 😅 Hoping one of the other long-time users has something stashed away...

mariasContributor

asked in Automation

Error in S3Connector: A value must be supplied for the S3 key. Use '/' to refer to the root of the bucket

Hello,Seeking your help, please.I have published the workbench from Desktop to FME Flow. It should extract files from S3 and do further manipulations. It works good on the desktop. But when I published it on FME Flow, I am getting an error:S3 AccessKey and Secret key are stored in the workbench as User Parameters.What is missing to make it work on FME Flow?

PostGIS dynamic writer forces lowercase attribute (column) names

As is stated in the title. However I need column names to be created exactly as they are, for example I have incoming attribute "OGC_ANGLE.uom" and even though I have Lower Case Attribute Names unchecked,tables in database have column names are created lowercase ("OGC_ANGLE.uom" becomes ogc_angle_uom) - this is a problem, if I read those tables and try to use xsd to create gml again, as these attributes are unknown to the xsd, therefore failing creation of the gml. I could manually rename those columns, however I would need to rename those columns every time xsd file changes, which is why I need to do this dynamically in the first place, as those xsd files are going to be updated quite often... And it seems that the dynamic PostGIS writer ignores Table Qualifier, it always creates tables in default schema, unless I specify schema in Table Name (schema.@Value(fme_feature_type))

bark0sContributor

asked in Transformers

GDB Reader browsing slowness

We’re currently experience FME 2 minute+ freezes when we add an Esri GDB reader to a workbench, then press the ellipses to browse to the location. This only happens in the dialog if we have selected Esri Geodatabase (File Geodb) as the Format. We have found a work around of pasting the GDB path into the dialog box but we still experience a 30+ second pause when we hit Parameters/Tables. This takes a substantial time to load. The issue is decreased when a gdb reader is added to a brand new workbench.

cavarlyContributor

asked in Authoring

Writing null geometry features to ESRI file geodatabase

Is it possible to create features with a null polygon geometry and write to an ESRI file geodatabase?I have some features with known geometry which I write successfully.I would also like to write features with no geometry to the same table and update their geometry by manual editing later.I have tried modifying fme_geometry{0} and fme_geometry but nothing seems to work.I usually get an error like “can’t write features to and area feature type” I have read through similar questions but don’t seem to have a complete response. It appears it is possible to create a valid null geometry. Thanks go any help.

salgardiContributor

asked in Transformers

Ascii to Shapefile -

Hi there,I have an Ascii grid file.The FME can read the file I have also added a Raster Cell Coercer transformer to create a shafile this simple workbench works fine. Issue - How the raster values can be displayed in the shapefile. The shapefile has no attribute data (cell values).I need to display the raster values in the shapefile. Any hints will be greatly appreciated.Thank you very much,Sebastian Algardi-CamusWorkbench Raster image

chlaw2001Participant

asked in Community Q+A

FME Message #706501

Hi, as a newbie in FME, I am using a FME ISO8211 reader to expose some of the attributes for further transformers. However, if all records have to be read, a message “Message #706501 is not present in the message file: Parameters are >< and FME HOME is >C:\Program Files\FME\<” was prompted and the whole process was halted. The FME version I am using is FME2018. Thank you for the kind response!

pearly1Contributor

Correctly reading table in CAD

I have an asbuilt with a table that has all the locations/names of the structures. The table layer name is “text” and when i bring in the drawing, the text layer is empty. Im sure its how i have my parameters set up so a little guidance on how to read this would be great.

kersyContributor

Value of attribute could not be converted to type 'timestamptz'.

I am trying to upload ifc data through PostGIS Writer and while doing so, I want to generate and store the time of upload as well. However, it gives the following error: “Value of attribute 'begin_lifespan_version' could not be converted to type 'timestamptz'. Feature will be logged and skipped.” can someone help? I am a beginner in FME as well.

bruceharoldContributor

asked in Transformers

The S3Connector doesn't let me enter a bucket name manually, what's the trick?

I’m attempting to access an AWS marketplace free resource, NOAA’s bathymetry, but with Anonymous access if I enter us-east-1 as the region I cannot manually specify noaa-bathymetry-pds as the bucket and I cannot get a picker, or not that I can see. Is there a trick? Thanks.

asked in Integration

FME bug causing failure in Workspace Runner, multiple datasets

Hi all, Since upgrading to FME 2021, I have found previous workspaces that were working in 2020 are now not working. This appears to be when multiple datasets are referenced in a WorkspaceRunner and through a user parameter. It concatenates the filepaths together and loses the double quotes and separation, causing the reader to fail. Any help would be appreciated. Kind regards,Jack

sar_coppContributor

Transposing Using the postcode and question number as a pair, possibly a list?

Morning, I am trying to transpose some data from a survey, I want to sort of Pair up the Postcode and the Question Number, then have columns of Responses with counts. Ive attached images and a fme workbench of the original data and the output I want. I have 36 questions, so want to know if there is a way to do this using a list? So I dont have to repeat this 36 times, I am not understanding how to do lists!I want to output the postcode as a column, then have a question number column. So each postcode will be repeated depending on the number of questions e.g.Question No PostcodeQuestion 1 M19 4NYQuestion 2 M19 4NYQuestion 1 M4 7ATQuestion 2 M4 7AT Then I want the next columns to be counts of the answersQuestion No Postcode Strongly Agree Agree Neither Disagree Strongly DisagreeQuestion 1 M19 4NY 2 3 1 0 2Question 2 M19 4NY 5

liamfezSupporter

asked in Authoring

Writing Geometries to an Attribute in MongoDB3

I have a complicated collection of features stored in mongo db, where a given feature may have multiple unique geometries stored as individual arrays. I would like to use the “Put” Operation in the writer to replace specific features. However when I write to mongo I get two different results (see screenshots of dummy feature with just one example geometry).location.coordinates{} attribute type set to stringlocation.coordinates{} attribute type set to doubleThe desired outcome would look like this:Referencing other community posts on related matters:After reviewing those other community posts I think I am going to need an alternative method to what I had started to develop. But I wanted to see if anyone had any ideas or experience with mongo writers to say otherwise.Thanks

mlupienContributor

asked in Transformers

CSV content from SQL field to Features

Hi Community,I need to extract a CSV Style content from a SQL field of an SQL table.It is stored into a single field.The content looks like this:Classification,Fonction03-1,30003-2,301AA-10,C-1000AA-12,C-1000AA-15,C-1000AA-17,C-1000AA-20,C-1000AA-22,C-1000AA-25,C-1000AA-27,C-1000AA-30,C-1000As you can see, the first line gives me the Attributes names and the following lines gives me the valuesWhat would be the best way to turn this into multiple features using the first line as the Attributes names ?Thank you

txalapartaParticipant

MongoDB writer with nested documents

I am working with MongoDB trying to upsert nested MongoDB documents. The JSON format would be something like:{“name”: “XXX”,“tables” : [ {“name”: “XXXX”,“num_rows” : 3423,“fields”: [ {“name”: “XXX”, “type”: “yyyy”} , …. ]}, ….] I have no problems when I use a JSON string attribute inserting a new document with Document Source”: Json Attribute” and Insert operation.But, I do need to UPDATE existing features.In this case, the nested dcouments (tables in the json above) are created as plain strings. Which is a real inconvenience in my use-case.{“name”: “XXX”,“tables” : [ “{“name”: “XXXX”,“num_rows” : 3423,“fields”: [ {“name”: “XXX”, “type”: “yyyy”} , …. ]} “ , ….]Valid datatypes do not currently include arrays (of objects) Is there any alternative or workarounds?

olivier2Participant

asked in Community Q+A

How to connect all the right points while not including the

Dear, I want to link all the lightposts to the nearby road segment. I used a buffer around the road segments and then Neigborfinder to do this. Now I am afraid that some lightposts are not linked to the roadsegment but I am not eager to increase the buffer or neigborfinder because maybe lightposts that should not be linked will be included. Is there maybe another way to bypass this? Or some tips you could give me?

zaneta.markContributor

asked in Architecture

FME Server/Flow job logs saved as .json

Hi,Is there a way to configure FME Server/Flow, so that logs are automatically saved not only to standard .log file, but also to .json file (containing JSON formatted data)? It would be very helpful when it comes to further log information processing.

jkr_wrkEnthusiast

asked in Integration

End Stream Transformer after 1 minute

I want to use the AzureServiceBusConnector to get the messages from the Queue.But if there are no messages in the queue I want to end the FME Job after 1 minute. Is there a way to terminate the process only if the queue is still waiting.If the AzureServiceBus connector reads the expected amount of messages I don't want to get an error, only if it's waiting for nothing.

asked in General

merge PDF files in one Multiple page PDF

i have many PDF , that PDF i want to merge in single PDF how can i do this

brindaObserver

asked in Integration

autocad map 3d

Hello please I need help. I converted my Autocad Map 3D files to integrate them into my database using the 'Raw relational' mode because my data has multiple tables and one entity with several attributes. Currently, I would like to convert them back into Autocad Map files while preserving the original file structure. I'm stuck because I can't recreate my different tables (Table A and Table B). What should I do?

karloz9999Participant

asked in Transformers

Features do not display EPSG:3006

Hi,I use FME form through ArcGIS Data interoperability workbench and I work with the national Swedish coordinate system 3006 Sweref 99 tm. I cannot display these features with the standard background maps and get: This does not happen in the regular FME Form and they display without problem there. How can I solve this in ArcGIS DI workbench?Is the standard FME Form able to do some kind of on the fly reprojection to view the features on the standard base/background maps? Best regards,Karl

worjakContributor

asked in General

Why is the workspace field empty after hitting [apply] in dynamic workspace dialog?

When in automations you work with the dynamic workspace runner the workspace field blanks after hitting [apply]. It is annoying and confusing because some times the chosen parameter value is not forgotten and some time it is forgotten!? I believe this is a bug but have not seen any mentioning of this in here. So appologies if this is a known issue expected to be solved in next release!Before [apply]:After [apply]:

1
2
3
4
...
777

Page 1 / 777

Badge winners

escortsaerocityhas earned the badge English Speaker
aidsterhas earned the badge English Speaker
mats_anderberghas earned the badge Teacher (Grey)
salgardihas earned the badge Teacher (Grey)
chlaw2001has earned the badge Student (Grey)

Show all badges

28,770: Posts

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

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

Username or e-mail

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.

OK

This file cannot be downloaded

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

OK

A product of

Company Products Giving Back Careers Contact 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.