Web Forms :: CSV Import / Export Upload And Validation
Oct 12, 2010
Some time back i posted for help in uploading CSV file to DB. With the assistance of other members, i was able to set that up on a test page and got the functionality working.. Now project is coming to the end and need to take that code / logic and incorporate with our application. On certain forms, we need to allow the user to export / import via a CSV file.. So this question is muti part for each function.
#1 Export = Since each form is unique, how can i setup the page to export that forms data that is currently in the DB? (I've used this control before [URL] and worked great) for excel. This may work fine for exporting the data out of the db for the user.
#2 Import, if the above is used or some other solution to export the specific table data, is there anyway to validate that the csv file that is being uploaded contains all the columns and is in the correct order? I mean if they were to export the data, but come back few days later to import it, and didnt realize that they selected a csv for another page or maybe they picked the right file, but while editing it they removed a comma or entered some data that would throw the format out of wack.. just looking for a way to read the selected file to import and compare to the table it is suppose to go into and make sure that the columns match and if possible, check for duplicates. I have read thru the forum and found ways to read the file into memory, set the data to a datatable or dataset and working with it that way.
So really looking for some good examples of being able to allow the export of data to .CSV and then allowing the data to be imported back into the table.(with validation in place before the import occurs)
My other posts:
[URL]
View 16 Replies
Similar Messages:
Dec 10, 2011
I have been facing a problem since last two days, actually i want to import some data from a file (file can be csv, txt, sql, xls etc) and after some filtration, export it into csv file. Basically i want to know whether a tool which provides an environment to import different types of file or data where we can perform filtration of data with sql query and then data could be save into file(file can be csv, txt, sql, xls etc)
View 1 Replies
May 9, 2010
I have a csv file and I want to be able to open it remove two colums and save it back as a cvs by clicking on one button.
View 3 Replies
May 29, 2010
instead of using gridview to insert student marks (I have hundreds of students) thought I used the Excel:
1) allow managers of each module after authentication to download the excel file (containing the students enrolled in the given module), the excel file ted is generated by the following code: Id_student ____ maks of subject1 -------- ----maks of subject2
[Code]....
But in this code I do not know how to:
* Add the following condition: the student'marks is between 0 and 20.
* Calculate the average of this module : sum (coeff * mark) / sum (coeff)
2) Allowing responsable module send me the file containing the data (but then I do not know how)
3) Using data, by sending them to the database to calculate averages.
View 3 Replies
Nov 11, 2010
I'm still struggling with my scenario. I have looked everywhere for a solution and cannot find a solution. I am using C# and ASP.NET and I need to export data to an Excel spreadsheet.
I have a list of applications that contains Application objects. Each Application object has a status ID. When I export these applications to Excel then I need a column with a drop down/combo box in it. In this drop down/combo box should be a list of all the statuses from the database. And then I need the status to be selected to that of the application's status ID.
Another question is also with regards to the above scenario. When the user downloads the Excel document then the user can change the status of each application by selecting a different value in the drop down. I will need to upload this spreadsheet and loop through the rows and get the values of the columns and the value of the selected item in the drop down/combo box. How would you do this? Is this possible?
I may not use COM components, so I tried to go with EPPlus or NPOI (it does not have to be these 2) but it doesn't seem like they support my scenario. How would I be able to achieve my scenario? Once again, it doesn't have to make use of EPPlus and NPOI.
View 1 Replies
Feb 21, 2011
How Can I Import,Export Exel to Sql
View 4 Replies
Mar 30, 2010
I have a report that I need to export to a txt file for EDI import. It adds extra blank lines at the bottom. This report is 1 line of text in the report footer. Any way to remove the extra lines that the export produces?
View 6 Replies
Jul 1, 2010
In my .net 2.0 application, i have used export / import excel option. In local, its working perfectly but in server i am getting the below errors,
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.
[UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.]
repClaim.Button3_Click(Object sender, EventArgs e) +337
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
I searched solutions for google and even in this forum, the following link also i applied but no use, still same error
[URL]
My application is running in IIS 7.0 with DefaultAppPool. In my web.config, i have used this authentication,
<authentication mode="Windows"/>
View 3 Replies
Feb 7, 2010
i have different tables for product details, images, category mapping
is there any way to import/export products by excel file in database along with category mappying and pictures in one go rather that importing just the products and then categorizing each product and adding image one by one ?
View 4 Replies
Jan 7, 2013
Importing contacts from facebook to excel using asp.net
View 1 Replies
Apr 13, 2010
import/export wizard in 2000 had lots of options.
I could copy databases without a care in the world. Including constraints, stored proc., AND the data, etc.
Now, with v2008, the wizard is dumbed down too much. It's a "stupid" copy function that fails on the first constraint it meets.
"Copy database.." is not an option here: it needs sysadmin on both source and destination server.
Re-adding the constraints manually is not an option either: the database is WAY too large.
I'm actually hoping there is a temporary bug in the import/export wizard. Each option (and you have THREE...) returns with a new error.
Googling, I found I am not alone:
http://itknowledgeexchange.techtarget.com/itanswers/sql-server-2008-export-data-problem/
This post is exactly my situation. Here's what his post says: (bolded key parts)
I'm trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy.
Firstly I created a new empty db on the local machine. Then I scripted the structure of the db on the remote machine and ran the resulting query on the local machine to copy the table structure into the new db. This gave me empty target tables to map to (see
below).
I used the export data wizard and selected my remote tables, then highlighted the tables to be copied and used the Edit Mappings option. Here I need to do two things, firstly checking'Enable Identity Insert' (because I have a unique id in most tables which is identity seeded, and I've read that if this is not checked sql server will helpfully renumber your entire table, rendering all your foreign key references useless). Secondly I need to decide what to do with the data already in the destination table. SQL 2k DTS simply dropped the destination table and recreated it. SQL 2008 will either keep the structure and delete the rows therein, or drop the table and recreate it. Because I intend to save this package and call it on a schedule in the future, I need to choose one of these options, because next time the target db won't be empty.
If I choose the delete rows option, when the package runs I get the following error when the process gets ot the first table with an identity ID which is used elsewhere in the db as a foreign key.
Error 0xc002f210: Preparation SQL Task 4: Executing the query "Truncate TABLE [dbo][tblCompany] failed with the following error 'Cannot truncate table tblCompany because it is being referenced by a foreign key constraint. Possible failure reasons: Problems with the query, "Result Set" property not set correctly, parameters not set correctly or connection not established correctly'
Half a dozen preceding tables did seem to transfer fine, but the process falls down on this one table. What I want is for the process to ignore constraints whilst it does the backup.
Undeterred I tried the other option, dropping each table and creating a new version. This time I get the error:
Error 0cx0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code 0x80004005. An OLE DB record is available. Source MS SQL Server Native Client 10.0. Hresult 0x80004005 Description "The statement has been terminated".
An OLE DB record is available. Source MS SQL Server Native Client 10.0. Hresult 0x80004005 Description "Violation of Primary Key constraint 'PK_LoginClasses'. Cannot insert duplicate key in object 'dbo.LoginClasses'.
Then I try unchecking the Enable Identity Insert option to see what happens. This happens:
- Validating (Error)Messages
Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column "UserID".
(SQL Server Import and Export Wizard)
Error 0xc0202045: Data Flow Task 1: Column metadata validation failed.
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task
1: "component "Destination - Login" (40)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)Error 0xc004700c: Data Flow Task 1: One or more component failed validation.
(SQL Server Import and Export Wizard)
Error 0xc0024107: Data Flow Task 1: There were errors during task validation.
(SQL Server Import and Export Wizard)
I can't see any more options to try. So how do I get SSMS 2008 to do what Enterprise Manager 2k did with no drama?
View 11 Replies
Feb 23, 2010
I have to export some data from excel to sql server. So, I just used simply Import/Export wizard from Management Studio.
Fill up and set the all necessary according to this wizard, after that I saved as SSIS Package.
Because, I have to run this package several time, but unfortunately, I can't find it where she saved it.
That may be funny, but really i can't find it out So, How to i save this package?
View 2 Replies
Apr 13, 2010
I need to be able to have a user upload an excel file, then immediately work with that file and save the contents in a database.
I know how to do this if I save the file first, then open it using OleDB, BUT I would rather not save it first.
View 3 Replies
Jun 28, 2010
Im trying to upload file (lets say .xls file) but i need to check if the file type is macth with it binary. for example we can renamefileA.mp3 as fileA.xls on our windows and upload it. i need to check this first. can anyone suggest me how to check this file type ?based from what I browse, I found that BInaryReading can do it. here is the code
[Code]....
this check correctly. BUT, once it returns TRUE (when FileA.xls is really an XLS file), the POSTED FILE content will be 0. and the upload went file (the SAVEAS works) , and the file copied to the specified directory. but the content is 0 and when i open it, it said that the file is corrupted.i think this is due to the BINARY READER. is that true ? because before above method called, i make a breakpoint and the POSTEDFILE content length is still 16kb. after the method called, its 0.
View 5 Replies
Aug 19, 2010
I have recently upgraded my system from Visual Studio 2008 to Visual Studio 2010. I have MS SQL Server 2008 RS installed as well as IIS7 and I am able to connect to my web application on my local server (IIS7).
View 1 Replies
Oct 18, 2010
I have an application that lets the use upload a pdf, I wanted to put a limit on the size the pdf can be. If the user tried to upload something too big I wanted to display a message to the user. I am trying to use a custom validator where it checks the size of the file and if it is too big it will set the "IsValid" to false. Is this the correct way to go about doing this? Is there a better way? When I test it, everything works in IE 8 and FF, but it does not work in IE 7 and can't figure out why.Here is what I have so far, this is on my aspx page:
[Code]....
And this is the code behind:
[Code]....
View 6 Replies
Apr 19, 2010
I have implemented a validation for the file upload control such that, only when some entry is made in the file upload control textbox, the Upload button will be enabled else it wil be disabled.
When I implemented this , the validation on the Upload button is not working. For the upload button I need to check certain fields are not empty. But I find that because of the above implementation, the validation function for this one is not working .
View 7 Replies
Aug 12, 2010
I have an upload control inside a panel and I am wanting to restrict the file types. I have found the following regExp but I'm unsure where to put it?
ValidationExpression="^(([a-zA-Z]:)|(\{2}w+)$?)(\(w[w].*))(.doc|.PDF|.gif|.jpg)$"
Does this go into the 'ValidationGroup' within the upload button?
View 5 Replies
Oct 12, 2010
how to validate a file upload control to allow maximum "100kB" Size images.if exceed it should fire a asp validation"file size must be 100KB maximum".
View 2 Replies
May 8, 2013
i have a file upload control to upload picture.i want the user can only upload picture not any other file . when i used file upload control ,user can insert word file also,this should not be done. user can only insert pictures,otherwise message should be appear
View 1 Replies
Apr 27, 2016
I want to code for csv file upload and read gridview in visual stuio 2010 MVC 4 ....
View 1 Replies
Mar 2, 2011
have a gridview in that i have checkbox and file upload controls and common submit button outside gridview.if i checked a row checkbox and i need to check whether the file upload control contains any value or not.if checkbox is checked and file upload control contains values then i will insert the details into database table.if not means i will show a message. if not checked means its not a problem no need to validate the control. how to do this..
View 4 Replies
Jun 8, 2010
I like how the "Html.ValidationMessageFor" and "Html.ValidationSummary" helpers work for validating textboxes, such as for required fields. Is there some way I can accomplish the same thing for a file input control? From the examples I've seen so far you cannot directly bind a file upload to your model, so I can't use the [Required] attribute that I am using for the textboxes.
View 10 Replies
Apr 23, 2010
I have a data import page where I start the Import by clicking a button.Second by second I want to print in Web Page informations about record is being importing.
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="CurrentTimePanel" runat="server">
<ContentTemplate>
<asp:Label ID="CurrentTime" runat="server" Text="Now: " />
[code]...
View 5 Replies
Aug 17, 2010
My MVC 2 app includes a simple file upload within in a strongly typed view and I am trying to figure out how to apply model validation to the file name. Is this possible? Is there better way to do file upload within an MVC app?
The salient parts of the (prototype) controller code are:
[Code]....
The Create view code was generated with VS2010 and then modified to support file upload and client side validation:
[Code]....
View 3 Replies
