Data

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!

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.

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

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.

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)

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

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 !!

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

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

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

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

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

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.

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

how reduce ecw

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

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

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 ???

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.

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 !!

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.

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

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 !!!

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?

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