Import/Upload directory (URGENT!!!)
-
I have a textbox with browse function in my web application. This will able user from the web to import or upload their data in CSV file into my SQL Server place at my factory. The problem is user in my factory office domain can import the file through the directory browse from My Network Place and proceed to import the csv file into the server. But, user not in my domain but from outside country or other location cannot import the CSV through the textbox with directory browse function. They alwasy get the error with "network path not found". How can i solve this problem to enable user around the internet to proceed import their csv file into my server using this textbox with directory browsing function? I give every user the bulk insert right for this system. Thank you for advice.
-
I have a textbox with browse function in my web application. This will able user from the web to import or upload their data in CSV file into my SQL Server place at my factory. The problem is user in my factory office domain can import the file through the directory browse from My Network Place and proceed to import the csv file into the server. But, user not in my domain but from outside country or other location cannot import the CSV through the textbox with directory browse function. They alwasy get the error with "network path not found". How can i solve this problem to enable user around the internet to proceed import their csv file into my server using this textbox with directory browsing function? I give every user the bulk insert right for this system. Thank you for advice.
Young, Your question does not look clear, at least for me. 1-Your SQL Server is located at a factory somewhere in the world 2-Your users are located either inside or outside your domain, meaning they could be reaching your application via intranet or internet 3-I'm assuming the CVS file is generated locally on the user's workstation located anywhere in the world and then they use your web application to upload it to a web server to then submitted to an SQL DTS package to update your database 4-Is the network path embedded or forced somehow in the path of the object? the object is the directory bworser not the web browser. 5-You have no problem using the textbox with directory browsing function as you called it, you just have to be aware that the application is assigned with the Write permission to the directory where users will upload the CVS file on your web server. 6-There could also be an error formatting the path of the file. Could you please post code? Please let me know if this make sense for you or if I'm assuming things in the wrong way. Regards, David
-
Young, Your question does not look clear, at least for me. 1-Your SQL Server is located at a factory somewhere in the world 2-Your users are located either inside or outside your domain, meaning they could be reaching your application via intranet or internet 3-I'm assuming the CVS file is generated locally on the user's workstation located anywhere in the world and then they use your web application to upload it to a web server to then submitted to an SQL DTS package to update your database 4-Is the network path embedded or forced somehow in the path of the object? the object is the directory bworser not the web browser. 5-You have no problem using the textbox with directory browsing function as you called it, you just have to be aware that the application is assigned with the Write permission to the directory where users will upload the CVS file on your web server. 6-There could also be an error formatting the path of the file. Could you please post code? Please let me know if this make sense for you or if I'm assuming things in the wrong way. Regards, David
You are right on the issue of 1, 2 and 3. But how about the issue 4th that you are mean by? FYI, i put my code some thing as this: Dim filetoread As String filetoread = File1.Value where the filetoread is the textbox text value after i browse for the file to be import to the server ay my place. IS this the problem that cause the network path not found issue from my directory browser? If this the matter, how can i solve this problem using the web browser as you mentioned? How the web browser code will look like? Any code exmaple or reference? Thank You, David.
-
You are right on the issue of 1, 2 and 3. But how about the issue 4th that you are mean by? FYI, i put my code some thing as this: Dim filetoread As String filetoread = File1.Value where the filetoread is the textbox text value after i browse for the file to be import to the server ay my place. IS this the problem that cause the network path not found issue from my directory browser? If this the matter, how can i solve this problem using the web browser as you mentioned? How the web browser code will look like? Any code exmaple or reference? Thank You, David.
Yong, I'm assumming you're using an HTML INPUT object type="File", which comes with a button embedded that once you click it opens a LOCAL directory browsing to select a file from the local workstation, users should select the file and then you should be processing that file saving it on a directory on your web server right! If the application is the same for everybody, there should not be any different between the 2 groups (local users and internet users), it is the application itself with rights or not to the directory where you upload the CVS file to later use on your SQL Server. How do you authenticate users? I don't know but it looks like rights problems....
-
Yong, I'm assumming you're using an HTML INPUT object type="File", which comes with a button embedded that once you click it opens a LOCAL directory browsing to select a file from the local workstation, users should select the file and then you should be processing that file saving it on a directory on your web server right! If the application is the same for everybody, there should not be any different between the 2 groups (local users and internet users), it is the application itself with rights or not to the directory where you upload the CVS file to later use on your SQL Server. How do you authenticate users? I don't know but it looks like rights problems....
I set 'NONE' for the authenticate mode in my web config file of my ASP.NET application. For the SQL Server, i put NT AUTHORITY/Authenticated Users for the user for database that use by the application as well as dbo. So, are you sure that not problem i using directory browser in my application? Thank for advice.