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ää: php replace mysql file, write name items online, width first search, webapp example, price file, php description, php create table, php color code, new line php, large format price list, indexed data, email application php, create table php, application web php mysql, place txt file mysql, mysql txt file php, write txt mysql php, file parsing mysql, parsing mysql file, table php txt file, write txt php, php write txt file, php order field, files file php mysql, php file parsing

About the Employer:
( 90 reviews ) 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