Project Detail

Description

There's a short description, and a long description, short first:

I want a php script to combine 3 types of files to create many csv files.

Types:
1. keyword.csv
2. domains.txt
3. random.txt (random words)

keyword.csv contains many rows:
keyword1,url1
keyword2,url2
..all the way to..
keyword87372,url87372

domains.txt contains many rows:
subdomain1.domain.com
subdomain2.domain.com
..all the way to..
subdomain392881.domain.com

random.txt contains many rows:
random1
random2
..
random389723


Together they are used to create many csv files:
File1:
random1.subdomain1.domain.com.csv which contains:
keyword1,url1
..
keyword300,url300

File2:
random2.subdomain1.domain.com.csv
keyword301,url301
..
keyword600,url600

etc..

Look at the CSVBuilderModel.jpg to get a clear picture.

****************************
Here's the long description:
****************************

PHP Script run in linux environment, it builds CSV files with these conditions:

3 Types of files exist:
A. A folder of keyword csv files(may be more than 1 keyword file)
/keywords/keywordlist1.csv
..
/keywords/keywordlist30.csv

B. domain txt file
/setup/domains.txt

C. random words file
/setup/randomwords.txt


File Specs:
A. Keywordlist.csv file may contain anywhere from 100-100,000+ rows of data
B. Domains.txt file may contain 10,000+ rows
C. Randomwords.txt file contains 50,000+ rows

What's contained in these files:
A. keywordlist.csv file format:
keyword phrase,URL
keyword phrase2,url2
keyword phrase3,url3

B. domains.txt file format:
subdomain.domain.com
subdomain2.domain.com
subdomain3.domain.com

C. randomwords.txt file foramt:
randomword1
randomword2
randomword3

******************************************

What I need the script to do:
Put all these information in CSV files with these parameters -
1. Create CSV files with the RANDOM WoRDS file & DOMAIN in the file NAME like so:
randomword1.subdomain.domain.com.csv
randomword2.subdomain.domain.com.csv
randomword3.subdomain.domain.com.csv

2. Within each randomword1.subdomain.domain.com.csv file, contains randomly anywhere between 200-300 rows of data pulled sequentially from the keyword file.
So if the keyword file contains 3,000 keywords, the script may create 10 files like so:

Filename 1: randomword1.subdomain.domain.com.csv
File 1 Content:
keywordphrase1,url1
..
keywordphrase300,url300

..all the way to..

Filename 10: randomword10.subdomain.domain.com.csv
File 10 Content:
keywordphrase2700,url2700
..
keywordphrase3000,url3000

3. In the domains.txt file, each subdomain maybe only used to name 50 CSV files max.
For example:
/generatedfiles/randomword1.subdomain.domain.com.csv
..
/generatedfiles/randomword250.subdomain5.domain.com.csv

I should also have the option to ignore the randomwords.txt file, so the generated files may look like this:
/generatedfiles/subdomain1.domain.com.csv
..
/generatedfiles/subdomain250.domain.com.csv

***************************************************

So before:
/keywords/keywordlist1.csv
..
/keywords/keywordlist30.csv
/setup/domains.txt
/setup/randomwords.txt
/generatedfiles/
thescript.php

and After:
/keywords/keywordlist1.csv
..
/keywords/keywordlist30.csv
/setup/domains.txt
/setup/randomwords.txt
/generatedfiles/randomword1.subdomain.domain.com.csv
..
/generatedfiles/randomword250.subdomain5.domain.com.csv
thescript.php

or After:
/keywords/keywordlist1.csv
..
/keywords/keywordlist30.csv
/setup/domains.txt
/setup/randomwords.txt
/generatedfiles/subdomain1.domain.com.csv
..
/generatedfiles/subdomain3892.domain.com.csv
thescript.php

CSV Builder.zip is just to show you a structure.


Additional files submitted:
csvbuildermodel.jpg
csv builder.zip