Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 6,827 Posts
  • 25,151 Replies
6827 Posts
J
jimq66
asked in Data
Converting SQL tables to MS Access

I have two sql tables. One contains inspection records as shown:The other contains questions for each inspection as shown:I need to combine these and put them in access as such:InspectionID; InspectionName; Date; InspectedBy; Old_Spill_ID; Spill_Type; etc.Any help is much appreciated!

80
mark2atsafe
Safer
8 years ago
X
xavigarciamar
asked in Data
Measure Lines and text Microstation

Hi ,I have elements of kind measure ( formed by a line/s and text) , anybody knows what geometry is this ??? the input give me it like lines , but the text disappear.Thanks in advanced for you help.

60
X
8 years ago
franco69
Contributor
franco69Contributor
asked in Data
Excel writer

I have problems to get the right idea to write an excel sheet Maybe for you an easy one. See screenshot: i will write an excel sheet..row names like Attribute names and one column for each element_index? how i have to set the params?Thx and greetzFranco

180
franco69
Contributor
8 years ago
whkarto
Contributor
whkartoContributor
asked in Data
Create group in dwg file

Hi CAD Experts!Is it possible to create groups on features that are written by ACAD Writer? I'm investigating capabilies of FME in this field. Find attached two files that indicate what I'm trying to archive. File demodata-layer.dwg shows the initial situation. I'd like to combine all lines of one building into one group. File demodata-group.dwg presents the desired result. The groups were formed interactively in AutoCAD to show the principle feasability. Within my wokspace I'm having all needed attributes to form groups upon them, so it's really a question of implemented functionality of AutoCAD Writer.

200
mark2atsafe
Safer
8 years ago
S
sega
asked in Data
Unbalanced parenthesis in SDE Reader/Writer password.

Good day!Does FME password parameter into SDE Reader/Writer sensitive to symbols?I encountered a problem with SDE connection parameters. Some of our SDE connection passwords contain one parenthesis. And when I try to connect via SDE Reader/Writer with parenthesized password value I have an error message: 'Unbalanced parenthesis encountered on line 13 of file ***** -- line was `"DEFAULT_MACRO" SDE30_IN_PASSWORD pas(sword'Program Terminating'I've never seen this error before in previous FME version (2013), as I remember...Does it is really and is it an innovation?Thanks)

60
fmelizard
Contributor
8 years ago
S
simongreener
asked in Data
Namespace Prefixes when writing GMLSF

Edition: FME Oracle Edition (node locked-crc) Version: FME(R) 2016.1.1.0 (20160722 - Build 16609 - WIN64) Locale: en_US Codepage: 1252 (ANSI - Latin I) Registration Key: 1-628-344-195 Registration: Evaluation License 361 days left Serial Number: NBGL-UEC6-12L8 Customer Number: 95780 Home Folder: C:\\Program Files\\FME\\ Operating System: Microsoft Windows 10 64-bit (Build 10586)I am converting some linear data in an ESRI File GeoDatabase to GML using the GML SF-0 writer. I then load that data in to SQL Server 2012 for conversion into geography instances.The FME data has namespace prefixes for every tag:<fme:FeatureCollection xmlns:fme="http://www.safe.com/gml/fme" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:gml="http://www.opengis.net/gml" gml:id="id78f185fa-6116-47e5-b873-8d66e48aa1dc"> <fme:featureMember> <fme:Roads gml:id="idd3bb702b-f7a7-4207-ae24-f509a17

184
S
8 years ago
X
xavigarciamar
asked in Data
Converting from V7 microstation to V7 microstation

Hi everybody ,In a part of my FME process I do a copy of a input V7 DGN , but when I look in results I always have the same result ,all the element in level 1 and color 20 , don't takes the attributes of the input.Finally , to test I'm doing a direct copy , conecting the input V7 directly to output V7 , and the result is the same.Any idea?? , thanks !!

40
X
8 years ago
B
balu
asked in Data
Fme citygml to kml while saving its showing error

