RE: [development-axapta] Axapta Upgrade
Thanks Jim I understand your approach now...I thought originally you just took a 2.5 and put SP5 on it!!! Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chwaszczewski, Jim Sent: 24 March 2006 00:25 To: development-axapta@yahoogroups.com Subject: [development-axapta] Axapta Upgrade Hi James. Interesting is definitely the word for Axapta upgrades. The service pack brings in new SYP, GLP, DIP layers. I do the code upgrade to the current release and service pack. I then open the old 2.5 database with the new application which starts the whole data upgrade. There are separate ReleaseUpdateDB... classes for moving the data from 2.5 to 3.0 and then from 3.0 to the current SP. So far, I haven't had any major problems. According to Microsoft, Axapta service packs are cumulative so if a service pack becomes a required stopping point on the way to another release, then it shouldn't be a service pack, it should be a new release like 3.5. I definitely put up a fuss when Microsoft creates more problems for upgrades. Upgrades take enough time as is and it hard to bill clients for extra work caused by Axapta's developers (we end up eating the time). With all that said, I have a great time working with Axapta. I'm looking forward to seeing 4.0. Jim Chwaszczewski [EMAIL PROTECTED] Message: 1 Date: Wed, 22 Mar 2006 08:57:36 +0900 From: James Flavell [EMAIL PROTECTED] Subject: RE: Digest Number 1713 Supposedly the install doc says need to upgrade 2.5 to 3.0 BUT then do not start Axapta...rather just apply SP5. So basically each version is a milestone I would say Interesting as it sounds like you say you have not taken this approach but gone directly to the service pack...I am just wondering does that not mean your SYS layer is actually a 2.5 version? In theory the SP should only bring in a SYP layer Interesting Thanks James _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . _ [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Axapta Opening in US/India
Hi All, This is Rashmi from Ignify. I am look after the recruitments at Ignify. We have an opening in Axapta and if you are interested in the please send your resumes to me. We have different opening available in Axapta/ERP. Though we would prefer someone with a valid US visa for our US office, we also have a few openings for our India office. Ignify, Inc. is a niche player in web applications and the mid-market Accounting system space. One of the focus areas for the company is Microsoft Business Solutions. We have a development center at Pune and offices in USA, UK, Canada and Singapore. Ignify, India is a 100% owned subsidiary of Ignify, US. At Ignify, it's desirable to have hands on knowledge of relevant products at all levels including management. Ignify is a Microsoft Business Solutions Developer, Microsoft Gold Certified Partner, ACCPAC Development Partner, Sage Certified Developer, Certified Wireless Consulting Provider. Please reply at the earliest. Regards, Rashmi Ignify, Inc. Excellence in Technology Tel: +91-20-26120778 Fax: +91-20-26120780 Email: [EMAIL PROTECTED] www.Ignify.com Los Angeles. Silicon Valley. Toronto. India Microsoft Gold Certified Partner Sage Certified Developer ACCPAC Development Partner Certified Wireless Consulting Provider Ignify eCommerce - Making Online Sales Profitable YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: SV: SV: [development-axapta] Working with Excel through Axapta
Hi Mikael,
Your code was very helpful! Thanks so much :)
One part of my problem is solved. Now, i'm able to export Ax data to
excel.
My other requirement is to import the excel data into Axapta. For
this i wrote the following code...
---
SysExcelApplication excel;
SysExcelWorkbooks books;
SysExcelWorkbook book;
SysExcelWorkSheets sheets;
SysExcelWorkSheet sheet;
str _filepath = C:\\SatishExcelTest.xls;
loginProperty loginProperty = new LoginProperty();
ODBCConnection odbcConnection;
Statement sql;
ResultSet resultSet;
str sqlstr = 'select studid,name,age from [Sheet1
$]';
;
super();
try{
excel = SysExcelApplication::construct();
books = excel.workbooks();
books.open(_filepath);
sheets=excel.worksheets();
sheet=sheets.itemFromNum(1);
loginProperty.setDSN('SatishExcelTestODBC'); // (Name of
your ODBC configuration)
odbcConnection = new ODBCConnection(loginProperty);
sql = odbcConnection.createStatement();
resultSet = sql.executeQuery(sqlstr);
// select data from excel and input fields into our table
while(resultSet.next()) {
satishTable.StudId=resultSet.getString(1);
satishTable.Name=resultSet.getString(2);
satishTable.Age=resultSet.getInt(3);
}
resultSet.close();
books.close();
}
catch {
books.close();
}
---
When i run this code, i get an error message 15:37:59 which
says [Microsoft][ODBC Excel Driver] The connection for viewing your
linked Microsoft Excel worksheet was lost.
Pls help!!! :(
Regards,
Satish Dalal
--- In development-axapta@yahoogroups.com, Mikael Dalgård (GPV
International A/S) [EMAIL PROTECTED] wrote:
Hi Satish
Example: (included Excel file, place the included file like this:
C:\filename.xls)
Source code, look below:
--
static void COMExcelExample(Args _args)
{
custtable customers;
SysExcelApplication SysExcelApplication;
SysExcelWorksheet SysExcelWorksheet;
SysExcelWorksheets SysExcelWorksheets;
SysExcelWorkbooks SysExcelWorkbooks;
SysExcelWorkbook SysExcelWorkbook;
SysExcelRange SysExcelRange;
SysExcelCell SysExcelCell;
SysExcelCells SysExcelCells;
COMVariant COMVariant1;
#excel
int i = 1, whilecount;
SysOperationProgress progress = new SysOperationProgress();
;
while select count(RecId) from customers
WhileCount = customers.RecId;
sysExcelApplication = SysExcelApplication::construct();
sysExcelApplication.visible(false);
sysExcelWorkbooks = sysExcelApplication.workbooks();
COMVariant1 = new COMVariant();
COMVariant1.bStr('c:\\filename.xls');
sysExcelWorkbook = sysExcelWorkbooks.add(COMVariant1);
SysExcelWorksheets = sysExcelWorkbook.worksheets();
SysExcelWorksheet = SysExcelWorksheets.itemFromNum(1);
SysExcelRange = SysExcelWorksheet.cells().range
(#ExcelTotalRange);
progress.setCaption('Progress');
progress.setText(strfmt('%1 - %2','Exporting customers to
Excel','Please wait'));
progress.setTotal(whileCount);
while select * from customers
if (customers)
{
i++;
SysExcelCell = SysExcelWorksheet.cells().item(i,1);
SysExcelCell.value(customers.AccountNum);
SysExcelCell = SysExcelWorksheet.cells().item(i,2);
SysExcelCell.value(customers.Name);
progress.incCount();
}
sysExcelApplication.visible(true);
}
--
Hope you'll find this helpful :-)
Best regards
Mikael Dalgaard
-Oprindelig meddelelse-
Fra: Mikael Dalgård (GPV International A/S)
Sendt: 23. marts 2006 09:03
Til: 'development-axapta@yahoogroups.com'
Emne: SV: SV: [development-axapta] Working with Excel through
Axapta
Hi Satish
... xinfo::directory(directoryType::Appl) is the Axapta appl.
path, if you would like to use [C:\] instead, like
this: C:\\satishExcelTest.xls, try to change the COMVariant1 code
into:
COMVariant1.bStr('C:\\SatishExcelTest.xls');
Best regards
Mikael Dalgaard
-Oprindelig meddelelse-
Fra: development-axapta@yahoogroups.com [mailto:development-
[EMAIL PROTECTED] På vegne af Satish
Sendt: 22. marts 2006 14:19
Til: development-axapta@yahoogroups.com
Emne: Re: SV: [development-axapta] Working with Excel through
Axapta
Hi Mikael,
Thanx a lot for ur help!
However, I'm unable to use the COMVariant part of ur code;
especially the part where
COMVariant1.bStr(xinfo::directory(directoryType::Appl)
+ 'C:\\SatishExcelTest.xls);
The compilation of this line was giving a syntax error. I'm really
new to Axapta, so i couldn't get it cleared... :(
Can u suggest a remedy for this? :)
Thanks,
Satish
--- In development-axapta@yahoogroups.com, Mikael Dalgård (GPV
International A/S) mid@ wrote:
Hi there
Try this :-)
SysExcelApplication SysExcelApplication;
SysExcelWorksheet SysExcelWorksheet;
SysExcelWorksheets SysExcelWorksheets;
SysExcelWorkbooks SysExcelWorkbooks;
SysExcelWorkbook SysExcelWorkbook;
SysExcelRange SysExcelRange;
SysExcelCell SysExcelCell;
Re: [development-axapta] WINAPI, MoveFile, Moving Files
this is working.
static void Job1(Args _args)
{
try
{
WINAPI::moveFile(C:\\example.txt,C:\\example.dat);
}
catch
{
}
}
if not check the moveFile method in winapi class
My moveFILE method is like this
client server static int moveFile(str fileName, strnewFileName)
{
DLL _winApiDLL = new DLL(#KERNELDLL);
DLLFunction _moveFile = new DLLFunction(_winApiDLL,'MoveFileA');
_moveFile.returns(ExtTypes::DWord);
_moveFile.arg(ExtTypes::String,
ExtTypes::String);
if (_moveFile.call(fileName, newFileName) == 0)
return WinAPI::getLastError();
return 0;
}
Mike Savage yazm#305;#351;:What am I doing wrong?
I have a file that, when I have read it, I wish to move. I can use
WINAPI::CopyFile and it copies it, but WINAPI::MoveFile does nothing!!
In 25 you had to do a file.finalise() but you can't call that in 30 as
it is protected.
Any clues?
Cheers
Version 3, Service Pack 4.
Mike Savage
Sense Enterprise Solutions Ltd
[Non-text portions of this message have been removed]
-
YAHOO! GROUPS LINKS
Visit your group development-axaptaon the web.
To unsubscribe from this group, send anemail to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
--090005000105050503040607--
-
New Yahoo! Messenger with Voice. Call regular phones from your PC for low, low rates.
[Non-text portions of this message have been removed]
SPONSORED LINKS
Computer part
Programming languages
Microsoft axapta
Support exchange
YAHOO! GROUPS LINKS
Visit your group "development-axapta" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
SV: [development-axapta] WINAPI, MoveFile, Moving Files
It's probably because your file is still open. If you have read your file with a io-class (asciiio, binaryio, commio) you should null your io-class to close the file. Fra: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af Mike Savage Sendt: 23. marts 2006 17:46 Til: development-axapta@yahoogroups.com Emne: [development-axapta] WINAPI, MoveFile, Moving Files What am I doing wrong? I have a file that, when I have read it, I wish to move. I can use WINAPI::CopyFile and it copies it, but WINAPI::MoveFile does nothing!! In 25 you had to do a file.finalise() but you can't call that in 30 as it is protected. Any clues? Cheers Version 3, Service Pack 4. Mike Savage Sense Enterprise Solutions Ltd [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
