New Date Import Test check capability

 

When you import in new data you must carefully match the date format to the format of your csv spreadsheet.

If you did not map the dates correctly an error would occur and none of the data would be imported or it might be imported for the wrong date period!

There is now a new Test button to help you map across the date fields accurately

There is now a new Test button to help you map across the date fields accurately

 

Select the Date format that you think matches the Date format from your spreadsheet and click on "Test"

Select the Date format that you think matches the Date format from your spreadsheet and click on "Test"

#1: Click on the dropdown and match the date format from your spreadsheet to a format from the dropdown.

#2: Click on the Test button.

If the message that appears says "Converted" you have selected the correct date format.

If the message that appears says "Converted" you have selected the correct date format.

Look for the Converted message and also check that it will import for the correct date (GMT is short for Greenwich Mean Time). Click OK and continue with the import.

If it says ERROR: Missing value, this means there is no data in the column that you are trying to import. The import will work because no dates are entered

If it says ERROR: Missing value, this means there is no data in the column that you are trying to import. The import will work because no dates are entered

The image here shows the message "ERROR: Missing value in row 1, 2,, 3 etc). This means that the system is trying to correctly match the dates from one of the date columns, but there was no data in that column row to map to. You will see this error when you have a blank cell in a date column. As long as any other date fields in that column say that they are mapped correctly, the data will import successfully.

If the message says "ERROR - Could not convert" then you MUST select a different date format or your data won't import

If the message says "ERROR - Could not convert" then you MUST select a different date format or your data won't import

If the message says "ERROR- could not convert" you MUST select a different date format (as shown in the image below)

If you had an error, check the data format again and try a different Date format. Click on Test again. Keep trying until Converted appears

If you had an error, check the data format again and try a different Date format. Click on Test again. Keep trying until Converted appears

#1: Look at your date format again

#2: Click on the dropdown and select a different date format that matches your spreadsheet

#3: Click on the Test button

-If "Converted" appears in message continue with the import. If "Error-could not convert" appears keep on trying different formats.

0 Comments

Add your comment

E-Mail me when someone replies to this comment