跳到主内容

搜索

搜索

Help! Serializing From Database

评论

3 条评论

  • 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... :)
    0

请先登录再写评论。