Search these areas:
Help
Support Forums
Product Info



Introduction
DataWeb: What's New
Creating an Application
The DataWeb Designer
Application Management
Data Tables
Data Tables
Views
Templates
Components
Data Analysis
Members
Security
Importing
-Importing an Access Database
-Importing an Excel Worksheet
-Importing a Text File
-Importing a Web Site
-Importing a Web Archive
Exporting
FTP
JavaScript
Object Model
Full-Text Search
Domain and Email Hosting
HotBlock Modules
Account Management
Glossary
New Responsive UI Module





DataWeb Help
Support Forums
Tutorial
Script Library
Knowledge Base

Home > Support

DataWeb User's Guide

Importing a Text File
You can create a new data table in your web by importing a text file with comma-separated values (.csv) file.

A .csv file contains text data separated by commas, so that a comma indicates where the value of one field ends and the value of the next begins. Individual records are separated by line breaks. Many spreadsheet and database programs support saving files or tables as comma-separated values files.

To create a new data table from a .csv file, click the destination folder for the data table on the Web Directory tab. Click the New button, and under the Import Existing column select Data in a Text File. Enter the path and file name for the text file that you want to import, and indicate whether the first row of the text file contains field names.

When you click the Next button, your text file is uploaded and processed. You're presented with a table showing the first twenty rows of your data. On this page, you can specify a name for your new data table, change field names and data types, and indicate whether a field should be excluded from the new data table. When you're done making changes, click the Finish button at the bottom of the page to create the new table.

When you import a text file, the resulting table's primary key is always created for you on the RowId field, which is an auto-incrementing field of type Integer.
Affiliate | Partner | Terms of Use | Privacy Policy | Contact Us | Pricing | Bring DataWeb In-House    
DataWeb, 720 North 10th Street, A #145, Renton, Washington 98057 *425-583-5970* Fax 484-770-4706* Email Us