Axaptapedia is now maintained by AgileCadence For more information please click here.

Axaptapedia talk:Community Portal

From Axaptapedia
Jump to: navigation, search

Excel to Axapta[edit]

How do I load an Excel file to Axapta

You have to use a tool called Promentum X3; It's a program written in VBA that interface Axapta Tables and Excel. It's very useful and strong, but you have to be careful to use it, because you change the database structure and data directly, just making a soft validation.


An other way is: Prepare a table you want to import your data into. Export this (empty) table to Excel. Fill this Exel file with your data and import this file.

Problem with file links[edit]

On my project page I have a number of download links to various version of my project. These don't appear to be working anymore. Any idea where the files went?

http://www.axaptapedia.com/index.php?title=Sales_Order_Status_Email_Generation


OK this is fixed. You were using a direct URL, but something is wrong with the "shortened" URLs sinc the move to the new server. I'll try to figure that out soon (hopefully tonight) but in the meantime I changed your links to a "standard" form which works OK. Let me know if you have any more issues AJ 04:39, 15 November 2006 (EST)


I've also fixed the short URL problem. Actually it's using even shorter URLs now, but the other ones will work correctly as well. This also means that old links from search engines work again...

AJ 13:42, 15 November 2006 (EST)

Problems at the synchronisation of the dates dictionary of the type of SQL. the version has failed.[edit]

hi. this is sunil.... While synchronizing a table InventTableModule i am getting some error messages. The messages are:

1.[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the index 'INVENTTABLEMODULE._dta_index_INVENTTABLEMODULE_10_1642488930__K22_K20_1_2_3_4_5_6', because it does not exist or you do not have permission.

2.SQL-instructie: DROP INDEX INVENTTABLEMODULE._dta_index_INVENTTABLEMODULE_10_1642488930__K22_K20_1_2_3_4_5_6

Very urgent require solution regarding webservices..[edit]

Very urgent require solution regarding webservices.. Hi All,

I am getting below error when i am calling webservice in axapta

" Method 'MSSoapInit' in COM object of class 'mssoap.soapclient30' returned error code 0x80020009 (DISP_E_EXCEPTION) which means: WSDLReader:XML Parser failed at linenumber 0, lineposition 0, reason is: The system cannot locate the resource specified.

HRESULT=0x1: Incorrect function.
- WSDLReader:Loading of the WSDL file failed HRESULT=0x80070057: The parameter is incorrect.
- Client:One of the parameters supplied is invalid. HRESULT=0x80070057: The parameter is incorrect."


below is the code which i have used

static void webservice_test(args _args) {

   WebService WebService;
   IO          xmlFile;
   container   c;
   int         i;
   str         xmlFileContent;
   ;
  
     WebService = new WebService(" http://localhost:8080/webtest/Service.asmx");

     xmlFile = SysDataIntegration::openFile("D:\\va\\wsst02.xml",'R',"");
     while (xmlFile.status() == IO_Status::Ok)
      {
       c = xmlFile.read();
       for (i=1; i<=conlen(c); i++)
       {
           if (xmlFileContent)
               xmlFileContent += "\n";
           xmlFileContent += conpeek(c,i);
       }
      }
   info ( WebService.OutboundInterface(xmlFileContent));

Note: if i run the webservice directly from browser it is working fine. Also same code was working few days back and all of sudden it stop working and giving the above error message

Thanks in advance sunil


How to Edit Images[edit]

Hello All,

I will thank you if you could help me with a solution to scan documents and edit images from Axapta, such as you can do with the MS Office image editor. We have version 4.0 and we need to link from DocuRef the captured images (multipage Tif format, black & white color, maximum size 70 Kb, resolution 200 x 200 dpi).

Patricia