Posts Tagged value

Prestashop 1.4 Bugs

I recently upgraded my site to Prestashop 1.4, and I have a few bugs that need to be worked out. The site is essentially broken at the moment, so Id like to get these issues taken care of immediately.

Website URL: http://www.modern-crafts.com/

Issues:
Missing categories
Footer is vertical, needs to be horizontal, footer content edits
Smarty3 not working
Java errors:
jQuery Easing v1.3, jquery.fancybox-1.3.4.css, js/order-address.js, Warning: Unknown pseudo-class or pseudo-element last, Unknown pseudo-class or pseudo-element visible, Unknown pseudo-class or pseudo-element First, Unknown pseudo-class or pseudo-element hidden, Error in parsing value for filter, Error in parsing value for eq, Declaration dropped, Unknown pseudo-class or pseudo-element first. Malformed simple selector as negation pseudo-class argument first, Expected color but found #ff. Error in parsing value for color. Declaration dropped.

Product page issues: (all)
http://www.modern-crafts.com/product.php?id_product=52
Thick box images reloading in a new window, should be on same page.

Header Issues:
When currency and Language blocks are disabled, the permalinks move underneath the logo, positioning does not fix.

Tags: , , , , , , , , , , , , , , , ,

VS FormView Insert

USING:
SQL 2005-2008
VS 2005 – 2008 – 2010 VB

Im having problem, and cant seem to find any solutions using Google, to be able to pre-fill textboxes in FormViewInsert mode, using data from Table A, and saving form contents into Table B.

I need a small demo created showing the process, along with detailed instructions. Need an example using both EXEC Stored Procedure and a query, and using Northwind database. Form will be called with a link using QueryString value or Session value. Link(s) on non related page may call the form, and thus would need ModeChange to insert.

Tags: , , , , , , , , , , , , , , , ,

Import Stock Updates Into Magento 1.5

We are looking for a PHP script that will update stock levels in Magento by directly writing updates to the MySQL database. The information is provides as a CVS file (two columns SKU and stock level) sitting on a local file system. The script iterates through the Magento product table using the SKU (the SKU in the Magento is prefixed – so the prefix needs to be stripped of; only two letters) to look up stock values in the provided CVS file and updates Magento with this value. If the value is Zero that that product has to be set to out of stock in the database as well and if the value is greater than Zero it needs to be verified that the product is set to in stock. If a Magento product (SKU) is not in the provide CVS file an Email should be send with that SKU.

Tags: , , , , , , , , , , , , , , , ,

List Of Food With Nutritional Value In Spanish

I need a list of all available food (that are thousands of aliments!) with its nutritional value. The nutritional values I need are: calories, proteins, carbohydrates and fat. Everything has to be in spanish and it should focus on food consumed in Spain and Latin America.
The list may be in excel, word, pdf or any other established format.

Tags: , , , ,

CSV Files Processing

Hello,

I need someone who is very familiar with csv files, texts processing read/write, regular expressions, C# programming and Visual Studio, to develop a simple desktop based application with 7 functions handling with csv files as defined below. The desktop application GUI has a TabPage for each function. The platform to run the application is Microsoft Windows Server 2008 but could be runnign on any Windows platform. The csv files could have 5000 rows or more, so the application should be robust enough to execute the functions properly.
All the sourcing codes of the application should be sent to me.

1) First TabPage with name "New Titles" :

1.1) The format of the csv file is using standard csv files rules as per this link http://en.wikipedia.org/wiki/Comma-separated_values
The first line of the csv file has column headers. CSV is a delimited data format that has fields/columns separated by the comma character and records/rows terminated by newlines. Fields that contain a special character (comma, newline, or double quote), are enclosed in double quotes. If a line contains a single entry which is the empty string, it is enclosed in double quotes.
Fields with embedded double-quote characters must be enclosed within double-quote characters, and each of the embedded double-quote characters must be represented by a pair of double-quote characters.
These rules wil help you to parse the csv file, I think there are already many existing and available C# librairies functions you can use to read/parse csv files with these rules above.
Is is important that the saved result csv files should copy exactly the fields value of the input csv file AS-IS, except of course for the fields which are modified as per the functions defined below. It means that for example if any fields values are within double-quotes, the result csv file should have the same field value within double-quotes.
See attached the sample format of csv file for this TabPage.

The format of the added csv file of this TabPage is :
– Name,Audio,Text,Image,Text,Image,Text,Image,Text,Image,Text,Image,Text,Title,Title2,Title3,Title4,Category,Tag,Description,Username,Password,DeveloperKey,ApplicationID,AmazonCategory
or
– Name,Audio,Image,Text,Image,Text,Image,Text,Image,Text,Image,Text,Title,Title2,Title3,Title4,Category,Tag,Description,Username,Password,DeveloperKey,ApplicationID,AmazonCategory

Just notice that in the second format, just the first Text column is removed compared to the first format. The application should only consider the columns which are used and modified in this function, and should ignore all the other columns and simply copy them AS-IS to the result csv file.

1.2) GUI design :

1.2.1) The name of the TabPage is New Titles, create a datagrid in the Keyword TabPage, the datagrid has 4 columns, Select column, Filename column, Path column, Status column.
The "Add Files" button add a csv file into the datagrid, the "Clear List" button remove all the csv files of the datagrid.
The "Run" button executes the functions.
The users can add multiple csv files into the datagrid, each line of the datagrid has the 4 columns, Select column, Filename column, Path column and Status column.
The column Select is like the checkbox with the sign view when a csv file is added to the datagrid. By default the csv file is selected when added to the datagrid.
The column Filename is the filename of the added csv file.
The column Path is the full path repertory of the added csv file.
The column Status is : OPEN when the csv file is added to the datagrid, PROCESSING when the application executes the function, OK when the function is executed successfully on the csv file, and FAILED if something is wrong with the execution.

1.2.2) Concerning the column Titles of the csv file, create in the GUI a group and name it Titles (just draw a rectangular to clearly identify this group) :
– create a text Title and a field value set by default to 10, the Title is mandatory so there is no checkbox
– create a text Title2, a checkbox selected by default and a field value set to 6 which can be changed
– create a text Title3, a checkbox selected by default and a field value set to 3 which can be changed
– create a text Title4, a checkbox selected by default and a field value set to 1 which can be changed
– create a text Title5, a checkbox selected by default, a text field set by default with the word Review and the users can modify the text as wished, a field value set to 1 which can be changed
– create a text Title6, a checkbox selected by default, a text field set by default with the word Video and the users can modify the text as wished, and a field value set to 1 which can be changed
– create a text Title7, a checkbox selected by default, a text label Amazon Category, and a field value set to 1 which can be changed
– create a button Add Titles which create a text Title8, a checkbox selected by default, an empty text field and the users can type the text as wished, and a field value set to 1 which can be changed. The button Add Titles can add Title9, Title10 and so on

