We are a manufacturer and so we create all product data ourselves as new products are developed.
All product data is created in Excel. From where it is imported into our ERP system and into CSC via CSV.
But the import of features-per-product into CSC is not yet done. Due to the complexity how CSC handles this. And I’m looking for how others have done this.
CSC export/import engine puts all features-related-info into 1 CSV field. Rather than separating it into separate CSV fields which would make data-translation to/from other computer systems a lot easier. Please see the example enclosed what I mean
Where to do the data-translation? Modify the CSC export/import engine? Or create VBA code in Excel? Or…?
If we would use API instead of CSV, would the data-translation be more simple?
Is there anybody (please… ) who is importing features into CSC (semi)automatically? If so, I would love to hear from you!
At the moment we manually combine (concatenate function in Excel) many data columns into the single & infamous CSC Features field in order to be able to import it into CSC. Very time-consuming and error-prone. We want to move towards automated workflow and I guess we will hire some VBA guru to get it done…
I have a similar set up. Our data comes from suppliers with specs, separated in individual cells. I see you are already using concatenate, so do we but we have 1 master sheet for the features with all concatenate functions set in sheet 2 to read whatever we drop in sheet 1 columns.
We also use the combine function amongst others in kutools, try kutools and use the text features, I like it