FME Configuration: No destination coordinate system setIFMELine was given memory that was NULL or invalidA fatal error has occurred. Check the logfile above for detailsKML: Error finishing writing datasetProgram Terminating

80
itay
Contributor
8 years ago
H
honkovam
asked in Data
Text Line - End of Line

Hello,I'm writing out to a text file with Line Termination: Windows. But when I open the text file in Notepad++, the end of line is Unix, except the last line which is Windows:25.000000000000 LF0.000000000000 LF0.000000000000 LF-25.000000000000 LF400012.5 LF1299987.5 CRLFI also checked in TextPad - that's showing "Unknown" end of line. When I open the text file in Notepad, the line breaks are ignored:25.000000000000 0.000000000000 0.000000000000 -25.000000000000 400012.5 1299987.5 Could you please help me?Thanks

19113
H
8 years ago
lazarlubomir
Contributor
lazarlubomirContributor
asked in Data
How to change PDF 2D background color

Hello, I want to convert DGN file to PDF, but in DGN file are features in white color. I need to change background color of PDF 2D to black color, how can I do that please?Thank You so much!Lubo

180
itay
Contributor
8 years ago
Z
zubairsm
asked in Data
dgn file greater in size does not show any element in Microstation

Hi I have many dgn files (Version 8) that I am processing and writing again to DGN format. (Tags are read and written)The problem is with the larger files created by FME, when opened in Microstation, there are no element in it (blank file). The same file if I open in Data Inspector, the elements are present and can be viewed.There are no issues with the file less then 3MB.I know there is a limitation of 32MB with mircostation v8 files but my files are less then 15 MBAny thought?RegardsZubair

1070
Z
8 years ago
S
submi
asked in Data
"Flattering" left join

How can I change something like this:1Chris1Rock2John2SmallInto something like this:1Chris Rock 2John Small Thanks,Submi

120
S
8 years ago
J
jamesblake
asked in Data
Best way to replace walls from Architectural CAD file with a line

What would be the best method of replacing walls from an architectural CAD drawing with a single line. I have tried a few variations with the Generalizer and not finding one that works well. I want to take an architectural drawing where the walls are shown as two parallel lines and replace with a single, much simplified version of the lines that preserves the general shape of the rooms. Preciseness and accuracy aren't that important it is just for visualization purposes.

40
itay
Contributor
8 years ago
sigtill
Contributor
sigtillContributor
asked in Data
Write to relation table in other than FileGDB