1.2.3) Create another group with a rectangular draw lines with the name Credentials, add in this group a checkbox selected by default, a text label CSV files and a windows browse option to locate the csv file which has a default path/filename value set to D:ProjectAmznProductionDataCredentialyt_credential_default.csv

1.2.4) Create a check box selected by default, a text label "First Text" and a text field with the default text set to :

Free Review!

Product
Title

1.2.5) Create a check box unselected by default, a text label "Category" and a windows browse to load the csv file.

1.2.6) Create a "Save Options" button which save all the default values of all the options defined above into a config file, so for each runninng process of the application, all the saved default values in the config file are loaded into the application.

1.3) The functions of the button "Run" is defined as following :

1.3.1) The first step is to replace the column Title with the Title, Title2, Title3, Title4, Title5, Title6, Title7
For all the added csv file altogether, the app creates a new data structure to group all the rows of all the csv files which have the same Title column values case insensitive.
You must use an appropriate datastructure to handle the process properly as the csv files could have 5000 rows or more.
For each group having the same Title value, the application overwrites the Title column value with the value of Title, Title2, Title3, Title4, Title5, Title6, Title7 with the ratio defined under the group Title as defined above.
For example the default ratio values of Title, Title2, Title3, Title4, Title5, Title6, Title7 are 10, 6, 3, 1, 1, 1, 1
So the application takes the first 10 rows of the group of duplicated Title and assign the value of the Title column (it is already correctly assigned as the Title is already correct).
The next 6 rows have the Title value set to the value of the Title2 column
The next 3 rows have the Title value set to the value of the Title3 column
The next 1 row has the Title value set to the value of the Title4 column
The next 1 row have the Title value set to the value of the Title5 column
The next 1 row have the Title value set to the value of the Title6 column
The next 1 row have the Title value set to the value of the Title7 column.
Repeat the assignement process until all duplicated items of the group are completed, and repeat the same process for all the groups of duplicated items. If there are not enough duplicated items, just use the sequence order of Title, Title2, Title3, Title4, Title5, Title6, Title7 as 10, 6, 3, 1, 1, 1, 1
The app uses only the different Titles which have a checkbox selected (except for the Title label which is mandatory).

The Title, Title1. Title2. Title3 and Title4 columns have already the values from the input csv files.
The Title5 is build as follow, take the value of the Title column, add a space and add the word Review (by default) or the text written by the users in the text field
The Title6 is build as follow, take the value of the Title column, add a space and add the word Video (by default) or the text written by the users in the text field
The Title7 is build as follow, take the value of the Title column, add a space and add the value of its associated AmazonCategory column
If there are new added Titles, take the value of the Title column, add a space and add the text written by the users in the text field

All the Titles should have maximum 100 bytes or less, if they are above the max 100 bytes truncate the last necessary word(s) of the Titles to match the size.

Obviously the datastructure must record which row belongs to which csv file, for the save to the corresponding result csv file.

1.3.2) When all the rows of all groups of duplicated items are assigned with the Title column following the specifications of point 1.3.1) above, here are the next functions :

1.3.2.1) If the checkbox of the Credential is selected, takes the credential csv file added and assign the Username,Password,DeveloperKey,ApplicationID columns of the first row of the datastructure with the first row of the Credential csv file, the second row of the datastructure with the second row of the Credential csv file, and so on, until all the total rows of the datastruture are completed. In most cases the Credential csv files have much less rows than all the rows of all csv files, so the application must loop on the credential csv file for the assignement. The format column headers of the Crendial csv file is : Username,Password,ApplicationID,DeveloperKey
So take the values of these columns and assign to the corresponding column headers Username,Password,DeveloperKey,ApplicationID of the rows (be careful order of column headers might not be the same but the colum name is identical).
If the checkbox is not selected, no change is done for the Username,Password,DeveloperKey,ApplicationID columns

1.3.2.2) For the first format csv file : if the checkbox of the text label "First Text" is selected replace the first Text column with the text of the text label "First Text" as defined above. The word Title in this text is just used to simplify the implementation, and it should be replaced as follow :
For all the rows of the datastructure which have the value of the Title column with Title2, Title3, Title4 replace the word Title with the value of the Title column
For all the other rows of the datastructure which have the value of the Title column with Title, Tile5, Title6, Title7 and so on, do nothing
For the second format csv file : either the checkbox of the text label "First Text" is selected or not, nothing is done

1.3.2.3) For the Tag column : all the rows of the datastructure which have the value of the Title column with Title2, Title3, Title4, replace the value of the Tag column as follow :
The value of the Tag column is a sequence of keywords, the first keyword is the value of the Title column, then add a comma, then add each word of the Title value with each word separated by a comma, add the value of the AmazonCategory column, add a comma, add each word of the value of the AmazonCategory column with each word separated by a comma. The value of the Tag is embedded between double-quotes (to be safe with csv rule see above).
So the Tag has the sequence of keywords like keyword1,keyword2,keyword3 and so on where each keyword can have one word or multiple words, and each keyword is separated by a comma. The Tag should comply to these following rules :

a) each keyword of the Tag should have at least 2 bytes and maximum 30 bytes (non-including the double-quotes). If a keyword is less than 2 bytes, it is removed. If the keyword is higher than 30 bytes, truncate the necessary last word(s) so the truncated keyword is less or equal to 30 bytes. The maximum size length of the Tag value should be less or equal to 500 bytes (non including the double-quotes), if it is above 500 bytes truncate the necessary last keyword(s) to match the size of 500 bytes.

b) if there is any duplicated keyword in the Tag value, remove the duplicated keyword.

1.3.2.4) For the Description column : For the rows of the datastructure which have the value of the Title column with Title2, Title3, Title4 the application parses the value of the Description column, bypass the first line which have texts, bypass 2 following Break Lines, and should find the next lines which starts with text, it could have 1 or 2 lines with texts, and then 2 Break Lines. If there is one line of text before the 2 Break Lines, replace the text of this line with the value of the Title column value. If there are 2 text lines before the 2 Break Lines, replace the second text line with the value of the Title column.
The value of the Description column has a maximum length of 5000 bytes, if it is over 5000 bytes truncate the necessary last word(s) to match the size.

1.3.2.5) For the Category column : If the checkbox of the text lable Category is selected, takes the Category csv file added and assign the Category of the first row of the datastructure with the first row of the Category csv file, the second row of the datastructure with the second row of the Credential csv file, and so on, until all the total rows of the datastruture are completed. In most cases the Category csv files have much less rows than all the rows of all csv files, so the application must loop on the Category csv file for the assignement. The format of the Category csv file has one column header : Category
If the checkbox is not selected, no change is done for the Category column.

