Skip to main content
  • EN

General

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

  • 4,033 Posts
  • 13,782 Replies
4033 Posts
warrendev
Enthusiast
warrendevEnthusiast
asked in General
HTTPCaller Timing Out

I am making a call to a SOAP web service to retrieve a token and FME Desktop will timeout, but I am able to successfully retrieve the token in Postman and in Python using the requests module. Any idea as to what would be causing the issue?2020.2.0.0 (20201027 - Build 20787 - WIN64) FME Error: HTTPCaller (HTTPFactory): HTTP/FTP transfer error: 'Timeout was reached'HTTPCaller (HTTPFactory): Please ensure that your network connection is properly set upHTTPCaller (HTTPFactory): No proxy settings have been entered.  If you require a proxy to access external URLs, please ensure the appropriate information has been enteredHere is the code in python that runs successfully:import requestsurl="https://ext.youraspire.com/AIS/WorkTickets.svc" headers = {'content-type': 'text/xml;charset=UTF-8', 'SOAPAction': 'http://ext.youraspire.com/AIS/WorkTickets/GetToken', 'Host': 'ext.youraspire.com', 'Content-Length': '404'}body = """    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/en

1973
nielsgerrits
VIP
3 years ago
C
clowncutie
asked in General
Add watermark to PDF

Hi, I made a super simple 3 pages "Lorem ipsum" file with docx and saved as pdf, I'm new to PDF in FME and wanted to test just to add a simple rotated text using point creator, text adder, pdf formatter, but how about the next step?? How do I write the result to a pdf? Tried connecting my reader and my created text to a new pdf but the content is white except for my creted text, but I want to keep the existing text and just add for example a transparent text and an image, but its it more complicated than I thought. Do I need spatial reader or non spatial? Im only interested in adding extra stuff to every page to an existing pdf with the PDFStyler, then writing it as an addition to an existing PDF. Most happy answer would be a template workspace with:-PDF READER-PDF WRITER-PDFStyler that you can connect to the writer or multiple even to add to existing pdf (since I could not even make a simple read write pdf copy in FME)   pdf:text: (no idea where the yellow stuff is or ca

291
debbiatsafe
Safer
3 years ago
M
morijlumos
asked in General
CSV with Geometry from Oracle to Geodatabase.

I have a CSV export from ORACLE with geometry in a format like POINT (-81.00893 33.9717480555556), POLYGON ((-84.1769359565167 34.0427328929524, -84.1767072908479 34.0427328929618, -84.1767072908479 34.0430401524308, -84.1769359565167 34.0430401524308) etc. I cannot figure out how to extract the geometry and create layers in a geodatabase. I tried a few ideas with GeometryExtractor, GeometryReplacer, etc but I haven't had any luck. I attached the CSV for reference.

143
M
3 years ago
J
jimq66
asked in General
How can I get a count of points that are on a line?

I have GIS point features that are on or along GIS line features. I need to get a count of how many point features are on any given line feature and attach that count as an attribute to the line. I also have separate inspection data as an access database that captures the equivalent of the point feature as a code. I need to get a count of the point codes associated with the given inspection to compare to the count of the GIS points and in turn determine if the inspection data needs to be reviewed.

811
david_r
Influencer
3 years ago
T
trialing
asked in General
How to optimise PostGIS DB Reader performance, currently I run out of memory.

Another learning FME question: I have a postGIS table with 1.6million records. I have 264 features from a lot of post process from another dataset. Each 264 features have been split to 4 extent coordinates. I need to understand the nearest neighbouring shape from the 1.6 million record PostGIS database (single table) for each 4 coordinates.  This means that FME Desktop attempts to cache the 1.6 million PostGIS records so it can then complete the nearest neighbour checks. I get 25% of the way through before I run out of memory and to be perfectly honest, I am slightly impressed my dinky laptop got this far. How would I go about changing this flow to increase performance?  Many thanks 

40
T
3 years ago
M
manumanul
asked in General
Aggregate table: Only keeping maximum values

I have a point feature containing different entries per point (multiple measurements on different heights), and i want to aggregate my attribute table in a way that only one entry per X,Y-point exist. The final entry should thereby only contain the maximum values of all measurements per points. I tried using the Aggregator tool, however, I was unable to keep the maximum values, since the only implemented functions seem to be average and sum. I think of using my own python script withih a PythonCaller, but it did not work either (I know it must work , but I am pretty new to both FME and Python and just did not succeed). Any help much appreciated!

987
ebygomm
Contributor
3 years ago
LizAtSafe
Safer
LizAtSafeSafer
asked in General
What's Up Wednesday: FME News for the Week Ending 11-December-2020

Welcome to What’s Up Wednesday and the 4th Challenge of our Twelve Days of FME 2020 Contest.  Twelve Days of FME 2020Have you been working through the challenges? Some of them are pretty tough. Today we are on the 4th challenge, you have until tomorrow night to get your art submissions in.  Do you have no idea what I am talking about? Now until January 8th, we are having an FME contest that gives you twelve chances to win a prize! Throughout the month of December, various challenges and puzzles of varying difficulty will be released to the community. Complete the challenge or puzzle within the limited time frame to be entered to win. See the Contest Terms and Conditions for the full schedule or the launch page for links to all the challenges.  FME Hub In November we had lots of great submissions to the FME Hub, some of the highlights include:Augmented Reality Portable Hole Examples: This is a template for created AR files that show underneath surfaces. ColorPercentile: A custom transfo

40
LizAtSafe
Safer
3 years ago
aguan
Contributor
aguanContributor
asked in General
Can FME read AWS S3 file version ID?

I used S3Connector to upload a file to a S3 bucket which has versioning enabled. I uploaded three files to the same bucket, and I can see the three version IDs in the AWS console. Can I retrieve the version ID of the latest upload? Can I download the file of a specific version?

143
aguan
Contributor
3 years ago
N
nelson
asked in General
Hello, it is possible to disable a public parameter linked to a disabled reader or transformer when we start running a workspace ? Thanks for answering this very beginner question :)

Hello, it is possible to disable a public parameter linked to a disabled reader or transformer when we start running a workspace ? Thanks for answering this very beginner question :)

53
david_r
Influencer
3 years ago
K
kd
asked in General
Configure FME options upon installation

Hello everyone, I made my database connections public for all users in my organisation using the guidelines described in this post. Although I succeeded in making the connections public, every user still individually needs to adjust his or her Connection storage parameters in the FME Options. Just like any other change to the default options. I was wondering if there is a way to already configure all FME options upon installation of the software , some sort of 'my company's FME configuration' file which overwrites the default settings. So the user does not need to configure anything themselves. All information is greatly appreciated,  

304
K
3 years ago
nicholas
Contributor
nicholasContributor
asked in General
What is the difference between SHAPEFILE and ESRISHAPE?

What is the difference between Esri Shapefile short name SHAPEFILE andEsri Shapefile (Replace by SHAPEFILE) short name ESRISHAPE?

185
ebygomm
Contributor
3 years ago
alc33
Contributor
alc33Contributor
asked in General
from 1 excel template to multiple sheets

Hi!I would like to duplicate my template (excel) to create multiple sheets based on an attribute on my datas. For example, when my attribute = sheetA, all the datas concerned go to named ranges on the sheetA. At the end I have one file with multiple sheets. But I saw this sentence :https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/xlsx/XLSX_writer.htm"Named ranges that exist on the template sheet are not duplicated." So I thought to use feature writer to write each sheet independantly with the same name sheet and then use feature reader + writer to group all the files in one and rename the sheet with the good value.This solution is a problem for me because I would like to delete the intermediates files automatically but FME can't do that. I'm not used to write on excel so it became a little complicated for me. Can you help me? Thanks! 

291
milo89
Enthusiast
3 years ago
cdalessandro
cdalessandro
asked in General
Clipping lines on DEM

I would like to use DEM to clip lines. Despice it seems simple, I still haven't gotten it. Any suggestions? Please see attached fmw and readers zip file.

72
cdalessandro
3 years ago
D
dennis
asked in General
my data citygml data is stored in a database. what transformers do I need to be able to call the data from the database into the workbench and convert to 3d tiles?

my data citygml data is stored in a database. what transformers do I need to be able to call the data from the database into the workbench and convert to 3d tiles?

12
D
3 years ago
E
eriblan
asked in General
Problem setting upp scheduled task with SQL server connection using service account.

Hi! I´m having problems getting a scheduled task to run with a service account. I get the following error: 2020-12-04 10:33:51|  0.7| 0.0|INFORM|Microsoft SQL Server Spatial Reader: Opening `omnia_' for read operation 2020-12-04 10:33:51|  0.7| 0.0|INFORM|Microsoft SQL Server Spatial Reader: Trying to connect using Microsoft OLE DB Driver for SQL Server... 2020-12-04 10:33:52|  1.0| 0.3|WARN |Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2146824582) Det gick inte att hitta den angivna providern. Den kanske inte Ã¤r ordentligt installerad.'. Connection string 'Provider=MSOLEDBSQL;DataTypeCompatibility=80;Data Source=;Initial Catalog=omnia_;User ID=;Password=********' 2020-12-04 10:33:52|  1.0| 0.0|INFORM|Microsoft SQL Server Spatial Reader: Trying to connect using SQL Server 2012 Native Client... 2020-12-04 10:33:52|  1.0| 0.0|WARN |Microsoft SQL Server Spatial Reader: Failed to connect using SQL Server 2012 Native

992
milo89
Enthusiast
3 years ago
A
andreweastop
asked in General
Good morning, I have recently started working with FME with no previous experience with the software and was wondering would anyone be able to me how I fix this problem please and what does it actually mean? Many thanks Andrew

FeatureJoiner_2_<Rejected> (TeeFactory): FeatureJoiner_2_<Rejected>: Termination Message: 'FeatureJoiner_2 output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature

344
A
3 years ago
nicholas
Contributor
nicholasContributor
asked in General
What version of FME Desktop has the 12d (12dxml) Writer?

I have FME DesktopFME(R) 2019.2.3.2 (20200320 - Build 19825 - WIN64)and when I look for 12 amongst the Writers it is not there.What version of FME introduced the 12D writer?https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/12dxml/12dxml.htm

41
danilo_fme
Evangelist
3 years ago
A
andre
asked in General
Read CSV as a _list

Hi Community,Is it possible to read a csv file as a _list already from CSV Reader or is there another list (element) reader that can be used? Reason is that i have a very large CSV file containing 24 million rows, and i'm generating a list after it's been read in through the CSV reader.  Would be great if it were possible to read a txt/csv file as a list from start to avoid the additional time spent on generating the list. Cheersandre

352
A
3 years ago
D
davebarter
asked in General
FME Desktop not opening after upgrade to Big Sur

I have upgraded my Mac to the latest OS (Big Sur 11.0.1) and at the same time moved to a SSD system disk. As a result FME Workbench will not run at all. I am running version 2020.2 but older versions will not load either. I've tried reinstalling FME but the same problem occurs. I do not see any error message displayed. Is FME compatible with Big Sur?

95
andreaatsafe
Safer
3 years ago
edgarrunnman
edgarrunnman
asked in General
Is there a way to access on FME-server stored DB connections through FME workbench?

It would be awsom if there would be a sync function to uppdate Database connections and get DB connections stored on FME server to lokal env. 

113
david_r
Influencer
3 years ago
C
christian-n
asked in General
Workspace process works, batch deployed process does not

Hello, I have a problem with my workspace.The Process does work inside the fme - the batch deployed version does not. The problem seems to have something to do with the FeatureMerger. There was a similar question in 2016 (7https://community.safe.com/s/question/0D54Q000080hgb1SAA/problems-with-batch-deploy) but that does not fit do me. the error message in the console is as follows: An error occurred during the batch file execution, 1 translation failed. The following error message was raised:#1 : The clause 'FACTORY_NAME FeatureMerger_3 FLUSH_WHEN_GROUPS_CHANGE No' within 'FACTORY_DEF {*} ReferenceFactory FACTORY_NAME FeatureMerger_3 FLUSH_WHEN_GROUPS_CHANGE No INPUT REFERENCER FEATURE_TYPE AttributeCreator_4_OUTPUT INPUT REFERENCEE FEATURE_TYPE AttributeCreator_3_OUTPUT REFERENCE_INFO GEOM_AND_ATTR_BUILD_AGGREGATES REFERENCE_TABLE @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>Nummer<closeparen>,FeatureMerger_3) @EvaluateExpression(FDIV,STRIN

212
C
3 years ago
bwn
Influencer
bwnInfluencer
asked in General
How to convert Arithmetic Angles to Geographic Angles

Not a question, but a Tip. Sometimes there is a need to convert angles measured in Arithmetic convention (counter-clockwise from the X-Axis) to Geographic convention (clockwise from North/Y-Axis).   For example, Transformers like TopologyBuilder output Edge angles in Arithmetic degree angles whereas Desktop GIS systems like ArcGIS can sometimes default to Geographic degree angles. Instead of using complicated Conditional Value formulae to translate angles quadrant by quadrant with different formulae, searching the internet came up with a genius single formulae that converts angles back and forth, no matter what quadrant the calculated angle is in.Geographic Angle = (450 - Arithmetic Angle) mod 360 Rewriting the formula into FME Maths function format it becomes thisGeographic Angle = @fmod((450 - @Value(Arithmetic Angle)),360)It also works in reverse:Arithmetic Angle = @fmod((450 - @Value(Geographic Angle)),360)

2303
caracadrian
Contributor
3 years ago
F
fmesafejde
asked in General
Join multiple tables from different database servers & import into destination table with logs

(1) Created a SQL view that inner join multiple tables from two different database servers with where conditions. Which Transformer will be the simplest to mimic the SQL inner join? There are SQL Executor, FeatureJoiner, FeatureMerger etc. Not sure which one to use.(2) Once I import those data into the destination SQL table, how can I also apply logic to also update another log table with each line item details (Trx ID, Name, Amount etc.)(3) The import should also validate against the Trx ID in log table (from 2) to make sure there's no duplication trying to import again. Still new to FME. Really appreciate for your advice.ThanksR

1082
M
3 years ago
R
robbie_botha
asked in General
Identifying regressed features

Hi There, I'm having some trouble of figuring out an approach to detect features that have "regressed".My data looks something like this:<Fruit> <Batch>Orange, 1Apple, 1Pear, 1Orange, 2Apple, 2Pear, 2Orange, 3Pear, 3 So look at this as Batch 1 had all three fruit, batch 2 had all three fruit, but in batch 3, Apple is missing.What I am interested in is knowing when a fruit went missing, specifically in a sequential view. Meaning, I don't really care about the relationship between batch 1 and 3, but I want to know that between batch 2 and 3, Apple went missing. So even if I have 10 batches, I only really care if I have "pineapple" in batch 8, but missing in 9. I hope my obscure example makes sense and please let me know in case any additional information is needed. Thanks a lot! 

55
R
3 years ago
B
bigapplerizzi19
asked in General
How to add "genericAttributeSet" tag in CityGML data

I would like to generat "genericAttributeSet" tag in CityGML data like as follows:   <gen:genericAttributeSet name="xxxxxxxxxxxxx">     <gen:stringAttribute name="xx">      <gen:value>yyy</gen:value>     </gen:stringAttribute>     <gen:stringAttribute name="aaaaaaa">      <gen:value>12345</gen:value>     </gen:stringAttribute>     <gen:measureAttribute name="zzzzz">      <gen:value uom="m">67.54</gen:value>     </gen:measureAttribute> </gen:genericAttributeSet>Could you tell me how to manage attributs for this?

491
D
3 years ago

Badge winners

Show all badges
30,017
Posts
Terms & ConditionsCookie settings