Käynnissä

PHP - MySQL txt file parsing - Repost

I have a large web based MySQL application written in PHP which needs some tweaking.

Task 1

I have a routine that parses a certain format text file. The routine works fine. I would like to parse 2 other format text file which are slightly different.

Task 2

Add another search button to globally search the ord_notes field.

YOU MUST BE THE ACTUAL CODER - please do not bid if you will be relying on a team or sending this work to someone else. You must be good at working within code done by others.

Now instructions for parsing the other files:

Notice line 1 of the files - they are either:

parser: magneking-rtd OR

parser: stickerz-payment-rtd

Your first step will be to isolate these 2 types of txt files separaterly. The

existing code parses files which do not have these headers. Your assignment is

to create routines to parse these 2 types of txt files. Below I will explain

how to handle each type. If you review the existing parse routines, the code

will be very similar.

FOR parser: stickerz-payment-rtd files:

---------------------------------------

1. email address is an indexed field. If the email address already exists,

overwrite the existing mailaddr1, mailcity, mailstate, mailzip... fields. If

the email is now append the data to a new record.

2. write the entire contents of the txt file into the ord_notes field.

3. select NO SHIPPING for "ord_shipmethod" of the ORDER table.

4. set "ord_begin" to todays date.

5. for the items table.... notice the ***NEW ITEM delimiter... There may be more

than one item.

6. place the "qty:" in the item_qty field

7. place the "item:" in the item_code field

8. place the "line1:" in the item_desc field

9. place "price:" in the item_unitprice field

10. place "unitwt:" in item_weight field

11. replace the "color:" with its NAME not RGB value in item_color. (list of

color names attached)

12. item_size = concatenation of height: & "x" & width: example "16 x 36"

height: 16

13. repeat 6-12 for each item in the order

14. shipping charges are also placed as an item in the item table because online

shipping is slighly different that calculated shipping in webapp.

15. for shipping place the following in the item table:

a) qty = 1

b) item_unitprice = "shipping:"

c) item_code = "SHIPPING"

d) item_desc = "shipmethod"

FOR parser: magnetking-rtd files:

---------------------------------------

1. email address is an indexed field. If the email address already exists,

overwrite the existing mailaddr1, mailcity, mailstate, mailzip... fields. If

the email is now append the data to a new record.

2. write the entire contents of the txt file into the ord_notes field.

3. select NO SHIPPING for "ord_shipmethod" of the ORDER table.

4. set "ord_begin" to todays date.

5. for the items table.... notice the ***NEW ITEM delimiter... There may be more

than one item.

6. place the "qty:" in the item_qty field

7. place the "item:" in the item_code field

8. place the "product:" in the item_desc field

9. place the "description:" in the item_size field

10. place "price:" in the item_unitprice field

11. place "unitwt:" in item_weight field

12. replace the "color:" with its NAME not RGB value in item_color. (list of

color names attached)

13. repeat 6-12 for each item in the order

14. shipping charges are also placed as an item in the item table because online

shipping is slighly different that calculated shipping in webapp.

15. for shipping place the following in the item table:

a) qty = 1

b) item_unitprice = "shipping:"

c) item_code = "SHIPPING"

d) item_desc = "shipmethod"

Taidot: PHP

Näytä lisää: explain parse mysql txt file, parse txt mysql, php replace mysql file, write txt file mysql table php, write name on items online, width first search, webapp example, type of button in php with code, price file, php description, php create table, php color code, new line in php, large format price list, indexed data, how to write table of contents, how to write at in email address, how do you write contents, email application in php, create table php, contents of product description, application web php mysql, php parse txt file mysql, text file parse php mysql, place txt file mysql

Tietoa työnantajasta:
( 90 arvostelua ) Port Charlotte, United States

Projektin tunnus: #448196

Myönnetty käyttäjälle:

paramountworks

I am ready to work on this. Please refer to your PMB. thanks

50 $ USD 0 päivässä
(62 arvostelua)
6.0

2 freelanceria on tarjonnut keskimäärin 55 $ tähän työhön

marcinzygmunt

I can do this job for You.

60 $ USD 1 päivässä
(27 arvostelua)
4.8