1.3.3) At the end of the whole process, for each csv file added to the datagrid, an associated result csv file is automatically generated and saved after the functions "Run" is executed and completed successfully. The columns Title2, Title3, Title4, and AmazonCategory are removed and not saved to the result csv file.
If there is something wrong during the execution there is no created result csv file. The column headers of the result csv file is :
Name,Audio,Text,Image,Text,Image,Text,Image,Text,Image,Text,Image,Text,Title,Category,Tag,Description,Username,Password,DeveloperKey,ApplicationID
or
– Name,Audio,Image,Text,Image,Text,Image,Text,Image,Text,Image,Text,Title,Category,Tag,Description,Username,Password,DeveloperKey,ApplicationIDThe result csv file is stored on the same repertory of the input csv file added, the filename is input csv file + _newtitle, for example if the input csv file is keyword.csv, the result csv file is keyword_newtitle.csv (if the result csv filename already exists in the repertory just overwrite it).
As the application records the row of its associated csv file into the datastructure, each row of the input csv file will be saved to its asscociated result csv file. It means that, the result csv file will have the same rows number as its associated input csv file.

2) Second TabPage with name "CSV Extract" :

Separate and Extract rows with the Status column equal to OK and rows with the Status column equal to FAILED.

2.1) GUI Similar to Tabpage 1, with the button "Add Files", "Clear List", a Datagrid and a button "Run". The user could add one or multiple csv files into the datagrid. For each csv file added the application separates and extracts rows with the Status column equal to OK and rows with the Status column equal to FAILED.

2.2) Save automatically to result csv file :

2.2.1) Save automatically all the rows with Status equal to OK to the result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory as the csv file added, the filename is the added csv file + _extractok, for example if the first csv file is keyword.csv, the result csv file is keyword_extractok.csv (if the result csv filename already exists in the repertory just overwrite it).

2.2.2) Save automatically all the rows with Status equal to FAILED to the result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory as the csv file added, the filename is the added csv file + _extractfailed, for example if the first csv file is keyword.csv, the result csv file is keyword_extractfailed.csv (if the result csv filename already exists in the repertory just overwrite it).

3) Third Tabpage with name "CSV Compare" :

Compare Name column or Status column of the first added csv file and the second csv file, and save to result csv file.

3.1) GUI Similar to Tabpage 1, with the button "Add Files", "Clear List", a Datagrid and a button "Run". The user adds a pair of 2 csv files into datagrid for each line of the datagrid. Multiple pairs of csv files can be added, one pair of csv file for each line of the datagrid. Some pairs of csv files have a Status column and some pairs of csv files do not have the Status column. In all cases there is always the column Name, all the columns of the first or second csv files should by copied AS-IS to the result csv file. For information, each pair of the first and second added csv files are always on the same repertory, and could not have the same column headers :

3.2) Case csv files having the Status column :

3.2.1) The application separates and selects all rows of the second added csv file which have the Status column equal to FAILED, separate and unselect all rows of the second added csv file which have the Status column equal to OK

3.2.2) The application selects all rows of the first added csv file whose value of the Name column is not in the second csv file.

3.2.3) Save to result csv file :

3.2.3.1) Save automatically all the selected rows of point 2.1.1 and 2.1.2 to the result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory of the first csv file added, the filename is the first csv file + _bis, for example if the first csv file is keyword.csv, the result csv file is keyword_bis.csv (if the result csv filename already exists in the repertory just overwrite it).

3.2.3.2) Save automatically all the unselected rows of point 2.1.1 to a result csv file (actually all rows having Status column equal to OK). If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory of the second csv file added, the filename is the second csv file + _compareok, for example if the second csv file is keyword.csv, the result csv file is keyword_compareok.csv (if the result csv filename already exists in the repertory just overwrite it).

3.3) Case of csv files not having the Status column :

3.3.1) The application selects all rows of the first added csv file whose value of the Name column is not in the second csv file.

3.3.2) Save automatically all the selected rows to the result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory of the first csv file added, the filename is the first csv file + _bis, for example if the first csv file is keyword.csv, the result csv file is keyword_bis.csv (if the result csv filename already exists in the repertory just overwrite it).

4) Fourth TabPage with name "Audio&Category&Credential" :

Change the Audio, Category and Username, Password, DeveloperKey, ApplicationID columns

4.1) GUI Similar to TabPage 1, with the button "Add Files", "Clear List", a Datagrid, a checkbox unselected by default with a text label "Audio" and a windows browse to load the csv file, a checkbox unselected by default with a text label "Category" and a windows browse to load the csv file, a checkbox unselected by default with a text label "Credential" and a windows browse to load the csv file, and a button "Run".

4.2) For the Audio column : If the checkbox of the text lable Audio is selected, takes the Audio csv file added and replace the value of the Audio column of the first row of the added csv file with the value of the Audio column of the first row of the Audio csv file, the second row of the added csv file with the value of the Audio column of the second row of the Audio csv file, and so on, until all the rows of the added csv file are completed. In most cases the Audio csv files have much less rows than all the rows of the added csv file, so the application must loop on the Audio csv file for the assignement. The format of the Audio csv file has one column header : Audio
If the checkbox is not selected, no change is done for the Audio column.

4.3) For the Category column : If the checkbox of the text lable Category is selected, takes the Category csv file added and replace the value of the Category column of the first row of the added csv file with the value of the Category column of the first row of the Category csv file, the second row of the added csv file with the value of the Category column of the second row of the Category csv file, and so on, until all the rows of the added csv file are completed. In most cases the Category csv file has much less rows than all the rows of the added csv file, so the application must loop on the Category csv file for the assignement. The format of the Category csv file has one column header : Category
If the checkbox is not selected, no change is done for the Category column.

4.4) For the Username, Password, DeveloperKey, ApplicationID columns : If the checkbox of the text lable Credential is selected, takes the Credential csv file added and replace the value of the Username, Password, DeveloperKey, ApplicationID columns of the first row of the added csv file with the value of the Username, Password, DeveloperKey, ApplicationID columns of the first row of the Credential csv file, the second row of the added csv file with the value of the Username, Password, DeveloperKey, ApplicationID columns of the second row of the Credential csv file, and so on, until all the rows of the added csv file are completed. In most cases the Category csv file has much less rows than all the rows of the added csv file, so the application must loop on the Category csv file for the assignement. The format of the Credentail csv file has 4 column headers : Username,Password,ApplicationID,DeveloperKey
If the checkbox is not selected, no change is done for the Username, Password, DeveloperKey, ApplicationID columns.

4.5) Save automatically all the rows to the result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory of the added csv file added, the filename is the added csv file + _acc, for example if the first csv file is keyword.csv, the result csv file is keyword_acc.csv (if the result csv filename already exists in the repertory just overwrite it).

5) Fifth TabPage with name "CSV Merge Images&Keyword" :

Merge some columns of the first added csv file into the second csv file. For information each pair of csv files are stored on the same directory, they have the same row numbers and the values of the Name column of the first csv file are identical to the value of the Name column of the second csv file.

5.1) GUI Similar to TabPage 1, with the button "Add Files", "Clear List", a Datagrid and a button "Run". The user adds a pair of 2 csv files into datagrid for each line of the datagrid. Multiple pairs of csv files can be added, one pair of csv file for each line of the datagrid. For information, each pair of the first and second added csv files are on the same repertory, and does not have the same column headers.

