Help! Serializing From Database 关注

0
Avatar
Legacy Poster

Hello everyone!

I looked out if this topic was discussed before and I couldn't find anything so here is my problem:

We have a database (Excel) with 100.000 names - which are printed on plastic cards (loyalty cards). These cards are then packed in boxes of 500 each - so we have 200 boxes (=labels) each. On each label should be the first and the last name (entry) of the box. In other words, the 1st and 500st entry from the database.

Normally I would have thought that I add a serialize-function with increment of 500 - but unfortunatelly that does not seem to work as it takes only the next line in the database, and does not count 500 to the next.

So my problems:

- How do I tell Bartender (V.9.01) to start with the first entry, and count +500 for the next label. (first label - first name in the box)
- How can I tell Bartender where in the Database to start from if I don't want it to start from the first line in the database, but at 499 for example (first label - last name in the box)

We are working this weekend and we need urgent help as we need to get the job done - any help would be greatly appreciated! :)

P.s.: We don't know VB at all so if it's a script-thing please let us know the code so we can copy/paste if possible.

3 评论

0
Avatar
Legacy Poster
评论操作 固定链接

Maybe since my english is not the best another word for "entry" should be "record" - so I don't want bartender to print every record from the database but only every let's say 500st record, and I also don't want it to start at 1 but at 499 for example. Please help! :)
0
Avatar
Legacy Poster
评论操作 固定链接

Your solution will be to alter your Excel file to take every 500th record and create a fresh datafile from that. This can possibly be done with cell formulas, but could definitely be done with an Excel Macro.

Edit: Okay here we go. Take the data I've pasted below and copy it into a cell beside all your data in excel. If you have all your data that needs to be printed in Column A, This will create a new column that only takes every 500th record. I've used spoiler tags because it's long. Click spoiler to expand.
[spoiler]

=A1
=A501
=A1001
=A1501
=A2001
=A2501
=A3001
=A3501
=A4001
=A4501
=A5001
=A5501
=A6001
=A6501
=A7001
=A7501
=A8001
=A8501
=A9001
=A9501
=A10001
=A10501
=A11001
=A11501
=A12001
=A12501
=A13001
=A13501
=A14001
=A14501
=A15001
=A15501
=A16001
=A16501
=A17001
=A17501
=A18001
=A18501
=A19001
=A19501
=A20001
=A20501
=A21001
=A21501
=A22001
=A22501
=A23001
=A23501
=A24001
=A24501
=A25001
=A25501
=A26001
=A26501
=A27001
=A27501
=A28001
=A28501
=A29001
=A29501
=A30001
=A30501
=A31001
=A31501
=A32001
=A32501
=A33001
=A33501
=A34001
=A34501
=A35001
=A35501
=A36001
=A36501
=A37001
=A37501
=A38001
=A38501
=A39001
=A39501
=A40001
=A40501
=A41001
=A41501
=A42001
=A42501
=A43001
=A43501
=A44001
=A44501
=A45001
=A45501
=A46001
=A46501
=A47001
=A47501
=A48001
=A48501
=A49001
=A49501
=A50001
=A50501
=A51001
=A51501
=A52001
=A52501
=A53001
=A53501
=A54001
=A54501
=A55001
=A55501
=A56001
=A56501
=A57001
=A57501
=A58001
=A58501
=A59001
=A59501
=A60001
=A60501
=A61001
=A61501
=A62001
=A62501
=A63001
=A63501
=A64001
=A64501
=A65001
=A65501
=A66001
=A66501
=A67001
=A67501
=A68001
=A68501
=A69001
=A69501
=A70001
=A70501
=A71001
=A71501
=A72001
=A72501
=A73001
=A73501
=A74001
=A74501
=A75001
=A75501
=A76001
=A76501
=A77001
=A77501
=A78001
=A78501
=A79001
=A79501
=A80001
=A80501
=A81001
=A81501
=A82001
=A82501
=A83001
=A83501
=A84001
=A84501
=A85001
=A85501
=A86001
=A86501
=A87001
=A87501
=A88001
=A88501
=A89001
=A89501
=A90001
=A90501
=A91001
=A91501
=A92001
=A92501
=A93001
=A93501
=A94001
=A94501
=A95001
=A95501
=A96001
=A96501
=A97001
=A97501
=A98001
=A98501
=A99001
=A99501
=A100001
[/spoiler]

If you have multiple columns of data, you'll just have to repeat this process (Put the data to pull in column A. Copy and paste as values after you've pulled every 500th label), until you have done all columns. Not the best way to go about it, and a macro would work much better, but if it's urgent, this is a workaround for you.
0
Avatar
Legacy Poster
评论操作 固定链接

Hey thanks for your input, it did work indeed, and meanwhile we found out another - probably easier solution which I'd like to share:

we created an excel file with 1, 500, 501, 1001, etc. in one line (not row) - exported it as .csv - opened in editor, copy/pasted in the "print records:" line in the printer-dialog window and it worked, altough this is also only a workaround :) .. I hope that the guys at Seagull implement this feature, I wonder that noone else had this problem before... :)

请先登录再写评论。