En cours

need a script to find and deploy from xls or csv

Hi,

I am looking for a program/script to run every hour to look for a file and if the file exist then i want it to go though our process and check out the file and deploy it to the directories specified in a xls or csv file.

process:

1. create directory specified in xls. (this will be in one of the column's and row's on the second workbook. (this is the starting directory)

2. script goes though the xls second workbook to find the tag(tag will change so the second workbook on one column and one row will only specify tag.)

3. I will provide you with the script that the this script will need to execute in order to check out the file with the tag specified in workbook2 and extracted to the directory specified in the first step.

4. the script is to find all of the files that have been checked out and if the file names are matched with the ones in the spreadsheet then it will continue.

5. if the files do not match i will need it to send me a email.

6. once confirmed that the files are matched it will need to copy the files to the specified directories on workbook 3.

7. if the filenames already exist then it will rename the file <filename>.B<date and time> example 201207230123

8. once it is copied it will send a email to me and another group (i will provide you with the email addresses) for confirmation of the files copied.

9. there will need to be a timestamp log for everything this program runs.

10. would like a errorlog with a timestamp as well.

notes:

the tags will change everytime the script is run

filenames will be the same so when the script is complete i need it changed to the tag that the program has run and the date and time completed.

there will be a directory that the users will place the files needed to be checked out

the files that they are putting into the directory will follow a filename structure.

i will need to setup a cron job so that this job runs every hour. so there will need to be another script for if the file exist then run this script. if not then create a log saying there was no new files.

I can provide full details to the person who is willing to take this project.

Compétences : Perl, PHP, Script Install, Script Shell, Architecture Logicielle

Voir plus : look new job, starting new job, spreadsheet script, program find, php find person, hour change 2012, find new job, deploy script, look person, csv spreadsheet, xls, row b, names column, log, deploy, php process csv, php script rename files, php script execute, spreadsheet csv, full deploy, php create csv file, want find person, php workbook, workbook csv, spreadsheet copy csv

Concernant l'employeur :
( 5 commentaires ) Toronto, Canada

N° du projet : #2329162

Décerné à :

jc1518

I am willing to take this project, please see my PM for details.

100 $ USD en 2 jours
(4 Commentaires)
4.0

13 freelance ont fait une offre moyenne de 141 $ pour ce travail

toinnisfree

pls chk pmb

250 $ USD en 3 jours
(628 Commentaires)
8.1
rajeshsonisl

Clear with requirement. Quality work assured. Ready to get started. Thanks.

400 $ USD en 1 jour
(476 Commentaires)
7.5
gangabass

I can do this for you. See PM for details.

90 $ USD en 2 jours
(236 Commentaires)
6.4
gvuyk

Hello, please check PM

80 $ USD en 2 jours
(26 Commentaires)
5.1
bwebdesignnet

Hello, Please check your PMB for more details! Thank you!

100 $ USD en 1 jour
(12 Commentaires)
3.2
a2infotech

Hello Sir, I'm intrested in your job.Please check your message board. thanks, A2infotech

100 $ USD en 5 jours
(4 Commentaires)
2.8
parker2012

Hi , I am doing automation using shell scripting for last four years. I will complete this in 6 days. Regards, Parker

100 $ USD en 6 jours
(2 Commentaires)
1.2
manishdave1

i have 5+ years of exp in Unix.Please share more information and give me time zone details where we can talk in detail. Waiting for your reply. Thanks

60 $ USD en 3 jours
(0 Commentaires)
0.0
Saurabh8

i can do this

150 $ USD en 4 jours
(0 Commentaires)
0.0
prajaktavb

I worked on shell scripting and such project previously. And I will be fully devoted to this task and will provide you within 5 days. Expecting your positive reply. Thanks in advance.

150 $ USD en 5 jours
(0 Commentaires)
0.0
MomoF

Hello! I can do this project for you. I work with automated unix shell scripts on a daily basis. Best regards

100 $ USD en 5 jours
(0 Commentaires)
0.0
k2swebtech

Hello, I am Server Administrator and having 2 yr of experiences in it.I have good knowldege of shell script for making auto process and made scripts for auto deploy process of website content and move sites from one s Plus

150 $ USD en 7 jours
(0 Commentaires)
0.0