5.2) For each pair of csv files added to the datagrid and all rows of the second csv file the application copy all the columns of the second csv file and find the matching value of the Name column of the first csv file, for the value of the Name column matching between both csv files, copy all the associated value of the Image columns of the first csv file respectively to the Images columns of the second csv file.

5.3) Save automatically all the rows to the result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory of the second csv file added, the filename is the second csv file + _ready, for example if the first csv file is keyword.csv, the result csv file is keyword_ready.csv (if the result csv filename already exists in the repertory just overwrite it).

6) Sixth TabPage with name "CSV Merge" :

Merge all rows of all csv files added into a result csv file. For information, all the added csv files have the same column headers and are stored on the same repertory.

6.1) Similar to TabPage 1, with the button "Add Files", "Clear List", a Datagrid and a button "Run". The user adds multiple csv files into the datagrid. The application simply merge all the rows of all the added csv file. Actually the application appends all the rows of the first csv added, and then the second csv file and so on.

6.2) Save automatically all the merged rows of point 3.1 to a result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory of the first csv file added, the filename is the first csv file + _merge, for example if the first csv file is keyword.csv, the result csv file is keyword_merge.csv (if the result csv filename already exists in the repertory just overwrite it).

7) Seventh TabPage with name "CSV Split" :

Split the added csv file into smaller result csv files.

7.1) Similar to Tabpage 1, with the button "Add Files", "Clear List", a Datagrid, a button "Run" and a text label "Rows Number" with a field where the users can type the value number. The user can adds multiple csv files into the datagrid. For each csv file added the application splits the total rows of the csv file with the value number.
For example, if an added csv files has 3800 rows, the user type the value number 500, the program generate 7 csv files of 500 rows and the last csv file has 300 rows. The first result csv file has the first 500 rows of the added csv file, the second result csv file has the next 500 rows of the added csv file, and so on.

7.2) Save automatically all the rows of point 3.1 to the result csv files. If there is something wrong during the execution there is no created result csv file.The first result csv file has the filename of the added csv file + _1, the second csv file has the added csv file + _2, and so on. The result csv file is stored on the same repertory of the added csv file added, for example if the first csv file is keyword.csv, the result csv files are keyword_1.csv, keyword_2.csv and so on (if the result csv filename already exists in the repertory just overwrite it).

Thanks

Tags: , , , , , ,

Writing Excel Macros – VBA

Need Excel Macro to do the following:

My sample data looks like:

Every RAW File:
1. The cell values and no. of rows will change for every time i want to use the macro. The no. of rows will vary from 2 to 500.
2. However the no. of columns, position of column, header of columns will be same for every raw file.

Macro to do the following:
*** Function A ***
A:. change cell value for column K based on the cell value of column A.
a. If Cell A2 ends in DS01, then multiply the value in cell K2 by 2.
b. If cell A2 ends in DS02, then multiply the value K2 by 4
c. If not match found in A2, then check next row (cell B2) until all the rows (ie. from A2 to A500) in column A are verified.
d. After all the rows are verified for function 1a to 1c, then do function B below:

*** FUNCTION B ***
a. Remove characters DS00, DS01, DS03 if it exists any cell range A2 to A500 (eg 1. After Function A above, the cell value A2 is MWRB6446-DS00, then change cell A2 to read WRB6446 ), eg 2, if the cell value A2 is MWRB6452-DS00 then change cell A2 to read WRB6452. Then step 2b below
b. Check cell range A2 to A 500 for step Fucntion 2a. above.

*** FUNCTION C ***

1. If any cells from range A2 to A500 has the cell starting with 4, then remove the character 4 from any cell in column A. (Eg. if cell A2 reads 4WRB5246, then change cell A2 to WRB5246) eg 2: if cell A2 reads 4WRB5444, then change cell A2 to WRB5444. Then do step the next step below.
2. Check cell range A2 to A 500 for step C.1 above

*** FUNCTION D **

1. If any cells from range J2 to J500 equals to

Tags: , , , , , ,

Codeigniter Functions & OsTicket

We are looking for a php coder who can modify a copy of the latest version of osTicket (currently 1.6.0) to include two additional (optional) fields, and modify the view ticket screen to display a click-able link, if one of the additional fields is not NULL, containing a part-static, part dynamic address.

i.e. if Additional Field 1 is not empty, a text link on the view ticket screen should show that points to xyz.com/user/xxxx. With the xxxx value being retrieve from the contents of Additional Field 1. The same applies for Field 2.

The winning bidder will also be required to create a Codeigniter 2.0.0 library class called osticket.php, which can take the contents of a web form and interface with osTicket to create a new support ticket (including getting osTicket to generate its standard emails).

The class should also have functions for the following:-
* To return the number of currently open tickets
* To return the number of open tickets assigned to a specific person or department

In addition, we need two Codeigniter functions (could be merged into one if necessa). The first should be passed a text string, and be able to identify any dates contained within it, in any of the formats listed below. It should then be able to extract the date, pass it to the second function (see below), and then replace the date in the string, with the value returned from the other function.

The second when called, needs accepts two parameters the first is a date, in one of the following formats, the second is the output type – which has three possible options F for full date (i.e. 1st April 2011), C for compact date (i.e. 01-04-2011 dd-mm-yyyy), or M for MySQL format date (2011-04-01 yyyy-mm-dd). The function should return a single value, of the date in the format requested.

The function needs to be able to recognise the correct day, month and year and undertake the appropriate conversion. In all the examples below the day is the first value, the month is the middle value, and the year is the last. All are 1st April 2011, although the function should be able to accept any calendar date, in any year.

Both should be optimised to be as efficient as possible, using the least amount of code.

An example of a text string containing a date that should be passed to the first function is:-
"Fred arrived at the hotel on 1 Apr 2011 and checked in as planned."

The first function should detect the date as 1 Apr 2011 and pass that to the second function with additional parameter of F in this case, which should then return the value of 1st April 2011. The first function should then replace the date with the returned value, and return the full text string….

"Fred arrived at the hotel on 1st April 2011 and checked in as planned."

The text string may contain one or more dates, in one or more formats. The list of formats required to be covered are as follows:

