467,169 Members | 992 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,169 developers. It's quick & easy.

File Import Wizard

Hi All. I'm looking for any help or sample code that can show me how to make a file import wizard in ASP.NET (VB preferred) like the one that MS Access uses. I'm working on a web site where the user has the ability to upload a file (.txt or .csv). The data in the file may be comma delaminated, tab delaminated, fixed width etc (we don't know).

What I'd like to create is something like MS Access uses to import an Excel file into the database. Access has a wizard that walks the user through steps such as - is the first row the header, ignore the first "x" number of rows, is it comma, tab, semi colon etc delaminated, allows you to adjust what data goes in what field etc And then does the import into the database. I need to recreate something exactly like this but web-based. I'd also like the user to be able to store their preferences so that the next time they go to upload the same type of file the can just choose a pre-made preference that knows what to do. The file would then get imported into a database (Access or SQL Server).

Any suggestions on where to start or code samples to look at?

Thanks
Oct 2 '05 #1
  • viewed: 2631
Share:
2 Replies
Hi David,

Welcome to MSDN newsgroup.
From your description, you're wanting to build a file import system which
allow the client user to provide some files (some wellknown format) and
then import the file content as records into the database server, also the
system is web based, yes?

As for such application, I think we can separate it into two parts:

1. In the ASP.NET web page, we provide a wizard like UI to collect
information from the clientuser, also use a <input file ..> element to let
the client user upload file. Then, when the user submit the page, the data
and file will be posted to the server for processing.

2. In the ASP.NET webapp's serverside, we just use our serverside code
logic to parse the uploaded file stream and loop through the text datas in
it and build SQL data execution command to insert data into database. This
is the same as we programmatically import a file into database in winform
or console application, you can make the parsing and accessing database's
code into a separate component.

Currently I haven't found any existing code samples, if you have any
further and more detaild question, we can have some further discussion on
them.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)


--------------------
| From: "David Berry" <db****@mvps.org>
| Followup-To: microsoft.public.dotnet.languages.vb
| Subject: File Import Wizard
| Date: Sun, 2 Oct 2005 11:50:56 -0400
| Lines: 83
| MIME-Version: 1.0
| Content-Type: multipart/alternative;
| boundary="----=_NextPart_000_000A_01C5C747.8CD60990"
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| Message-ID: <#Y**************@TK2MSFTNGP14.phx.gbl>
| Newsgroups:
microsoft.public.dotnet.general,microsoft.public.d otnet.languages.vb
| NNTP-Posting-Host: adsl-64-252-4-30.adsl.snet.net 64.252.4.30
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.dotnet.languages.vb:108605
microsoft.public.dotnet.general:51140
| X-Tomcat-NG: microsoft.public.dotnet.general
|
| Hi All. I'm looking for any help or sample code that can show me how to
make a file import wizard in ASP.NET (VB preferred) like the one that MS
Access uses. I'm working on a web site where the user has the ability to
upload a file (.txt or .csv). The data in the file may be comma
delaminated, tab delaminated, fixed width etc (we don't know).
| What I'd like to create is something like MS Access uses to import an
Excel file into the database. Access has a wizard that walks the user
through steps such as - is the first row the header, ignore the first "x"
number of rows, is it comma, tab, semi colon etc delaminated, allows you to
adjust what data goes in what field etc And then does the import into the
database. I need to recreate something exactly like this but web-based.
I'd also like the user to be able to store their preferences so that the
next time they go to upload the same type of file the can just choose a
pre-made preference that knows what to do. The file would then get
imported into a database (Access or SQL Server).
| Any suggestions on where to start or code samples to look at?
| Thanks
|

Oct 3 '05 #2
Hi David,

How are you doing on this issue. Does the suggestions in my last reply help
a little? If there're anything else we can help, please feel free to post
here.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
--------------------
| X-Tomcat-ID: 56268410
| References: <#Y**************@TK2MSFTNGP14.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: st*****@online.microsoft.com (Steven Cheng[MSFT])
| Organization: Microsoft
| Date: Mon, 03 Oct 2005 03:51:26 GMT
| Subject: RE: File Import Wizard
| X-Tomcat-NG: microsoft.public.dotnet.general
| Message-ID: <lz*************@TK2MSFTNGXA01.phx.gbl>
| Newsgroups: microsoft.public.dotnet.general
| Lines: 88
| Path: TK2MSFTNGXA01.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.dotnet.general:51152
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Hi David,
|
| Welcome to MSDN newsgroup.
| From your description, you're wanting to build a file import system which
| allow the client user to provide some files (some wellknown format) and
| then import the file content as records into the database server, also
the
| system is web based, yes?
|
| As for such application, I think we can separate it into two parts:
|
| 1. In the ASP.NET web page, we provide a wizard like UI to collect
| information from the clientuser, also use a <input file ..> element to
let
| the client user upload file. Then, when the user submit the page, the
data
| and file will be posted to the server for processing.
|
| 2. In the ASP.NET webapp's serverside, we just use our serverside code
| logic to parse the uploaded file stream and loop through the text datas
in
| it and build SQL data execution command to insert data into database.
This
| is the same as we programmatically import a file into database in winform
| or console application, you can make the parsing and accessing database's
| code into a separate component.
|
| Currently I haven't found any existing code samples, if you have any
| further and more detaild question, we can have some further discussion on
| them.
|
| Thanks,
|
| Steven Cheng
| Microsoft Online Support
|
| Get Secure! www.microsoft.com/security
| (This posting is provided "AS IS", with no warranties, and confers no
| rights.)
|
|
|
|
|
|
|
|
| --------------------
| | From: "David Berry" <db****@mvps.org>
| | Followup-To: microsoft.public.dotnet.languages.vb
| | Subject: File Import Wizard
| | Date: Sun, 2 Oct 2005 11:50:56 -0400
| | Lines: 83
| | MIME-Version: 1.0
| | Content-Type: multipart/alternative;
| | boundary="----=_NextPart_000_000A_01C5C747.8CD60990"
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| | Message-ID: <#Y**************@TK2MSFTNGP14.phx.gbl>
| | Newsgroups:
| microsoft.public.dotnet.general,microsoft.public.d otnet.languages.vb
| | NNTP-Posting-Host: adsl-64-252-4-30.adsl.snet.net 64.252.4.30
| | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP14.phx.gbl
| | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.dotnet.languages.vb:108605
| microsoft.public.dotnet.general:51140
| | X-Tomcat-NG: microsoft.public.dotnet.general
| |
| | Hi All. I'm looking for any help or sample code that can show me how
to
| make a file import wizard in ASP.NET (VB preferred) like the one that MS
| Access uses. I'm working on a web site where the user has the ability to
| upload a file (.txt or .csv). The data in the file may be comma
| delaminated, tab delaminated, fixed width etc (we don't know).
| | What I'd like to create is something like MS Access uses to import an
| Excel file into the database. Access has a wizard that walks the user
| through steps such as - is the first row the header, ignore the first "x"
| number of rows, is it comma, tab, semi colon etc delaminated, allows you
to
| adjust what data goes in what field etc And then does the import into the
| database. I need to recreate something exactly like this but web-based.
| I'd also like the user to be able to store their preferences so that the
| next time they go to upload the same type of file the can just choose a
| pre-made preference that knows what to do. The file would then get
| imported into a database (Access or SQL Server).
| | Any suggestions on where to start or code samples to look at?
| | Thanks
| |
|
|

Oct 5 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Grim Reaper | last post: by
3 posts views Thread by mollyf@hotmail.com | last post: by
2 posts views Thread by David Berry | last post: by
4 posts views Thread by Sam K. | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.