|
|
| | Author: | jeffmcclain | Posted: | Jun 6, 2015 12:32 | Subject: | Orders Download Feature | Viewed: | 143 times | Topic: | Suggestions | Status: | Discarded | |
|
| Hello,
It would sure help out a LOT if in the "download orders" list, you could separate
out the "Item Description" to be 3 separate columns: Type (brick, plate, tile,
slope, etc), Description (1x3, round, etc.), and Color, rather than it all combined.
This would make it MUCH easier to pivot by item number, type, color, etc.
Thanks!
Jeff
|
|
| | | | | |
| | | | Author: | chetzler | Posted: | Jun 6, 2015 13:19 | Subject: | Re: Orders Download Feature | Viewed: | 30 times | Topic: | Suggestions | |
|
| In Suggestions, jeffmcclain writes:
| Hello,
It would sure help out a LOT if in the "download orders" list, you could separate
out the "Item Description" to be 3 separate columns: Type (brick, plate, tile,
slope, etc), Description (1x3, round, etc.), and Color, rather than it all combined.
This would make it MUCH easier to pivot by item number, type, color, etc.
Thanks!
Jeff
|
I've had the same difficulty. I even asked about it here a while back but
surprisingly, I didn't get a single response:
http://www.bricklink.com/message.asp?ID=899185
|
|
| | | | | | | | | |
| | | | | | Author: | jeffmcclain | Posted: | Jun 6, 2015 22:08 | Subject: | Re: Orders Download Feature | Viewed: | 25 times | Topic: | Suggestions | |
|
| In Suggestions, chetzler writes:
| In Suggestions, jeffmcclain writes:
| Hello,
It would sure help out a LOT if in the "download orders" list, you could separate
out the "Item Description" to be 3 separate columns: Type (brick, plate, tile,
slope, etc), Description (1x3, round, etc.), and Color, rather than it all combined.
This would make it MUCH easier to pivot by item number, type, color, etc.
Thanks!
Jeff
|
I've had the same difficulty. I even asked about it here a while back but
surprisingly, I didn't get a single response:
http://www.bricklink.com/message.asp?ID=899185
|
I'm going to just have to put it through a perl REGEX match on that field
(duplicated) and match everything up to the color: s/^(.*?)(black|white|tan|blue|gray|red|yellow|orange|green).*/$1/i
As an example (that should get even "Light Bluish Gray" and "Dark Red", "Trans-Black",
etc...Then I'll match the first word left for the "item type" and leave the
rest.
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | Author: | 62Bricks | Posted: | Jun 6, 2015 22:43 | Subject: | Re: Orders Download Feature | Viewed: | 37 times | Topic: | Suggestions | |
|
| In Suggestions, jeffmcclain writes:
| In Suggestions, chetzler writes:
| In Suggestions, jeffmcclain writes:
| Hello,
It would sure help out a LOT if in the "download orders" list, you could separate
out the "Item Description" to be 3 separate columns: Type (brick, plate, tile,
slope, etc), Description (1x3, round, etc.), and Color, rather than it all combined.
This would make it MUCH easier to pivot by item number, type, color, etc.
Thanks!
Jeff
|
I've had the same difficulty. I even asked about it here a while back but
surprisingly, I didn't get a single response:
http://www.bricklink.com/message.asp?ID=899185
|
I'm going to just have to put it through a perl REGEX match on that field
(duplicated) and match everything up to the color: s/^(.*?)(black|white|tan|blue|gray|red|yellow|orange|green).*/$1/i
As an example (that should get even "Light Bluish Gray" and "Dark Red", "Trans-Black",
etc...Then I'll match the first word left for the "item type" and leave the
rest.
|
Not sure what your exact needs are, but Brickstock fills in the color and type
when you import orders, and all fields are sortable. Might be easier to import/export
the Brickstock XML into excel than to run regex on the Bricklink file.
|
|
|
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | Author: | jeffmcclain | Posted: | Jun 8, 2015 12:49 | Subject: | Re: Orders Download Feature | Viewed: | 37 times | Topic: | Suggestions | |
|
| In Suggestions, 62Bricks writes:
| In Suggestions, jeffmcclain writes:
| In Suggestions, chetzler writes:
| In Suggestions, jeffmcclain writes:
| Hello,
It would sure help out a LOT if in the "download orders" list, you could separate
out the "Item Description" to be 3 separate columns: Type (brick, plate, tile,
slope, etc), Description (1x3, round, etc.), and Color, rather than it all combined.
This would make it MUCH easier to pivot by item number, type, color, etc.
Thanks!
Jeff
|
I've had the same difficulty. I even asked about it here a while back but
surprisingly, I didn't get a single response:
http://www.bricklink.com/message.asp?ID=899185
|
I'm going to just have to put it through a perl REGEX match on that field
(duplicated) and match everything up to the color: s/^(.*?)(black|white|tan|blue|gray|red|yellow|orange|green).*/$1/i
As an example (that should get even "Light Bluish Gray" and "Dark Red", "Trans-Black",
etc...Then I'll match the first word left for the "item type" and leave the
rest.
|
Not sure what your exact needs are, but Brickstock fills in the color and type
when you import orders, and all fields are sortable. Might be easier to import/export
the Brickstock XML into excel than to run regex on the Bricklink file.
|
Thank you! I need to spend some time with this, but this looks pretty helpful,
actually. Might have saved me some time/money placing my custom sets orders.
I think it could use some more features for combining orders and delta operations
from a "wanted" list, but I need to play with it first. Thanks!!!
Jeff
|
|
|
|
|
|