Import Budgets

BenSydney

Hi,

When we try to import budgets in RTC we get the message:
"Dates have not been recognised in the Excel worksheet".

We can however import the same budget in the Classic Client.

Anyone know a solution to this problem?

Thanks and Regards,
Ben

jkor1

Hi,

Just wondering if you have found a solution to the Import Budget error as we are getting the same error message.

Urbanplanen

You need to delete the column headers...

Alex_Chow

This seems like a bug to me. The import will work fine in the Classic client.

Alex_Chow

Here's the resolution to this:

Function: AnalyzeData:

Local variables:
Delete these two:
TestDate@1005 : Date;
TimePos@1009 : Integer;

Add this one:
TestDateTime@1005 : DateTime;

Code before:
ExcelBuf."Row No." = HeaderRowNo:
BEGIN
  TempExcelBuf := ExcelBuf;
  TimePos := STRPOS(TempExcelBuf."Cell Value as Text",' 00:00'); // Time part - only on Service Tier
  IF TimePos = STRLEN(TempExcelBuf."Cell Value as Text") - 5 THEN
    TempExcelBuf."Cell Value as Text" := COPYSTR(TempExcelBuf."Cell Value as Text",1,TimePos - 1);
  CASE TRUE OF
  TempDim.FIND('-'):

Code after:
ExcelBuf."Row No." = HeaderRowNo:
BEGIN
  TempExcelBuf := ExcelBuf;
  CASE TRUE OF
    TempDim.FIND('-'):

Code before:
EVALUATE(TestDate,TempExcelBuf."Cell Value as Text"):
BEGIN
  TempExcelBuf.Comment := Text014;
  TempExcelBuf.INSERT;
END;

Code after:
EVALUATE(TestDateTime,TempExcelBuf."Cell Value as Text"):
BEGIN
  TempExcelBuf."Cell Value as Text" := FORMAT(DT2DATE(TestDateTime));
  TempExcelBuf.Comment := Text014;
  TempExcelBuf.INSERT;
END;

BenSydney

Thanks Alex.

Thought is was a bug, until now kept on using 'classic' to import budgets.
Cheers,
Ben

jonesalden

Hi there, this is really informative post. Actually, I am here looking for information about benefits of import pages in import and export business, as I had my own business of import and export.

http://www.import-pages.com/