[mchen]

Not complaining…just think it might be some performance issue.

I'm trying to do a CSV cleanup/update on a customer record.

2972 rows. I am doing an update on 2972 addresses in this customer record.

I didn't think it would take forever, so I thought I could cancel it and work on something smaller.

Now it's stuck on cancelling. Taking forever too.

still cancelling… over 10 minutes now. now just timing how long it will take to cancel this CSV upload. I'll send an update when it's done cancelling… *sigh* Cancelling…
This is a cached copy. Click here to see the original post.

[mchen]

yep, i am convinced that CSV upload is slow and problematic.

I'm updating 10 addresses in a customer record.

It's been 2 hours now. I can do this faster manually. I wonder why it takes CSV so slow.

This customer has 4076 addresses, 6289 sales order.

Is it because netsuite can handle storing this many addresses? so it's dying just to update 10 addresses…10 rows?

[mchen]

If netsuite cannot handle 4076 addresses in a customer record, wouldn't it be better just to add a limit.

It takes me about 8-9 seconds to load customer record, another 3 seconds to load 'address tab', then go through 10 address, and update it.

it take me no more than 5 minutes manually.

why does CSV upload take over 2 hours…

[mchen]

still uploading. i was thinking CSV updating to delete 2500 address, but if updating 10 addresses took 2+hours.

is this going to take me 20 days to do 2500?

it didn't take that long to process, just took forever to start it

[rnedelkow]

It may have been in queue to process. Worth noting that import jobs typically run faster during off-peak hours.

[mchen]

or it could be that csv import for customer address is terribly designed

[mchen]

running a test to csv update 1 customer address

no queue. started at 8:54am. be back in an hour when it's done

*took 10 minutes* for 1. i will try 2, and i wonder if it will take 20 minutes

the whole point of this is to check how long it would take to update over 2500 addresses in 1 customer record.

i will probably run it for 1 weekend, and see how long it takes.

then i have another 20 customers records after that…i guess line it up for 20 weeks?

[mchen]

took about 17 minutes for 2 customer address. okay slight better than 20 minutes

i will try to attempt csv update for 2500 this weekend.

but if i had hours to spare, i could do 2500 update manually in 6 hours.

sadly, it would probably be faster than CSV update.

well nothing else i can do here. just want to document how slow this is

[mchen]

tried updating 2500 addresses last weekend. fail. not sure why. no files to view.

not able to cancel the csv upload either. i just have to wait until it finishes and fail.

[mchen]

I decided to run try CSV again. I know my update would take many many many hours.

Dont worry, I was going to cancel when i see someone else want to use CSV upload.

…but now, it's not letting me cancel. I click on the link 'cancel', and it just refreshes and does nothing.

nothing. i've switched browser and same thing.

i've been clicking cancel for the past 40 minutes. I don't think it will let me cancel. it's probably going to run until the end.

CSV upload is so glitchy.

[Author]

Posts