Similar to FileGDB (https://knowledge.safe.com/questions/1652/writing-relationships-in-esri-file-geodatabase.html) Is it possible to easily write to a relation-table on MS SQL? And other databases? I see the db_relationship does not exist in those formats

78
sigtill
Contributor
8 years ago
P
pierreguyane
asked in Data
how reduce ecw

how reduce ecw

110
davideagle
Contributor
8 years ago
R
rogerm
asked in Data
Validate/Read /Export thousand of txt to csv (txt are in 2-3 differents formats)

Hi, I would like to know how i can import multiples txt file currently with 2-3 different formats and export it in csv. Validate it (If is fail to read it or if it succès and make a txt file with result)I have thousand of .txt file in a directory  The goal is to convert all in one common format in this case .CSV. The majority of the file are in this format: "/" = SKIP LINE (Good point are without / ) Line begin with number are good  On this case i want to extract 127,126,115 Cannot use the header its never have same number of line.  //-----------------JOBFILE INFORMATION------------------------ / / Instrument: I 3" R1000 No.: 1610178 / Date: 2016-04-07 / Hours: 09H32 / By: / Job: 60407P3DICF / Description: ; / Location: ; /--------------------END OF JOBFILE INFO--------------------- 127(TAB)1005.4345(TAB)10.2440(TAB)477.0120(SOME SPACES WITH TAB AT THE END);2016-04-07(TAB)##FILENAME## 126 1005.4517 -0.0040 476.9552 ; 2016-04-07 ##FILENAME## 115 10

100
mark2atsafe
Safer
8 years ago
C
cassidym
asked in Data
Is there any way to sort/order records in HTML report generated by HTMLReportGenerator?

Is there any way to sort/order records in HTML report generated by HMTLReportGenerator?

270
ciarab
Contributor
8 years ago
X
xavigarciamar
asked in Data
Converting microstation V7 to V8

Hi again ,Anybody knows why when I convert a V7 map to V8 map bylevel , don't assign me the attributes , color , style and weigth bylevel ?? I'll explain , I have a input in V7 that I pass for a schemaMapper to assign the feature outputs in function of a values of the input ( the attributs color , style , level and weigth of the input) . In function of this attributes in the input I assign a featureType or other classified by level name , I inform the level code in the feature output and the attributes set_bylevel , set_bycolor and set_byweight ara marqued to yes. Also the parameter Write Tags in the output is set to yes .... but the process inform correctly the name level in V8 but not the attributes bylevel ...Any idea ???

200
X
8 years ago
remco
remco
asked in Data
from subtype to new featureclass

Hello, I have a FGDB with a lot of (empty) features, and the features all contain subtypes.Now I want to create new features out of every subtype.Does anyone have a idea how I can do this?R.

170
itay
Contributor
8 years ago
X
xavigarciamar
asked in Data
Elevations(heigth) in microstation V8

Hi everybody ,I'm trying to translate a V7 map from microstation to V8 microstation map and I have a problem :The elevations or heigths(Cotas in spanish) that in V7 ara a unique element , are translated to V8 like a diferent elements ( Text and lines).Anybody knows how to translate from v7 to v8 the cotes like unique element ???.Thanks in advance for your help , regards !!

590
X
8 years ago
A
amit
asked in Data
Reading DGN Default/Model Space

Hi everyone,I'm reading in a DGN file, but when I inspect/run it, only the paper space is output. Unlike the AutoCAD DWG writer, there doesn't seem to be a Paper Space On/Off toggle. How can I read in only the default/model space? Thank you.

260
mark2atsafe
Safer
8 years ago
lazarlubomir
Contributor
lazarlubomirContributor
asked in Data
How to gain Z value from text entity to line feature

Hello everybody!I just wanna solve problem with Z values (as stand alone entity), which I want to merge with attributes of line feature. My problem is following (please check the picture below):As You can see, there is text point with Z value, but their def point is totally out of vertex of line feature. What I need is to get line feature with 2 attributes - Z value of start vertex and Z value of end vertex. Is anybody here, who has solution of this situation please?Thank You so much!Lubo

630
lazarlubomir
Contributor
8 years ago
X
xavigarciamar
asked in Data
Converting points Arcmap to cells microstation V8

Hi everybody ,Anybody could help me ? , I'm trying to convert the points of a arcgis map to cells in microstation V8.This points are in feature class with a identificative field for register. I'm doing the next one , the input arcgis is passed for a schemaMapper and in function of the value of the identifier in arcmap I give to the ouutput in microstation this attributes : igds_cell_name , igds_type and igds_element_type , but don't transform the cells , It stay in points in ouput microstation ...The ouput is generated with feature types by level name ....Any help would be greater , thanks !!!

110
X
8 years ago
gisgeek
Contributor
gisgeekContributor
asked in Data
AGOL WRITER UPDATES BUT DOESN'T DELETE OR INSERT

I am using the latest FME 2016.1.1. I am trying to update features in AGOL and it updates existing features but it doesn't delete or insert new entries. Anyone know why this would be happening I am stumped. I have my AGOL writer set to UPDATE. Is there a setting somewhere I am missing?

630
ciarab
Contributor
8 years ago
fmelizard
Contributor
fmelizardContributor
asked in Data
More accurate line length using elevation / DEM

How can I calculate a more accurate line length using a DEM?

50
daveatsafe
Safer
8 years ago

Badge winners

Show all badges
30,469
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.