Skip to main content

Home
Search

Best Answers

10696 Posts

Recently active

Most views Most replies

michael_mContributor

Trying to create a point feature class from an excel file with lat/long coordinates. Getting a "missing column" error. How to I resolve this?

I have an excel file with lat/long coordinates and I'm trying to create points based on them in a file geodatabase. The geometry is being created but I keep getting an error when trying to view the attribute table: "A column was specified that does not exist." I've checked that all the columns are green in the file gdb writer.If I replace the file geodatabase writer with a shapefile writer everything works fine. Can anybody tell me how to figure out what is going on? Using FME Workbench (Form now?) 2020.1 Thanks, Mike

fmesafe.podporaContributor

asked in Transformers

Filtering based on geometries

Hello. I have a question about one solution. I have duplicate points with the same name, but with at least different geometry. I need to filter these duplicate points relative to this one coordinate. Passed will be the point with the same name that is closer to this coordinate. I am attaching the fmwt. Thank you very much.

elmido13Contributor

asked in General

How to connect fme server to the network drive?

How to connect fme server to the network drive?

lifalin2016Influencer

asked in General

Upgrading server from 2020 to 2022, changed behaviour with automations output

Hi list.I've just upgraded our FME Server from 2020.2.5 to 2022.2.2.I'm still using the 2020 workspaces, and I've noticed a changed behaviour.I did some test with Automation a while back, and thus have some remnant automation output features in some workspaces. In 2020 these worked well, yielding no erros or warnings, but in 2022 a runtime error like this is logged:AUTOMATIONS_2: Server connection error. Unable to send Event to automation route 'Trin2a': { ..... }Why does this throw an error ?Luckily it doesn't matter in this workspace, but I have used Automation extensively elsewhere (nightly data-imports), so I am concerned about whether my other workspaces, that have active automation logic, will work?Is the error above just a disclaimer that it didn't run in a started automation, and so doesn't have anything connected to my "Trin2a" automation feature output, and warns about it in version 2022 (but not in 2020) ?Any insights about this is welcome.Oh well, I guess I'll see what hap

hlynurSupporter

asked in General

Accepting terms and conditions when using a HTTPCaller

Hey there. Im trying to use the good'ol Creator->HTTPCaller->JSon'er method for the data here:https://www.fega.gob.es/atom/es.fega.sigpac.xml Where I am basically sending requests to fetch certain part of the data and then do some analysing on it before exporting to a format. But there is a problem here which is that the service requests you to accept to terms and conditions before you can start fetching. Doing this through browser ain't a problem as you just click on the "LEER Y ACEPTAR LAS CONDICIONES" button and read through the document that pops-up and then press "ACEPTAR LLAS CONCIONES" which brings you to the data. It is using the HTTPCaller where i have the problem, cause just fetching the data (through the same URL) gives me the _response_body:<html><body>No has aceptado las condiciones y no puedes ver los ficheros</body></html> or basically "You have not accepted the conditions" Does anyone have suggestions how to include accepting the terms and

asked in General

Multiple SOAP requesta

Hi all!I want to request the monthly average exchange rate for a whole year. So far, I have transformed the soap request to xml and pasted it into the xml templater. I then post the request by the HTTPCaller and extract attributes by means of the XMLFragmenter. This works fine as long as I request the monthly average exchange rate of one month of a specified year at the time.However, here is were I am stuck: To get all monthly average exchange rate I would need to post 12 request, one for each month. My idea was to do this by means of sub templates, but I have not succeeded in doing so. I tried to import a file containing a list from 1 to 12 (1= january...12=december) and connect this list to the sub port. I could add 12 xml templater and httpcaller instead, but this does not seem very effective. Is it possible to achieve this by sub template?Or is there a way to dublicate requests or is it in some way possible to loop through the request?Any ideas and help are welcome!Thanks in adva

asked in Transformers

Hi, I am trying to practice "Generate workspace" module but I don't have "FME Training PostGIS database" connection available. I tried to add database connection, but I don't understand what URL to enter in the "Host" parameter.?

Hi,I am trying to practice "Generate workspace" module but I don't have "FME Training PostGIS database" connection available. I tried to add database connection, but I don't understand what URL to enter in the "Host" parameter.?

ebygommEvangelist

asked in Transformers

Schema Mapper and embedded PostgreSQL connection parameters

When using the schema mapper and connecting to a postgres table and choosing embedded connections there are no options to choose a parameter that holds the relevant value. For host, port, database and username, I'm able to type e.g. $(STAGING_DB) and create the link to my user parameter that way. However this doesn't work for the password field.Is there any trick to link the password parameter? (FME 2021.2.0.0 Build 21784)

joyEnthusiast

asked in General

FME Server 2022.2.2 When sheduling a script password changes itself automatically

