RE: [development-axapta] Excel import error
Den 27. juli 2005 15:15 skrev pallegude: Any ideas would be welcome Are you using extended data types on the fields? If not do so. Hilsen Søren 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.
RE: [development-axapta] Excel Import
Hi there, Make sure that the format of the cells is correct. Even after you paste the data go to the cell and make sure that the excel cell is formated i.e. number, text, general etc. Hope this helps. Yifat From: akash malohatra [mailto:[EMAIL PROTECTED] Sent: 05 May 2004 02:07 To: [EMAIL PROTECTED] Subject: [development-axapta] Excel Import Hi All, Need your help. Axapta 3.0 SP2 I created the Excel template file using the Template wizard for importing Vendor Master. I paste the required data for Vendor master from another Excel file to this template file. When i import , it says the record Alreday Exist. I checked its importing the blank values in vendor Account field instead of the correct vendor Account in the Excel File. Really dont know , why its happening like this I saw , it happens as i copied the data from another Excel file and pasted in the Template excel file file. When i enter some data in the template file manually and trying to import , it works successfully. So, data from another Excel file, can not be pasted to the Template file. Need your comments and suggesstins. Regards Akash Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html 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.
RE: [development-axapta] Excel Import
After copying in your data go to the vendor code and put ' in the front as part of the code, does it show or disappear? If it disappears try doing an import. Excel has some strange behaviour on so called string fields (to you it looks like a striong field but not to excel, not until you put the ' on the front), I kinda remember something similar with another customer but I think in the end couldnt get the excel to except the field as string so did it via csv (which is faster I think also). -Original Message- From: akash malohatra [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 3:49 PM To: [EMAIL PROTECTED] Subject: RE: [development-axapta] Excel Import Yah , i checked the format of the cells are as required. But still its not allowing the vendor codes. Its entering as blank. Regards Akash --- Yifat Halili [EMAIL PROTECTED] wrote: Hi there, Make sure that the format of the cells is correct. Even after you paste the data go to the cell and make sure that the excel cell is formated i.e. number, text, general etc. Hope this helps. Yifat From: akash malohatra [mailto:[EMAIL PROTECTED] Sent: 05 May 2004 02:07 To: [EMAIL PROTECTED] Subject: [development-axapta] Excel Import Hi All, Need your help. Axapta 3.0 SP2 I created the Excel template file using the Template wizard for importing Vendor Master. I paste the required data for Vendor master from another Excel file to this template file. When i import , it says the record Alreday Exist. I checked its importing the blank values in vendor Account field instead of the correct vendor Account in the Excel File. Really dont know , why its happening like this I saw , it happens as i copied the data from another Excel file and pasted in the Template excel file file. When i enter some data in the template file manually and trying to import , it works successfully. So, data from another Excel file, can not be pasted to the Template file. Need your comments and suggesstins. Regards Akash Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html Yahoo! Groups Sponsor ADVERTISEMENT click here http://rd.yahoo.com/SIG=129je190v/M=295196.4901138.6052515.3001176/D=gr oups/S=1705006764:HM/EXP=1083802024/A=2128215/R=0/SIG=10se96mf6/*http:/c ompanion.yahoo.com http://us.adserver.yahoo.com/l?M=295196.4901138.6052515.3001176/D=group s/S=:HM/A=2128215/rand=479700352 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] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html Yahoo! Groups Links 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.
RE: [development-axapta] Excel Import
Hi James , you are right. Afetr putting one ' before each vendor code. The import works. But its really a strange behavoiur, how excel recognises this. But i dont understand why its only for vendor code , not for other mandatory fields. Regards Akash --- James Flavell [EMAIL PROTECTED] wrote: After copying in your data go to the vendor code and put ' in the front as part of the code, does it show or disappear? If it disappears try doing an import. Excel has some strange behaviour on so called string fields (to you it looks like a striong field but not to excel, not until you put the ' on the front), I kinda remember something similar with another customer but I think in the end couldnt get the excel to except the field as string so did it via csv (which is faster I think also). -Original Message- From: akash malohatra [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 3:49 PM To: [EMAIL PROTECTED] Subject: RE: [development-axapta] Excel Import Yah , i checked the format of the cells are as required. But still its not allowing the vendor codes. Its entering as blank. Regards Akash --- Yifat Halili [EMAIL PROTECTED] wrote: Hi there, Make sure that the format of the cells is correct. Even after you paste the data go to the cell and make sure that the excel cell is formated i.e. number, text, general etc. Hope this helps. Yifat From: akash malohatra [mailto:[EMAIL PROTECTED] Sent: 05 May 2004 02:07 To: [EMAIL PROTECTED] Subject: [development-axapta] Excel Import Hi All, Need your help. Axapta 3.0 SP2 I created the Excel template file using the Template wizard for importing Vendor Master. I paste the required data for Vendor master from another Excel file to this template file. When i import , it says the record Alreday Exist. I checked its importing the blank values in vendor Account field instead of the correct vendor Account in the Excel File. Really dont know , why its happening like this I saw , it happens as i copied the data from another Excel file and pasted in the Template excel file file. When i enter some data in the template file manually and trying to import , it works successfully. So, data from another Excel file, can not be pasted to the Template file. Need your comments and suggesstins. Regards Akash Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html Yahoo! Groups Sponsor ADVERTISEMENT click here http://rd.yahoo.com/SIG=129je190v/M=295196.4901138.6052515.3001176/D=gr oups/S=1705006764:HM/EXP=1083802024/A=2128215/R=0/SIG=10se96mf6/*http:/c ompanion.yahoo.com http://us.adserver.yahoo.com/l?M=295196.4901138.6052515.3001176/D=group s/S=:HM/A=2128215/rand=479700352 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] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html Yahoo! Groups Links Yahoo! Groups Sponsor Yahoo! Groups Links http://groups.yahoo.com/group/development-axapta/ [EMAIL PROTECTED] === message truncated === Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html 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.
RE: [development-axapta] Excel Import
I really cant help as I recall I gave up and used csv... :( I have seen it not just on Axapta import but I dont know why excel doesnt treat it as a string field without the ' Maybe you can write short VB script to add ' or something similiar -Original Message- From: akash malohatra [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 4:29 PM To: [EMAIL PROTECTED] Subject: RE: [development-axapta] Excel Import Hi James , you are right. Afetr putting one ' before each vendor code. The import works. But its really a strange behavoiur, how excel recognises this. But i dont understand why its only for vendor code , not for other mandatory fields. Regards Akash --- James Flavell [EMAIL PROTECTED] wrote: After copying in your data go to the vendor code and put ' in the front as part of the code, does it show or disappear? If it disappears try doing an import. Excel has some strange behaviour on so called string fields (to you it looks like a striong field but not to excel, not until you put the ' on the front), I kinda remember something similar with another customer but I think in the end couldnt get the excel to except the field as string so did it via csv (which is faster I think also). -Original Message- From: akash malohatra [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 3:49 PM To: [EMAIL PROTECTED] Subject: RE: [development-axapta] Excel Import Yah , i checked the format of the cells are as required. But still its not allowing the vendor codes. Its entering as blank. Regards Akash --- Yifat Halili [EMAIL PROTECTED] wrote: Hi there, Make sure that the format of the cells is correct. Even after you paste the data go to the cell and make sure that the excel cell is formated i.e. number, text, general etc. Hope this helps. Yifat From: akash malohatra [mailto:[EMAIL PROTECTED] Sent: 05 May 2004 02:07 To: [EMAIL PROTECTED] Subject: [development-axapta] Excel Import Hi All, Need your help. Axapta 3.0 SP2 I created the Excel template file using the Template wizard for importing Vendor Master. I paste the required data for Vendor master from another Excel file to this template file. When i import , it says the record Alreday Exist. I checked its importing the blank values in vendor Account field instead of the correct vendor Account in the Excel File. Really dont know , why its happening like this I saw , it happens as i copied the data from another Excel file and pasted in the Template excel file file. When i enter some data in the template file manually and trying to import , it works successfully. So, data from another Excel file, can not be pasted to the Template file. Need your comments and suggesstins. Regards Akash Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html Yahoo! Groups Sponsor ADVERTISEMENT click here http://rd.yahoo.com/SIG=129je190v/M=295196.4901138.6052515.3001176/D=gr oups/S=1705006764:HM/EXP=1083802024/A=2128215/R=0/SIG=10se96mf6/*http:/c ompanion.yahoo.com http://us.adserver.yahoo.com/l?M=295196.4901138.6052515.3001176/D=group s/S=:HM/A=2128215/rand=479700352 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] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html Yahoo! Groups Links Yahoo! Groups Sponsor Yahoo! Groups Links http://groups.yahoo.com/group/development-axapta/ [EMAIL PROTECTED] === message truncated === Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html Yahoo! Groups Links 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.
