Wasting Time? Time is wasted when:- A group of people must wait for one person.- A Team cannot readily access the same document or data.- A Task must be redone due to insufficient supervision.
'Horizontal' Software may be called a Suite - or a Platform. - It is very flexible & made to Create new information.- Can be used to create Vertical (specific) Applications.- An example would be 'Adobe Creative Suite'or MS Office.Vertical Software is developed for a specific set of Tasks.
The Platform is Broad & flexible by Design.- WYSIWYG Design tools for Novices autogenerates code.- Powerful Editors allow Experts to further customize.- Includes an underlying and thoroughly integrated database.- Robust, multiuser access without onerous fees.
Wasting Talent? Talent is wasted when:- An Expert is assigned a task that is suitable for a Novice.- A Novice is assigned a Task that way over his/her head.- A Novice that is eager to learn new skills is denied access.- Team members are pigeonholed. Latent talent, undeveloped.
There is another 'Great Divide' and that is the one between the Haves and the Have Nots. Younicycle is affordably priced for any business, not just the 'Fortunate 500'. Available as a SaaS (online) or as a Server package.
'Vertical' Software is often called an 'Application'. - It is typically developed for a specific set of tasks.- Is 'powered by' the underlying Horizontal Platform.- An example would be 'Recruiting' or 'Benefit Enrollment'.
Wasting Money? Money is wasted when:- Multiple software packages must be purchased.- Multiple licenses or 'seats' must be purchased for each.- Multiple user interfaces must be learned (extra training).
The Great Divide is Knowledge. If you have the required depth of Knowledge, you can accomplish difficult tasks but without it, you will either 'give up', assign or pay an Expert or purchase yet another limited use software application.
Cost? 1) Server package for $400. No limit on number of users.2) Online vsn (SaaS) = $480 per year (3 users).3) Custom programming from $25 to $75 per hour.
Many spokes. Younicycle's framework will allow you to create many types of Vertical Applications, defined only by your imagination. An Actuary - or a Recruiter, a Benefit Consutant or Insurance Carrier can create compelling, plug-in Solutions.
Need an Edge? Many possibilities:1) Create Customer Solutions & give to them for Productivity.2) Create and sell as a suppemental source of revenue.3) Create, give it away - but charge for added customization.4) Become a Partner. Sell Younicycle + your Solutions.
One wheel. We've designed the IT Vehicle so that:1) Experts can work side-by-side with Novices.2) WYSIWYG Tools auto generate complex code.3) Each 'mini-app' you create can be shared (or sold).
Getting there is the hard part ... but we've made the trip much easier. We have spent many years 'blazing a trail' and building the IT vehicle that can get you there, safely & affordably. Yes, it is easier - but Easy is a relative term.
Start here. Get there. It's a given that you want to provide superior service for your customers and always keep a responsible. technological edge. But how? Younicycle can give you that edge - & be white-labeled for your identity.
It's coming. Like it or not, your competitors are standing outside your customers' front door and can be invited in with a few clicks of a mouse. We have the high tech and you, the relationships. Let's talk while the sun is still out.
Personalizing your Employee Communications is critical whenever personal Knowledege is required. Use Retirement as an example. Why would an employee care about John or Jane Doe's retirement security? Meaningless, inaccurate information is not only irrelevant, it's dangerous. Do it right.
The 3 Steps for effective Employee Communications:1) Inform: Let them know it exists. Where? When?2) Educate Employees: What is it? How does it work?3) Personalize the content. John Doe is not real.
Employers: Collaborate internally, with us or other Vendors 1) We (or other Vendors) can provide Full service2) Do it yourself (DIY). You can always ask for help.3) Initial full service -> then DIY in the future.
Your Employee Benefits may be very Cool - but will be ineffective if they remain Hidden. Employee Benefit Statements help your Group understand & appreciate their Personal, Big Picture. We have more than 20 years of experience and know all the possible pitfalls.
Poor Henry. Overcome by events beyond his control.Approximately 3 minutes.
A Diagram of the 'Connections'
logo (image) placed on the Template
The Chart uses the same dataource & is placed on the template
Table (pebs_1)
Table (pebs_2)
joined
The 2 Tables are JOINED. The desired datafields selected and Casts, Expressions & other functions applied as appropriate.
A datasource is made on the Query.The datasource is like a 'mirror' of the Query and is now a floating layer of data -- accessible by Charts, Templates, Applications, etc.
An Action is created automatically that links the Query to the Datasource.
The XML for your Template is stored safely in your account.The Template loads the XML when launched.
Click the pdf icon. The XML is Saved - and pulls the datasource, merging it into the static template XML. The PDF is then processed on the server.
The Template
PDF
The original purpose of the Younicycle was to allow the development of Personalized (data driven) PDF's for print, specifically Benefit Statements. We soon realized that this goal would require the development of many Tools:
Developing a Rudimentary Benefit Statement with Younicycle: a Personalized PDF for Print
STEP 1
Your first step should be to visually organize your static content - and avoid intermingling data driven content with static content. As an example, when laying out a Template and adding text:
XYZ offers several Options for your Health Care, to include choices of BSBS, Really Good HMO and the new, high-deductible Bla Plan.
XYZ offers several Options for your Health Care, to include choices of BSBS, Really Good HMO and the new, high-deductible Bla Plan.
OK
XYZ offers several Options for your Health Care, to include choices of BSBS, Really Good HMO and the new, high-deductible Bla Plan. You are enrolled in the BCBS Plan with Family Coverage.
Bad
Best
XYZ offers several Options for your Health Care, to include choices of BSBS, Really Good HMO and the new, high-deductible Bla Plan. [ health_text]
STEP 2
Begin developing the variable text alternates for [health_text]. You may have 20 or 100 variations, but at this pont - be more concerned with the variation with the most characters (the longest string of text). Place that in your brackets so that you can see how it affects the textflow. Mapping your 'visual space can be done -- even without 'real data'. Example:
XYZ offers several Options for your Health Care, to include choices of BSBS, Really Good HMO and the new, high-deductible Bla Plan. [You are enrolled in the new, high-deductible Bla Plan with Family coverage.]
It's better to understand issues such as word wrap early, rather than late. Late could mean a redesign of the Template. Depending on the Template, a bit of a nuisance.
Systematically identify Static vs variable data. Keep working until you are OK with placement and static content.
STEP 3
STEP 4
For each Variable item, ask yourself - or your HRIS person: "What data items do we need to Query in order to provide this variable content?"
The answer to this question is rarely 'simple' as the data elements required for benefit statements touch much of your HR system. Since there are 1,000's of possible systems & implementations, the data collection portion of this newsletter will be necessarily brief.
The answer to this question is rarely 'simple' as the data elements required for benefit statements touch much of your HR system. Since there are 1,000's of possible systems & implementations, the data collection portion of this newsletter will be necessarily brief.
This lesson is meant to accompany - the Free Benefit Statement - that comes with Younicycle.Sometimes the best way to learn - is by breaking everything apart - and putting it back together.
SUMMARY Part 1 - Load the Template
Use the YTree (on far left after you login). Select the Template and click 'Load'. The Template will require about 30 seconds to load. After it does, you should see (+ -) the cropped image that is below.
Click on objects & 'see what happens'. Drag objects around, resize, change properties & add - or delete text. See if you can identify what is - and isn't variable data. (Hint: click the lightning bolt, then click the artboard).
The functionality of the editor is similar to any layout Tool -- and is best learned by experimenting.
Click on objects & 'see what happens'. Drag objects around, resize, change properties & add - or delete text. See if you can identify what is - and isn't variable data. (Hint: click the lightning bolt, then click the artboard).
The functionality of the editor is similar to any layout Tool -- and is best learned by experimenting.
If you double-click some text -> insert your cursor -> and then select the 'lightning bolt' from the Toolbar, select a field, it will insert (merge) into the text block.
Part 1Design Editor (The Template)
Part 2 Add Tables(Some Data)
Regardless of how you output your documents, you will eventually need to address the data. Before you walk down that path, set your goals a bit lower. Let's try to get ANY data to be embedded & 'work'. That will be measureable success. The Tables below are NOT set up to be correct - or efficient. They are set up to help you get started with understanding a basic building block, the Table.
STEP 1
STEP 2
STEP 3
STEP 4
Look at the YTree and you will see 2 Tables: peb_1 and pebs_2. Each of them are only 1 row of information. Large Tables could hold millions, even billions of rows.Click on pebs_1 and you will see information about its structure and its values. Review the image below.
use these buttons to Edit the Structure of the Data
Edit is active in the image below
change data types with the drop down listsshown left
Click View to view the Values (data) in the Table
Q: Is there any rhyme or reason to the Structure shown above?A: A little bit, but not much. The Goal is to help you to understand how 2 Tables can be JOINED, with the results getting 'into' the PDF. Baby steps. Click View (Values) and you will see what is below. Also - take a moment to review the Diagram of Connections shown above and see where Tables fit into the Connections.
hmmm. ee_id could be useful
We only have 1 Row (employee).... Inessa Kovtun. Our goal is to get her data INTO the pdf.
Once again using the YTree - navigate to Tables - > peb_2. You will see a different Table, with a different Structure and different data. Both peb_1 and pebs_2 have only 1 row.
As you look at pes_2, see if you can identify the Common element .... the element that both share. See below.
As you look at pes_2, see if you can identify the Common element .... the element that both share. See below.
Once again, we have one employee -Inessa Kovtun - with additional data. The challenge? Get them 'together'.
Compare the 2 Table structures side by side. there may be similarities -but it's hard to know for sure.....
ee_idh_tdbl_tltd_tlife_tvac_daysholidayspers_days
namedohee_ida_wageh_rateptoptwotbtcptw_pctaw_pcth_ddsblissrtrptostbpay_periodshrs_per_pay
Note that descriptions were left empty on both Tables. That is NOT the way to set up a Table. You may forget the meaning - or another person may be left scratching their head. Below would be more helpful:
namedohee_ida_wageh_rateptoptwotbtcptw_pctaw_pcth_ddsblissrtrptostbpay_periodshrs_per_pay
full namehire dateemployee idannual wagehourly ratepaid time offpay for time workedother benefitstotal compensationpay for time worked percentannual wage percenthealth dental contributiondisability benefits contributionlife insurance contributionsocial security contributionretirement contributionpaid time of & special programstotal benefitspay_periods per yearhours per pay period
ee_idh_tdbl_tltd_tlife_tvac_daysholidayspers_days
employee idhealth textdisability textltd textlife textvacation daysholidaysperssonal days
We see that ee_id is common to both Tables. You must also make sure that they are of the same TYPE and in this case - they are both INTEGER. It will be important that both have the same TYPE. In fact, it make no difference at all if one is called ee_id and the other is called identification_code (or whatever). It isn't the name that is important -- it's the type. An integer can JOIN an INTEGER, a STRING a STRING, etc.
So if we JOIN -- where ee_id = ee_id .... well, we'll know something. What we'll know remains to be seen.
So if we JOIN -- where ee_id = ee_id .... well, we'll know something. What we'll know remains to be seen.
Getting Started with 'combining Tables' SQL Editor
I am always doing that which I cannot do, in order that I may learn how to do it.
Pablo Picasso
Pablo Picasso
This walk through includes a brief introduction the above. Our initial Goal -- get any Data into a Template for the creation of a personalized PDF.
on this page