| ------------------------------------------------------------------------------
|
The
CSV ("Comma Separated Value") file format
is often used to exchange data between disparate
applications. The file format, as it is used in
Microsoft Excel, has become a pseudo standard
throughout the industry, even among non-Microsoft
platform
|
CSV
stands for Comma Separated Values, sometimes also
called Comma Delimited. A CSV file is a specially
formatted plain text file which stores spreadsheet
or basic database-style information in a very
simple format, with one record on each line, and
each field within that record separated by a comma.
It's important that the individual "records"
within a CSV file NOT contain commas, as this
may break the simple formatting when using the
file in another application. |
As
is the case with most exchange formats since XML,
CSV files have become somewhat of a legacy format.
New applications that wish to include an export
format will generally use XML today. |
CSV
in New Designs |
| CSV
does have one advantage over XML for specification
in new designs. CSV has much lower overhead, thereby
using much less bandwidth and storage than XML.
For new designs where overhead issues have high
importance or criticality, CSV may be the better
choice. |
| Especially
in requirements that utilize high-cost bandwidth
and where large amounts of data must be moved often,
CSV may be better specified. Hybrid implementations
that convert to and from CSV where bandwidth is
critical may also be a workable solution in some
designs. |
CSV
advantages include: |
 |
Files are very small,
about 100KB for the largest files |
|
The data in CSV's
is stored as text so files are supported
by a wide |
| |
variety of applications |
|
Easily imported or
opened in applications such as spreadsheets.
|
|
We at
Evolve can create CSV file for your application
in which Data tables are presented in Comma
Delimited, CSV text file format. Although this
file format allows for the data table to be
easily retrieved into a variety of applications,
they are best viewed within one that will allow
one to easily manipulate data that is in columnar
format. Common examples of such applications
are those that are used to create spreadsheets
and databases.
|
We
can develop a CSV file is a specially formatted
plain text file which stores spreadsheet or basic
database-style information in a very simple format,
with one record on each line, and each field within
that record separated by a comma and can use CSV
files to transfer a large volume of spreadsheet
or database information between programs. |
We
need to use CSV formatted for inserting data into
the MySql as table/database directly and can open
a .CSV file in any spreadsheet application like
Microsoft Excel, Access and any special CSV editor. |
We
can interact with the CSV file as an ODBC source.
To do this, we can use the ODBC Data Source Administrator
to define the file as an ODBC data source. |
CSV
file created by evolve can be imported into other
programs like Address Book. |
We
can prepare your data in a *.txt file. This file
will contain a record per line. Each record is
made of fields separated by a special character
(for instance). The order of fields does not matter
since you'll specify in the next step how they
will be interpreted. Just check that all lines
have the same number of fields (even when void).
A faster method to produce a CSV file is to use
a spreadsheet like Excel and save a document as
a CSV file (*.txt). |
We
can create applications using php, asp or any
platform and for that matter which can export
the data to various type of files for integration
with their offline software or Offline records
we can use CSV file type to export data. |
| |
| Back
to, E-commerce
website solution |
