Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Error after installing 2.4.09

Greetings

I installed the new scripts today and have started receiving a check files error.



When I go into the logs, it shows the following:

10:34:47 --- Starting script psCheckFiles.ps1
10:34:47 File Dates.csv. Record count: 1525
Dates.csv. Row count - must be at least 2 (header and at least one date) - OK
Dates.csv. First row (file header) should be 'Date' - OK
Dates.csv. All but first row (header) should be in format YYYY-MM-DD - OK
Dates.csv. Minimum date in file should be configured MinDate - OK (2014-12-31)
Dates.csv. Maximum date in file should be today - OK (2019-03-03)
Dates.csv. Dates should be unique - OK
10:34:47 File Dates.csv check completed. No issues found.
10:34:47 File Quotes.csv. Record count: 2874
Quotes.csv. Row count - must be at least 2 (header and at least one record) - OK
Quotes.csv. First row (file header) should be 'Date Close Symbol' - OK
Quotes.csv. Each row should have exactly two column separators (' ') - ERROR. Bad records bellow:


But then there is a huge blank area, and then it continues with

Quotes.csv. All rows should have 'Date' column in format YYYY-MM-DD - OK
Quotes.csv. Minimum date in file should be after configured MinDate - OK (2014-12-31)
Quotes.csv. Maximum date in file should be today or before - OK (2019-03-01)
Quotes.csv. Date+Symbol should be unique - OK
10:34:48 File Quotes.csv check completed. Errors found - please review
10:34:48 File Dividends.csv. Record count: 2
Dividends.csv. Row count - must be at least 1 (header) - OK
Dividends.csv. First row (header) should be 'PayDate DividendPerShare Symbol' - OK
Dividends.csv. Each row should have exactly two column separators (' ') - OK
Dividends.csv. All rows should have 'PayDate' column in format YYYY-MM-DD - OK
Dividends.csv. Minimum date in file should be configured MinDate - OK (2014-12-31)
Dividends.csv. Maximum date in file should be today or before - OK (2014-12-31)
Dividends.csv. Date+Symbol should be unique - OK
10:34:48 File Dividends.csv check completed. No issues found.
10:34:48 File CurrencyConv.csv. Record count: 1642
CurrencyConv.csv. Row count - must be at least 1 (header) - OK
CurrencyConv.csv. First row should be 'Date ExchRate CurrencyFrom CurrencyTo' - OK
CurrencyConv.csv. Each row should have exactly three column separators (' ') - OK
CurrencyConv.csv. All rows should have 'Date' column in format YYYY-MM-DD - OK
CurrencyConv.csv. Minimum date in file should be configured MinDate - OK (2014-12-31)
CurrencyConv.csv. Maximum date in file should be today or before - OK (2019-03-01)
CurrencyConv.csv. Date+CurrencyFrom+CurrencyTo should be unique - OK
10:34:48 File CurrencyConv.csv check completed. No issues found.
10:34:48 --- Finished. Duration: 2 sec.


Any thoughts?

Thanks :)

Comments

  • One of the optimizations introduced in this version - to remove code that removed empty lines from Ouotes.csv file, as this was taking very long time for very large file. I will review that tonight, but you can also check your files in Quotes folder and remove empty lines.
  • I went in and deleted all the empty lines in between the various quotes, and then re-ran the script file and the same error occurred. I went and looked at the quotes file again and it had inserted the lines again.
  • You should delete empty lines in the files in Quotes folder. Do not change quotes CSV file.
  • I went into the quotes folder and looked through the individual quote files and none of them seem to have empty lines in them.
  • Can you please send me your Quotes.csv file? I will look into this.
  • If the empty lines in Quotes.csv file are close to the end of the file, then these empty lines might come from intraday quotes file. I already have a fix for that.
  • There is a blank line between each of the quotes in the csv file

  • OK, thank you! Fix will be out very soon.
  • Fix was just released and available for download from Download page.
  • The downloads page still shows:

    Download v2.4.09 (2019-Mar-02): External data Download and Management script set (for majority of users).
  • Try to do CTRL+F5 to clear the browser cache or use different browser.
  • The new scripts worked like a charm.

    Thank you for your help :)
Sign In or Register to comment.