In my colleague'script there is an ArcGISOnlineConnector and my colleague made a parameter of the password for the ArcGIS Online connection.At FME Server, we first filled in the parameter for the workspace and made a testrun. The script ran and it works. However when I make a shedule of this script, fill in the parameters, after triggering once, then for some reason the value of the password gets the following string (see image below). I am not sure why that happens. Then I change the value to the correct pasword, however after triggering the schedule, the password changes itself again into that long password, while this long password is not defined in the script itself. Since the password is not correct, the script will fail since no connection can be made with ArcGIS Online. Does anyone might know why this happens and what I can do to get the original password all the time instead that it changes itself after running once succesfully.

asked in General

SOAP API not working in FME

Hi all!I want call a soap service in FME. I use this link:https://swea.riksbank.se/sweaWS/wsdl/sweaWS_ssl.wsdlI used the program SoapUI to generate and test the xml request. In SoapUI the return works fine. This is the request I use:<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsd="http://swea.riksbank.se/xsd"> <soap:Header/> <soap:Body> <xsd:getMonthlyAverageExchangeRates> <year>2022</year> <month>1</month> <languageid>en</languageid> </xsd:getMonthlyAverageExchangeRates> </soap:Body></soap:Envelope> However, in FME I only get a list of function as a return.Any help is welcome.Thanks in advance!

Smallworld points to Microstation V8i cells are different sizes

I am translating a group of point objects at different rotations from Smallworld to Microstation V8i. The same object in Smallworld and using the same FME translator. The resulting DGN has different size cells to represent the same object. The point objects that are at 0, 90, 180 or 270 are the correct size when translated but other angles translate larger. I am open to any ideas on why this is happening and what can be done about it. Thanks

asked in Transformers

1. How do I export, to an excel template, data from a Survey123 form that has related tables? 2. Rather than overwriting the excel file, how can a create a new excel file from the Parent record, while integrating in the Survey123 related tables

I have a Survey123 form, that needs to be exported to a specific excel template file. The Survey123 form has 1 layer (parent record), and two related tables associated with that single record. The final format for the excel template would need to be 1 file per record, with two sheets (from the two related tables). Prior to exporting out to the template files, I would need to filter the data down by a site name For instance, a site (that I have filtered down to) may have 4 records taken on it, so I would need to create 4 separate excel files, based on a Plot ID field. Each on of these excel files would then have 2 sheets based on the related tables of the record. Open to suggestions and comments. Thank you!

wlangejansContributor

asked in Transformers

Is there a way to establish parent child relationships between line segments?

I am working with conductor line segments and need to establish a parent child relationship between these lines. For example I would like to assign conductor "2" a parent value of "1" and a child value of "3". Has anyone accomplished this task or have an idea of how to go about this?

asked in General

Hi, I am an absolute begginer in using FME and I highly appreciate any outputs to my question. Anyway, I am trying to remove unnecessary areas inside of polygons (shown in the image) and connect neighbouring vertex togather.

asked in General

Preventing FME Server Workspace Job cancellation on closing tab/browser

In a FME Server workspace app, how do I prevent the job from being cancelled if i close the tab or browser before the job has finished? In our case the processing of the job takes a very long time, so I don't want to expect the user to leave the tab open all the time.

If i have an outline of the UK and coordinates dotted around the UK represented as points, is it possible to create polygons which 'colour in' the UK based on the closest point? and if so, what approach should I be taking?

Ultimately, i aim to end up with a map where you know depending on your location, where your nearest point is, represented by area.

zacharylee_1204

asked in Transformers

Transformers questions

Hello Sir/ Madam, I have several transformers that I am not quite understand even I checked on the "help". I hope someone can give me a hand. May I ask what is the purpose of using transformer "Creator"? I often use "reader" to add the data. However, I saw other people use "Creator", may I ask why?What is transformer "GeomtryCoercer" does? It said to reset the geometry type, what does it mean?How about "Aggregator" and "Deaggregator"? does it mean to combine and separate data? Thank you.

asked in General

I want to convert a file with extension ".SFC" in FME. SFC does not seem to be included in the Reader's Format. Is there a possible way to deal with this?

SFC (Scadec Feature Comment file) files are used to store CAD data and are included in the SXF (Scadec data exchange format) format of the CAD data exchange standards.

Generate simple trees from Point Cloud (LIDAR)

Hello,I want to create simple mesh trees from Point Cloud (LIDAR) in FME. And the closest thing I came to was with the "PointCloudSurfaceBuilder" transformer.Can anybody help me with this, please. The file is the way I want the final trees look like (it seems like it is about 8 piece of pentagon polygons for each tree).And the file is the closest I came in FME.I attach the FME-Workbench file and the input LAS file (and it looks like this ).Best regards,Jonas

martinkochEnthusiast

asked in General

Which .NET components and versions does FME Server depend upon?

