Profile: blacklab2

What version of nopCommerce are you working with. (Just seen the 2.8 version bit, so the below probably applies although don't have a 2.8 DB installed right now to check).

Not sure when it changed but company name used to be stored in CustomerAttribute with a key of "Company"

Looking at 3.1, looks like its on the address.

@[email protected] Thank you that did it.

Actually it makes perfect sense now, frustrated that I didn't see it before.

Thanks Again.

Thank you @[email protected]

Will give that a go and see where it takes me.


Paul

Hi,

This is my Schedule code
namespace Nop.Plugin.Feed.MYImport.Services
{
    /// <summary>
    /// Represents a task for keeping the site alive
    /// </summary>
    public partial class MYUpdateScheduler : ITask
    {
        private readonly MYImportService _MYImportService;

        public MYUpdateScheduler(MYImportService MYImportService)
        {
            this._MYImportService = MYImportService;
        }

        /// <summary>
        /// Executes a task
        /// </summary>
        public void Execute()
        {
            
            MYImportRecord MYImportRecord = _MYImportService.GetConfig();
            try
            {
                _MYImportService.doUpdateXMLImport(MYImportRecord.UpdateXMLURL);
            }
            catch (Exception)
            {
            }
            finally
            {
                MYImportRecord = null;
            }
            
        }
    }
    public partial class MYImportScheduler : ITask
    {
        private readonly MYImportService _MYImportService;

        public MYImportScheduler(MYImportService MYImportService)
        {
            this._MYImportService = MYImportService;
        }

        /// <summary>
        /// Executes a task
        /// </summary>
        public void Execute()
        {
            MYImportRecord MYImportRecord = _MYImportService.GetConfig();
            try
            {
                _MYImportService.doUpdateXMLImport(MYImportRecord.ImportXMLURL);
            }
            catch (Exception)
            {
            }
            finally
            {
                MYImportRecord = null;
            }
        }
    }
}


The constructor of the class that is called looks like. This works absolutely fine when called from the config form.
        public MYImportService(IRepository<MYImportRecord> MYRepository,
            ICacheManager cachManager, IProductService produtSevice,
            ICategoryService categoryService, IManufacturerService manfService,
            IUrlRecordService urlRecordService, IPictureService pictureService,
            IDiscountService discountService, IRepository<MYCategory> MYCategoryRepository)
        {
            this._MYRepository = MYRepository;
            this._cacheManager = cachManager;
            this._productService = produtSevice;
            this._categoryService = categoryService;
            this._manfService = manfService;
            this._urlRecordService = urlRecordService;
            this._pictureService = pictureService;
            this._discountService = discountService;
            this._MYCategoryRepository = MYCategoryRepository;
        }

Hope that will help a little.

Thanks for the response.

Paul

@kaunuk that's a good way, another is to use formula in excel to create update statements then run them against the DB