Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
VendTable and CustTable i did the export and gave it to client to fill it up with their actual data. after recieving it i tried to import using same definition group and it gave an error -Tushar Nitesh [EMAIL PROTECTED] wrote: Hi Tushar, Which Table you are trying to import ? On Thu, Mar 27, 2008 at 3:17 PM, Tushar Joshi [EMAIL PROTECTED] wrote: Did not get you. which format we need? -Tushar Dharmanadi [EMAIL PROTECTED] wrote: Hi, Checked your excel format also for example Ledger table Regards, - From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Nitesh Sent: Friday, March 21, 2008 6:56 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax Hi Tushar, seems Record already exist in Table . From Import Dialog box go to Import Rule Tabpage and select the Option clear table before Import from Import Rule field. Regards Nitesh On 3/21/08, Tushar Joshi [EMAIL PROTECTED] wrote: Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now. - Did you know? You can CHAT without downloading messenger. Click here - Meet people who discuss and share your passions. Join them now.
RE: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Cristina, How to import from a *.csv file? i saved my excel into a .csv type of file but when trying to import it through import option it does not allow me to select the file of tyep .csv!! -Tushar Cristina Carcelén [EMAIL PROTECTED] wrote: Try to import from an *.csv file. Maybe you have some blanks records. - De: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] En nombre de Tushar Joshi [EMAIL PROTECTED] Enviado el: viernes, 21 de marzo de 2008 20:18 Para: Axapta-Knowledge-Village@yahoogroups.com Asunto: Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax Hi Nitesh, Thanks a lot for reply! but i tried this already... i have a doubt... if i try to import a single record then it is success but when i try to import another one it syas record already exists is it something to do with Number Sequences??? would appriciate if u cud throw some light on this :) Tushar Nitesh [EMAIL PROTECTED] wrote: Hi Tushar, seems Record already exist in Table From Import Dialog box go to Import Rule Tabpage and select the Option clear table before Import from Import Rule field. Regards Nitesh On 3/21/08, Tushar Joshi [EMAIL PROTECTED] wrote: Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now. - 5, 50, 500, 5000 - Store N number of mails in your inbox. Click here. #ygrp-mkp { BORDER-RIGHT: #d8d8d8 1px solid; PADDING-RIGHT: 14px; BORDER-TOP: #d8d8d8 1px solid; PADDING-LEFT: 14px; PADDING-BOTTOM: 0px; MARGIN: 14px 0px; BORDER-LEFT: #d8d8d8 1px solid; PADDING-TOP: 0px; BORDER-BOTTOM: #d8d8d8 1px solid; FONT-FAMILY: Arial } #ygrp-mkp HR { BORDER-RIGHT: #d8d8d8 1px solid; BORDER-TOP: #d8d8d8 1px solid; BORDER-LEFT: #d8d8d8 1px solid; BORDER-BOTTOM: #d8d8d8 1px solid } #ygrp-mkp #hd { FONT-WEIGHT: bold; FONT-SIZE: 85%; MARGIN: 10px 0px; COLOR: #628c2a; LINE-HEIGHT: 122% } #ygrp-mkp #ads { MARGIN-BOTTOM: 10px } #ygrp-mkp .ad { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-mkp .ad A { COLOR: #ff; TEXT-DECORATION: none } #ygrp-sponsor #ygrp-lc { FONT-FAMILY: Arial } #ygrp-sponsor #ygrp-lc #hd { FONT-WEIGHT: bold; FONT-SIZE: 78%; MARGIN: 10px 0px; LINE-HEIGHT: 122% } #ygrp-sponsor #ygrp-lc .ad { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; MARGIN-BOTTOM: 10px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-mlmsg { FONT: x-small arial,helvetica,clean,sans-serif } #ygrp-mlmsg TABLE { FONT-WEIGHT: normal; FONT-SIZE: 100%; LINE-HEIGHT: normal; FONT-STYLE: normal; FONT-VARIANT: normal } #ygrp-mlmsg SELECT { FONT: 99% arial,helvetica,clean,sans-serif } INPUT { FONT: 99% arial,helvetica,clean,sans-serif } TEXTAREA { FONT: 99% arial,helvetica,clean,sans-serif } #ygrp-mlmsg PRE { FONT: 100% monospace } CODE { FONT: 100% monospace } #ygrp-mlmsg * { LINE-HEIGHT: 1.22em } #ygrp-text { FONT-FAMILY: Georgia } #ygrp-text P { MARGIN: 0px 0px 1em } #ygrp-tpmsgs { CLEAR: both; FONT-FAMILY: Arial } #ygrp-vitnav { FONT-SIZE: 77%; MARGIN: 0px; PADDING-TOP: 10px; FONT-FAMILY: Verdana } #ygrp-vitnav A { PADDING-RIGHT: 1px; PADDING-LEFT: 1px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-actbar { CLEAR: both; MARGIN: 25px 0px; COLOR: #666; WHITE-SPACE: nowrap; TEXT-ALIGN: right } #ygrp-actbar .left { FLOAT: left; WHITE-SPACE: nowrap } bld { FONT-WEIGHT: bold } #ygrp-grft { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 15px; PADDING-TOP: 15px; FONT-FAMILY: Verdana } #ygrp-ft { PADDING-RIGHT: 0px; BORDER-TOP: #666 1px solid; PADDING-LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 5px; PADDING-TOP: 5px; FONT-FAMILY: verdana } #ygrp-mlmsg #logo { PADDING-BOTTOM: 10px } #ygrp-reco { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-reco #reco-head { FONT-WEIGHT: bold; COLOR: #ff7900 } #reco-grpname { MARGIN-TOP: 10px; FONT-WEIGHT: bold } #reco-category { FONT-SIZE: 77% } #reco-desc { FONT-SIZE: 77% } #ygrp-vital { PADDING-RIGHT: 0px; PADDING-LEFT: 8px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 8px; PADDING-TOP: 2px; BACKGROUND-COLOR: #e0ecee } #ygrp-vital #vithd { FONT-WEIGHT: bold; FONT-SIZE: 77
RE: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Did not get you. which format we need? -Tushar Dharmanadi [EMAIL PROTECTED] wrote: Hi, Checked your excel format also for example Ledger table Regards, - From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Nitesh Sent: Friday, March 21, 2008 6:56 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax Hi Tushar, seems Record already exist in Table . From Import Dialog box go to Import Rule Tabpage and select the Option clear table before Import from Import Rule field. Regards Nitesh On 3/21/08, Tushar Joshi [EMAIL PROTECTED] wrote: Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now. - Did you know? You can CHAT without downloading messenger. Click here
Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Hi Tushar, Which Table you are trying to import ? On Thu, Mar 27, 2008 at 3:17 PM, Tushar Joshi [EMAIL PROTECTED] wrote: Did not get you. which format we need? -Tushar *Dharmanadi [EMAIL PROTECTED]* wrote: Hi, Checked your excel format also – for example Ledger table Regards, -- *From:* Axapta-Knowledge-Village@yahoogroups.com [mailto: [EMAIL PROTECTED] *On Behalf Of *Nitesh *Sent:* Friday, March 21, 2008 6:56 PM *To:* Axapta-Knowledge-Village@yahoogroups.com *Subject:* Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax Hi Tushar, seems Record already exist in Table . From Import Dialog box go to Import Rule Tabpage and select the Option clear table before Import from Import Rule field. Regards Nitesh On 3/21/08, Tushar Joshi [EMAIL PROTECTED]tushar_s_joshi%40yahoo.co.in wrote: Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now. -- Did you know? You can CHAT without downloading messenger. Click herehttp://in.rd.yahoo.com/tagline_webmessenger_2/*http://in.messenger.yahoo.com/webmessengerpromo.php
Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Hi Nitesh, Thanks a lot for reply! but i tried this already... i have a doubt... if i try to import a single record then it is success but when i try to import another one it syas record already exists is it something to do with Number Sequences??? would appriciate if u cud throw some light on this :) Tushar Nitesh [EMAIL PROTECTED] wrote: Hi Tushar, seems Record already exist in Table . From Import Dialog box go to Import Rule Tabpage and select the Option clear table before Import from Import Rule field. Regards Nitesh On 3/21/08, Tushar Joshi [EMAIL PROTECTED] wrote: Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now. - 5, 50, 500, 5000 - Store N number of mails in your inbox. Click here.
RE: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Hi, Checked your excel format also - for example Ledger table Regards, _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Nitesh Sent: Friday, March 21, 2008 6:56 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax Hi Tushar, seems Record already exist in Table . From Import Dialog box go to Import Rule Tabpage and select the Option clear table before Import from Import Rule field. Regards Nitesh On 3/21/08, Tushar Joshi tushar_s_joshi@ mailto:tushar_s_joshi%40yahoo.co.in yahoo.co.in wrote: Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now.
[Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now.
Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Hi Tushar, seems Record already exist in Table . From Import Dialog box go to Import Rule Tabpage and select the Option clear table before Import from Import Rule field. Regards Nitesh On 3/21/08, Tushar Joshi [EMAIL PROTECTED] wrote: Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now.