Hi,

I have a table with single integer field (RandomSeqNo), and tried to import a csv file to it. This file container two column, RecordID and RandomSeqNo.

It is around 1000000 records. 

While import via method import UI, it keeps giving me this error message (followed), how can I reolve this? Seems that if I reduce data to be smaller, I can make it. 

Is there anything wrong with my csv file? or some limitation to import size? Thanks.

---

Server Error in '/MethodImpex' Application.

Runtime Error

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. 

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="Off"/>
    </system.web>
</configuration>

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.

<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
    </system.web>
</configuration>

Hi Alex,

Importing a large quantity of records at one time can cause errors. Try splitting your CSV file into smaller CSV files and importing them like that.

- Justin

Hi Justin,

Thanks. what is the limitation of record number for one import? 1000000 records is what I need for my client's program, if this limitation is small, that could mean a lots of import. any other way to work around it?

--

Alex

Alex,

There's no official limit. The more records you're importing, the greater chance there will be an issue. If you have 1000000 records, I'd say start with 50000.

- Justin

Hi Justin,

Thanks. It works. 

--

Alex