Discussion Forum: Messages by _djm (524)
Redisplay Messages: Compact | Brief | All | Full      Show Messages: All | Without Replies

 Author: _djm View Messages Posted By _djm
 Posted: Jan 19, 2016 18:15
 Subject: Inventory Change Request for Set 9603-1
 Viewed: 28 times
 Topic: Inventories Requests (Entry)
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

_djm (524)

Location:  New Zealand, Auckland
Member Since Contact Type Status
Jul 17, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: DJMs Parts
Please make changes to the following inventory:
 
Set No: 9603  Name: TECHNIC I Activity Centre Cards (Simple Machines Activity Center - ISBN 8777370228 for US Version)
* 
9603-1 (Inv) TECHNIC I Activity Centre Cards (Simple Machines Activity Center - ISBN 8777370228 for US Version)
120 Books, 2 Gear, 1990
Sets: Educational & Dacta: Technic: Supplemental

* Change 1 Book 8777370066 LEGO Technic 1 Activity Centre Useful Information (UK version for 9603) {Regular to Alternate} {match ID 0 to 1}

Comments from Submitter:
Step 2, to differentiate between the US and UK version of the same book.
 Author: _djm View Messages Posted By _djm
 Posted: Jan 19, 2016 18:13
 Subject: Inventory Change Request for Set 9603-1
 Viewed: 34 times
 Topic: Inventories Requests (Entry)
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

_djm (524)

Location:  New Zealand, Auckland
Member Since Contact Type Status
Jul 17, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: DJMs Parts
Please make changes to the following inventory:
 
Set No: 9603  Name: TECHNIC I Activity Centre Cards (Simple Machines Activity Center - ISBN 8777370228 for US Version)
* 
9603-1 (Inv) TECHNIC I Activity Centre Cards (Simple Machines Activity Center - ISBN 8777370228 for US Version)
120 Books, 2 Gear, 1990
Sets: Educational & Dacta: Technic: Supplemental

* Change 1 Book 8777370201 LEGO Technic 1 Activity Center Teacher Supplement (US version for 9603) {match ID 0 to 1}

Comments from Submitter:
Step 1 of identifying the different versions (US v UK) of this book.
 Author: _djm View Messages Posted By _djm
 Posted: May 22, 2015 16:39
 Subject: Re: Dealing with orders
 Viewed: 67 times
 Topic: Suggestions
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

_djm (524)

Location:  New Zealand, Auckland
Member Since Contact Type Status
Jul 17, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: DJMs Parts
In Suggestions, billduge writes:
  We would like to suggest some changes to the orders pages, both printing and
downloading.

1. The current order printouts are taking up a lot of paper (and toner etc).
If I download the order into Brickstock for example I can reduce the number of
pages by 40 to 50% but I cannot get same sort order. Brickstock is severely limited
on its sorting capabilities at the moment. We have asked Patrick Brans to look
at this as a matter of urgency, but he seems to be quite tied up with his normal
job at present.
2. If we download the order from Bricklink to a spreadsheet file we lose the
images and the quantity remaining - and both of those fields are used in the
picking process - we do not want to lose them. We have tried all the different
download formats and none of them provide or bring either of the fie4lds with
them.

So the suggestions are:

1. Improve the order printing process and allow more flexibility in where we
place the columns etc. This can be done as Allan Smith has produced a great order
template for Brickstock which is how we have been able to reduce the number of
pages per order - we still get everything we had with the Bricklink Order printout
(Except quantity remaining)and it all fits on one A4 Portrait page much better
that the existing printout from Bricklink.

2. Give us a way to incorporate the image and quantity remaining fields and data
in the download capabilities.

Either of these 'solutions' will solve the problem, save money and time
on the printing side and be a significant improvement to the current process.

We are aware that some stores do not print their orders at all any more - they
simply work from a tablet or computer screen - but in our case this isn't
really possible - we need that picking list as our storage and distribution centre
is not in the same location as the rest of the order processing.

Neither of the above suggestions would take a great deal of coding changes and
we see them as an excellent improvement to the site.

Because I'm only a buyer and not a seller (so far), I don't know anything
about BrickStock from a seller's perspective. So the following suggestion
may not offer a solution for you.

