Skip to main content

Data

Using readers and writers to extract and load data.

  • 7,310 Posts
  • 26,856 Replies
7310 Posts
jkr_wrk
Influencer
jkr_wrk
 Data
michaeld
 Data
jhawks
Contributor
jhawksContributor
 Data
gislogan01
 Data
chris_m
Participant
chris_mParticipant
 Data
Can't access Pervasive database

I get the following error when trying to access a Pervasive SQL databaseStarting translation... FME 2018.0.0.0 (20180308 - Build 18284 - WIN32) FME Database Edition (node locked-crc) Temporary License: 16 days left. Machine host name is: cmcclain Operating System: Microsoft Windows 10 64-bit (Build 16299) Copyright (c) 1994 - 2018, Safe Software Inc. Safe Software Inc.Creating reader for format: Pervasive PSQLTrying to find a DYNAMIC plugin for reader named `PERVASIVE'Loaded module 'PERVASIVE' from file 'C:\\apps\\FME\\plugins/FME_ADO.dll'FME API version of module 'PERVASIVE' matches current internal version (3.8 20180209)Pervasive Reader: Read 0 DEF line(s). Found 0 attribute(s)Pervasive Reader: Opening `mcsdb' for read operationPervasive Reader: Connection failed. Connection string `Provider=MSDASQL;DSN=mcsdb'.

1393
chris_m
Participant
tara
 Data
wallace
 Data
Some Excel writer worksheet/ranges not getting populated after upgrade to FME2017x64

I am migrating from FME 2014 to FME2017x64. We have been using a workbench for some time in which the output includes writing to a number of excel template worksheets having defined ranges for the writer. In each case the option to truncate the range has been set to yes. When running the same workbench in 2017x64 I am now seeing that some worksheets/ranges are getting populated while the vast majority are not . I've been looking for something that indicates why some would get populated while others would not but have not been able to determine what that might be. Has anyone else experienced problems with excel writer in FME 2017 not writing to worksheet/ranges as they had in a previous version?

974
david_prosack88
 Data
Center Point Extractor

Hi All,I am trying to get the center point of a room without replacing the geometry, i.e using the center point replacer. When I use the Center Point Extractor to get the center point lat and long, the lat and long ends up in South America. I'm confused because the Revit file displays in Texas, which is correct. Can anyone help explain this?I am using the IFC reader to run the Revit file. The RefLat and Long are in Texas. Can this be caused by the Revit file Min and Max Reference coordinates? I'm thinking the vertices in the Revit file are not correct. I do not know Revit unfortunately, I only receive these files. If there something wrong with the file, or something that the Revit Technicians should fix, that would be great to know and understand. Any insight would be great!Thanks,David

411
lars_de_vries
mamajid
Contributor
mamajidContributor
 Data
roberto
Contributor
robertoContributor
 Data
SSO cross domain users

Hi all,I’ve a question regarding single sign on into FME Server.I’ve installed FME Server on a domain (let’s call it “Domain A”) and I’ve configured the SSO for the users in the Domain A. I’ve tried to log in on a client using right domain A account and then, using Internet Explorer, I’ve logged into FME Server in SSO mode and It works fine.Now I have another domain (let’s call it “Domain B”) trusted with Domain A in bidirectional mode.In FME Server I added the connection to the Domain B’s Active Directory and imported the users from this domain.I tried to log in on a client using right Domain B account and then, using Internet Explorer, I logged into FME Server in SSO mode but it not works.The returned message is “You are not authorized to access this web application”Can someone tell me if I need to set principal name, using the setspn command, also in the Domain B?Thanks in advanceRoberto

972
roberto
Contributor
cm07
 Data
louis_c3
 Data
alexanderyanush
 Data
Geodatabase error 2147467259 Could not read Field