01.04.11
01.4.11
1.04.11
01.04.2011
01.4.2011
1.4.2011
1.04.2011
01-04-11
01-4-11
1-04-11
01-04-2011
01-4-2011
1-4-2011
1-04-2011
01/04/11
01/4/11
1/04/11
01/04/2011
01/4/2011
1/4/2011
1/04/2011
1 Apr 2011
01 Apr 2011
1 Apr 11
01 Apr 11
01 April 2011
1 April 2011
01 April 11
1 April 11
01/April/2011
1/April/2011
01/April/11
1/April/11
01/Apr/11
01/Apr/2011
1/Apr/11
1/Apr/2011
1st April 11
1st Apr 11
01/04.11
01/4.11
1/04.11
01/04.2011
01/4.2011
1/4.2011
1/04.2011
01 04 11
01 4 11
1 04 11
01 04 2011
01 4 2011
1 4 2011
1 04 2011
1=4-11
1=4=11
1-4=11
01=4-11
01=4=11
01-4=11
01=04-11
01=04=11
01-04=11
1=4-2011
1=4=2011
1-4=2011
01=4-2011
01=4=2011
01-4=2011
01=04-2011
01=04=2011
01-04=2011
1,4,11
1,4.11
1.4,11
01,4,11
01,4.11
01.4,11
01,04,11
01,04.11
01.04,11
April 1, 2011
April 1st, 2011
April 1 2011
April 1st 2011
April 01 2011
April 01, 2011
Apr 1, 2011
Apr 1st, 2011
Apr 01, 2011
Apr 1 2011
Apr 01 2011
Apr 1st 2011
1/ April/2011
1/April /2011
1/April
April 1, 11
April 1st, 11
April 1 11
April 1st 11
April 01 11
April 01, 11
Apr 1, 11
Apr 1st, 11
Apr 01, 11
Apr 1 11
Apr 01 11
Apr 1st 1

Tags: , , , , , ,

Magento – Fix Problem With Gift Card Not Showing In PayPal

Using Magento ver. 1.3.2.4

Installed at properhost.net

Gift card module http://www.magentocommerce.com/magento-connect/Unirgy/extension/751/unirgy_giftcert

When a customer tries to buy items and uses a giftcard everything is fine until you order for something more than the value of the gift card. Then if the customer chooses Paypal or our Invoice solution (Klarna) the value of the giftcard is removed and they have to pay the full sum as if it did not exist.

We need this fixed so that customers can combine gift cards and card payment. And we are in a hurry.

Tags: , , , , , ,

Flash Spinning Wheel Game

I would like a "Spin the Wheel" flash game created that will send data to a PHP script indicating where the spinner stopped. The flash script should then read in a value passed from PHP and display that value on the screen.

The overall look and feel is also important, so I would like someone skilled in graphical design as well.

Tags: , , , , , ,

Virtuemart Shipping Module For Zip/Order Value/Shipping Cost

Need a shipping module quickly for Virtuemart that relates Zip code, Order Value to Shipping Cost.

I do not want this to be a hack that uses weight as order value.

Need to be able to set up shipping ranges based on post code and price of goods ordered.

I would like to be able to select the tax on shipping from the Virtuemart Tax rates (VAT ID). I also would like to be able to give each shipping rate a name that displays in the checkout on the shipping page.

e.g.
Zip Range, Order Value, Shipping Cost (inc. Tax), Shipping Tax (VAT ID), Shipping Rate Name
1000-2000, $0-$29.99, $15, 10%, Standard Shipping
1000-2000, $0-$29.99, $18, 10%, Express Shipping
1000-2000, $30-$99.99, $10, 10%, Standard Shipping
1000-2000, $30-$99.99, $15, 10%, Express Shipping
1000-2000, $100-$10000, $0, 10%, Standard Shipping
1000-2000, $100-$10000, $9, 10%, Express Shipping
2001-9000, $0-$29.99, $14, 10%, Standard Shipping
2001-9000, $0-$29.99, $17, 10%, Express Shipping
2001-9000, $30-$99.99, $9, 10%, Standard Shipping
2001-9000, $30-$99.99, $14, 10%, Express Shipping
2001-9000, $100-$10000, $0, 10%, Standard Shipping
2001-9000, $100-$10000, $5, 10%, Express Shipping

I have about 500 Shipping rates that will need to be added to my online shop. I will supply them in an excel spreadsheet in the same format as shown above. (Zip Range, Order Value, Shipping Cost (inc. Tax), Shipping Tax (VAT ID), Shipping Rate Name)

After the initial entry of the amounts is done, then I need to be able to edit the values myself in the future.

Tags: , , , , , ,

Codeigniter Date Function

We need two Codeigniter functions. The first should be passed a text string, and be able to identify any dates contained within it, in any of the formats listed below. It should then be able to extract the date, pass it to the second function (see below), and then replace the date in the string, with the value returned from the other function.

The second when called, needs accepts two parameters the first is a date, in one of the following formats, the second is the output type – which has three possible options F for full date (i.e. 1st April 2011), C for compact date (i.e. 01-04-2011 dd-mm-yyyy), or M for MySQL format date (2011-04-01 yyyy-mm-dd). The function should return a single value, of the date in the format requested.

The function needs to be able to recognise the correct day, month and year and undertake the appropriate conversion. In all the examples below the day is the first value, the month is the middle value, and the year is the last. All are 1st April 2011, although the function should be able to accept any calendar date, in any year.

Both should be optimised to be as efficient as possible, using the least amount of code.

An example of a text string containing a date that should be passed to the first function is:-
"Fred arrived at the hotel on 1 Apr 2011 and checked in as planned."

The first function should detect the date as 1 Apr 2011 and pass that to the second function with additional parameter of F in this case, which should then return the value of 1st April 2011. The first function should then replace the date with the returned value, and return the full text string….

"Fred arrived at the hotel on 1st April 2011 and checked in as planned."

The text string may contain one or more dates, in one or more formats.

Possible different date formats:
01.04.11
01.4.11
1.04.11
01.04.2011
01.4.2011
1.4.2011
1.04.2011
01-04-11
01-4-11
1-04-11
01-04-2011
01-4-2011
1-4-2011
1-04-2011
01/04/11
01/4/11
1/04/11
01/04/2011
01/4/2011
1/4/2011
1/04/2011
1 Apr 2011
01 Apr 2011
1 Apr 11
01 Apr 11
01 April 2011
1 April 2011
01 April 11
1 April 11
01/April/2011
1/April/2011
01/April/11
1/April/11
01/Apr/11
01/Apr/2011
1/Apr/11
1/Apr/2011
1st April 11
1st Apr 11
01/04.11
01/4.11
1/04.11
01/04.2011
01/4.2011
1/4.2011
1/04.2011
01 04 11
01 4 11
1 04 11
01 04 2011
01 4 2011
1 4 2011
1 04 2011

Tags: , , , , , ,

Stock Portfolio For Joomla

We need a stock portfolio manager for a joomla website.

The PHP stock portfolio manager should allow a user to add, modify and delete stocks from a portfolio. Stock quotes should be sourced form Yahoo Finance.

The user should be able to edit his portfolio (Add/Edit stocks) and the portfolio manager should be able to to retrieve the stock value, and tabulate the total value of individual shares, total value of the portfolio, Total Gains/losses etc..

If further info is needed please do post a message.

Tags: , , , , , ,

Custom Php Shop Mod – Branding Cost

Add new field to db: price2
add new field to db: xxx

existing custom php shop cart page:

