Monday, December 29, 2014

Multi-dex support solves this problem. dx 1.8 already allows generating several dex files. Android L will support multi-dex natively, and next revision of support library is going to cover older releases back to API 4. It was stated in this Android Developers Backstage podcast episode by Anwar Ghuloum. I've posted a transcript (and general multi-dex explanation) of the relevant part. Update (10/17/2014): As anticipated, multidex support is shipped in revision 21 of Android Support Library. You can find the android-support-multidex.jar in /sdk/extras/android/support/multidex/library/libs folder. Update (10/31/2014) Gradle plugin v0.14.0 for Android adds support for Multi-Dex. To enable, you just have to declare it in build.gradle: android { Android Error: defaultConfig { ... multiDexEnabled = true } } Update (11/3/2014) Google finally released an official description.

Multi-dex support solves this problem. dx 1.8 already allows generating several dex files.
Android L will support multi-dex natively, and next revision of support library is going to cover older releases back to API 4.
It was stated in this Android Developers Backstage podcast episode by Anwar Ghuloum. I've posted a transcript (and general multi-dex explanation) of the relevant part.
Update (10/17/2014):
As anticipated, multidex support is shipped in revision 21 of Android Support Library. You can find the android-support-multidex.jar in /sdk/extras/android/support/multidex/library/libs folder.
Update (10/31/2014)
Gradle plugin v0.14.0 for Android adds support for Multi-Dex. To enable, you just have to declare it inbuild.gradle:
android {
   defaultConfig {
      ...
      multiDexEnabled = true
   }
}
Update (11/3/2014)
Google finally released an official description.

Sunday, December 28, 2014

installation error: install_parse_failed_no_certificates

to solve: right click the project folder and select Android Tools--> Fix project properities.

Then, clean the project and rebuild it.

Thursday, December 11, 2014

Add, move, or delete connection points in Visio

Add, move, or delete connection points


A connection point is a special point on a shape that you can “glue” connectors and other shapes to. It looks like a blue x (Connection point image - blue X). When you glue a connector or shape to a connection point, they stay connected, even if one of the shapes is moved. Use connection points when you want connectors or shapes to stay connected to specific points on a shape.
NOTE   Connection points are not the only places you can glue connectors and lines. You can also glue connectors and lines to shape vertices, shape handles, and shape geometry. For information on how to glue to these shape features, see Add and glue connectors with the Connector tool.
A shape with four connection points.
A shape with four connection points.

In this article


Add connection points

If the shape you want to glue a connector or shape to doesn’t have a connection point where you want it, it’s easy to add one.
  1. If connection points are not visible, on the View menu, click Connection Points.
  2. Select the shape.
    NOTE   If you don’t select the shape first, you can’t add a connection point to it. The shape is selected shape if it has a green, dashed border around it.
  3. Click the Connection Point tool Button image.
    If you don’t see the Connection Point tool, click the down arrow next to the Connector tool Button image, and then click the Connection Point tool Button image.
  4. Press CTRL and click where you want to add a connection point.
  5. If you want an outward or inward & outward connection point, right-click the connection point and clickInwardOutward, or Inward & Outward.
    • Most of the time, you want an inward connection point. An inward connection point “attracts” the endpoints on connectors and the outward and inward & outward connection points on two-dimensional (2-D) shapes.
    • If you have a 2-D shape that you want to glue to another shape, you want an outward connection point. An outward connection point is “attracted to” inward connection points.
    • If you have a shape and you don’t know how you want it to be glued to other shapes, you want aninward & outward connection point.
  6. Click the Pointer tool Button image to return to normal editing.

Add text next to a connection point

Unfortunately, you can’t add text directly to a connection point. You can, however, add text to the shape and then move the text next to the connection point.
  1. Select the shape.
  2. Start typing. The text you type appears in the shape.
  3. Click the Text Block tool Button image.
    If you don’t see the Text Block tool, click the down arrow next to the Text tool Button image, and then click the Text Block tool Button image.
  4. Drag your text.
TIP   If the shape has a control handle Control handle image - yellow diamond, you might be able drag it to move shape text quickly.

Move connection points

If you’re not happy with where a connection point is located, you can move it.
  1. Select the shape.
    NOTE   If you don’t select the shape first, you can’t move the connection point. The shape is selected shape if it has a green, dashed border around it.
  2. Click the Connection Point tool Button image.
    If you don’t see the Connection Point tool, click the down arrow next to the Connector tool Button image, and then click the Connection Point tool Button image.
  3. Drag the connection point you want to move.
    If you don’t see any connection points, on the View menu, click Connection Points.
  4. Click the Pointer tool Button image to return to normal editing.
If you’re having a hard time moving the connection point to exactly where you want it, try different snap settings:
  • On the Tools menu, click Snap & Glue, and then on the General tab, under Snap to, select the options you want.


Delete or hide connection points

Sometimes connection points can get in the way. When they do, you have two choices: delete them or hide them.

Delete a connection point

  1. Select the shape.
    NOTE   If you don’t select the shape first, you can’t delete the connection point. The shape is selected shape if it has a green, dashed border around it.
  2. Click the Connection Point tool Button image.
    If you don’t see the Connection Point tool, click the down arrow next to the Connector tool Button image, and then click the Connection Point tool Button image.
  3. Click the connection point you want to delete. The connection point turns magenta.
    If you don’t see any connection points, on the View menu, click Connection Points.
  4. Press DELETE.
  5. Click the Pointer tool Button image to return to normal editing.

