›

Howdy, Stranger!

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

Sign In Register

Quick Links

Categories

Error after installing 2.4.09

dstirlingdstirling
in External Data Files
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

  • VidasMatelisVidasMatelis
    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.
  • dstirlingdstirling
    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.
  • VidasMatelisVidasMatelis
    You should delete empty lines in the files in Quotes folder. Do not change quotes CSV file.
  • dstirlingdstirling
    I went into the quotes folder and looked through the individual quote files and none of them seem to have empty lines in them.
  • VidasMatelisVidasMatelis
    Can you please send me your Quotes.csv file? I will look into this.
  • VidasMatelisVidasMatelis
    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.
  • dstirlingdstirling
    There is a blank line between each of the quotes in the csv file

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

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

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