Guys,something wrong is going on. I was changing existing working workspace to pointing to new geodatabase zip file, which also has new table structure. Modified new workspace is working fine on my PC under FME Workbench. But if I publish it on FME Server I'm getting the error (see below) for each attribute that we are not reading from geo tables. And since original database is huge after few minutes FME Server stops the job without any failure message and building core dump files on FME Server machine.Error messages that we are getting:Geodatabase Error (-2147467259): General function failure. Could not read Field `column_name' in Table `Table_name'Does somebody know where the issue can be?Appreciate any help!Thanks.

4199
david_r
Celebrity
wilczekmj
Contributor
wilczekmjContributor
 Data
DonutBuilder: Two Polygons on different heights, incorrect donut – random heights assignment

I am writing a CityGML file by reading the LOD2 3D building models from the DGN file.While reading the DGN, grouped holes are exploded, i.e. “Expand Unnamed (Group Hole) Cells: Yes” and then DonutBuilder is used to re-build the required geometry, i.e. grouped holes. However, rebuilding the grouped holes with the DonutBuilder for the polygons at different heights does not work properly and seems to randomly assign the Z from either the top or bottom or some from bottom and some from top. Please see screen grabs below showing building superstructures:The part that re-builds polygon cutouts is as follows: I used the Group By: “igds_cell_name_sequence_number” from the original DGN grouped hole cells that got expanded when read in order to rebuild them again with DonutBuilder. I tried different Z Modes but it did not help to prevent from incorrect group hole building It seems to be random, in some cases it will built a correct geometry, in other, it will do the incorrect “unexpected” geomet

766
wilczekmj
Contributor
mickael
mickael
 Data
How does FME attributes work with OSM tags ?

Hello,I am trying to work with data from OpenStreetMap, and I have an issue with retrieving tags. The only tags I get are the ones related to 1st level types. Other attributes appear in the inspector right panel, but I cannot access it from in my workflow. So what is the difference between attributes from the Table View and the Feature Information ? Is there any way to access those specific features information from the Workbench ? Strangely enough, when I check the "Determine feature by scanning the entire dataset", all tags also appears in the Inspector Table View (with a lot of missing values). But I cannot use that option from my main workflow, as my dataset is an URL (returning an OSM XML file). So far, I am only looking for a few attibutes on a few elements, like the "layer" value for highways (which indicates if they are underground and above or below other highways).  Any help would be much appreciated, as this is very important for my work :)

2283
mickael
marshwetland
 Data
PDF transformation problems

I'm struggling to transform some pdfs. I am using the PDFtoTEXT transformer as well as a textwriter, stringsearcher, maybe calling to python, and then writing it to a database. I'm flummoxed at the first step.Sometimes it'll write a pdf to a textfile. But often the pdf2text program box pops up. That's useless for automation. What I want is for it to read a whole folder of texts - found the place to specify that - and process each of them into a complex row in my database with many different values. The pdf contains a couple values in the headers and many more in a table-like layout. I will need a couple string parsing processes to get through all that. No idea how to get it to read the pdf name and put that in one cell in my db.But the data inspectors are useless. The interface says the transformation was successful - but nothing was written to the output.txt.So - issues:- how to process multiple texts- how to see what's going on so I know it's working properly

1614
jakemolnar
peaches50
 Data
michuup
 Data
esaka
Participant
esakaParticipant
 Data
arka
 Data
mvdorst
 Data
ECW spatial data: check if it's there and store it in postgis raster

Hi,I'm new to spatial data and ECW files. I've got a ECW file that needs to be inserted into a postgis raster database. All the proper extentions are installed on the database side. I currently load the file into a RasterTiler and then into a postgis writer. The rastertiler was needed otherwise it would not load the file into the database. I'm not sure when raster size I should use, but it's currently set to 256 by 256. But when my colleague tries to view the file from the postgis raster database with several different GEO applications, the error always says that spatial data is missing. So: how to I check if the source file has spatial data? Do I need to change something to the postgis raster writer? Or maybe to the RasterTiler transformer? Thanks so much! In advance for any help.  

571
fmelizard
Safer
delac321
 Data
caddrafter
 Data
ilmachairas
 Data
jhawks
Contributor
jhawksContributor
 Data
Show more activity

Badge Winners

  • FME Certified Professional
    duncanbmcleishhas earned the badge FME Certified Professional
  • English Speaker
    mismail75has earned the badge English Speaker
  • FME Flow Authoring Training
    ismail_imgshas earned the badge FME Flow Authoring Training
  • FME Form Intermediate Training
    jbrontehas earned the badge FME Form Intermediate Training
  • Conversationalist
    beauhas earned the badge Conversationalist
Show all badges

Community Stats

32,865
Posts
124,712
Replies
41,468
Members
Terms & ConditionsAccessibility statement
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.