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 | |
|
|
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.
