- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
General

General

A read-only category for lost FME Form topics. We hope to move them shortly.

4,033 Posts
13,782 Replies

When you subscribe we will email you when there is a new topic in this category

4033 Posts

Recently active

Most replies Most views Newest first

tim_t

asked in General

Hello everyone, I am extremely new to FME and I am trying to do a basic task and take a column in excel and turn it into an inline csv document. Any help would be appreciated, even links to know forum answers I can't find yet.

2311

3 years ago

markcoopersdcContributor

asked in General

Sum attributes for each record

Hi I have a database which has about 80 attributes that I need to add together. Short of manually creating an attribute in Attribute Manager's arithmetic editor, is there another way that can sum there? I thought about creating a list, but that creates a numbered element per feature, not per field like I need. Many thanksMark

Updating adjacent elevations

The data has three points crossing a main segment. The center point will generally hold the correct elevation value needed for the adjacent features.

4 years ago

ostojaContributor

asked in General

Run more than 16 threads in parallel using the custom transformer

I would like to run more than 16 threads using the custom transformer in parallel on one machine. If I read the documentation, that is not possible because there is a limit to the number of processes available for FME licenses – in my case it is 16.Do we have in the FME licensing some trick which will allow us to connect two licenses to the FME client machine and by that use 32 threads with the custom transformer?

4 years ago

LizAtSafeSafer

asked in General

What's Up Wednesday: FME News for the Week Ending 6-November-2020

Welcome to your weekly FME news update! FME 2020.2 is now live!Last week we launched FME 2020.2. This release is a smaller release in terms of new functionality, but we spent a lot of time building the framework for some epic things for 2021! Watch the highlight reel to see some of our favorite things in this release or read all about them in the blog post or on the new features page. Download the latest version from our website. Personally, my new favorite feature is failed ports on Automation triggers in FME Server. Now you can send an email or execute other tasks to let you know your trigger failed. FME Server Dashboards - Feedback wanted!Do you use FME Server Dashboards or another reporting tool to monitor activity on your FME Server? If yes, we’d love to hear from you. Please fill out this Google Form - it should take no longer than 5 minutes. Survey closes November 27th. Coordinate Systems blog postHave you ever wondered about the difference between a projection and a coordin

4 years ago

danielkroon

asked in General

Positive lookbehind in @FindRegEx doesn't work?

Does someone recognize that Regex Lookbehind does not work in the string function FindRegEx, but does work in the StringSearcher transformer? Pattern: (?<=[_-])\\d+\\.\\d*$String: Foobar_1.023 RegardsDaniel Update: I did some testing, this is my result:Conclusion: StringSearcher and ReplaceRegEx behaves as expected with lookaround. StringReplacer doesn't handle lookaround at all.FindRegEx handles lookahead, but not lookbehind. Test workspace is attatched.

554

4 years ago

mark2atsafeSafer

asked in General

Question of the Week: Lists, Measures, and Spatial Analysis without the Spatial

Today we had a great question on the community about counting the number of line vertices in a given section of line: "Lets say I have locations of point/polygon features along a line and I would like to count the number of points along the line using a moving window. For instance I'd like to slide along the line using a window of 100 feet. As I move along the line, I want a count the number of points within the 100 feet window until I reach the end." At first glance, this looks like it ought to be a problem of spatial analysis: you create a buffer perhaps, 100 feet long, and do an overlay to count the points inside it. Then you move it along by a set offset and repeat. But consider: if you could just take the line feature, create a list of its points, and calculate how far along the line they existed... well then you could analyze the numbers not the geometry. That would be easier and quicker. And the distance along the line that a point exists has a name: a Measure. Me

493

4 years ago

hlouieContributor

asked in General

Testing if a Directory contains relevant files

The directory starts fresh every time, files copied are and produced by other FME Workbenches, testing condition whether a directory contains a 1-1000 files. I'm found and filter for the required files via FeatureReader Path but having a hard time testing for specific condition, Tester before a ListBuilder or a ListBuilder then a ListSearcher ??? PASSED condition if the directoryMust find = const.dwg, exist.dwg, passed.kmzMUST BE NOT FOUND = failed.kmz FAILDED in all other conditionsFound = const.dwgFound = const.dwg, existing.dwgFound = const.dwg, existing.dwg, failed.kmzFound = const.dwg, existing.dwg, failed.kmz, passed.kmz......