I recently posted a thread (http://www.bricklink.com/message.asp?ID=914453) to
an Excel template I have written. The spreadsheet is able to include part images
by leveraging the image cache that BrickStock and Bricficiency create. If you
can get BrickStock to create an XML file with the columns you desire (and this
is where my seller's perspective comment came from, as I don't know the
answer to that), you could import the XML data into Excel, incorporate the data
into an instance of a spreadsheet based on my template and manipulate the data
as you see fit.

FWIW, I'm also looking at making the XML import to be a more automated step,
leveraging XSLT to cherry pick the columns and reduce the manual steps for importing
an XML file. This would allow the template to more simply import arbitrary XML
files. But this will be a few weeks away, as I am presently working on my LEGO
diamond train crossing (http://www.eurobricks.com/forum/index.php?showtopic=96098&st=25#entry2223213).

Regards,

David
 Author: _djm View Messages Posted By _djm
 Posted: Nov 7, 2014 05:50
 Subject: Inventory Change Request for Set 1031-1
 Viewed: 34 times
 Topic: Inventories Requests (Entry)
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

_djm (524)

Location:  New Zealand, Auckland
Member Since Contact Type Status
Jul 17, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: DJMs Parts
Please make changes to the following inventory:
 
Set No: 1031  Name: Building Cards - 1030
* 
1031-1 (Inv) Building Cards - 1030
20 Books, 1983
Sets: Educational & Dacta: Technic: Supplemental

* Add 1 Book 1031b01b Set 1031 Activity Booklet 01 - Parts Tray Organizer Card (Alternate) (match ID 1)
* Add 1 Book 1031b02b Set 1031 Activity Booklet 02 - Forces and Structures #1 (Alternate) (match ID 2)
* Add 1 Book 1031b03b Set 1031 Activity Booklet 03 - Forces and Structures #2 (Alternate) (match ID 3)
* Add 1 Book 1031b04b Set 1031 Activity Booklet 04 - Levers #1 (Alternate) (match ID 4)
* Add 1 Book 1031b05b Set 1031 Activity Booklet 05 - Pulleys #1 (Alternate) (match ID 5)
* Add 1 Book 1031b06b Set 1031 Activity Booklet 06 - Gears #1 (Alternate) (match ID 6)
* Add 1 Book 1031b07b Set 1031 Activity Booklet 07 - Gears #2 (Alternate) (match ID 7)
* Add 1 Book 1031b08b Set 1031 Activity Booklet 08 - Levers #2 (Alternate) (match ID 8)
* Add 1 Book 1031b09b Set 1031 Activity Booklet 09 - Gears #3 (Alternate) (match ID 9)
* Add 1 Book 1031b10b Set 1031 Activity Booklet 10 - Wheels and Axles #1 (Alternate) (match ID 10)
* Add 1 Book 1031b11b Set 1031 Activity Booklet 11 - Wheels and Axles #2 (Alternate) (match ID 11)
* Add 1 Book 1031b12b Set 1031 Activity Booklet 12 - Gears #4 (Alternate) (match ID 12)
* Add 1 Book 1031b13b Set 1031 Activity Booklet 13 - Gear #5 (Alternate) (match ID 13)
* Add 1 Book 1031b14b Set 1031 Activity Booklet 14 - Gears #6 (Alternate) (match ID 14)
* Add 1 Book 1031b15b Set 1031 Activity Booklet 15 - Pulleys #2 (Alternate) (match ID 15)
* Add 1 Book 1031b16b Set 1031 Activity Booklet 16 - Pulleys #3 (Alternate) (match ID 16)
* Add 1 Book 1031b17b Set 1031 Activity Booklet 17 - Energy #1 (Alternate) (match ID 17)
* Add 1 Book 1031b18b Set 1031 Activity Booklet 18 - Energy #2 (Alternate) (match ID 18)
* Add 1 Book 1031b19b Set 1031 Activity Booklet 19 - Wheels and Axles #3 (Alternate) (match ID 19)
* Add 1 Book 1031b20b Set 1031 Activity Booklet 20 - Wheels and Axles #4 (Alternate) (match ID 20)

Comments from Submitter:
The alternative cards are the blue border (1990) edition of the cards.
 Author: _djm View Messages Posted By _djm
 Posted: Nov 3, 2014 05:13
 Subject: Inventory Change Request for Set 1031-1
 Viewed: 27 times
 Topic: Inventories Requests (Entry)
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

_djm (524)

Location:  New Zealand, Auckland
Member Since Contact Type Status
Jul 17, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: DJMs Parts
Please make changes to the following inventory:
 
Set No: 1031  Name: Building Cards - 1030
* 
1031-1 (Inv) Building Cards - 1030
20 Books, 1983
Sets: Educational & Dacta: Technic: Supplemental

* Change 1 Book 1030b1 Set 1030 Activity Booklet 1 - Parts Tray Organizer Card {match ID 0 to 1}
* Change 1 Book 1030b2 Set 1030 Activity Booklet 2 - Levers {match ID 0 to 2}
* Change 1 Book 1030b3 Set 1030 Activity Booklet 3 - Supports {match ID 0 to 3}
* Change 1 Book 1030b4 Set 1030 Activity Booklet 4 - Lifting & Supporting {match ID 0 to 4}
* Change 1 Book 1030b5 Set 1030 Activity Booklet 5 - Pulleys & Belts {match ID 0 to 5}
* Change 1 Book 1030b6 Set 1030 Activity Booklet 6 - Gears {match ID 0 to 6}
* Change 1 Book 1030b7 Set 1030 Activity Booklet 7 - More Gears {match ID 0 to 7}
* Change 1 Book 1030b8 Set 1030 Activity Booklet 8 - Angles {match ID 0 to 8}
* Change 1 Book 1030b9 Set 1030 Activity Booklet 9 - Flywheels {match ID 0 to 9}
* Change 1 Book 1030b10 Set 1030 Activity Booklet 10 - Wheels {match ID 0 to 10}
* Change 1 Book 1030b11 Set 1030 Activity Booklet 11 - Conveyors {match ID 0 to 11}
* Change 1 Book 1030b12 Set 1030 Activity Booklet 12 - Advanced Gearing {match ID 0 to 12}
* Change 1 Book 1030b13 Set 1030 Activity Booklet 13 - Pistons {match ID 0 to 13}
* Change 1 Book 1030b14 Set 1030 Activity Booklet 14 - Merry-go-round {match ID 0 to 14}
* Change 1 Book 1030b15 Set 1030 Activity Booklet 15 - Cranes {match ID 0 to 15}
* Change 1 Book 1030b16 Set 1030 Activity Booklet 16 - Lifting with Pulleys {match ID 0 to 16}
* Change 1 Book 1030b17 Set 1030 Activity Booklet 17 - Water Wheels {match ID 0 to 17}
* Change 1 Book 1030b18 Set 1030 Activity Booklet 18 - Windmills {match ID 0 to 18}
* Change 1 Book 1030b19 Set 1030 Activity Booklet 19 - Simple Steering {match ID 0 to 19}
* Change 1 Book 1030b20 Set 1030 Activity Booklet 20 - Advanced Steering {match ID 0 to 20}

Comments from Submitter:
Preparation for adding the 1990 version of the activity cards as alternative parts.