Skip to Content
author's profile photo Former Member
Former Member

.csv file again

Hello friends;

I have this .csv file and I am trying to upload it upto PSA now, them later into data targets. It has 42289 records. I created a seperate .csv file for first 2 records and was able to upload those two successfully. but when I tried to upload the all file I got an error "Error 1 when loading external data" or sometimes I get "Error 4 when loading external data" it's the same file and same format. I just ctrlc, ctrlv to create file with 2 records.

what would be the reason. thank you.

sajita

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2004 at 09:23 PM

    It could be a couple of things most likely related to dates?

    1. Data somewhere in the larger file is using a different format than the 2 records you were uploading. Check dates.

    2. Your default user date format is different than the background user. (most like ALEREMOTE). You may need to change the USER ALEREMOTE to use the same format or change your file format...

    Hope that helps...

    Ken

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2004 at 10:23 PM

    Error 1 occurs when the file is still open while uploading the data.

    Make sure you close the file before clicking schedule button.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.