923

4 years ago

mark2atsafeSafer

asked in General

Expert Notes: Randomizing an FME Server Schedule

It's not up there with previous oddball ideas (sundials, QR codes) but randomly scheduled jobs certainly isn't something everyone will need. On the other hand, perhaps you might want to do data QA at random intervals, or sample a live feed at unscheduled times (what is the weather/traffic load at this particular point?) I thought about how I might achieve this, and here are the methods I used and the results I got. FME Server SchedulingHere's what the scheduling dialog looks like in FME Server: As you can see there are no options to randomize time, which is sensible really. If FME had to pick random times then the user would have to enter the probability of an event (say, 1:10,000) and FME would have to continuously test for that, taking up valuable resources while doing so. Similarly the CRON command doesn't have the option, and the solutions I saw online involved more of a command-line CRON process. So, I considered two viable FME processes: Have one workspace run an

4 years ago

manleypv1

asked in General

How will the change in AutoCAD licensing affect the use of FME?

Our company was told AutoCAD will go from a computer-based to user-based license structure. We're wondering how this will affect using FME.

141

4 years ago

aguanContributor

asked in General

How to use FME server app to edit XML data

I just installed FME server 2020.1 in the hope to use the Server App functionality. One example comes up quickly. I have a XML file that I want to use FME server app to edit a few elements. The flatten elements are shown in the attached image. I want to present this in the server app as some kind of table. The label column is static and each cell of the other two columns either as a free text entry or a drop down choice. The free text entry and dropdown can be published FME parameters. The initial free text entry and the drop down choice is populated from the XML file, but the users can enter or select their own choice. The have a Save button to save the results back into the XML file. Is this possible to do this in the Server App?

4 years ago

leif

asked in General

3D breaklines into contourgenerator does not work

When I try to use 3D-breaklines, the contours are created without regard to the breaklines. See my method below. It's a simple process where I create a terrain mesh and coerce the geometry type to line. Any suggestions?

4 years ago

pschoutParticipant

asked in General

Read a Point Cloud with double separator characters

I have a problem with a Pointcloud source file. It is a CSV file without headers and separator character is |, but there are also double quotes present (see yellow marked in the attached picture). When I use a pointcloud xyz reader it generate only 4 columns but I need 6 columns (with | as separator character), it seems that the quotes cause the problem to split the string between the quotes. It will work when I replace the double quotes for noting. That’s usable in a small file but most of the CSV’s contains more than 20 million records (up to 100 million records) so replacing double quotes is not so easy! Has anyone an idea to handle these csv pointcloud files? Is there a way to negate these double quotes, maybe a rewrite action will solve this problem? A subset of the point cloud is attached.

4 years ago

pschoutParticipant

asked in General

Select Linestrings from a PostGis table usingg SQL executor.

I use the SQL executor to join a lot of PostGreSQL and PostGis tabels. One of these tables contain a "geom" column with points and line objects. At the end of the SQL statement i want to select only the lines. Can anyone specify which statement to use to select only linestrings?

4 years ago

amc

asked in General

Cannot get PythonCreator script to expose attribute.

Hi there, I am running below script succesfully in the PYTHON Creator but i can't get it to expose a created value into and attrribute. the script creates a 3 digit number in ICP_GEN_ICP based on a parameter I provide for CheckICP, but it won't get exposed. i need to know how I can assign this value to an attribute and use it in an XML templater. thanks! ps i am new to coding ( both FME and Python) script: D = int('0x180f', 0)H100 = int('0x100', 0)H1000 = int('0x1000', 0)HFFFF = int('0xffff', 0) def Asc(bytes_obj): '''Get the int value of a char''' if type(bytes_obj) == bytes: return bytes_obj[0] else: return ord(bytes_obj[0]) def Mid(string, integer, integer2): '''Select a substring from a string''' integer = integer - 1 return string[integer : integer+integer2] def gen_crc(icp_number): """ Generate a checksum for an ICP""" R = int('0', 0)

