Alex

From UG

(Difference between revisions)
Jump to: navigation, search
(F 27 Apr)
(Replaced content with 'Category:Proj Plans == March == === 20 === * Estimation module * E0 to Bill To Party link')
Line 1: Line 1:
[[Category:Proj Plans]]
[[Category:Proj Plans]]
-
== Current Work ==
+
== March ==
-
* 0002237: [SmartPhone App] ............. <proj parent>
+
=== 20 ===
-
* 0002515: [Estim P&L / Accruals] .......<parent>
+
-
== Code Reviews ==
+
* Estimation module
-
 
+
* E0 to Bill To Party link
-
* [https://dev-kuchma.jaguarfreight.com/repos/ repos]
+
-
 
+
-
=== Acc ===
+
-
 
+
-
* tblCurrency
+
-
*
+
-
 
+
-
==== tbl Currency ====
+
-
 
+
-
<pre>
+
-
 
+
-
-- Table "tblCurrency" DDL
+
-
 
+
-
CREATE TABLE `tblCurrency` (
+
-
  `Id` int(10) NOT NULL AUTO_INCREMENT,
+
-
  `Name` varchar(50) NOT NULL,
+
-
  `Abbreviation` varchar(3) NOT NULL,
+
-
  `IsMain` tinyint(1) NOT NULL DEFAULT '0',
+
-
  PRIMARY KEY (`Id`)
+
-
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 9216 kB';
+
-
 
+
-
DELIMITER ;;
+
-
CREATE TRIGGER `tblCurrency_after_ins_tr` AFTER INSERT ON `tblCurrency` FOR EACH ROW BEGIN
+
-
    INSERT INTO `tblCurrencyExchangeRate` (FromCurrencyId, ToCurrencyId, OfficeId)
+
-
    SELECT NEW.Id, `tblCurrency`.Id, `tblOffice`.Id
+
-
        FROM tblCurrency, tblOffice
+
-
        WHERE NOT `tblCurrency`.Id=NEW.Id;
+
-
    INSERT INTO `tblCurrencyExchangeRate` (FromCurrencyId, ToCurrencyId, OfficeId)
+
-
    SELECT `tblCurrency`.Id, NEW.Id, `tblOffice`.Id
+
-
        FROM tblCurrency, tblOffice
+
-
        WHERE NOT `tblCurrency`.Id=NEW.Id;
+
-
END;;
+
-
DELIMITER ;
+
-
 
+
-
</pre>
+
-
 
+
-
<pre>
+
-
+--------------+-------------+------+-----+---------+----------------+
+
-
| Field        | Type        | Null | Key | Default | Extra          |
+
-
+--------------+-------------+------+-----+---------+----------------+
+
-
| Id          | int(10)    | NO  | PRI | NULL    | auto_increment |
+
-
| Name        | varchar(50) | NO  |    | NULL    |                |
+
-
| Abbreviation | varchar(3)  | NO  |    | NULL    |                |
+
-
| IsMain      | tinyint(1)  | NO  |    | 0      |                |
+
-
+--------------+-------------+------+-----+---------+----------------+
+
-
4 rows in set
+
-
</pre>
+
-
 
+
-
== SVN updates ==
+
-
 
+
-
== Weekly Reports ==
+
-
Related: 0002610: {Alex} ........... <mh report>
+
-
 
+
-
=== 2012 w16 ===
+
-
==== Mon 16 Apr ====
+
-
 
+
-
==== Tue 17 Apr ====
+
-
 
+
-
==== W 18 Apr ====
+
-
 
+
-
* '''GM Split'''  - 1h
+
-
** SIT, etc
+
-
 
+
-
* '''Estim GM''' - 5h
+
-
** completely rewriting SOW: more clear/ simple approach, etc
+
-
 
+
-
* '''Mobile App''' - 0h
+
-
 
+
-
* '''Meetings/Misc''' - 2h
+
-
** ihelp - helping AG to cover for Denise, etc
+
-
** weekly Perry's meeting
+
-
** meeting w/ Marc
+
-
** discussing code management w/ Perry
+
-
 
+
-
'''TOTAL''': 8 hours
+
-
 
+
-
=== 2012 w17 ===
+
-
 
+
-
* GM Split
+
-
* Est GM
+
-
* Mobile
+
-
* Misc
+
-
 
+
-
==== M 23 Apr ====
+
-
* GM Split
+
-
* Est GM
+
-
* Mobile
+
-
* Misc
+
-
==== Tu 24 Apr ====
+
-
* GM Split
+
-
* Est GM
+
-
* Mobile
+
-
* Misc
+
-
** meeting with Denise
+
-
** https issue
+
-
 
+
-
==== W 25 Apr ====
+
-
* GM Split
+
-
* Est GM
+
-
* Mobile
+
-
* Misc
+
-
==== Th 26 Apr ====
+
-
* GM Split
+
-
* Est GM
+
-
* Mobile
+
-
* Misc
+
-
==== F 27 Apr ====
+
-
* GM Split
+
-
* Est GM
+
-
* Mobile
+
-
* Misc
+
-
 
+
-
== Misc ==
+
-
 
+
-
=== SVN addr etc ===
+
-
 
+
-
 
+
-
Reply Reply to all Forward Close Help
+
-
 
+
-
You replied on 12/27/2011 2:25 PM.
+
-
Follow up
+
-
From: Vlad Spichek [v.spichek@elcosol.com] Sent: Tue 12/27/2011 2:16 PM
+
-
To: Alex Dobrovolsky
+
-
Cc:
+
-
Subject: Fwd: Re: SVN relocation
+
-
Attachments:
+
-
View As Web Page
+
-
 
+
-
 
+
-
-------- Original Message --------
+
-
Subject: Re: SVN relocation
+
-
Date: Sat, 05 Mar 2011 22:59:40 -0800
+
-
From: Vlad Spichek <vspichek@gmail.com>
+
-
To: Konstantin Ushakov <ushakovk@mail.ru>, a.pivniak@gmail.com, Gurzov@gmail.com, Roman.Lakhno@gmail.com, andriy.koltsov@gmail.com, mihail.tymoshenko@gmail.com, Alex Dobrovolsky <alex@jaguarfreight.com>
+
-
 
+
-
Hi,
+
-
 
+
-
Correction:
+
-
To be able to use TortoiseSVN from outside the office, slightly different setting is needed:
+
-
In the "TortoiseSVN Setting -> Networks -> SSH"
+
-
SSH client should be set to
+
-
<"C:\Program Files\TortoiseSVN\bin\TortoisePlink.exe" -P 8822 -l username -pw password>
+
-
 
+
-
Note the port number needs to be specified explicitly.
+
-
 
+
-
Regards,
+
-
Vlad
+
-
 
+
-
On 03/01/2011 12:47 AM, Vlad Spichek wrote:
+
-
Hi,
+
-
 
+
-
Please be informed that SVN repository will be moved to the Kiev office by the morning of Wednesday, March 2nd.
+
-
 
+
-
Please consider committing your work to the existing repository at the end of Tuesday, March 1st. This will greatly reduce possibility of complications.
+
-
 
+
-
There will be changes to the way repository is accessed. Unfortunately the transition isn't seamless.
+
-
 
+
-
1. Server address will change. Unfortunately the Kiev office doesn't run any naming scheme which could allow for uniform access from inside and outside of the office.
+
-
Server's internal address is 192.168.0.2, server's external address is 82.207.113.107 (aka kuchma.jaguarfreight.com). If you have suggestions of a name for the server other than <kuchma>, please let me know, it's not too late to change it.
+
-
2. The protocol used to access the repository will change to "svn+ssh://". The full URL then will look like
+
-
 
+
-
<svn+ssh://kostya@192.168.0.2:8822/srv/repos/cybertrax/trunk/...>
+
-
 
+
-
 
+
-
svn+ssh://kostya@82.207.113.107:8822/srv/repos/cybertrax/trunk/
+
-
 
+
-
 
+
-
<kostya> will need to be changed to your name. For access from outside the office <192.168.0.2> will need to be changed  to <82.207.113.107> or <kuchma.jaguarfreight.com>. If needed </trunk/> will be replaced to specification of tag or branch you are interested in.
+
-
3. Authentication will be done by SSH, against standard Linux password database and/or SSH public key. I have created standard Linux accounts for everyone on the server, and assigned initial passwords, at the earliest convenience, please, changes them to your individual secret combination.
+
-
 
+
-
* To change your Linux password. For this you need to have Putty SSH client, it can be downloaded from <http://www.chiark.greenend.org.uk/~sgtatham/putty/>, no installation is required. Please open SSH connection to the server (using port 8822). After you get to the Linux command line enter <passwd>, enter your old password, then, twice your desired new password.
+
-
* As is TortoiseSVN will as for a password each time you do anything with the repository. To remove this inconvenience there are two ways:
+
-
1) To hardcode the password in TortoiseSVN configuration. This is not the preferable way, but very easy to start. From the pop-up menu of the File Manager, select TortoiseSVN Setting -> Networks -> SSH and set ssh client to TortoisePlink.exe, which comes together with TortoiseSVN (It is usually in <C:\Program Files\TortoiseSVN\bin\TortoisePlink.exe>). You can add two additional arguments after TortoisePlink.exe to avoid entering your username and password everytime: <C:\Program Files\TortoiseSVN\bin\TortoisePlink.exe -l username -pw password>
+
-
 
+
-
2) To use SSH open key authentication, follow one of these manuals:
+
-
<http://www.noah.org/wiki/Tortoise_SVN_with_PuTTY>
+
-
<http://www.ualberta.ca/CNS/RESEARCH/LinuxClusters/pka-putty.html>
+
-
<http://www.mono-project.com/Putty_and_TortoiseSvn>
+
-
 
+
-
On Wednesday I'll be checking my email and Skype more often to help resolve any troubles you might have.
+
-
Don't hesitate to contact me if you have any questions/suggestions.
+
-
 
+
-
PS together with Linux passwords, please change also Samba passwords using "smbpasswd".
+
-
 
+
-
Regards,
+
-
Vlad
+

Revision as of 17:16, 20 March 2013


March

20

  • Estimation module
  • E0 to Bill To Party link
Personal tools