Jump to content

mclarke

Registered Users - Approved
  • Posts

    4
  • Joined

Converted

  • Location
    Upstate NY

Converted

  • Occupation
    Senior Solutions Analyst, Canon Solutions America

Converted

  • FusionPro Products
    Yes

Converted

  • FusionPro VDP software version
    11.0.9

Converted

  • OS
    MS Server 2016 Standard

Converted

  • Acrobat Version
    Acrobat DC

mclarke's Achievements

Newbie

Newbie (1/14)

  • First Post Rare
  • Week One Done
  • One Month Later
  • One Year In
  • Conversation Starter Rare

Recent Badges

10

Reputation

  1. Dan: I have it working perfectly now. Had to make a couple small changes to get the back cover of the book to be in the correct position, though. I even managed to figure it out on my own. Thank you again. Mike P.S. How hard would it be to make all the side 2 pages variable? I figure to control it by added a column for number of sides. Then, I would just need to set up some conditions to check for the value and turn on/off the required pages, right?
  2. Thanks for helping me with this project. The SQL database is for the data management. It's how the CSV files will be generated to put into FusionPro Server (yeah, I typed the wrong product, didn't catch it in my proofreading). As I am under a NDA, that is all I can go into right now. Also, the product isn't tickets, but it's close. I've added a back cover, but it is coming out after the first front/back ticket, instead of at the end of each book (right before the next cover page). Is there an easy way to move it? Also, I found out that I have to add a line on the cover to list the range of tickets in the book, too. Can the variables already created do it? I've attached the updated ticket template with the back cover and a small sample file. Spacely Sprockets_50.pdf Sample-Ticket-Book-Dan-1.pdf
  3. Sure, no problem. It's very rough, no graphics, just the text. Before I went to the trouble of "fancying it up", I wanted to make sure I could get the variable pages to work. I don;t even have an imposition yet. The three pages are named and marked as unused (as per one of the training videos), so you will have to turn them on. I did find some errors in the code I posted last night. I had an unknown variable because I had missed changing "couponsPerBook" to "ticketsPerBook" and the OnRecordStart gave an error to the lone "FusionPro.Composition.SetBodyPageUsage(Front, true)" I had at the beginning. It said "Front" (name of the cover page) was unknown. I hope to get better at all this stuff, but it's hard learning scripting as I try to do this project and also teaching myself MySQL at the same time (needed for another part of the project). So, thank you for looking into this issue for me. I really appreciate it. Sample-Ticket-Book.pdf
  4. Hello! I am *very* new to FusionPro and somewhat of a beginner in Javascript, but I have to come up with a demo for a customer creating one of their more complex products (at least to me) in FusionPro to show them it's merits in their daily production. The product is raffle ticket books. Each book has a personalized front cover, dual numbered tickets with the amount of tickets in each book set at time of order (variable) and a back cover. The cover of each book also has to have "Book x of y" numbering on it. So, I have a calculation for the total number of books, some "setbodypageusage" loops and then have to produce them as both one file for each book and one file for each order (not at the same time - two different production runs). The customer wants a totally hands-off production run (we're going to be looking at FusionPro Producer if I can get this to work manually) with each order a separate line in the data file. I've watched all the training videos, read the entire Rules guide and the User Guide section on rules, and I still can't figure out how to setup the loops. This is what I've managed to come up with so far: OnJobStart FusionPro.Composition.chunksBreakStacks = true; OnRecordStart FusionPro.Composition.SetBodyPageUsage(Front, true) var jobNumber = Field("CompanyName") + "_" + Field("TotalTickets"); var totalBooks = 0; var ticketsPerBook = Field("TicketsPerBook"); var jobExtension = "." + (FusionPro.Composition.outputFormatExtension || "pdf"); if (FieldChanged("Companyname") || FusionPro.Composition.repeatRecordNumber % couponPerBook == 1) { var jobNumber = Field("CompanyName") + "_" + Field("TotalTickets") + "_Book" + Int((FusionPro.Composition.repeatRecordNumber-1) / couponPerBook); var jobExtension = "." + (FusionPro.Composition.outputFormatExtension || "pdf"); FusionPro.Composition.OpenNewOutputFile(jobNumber + jobExtension); } Ticket Number Rule FusionPro.Composition.composeAllRecords = false; FusionPro.Composition.startRecordNumber = Field("StartNumber"); FusionPro.Composition.endRecordNumber = Field("TotalTickets"); FusionPro.Composition.repeatRecordCount = Field("TotalTickets"); return FormatNumber ("####", FusionPro.Composition.repeatRecordNumber); Book Number Rule var bookTotal = Field("TotalTickets") / Field("TicketsPerBook"); FusionPro.Composition.composeAllRecords = false; FusionPro.Composition.startRecordNumber = Field("StartNumber"); FusionPro.Composition.endRecordNumber = bookTotal; FusionPro.Composition.repeatRecordCount = bookTotal; return FormatNumber ("####", FusionPro.Composition.repeatRecordNumber); Book Total Rule var bookTotal = Field("TotalTickets") / Field("TicketsPerBook"); return bookTotal The sample data is as follows: CompanyName,TotalTickets,TicketsPerBook,Date,Location,FirstPrize,SecondPrize,ThirdPrize,Price,MultPrice,StartNumber ABC Company,1500,10,"July 3, 2020","123 Main Street, Anytown","40"" Smart TV",A Case of Mixed Wine,$25 Gas Card,5,20,1 Acme Widgets,2500,25,"August 14, 2020","895 Smith Place, Toytown",Weekend for Two in Las Vegas,"32"" Smart TV",$100 Gift Card,5,20,1 Spacely Sprockets,500,5,"September 7, 2020","999 Jon Street, Cape End",Entertainment Gift Basket,$25 Gas Card,$10 Starbucks Card,1,3,1 Any help will be greatly appreciated!! Mike
×
×
  • Create New...