Welcome

A space for news, notes and introductions

21 Posts

smartman63
Contributor
smartman63Contributor
asked in Community Q+A

Show all tables with contents in a db

Hi all,I am trying to show all tables with contents in a database. I have a database with over 800 tables. Some tables are empty, some are not.  Im using this query in a sql client:SELECT SCHEMA_NAME(t.[schema_id]) AS [table_schema]          ,OBJECT_NAME(p.[object_id]) AS [table_name]          ,SUM(p.[rows]) AS [row_count]    FROM [sys].[partitions] p    INNER JOIN [sys].[tables] t ON p.[object_id] = t.[object_id]    WHERE p.[index_id] < 2    GROUP BY p.[object_id]        ,t.[schema_id]    ORDER BY row_count desc  If i am using a Sql Executor with this sql statement i have a return value of more than 300 tables wich is correct. In the preview of the feature window i see more than 300 lines. But i dont see any attributes like a table name or the number of records. Do you know how i can expose these attributes?

3
smartman63
Contributor
4 hours ago
p-chessel-vdg
Contributor
p-chessel-vdgContributor
asked in Community Q+A

AreaOnAreaOverlayer transformer : tolérance = “None” parameter

Hello,In FME 2023 , in the AreaOnAreaOverlayer transformer the tolérance = “None” parameter has been removed. There only option of “Automatic” or “Custom value”.Question : if there was Tolerance = “none” in pre FME 2023 .fmw scripts, should we use Custom Value = 0 to have the same result as tolérance = none  or “Automatic”?Thanks

2
p-chessel-vdg
Contributor
1 day ago
joshua_jacobs
Participant
joshua_jacobsParticipant
posted in Community Q+A

I can't seem to send or reply an email to train@safe.com

There was a broken link in the courses, so I attempted to send a feedback through the “FME Academy Feedback” page. But after completing the survey form and pressing the submit button, I was redirected to a “page not found” window so I thought the submission didn’t go through.I then tried reaching out by sending an email to train@safe.com, but my email bounced back. I gave up at this point.After some hours, someone using the train@safe.com email actually sent me an email regarding my feedback. He also asked me if I submitted several ones because the system received multiple copies of the same feedback. I tried to reply, but was still unable to because my reply bounced back again.Anyone have the same experience?I’m posting this here because this is the only place I can think of now!

0
joshua_jacobs
Participant
1 day ago
galigis
Enthusiast
galigisEnthusiast
asked in Community Q+A

All questions go now to moderators to approve?

Hi All,I have just posted a technical question and the FME platform showed a text box saying that my question has gone to the moderator to approve?Has this new workaround been recently implemented? or maybe the hyperlinks included in the post need to be checked? Just wanted to confirm :) 

7
liamfez
Supporter
7 days ago
fbastian73
Contributor
fbastian73Contributor
asked in Community Q+A

finding articles that I liked

Hi,this is more of a general question related to the FME community/forum site.How do I find articles that I clicked “like” on?thank you.

3
fbastian73
Contributor
15 days ago
egge
Contributor
eggeContributor
posted in Community Q+A

fmwt file type not supported in FME Community?

Hi,Today I noticed that attachments of 2 of my posts had disappeared with the transfer to the new community environment. When I tried to add these attachments, both *.fmwt files, again, I got the message that the fmwt file type is not supported as an upload… see screenshot below.Huh…?How is that?Cheers,Egge-Jan

1
nielsgerrits
Celebrity
24 days ago
mark2atsafe
Safer
mark2atsafeSafer
posted in Introductions

Welcome, from Mark Ireland (aka FME Evangelist)

Hello everyone,Please feel free to use this space to introduce yourself to the FME Community. I’ll go first.My name is Mark, but I’m also known as the FME Evangelist, or sometimes mark2atsafe. I help to manage the community, engage with users, and spread as much FME knowledge as I can.Feel free to DM me about any issues or thoughts about the community platform. Although I’ve used FME for 20+ years, your FME questions are best directed to the relevant forum, to get more eyes on them.My expertise is in FME Form and the design of FME workflows. My favourite data format is GeoJSON. My favourite transformer is the ShortestPathFinder. Before working at Safe I was a land surveyor, project manager, GIS developer, photogrammetrist, and dog food tester.  

1
danilo_fme
Evangelist
1 month ago
salvaleonrp
Contributor
salvaleonrpContributor
asked in Community Q+A

Sort button for Community search results

Title should be changed to: Consistent Community Search page results. When you open the Community Q+A, the posts seem to be chronoligaclly ordered.  When I do a search, I don’t see a pattern on the results - perhaps Relevance. Could we have a Sort by Post Date or by Relevance (Asc/Desc) buttons on the Community Search results please. Weird, this search page results has the sort options.https://community.safe.com/p/search#q=python This page does not: https://community.safe.com/search?q=python 

2
salvaleonrp
Contributor
1 month ago
mark2atsafe
Safer
mark2atsafeSafer
posted in Announcements

New Community Updates

