Skip to Content
This question has been flagged
2 Replies
1781 Views
Avatar
Cameron Jones

I try importing the following csv file:

Company,Internal Reference,Name,Revision,Lifecycle,Unit of Measure,Purchase unit of measure,Cost,Product Category,Product Type,responsibleCranium Audio Designs LLC,QBN-0004,XSTR BIP NPN MMBTA06 80V 500mA SOT23,A00,Production,each,each,1,All,Storable Product,AdministratorCranium Audio Designs LLC,OSC-0001,OSC 22.5792MHz 3.3V 25PPM SMT,A00,Production,each,each,2,All,Storable Product,AdministratorCranium Audio Designs LLC,FAA-0005,ASSY FINAL WARWICK MOD7,A00,Production,each,each,3,All,Storable Product,AdministratorCranium Audio Designs LLC,FAA-0001-00,ASSY FINAL DESOLATION SOUND FORD PREFECT (HIGH PERF),1,ENG Plan,each,each,4,All,Storable Product,AdministratorCranium Audio Designs LLC,CON-0014-05,CONN HRD 5P MALE 7.92mm 7A 250V 94V0,100,Prototype,each,each,5,All,Storable Product,AdministratorCranium Audio Designs LLC,CON-0014-03,CONN HRD 3P MALE 7.92mm 7A 250V 94V0,100,Prototype,each,each,6,All,Storable Product,Administrator​

I do a test import and get the message "Everything seems valid".

I then import the file and get the following message:  "6 records were successfully imported".

I then go to master data / products and only 3 of the 6 records appear, the following Internal references:

FAA-0001-00; FAA-0005; CON-0014-03

What am i missing?



Avatar
Discard
Avatar
Cameron Jones
Author Best Answer

Niyas:

Thanks for your suggestion!  I setup your custom filter and unfortunately it didn't yield the missing parts. Just to make sure I setup the filter properly, I achived one of my "good" parts and it then showed up under that filter....

Cam

Avatar
Discard
Avatar
Niyas Raphy (Walnut IT)
Best Answer

Hi,

Just check and ensure that the other three products doesn't set  to active=False . Filter the active=False and check whether you can see the missing records there.

Thanks

Avatar
Discard