Problems importing an ASCII file

AmiBroker
1

Hello,

I have some problems to import an ASCII file. I have done it before, using the same imported file and the same "defaut.format" file without any difficulty. But now, I get an error message. Probably it is an obvious issue, but I am unable to find what I am doing wrong.

The extension of the three files, "defaut.format", imported file, and the error message, are not authorised to be uploaded here, so I copy them next:

DEFAUT.FORMAT

$FORMAT Ticker, FullName, Currency, Market, Group, Watchlist, Alias, ICB, Industryname
$OVERWRITE 1$
$SEPARATOR ;
$CONT 1
$GROUP 255
$AUTOADD 1
$NOQUOTES 1

IMPORTED FILE

IWM;ISH Russell 2000;USD;2;12;58;N/A;N/A;N/A
EEM;ISH MSCI Emerging Markets;USD;2;12;58;N/A;N/A;N/A
EFA;ISH MSCI EAFE;USD;2;12;58;N/A;N/A;N/A
IEV;ISH Europe;USD;2;12;58;N/A;N/A;N/A
EWJ;ISH MSCI Japan;USD;2;12;58;N/A;N/A;N/A
FXI;ISH China Large-Cap;USD;2;12;58;N/A;N/A;N/A
etcetera

ERROR MESSAGE

Logging started for 'F:\0 TEXTOS\03 INVERSIONES\INVERSIONES 2018\6 Exportación\180127 - Exportación general Tiingo.csv' file, using format definition file 'Formats\FONDOS_EUR.format'
Error in line IWM;ISH Russell 2000;USD;2;12;58;N/A;N/A;N/A
Invalid date format/value
Error in line EEM;ISH MSCI Emerging Markets;USD;2;12;58;N/A;N/A;N/A
Invalid date format/value
Error in line EFA;ISH MSCI EAFE;USD;2;12;58;N/A;N/A;N/A
Invalid date format/value
Error in line IEV;ISH Europe;USD;2;12;58;N/A;N/A;N/A
Invalid date format/value
Error in line EWJ;ISH MSCI Japan;USD;2;12;58;N/A;N/A;N/A
Invalid date format/value
Error in line FXI;ISH China Large-Cap;USD;2;12;58;N/A;N/A;N/A
Invalid date format/value
etcetera

I will appreciate any help.

Best regards

2

Hello,

I got the problem, the last time I used the Import Wizzard, I selected the option "Add current settings to ACSII importer definitions". The programme was using the saved file instead of the usual "defaut.format" one, i did not realized of it.

Best regards.

3

@jptrader

Good to see that you solved it, but the answer was already in the log.
You imported the file with the specification of 'FONDOS_EUR.format' and not using the 'default.format' as you supposed.

Each time the Import ASCII procedure is used, it is a good practice to verify what item is currently selected in the open file dialog:

immagine

1 Like