Author Post
griff 30/04/2015 21:04 griff

import of item

Hi Frank

I created a test file in xcell (2010) saved the file as a comma deliminator


the first field is the part # second is the item description
when I preview the import file it only show the item description inside the
part # field ??
Fabio 04/05/2015 08:56 Fabio

Hi,

Quote:
when I preview the import file it only show the item description inside the part # field ??

From this behavior i think the problem is in the field delimiter. Or the import filter is not configured for a comma delimiter, or the file exported isn't comma delimited.


Could you please attach a screenshot of the import filter you've created?
To take a screenshot you can use Greenshot or something similar
griff 04/05/2015 14:21 griff

Hi Fabio

Simple excel file saved as CSV comma deliminator
Column a is the part # or you item code
column b is the item description

griff 04/05/2015 16:11 griff

Fabio

got it to work
got info on web

vinny
griff 04/05/2015 16:46 griff

hi Fabio

what field to you choose for importing the item Cost (base price) ?
Fabio 04/05/2015 16:51 Fabio

Hi vinny,
you need to leave the record separator as default ( the default is CR+LF )

So:

Record separator : CR+LF
Field separator : , (comma)


Quote:
what field to you choose for importing the item Cost (base price) ?

You must import it as a supplier price (for a specific supplier). We didn't have a generic cost price not connected to a supplier.
If you want more details on this please open a new thread and i will attach a sample screenshot (we ask our customers to open a separate thread for each single question so we can better explain each step)