![]() Next, the Comma Separated Value Parameters menu must be addressed. This menu has 3 entries which are critical to this particular file. Separator Character: Make sure that this value is set to a coma (",")Ģ. Strip Quotes: all strings in the input file are quoted and must have their subtending quotes removedģ. Lines to Skip, Header: Their are 2 header lines in this file which must be skipped Note unreferened items, such as "Remove Duplicate Separators" are left in their default value.ġ. The "Main" FME Workbench canvas will now show the reader item for the GeoLiteCity-Blocks.csv file as follows (Image 5): Select the "OK" menu button to proceed (Image 4). Next, the output of the workflow needs to be specified. To create a Writer, go to Writers -> Add Writer in the main top level FME menu (Image 6) The Writer, in this case, will be a Microsoft SQL Server Non-spatial table. In the Add Writer menu there are 3 items that need to be addressed:ġ. Format: This needs to be set to "Microsoft SQL Server Non-spatial"ģ. Parameters: This is where the core elements will be specified for the Writer Coordinate System: leave this as the default ("Same as source") even though it is irrelevant since this table will not contain any spatial columns.Ģ. This screen (Image 8) is used to specify the database connection values. The Server will the SQL Server instance being used. ![]() The database will be the database elected to hold the GeoLite tables.ĭepending on your preferences, either use an authentication pattern of Username/Password or opt for "Use Windows Authentication". Selecting "OK" from the previous menu will take you back to the "Add Writer" menu. Note that the Dataset: field is now populated with the name of the database which will hold the resulting table (1). ![]() To the first time user, this menu can be a bit confusing. Since a database table is the intended output from the Writer, this menu is asking if you would like to add a new table (feature type) to the Writer. Item 1, Feature Type Name: is the name of the SQL Server table which will be created. After entering the table name, select the Format Parameters tab (2). ![]() Next, the Feature Type Properties will be specified. Unreferenced items are left at their default values. Item 1, Drop Table First can be set to "Yes", allowing you to overwrite existing attempts to create this table. The Main FME canvas now displays the Writer element. Next, the Reader and Writer are connected to each other, expressing the data flow from Reader to Writer. You can think of these are the table column - basically, you are telling FME to transfer the data in the input file to Next, the attributes from the input file defined by the Reader (think of these as the table columns) need to be specified to the Writer. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |