| |
wertyuio1 wrote:Thank you for the quick response, Yes I am. I'm trying just to add a new row but the Picture Binary remains NULL.
We are on a localhost currently and testing the operational systems o various ECommerce packages, the company I work for has an in house database that uses a replication process to update there stock levels every evening, the database I'm currently creating will be linked to this system in time but we need to find a way of uploading the images first and connecting them to specific stock codes...
I can do it through the admin interface with ease but I have been told/asked to do it manually in the database.
Is this possible any help would be great.
Kind regards - Once again thank you for the quick response..
How are you doing it manually... through SQL?
I don't know the table or column name off-hand, but you can try something like this:
INSERT INTO TableName(ColumnName) SELECT * FROM OPENROWSET(BULK N'C:\Image1.jpg', SINGLE_BLOB) As Image
... to upload an image from your hard drive into the database. Of course you replace the table and column name and the file path. This code may not be exactly right, I found it online somewhere. This isn't how I do it in my program, but I can't remember that off-hand either.
Posted:
one year ago
|
wertyuio1 wrote:Hello,
I recently installed NopCom 2.30, I having trouble importing images into the database, I currently have Microsoft Sql 2008 and I'm trying to manually insert row's into the database to view on the front end. I can physically create the category and products but when I go to map the image it does not view on the front end. The reason for me doing this is I will be connecting to an existing database to the new one I am currently working on.
Within the admin of NopCom I have changed the Media setting's to file system and set up my configuration to the file I created. The company I am working for has over 10,000 products and images.
For the life of me I can't view the image.. Any help advice or any pointer's in the right direction would be great.
Kind Regards
Richard
How are you trying to import the images into the database? Are you inserting them into the database yourself?
Posted:
one year ago
|
I had been working on other projects and hadn't had the time to finish this up. When I went back to it I decided to re-write the entire application so that it would support versions nopcommerce 1.30 through the latest one and also to add a bunch of features that I hadn't originally included in the first design. I'm right in the middle of working on this and I don't have a lot of time right now so it is slow going, but I hope to be able to release a beta version some time this month. It will have a completely different look and a lot of extra features.
You'll be able to:
Manage your stock - stock quantity plus 12 other settings Manage Categories and Manufacturers - add/edit categories/manufactures - quickly assign categories/manufactures to products Manage Warehouses - add/edit warehouses
There might be some other stuff that I throw in there... I'd like to make it as useful as possible.
If anyone has any features that they'd like to see added to it I'd love to hear suggestions... but try to keep it to ideas that relate to managing your stock - because it is called NopEasy Stock Manager ;)
Posted:
one year ago
|
mrcooll020 wrote:Hello , m having this issue for the new version 2.1 , i tried u r code and it didn't worked , but m sure many things changed after a whole year :)
Thank you
This code should be built into version 2.1, it was put into 1.90 (maybe 1.80 I don't remember) after I wrote it. It is possible that there is a setting somewhere that allows you to show the items - I just can't tell you where it is right now as I have had little time to mess with 2.0+.
Posted:
one year ago
|
gonze1 wrote:If its not open source, it should not be allowed to be even yalked about here. Like one of the users above comments, why dive into an open source shopping cart if i will have to spend else where money for an interface for product manipulation!
Maybe Nopcommerce can reproduce something like nopadmin as open source and distribute it here in the future.
Thank you
First of all, the main reason that a lot of people use Nopcommerce is not because it is open source and free - is it because Nopcommerce is a great application with the support of a great community behind it. Being free just happens to be a bonus.
Also, if you notice this topic is in the forum section titled "COMMUNITY COMMERCIAL PRODUCT ANNOUNCEMENTS". This section is meant for commercial (paid for) products.
Lastly, a lot of people find value in products that help them get the job done, even if they have to put forth some money to do so. If they didn't, these products wouldn't exist. By your own admission you seem to value this type of thing as well, the only issue that you seem to have is that you can't get it for free. If that is the case, then I suggest that you avoid reading this section of the forums.
Posted:
one year ago
|