Dear FME friends,I’m delighted to announce a few new updates to the FME Community platform.Updates to status.safe.com will now appear in a pop-up window on the community, to give you advance notice of maintenance or alert you to problems on other parts of the Safe infrastructure. The Network News section has been renamed to Community Alerts and moved out of the Welcome section to emphasize it is more technical info than general news. It’s also been split into three different subcategories (Hub, StackExchange, Blog) so you can subscribe to each one separately Speaking of which, yes, blog posts should now trigger alert posts on this site. The Welcome category now has a specific place to ask questions about the community platform. The Events page has received an overhaul that includes the ability to filter by event type. Past events have also been moved to a separate tab. As we add more and more events to this page, this filter tool will be really useful. There is a new page that lists

1
danilo_fme
Evangelist
1 month ago
sulimandarweesh
Contributor
sulimandarweeshContributor
asked in Community Q+A

FME Form sample data

Hello there, I am quite new to FME and started from scratch, I started with the first instruction course, However, I’m wondering from where I can get sample data.I’m now watching this training “FME Accelerator” but can’t find any data to apply it from my end.Thanks,

7
salvaleonrp
Contributor
1 month ago
chrisgoodman
Contributor
chrisgoodmanContributor
asked in Community Q+A

Why do the knowledge links fail?

Why do all the links in your community portal always go back to the login page. https://knowledge.safe.com/articles/543/floating-license-troubleshooting.html\goes to https://community.safe.com/Nothing against the community, but that’s not what I was looking forIt makes your portal less useful. 

3
chrisgoodman
Contributor
1 month ago
liamfez
Supporter
liamfezSupporter
posted in Community Q+A

Dark Mode for Community

I would be interested in a dark/night mode for the community. This may be something that is already on the roadmap for future development. Perhaps another community poll could help determine how many others would also like a dark mode in the future?

1
mark2atsafe
Safer
1 month ago
milo89
Enthusiast
milo89Enthusiast
asked in Community Q+A

Work Extension License: Has anyone received one?

Hi everyone, I know there are many users who are saddened by the removal of the Home Use licensing. To try and bridge some gaps, I’ve applied for a work extension license but haven’t received anything back.The request form mentions 10 days but it’s been well over that.So I’m wondering whether anyone has received a license via this method and how long did it take? Thanks.

3
milo89
Enthusiast
1 month ago
stalknecht
Contributor
stalknechtContributor
asked in Community Q+A

How can I edit my own forum post?

How can I edit my own forum post? I don’t have an edit button visible somewhere!This one has an edit button but the older ones NOT! I want to edit a post from 5 days ago.

1
mark2atsafe
Safer
1 month ago
andrew741
Participant
andrew741Participant
asked in Community Q+A

Certification

Hi! Does anybody know if could I get any type of certification or confirmation with my name after completing a free FME training? 

1
redgeographics
Influencer
1 month ago
galigis
Enthusiast
galigisEnthusiast
posted in Community Q+A

Edit existing FME Community questions

Hi All,With the new FME Community platform, I’m not finding the EDIT button to make changes in my existing questions,Does anyone know how to edit the questions now? 

3
nielsgerrits
Celebrity
1 month ago
mark2atsafe
Safer
mark2atsafeSafer
posted in Announcements

Welcome to the new FME Community

Dear FME Community Members,I'm thrilled to welcome you to our newly launched FME Community platform!This new platform is completely redesigned, with new and updated functionality, more options for connecting with fellow FME users than ever before, and a whole new range of gamification badges and rewards. It’s faster, sleeker, and lets us customize it in ways to help you get the information you need, when you need it.  As I always say - in a completely non-rehearsed and natural way - the FME Community is your one-stop destination for all things FME. Here, you can connect with peers, share ideas, and get answers to your pressing questions, as well as register for upcoming events and learn about the latest and greatest FME product updates.I encourage you to explore our forums, contribute to discussions, and share your insights. Your active participation not only enriches the community but also helps you to climb our reputation leaderboard, where we recognize and reward our most engaged an

29
nielsgerrits
Celebrity
2 months ago
mark2atsafe
Safer
mark2atsafeSafer
posted in Announcements

What's Up Wednesday: 21st February, 2024: Community Updates, FME+Python, Events, Training

FME friends, the latest What’s Up Wednesday post can now be found online, here on LinkedIn. 

1
danilo_fme
Evangelist
2 months ago
sigher
Contributor
sigherContributor
asked in Community Q+A

Block fmelizard

Is it possible to mute @fmelizard  ? He/she/it is harassing me by sending private mail all the time so I need to log in and check the message.

1
oscard
Supporter
2 months ago
vxn43
Supporter
vxn43Supporter
asked in Community Q+A

Where has the FME Customer Support Page gone?

Submit Case  My Cases I can access it here: Technical Support | FME Support Center (safe.com) But are there plans to include it in the new FME Community Page? (as a link in the banner at the top of the page)

2
danilo_fme
Evangelist
2 months ago
takashi
Contributor
takashiContributor
asked in Community Q+A

Where has the Documentation site gone?

The new Community site looks good, but I cannot find the Documentation site.Can you inform me the URL?

2
takashi
Contributor
2 months ago

Badge winners

Show all badges
28,743
Posts
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.