[development-axapta] RE: SysDataImportExcelClient Error

[Chwaszczewski, Jim]

I haven't used this class and don't do much importing, but from what I'm reading in SysDataImportExcelClient, it appears that the spreadsheet has to be in a certain format for Axapta.  Maybe someone else can shed some light here, but I believe the class is used to import a spreadsheet that was created/exported by Axapta.  The class seems to expect that the first 5 rows of the spreadsheet (see the clip below from macro "Excel" in the AOT) contain certain Axapta information.



The class returns a container of values that correspond to one row of the spreadsheet.  As the class examines each column, it looks for certain information in the corresponding column in the first five rows.  If the EnumRow (4) is zero (not a Enum TypeID), then it checks the TypeRow (3) for an extendedTypeID, otherwise it attempts to convert the cell value to an extendedTypeID. Because the class expects an internal extendedTypeID number in the spreadsheet leads me to suspect that Axapta is expecting a spreadsheet it created.  I hope this helps.



/*

 * Excel cell values

*/

#define.LabelRow(1)

#define.SheetInfoRow(2)

#define.TypeRow(3)

#define.EnumRow(4)

#define.NameRow(5)



Jim Chwaszczewski

Wipfli LLP





---------------------------

   Date: Thu, 17 Jun 2004 15:15:41 -0600

   From: "Ing. Gonzalo Bastos S." <[EMAIL PROTECTED]>

Subject: Error



Hi Jim Chwaszczewski Thanks for your advice, It' s really help me, but when I try to importthe Template this error is presented:I'll appreciate If you can help me...Error al ejecutar c�digo: SysDictType objeto no inicializado.



Seguimiento de pila:

\Classes\SysDictType\baseType

\Classes\SysDataImportExcelClient\read - line 47

\Classes\SysDataImportExcelServer\sheet2Table - line 53

\Classes\SysDataImportExcelServer\importSheets - line 53

\Classes\SysDataImportExcelServer\run - line 7

\Classes\SysDataImport\main - line 10

\Classes\FormFunctionButtonControl\Clicked

Best Regards.Ing. Gonzalo Bastos Stephens      Dpto. de Ingenier�a     Columbus IT Partner 

  

--------------------------------------------------------

 

The content of this E-mail and any attached files is confidential, and may be subject  

to certain privilege.  This email is intended for the designated recipient(s) only.   

If you have received this E-mail in error, please immediately contact the sender. 

  

WIPFLI LLP 

Business experts.  Right from the start. 

 



[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.