Jump to content

mdlivels

Registered Users - Approved
  • Posts

    17
  • Joined

Converted

  • Location
    Gettysburg, PA

Converted

  • Occupation
    President

Converted

  • FusionPro Products
    Yes

Converted

  • FusionPro VDP software version
    Desktop 10.0.3

Converted

  • OS
    Win 7 Professional

Converted

  • Acrobat Version
    Acrobat DC

mdlivels'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. Hi- Trying to use a mutli-line record data file and insert variable page count PDFs into my Fusion template, but I cannot get it right. I have no issue calling in one PDF (the filename is literally in the data) but I cannot get it to advance and continue adding PDF files until the next record. Can't show the data, but it's pretty simple with a mutli-line record that advances when a certain field changes. The corresponding records all contain different PDF filenames, but again I'm only able to pull in the first one and then it moves to the next record. Is this even possible? var pathName = "\\gcomsecure\Resources\MDL\\"; var data = FusionPro.GetMultiLineRecords(); for (var rec = 1; rec <= data.recordCount; rec++) var FullResourcePath = pathName + Field("Filename"); //change to match your data file field var x = new FusionProResource(FullResourcePath, "graphic", 1); if (!x.exists) { ReportError("Graphic not found: " + Field("Filename")); } var pdfString = ''; for (var pgnbr = 1; pgnbr <= x.countPages; pgnbr++) { x.pagenumber = pgnbr; pdfString += x.value + '<p>\n'; } Print("Result is: " + pdfString); return pdfString;
  2. Thanks, Dan. It's not a good outcome, but you've saved me from continuing to chase my tail! I'll have to find another solution as these index pages (even for a very small provider directory) are 4-5 pages. Large ones can get into the 10's of pages, so I've got to find a way to automate it. I appreciate all of your help along the way here, the directory listing tips you gave me were extremely helpful. Thanks!
  3. So very close here - everything works except one thing - as soon as I try to make the index page overflow into an overflow page (which will be necessary once the real data flows in) the page numbers disappear. It works and displays page numbers but only if not trying to use the overflow page. I am stumped. This time I'm including the collected files for a last stab at wrapping this thing up. The main rules are "Index" and "Adult Companion". I will simply stack the "Specialty" rules in the listing section, and that works fine, it's just the page numbers in the index that are currently out of my reach. ProviderDirectory.zip
  4. Thanks, Dan. I think I'm almost there. The original code I posted was for the provider listing where the <destination>tag should go...problem is, I'm not sure how to incorporate it into the code since it's looping through an XDF and not a specific field one at a time. The code below is what I've started for the actual index, which is there I assume I'll put the <crossref> tag, right? The provider listing is different from the index listing as they are sorted by specialty and alphabetically, respectively. Here's the current index code; var result = ""; IndexXDF = new ExternalDataFileEx("providersIndex.xlsx", "Excel", "providers"); var looping = true; var starting_row = 1; var response = ''; while (looping) { // while looping is true if (IndexXDF.GetFieldValue(starting_row, 'last_name') != '') { //response += IndexXDF.GetFieldValue(starting_row, 'last_name'); TESTING RESPONSE response += "<color name=black>" + IndexXDF.GetFieldValue(starting_row, 'last_name') ; if (IndexXDF.GetFieldValue(starting_row, 'SPECIALTY') != '') { response += "<color name=black> (" + IndexXDF.GetFieldValue(starting_row, 'SPECIALTY')+ ") <br>"; } starting_row++; } else { looping = false; } } return response;
  5. Hi- I need to be able to create a dynamic index from a provider listing that's built from external data with multi-line records. I need the index to report back the page that the Provider is listed on in the listing part (code below). Seems like I should use cross reference tags, but I can't figure out how to apply that given that I'm looking for a specific provider's name among hundreds that are listed in the directory by specialty. The index is to be displayed in alphabetical order, show the provider's name, specialty and page number that it appears on. Any ideas? This creates the provider listing just how i want it - Now I just need to create the index and populate the page that they fall on. var result = ""; Provider = new ExternalDataFileEx("providers.xlsx", "Excel", "providers"); var rows = Provider.SortBy("SPECIALTY").FindRecords("Adult Companion"); var content_fields = ["last_name","address1","address2","address3","city","state","zip","phone","hours","URL"]; for (ri = 0; ri < rows.length; ri++) { result += "<p>"; // loop through each value of content_fields array for (i = 0; i < content_fields.length; i++) { // check to make sure there is a value for the content field if (Provider.GetFieldValue(rows[ri], content_fields[i]) != '') { if (content_fields[i] == 'last_name') { result += "<b/><color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "</b><br>"; } else if (content_fields[i] == 'address1') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; }else if (content_fields[i] == 'address2') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; }else if (content_fields[i] == 'address3') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; }else if (content_fields[i] == 'city') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ ", "; } else if (content_fields[i] == 'state') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ " "; }else if (content_fields[i] == 'zip') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; }else if (content_fields[i] == 'phone') { result += "<color name=black>" + "Phone/Telefono: " + Provider.GetFieldValue(rows[ri], content_fields[i])+ " <br>"; }else if (content_fields[i] == 'hours') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; }else if (content_fields[i] == 'URL') { result += "<color name=black>" + "URL: " + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; } else { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; } } } result += "<br></p>"; } return result;
  6. This is what ended up working, just FYI. Thanks for the help - it didn't work specifically as you gave it to me for my purpose, but you sent me down the right path. var result = ""; Provider = new ExternalDataFileEx("providers.xlsx", "Excel", "providers"); //XDFList = Provider.SortBy("SPECIALTY"); var rows = XDFList.FindRecords("Adult Companion"); // Create an arry of all the content fields you need to check var content_fields = ["last_name","address1","address2","address3","city","state","zip","phone","hours","URL"]; /**/ for (row in rows) { result += "<p>"; //if (row.length != 0) { // loop through each value of content_fields array for (i = 0; i < content_fields.length; i++) { // check to make sure there is a value for the content field if (Provider.GetFieldValue(row, content_fields) != '') { if (content_fields == 'last_name') { result += "<b/><color name=black>" + Provider.GetFieldValue(row, content_fields)+ "</b><br>"; } else if (content_fields == 'address1') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ "<br>"; }else if (content_fields == 'address2') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ "<br>"; }else if (content_fields == 'address3') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ "<br>"; }else if (content_fields == 'city') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ ", "; } else if (content_fields == 'state') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ " "; }else if (content_fields == 'zip') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ "<br>"; }else if (content_fields == 'phone') { result += "<color name=black>" + "Phone/Telefono: " + Provider.GetFieldValue(row, content_fields)+ " <br>"; }else if (content_fields == 'hours') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ "<br>"; }else if (content_fields == 'URL') { result += "<color name=black>" + "URL: " + Provider.GetFieldValue(row, content_fields)+ "<br>"; } else { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ "<br>"; } } } result += "<br></p>"; } return result;
  7. Hi- I'm using an external data file to pull in multi-line records for a provider directory, sorted by specialty. All of that is fine, except when there's a field that ins't populated (like address3). I cannot figure out how to collapse empty fields like I normally would using this method. So most of the entries do NOT have anything in address3, but I've got tons of awkward empty spaces and need to solve this. Here's the code; var result = ""; Provider = new ExternalDataFileEx("providers.xlsx", "Excel", "providers"); XDFList = Provider.SortBy("SPECIALTY"); var rows = XDFList.FindRecords("Adult Companion"); var content_fields = ["last_name","address1","address2","address3","city","state","zip","phone","hours","URL"]; for (row in rows) { for (i = 0; i < content_fields.length; i++) { if (content_fields != '') { if (content_fields == 'last_name') { result += "<b/><color name=black>" + Provider.GetFieldValue(row, content_fields)+ "</b><br>"; } else if (content_fields == 'address1') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ "<br>"; }else if (content_fields == 'address2') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ "<br>"; }else if (content_fields == 'address3') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ "<br>"; }else if (content_fields == 'city') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ ", "; } else if (content_fields == 'state') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ " "; }else if (content_fields == 'zip') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ "<br>"; }else if (content_fields == 'phone') { result += "<color name=black>" + "Phone/Telefono: " + Provider.GetFieldValue(row, content_fields)+ " <br>"; }else if (content_fields == 'hours') { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ ", "; }else if (content_fields == 'URL') { result += "<color name=black>" + "URL: " + Provider.GetFieldValue(row, content_fields)+ "<br>"; } else { result += "<color name=black>" + Provider.GetFieldValue(row, content_fields)+ "<br>"; } } } result += "<br><p>"; } return result; FusionPro Creator 10.0.3 and producer server (PC/Mac/Server)
  8. I have an update! Must be something else happening with this template (it's an existing one that I didn't create, so there are TONS of rules already). I pulled your code out to a clean new file and it works perfectly. Can't thank you enough for this - many, many thanks!
  9. Thanks, Scott. Not working for whatever reason. When I go to process the project (just one page) it sits for hours on 0%. I'm not sure what the issue is, but it's not fond of that code! I put that into an empty Javascript rule (graphic) and put it into an image box, but nothing.
  10. Hi- Has anyone dealt with creating variable PDFs that are 508 compliant? Are there any tools/tricks/tips with generating these documents with Fusion Creator and not having to post-process them for 508 compliance? Fusion Creator 10.0.3, Producer
  11. Hi- Can anyone help me create a rule that will pull an image from a defined location at random? There could be as few as two images to choose from, could be more, but the selection should be random. This is for print, not web. Creator 10.03, PC, Producer server
  12. I’m using a mutli-line data set with a table and simply would like to add a separator between records (I’m listing patients for a particular provider) but can’t figure it out. Is there something simple I’m missing? Here’s the code I’m currently using, but this has borders all around, and I’d like some indicator when records change (patient). FP 10.0.03, PC, Producer w/6 concurrent licenses. I cannot show data as it is protected health information. var table = new FPTable(); table.AddColumns(7000,8000,8000,6000,6000,6000,30000); var header = table.AddRow(); header.Type = 'Header'; header.Cells[0].Font = 'Open Sans Condensed'; header.CopyCells(0,1,2,3,4,5,6); header.SetContents ("MEMBER NO.", "LAST NAME", "FIRST NAME", "GENDER", "DOB", "ICD10", "ICD10 CODE DESCRIPTION"); var data = FusionPro.GetMultiLineRecords(); for (var rec = 1; rec <= data.recordCount; rec++) { function ExField(str) { return TaggedTextFromRaw(data.GetFieldValue(rec, str)); } var content = ["MEMBER_NBR","LAST_NAME","FIRST_NAME","GENDER", "DOB", "SUSPECT_CODE_ICD10","ICD10_CODE_DESCRIPTION"].map(ExField); var row = table.AddRow(); row.SetContents.apply(row, content); } return table.MakeTags();
  13. We've had this issue sporadically for some time and cannot find a solution. We are using FP Creator 10 and composing on Producer. Records (8.5" x 11" fairly simple documents) render fine without imposition, then when we go to impose 2 up on 17 x 11 for print, MOST records are fine...but some do not render properly. An example could be that the IMB field prints where Last Name should be, etc. It doesn't seem consistent. We've tried to find illegal characters in the data, but can find none, and also have tried running fewer records at a time (thinking it could be a memory issue), and still fails. This is very sensitive data (PHI), therefore I cannot send any documents for review...nor can I have them print improperly, so this is a significant issue for us. Does anyone have any thoughts on what might be happening here? Is this a bug?
  14. I have a sensitive mailing that has a multi-line data file (Excel) where the new record indicator is the National Provider Identifier (NPI) number. I have a rule created to pull in PDFs of ******* records (the filenames are IN the data exactly) of varying lengths, which is not the problem. My template consists of a cover sheet (with address block for the physician), common letter, followed by the ******* record. The problem is, I want to pull all of the patients that belong to a particular NPI, but when I process I only ever get one patient per NPI - even though the data contains many. How can I build this to loop through and include all patients? I can't share any of this data in order to help shed light, as it's protected health information.
  15. Thanks - that worked beautifully!
×
×
  • Create New...