TetraWiki - User contributions [en]

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T11:48:19Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

'''TO IMPORT PRODUCTS:'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra //
User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[File:Screenshot from 2016-03-22 12-43-41.png|750px]]

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
link: www.brijraj.com/index.php/admin
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

Now transfer this file to the brijraj server via gftp as shown below.

[[Image:Brij-15.png|750px]]

Now select overwrite option.

[[Image:Brij-16.png|750px]]

Go to terminal ssh tetra@166.62.16.84 -v

password:- orgi50NoAu4C

# su -

password:- Login&(!-#)

and go to :- cd /var/www/html/brijraj/cron_custom/

then run this php script given below:

#php product_cron_other_way.php

[[Image:Brij-17.png|750px]]

Now wait for the script to complete.

[[Image:Brij-18.png|750px]]

To verify go to brijraj admin page and go to Catalog then Manage Products and check for the products got updated on the Manage Products Page.

[[Image:Brij-19.png|750px]]

Now verify for the products updated are either saree or lehnga or suit. There are three file in the path
'''/var/www/html/brijraj/cron_custom/custom_manual_entry/''' listed below:

add_saree_custom_option_with_entity_id.php

add_lehenga_custom_option_with_entity_id.php
add_suit_custom_option_with_entity_id.php

According to the image above, the products updated are of saree. So we are considering the file name
add_saree_custom_option_with_entity_id.php .
Now edit the add_saree_custom_option_with_entity_id.php file, enter the imported codes and save it.

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-20.png|750px]]

Now gftp the file to the server.

[[Image:Brij-21.png|750px]]

Now run this below link on the browser:

http://www.brijraj.com/cron_custom/custom_manual_entry/add_saree_custom_option_with_entity_id.php

[[Image:Brij-22.png|750px]]

For verification go to brijraj admin page and compare these id's are correct or not.

[[Image:Brij-23.png|750px]]

If not then refresh the page once.

[[Image:Brij-24.png|750px]]

Now we have to verify these updated products on

http://www.brijraj.com/index.php/admin and go to Catalog then Manage Products.

[[File:Brij-27.png|750px]]

Now click on any product and lookfor "Custom Options" at the Bottom Left on that page.
The product details should be updated there. If not updated then it will show a blank page. As shown below:

[[File:Brij-26.png|750px]]

[[File:Brij-25.png|750px]]

'''TO UPDATE PRODUCTS'''

Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

select to Brijraj database and select SQL

For updating products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.lastmodifiedon,'yyyy-mm-dd')='2016-03-01'

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.

First login to the brijraj server and go to the path given below:

# cd /var/www/html/brijraj/cron_custom
# vi product_update_cron_other_way.php

enter the product codes into the file "product_update_cron_other_way.php" in pairs of 4 or 5 and save it. As shown below:

[[File:Brij-28.png|750px]]

Now run the php script as given below:

# php product_update_cron_other_way.php

And wait for the script till its completed.

File:Brij-28.png

2016-03-22T11:45:08Z

Sahil:

File:Brij-27.png

2016-03-22T11:32:18Z

Sahil:

File:Brij-26.png

2016-03-22T11:29:21Z

Sahil:

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T11:19:56Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[File:Screenshot from 2016-03-22 12-43-41.png|750px]]

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
link: www.brijraj.com/index.php/admin
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

Now transfer this file to the brijraj server via gftp as shown below.

[[Image:Brij-15.png|750px]]

Now select overwrite option.

[[Image:Brij-16.png|750px]]

Go to terminal ssh tetra@166.62.16.84 -v

password:- orgi50NoAu4C

# su -

password:- Login&(!-#)

and go to :- cd /var/www/html/brijraj/cron_custom/

then run this php script given below:

#php product_cron_other_way.php

[[Image:Brij-17.png|750px]]

Now wait for the script to complete.

[[Image:Brij-18.png|750px]]

To verify go to brijraj admin page and go to Catalog then Manage Products and check for the products got updated on the Manage Products Page.

[[Image:Brij-19.png|750px]]

Now verify for the products updated are either saree or lehnga or suit. There are three file in the path
'''/var/www/html/brijraj/cron_custom/custom_manual_entry/''' listed below:

add_saree_custom_option_with_entity_id.php

add_lehenga_custom_option_with_entity_id.php
add_suit_custom_option_with_entity_id.php

According to the image above, the products updated are of saree. So we are considering the file name
add_saree_custom_option_with_entity_id.php .
Now edit the add_saree_custom_option_with_entity_id.php file, enter the imported codes and save it.

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-20.png|750px]]

Now gftp the file to the server.

[[Image:Brij-21.png|750px]]

Now run this below link on the browser:

http://www.brijraj.com/cron_custom/custom_manual_entry/add_saree_custom_option_with_entity_id.php

[[Image:Brij-22.png|750px]]

For verification go to brijraj admin page and compare these id's are correct or not.

[[Image:Brij-23.png|750px]]

If not then refresh the page once.

[[Image:Brij-24.png|750px]]

Now we have to verify these updated products on

http://www.brijraj.com/index.php/admin and go to Catalog then Manage Products.
Now click on any product and lookfor "Custom Options" at the Bottom Left on that page.
The product details should be updated there. As shown below:

[[File:Brij-25.png|750]]

File:Brij-25.png

2016-03-22T11:18:56Z

Sahil:

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T11:14:37Z

Sahil:

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T11:12:24Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
link: www.brijraj.com/index.php/admin
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

Now transfer this file to the brijraj server via gftp as shown below.

[[Image:Brij-15.png|750px]]

Now select overwrite option.

[[Image:Brij-16.png|750px]]

Go to terminal ssh tetra@166.62.16.84 -v

password:- orgi50NoAu4C

# su -

password:- Login&(!-#)

and go to :- cd /var/www/html/brijraj/cron_custom/

then run this php script given below:

#php product_cron_other_way.php

[[Image:Brij-17.png|750px]]

Now wait for the script to complete.

[[Image:Brij-18.png|750px]]

To verify go to brijraj admin page and go to Catalog then Manage Products and check for the products got updated on the Manage Products Page.

[[Image:Brij-19.png|750px]]

Now verify for the products updated are either saree or lehnga or suit. There are three file in the path
'''/var/www/html/brijraj/cron_custom/custom_manual_entry/''' listed below:

add_saree_custom_option_with_entity_id.php

add_lehenga_custom_option_with_entity_id.php
add_suit_custom_option_with_entity_id.php

According to the image above, the products updated are of saree. So we are considering the file name
add_saree_custom_option_with_entity_id.php .
Now edit the add_saree_custom_option_with_entity_id.php file, enter the imported codes and save it.

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-20.png|750px]]

Now gftp the file to the server.

[[Image:Brij-21.png|750px]]

Now run this below link on the browser:

http://www.brijraj.com/cron_custom/custom_manual_entry/add_saree_custom_option_with_entity_id.php

[[Image:Brij-22.png|750px]]

For verification go to brijraj admin page and compare these id's are correct or not.

[[Image:Brij-23.png|750px]]

If not then refresh the page once.

[[Image:Brij-24.png|750px]]

Now we have to verify these updated products on

http://www.brijraj.com/index.php/admin and go to Catalog then Manage Products.
Now click on any product and lookfor "Custom Options" at the Bottom Left on that page.
The product details should be updated there.
[[File:Screenshot from 2016-03-22 12-43-41.png|750px]]

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T10:54:07Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
link: www.brijraj.com/index.php/admin
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

Now transfer this file to the brijraj server via gftp as shown below.

[[Image:Brij-15.png|750px]]

Now select overwrite option.

[[Image:Brij-16.png|750px]]

Go to terminal ssh tetra@166.62.16.84 -v

password:- orgi50NoAu4C

# su -

password:- Login&(!-#)

and go to :- cd /var/www/html/brijraj/cron_custom/

then run this php script given below:

#php product_cron_other_way.php

[[Image:Brij-17.png|750px]]

Now wait for the script to complete.

[[Image:Brij-18.png|750px]]

To verify go to brijraj admin page and go to Catalog then Manage Products and check for the products got updated on the Manage Products Page.

[[Image:Brij-19.png|750px]]

Now verify for the products updated are either saree or lehnga or suit. There are three file in the path
'''/var/www/html/brijraj/cron_custom/custom_manual_entry/''' listed below:

add_saree_custom_option_with_entity_id.php

add_lehenga_custom_option_with_entity_id.php
add_suit_custom_option_with_entity_id.php

According to the image above, the products updated are of saree. So we are considering the file name
add_saree_custom_option_with_entity_id.php .
Now edit the add_saree_custom_option_with_entity_id.php file, enter the imported codes and save it.

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-20.png|750px]]

Now gftp the file to the server.

[[Image:Brij-21.png|750px]]

Now run this below link on the browser:

http://www.brijraj.com/cron_custom/custom_manual_entry/add_saree_custom_option_with_entity_id.php

[[Image:Brij-22.png|750px]]

For verification go to brijraj admin page and compare these id's are correct or not.

[[Image:Brij-23.png|750px]]

If not then refresh the page once.

[[Image:Brij-24.png|750px]]

Now we have to verify these updated products on

http://www.brijraj.com/index.php/admin and go to Catalog then Manage Products.
Now click on any product and lookfor "Custom Options" at the Bottom Left on that page.
The product details should be updated there.

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T10:35:07Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

Now transfer this file to the brijraj server via gftp as shown below.

[[Image:Brij-15.png|750px]]

Now select overwrite option.

[[Image:Brij-16.png|750px]]

Go to terminal ssh tetra@166.62.16.84 -v

password:- orgi50NoAu4C

# su -

password:- Login&(!-#)

and go to :- cd /var/www/html/brijraj/cron_custom/

then run this php script given below:

#php product_cron_other_way.php

[[Image:Brij-17.png|750px]]

Now wait for the script to complete.

[[Image:Brij-18.png|750px]]

To verify go to brijraj admin page and go to Catalog then Manage Products and check for the products got updated on the Manage Products Page.

[[Image:Brij-19.png|750px]]

Now verify for the products updated are either saree or lehnga or suit. There are three file in the path
'''/var/www/html/brijraj/cron_custom/custom_manual_entry/''' listed below:

add_saree_custom_option_with_entity_id.php

add_lehenga_custom_option_with_entity_id.php
add_suit_custom_option_with_entity_id.php

According to the image above, the products updated are of saree. So we are considering the file name
add_saree_custom_option_with_entity_id.php .
Now edit the add_saree_custom_option_with_entity_id.php file, enter the imported codes and save it.

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-20.png|750px]]

Now gftp the file to the server.

[[Image:Brij-21.png|750px]]

Now run this below link on the browser:

https://www.brijraj.com/cron_custom/custom_manual_entry/add_saree_custom_option_with_entity_id.php

[[Image:Brij-22.png|750px]]

For verification go to brijraj admin page and compare these id's are correct or not.

[[Image:Brij-23.png|750px]]

If not then refresh the page once.

[[Image:Brij-24.png|750px]]

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T10:21:43Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

Now transfer this file to the brijraj server via gftp as shown below.

[[Image:Brij-15.png|750px]]

Now select overwrite option.

[[Image:Brij-16.png|750px]]

Go to terminal ssh tetra@166.62.16.84 -v

password:- orgi50NoAu4C

# su -

password:- Login&(!-#)

and go to :- cd /var/www/html/brijraj/cron_custom/

then run this php script given below:

#php product_cron_other_way.php

[[Image:Brij-17.png|750px]]

Now wait for the script to complete.

[[Image:Brij-18.png|750px]]

To verify go to brijraj admin page and go to Catalog then Manage Products and check for the products got updated on the Manage Products Page.

[[Image:Brij-19.png|750px]]

Now verify for the products updated are either saree or lehnga or suit. There are three file in the path
'''/var/www/html/brijraj/cron_custom/custom_manual_entry/''' listed below:

add_saree_custom_option_with_entity_id.php

add_lehenga_custom_option_with_entity_id.php
add_suit_custom_option_with_entity_id.php

According to the image above, the products updated are of saree. So we are considering the file name
add_saree_custom_option_with_entity_id.php .
Now edit the add_saree_custom_option_with_entity_id.php file, enter the imported codes and save it.

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-20.png]]

Now gftp the file to the server.

[[Image:Brij-21.png]]

Now run this below link on the browser:

https://www.brijraj.com/cron_custom/custom_manual_entry/add_saree_custom_option_with_entity_id.php

[[Image:Brij-22.png]]

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

goto browser and show the old file then refresh

to the right file

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T10:12:50Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

Now transfer this file to the brijraj server via gftp as shown below.

[[Image:Brij-15.png|750px]]

Now select overwrite option.

[[Image:Brij-16.png|750px]]

Go to terminal ssh tetra@166.62.16.84 -v

password:- orgi50NoAu4C

# su -

password:- Login&(!-#)

and go to :- cd /var/www/html/brijraj/cron_custom/

then run this php script given below:

#php product_cron_other_way.php

[[Image:Brij-17.png|750px]]

Now wait for the script to complete.

[[Image:Brij-18.png|750px]]

To verify go to brijraj admin page and go to Catalog then Manage Products and check for the products got updated on the Manage Products Page.

[[Image:Brij-19.png|750px]]

Now verify for the products updated are either saree or lehnga or suit. There are three file in the path
'''/var/www/html/brijraj/cron_custom/custom_manual_entry/''' listed below:

add_saree_custom_option_with_entity_id.php

add_lehenga_custom_option_with_entity_id.php
add_suit_custom_option_with_entity_id.php

According to the image above, the products updated are of saree. So we are considering the file name
add_saree_custom_option_with_entity_id.php .
Now edit the add_saree_custom_option_with_entity_id.php file, enter the imported codes and save it.

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-20.png]]

Now gftp the file to the server.

[[Image:Brij-21.png]]

https://www.brijraj.com/cron_custom/custom_manual_entry/add_saree_custom_option_with_entity_id.php

[[Image:Brij-22.png]]

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T09:52:24Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

Now transfer this file to the brijraj server via gftp as shown below.

[[Image:Brij-15.png|750px]]

Now select overwrite option.

[[Image:Brij-16.png|750px]]

Go to terminal ssh tetra@166.62.16.84 -v

password:- orgi50NoAu4C

# su -

password:- Login&(!-#)

and go to :- cd /var/www/html/brijraj/cron_custom/

then run this php script given below:

#php product_cron_other_way.php

[[Image:Brij-17.png|750px]]

Now wait for the script to complete.

[[Image:Brij-18.png|750px]]

To verify go to brijraj admin page and go to Catalog then Manage Products and check for the products got updated on the Manage Products Page.

[[Image:Brij-19.png|750px]]

Now verify for the products updated are either saree or lehnga or suit. There are three file in the path
'''/var/www/html/brijraj/cron_custom/custom_manual_entry/''' listed below:

add_saree_custom_option_with_entity_id.php

add_lehenga_custom_option_with_entity_id.php
add_suit_custom_option_with_entity_id.php

According to the image above, the products updated are of saree. So we are considering the file name
add_saree_custom_option_with_entity_id.php .

[[Image:Brij-20.png]]

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T09:18:09Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

Now transfer this file to the brijraj server via gftp as shown below.

[[Image:Brij-15.png|750px]]

Now select overwrite option.

[[Image:Brij-16.png|750px]]

Go to terminal ssh tetra@166.62.16.84 -v

password:- orgi50NoAu4C

# su -

password:- Login&(!-#)

and go to :- cd /var/www/html/brijraj/cron_custom/

then run this php script given below:

#php product_cron_other_way.php

[[Image:Brij-17.png|750px]]

Now wait for the script to complete.

[[Image:Brij-18.png|750px]]

To verify go to brijraj admin page and go to Catalog then Manage Products and check for the products got updated on the Manage Products Page.

[[Image:Brij-19.png|750px]]

Now verify for the products updated are either saree or lehnga or suit. There are three file in the path
'''/var/www/html/brijraj/cron_custom/custom_manual_entry/''' listed below:

add_saree_custom_option_with_entity_id.php
add_lehenga_custom_option_with_entity_id.php
add_suit_custom_option_with_entity_id.php

[[Image:Brij-20.png]]

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T09:03:25Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

Now transfer this file to the brijraj server via gftp as shown below.

[[Image:Brij-15.png|750px]]

Now select overwrite option.

[[Image:Brij-16.png|750px]]

Go to terminal ssh tetra@166.62.16.84 -v

password:- orgi50NoAu4C

# su -

password:- Login&(!-#)

and go to :- cd /var/www/html/brijraj/cron_custom/

then run this php script given below:

#php product_cron_other_way.php

[[Image:Brij-17.png|750px]]

Now wait for the script to complete.

[[Image:Brij-18.png|750px]]
[[Image:Brij-19.png|750px]]

[[Image:Brij-20.png]]

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T09:00:57Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

Now transfer this file to the brijraj server via gftp as shown below.

[[Image:Brij-15.png|750px]]

Now select overwrite option.

[[Image:Brij-16.png|750px]]

Go to terminal ssh tetra@166.62.16.84 -v

password:- orgi50NoAu4C

# su -

password:- Login&(!-#)

and go to :- cd /var/www/html/brijraj/cron_custom/

then run this php script given below:

#php product_cron_other_way.php

[[Image:Brij-17.png|750px]]

Now wait for the script to complete.

[[Image:Brij-18.png|750px]]
[[Image:Brij-19.png|750px]]

[[Image:Brij-20.png]]

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T08:55:51Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

Now transfer this file to the brijraj server via gftp as shown below.

[[Image:Brij-15.png|750px]]

Now select overwrite option.

[[Image:Brij-16.png|750px]]

[[Image:Brij-17.png|750px]]

Now run php script as shown below:

#php

[[Image:Brij-18.png|750px]]
[[Image:Brij-19.png|750px]]

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T08:52:42Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

Now transfer this file to the brijraj server via gftp as shown below.

[[Image:Brij-15.png|750px]]

Now select overwrite option.

[[Image:Brij-16.png|750px]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-17.png|750px]]

[[Image:Brij-18.png|750px]]
[[Image:Brij-19.png|750px]]

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T08:47:04Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png|750px]]

[[Image:Brij-15.png|750px]]

[[Image:Brij-16.png|750px]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-17.png|750px]]

[[Image:Brij-18.png|750px]]
[[Image:Brij-19.png|750px]]

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T08:44:14Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T08:31:32Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T08:30:28Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]
Now go to "Catalog" then Manage Products.

[[Image:Brij-13.png|750px]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T07:36:02Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T07:32:46Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T07:31:47Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Screenshot from 2016-03-22 12-43-41.png|750px]]

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T07:28:11Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Make this formate

then go to brijraj admin panal and login with
username: admin
password: admintetra123!@#

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T07:25:42Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]Make this formate

then go to brijraj admin panal and login

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

File:Screenshot from 2016-03-22 12-43-41.png

2016-03-22T07:21:42Z

Sahil:

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T07:10:58Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

[[Image:Brij-9.png|750px]]

Select blank space after part no. in first line with "Shift+Right Arrow" key and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-10.png|750px]]

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]Make this formate

then go to brijraj admin panal and login

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T07:08:10Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

[[Image:Brij-9.png|750px]]

[[Image:Brij-10.png|750px]]

Select blank space after part no. and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]Make this formate

then go to brijraj admin panal and login

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T07:05:17Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-6.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

[[Image:Brij-9.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

[[Image:Brij-10.png|750px]]

Select blank space after part no. and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]Make this formate

then go to brijraj admin panal and login

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T07:03:29Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-5.png|750px]]

[[Image:Brij-6.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-7.png|750px]]

[[Image:Brij-8.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-9.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

[[Image:Brij-10.png|750px]]

Select blank space after part no. and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]Make this formate

then go to brijraj admin panal and login

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T06:53:28Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

[[Image:Brij-5.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-6.png|750px]]

[[Image:Brij-7.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-8.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-9.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

[[Image:Brij-10.png|750px]]

Select blank space after part no. and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]Make this formate

then go to brijraj admin panal and login

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T06:46:42Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

Select Product_cron_other_way.php and Product_update_cron_other_way.php

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

[[Image:Brij-5.png|750px]]

check as screen and also check your local system location folder and downloaded files.

then
5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

[[Image:Brij-7.png|750px]]

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

[[Image:Brij-6.png|750px]]

select to Brijraj database and select SQL

[[Image:Brij-8.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-9.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

[[Image:Brij-10.png|750px]]

Select blank space after part no. and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]Make this formate

then go to brijraj admin panal and login

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T06:41:59Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

'''Product_cron_other_way.php'''

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as shown below:

[[Image:Brij-4.png|750px]]

[[Image:Brij-5.png|750px]]

[[Image:Brij-6.png|750px]]

check as screen and also check brijraj folder and file for downloaded file.

then

5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

[[Image:Brij-7.png|750px]]

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

select to Brijraj database and select SQL

[[Image:Brij-8.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-9.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

[[Image:Brij-10.png|750px]]

Select blank space after part no. and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]Make this formate

then go to brijraj admin panal and login

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T06:35:44Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

'''Product_cron_other_way.php'''

[[Image:Brij-2.png|750px]]

Transfer these two file to your local system as shown below.

[[Image:Brij-3.png|750px]]
[[Image:Brij-4.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as given in pic

[[Image:Brij-5.png|750px]]

[[Image:Brij-6.png|750px]]

check as screen and also check brijraj folder and file for downloaded file.

then

5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

[[Image:Brij-7.png|750px]]

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

select to Brijraj database and select SQL

[[Image:Brij-8.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-9.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

[[Image:Brij-10.png|750px]]

Select blank space after part no. and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]Make this formate

then go to brijraj admin panal and login

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T06:25:14Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|750px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

'''Product_cron_other_way.php'''

[[Image:Brij-2.png|750px]]

[[Image:Brij-3.png|750px]]
[[Image:Brij-4.png|750px]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as given in pic

[[Image:Brij-5.png|750px]]

[[Image:Brij-6.png|750px]]

check as screen and also check brijraj folder and file for downloaded file.

then

5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/]

I.select postgreSQL and make login with login name and password given below.

[[Image:Brij-7.png|750px]]

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

select to Brijraj database and select SQL

[[Image:Brij-8.png|750px]]

For importing products, copy below query in the SQL tab and execute it.

select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01'

[[Image:Brij-9.png|750px]]

After execute all ,copy part nos. then go to text file and paste it

[[Image:Brij-10.png|750px]]

Select blank space after part no. and press keys 'ctrl+h'. Type [','] in 'Replace with' block and click on 'replace all' and the close it.
as shown below:

[[Image:Brij-11.png|750px]]
[[Image:Brij-12.png|750px]]

[[Image:Brij-13.png]]Make this formate

then go to brijraj admin panal and login

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all

BRIJRAJ's Updation of Products on the Website at Night

2016-03-22T06:11:40Z

Sahil:

[[category:Brijraj]]

'''BRIJRAJ NIGHT WORK'''

To login in '''gftp '''

1.IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

Port:22

[[Image:Brij-1.png|700px]]

2.Local system path(for this system): choose path on your system where you want to save files.
For Example:

'''/home/tetra/Desktop/sant/brijraj '''

3.Path to server:

'''/var/www/html/brijraj/cron_custom'''

4.

Select the file given in picture below and press down arrow key to import file from server to local system.

'''Product_cron_other_way.php'''

[[Image:Brij-2.png|750px]]

[[Image:Brij-3.png]]
[[Image:Brij-4.png]]

Now select '''custom manual entry''' folder and enter in the folder ,now select three file from this as given in pic

[[Image:Brij-5.png]]

[[Image:Brij-6.png]]

check as screen and also check brijraj folder and file for downloaded file.

then

5.Go to Browser and paste [http://182.73.255.242/phpPgAdmin/ http://182.73.255.242/phpPgAdmin/]

I.select to

postgres and login name and password

[[Image:Brij-7.png]]

Detail-

Url :-http://182.73.255.242/phpPgAdmin

D/B :-brijraj

User Name:- postgres

password:- bfl@123

select to Brijraj database and select SQL

[[Image:Brij-8.png]]

For import products.

1.product_cron_other_way.php

(Copy import link from import file and paste this in SQL section,replace * by '''partno then '''edit date and press execute)

'''select itemsubaddinfo.partno from itemsubaddinfo inner join items on (itemsubaddinfo.partno=items.partno) where TO_CHAR(itemsubaddinfo.createdon,'yyyy-mm-dd')='2016-03-01''''

[[Image:Brij-9.png]]

After execute all ,copy '''part no.''' then go to text file and paste it

[[Image:Brij-10.png]]

Copy blank space after part no. And set in this format by '''ctrl+h''' all replace to all space to ','

[[Image:Brij-11.png]]
[[Image:Brij-12.png]]

[[Image:Brij-13.png]]Make this formate

then go to brijraj admin panal and login

[[Image:Brij-14.png]]

[[Image:Brij-15.png]]

[[Image:Brij-16.png]]

[[Image:Brij-17.png]]

8.Go to '''product_cron_ other_way.p'''hp file in brijraj folder in desktop and open the file then paste three part no. into file and save it.

[[Image:Brij-18.png]]
[[Image:Brij-19.png]]

then save and upload the file on gftp server and refresh local side.

[[Image:Brij-20.png]]

then upload the file product_cron_other_way.php

Go to terminal ssh [mailto:tetra@166.62.16.84 tetra@166.62.16.84]

pass:-

su -:-

pass:-

IP:166.62.16.84

User : tetra // User : root

Password : orgi50NoAu4C // pass : Login&(!-#)

and go to :- '''cd /var/www/html/brijraj/cron_custom/'''

then run this command

'''<nowiki>#</nowiki>php file product_cron_other_way.php'''

AS given the picture below

[[Image:Brij-21.png]]

And run this command.

[[Image:Brij-22.png]]

Now refresh the local path in '''gftp'''

For verification go to brijraj admin page and

[[Image:Brij-23.png]]

<nowiki>****E</nowiki>nter the base_entity for saree or suit or lehnga if all product are same than use the 1st quarry for greater value.

Use 2nd quarry for equal base id.

Use 3rd quarry for grater than base id and less than Last ID.

[[Image:Brij-24.png]]

Now save file go to upload '''gftp '''

'''<nowiki>***Always check local and server path</nowiki>'''

[[Image:]]

goto browser and

[[Image:]]

show the old file then refresh

[[Image:]]

to the right file

[[Image:]]

all