I prepare WMS using FME server. When I want to open this WMS in Fme Desktop I get log: HTTP/FTP transfer error: 'Couldn't resolve host name'. What is wrong?

I prepare WMS according to https://community.safe.com/s/article/how-to-create-a-wms-service-using-fme-server I use the same data and when I run the process in FME server I get http://FOTOFME01/fmedatastreaming/AB_TEST_WMS/GetCapabilities.fmw?&token=3263a54ac33d220770be9136328640104b698f19When I want to open WMS in FME I get log like in attachment: "HTTP/FTP transfer error: 'Couldn't resolve host name'Please ensure that your network connection is properly set upNo proxy settings have been entered. " What can be wrong?

813

4 years ago

nicholasContributor

asked in General

ESRI Reprojector gives a typeid of nullptr pointer error

Reprojector: Reprojection failedAn error occurred. FME will attempt to provide more information on the error, but this may cause the translation to be terminatedAttempted a typeid of nullptr pointer! I get the above error. I don't know how to solve this

4 years ago

hlouieContributor

asked in General

AttributeValidator NOT EQUAL to "VALUE "

Is there a way within in AttributeValidator Parameters -> Validation Rule -> Rule Configuration -> NOT EQUAL a value?

How to convert gpe line data in Polyiline format

We have gps data , want to convert in to Polyiline format

4 years ago

arnaudfouch

asked in General

Specific html/XLMX extraction to attributs

Hello all, I've made an .fmw that allow me to extract a lot of information contain in an kml to store them into an excel file. It work well but I want to improve my .fmw by extracting more new information. So, in my kml I have some entity that have an HTML structure. Generaly I put an HTMLtoXHTMLConverter followed by an XMLXQueryExtractor to store info into new attribute but here I'm stuck, I don't know how to do.My request is maybe impossible to do, I want some of your advice.Here my XHTML : <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"><head> <title></title></head> <body> System: type: mysystemetype SEN: 2569852 day: 2022-09-04 fw: P6589-69-05-25 <hr /> software compu

4 years ago

nanblogfmeParticipant

asked in General

Is there a Moving Window Capability in FME?

Lets say I have locations of point/polygon features along a line and I would like to count the number of points along the line using a moving window. For instance I'd like to slide along the line using a window of 100 feet. As I move along the line, I want a count the number of points within the 100 feet window until I reach the end.Once the counts is done, I'd like to segment the line as well, based on the total counts within the 100 feet window. Any ideas and help on this will be greatly appreciated.

355

4 years ago

bwnInfluencer

asked in General

How to manually remove FME2020.0?

131

4 years ago

wisegisContributor

asked in General

What is the process to create the spatial_geometry_id and spatial_geometry_order for presenting data in Tableau?

I saw these fields in the output in the examples provided by Safe. When I looked at the example workbench files I don't see where and why those fields are created.

4 years ago

johnkContributor

asked in General

How can I isolate HTML Table values <td> based on attribute name?

This question is similar to one already asked below, but I couldn't crack the answer: https://community.safe.com/s/question/0D54Q000080hAQuSAM/css-selcetors-in-html-extractor?t=1603847778190 I would like to take the table as displayed in the xlsx example (mock up of a HTML table on a webpage), and force the values into attributes on a row per ID basis, to be able to construct an easy to use list of IDs with their associated attributes.The tables (there are many across different URLs) are structured as in the 'HTML Table code example' (one table per ID) and I am having trouble trying to isolate the values of the associated attributes (in bold in the xlsx table example). The attribute names are always the same and in the same order, but not necessarily on the same row numbers everytime. I tried isolating by using the _element_index (using HTML Extractor and ListExploder) but these are not consistent across all tables (as attrbutes such as location can have multiple values),

732

4 years ago

kattContributor

asked in General

I have a table (see Before Image) and I would like to transform it to get it like this : see After Image. That means the value of the attribute Category should become an attribute itself. How can I do this?

4 years ago

Page 132 / 162

Badge winners

kanhan1has earned the badge Teacher (Grey)
olivierlhas earned the badge Student (Grey)
kiki221has earned the badge Student (Grey)
sweco-senarihas earned the badge Welcome Back
cdalessandrohas earned the badge FME Certified Professional

Show all badges

30,019: 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.