Jump to content

GreggRusson

Registered Users - Approved
  • Posts

    35
  • Joined

Converted

  • Location
    Seattle

Converted

  • Occupation
    Programmer

Converted

  • FusionPro Products
    Yes

Converted

  • FusionPro VDP software version
    7.1

Converted

  • OS
    XP SP3

Converted

  • Acrobat Version
    Acrobat 9.x

GreggRusson's Achievements

Explorer

Explorer (4/14)

  • First Post Rare
  • Collaborator Rare
  • Conversation Starter Rare
  • Week One Done
  • One Month Later

Recent Badges

10

Reputation

  1. Why not just use a inline graphic rule based on the Signature field? return "<graphic file='sig.tif' height='4800' width='5600'>"; Gregg
  2. http://forums.pti.com/showthread.php?p=20745#poststop
  3. One idea would be to use a textbox and write a rule using a FPTable object with 1 row and up to 6 columns (one for each logo field that's not empty). Then center the returned table... Gregg
  4. Try using this in a rule: if (CurrentRecordNumber()% 2 == 1) return CurrentRecordNumber(); return NullResource(); If the current page/record number is 1, 3, 5, 7 etc, the rule will return that number...
  5. To Dan, Great response, clear, concise and compact. To Tou, After posting my 'down and dirty' response, I had the same thought on tracking tags. It wasn't clearly defined 'why' the extra space was needed, but you're right. If there was a reason the spacing between the characters needed some kind of exacting tolerance, that would have been the way to go. Gregg
  6. Put this into a rule: var ZipWithSpaces = ""; for(var idx = 0; idx < Len(Field("ZIP")); idx++) { ZipWithSpaces += Field("ZIP").substr(idx,1) + " "; } return Trim(ZipWithSpaces); Gregg
  7. Look in the user manual for 'Modifying Frames During Composition'. This section will give you an overview of how to programmatically write (or add to ) a OnRecordStart rule to find and modify either a graphic or text frames properties. To find all the properties of a frame (of which suppress is one), consult the Rules system guide under the FusionProFrame Attributes section.
  8. draco66, I've attached a Access db with 1 data table and an example of a simple select correlated sub-query to get 10 samples from each segment/sort grouping in the data table. Double click on the data table... a little over 36k records with 4 sort groups (A,B,C & E) and 3 fields, rec_id, sort & name. Now, right click and select the design view icon. Next select SQL view. Notice you have an inner & outer query which both reference the same table, hence the AS aliases. The inner query and outer query work together. The inner one runs first, selecting the TOP n (in this case 10) rec_id's needed by the outer query for each segment/sort group. I have just the basics for criteria, but you could easily add additional requirements, like the zip must be 10 characters and/or the country needs to be US etc... you could also add sorting specs as well if you like. Another idea would be turning it into an Update query so you could post back to the database and flag the records selected for tracking purposes. In any event, for ~36k records, process time for me running on a Intel I7 box was just under 3 seconds! Hope this helps, Gregg CorrelatedSubQueryExample.zip
  9. If I understand you correctly, you have a database with some kind of segment/version field and want a quick way to create a proof file with n records from each segment/version. Use whatever SQL database RDBMS you want (such as MS Access) and write a corralated sub-query. It's basically a query within a query, eg, self joining a table to itself and returns the Top n records you specify for each version. Here's a link to get you going: http://allenbrowne.com/subquery-01.html Take a look at the 'TOP n records per group' example Gregg
  10. Hi David, With only one location, it's really straight forward. One input data file with a page number, old & new serial fields. The catalog.pdf is used as a resource, with a rule to control what page is returned for each call. Example attached. Happy Programming, Gregg CatalogMask.zip
  11. Hi David, Is there just one part with one serial number in a static location to replace on each page or multiple parts/serial numbers in different locations? Every page or just certain pages that need to be dealt with? If it's just one static location to replace, even if it's not every page it's certainly doable. Multiple locations would involve more work. Gregg
  12. Hey Step, A quick question on a post in this thread (#4). In your function getTextWidth(input), you're returning the tm.textWidth * 1.1. I get the space * 2 to get the 1/8 inch left/right margins the original poster said he wanted, but why multiply the textWidth * 1.1? Just curious... TIA Gregg
  13. Have a project where I thought Text on a Curve frames would work great. Haven't ever used it before. Wanted the text to flow between multiple linked curve frames... but alas, it seems that you can't link the curved text frames. Is there any way to get the line/path length of this type of frame to get a object reference and write my own linking routine? Went looking for a function similar to FindTextFrame or FindGraphicFrame but no luck. Any ideas? Thanks, Gregg
  14. Hi Dave, Did a couple of these types of jobs for tax season. The general idea is to have 2 files with a parent/child relationship. You already have the 'child' table with all the transactions. All you need to do is make a copy of the file you already have and de-dupe down to one record per account based on account number... this will be the 'parent' file. In your template, you'll need to define the child table in your on job start rule with an external data file. Next, in your on record start, you'll need to define a FP Table and loop thru the child table, populating the table cells with the data you want with when the account numbers match. Hope this helps, Gregg
  15. In the MS Visual Studio editor environment, you can select multiple objects at one time and move them all at once. Can this be done (selecting multiple frames to move) in Fusion Pro? TIA, Gregg
×
×
  • Create New...