Hide a connection point

  • On the View menu, click Connection Points.

Friday, November 28, 2014

To check the row number of the csv file, using the following command
wc -l filename.csv
Consider files coming with 1 record I am getting some files with * at the start and for those files if I issue the same command I am getting count as 0. Does * mean anything in here and gimme a command that solves the issue.

Wednesday, November 19, 2014

but middle n line in the linux FS

If you want lines from 20 to 30 that means you want 11 lines starting from 20 and finishing at 30:
head -n 30 $file | tail -n 11
That is, you firstly get first 30 lines and then you select the last 11=30-20+1 ones.
So in your code would be:
head -n $3 $1 | tail -n $(( $3-$2 + 1 ))
Based on firstline = $2lastline = $3filename = $1
head -n $lastline $filename | tail -n $(( $lastline -$firstline + 1 ))
Writing in the bash, it should be the following
#!/bin/bash
(head -n +14 MergedTesting162.csv| tail -n 7) > Person1_Dat2Test.csv

Highlight the lowest and highest value in an Excel row or column



excel-logo.png

Finding the lowest or highest value in an Excel row or column is simple using the MIN() and MAX() functions, respectively. You just drop in the function and specify the range.
Highlighting the minimum or maximum value within an Excel row or column takes a bit more work. You might consider using the built-in Top 10 Items and Bottom 10 Items rules and changing 10 to 1, but it won't work the way you expect. This rule highlights values for the entire data range; it doesn't consider individual rows or columns. 
There's more than one way to achieve the results you want; the method you choose is up to you. The downloadable demo files (.xls and .xlsx formats) include the Excel workbook used in this article.

The easy way

The easiest way to apply this particular conditional format is to enter the appropriate function and then base a conditional format on the results of that function. For example, let's suppose we want to highlight the lowest price for each part in the sheet (Figure A). As you can see in Figure A, the MIN() functions in column F return the minimum value for each row.
Figure A

ExcelCondFormat_FigA_012314.JPG

After adding the MIN() function, you're ready to add a conditional format rule. Follow these steps.
1. Select the data range. In this case, that's B2:E4.
2. On the Home tab, click Conditional Formatting in the Styles group. In Excel 2003, choose Conditional Formatting from the Format menu and skip to step 5.
3. In the resulting dialog, choose New Rule.
4. In the top pane, select the Use A Formula To Determine Which Cells To Format option.
5. In the lower pane, enter the formula =B2=$F2. In Excel 2003, retain the default condition of Formula Is, and enter the same formula.
6. Click the Format button.
7. In the resulting dialog, click the Fill tab. In Excel 2003, click the Patterns tab.
8. Select a color and click OK. Figure B shows the formula and the formatting preview. 
Figure B 

ExcelCondFormat_FigB_012314.JPG

9. Click OK to apply the new conditional format. As you can see in Figure C, the highlighted value in each row is the same value returned by the MIN() function in column F.
Figure C 

ExcelCondFormat_FigC_012314.JPG

To highlight the highest value, use MAX() instead of MIN(). To find the minimum or maximum value in a column, add MIN() or MAX(), respectively, to the bottom of the data range and use this formula rule in step 5 =B2=B$5.

Minus column F

Adding a new column (or row) usually won't be a problem; if it is a problem, you can hide the new column or row. (I don't recommend hiding data as a rule; it's easy to forget data you can't see.) If you don't want to add a function to the sheet, you can add the function to the rule. To use this method, complete the earlier steps, but in step 5, enter this formula rule=B2=MIN($B2:$E2). (If you're working with the same example sheet, clear the first formatting rule before applying the new one.)
The results are the same, but the rule doesn't rely on the functions in column F. If you delete those functions, the conditional format will continue to work. As before, to highlight the maximum value, use the MAX() function. To evaluate columns instead of rows, use this rule formula =B2=MAX(B$2:B$4).

A monkey wrench

One of the cells in the data range (E3) is blank, because entering a 0 to indicate the vendor doesn't offer this product has an unfortunate impact on the format (Figure D). The conditional format highlights 0, but 0 isn't the lowest price; in this case, 0 indicates that the vendor doesn't offer that particular part.
Figure D 

ExcelCondFormat_FigD_012314.JPG

If you're working with a data set that requires 0, but you want the conditional format to disregard them, use this formula rule =B2=(MIN(IF($B2:$E2>0,$B2:$E2))).
As you see in Figure E, this rule ignores the value 0, but the MIN() function in F3 doesn't. You can use a similar formula in column F as an array =MIN(IF($B2:$E2>0,$B2:$E2)).
To enter the formula as an array, type it in as you normally would, but instead of pressing [Enter], press [Ctrl]+[Shift]+[Enter]; this will display brackets ({ }) around the formula to indicate it's an array formula. Then, copy the array to complete the column (or row).
Figure E

ExcelCondFormat_FigE_012314.JPG

Array formulas are common in complex sheets, so I don't recommend them for the average user; they require specialized knowledge that many users don't have. If you inadvertently change one, you might not have the expertise to fix it. If you're not familiar with using and maintaining array formulas, use the formula rule instead.