when cart total >= xxx then replace price field value with price2 field value in existing total calculations
replace zero with No charge
add text string

Non dynamic:
add text link with small popup message (help tip)

Apply same changes to clone site

Tags: , , , , , ,

Do My PHP Programming Homework

Create a stock portfolio manager using PHP. The PHP stock
portfolio manager should allow a user to add, modify and delete stocks from a portfolio. When
a user adds a stock record, the stock tick and number of shares should be collected. The
information should be added to a file with the date and time the stocks were added. On the
same page or a separate page, a program should read the file, make the appropriate calls to
Yahoo Finance to retrieve the stock value, and tabulate the total value of those shares (multiply
the number of shares by the current stock value). Additionally, a total value of the portfolio
should be shown to the user. The user should also be able to modify the number of shares or
delete any stock record from the portfolio. The following statement will retrieve the relevant
information from Yahoo Finance:
$open = fopen("http://finance.yahoo.com/d/quotes.csv?s=$stock&f=
sl1d1t1c1ohgv&e=.csv", "r");
The use of sessions or persistent memory is optional for this part of the assignment. However,
you are welcome to use PHP sessions for this assignment as well.
Grading Rubric

Tags: , , , , , ,

Product Listers – Limited Seats

Hi there,

I have products to sell on the auction site ebay.com.

Only 5 seats available for permanent work!!!!

Will have to pass a trial to start working regularly.

Products: electronics, sunglasses and clothing

Requirements:
1. Must have an eBay ID that has at least 5 100% positive feedback, thus knowing the basics of selling on ebay.
2. Must have unlimited Paypal account so no limits will be placed and then spend a lot of time just to lift the unnecessary limits.
3. Must reply daily regarding status of items.
4. Must comply with sending the trial item funds prior to sending the item to the buyer as a preliminary caution
5. Must have good English

Offer:
1. 10% off final value sale
2. eBay listing and final value fees + paypal fee (deducted automatically by paypal once payment is done)
3. Item photos and item description
4. All information needed
5. Long term work

The trial consists in selling one item (value $250) to more than 1 buyer, filling and resolv a report and keeping the listing updated and being in touch.

Once you have read and agree with the above mention rules just leave your ebay ID in the comment of the bid for verification purposes.

Have a wonderful day.

Tags: , , , , , ,

Customized Online Calculator

Custom Online Calculator

The purpose of this project is to code a custom pricing calculator. The Calculator has already been designed & built in HTML/CSS, but needs functionality added to it. Also looking for clean well commented code, so that values can easily be changed in future.

Please read carefully the requirements below and follow the link which will aide you in understanding:
https://www.issuebreeze.com/dev/signup.php?PROGTYPE=1

BRIEF OVERVIEW
——————————————-

The only section on this page that needs attention is the Total Costs section, this is where the calculator resides. All other elements on the page are functioning and do not need work done.

REQUIREMENTS
——————————————-

Total Costs Section
– As the user fills out the input field from the Need more than fifteen licenses? section, Total Costs section should automatically update without the need for a Submit button and without refreshing the page. The user should also be able to go back and change the value in the number of additional licenses input field.

– Where it says Monthly Plan this text should change depending on which option they selected on a previous page … in the URL of that link I provided, you will see PROGTYPE=1, this signals to the page that the Monthly Plan was selected on the previous page … PROGTYPE=2 signals the Yearly Plan was selected.

– To the right of the Monthly Plan text it says $299 this value should update depending on which plan was selected.

– Where it says 0 Additional Licenses 0 should change with the value entered in the input box above … So if a user enters the number 20, that part in Total Costs would read 20 Additional Licenses. By default it should read 0 Additional Licenses until the user enters in a number.

– To the right of the 0 Additional Licenses text it says $0 this value should update depending on the number entered in the input box above, and the cost per license. PLEASE SEE THE LICENSE CALCULATION INFO BELOW. By default it should have the value of $0 … because initially when this page is loaded no number will be in the Step 2 input box above. If a user enters more than 85 additional licenses in the input box above, this value will display the text Call for pricing.

– where it says ($0 each) this is a pricing bracket, this value should reflect what price bracket the additional licenses are being charged at. PLEASE SEE THE LICENSE CALCULATION INFO BELOW. If a user enters more than 85 additional licenses in the input box above this value will display the text ($? each).

– At the bottom where it says Total Cost $0 that value should add the 2 above values for the total. Again this should be updating as the user fills in the form and makes changes. If a user enters more than 85 additional licenses in the input box above this value will display the text Call for pricing.

– At the bottom where it says License Total 0 that value should take the value entered in the input box above and add 15 to the number … as 15 licenses are always included with each plan. So if 20 was entered into the input box above, that license total will read 35.

Additional License Calculations & Price Brackets (the pricing per license depends on the quantity and also whether they choose a Monthly or Yearly plan)

Monthly Plan – Additional License Cost
1-15 Licenses ($20 per license)
16-35 Licenses ($18 per license)
36-85 Licenses ($16 per license)
> 85 Licenses (Call for Pricing)

Yearly Plan – Additional License Cost
1-15 Licenses ($17 per license)
16-35 Licenses ($14 per license)
36-85 Licenses ($11 per license)
> 85 Licenses (Call for Pricing)

Tags: , , , , , ,

Quanitity Box Minimum

On my shopping cart website I have quanitity boxes next to each Add To Cart button. These have a default value. Unfortunately you can edit the default value to be less. I would like it so that so can not edit the quanity to be lower than the default value. It should only be editable to be higher than the default value.

The site is coded in ASP VB Script.

Tags: , , , , , ,

JAVA Program To Implement The Ngram Object.

Write a JAVA program to implement the Ngram object.

The program should load the ARPA language model:
We have given an arpa file that contains text data, these textual data are divided into separated parts:

* 1 Gram:
probability value word backtracking value
Examples:
0.5 sleep 1.333333
0.15222 withdraw 0.5578
* 2 Gram:
probability value word word backtracking value
Examples:
0.33 sleep on 0.63333
0.758 withdraw money 1.8999
* 3 Gram:
probability value word word word backtracking value
Examples:
0.14667 sleep on bed 0.4445

– The data file can be downloaded from:
http://www.4shared.com/file/cdZPHU8G/lm_giga_64k_nvp_3gram.html

Inputs & outputs

When the user

Tags: , , , , , ,

Embedded Video Stream In Facebook Wall

I would like to embedded stream from ustream.tv into a facebook fan page.

for example below ustream.tv embedded code:

link:http://www.ustream.tv/flash/live/19459/test
embedded code:

<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="320" height="260" id="utv729129"><param name="flashvars" value="autoplay=false&brand=embed&cid=19459%2Ftest&locale=en_US"/><param name="allowfullscreen" value="true"/><param name="allowscriptaccess" value="always"/><param name="movie" value="http://www.ustream.tv/flash/live/19459/test"/><embed flashvars="autoplay=false&brand=embed&cid=19459%2Ftest&locale=en_US" width="320" height="260" allowfullscreen="true" allowscriptaccess="always" id="utv729129" name="utv_n_706283" src="http://www.ustream.tv/flash/live/19459/test" type="application/x-shockwave-flash" /></object>

Tags: , , , , , , , , , , , , , , , ,

Interpolation Add-In For Excel (C++)

Interpolation Function – mdInterpolate

I need a fast interpolation function to be used primarily in big Excel sheets. The syntax is described below.
Main focus is performance. It needs to be very fast since inputs will be continiously updating realtime financial data.
Coding language shall be C++. I will not only need a working xll file but also the code files to make adjustments if necessary.

mdInterpolate(x-Inputs,y-Inputs,x-Value,[Interpol_Method],[Interpol_Power],[Extrapol_Method],[Extrapol_Power],[Sort_Inputs],[Missing_Inputs],[Error_Inputs])

Parameters
x-Inputs double obligatory
y-Inputs double obligatory
x-Value double obligatory
Interpol_Method string optional
Interpol_Power real optional
Extrapol_Method boolean optional
Extrapol_Power real optional
Sort_Inputs boolean optional
Missing_Inputs boolean optional
Error_Inputs boolean optional

Requirements
as fast as possible since being used multiple times in huge spread sheet
written in C++
C++ Project Files required for later adjustments
available as C++ function and as Excel function through Add-in (.xll)

x-Inputs
Range of values with no headers
can be vertical or horizontal in Excel Sheet
number of data sets please see Sort_Values

y-Inputs
Range of values with no headers
can be vertical or horizontal in Excel sheet
same length as x-Inputs

x-Value
valid Number to calculate y-Value

Interpol_Method
linear
previous nearest lower value
closest nearest value
next nearest higher value
lagrange see link: http://www.codecogs.com/code/maths/approximation/interpolation/lagrange.php
cubic spline see link: http://www.codecogs.com/code/maths/approximation/interpolation/cubic.php
akima see link: http://www.codecogs.com/code/maths/approximation/interpolation/akima.php
hermite
… more methods are welcome if at hand

Interpol_Power
one number to determine smoothness of curve if method requires it
meaningful default value should be chosen

Extrapol_Method
can differ from Interpol_Method, same Methods shall be available
default is same as Interpol_Method

Extrapol_Power
one number to determine smoothness of curve if method requires it
meaningful default value should be chosen
if not given, value from Interpol_Power should be used if same method

Sort_Values
TRUE x-Inputs dont need to be in order (default setting)
FALSE x-Inputs need to be in order

Input data usually comprises no more than 50 data sets but will also be used with up to 1,000 data set
Maybe different sort methods depending on size of input make sense to increase speed.

Missing_Values
TRUE value can be missing in x-Inputs and/or y-Inputs at any position; data set will be excluded (default) FALSE no missing values are allowed

Error_Values
TRUE value can be any Error in x-Inputs and/or y-Inputs at any position; data set will be excluded
(default)
FALSE no missing values are allowed

Tags: , , , , , , , , , , , , , , , ,

Small Error In Mysql Needs Fixed

Small error in mysql needs fixed

The job is to fix script and let me know what had to be be done so I can fix my other sites that have the same error.

When I add a payment code to the payment account I get a mysql error. I am sure it is simple for a person that knows mysql

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near s fast, free and secure!">

Please do not change the logins so all can see the error and make the best bid they can from information supplied

To make the error so you can see it you can do this

login to the admin

http://www.barnyardtraffic.com/admincpanel

user and password: admin

Go to 😐 Account Settings |

Scroll down to> Account : demo > then scroll down to the paypal box

Add the paypal html and save and it will go to error

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="amount" value="5.00">
<input type="hidden" name="business"value="">
<input type="hidden" name="cancel_return"value="http://www.theaddepot.com/">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="item_name" value="Silver Membership">
<input type="hidden" name="item_number" value="1"><input
type="hidden" name="no_note" value="1">
<input type="hidden" name="return"value="http://www.theaddepot.com/thankyou.php">
<div align="center"><center><p><input type="image" src="https://www.paypal.com/en_US/i/btn/btn_subscribeCC_LG.gif" border="0"
name="submit" alt="Make payments with PayPal – its fast, free and secure!"> </p>
</center></div>
</form>

Save and it should go to the error

I am going broke on this project so be nice. Thank you for the time to look and bid.

Tags: , , , , , , , , , , , , , , , ,

11 Anti Aging Product Reviews

I require a content writer with an excellent grasp of the English language (perfect grammar, spelling and creativity) to write 11 reviews about anti aging products.

These reviews should be of high quality and of value to readers.

My criteria are:
– each review has to be between 500-600 words;
– Reviews need to be well researched and factual;
– No grammatical errors;
– Natural and flowing;
– Good sentence structure;
– Reviews must pay attention to the SEO value and have a 3-4% keyword density. (I will provide the keywords as well the article titles)
– Reviews must be unique and pass Copyscape

This can turn into a long term relationship.

Payment: I will make a milestone payment after receiving the first article.

Please send one sample of your previous work. Only reviews accepted!

Bids without samples will be ignored!

I will give preference to the bidder with the best price and positive reviews!

Tags: , , , , , , , , , , , , , , , ,

Group Buying Contract Writer Needed

We are looking for a contract to be developed for our upcoming group buying website similar to Groupon. This contract will be used between our company and the businesses we partner with.> > This contract will need to have the following:
> – Involve two parties
> – Ensure the participating business agrees to honor the promotional value for the agreed upon timeframe
> – Once the timeframe is over, the business must agree to honour the paid value of the voucher in compliance with US laws.
> – Ensure the participating business agrees to perform proper ID checks when vouchers are being redeemed
> – Outline that we will be using the company

Tags: , , , , , , , , , , , , , , , ,

Joomla RSFORM Component Custom Code

Need custom php script for joomla RSFORM component and adsmanager.
I have created booking form with RSFORM component.Now i need initial value for first text field in form.Initial value has to be value of field ad_hedline from adsmanager component.

Tags: , , , , , , , , , , , , , , , ,

Voltage Level Indicator

The project involves programming 2 PLC s. PIC (ideally cause we have the programer). The programmer will choos e the PIC according. One of the PIC, (PICA) to read an analog linear values (8 variations) over one analog input. and send info with a simple 2 bytes protocol (byte no one = 4 bits header + 4 bits value and byte no 2= check sum), It will transmit the info to another PIC PLC (PICB) with 8 outputs and to receive the info and output the value (1-8) on a number of the digital outputs in a binary format for the first 4 outputs equivalent to the received value, plus output on another one of 2 other o/ps, one indicating that the value is on the rise and the other that the value is falling, When the value reaches maximum, namely 8 the receiving PLC or PICB will pulse another (alarm o/p) at 120 pulse per minute along with the 2 rise or fall indicator o/ps. It will continu pulsing these 3 o/ps until the received value has droped below 15 or if a signal an i/p (alarm cancel input 1 or ?) goes low from high, This will indicate that the sound alarm generated by the alarm o/p is to stop, in which case it will stop pulsing the alarm o/p but keep pulsing both the 2 rise and fall o/ps. It will continu pulsing these last 2 until the received value has dropped.

PICA will read and transmit the values every few seconds. And if the receiving PICB doesn

Tags: , , , , , , , , , , , , , , , ,

Script To Search Checkbox Value

I need a script that can search the value of a checkbox that my users submit.

Example:If a user submits a checkbox that has a value of ABC.
I want this ABC to be searchable.

So If I am another user and I type ABC in the search,I want the search to pull up all the ABC matches.

I have multiple checkboxes so I would need the script to take this into account as well.

The website is PHP.

Thanks,

Tags: , , , , , , , , , , , , , , , ,

Value Disciplines Report

To produce a value disciplines report based on Treacy and Wiersema three value disciplines: Operational excellence, Customer intimacy & Product leadership. To determine which of these concept is most significant in determining medium term biz strategy and the extend to which this strategy is supported by the organizations IT Strategy.

Payment to be made thru Freelancer Only.

Tags: , , , , , , , , , , , , ,

Check Average PR On Google

1. Check Google for a keyword
2. Checks the PR of the first 10 websites in the results
3. Calculates the average PR value of those 10 websites

I just input a list of keywords into a textbox, and your script does the rest and outputs the average PR value for each keyword.

Tags: , , , , , , , , , , , , ,

Project For Sasa

Hi Sasa,

We discussed this a little already, I just want to change the single text field for the date to multiple text fields, with am/pm. Also, page is throwing an error: "Object reference not set to an instance of an object."

Ive made some changes to the files on the server, so please work from these instead of overwriting them with the files from your machine. If youve already overwritten them please let me know and I can re-upload the updated files.

The form for the date input should look a little like this:

<label for="textfield"></label>
<input name="textfield" type="text" id="textfield" value="MM" size="10" />
/
<input name="textfield2" type="text" id="textfield2" value="DD" size="10" />
/
<input name="textfield3" type="text" id="textfield3" value="YYYY" size="10" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input name="textfield4" type="text" id="textfield4" value="HH" size="10" />
:
<input name="textfield5" type="text" id="textfield5" value="MM" size="10" />
<label for="select"></label>
<select name="select" id="select">
<option value="am">am</option>
<option value="pm">pm</option>
</select>

The fields should also be validated before submission.

Tags: , , , , , , , , , , , , , , , ,

High CPC Google Adsense Keywords

Need Google Keywords in the following order of priority:

– 50 keywords whose CPC value is greater than $70
– 50 Keywords whose CPC value is between $50 – $70
– 100 Keywords whose CPC value is greater than $35

Only serious bidders who can supply all the above keywords list ( in excel spreadsheet ) should bid. The supplied list will be checked against google keyword tool.

Payment will be in 3 installments for supplying keywords in the order of priority as listed above with highest being on the top i.e first you need to supply keywords whose CPC value is $70+, then youll get paid your first installment. Then youll go ahead with the second one in the list and so on. No advance will be paid.

Moreover send me 2 keywords in each category along with your bid. The lowest bid will get higher priority. Please bid only if you are 100% confident.

Tags: , , , , , , , , , , , , , , , ,

Submit Multiple Forms At Once

I have code that I need to add to my Shopping Cart. The cart can easily add one item at a time and redirect you to the cart. I need to add multiple items to the cart all at once with 1 click. Each item is a form (sample below). Each item has a set of configurable details (size, color, etc.)

Ive read code online that suggest javascript and arrays to submit multiple forms at once, but I dont understand the code enough to implement it.

I was quoted by a company for over a hundred dollars and a lot of lead time. If I can get it for less and faster, that would be great.

Here is a sample of the code:
<FORM name="orderform_16210" method="post" action="http://www.localheroclothing.com/shop/cart.php">
<INPUT type="hidden" name="mode" value="add">
<INPUT type="hidden" name="productid" value="16210">
<TABLE><TR>
<TD>Price:</TD><TD><INPUT type="text" name="price"></TD></TR>
<TR><TD>Color</TD> <TD><SELECT id="po43" name="product_options[43]">
<OPTION value="130">White</OPTION>
<OPTION value="131">Black</OPTION>
<OPTION value="132">Light Grey</OPTION> </SELECT> </TD> </TR>
<TR> <TD>Size</TD> <TD> <SELECT id="po42" name="product_options[42]">
<OPTION value="123">Small</OPTION>
<OPTION value="124">Medium</OPTION>
<OPTION value="125">Large</OPTION>
<OPTION value="126">X-Large</OPTION>
<OPTION value="127">2X-Large</OPTION></SELECT> </TD> </TR>
<TR><TD>Quantity</TD> <TD> <SELECT name="amount">
<OPTION value="1" >1</OPTION>
<OPTION value="2" >2</OPTION>
<OPTION value="3" >3</OPTION>
</SELECT> </TD></TR>
<TR><TD colspan="2"><A href="javascript: document.orderform_16210.submit()">Add to cart</A> </TD>
</TR> </TABLE> </FORM>

<FORM name="orderform_16221" method="post" action="http://www.localheroclothing.com/shop/cart.php">
<INPUT type="hidden" name="mode" value="add"> <INPUT type="hidden" name="productid" value="16221">
<TABLE> <TR><TD>Price:</TD> <TD"><INPUT type="text" size="7" name="price2"></TD> </TR>
<TR><TD>Color</TD> <TD> <SELECT id="po63" name="product_options[63]">
<OPTION value="258">White</OPTION>
<OPTION value="259">Black</OPTION>
<OPTION value="260">Light Pink</OPTION>
</SELECT></TD></TR>
<TR><TD>Size</TD><TD> <SELECT id="po64" name="product_options[64]">
<OPTION value="263">Small</OPTION>
<OPTION value="264">Medium</OPTION>
<OPTION value="265">Large</OPTION>
<OPTION value="266">X-Large</OPTION></SELECT>
</TD></TR><TR><TD>Quantity</TD>
<TD> <SELECT name="amount">
<OPTION value="1" >1</OPTION>
<OPTION value="2" >2</OPTION>
<OPTION value="3" >3</OPTION>
</SELECT> </TD></TR> <TR>
<TD colspan="2"><A href="javascript: document.orderform_16221.submit()">Add to cart</A></TD>
</TR> </TABLE> </TD> </TR> </FORM>

Tags: , , , , , , , , , , , , , , , ,

Custom JQuery Drop Down Selector

You need to build a custom drop down field which on select will load fieldsets based on what is selected in the drop down field

EG:

<label for="bandmembers">Band Members</label>
<select name="membersAmount" class="select">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>

If 10 is selected it will automatically load 10 fieldsets with form information for each member

must use jQuery

Tags: , , , , , , , , , , , , , , , ,