Hello all, Because of this Microsoft notice on e.o.l. for .NET Framework 4.5/6/7 I got questioned of the dependencies of FME Server. A quick search both on the Safe documentation, as on the interweb did not yield a satisfying answer, so I post it here... On which Microsoft .NET components and versions thereof does FME Server depend? Will upgrading to .NET Framework 4.8 break an FME installation? Client asks for an official statement from us, or from Safe Software that upgrading the .NET framework won't cause any issues. [edit]: It involves both FME Server version 2021.1.1 and 2018.1 Kind regards, Martin p.s. I checked the Windows-FME-servers I have access to, and they all have .NET framework 4.8 installed, so I do have my gut-feelings on this subject. Also I would be more than astonished to hear Safe developing newer releases of their product using outdated Microsoft frameworks.Only those things won't convince the client involved.

gmbutler2Contributor

asked in General

How can I limit 50 records to a file with a maximum of 10 different types of objects within that 50 record file?

I have a dataset that has multiple records, each with a different types. Each of those types could have any number of records from 1 record to 5000+ records. How can I write these records to individual files based on a limit of 50 records per file with no more than 10 types? For example: File 1 would consist of:Type 1 = 10 Records,Type 2 = 37 RecordsType 3 = 13 Records File 2 would consist of:Type 3 = 50 Records File 3 would consist of:Type 3 = 5 recordsType 4 = 45 records and so on... and so on... I've tried groupers, and I have tried building lists, I've also tried the modulocounter, but I can't seem to find a way to build this criteria with any of those. Any help is much appreciated! Thank you! I've built a sample set of data that could be used to do testing. My final output needs to be no more than 50 records per file with no more than 10 Circuit ID's in each file. Please help! 😁

vkiContributor

asked in Automation

directory watch: run the automation during the night

I would like my automation to watch a directory. If there's a update, then the rest of the automation runs, but only during the night.I could use a directory watch trigger to run the automation immediately after a change, or use the schedule-trigger to run the automation during the night, but how can I combine those triggers?Thanks, Vera

lacyContributor

asked in Transformers

Construct a URL from a Windows file path?

I'll be the first to admit this may be a dumb newbie question, but I'm struggling! I have an input field that contains a file path like the following:q:\\staging\\incoming\\1930s\\WI\\Sauk\\1937\\Sauk_WI_WU_11_908_19370707.tifI need to construct a URL to the file as referenced in a URL, and dump it into another field:https://server.com/1930s/WI/Sauk/1937/Sauk_WI_WU_11_908_19370707.tif My conceptual approach has been to use string processing to replace q:\\staging\\incoming with https://server.com, and then replace backslashes with forward slashes. Well, you can see where this is going... the slashes and backslashes are wreaking havoc. For example, I've tried various combinations to escape the \\, like:@ReplaceString(@Value(inputpath),"/\\","/")... but I either get no results, or a syntax notice. Am I even in the ballpark?? I'd love some suggestions on how to approach this issue.

f.kemminjeContributor

asked in Transformers

How to generate new line along lines ?

@nielsgerrits I have a road shape file with numerous segments (links), all of which share the same road id. Now the user has provided me with csv data, claiming that this is the bad route from chainage 0.75 to chainage 5.1. In order to highlight the road, I must add another line geometry (a long line) on top of road features. The created line must overlay eactly on top of road. the created line begins at link 1 (0.75 chainage far)and extends to link 9 at a 5.1 chainage. How do I accomplish this with fme? I tried a lot of different things, but none worked. Actual line length and chainage length are two different metrics. We can take the proportionately dividing road length since chainage length is accurateWhat I mean is that if the real length of the line is 1.5 km and the start chainage and end chainage (attributes) difference is 1 km, then it becomes 100 m = 150 m in geom length. sample source shape file attachedand source shape ,desired output line, how it looks like( jpg files)

melaniedContributor

S-57 ENC Reader : bug in implementation of gdal ?

Hello,I use FME to transform data in S-57 format (the native format of our databases) into more traditional formats, in particular shapefiles. The database export is therefore in S-57 format (extension .000), with the classes and attributes present for the ENCs, but this model is enriched with additional attributes and classes. This can be done by modifying the files s57attributes.csv, s57objectclasses.csv and s57expectedinput.csv in the directory $FME_HOME/s57 (Custom Object Classes File and Custom Attributes File). These files are also useful for correctly displaying additional attributes and classes in QGis (in the directory C:\\Program Files<QGIS>\\share\\gdal). While in QGis an S-57 file with additional classes and attributes is displayed correctly, this is not the case in FME.For additional classes: some are handled correctly, others generate an error when read and you can't go further in the processing (there are also cases where the class seems to be ignored, without

1
...
94
95
96
97
98
99
100
...
428

Page 97 / 428

Badge Winners

gabrielmghas earned the badge FME Form Advanced Training
jhu_20has earned the badge Conversationalist
jhu_20has earned the badge Student (Bronze)
jhu_20has earned the badge Student (Grey)
jhu_20has earned the badge Teacher (Bronze)

Show all badges

Community Stats

32,604: Posts
123,752: Replies
40,948: Members

Powered by Gainsight

Terms & ConditionsAccessibility statement

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

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 Trust Center Privacy

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