- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Unanswered questions

20233 Posts

Recently active

Most views Most replies

hektopascal

asked in Data

Doing a JOIN in ArcSDEQuerier or ArcSDE reader

Hi all, I found this wonderful piece of informatjon in the description of ArcSDE reader (http://docs.safe.com/fme/html/FME_ReadersWriters/Default.htm#sde30/sde30.htm%3FTocPath%3DFME%20Readers%20and%20Writers%20(formats%20supported%20by%20FME%202014)%7CEsri%20ArcSDE%20Reader%2FWriter%7C_____0): The SDE reader can also perform multi-table join queries, thereby exploiting the full power of the underlying RDBMS. Cool... I wanna do that, and most likely either the ArcSDEQuerier or ArcSDE reader, whichever is most convenient. But I can't seem to wrap my head around the syntax. Composing a valid JOIN statement in SQL should be fairly straightforward, but that doesn't really seem to fit into the concept of WHERE Clause. Or I cant figure it out... Problem description: I have a huge ArcSDE database. I and I want to extract all data from table A, and a subset of information from table B, only extracting those whose ROUTE_ID values match ROUTE_ID in table A. In my head, this should

1610

4 years ago

pchengContributor

asked in Data

Sharepoint & IQY file in FME

Hey FMErs! Wondering if anyone here has worked with an Internet Query (.IQY) file downloaded from a sharepoint site before! When I open the link in a web broswer (IE11 in this case) it'll prompt a download for this IQY and it'll resolve into a excel spreadsheet! I want to run a automated process on this file from FME but when I use use a XLS reader or HTTPCaller transformer all I've been getting are error messages or the 'GET' response:(left out some details as its internal)WEB1https://xxxxxSelection={7EB5B6E8-8458-4F92-925E-A3EB593229E7}-{9814593B-164C-4604-A5DD-4CAF07C9FDF7}EditWebPage=Formatting=NonePreFormattedTextToColumns=TrueConsecutiveDelimitersAsOne=TrueSingleBlockTextImport=FalseDisableDateRecognition=FalseDisableRedirections=FalseSharePointApplication=https://xxxxx/_vti_binSharePointListView={9814593B-164C-4604-A5DD-4CAF07C9FDF7}SharePointListName={7EB5B6E8-8458-4F92-925E-A3EB593229E7}RootFolder=Thanks in advanced, Patrick

260

4 years ago

erik_janContributor

asked in Data

Issue with writing to SDE feature class and archiving enabled

Hi FME and ESRI users, In an SDE feature class archiving is turned on.When writing a record in update mode, an attribute is blanked out, all other attributes get values.But redirecting to the Data Inspector shows a value for the attribute. We checked the data type in SDE and FME and they match. Any idea what could be causing this issue? Your suggestions are highly appreciated.

110

4 years ago

gogopotter90Contributor

asked in Data

how to inspect on workbench and get attribute lists from oracle non spatial file

could i ask how to get the list of attributes from oracle non spatial.iam a little bit confused from oracle files .i added a reader for oracle non spatial but i could not check the oracle on inspector when i conenct with inspector i see nothing,is there a way to inspect it while iam working on workbench . and when if i want to extract only the attributes ,how could i do that i want to extract the attributes in table Thanks in advance

I am looking to insert a new feature into the output geodatabase here. The translations uses a feature reader to read a source geodatabase based on a user defined parameter which defines which feature classes the user wants to bring over. However I also need to add second feature class but instead of reading from a source I need to add a new record which i intialize from the creator. In this case though because the output writer uses a dynamic schema, I don't know how to insert this new feature or to indicate which feature class it should be written to. Any ideas?

161

4 years ago

koenvdwContributor

asked in Transformers

How can you clip based on the objects of a shapefile

I have a shapefile with an attribute ID that contains 23 objects (polygons).I want to use this shapefile to clip the las files and combine them based on the objects.So I want 23 point clouds. I have an idea on how it works, but want to be sure as this is going to run for a long time. My bench looks like this:In clipper I would turn on group by "ID" and merge the attribute just to name the Las file by the value in ID. In pointcloudcombiner I would turn on group by "ID" will this give me the result I want?

665

4 years ago

davygoethals

asked in Transformers

How to read Extended Data / Properties sets (Civil 3D) for use in GIS

Hi,I'm new to the FME family and have this question. I have a Civil 3D dwg that we want to transfer to a geodatabase. Transforing the geometry is no problem, but the dwg has extended entity data that I want as attribute fields in the geodatabase.But, at this time, I can't even find my extended data when inserting the dwg as a reader. I searched this community but so far no luck. I tried the 'AttributeExposer' or ListExploder' transformers, but still didn't get result.Can someone tell me how to set the parameters so I can read the extended data and will be able to transfer them as attributes in a geodatabase?Thanks,Davy

How do I download zip files with different number in filename every week from HTTPS site with authentication?

Hi,I'm trying to setup a script to download a set of zip files from a website that requires logging of username/password. After logging in, I need to select from 3 different zip files from the list. From what I've read so far, it looks HTTPCaller transformer with GET method is what I should use. The 3 zip files that I need to download each week is changing every week with a new # in a filename. How do I use HTTPCaller to select the zip files each week regardless of what number is in the filename?

The error number from ArcObjects is: '-2147215875'

I am trying to write data from GDB file into oracle database using SDE writer. Its giving below error Could not unregister GlobalID column 'GLOBALID' in table TABLE_NAME. The error number from ArcObjects is: '-2147215875'. The error message from ArcObjects is: {Table is already locked [TABLE_NAME]}

Publishing Rasters on ArcGIS online

Hi, the result of my workflow is a raster and I would like to publish it on ArcGIS online automatically with FME. Is it possible? Thanks

Make non spatial data spatial

HelloI am attempting to make non spatial Oracle table data spatial, I have created the FME workbench no problem but when it comes to writing the results to an Oracle table using Oracle Spatial table no points are displayed just the data.Basically I am missing the accompanying spatial data to the points. I am sorry if my post makes no sense and please ask any further questions. Many thanksSy

245

4 years ago

rafeashour

asked in Transformers

FuzzyParallelLines

Hi All, I'm trying to select parallel lines from a shapefile using FuzzyParallelLineFinder. The output gives line_ID of the fuzzy parallel line for each feature with a given STDV value. What I need is how to select the features that are expected to be parallel from this output.Any ideas?

Hallo guys!I want to transform/convert an OSM file to an OpenDRIVE file. So my question is if anyone have some informations for me how that's possible and which steps are needed for. I also tried it with "GIP" data. My main problem is i have no idea how to add attributes or to get an OSM data into a structured OpenDRIVE file. Thats my first time with FME so i have no Idea how that should work.

1532

4 years ago

muhammad_yasir

asked in Transformers

Generating date and time columns

Hi there,I want to create two columns: One column generates the dates between two given dates and second column contains the half an hourly time stamp of each date. For example:Column AColumn B1/1/202000:001/1/202000:301/1/202001:001/1/202001:301/1/202002:00............................................1/1/202023:302/1/202000:00 So that means each date of column A would have 48 values (half an hour slot) of column B. Could you some one tell me how to do that in FME?

761

4 years ago

nepalikiwiContributor

asked in Transformers

JSONFragmenter between 2017 (17259) Vs 2019.2 (19817)

Just wanted to know on JSONFragmenter between 2017 (17259) Vs 2019.2 (19817): What i have noticed is, JSON fragmenter never returned anything when the fragmented value was 'null' in 2017, while i have just noticed that for the same JSON text input, JSON fragmenter on 2019.2 is sending the attribute with 'null' value that we wanted to fragment through 'Rejected Port', is this intended on 2019.2? Any answer would be appreciative as we have lots of workbenches that we need to go through and fix it if that's the case?

4 years ago

ann

asked in Transformers

Problems with SQL Statement and Access

I have a lot of shapefiles that I want to clip with different areas which I read from MSAcces and I want to select the area that I need for the certain shapfile and clip the shape-file. I use SQL Executor connected to a MS Access database to select the area that I want to use but I don't get the area. Do anyone have any solution?

4 years ago

mark2atsafeSafer

asked in General

FME Weekly Quiz Results: John Lees (February 2020-3)

Well FME'ers,This week the quiz involved taking on our IT manager, John Lees. John isn't an FME user (at most he would have dabbled in it) so this should have been easy... right?!Let's see the correct answers and how well John did...Answers1) Which one of these is NOT a piece of FME documentation listed on our docs page?FME Readers and Writers ManualFME Server REST API DocumentationFME Cloud DocumentationFME Terminology and Localization GuideFME Factory and Function DocumentationThis is usually the easy question and this one should have been only a small obstacle. But it makes me glad to see that you do know our available documentation and where to find it.The Terminology and Localization Guide isn't a real thing... in fact they are two real things I joined together for quiz purposes, neither of them listed on that page.The terminology guide exists here on our web site, while I understand that a localization kit is given to users or partners who wish to translate the FM

Hello, I'm trying to connect to the cloud with a HTTPCALLER. I received an URL, Username and password to connect to ODATA/MSPROJECTS (Office365). When I run the workspace I get the message: HTTPCaller(HTTPFactory): Received HTTP response header: 'HTTP/1.1 403 Forbidden' from 'https://XXX.sharepoint.com/sites/pwa/_api/Projectdata' How can I connect? do I need additional software? do I need to use an other transformer (ODATA?) Please help, thanks

255

4 years ago

sbp

asked in Transformers

Missing data in translation from json to access.mdb

4 years ago

kathir

asked in Transformers

how to extract coordinate from the geo tagged photos

2799

4 years ago

asellarsParticipant

asked in Data

Extracting Nested JSON

Hi All, I am having quite the time getting some nested JSON out of an attribute. My current workflow flattens out the original JSON, then fragments out the nested meetings. I then flatten it out again to expose each attribute for each meeting. I get to a point where I now have an attribute "agendaitems" that can have different amounts of items for each meeting. This is where I am having trouble flattening it out from here. The attribute is filled as <missing> but when inspected has the items listed in the attributes as: agendaitems{0}.billagendaitems{0}.descriptionagendaitems{0}.item and so on for however many items are associated to it. Is there anyway to get these to all flatten out?

What does error "Failed reading coordinate data at offset 0" mean?

Using reader MITAB on a file written in 2006 and getting the error "Failed reading coordinate data at offset 0".Sometimes, the error doesn't stop further actions, sometimes it does.Can anyone point out the likely issue?Cheers!

Automations with Data Download Service

Hi, I have another FME Server query!I have successfully uploaded an FME workbench to FME Server 2019.1 with a Data Download Service. When I run the workspace in FME Server the Data Download Service works fine.I would also like the Data Download Service to work with a scheduled job which I have set up using Automations. However whenever this scheduled job runs, the Data Download Service does not work and the files are output to the shared directory rather than a zip file to download. Is it actually possible for the Data Download Service to work in a scheduled Automation? I thought maybe I could add the hyperlink to the zip file to an email, but I can't work out how to do that.Thanks

Error when using FME to create a table into Oracle when the user is not the owner.

Hi all I have a workspace that is managing a dynamic migration from one Oracle 11g database to Oracle 12c. The process is quite mature and has mainly be used to truncate and insert new data. We now have to extend this process to create tables if required. The writer connection is a different user (USER1) to then one where the table is being created into (USER2). USER1 has heightened privileges and is used for all maintenance tasks. Grants include 'create any table', among others. We have started to encountered exceptions when attempting to drop/create a table into the destination instance. Using Feature Writer or a writer/Feature Type, when we try to 'drop/create' or 'Create if needed', we get the following exception raised: "Cannot create table 'TABLE_FROM_FW' within schema 'USER2', when logged in user is 'USER1' ".Full log with debug here: I have tested with Oracle Spatial Object and Oracle Non-Spatial writers both withe sam

475

4 years ago

tbs_gis_teamContributor

asked in Authoring

FME Server 2019 User Parameters

We recently upgraded to FME Server 2019.1.1 and have run into user parameter issues. We built an extractor tool in our ArcMap Portal GIS that enables users to extract GIS data into styled dwg or shapefile format to create maps. We have user parameters linked to FME process for layer names, projection and user input selection via draw tools in the tool. After the upgrade from 2018 to 2019.1.1 we have noticed the process will give an error if too many layers are selected and also if you use the draw tool and create polygons with too many vertices. I am wondering if there is a limit setting for the user parameter values or other setting causing the issue. I did test running the process on the server interface with the string used for the selection box and it works. Below is example of the failed string running from Portal, but passes if I paste value in the box selection user parameter on the server interface. <lt>?xml<space>version=<quote>1.0<quote><space>e

132

4 years ago

Page 392 / 810

Badge winners

jeovishas earned the badge Welcome Back
bill_sullivanhas earned the badge Welcome Back
marcusthas earned the badge Socializer (Storyteller)
canerakinhas earned the badge Welcome Back
mmestrovhas earned the badge Welcome Back

Show all badges

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

A product of

Company Products Giving Back Careers Contact Privacy Feedback

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