Jump to content

dmp

Registered Users - Approved
  • Posts

    44
  • Joined

Converted

  • FusionPro Products
    No

dmp's Achievements

Contributor

Contributor (5/14)

  • First Post Rare
  • Collaborator Rare
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

10

Reputation

  1. Dan, You continue to amaze me good sir. Thank you very much! -Mike
  2. Hi there, Back again with more multi-line ?'s 1. When using the multi-line wizard, it puts in the field name above the data. How can I remove that? I just want the data, no header. I'm guessing convert to Javascript and change something, but I don't know what is pulling the header name: // Rule converted from XML Template "Multi-Line_NAME": // Choose the following values: // Begin XML Template selections // var Field1 = "Member Information"; // "Field for column 1" (Required): FieldList var Field2 = ""; // "Field for column 2 (optional)": FieldList var Field3 = ""; // "Field for column 3 (optional)": FieldList var Field4 = ""; // "Field for column 4 (optional)": FieldList var Field5 = ""; // "Field for column 5 (optional)": FieldList var Field6 = ""; // "Field for column 6 (optional)": FieldList // End XML Template selections // var fields = [Field1, Field2, Field3, Field4, Field5, Field6].filter(String); var XDF = FusionPro.GetMultiLineRecords(); var result = []; for (var r = 0; r <= XDF.recordCount; r++) { var values = []; //for (var c = 0; c < XDF.fieldCount; c++) // values.push(XDF.GetFieldValue(r, c)); for (var f in fields) values.push(XDF.GetFieldValue(r, fields[f])); result.push(values.join("\t")); } return result.join(Chr(13)); 2. I only want sub records to populate (if any) and not the first one of the multi-line record. what would I change to make that happen? 3. I suppose I should also ask if there's a simple way to just call out a specific iteration of multi-lines like: 2nd line, 3rd line, 4th, 5th etc... of a multi-line record so I could manipulate it that way. Thanks for your help!
  3. Ooh thanks Dan, I was typing that while you posted. I will read through it!
  4. OK I think I'm making progress. I got the names to show up. Now I'm having trouble with the VOID box, where I want to do the opposite:Show void when there are no records over an ID Card instead of leaving it blank. I don't think it quite works the same way, so maybe there is a way to show VOID in a box when there's no 4th, 3rd, or 2nd record. Here's what I have so far attached. I added a column VOID in case I need to somehow grab that text instead of some kind of Return text "VOID". ugh sorry I"m not good at this. Anyone have an idea? I'm almost there T.T FP Export.zip
  5. Hi Dan, I saw some code you mentioned in another thread about the multi-line. I tried using that (added a column: FullName) and I have it so it suppresses the boxes if it's not being used, but I don't know how to actually make the boxes display the 2nd, 3rd, etc.. line of the record group. I have this as an OnRecordStart: FindTextFrame("Box0").suppress = true; FindTextFrame("Box1").suppress = true; FindTextFrame("Box2").suppress = true; //FusionPro.Composition.composeThisRecord = FieldChanged("MEMBER"); var data = FusionPro.GetMultiLineRecords(); for (var r = 1; r <= data.recordCount; r++) { FindTextFrame("Box" + (r - 1)).suppress = false; FusionPro.Composition.AddVariable("FullName" + r, data.GetFieldValue(r, "FullName")); } So with this I can see the boxes showing up or not, but they always display the first line of the record instead of each consecutive one. I'm guessing I need to somehow make a rule that says FullName1 = first line, FullName2 = 2nd line etc.? Cheers, Mike Javascript Rocks!
  6. Hi Dan, Thanks for taking a look at this! Here's the FP document along with that sample data. I've got the 4 ID card spots laid out with the top left one being the Head of Household(HOH) name/address for the actual mailing portion. Then the other 3 are using the address & member number which should be the same as the HOH in all 4 spots. The kicker is that they want the dependents(DEP) name (if any) to populate the top right, then bottom left, then bottom right ID cards above the address. And when there is no DEP, to not have any name and just leave the address/member number there. There's also a salutation on the bottom third of the page that is just "Dear <HOH>:" I hope this makes it clearer, thanks again for your help! - Mike test.zip
  7. Hi there, I need some help with making the multi-line work, I was hoping there was a drag & drop option but I guess it's not so simple haha. I have a page with 4 membership cards on it that I need to populate. I have a list with 1 to many lines for each record. There is at least one Head of Household (HOH) and there may or may not be any dependents (DEP) in the HOH or DEP column. There is a member ID that I've setup to be the multi-line identifier when I imported the list. What I would like to do, is have the address of the HOH be in all 4 ID card spots, (which Is easy enough) and then have the HOH name be in the first ID card, and subsequent dependents be in the other 3 cards. If there is no other dependents then it would be blank(name) and just have the address of the HOH. If there are more than 4 lines for a record, I'd like it to just ignore the rest for that member (members only get 4 max cards) I'll attach some mock data. PS. I'm a total n00b at writing code T.T Sample List.zip
  8. OK I tried switching to Gotham font and it did utilize the italicized ' so I thought it was the font again, but I tried different versions of helvetica (about 4 different versions Neue, Std etc..) and all the helvetica's did not utilize the italicized version T.T I will try to convince the client to switch to Gotham, but hopefully we can figure it out seen as how helvetica is kinda popular and all
  9. Hi Dan, It's just a csv file that has a bunch of fields that have apostrophe's in it. I tried a couple other Helvetica fonts with the same result, however trying gotham worked just fine. Is there a way I can denote curly apostrophe in a csv file? Cheers, Mike
  10. Hi there, I am using Helvetica LT Std Italic with some fields and just the apostrophe is coming out straight instead of italic. I can type with that font in all italics just fine in other programs. I've tried composing with the Limit processing to Latin-1 text checked and un-checked. I've also tried reloading the font. Anyone have any ideas? Cheers, Mike
  11. Awesome thanks guys! I will try that out. Cheers, Mike
  12. Hi there, I'd like to do pretty much the same function Trim does in excel. Remove any extra spaces inside the data including trailing or leading spaces. I saw someone posted this is possible with "regular expressions"? I can see in the guide book there is left, right or both trim, but not sure how I would go about making a regular expression for removing both and any extra spaces in the data itself. Thanks much for any help! Cheers, Mike
  13. OK, and then the page and page + 1 just grabs the next page after 1 and 3 respectively? That code worked great. I didn't have success just removing the "" 's though. Thanks Step for explaining it too!
  14. Yes the pages are just named 1 2 3 and 4 respectively. ok so putting the "" changes the meaning! I see. thanks Step What does this mean after the local: ? 1 : 3;
  15. Hi there, I'm getting weird results and I'm not sure where my code is wrong. I have 4 pages all set to unused. Local records are page 1 & 2 Out of state are 3 & 4 so I'm using this OnRecordStart rule but I'll get something like record 1 = pg 1,3,4. if (Field("List")=="Local") { FusionPro.Composition.SetBodyPageUsage("1", true) FusionPro.Composition.SetBodyPageUsage("2", true) FusionPro.Composition.SetBodyPageUsage("3", false) FusionPro.Composition.SetBodyPageUsage("4", false) } if (Field("List")=="Out of State") FusionPro.Composition.SetBodyPageUsage("1", false) FusionPro.Composition.SetBodyPageUsage("2", false) FusionPro.Composition.SetBodyPageUsage("3", true) FusionPro.Composition.SetBodyPageUsage("4", true) }I tried to look at the code Dan wrote for page ranges, but I can't wrap my head around the var i <= 6 i++ stuff. o.O Anyone know what I'm doing wrong here? Cheers, Mike
×
×
  • Create New...