Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 6,701 Posts
  • 24,703 Replies
6701 Posts
J
jaygis
asked in Data
Generate shapefile with no data

Hi There, I am working on an issue where our FME workspace, reads data from a database and generates a shapefile. The issue that I am having is that if there are no new records, the shapefile doesn’t get generated but it keeps the last run that had any data. This is creating problem with next step of the process. I am trying to figure out a way so that FME generates a shapefile even if there is no new data (empty shapefile). Appreciate any help. Thanks Jay

4
davideagle
Contributor
6 years ago
C
cohlson
asked in Data
Feature merge, Excel writer/sort issue

Have used a feature merger to merge several excel lists together and want to output them to a single excel worksheet. I've got it working fine except when I run a sorter before the writer, and sort numerically off of one of my numeric fields, the writer will add and additional page to the excel file and put information from one list on the actual intended sheet and information from the other on the additional sheet (if I use an inspector and view the list in Data Inspector it's perfect). If I sort on the exact same field, but do it alphabetically, it puts everything on the single sheet I specify (but of course is not sorted the way I'd like). Any ideas?

10
takashi
Contributor
6 years ago
P
philippe33
asked in Data
How to obtain a qgis drawing of a complex geometry ?

Hi,I have a file written with some gml description of geometries. One of these description contains <gml: arcbycenterpoint > definition. I tried to import this file in QGIS 3 directly. But it doesn't work. It seems that the <gml : arcbycenterpoint > is not supported but i'm not sure with this point.I would like to know how to draw my geometries in QGIS 3.Should i have to translate my file in an other format ?It's an AIXM 5 format.Thanks

1
soeren
Contributor
6 years ago
J
johnwk
asked in Data
Preventing writer from executing if features in another workstream exist.

Hi,I have two workstreams in my workspace:Check data integrity, culminating in any errors appearing out of the NotMatched port of a Matcher.Writes the data out.The two workstreams are separate from eachother.Is there a way to prevent the writer from executing if features appear in the NotMatched port of the other workstream?At present, I disable the writer and run the workspace repeatedly (correcting errors in the NotMatched port) until the data is ready to be written. Not very efficient... Would appreciate any help!

4
J
6 years ago
liujisheng
liujisheng
asked in Data
There is messy code when I open a shapefile created by arcgisdesktop

There is messy code when I open a shapefile created by arcgisdesktop, but it shows well in arcgisdesktop. I don't know why. I hope someone can help me to solves this problem , thanks a lot.Here is the testfile. 

7
takashi
Contributor
6 years ago
jhawks
Contributor
jhawksContributor
asked in Data
kmlpropertysetter: I want to add hyperlinks to my kml popup up balloon.

I only need certain records to have hyperlinks. See attached image, (created with arc2earth). I'm trying to create the same popup with a workbench, see attached.noaa-rncs-shape-kml.fmw

2
jhawks
Contributor
6 years ago
tmoreland
Participant
tmorelandParticipant
asked in Data
Anyone connecting to Oracle Cloud for EiS, HCM and Financial Management solutions.

I'm trying to connect to Oracle cloud for the human resources and financial management services. So far, I am not having any luck. Has anyone been able to set up these connections? If we could connect to the existing EiS reports that would be a fine work around but as far as I can tell we can not have the EiS reports automatically load into a FTP site where we could grab them. We are currently using FME 2017 but are fine upgrading if a new version is needed. Any advice or help wold be greatly appreciated.

5
M
6 years ago
Z
zhengsy
asked in Data
convert IFC to OBJ

hello, I need to convert IFC to OBJ, but I had some trouble when converting. Firstly, IFC has many features, but the OBJ converted just has a feature(geometry?). In the process of transformation, merge all the geometries into one. I don't want to merge. Secondly, the transparency properties of the material in the MTL file are all 1(In other words, OBJ is transparent).It's really terrible. Finally,I want to export the attribute table from IFC.Is there any way to solve it?Any advice would be appreciated!Thanks!

1
daveatsafe
Safer
6 years ago
simonhume
Participant
simonhumeParticipant
asked in Data
Select only certain values in excel spreadsheet column

Hi Can someone advise me what the easiest method there is to select only certain records from an excel spreadsheet, based on one column?I have a simple excel spreadsheet listing bin deliveries to addresses as individual cases from our CRM system. One of the columns is whether the case is Open or ClosedOne of my FME workspaces is configured to map all these into SHP format, which i've succesfully doneThe other workspace now needs to also map these, but only where the case is Open.I've tried the Attribute based Transformers, but can't get the correct outputAny help much appreciatedthanksSimon Hume

2
simonhume
Participant
6 years ago
boubcher
Contributor
boubcherContributor
asked in Data
WFS query

Hello I am using a WFS reader to extract data, is there any way we could query the WFS to retrieve only specific featuresThanks

9
deanatsafe
Safer
6 years ago
apence231
apence231
asked in Data
center and zoom (set scale) to polygon within google static maps

My workflow right now is set up to do some calculations on a property boundary then be able to show that property on an aerial image. Where I'm getting stuck is to be able to find a way to set the scale (zoom level) of the google static map so the polygon is centered and at an appropriate zoom level. I'm using the 'google static map fetcher' transformer and have everything working to be able to center the polygon within the google map, just want to find a way to set a scale level to have it adjust to the different size polygons.

2
apence231
6 years ago
V
vincentvanderwo
asked in Data
Spatial xyz (points) to .jpg/png

Hi, I have a lot of profiles measured as xyz data (points) in RD coordinate system. It's an Excel with all the profiles, each profile has it's own name (1,2,3, etc). Is there a way to convert each profile to a separate .jpg/png file in FME?

8
V
6 years ago
G
gisarchitect
asked in Data
Connecting to a HANA Geodatabase

Hi, I have set up an Esri Geodatabase on HANA 2 using ArcGIS Pro and loaded data in it using Pro. I then tried to establish a reader connection to this geodatabase from FME 2018 using a connection file created in ArcGIS Pro.The system I am trying this from has ArcGIS Desktop 10.6, ArcGIS Pro 2.1.3 and FME 2018.0.1 installed (b18310, 64-bit). The HANA jdbc driver has been installed propoerlyThe error I am getting is: 'Could not open Enterprise Geodatabase. The error number from ArcObjects is: -2147155361. The error message from ArcObjects is: Connections to HANA to geodatabase in SAP HANA are only supported from ArcGIS Pro and ArcGIS Server sites.I can think of 2 possible reasons:1. The 'Esri Geodatabase (ArcSDE Geodb)' format doesn't support HANA-based Geodatabases (yet?). If so, is this on the FME roadmap?2. FME is trying to establish the connection using the 32-bit ArcGIS 10.6 libraries rather than 64-bit ArcGIS Pro libraries. The reference to ArcObjects in the error

6
fmelizard
Contributor
6 years ago
dmerrick
Contributor
dmerrickContributor
asked in Data
SDE to KML Issue

Hi,I am having an issue converting data from an ESRI SDE connection to KML file in FME due to 1.3m shift from the same conversion in ArcMap.My SDE data is NAD 83, UTM Zone 10N (WKID: 26910). I have no issues connecting to the SDE, I get the same 1.3m shift using a Writer or a FeatureWriter. I do get a warning of:NOT changing coordinate system of reader identified by keyword `GEODATABASE_SDE_1' from `EPSG:26910' to `_UTM83-10_0' -- mapping file setting of `EPSG:26910' overrides coordinate system `_UTM83-10_0' read from fileIf I put the SDE coordinate system of "UTM83-10", I still get the same error. Once exported, regardless of which coordinate system i use, the 1.3m shift is still present in the kml. I have exported from the SDE into both a file geodatabase and shapefiles and repeated the same process and I get the same results. If I re-import the KML into FME to a shapefile and compare to the original in ArcMap, there is no shift. If I import the same kml

5
dmerrick
Contributor
6 years ago
K
kstckillian
asked in Data
Does FME have a AIG format raster reader?

Does FME have a reader for AIG format rasters?

1
debbiatsafe
Safer
6 years ago
M
michael_pieters
asked in Data
Layers from spatialite database not visible in QGIS.

I've created a spatialite database using FME. It includes layers with polygons, lines, points and tables (no geometry). However, FME 2017 does not seem to offer an option to indicate geometry type. Therefore, the geometry_type table and column is not filled correctly thus layers are not visible in QGIS. After adjusting the table manually the layers become visible. Does anyone know how to solve the problem within FME?

1
debbiatsafe
Safer
6 years ago
A
azajarc
asked in Data
Request timed out in ArcGIS Online

Anyone who knows the solution to this? We are doing a refresh from ESRI ArcGIS SDE to ArcGIS Online and this is the error that was encountered. How to avoid this? Most of the time I encounter this error, only sometimes that the process becomes successful. ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '504' and the message was: 'Your request has timed out

3
J
6 years ago
S
skhanaba
asked in Data
FMEServerJobSubmitter - Could not initialize connection to server

Hello I am getting error: FMEServerJobSubmitter(ServerJobSubmissionFactory): Could not initialize connection to server "<server/LoadBalancer name>". FME Server error: `Communication Error: Failover node detected client request. Request rejected to redirect to active node.' , Please advise.

1
redgeographics
Evangelist
6 years ago
K
kouri1986
asked in Data
Can I use a postgres writer over a sqlexecutor to write to a postgres hstore column?

I am looking to write to a postgres hstore column and seeing if their is a way to use a postgres writer with its 1000 transactions at a time to write to postgres table with a hstore column over using a 1 at a time sql-executor? I have 5 attributes to go into the hstore.

1
takashi
Contributor
6 years ago
J
jkubacka
asked in Data
Workflow from point cloud to 3D model in GIS

I need to create a workflow in FME Workbench. It should contain following steps:1. Given Point Cloud (.las-format)2. Export as a 3D Model in IFC3. Create a GeodatabaseSo in the end I want my point cloud to be a model that I can import to ArcGIS Pro. Is that possible or is there any other/better solution solving my problem? I am thankful for any comment.

5
daveatsafe
Safer
6 years ago
H
hadhafang
asked in Data
WRITER_TYPE Error Ifc to CityGML

I am am trying to convert a IFC-file into a CityGML-file. For inspiration I am relying heavily on the intermediate guide for BIM to gis. Now when I am trying to convert the IFCDoors entities into CityGML doors i get the following error:Type of writer to use was not specified (WRITER_TYPE was not found)I have to the best of my knowledge not changed the writer in any way except for the output-file path and the projection system. Every other geometry I am using seems to konvert nicely.So my questions are as follow:What does the error mean?How can I solve it?Thanks in advance :D

5
daveatsafe
Safer
6 years ago
jatoxa
Contributor
jatoxaContributor
asked in Data
BADNEWS autocadCorrTemplate.fmi could not be opened

Hi,   When running a workspace on Cloud I get the following error "BADNEWS: File /opt/fme-engine-2018/metafile/autocadCorrTemplate.fmi could not be opened (foundation/framework/engine/tabrdr_classic.cpp:2756 - open) - (foundation/framework/engine/tabrdr_classic.cpp:1460 - getRow)"  The same workspace works fine in Workbench and even worked on Cloud in an earlier iteration. I have recently updated the workspace and it does contain a DWG reader but I have made no changes to that part of the workflow.  

2
G
6 years ago
J
joaarmst
asked in Data
Error running translation

I keep getting this very vague error message when running my FME. My workspace is simple. I'm pulling down my data from ArcGIS online, I have a joiner to join to other data to get a few attributes, I'm re projecting my data then writing it out to SDE. When I run it all I get returned is Error running translation. I have sent it to inspector and I can see what I want so it appears to be having trouble when it gets to SDE. Any ideas?

2
J
6 years ago
M
markfrater
asked in Data
3D spatial relator for creating minecraft rails

@dmitribagh and @mark2catsafe created a railway in minecraft using a spatial relator to examine adjacent points to determine the orientation for the rails. See https://knowledge.safe.com/articles/1064/how-to-make-minecraft-worlds.html. However the "complicated" condition definition for adding the block attributes only works in 2D and does not incorporate in z data for elevation or slope of the rails. Does anyone have some thoughts/ideas about how to expand on the condition definition to add the slope attributes? e.g. 2 Sloped rail ascending to the east. 3 Sloped rail ascending to the west. 4 Sloped rail ascending to the north. 5 Sloped rail ascending to the south.

0
M
6 years ago
O
ottadini
asked in Data
recursively concatenate json attributes

I have a response from Azure's OCR service, which looks like this (full response attached):{    "language": "en",    "orientation": "Up",    "textAngle": 0,    "regions": [        {            "boundingBox": "316,555,1597,123",            "lines": [                {                    "boundingBox": "1515,555,398,29",                    "words": [                        {                            "boundingBox": "1515,555,82,23",                            "text": "CRMA"                        },                        {                            "boundingBox": "1608,555,154,29",                            "text": "Completion"                        },                        {                            "boundingBox": "1775,555,138,23",                            "text": "Document"                        }                    ]                },                {                    "boundingBox": "316,632,556,46",                    "words": [                        {                  

4
O
6 years ago

Badge winners

Show all badges
29,721
Posts
Terms & ConditionsCookie settings