Community Q+A

A space for asking questions about the community, how it works, and where to find content.

  • 17 Posts
  • 42 Replies

17 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
7 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
25 days 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
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
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.