Forum Discussion
CodnChips
Nov 14, 2023Brass Contributor
Watchlist Bulk Update - Failed to Read File (But does!)
Hi, I've been updating watchlists with no issues for ages. Since yesterday, after selecting the file (which is a basic CSV file), the 50 rows preview is presented, a green ticket is shown next to t...
- Dec 06, 2023HIya, It has started working again - I had to move on with life, so it was quicker to spin a new watchlist & edit the relative analytical rule.
(Someone's first day at work? :D)
Torsten365
Nov 20, 2023Copper Contributor
I had the same problem. I was also able to upload a *.csv file, but I couldn't complete the wizard.Here's how I solved the problem. I edited the *.csv file again and arranged the columns so that the column with the most entries is displayed first (column A) and then the other columns are ordered in descending order so that the column with the fewest entries is displayed last.
Give it a try, maybe it will help you.
Give it a try, maybe it will help you.
CodnChips
Nov 20, 2023Brass Contributor
Thanks for the input. However in my watchlist every row has all columns populated, therefore all are equal - glad it worked for you though. I don't have the time for MS to acknowledge\fix so I had to export the original watchlist, append the data, create a new watchlist and adjust the pointers in the relevant analytical rule. For me, these have to stay up to date so unfortunately have to move on with the workaround (Which I'm not a fan of & would much prefer an actual resolution\answer) 🙂
- TheDillyNov 20, 2023Copper ContributorCodnChips Have you tried to update again recently? It started working again for me later on the 15th and I haven't seen the problem since. I assumed they fixed whatever the glitch was.
- CodnChipsDec 06, 2023Brass ContributorHIya, It has started working again - I had to move on with life, so it was quicker to spin a new watchlist & edit the relative analytical rule.
(Someone's first day at work? :D)