Get a Freelance Job

This is a simple copy and paste project. I have an excel file which has about 10,000 columns and about 10 rows. I need someone to copy and paste words into 5 rows of every column. You will copy and paste from the title which has about 5-12 words. You will copy two words from the titel to form keywords on 5 rows from every column. It is very simple just takes a bit of time to copy and paste.

I need a program/script that can extract selected data columns/rows from multiple PDF files to Excel.

We are looking for an individual or company experienced in X-Cart Excel data feed work. Project is for 50 Excel spreadsheet rows.

Payment is to be made only after successful data feed upload.

Please bid if you have experience with these data feeds. We are ready to assist as needed but we are not willing to provide any extensive training.

Rows must be checked for errors before returning to us. Some columns, especially CATEGORY, will need to be intelligently selected.

Complete X-Cart i…

Currently I am using a simple WordPress plugin in order to prevent duplicate post entries. It is a simple WordPress function:

<?php
function clearDuplicatePosts(){
global $wpdb;
$prefix = $wpdb->prefix;

$wpdb->query(“DELETE bad_rows . * FROM “.$prefix.”posts AS bad_rows INNER JOIN (
SELECT “.$prefix.”posts.post_title, MAX( “.$prefix.”posts.ID ) AS max_id
FROM “.$prefix.”posts
GROUP BY post_title
HAVING COUNT( * ) >1
) AS good_rows ON ( good_rows.post_title = bad_rows.post_title
AND good_rows.max_id <> bad_rows.ID )”);
}
add_action(‘publish_post’, ‘clearDuplicatePosts’);

?>

This plugin is used on an autoblog and deletes the old post with the same title, keeping the new one instead.
But this doesn’t delete the post-historie and also don’t delete the attachments.

You have to rewrite the plugin so it uses wordpress functions and also delete all historie entries and all attachements.

Only a very small change.

I want to adapt this plugin, to be able to delete the the attached images of the old post, not only the database entry. So, the old post should be deleted completely, including the attached images. That’s it…

I have 3 worksheets in xlsx.
Each should have 60629 rows.
each one has 2 columns ID and text
there are missing ID rows.
i need macro insert missing ID rows with ID number and that row under text will be empty.
example:
ID Text
1 xxxx
2 yyyy
3 zzzz
5 xxxx
7 aaaa

i would like the sheet to look like

ID Text
1 xxxx
2 yyyy
3 zzzz
4
5 xxxx
6
7 aaaa

i would like the macro for future use too along with fixed files

I have an excel spreadsheet that has prospect data. It will list the prospect many times based on how many policy types the prospect has. What I need to do is merge the data together based on the prospect name and have the policy type, expiration date, premium, company, producer and status from each row become 1 record per prospect. The best thing to do is look at the attached example. The first tab is the original and teh second is what I want it to look like. this is a sample of the spreadsheet. The actual one has over 3200 records total.

This needs to be done immediately!!!

I have Three small jobs I need doing on my site and admin pages

1. Edit list code
I need code to generate a fixed list of 10 data variables each separated by an opening and closing ^.

The data is to be pulled off table of images where the picture id (pid) matches.
If there are less than 10 images the code should generate still generate the opening and closing symbols ^^

My code pulls the data in the correct format, but it only writes code where there is fields in the table – so if there are only 4 images it writes 4 lines.

^51214_539_img_539_1.jpg^51214_539_img_539_2.jpg^51214_539_img_539_3.jpg^51214_539_img_539_4.jpg^|

it needs to write
^51214_539_img_539_1.jpg^51214_539_img_539_2.jpg^51214_539_img_539_3.jpg^51214_539_img_539_4.jpg^^^^^^^|

its onlene at
http://www.rivaestates.com/admin/feed-3i-test.php

I attach my php code and the sql dump.

2 I want a form on my site to edit mass data
it needs to list 10 rows of data (eg address1, address2, price, quamtity, display etc) in a form with a submit button that updates all amended data, refreshes to show the same data, and a next button to see the next 10 rows.

3 I want a back button coding from detail page
I have a search function on my site and the results have a pageing code which splits them into pages of 12. each block has a link to a details page. I want a back button from this detail page to the correct block or records in the search results ( not just a ‘go back a page’ code) ie if this is page 4 of the recordset – the link must go back to that, not to the firat page in the recordset.

I have more work on this site to follow as another project, eg listing recently viewed records, creating a shortlist etc. It would make sense for the same coder to work on this if possible.

I urgently need for today (Sunday) the following three macros for the attached Excel file:

1) a macro assigned to the button

I have a windows form with 2 datagridviews in c# but I need it to have the following features.

Both datagridviews are similar in function:
Unbound – not linked to any data source.

Two columns:-

Column 1: contains a number from 1 – 255 ( Zero not allowed but may be in future – disallow for now).

Column 2: contains plain text.

Datagridview1 Column Names “Area” , “Area Name”
Datagridview2 Column Names “Zone” , “Zone Name”

Column sorting on column 1 ( Area / Zone ) must be in numeric order ( not string based ).

User must be able to add rows by entering a new number and optionally adding text in column 2.

Duplicate numbers are not allowed. – If a duplicate number is added manually then message box prompt ‘ Duplicate’ . No action until user corrects it – or cancels the operation.

Not allowed to have text in column 2 without a valid number in column 1 – if text added, then focus will then move to the number cell awaiting a valid number ( or a cancel operation ). If cancelled – the row will be deleted.

There must be a function provided to programatically add rows with new unique numbers ( function returns ‘true’) – if duplicate number found, function will return without doing anything ( and return a ‘false’ value).

The user must be able to delete rows. ( Delete on Keyboard or Right Click ‘Delete’ on Row )

There must be a function to programatically delete rows ( based on the unique number in column 1. If attempt to delete a non existent row then the function returns ‘false’.

The tables will never have more then 255 rows.

This should be fairly easy for anyone with even a little bit of VBA experience.

I’ve provided a hard coded example of what I want done, but need it to be more flexible.

If you click on the green column that says “Name 1″ it hides all of the columns except for the others that say “Name 1″. I want to do this automatically instead of using hard-coded ranges.

So I want to be able to give it a range and it reads these names into some sort of listbox and then you can check the names that you want to be shown.. all other columns in the “green, yellow, and gray” sections will be hidden.

Hi, i need a simple query do to the following,

1. I have 2 rows in 2 tables namely Password hash and Salt
2. I want a program that will check all the rows on both the tables and show what are the rows that does not have a match and a button that will sync both the tables.

I will give more details on PM.

Thank you

I need a simple file, can be php that can connect to my SQL database (from localhost) and add multiple rows in a single table.

I need to add some rows.. 3 fields in each row, 2 of them are a static value same to all rows and the other one is dinamic and shall be retrieved from each line of some another txt file. where is contained the data

Ill pay after the work delivered via paypal

I need a display page written in php that has a table with 4 columns wide and as many rows as needed.

I already have the database created and the config and connect files

Hello,

I wish to customise this Drupal charting module – http://drupal.org/project/issues/views_charts – so that data is plotted in columns, rather than rows.

Ie so that it can effectively chart data such as:

Fruit Apples Oranges Bananas
Percentage 20 30 50

At the moment it can only deal with

Fruit Percentage
Apples 20
Oranges 30
Bananas 50

The change requires adjusting a few lines of PHP code. However, I am not a PHP expert.

Ideally the module would be customised to give the user the option, within the webform, on whether to plot data in rows or columns. But, if that is too complex, I can accept a solution that just changes the rendering from rows to columns, without exposing the option within the webform.

I would like the solution, when completed, to be shared with the Drupal community.

I would also accept any solutions to this issue that use alternate modules or approaches within Drupal (or possibly that involve attaching some other technology to Drupal). In your bid, please mention your approach.

Hi,

I need a programmer to clone a very simple piece of software in C or C++. If you can also build a Mac OS X version, let me know.

Download the software here:
http://bit.ly/1bXwbM
(the graphics and text are not desired. only need the text boxes and OK button for functionality!)

The user enters 2 numbers (columns/rows), clicks OK to minimize and then presses “SPACE BAR” to begin the auto cursor/clicking.
The software simply moves in the selected columns/rows and auto clicks.

The software MUST perform the same way as the original.

The clone must also include these features:
1) Press “ESCAPE” to cancel any auto cursor/clicking.
2) Remember the columns/rows number values when user quits and relaunches software. (system memory/preferences/registry)

Please let me know if you have any questions prior to bidding.

We have included 2 sample excel files, to give you an idea on what the program or vb macro needs to do.

The first file is called nj.csv. This is the sample of a file we will be using that needs to be manipulated.

The second file is called SICTranslator.xls . This is a file your program will be using as a reference.

==================

We need a program, that can take any excel file in the format of the nj.csv file included.

It looks at the last column titled “SIC Code”

It compares the first 4 character of the data in the column and checks to see if there is a match with any of the first four characters in any row of Column B of the other excel file named SICTranslator. xls

If there is a match with the first four character of ANY row in Column B of SICTranslator.xls, then keep the row in the first excel file. Otherwise Delete the entire row and shift the other rows up.

====================

This program should then have another option in which it looks at the first excel file, nj.csv and can find all the unique rows of the last column titled “SIC Code” and create another excel file with all the unique rows of just that column.

Iam looking for a MYSQL guru to optimize a couple of slow queries, please don’t bid on this project unless you are a expert in mysql and can dramatically reduce the time these queries take.

Below are the problem queries taken from the slow query log.

# Query_time: 8 Lock_time: 0 Rows_sent: 8 Rows_examined: 378201
SELECT *, COUNT(file_id) AS image_count FROM uploader_userfolders JOIN uploader_userfiles USING(folder_id) WHERE file_isimage=1 AND folder_i$

# Query_time: 16 Lock_time: 3 Rows_sent: 30 Rows_examined: 682764
SELECT pm.pfile_id, pm.mfile_id, pu.*, mf.file_description, mf.file_extension, mf.file_date, mf.file_key, mf.userid, mf.folder_id,uf.*, MAKE$
MAKE_SET( 1 |2, COUNT(mf.file_id), COUNT(pf.file_id) ) AS image_count,
MAKE_SET( 1 |2, pf.file_name, mf.file_name ) AS file_name,
MAKE_SET( 1 |2, pf.file_location, mf.file_location ) AS file_location,
MAKE_SET( 1 |2, pf.file_size, mf.file_size ) AS file_size,
MAKE_SET( 1 |2, pf.file_views, mf.file_views ) AS file_views,
MAKE_SET( 1 |2, pf.file_lastview, mf.file_last_view ) AS file_lastview,
MAKE_SET( 1 |2, pf.file_isimage, mf.file_isimage ) AS file_isimage,
MAKE_SET( 1 |2, uf.folder_name, pu.upload_name ) AS set_name,
ud.username,ud.avatar
FROM uploader_pmfiles AS pm
LEFT JOIN uploader_puploads AS pu ON ( pm.pfile_id = pu.upload_id )
LEFT JOIN uploader_pfiles as pf USE INDEX(upload_id) USING(upload_id)
LEFT JOIN uploader_userfiles AS mf ON ( pm.mfile_id = mf.file_id )
LEFT JOIN uploader_userfolders AS uf ON ( mf.folder_id = uf.folder_id )
LEFT JOIN uploader_users AS ud ON ( mf.userid = ud.userid )
WHERE (pu.upload_ispublic = 1 OR uf.folder_ispublic = 1)
GROUP BY mf.folder_id, pu.upload_id
ORDER BY pm.file_date DESC
LIMIT 0, 30;

Hi,

I would like someone to write me two php scripts.

The first script will take a tab delimited file that has headers and create the code to create a MySQL table for me using the headers as field names, with all fields default varchar(20).

I want variables created so that I can easily change the location of the file used, and the default field type.

I want the program to default to using all the headers as field names, but, I also want the option to select field names which I can pass on in a function.

For example, if I want the following headers used as field names in the MySQL database to be created, I would write something like this:

selectfields(ProductID, ProductName, Category);

The second script will take a tab-delimited file and insert selected fields into my mysql database.

Other functions of the script include:
I want the script to delete all the rows in the table first before inserting.
I would like this written in such a way that I can comment this part out easily in case I don’t want to delete all the rows in the table.

I want to be able to change one variable to select the number of rows that are read in. Please comment this in the program and make it easy to change, maybe putting it at the top of the program.

I mentioned that I only want selected fields to be inserted. However, I want the script written in such a way that I can add more fields easily if I choose to. Please make comments in the script on where and how to add the fields.

I don’t know if this matters or not, but, the script has to be able to read the product feed from a subdomain of mine. Please write the program so that it is easy to change the location of the product feed.

The script has to be usable by a cron scheduler.

I use MySQL 5 and PHP 5.2.

I will provide a test directory and database for you to work on. You will only have ftp access.

I will consider the script complete when I can run the cron scheduler on your script and it loads the data successfully into my test database. I agree to pay within 2 days after finding that the script works properly. I put 2 days just for contractual purposes in case something comes up, but, I will pay immediately (within minutes or hours) after I find it works successfully.

I have two tables with the following structure:

PRODUCTS
id
productname
qty1
qty2
qty3

OPTIONS
id
productid
optionname
qty1price
qty2price
qty3price

I know that the database is not as efficient as it could be, but that is not what the project is for. You are just to get the query to work with the current database structure.

With that being said, the object is for you to allow these fields to be edited through a page called update.php

The current update.php page takes the variable “id” from the URL and pulls from the PRODUCTS table all rows where the id is equal to the id in the URL. It also pulls information from OPTION where the productid is equal to the id in the URL. All of this information is then summarized in an an HTML table.

Headings: QTY1, QTY2, QTY3
Row 1: OPTIONNAME1, QTY1PRICE, QTY2PRICE, QTY3PRICE
Row 2: OPTIONNAME2, QTY1PRICE, QTY2PRICE, QTY3PRICE

These results are displayed in input fields so that they can be edited. The problem that I have with the current update.php file is that there can be multiple OPTIONS for a single product, so right now, the query is only updating one OPTION for each product. I’m sure that I’m just missing a loop or for each statement-something simple. I’d like you to write the code for the input fields/form. I have most of the fields, but I may be missing something like a hidden field, which will cause the query to work. You also need to write the query that will update both pages. The form needs to submit using the post method, not the get method.

Only bid if you can have it finished in one hour. Lower bids with faster delivery have priority.

I have two tables with the following structure:

PRODUCTS
id
productname
qty1
qty2
qty3

OPTIONS
id
productid
optionname
qty1price
qty2price
qty3price

I know that the database is not as efficient as it could be, but that is not what the project is for. You are just to get the query to work with the current database structure.

With that being said, the object is for you to allow these fields to be edited through a page called update.php

The current update.php page takes the variable “id” from the URL and pulls from the PRODUCTS table all rows where the id is equal to the id in the URL. It also pulls information from OPTION where the productid is equal to the id in the URL. All of this information is then summarized in an an HTML table.

Headings: QTY1, QTY2, QTY3
Row 1: OPTIONNAME1, QTY1PRICE, QTY2PRICE, QTY3PRICE
Row 2: OPTIONNAME2, QTY1PRICE, QTY2PRICE, QTY3PRICE

These results are displayed in input fields so that they can be edited. The problem that I have with the current update.php file is that there can be multiple OPTIONS for a single product, so right now, the query is only updating one OPTION for each product. I’m sure that I’m just missing a loop or for each statement-something simple. I’d like you to write the code for the input fields/form. I have most of the fields, but I may be missing something like a hidden field, which will cause the query to work. You also need to write the query that will update both pages.

I will not be able to answer questions, because I will not be here. I think that I have provided enough information for you to work independently. Once I get back in within four hours, I will select someone. Include the phrase not a bot in your bid, or it will not be considered at all-even if you only bid $10. I’m only looking for this project to be completed, so no portfolios or background information about you or your company. If you have a demo for this project, post it in the PMB.

Thanks.

I am looking for a quick order form made that I can host on my server.

Here is what the form will need to have in it.

4 columns and 3+ rows

The column headings would be something along this nature:

Package name – Package description – Paypal button – Alertpay button

The rows would be 3 levels of packages I would be selling.

Follow on rows may be added to allow for upgrades or add on services.

Each row (as read from left to right) would contain the package name, package details, payment choice of paypal or alertpay.

Basically looking for a template that I could add on extras later and modify the pricing as needed.

Thanks for looking

I am a Flex coder using Flex Builder. I am accessing a mySQL database using PHP by creating the scripts via Flex Builder’s built-in “Create Application From Database…” wizard which cranks out all of the scripts for me.

This all works fine. Currently when I load a table from the database using one of these scripts, it loads ALL of the rows in each table. After it is in Flex I have used filter functions to sort out the data that I want displayed.

However, in order to keep the load time to a minimum as the mySQL database grows, I want to only load the rows of each table initially that I want, rather than waiting for the entire thing to load into Flex first.

Fortunately, each table in my database has a field called “subscriber_id”. I want to use this variable to have the Flex Builder scripts simply sort out the data WHERE ‘subscriber_id’ = $myVariable. The variable I will pass from Flex to the script.

I am looking for someone who is VERY familiar with the pre-canned PHP scripts that Flex Builder spits out who can help me to tweak the “Find All” portion of it so that it can take my ‘subscriber_id’ variable and only load the table rows that match that.

[SKILLS NEEDED] :

For someone who is GOOD at programming, it should not be all that difficult to do. Basically just retrieving information from a database

- PHP
- Database (MYSQL) (MOST ALL resource information is already in the HUGE database. Would need to retrieve and display where required)
- Likely have to assist with the HTML as some points (obviously)
- javascript
- Compatible with all known browsers
- Ability to allow me to SEE progress (IE. Login to view it on your server) and report to you any changes, edits,additions at will)

[FEATURES FOR SCRIPT]

- Language file for most (all if possible) prompts and text
- ADMIN panel. (with login/password for protection) A GREAT feature that guy did with the other program is there is an admin panel full of fields, but if you are signed is as the admin (both a login/pass and a cookie on the computer) there is a tiny icon beside each part that can be accessed in the admin panel. Click that icon and it opens the admin panel forwarding you directly to the field to admin that specific part).
- I’d LIKE to be able to upload the pictures thru the admin panel for ease of use.
- Ability to THUMBNAIL the full size images and pop up the full size images in a new window for specific areas. And a default image if image doesn’t exist yet.
- Ability to SORT how items are shown (ie. engines, camaro models, etc).
- The program loads with a year that the user selected from a previous page.

ie.
http://www.camarosource.ca/php/camaro_info_db/index.php?year=1992
http://www.camarosource.ca/php/camaro_info_db/index.php?year=1993
http://www.camarosource.ca/php/camaro_info_db/index.php?year=1994

See the pattern? And having the details specified on the URL

ie.

http://www.camarosource.ca/php/camaro_info_db/index.php?act=engine_specs&amp;year=2002
http://www.camarosource.ca/php/camaro_info_db/index.php?act=colors_trim&amp;year=2002

Note: the plain SEO english year and page specified on URL.

The year selected would ENTIRELY reflect what information, specs, and camaro thumbnails are shown.

Layout would consist of a layout with a HEADER, FOOTER, CENTER, and LEFT

[MAIN OPENING PAGE]

- [HEADER] Static header. Consists of just images (with rollover effect), and a single pull down menu with all the years (Select a year and it refreshes the page with new info pertaining to that specific year)
- [LEFT SIDE] has intro text. Click a hidden admin only shown icon to jump to admin panel directly to that field to edit.
- [FOOTER] Consists of a group of images (Camaro thumbnails) for that specific year (mentioned above). For when there are too many thumbnails to show, it would wrap to the line below; easiest enough using ROWS. When mouseovered, text (again edited thru admin panel) would appear in a specific location on the page. For each small Camaro pic thumbnail there to be mouseovered, the text would change (it’s indicating what Camaro model is currently mouseovered). When clicked, it opens the GENERAL info page (Refer below)
- [CENTER] regular image

That’s pretty much for that page

[GENERAL INFO]

- [HEADER] SAME
- [Left Side] has intro text. Again hidden admin icons for editing.
- [FOOTER] SAME footer. The images Camaro thumbnails would corospond to that year
- [CENTER] Tables with ROWS, retrieving information from database, thumbnail pics,

That’s it for that page

[ENGINES]

- [HEADER] SAME
- [LEFT SIDE] has engine text for that year. Retrieve engine specs. Engines are displayed in configured (thru admin panel) sorting as well as the transmissions. This side would display Transmissions and engines for that year. Originally shown in a image box, click the arrow to open the box fully to display availability information for that tranny. Click arrow again to reduce size back (likely thru java/javascript). The engine/tranny combo’s would come from the specific configured for each camaro model and variation (throughout the years) thru the admin panel which I specific every feature/option/color/specs, etc [below])
Again, hidden admin only shown icons to jump to admin panel directly to that field to edit.
- [FOOTER] SAME
- [CENTER] Display Engine pic (Either by means of a default engine for that year to be selected or random for that year) Displays the engine image and retrieves and displays the specs specific to that engine.. Again hidden admin icons for editing. Would display all engines for that year on a ROW and again repeat new rows if too many were to fit on one row. Clicking that engine button would result in page refreshing with the new engine specs and engine pic.

That’s pretty much for that page

[OPTIONS &amp; WHEELS]

- [HEADER] SAME
- [LEFT SIDE] : New page: Imported html page that I can edit myself.
- [FOOTER] SAME
- [CENTER] Image buttons on top, click to jump down to specific areas of that page. User selects up to 3 Camaro models for that particular year to look at, at once on the page. Thumbnail pic changes for each model selected and the text changes to indicate which model was selected. A group of tables consisting of ROWS that repeat the same for each option category and alternative between two colors for each ROW. The information inside changes obviously. All information again comes from pre-configuring in the admin panel for each camaro year/model/variation. Would display an icon to represent “OPTIONAL, STANDARD, and NA”, again part of the config in model specifics. Would like to be able to TOGGLE the options (more below in the ADMIN panel section) and easily indicate what is “OPTIONAL, STANDARD, and NA” and then display that as icons on that page when retrieved. Basically the rest is usually the same table layout retreiving info and display pics and thumbnails. Clicking the thumbnail opens image full page. There are also an icon on the table to click to jump to the top of the page via #TOP which is easy enough. Some of the text (options) can be clicked to open in a window (perhaps I can display a picture of the part with some text), again edited thru admin.

That’s pretty much for that page

[COLORS &amp; TRIM]

- [HEADER] SAME
- [LEFT SIDE] : SAME : Imported html page that I can edit myself.
- [FOOTER] SAME
- [CENTER] Same thing with regards to image buttons at top of page. And importing an html that is specific for that year. Simple.

That’s pretty much for that page

[DECODING]

- [HEADER] SAME
- [LEFT SIDE] : SAME : Imported html page that I can edit myself.
- [FOOTER] SAME
- [CENTER] Same thing with regards to image buttons at top of page. Tables similar to [OPTIONS &amp; WHEELS].. retrieving from database for that year and also using ROWS. And importing a html at the end of all that, that is specific for that year.

That’s pretty much for that page

[SPOTTER'S GUIDE]

- [HEADER] SAME
- [LEFT SIDE] : SAME : Imported html page that I can edit myself.
- [FOOTER] SAME
- [CENTER] : Again similar looking table as [OPTIONS &amp; WHEELS] importing text from database with ROWS.

Same thing with regards to image buttons at top of page. Tables similar to [OPTIONS &amp; WHEELS].. retrieving from database for that year and also using ROWS. And importing a html at the end of all that, that is specific for that year. Also would have ability to choose up to 3 Camaro models/variations for that year to display text and thumbnails.

That’s pretty much for that page

[SPECIFIC MODEL INFO]

- [HEADER] SAME
- [LEFT SIDE] : SAME : Imported html page that I can edit myself.
- [FOOTER] SAME
- [CENTER] : Again similar looking table as [OPTIONS &amp; WHEELS] importing text from database with ROWS. Similar to retrieving information to that year model/variation and thumbnail pics.

[ADMIN PANEL]

- Edit information for that year or model/variation (clicking the hidden admin icon which logged in as admin would take you straight to that field for convenience).
- A NICE feature would be the ability to be able to upload pictures directly to the server folders thru the admin panel.
- to be able to list ALL the (for example) COLORS, trans, Engines, Factory Options, and be able to TOGGLE which ones correspond to that year model/variation as well. For example: Let’s say I configured a L98 5.7L v8 350 for a 1990 Camaro Z28 and I am currently configuring a 1992 Z28. It uses the same engine so I can easily just toggle that as the engine for this as well.. or.. perhaps configured a Power Seat for a specific year. Well rather than make another Power seat for the other days, I would easily just choose that out of the list of all previously added.. Likely there would have to be seperate admin panels for some of these pages as we can’t have 1 GIGANTIC admin panel especially when it’s listing all colors, trans, engines, options, etc.. Setting a default thumbnail. Ability to easily add a new YEAR, or MODEL, or VARIATION for future Camaro years.

That’s pretty much for that page

That is basically it for the program

Hello

Simple project.
I need to convert data from multiple rows by joining them in a single field.
See example attach.
You create 1 access module that I will execute with a macro. Output in a new table.
I need to change code if necesary.
Scrow payment.
Thanks
Pablo

I’ll have two csv files, in which values are delimited by commas or semicolons. Each row in the first column of each file will contain a date and time, in seconds, written as one number (for example 20090527164134, YYYYMMDDHHMMSS).

The two files span around the same “duration” in time but have an unequal number of rows. The job of this program would be to make the two files compatible in a way that each respective row in each file will contain identical date/time values. It should do this by inserting and filling up the rows of each file in which the date/time field doesn’t match with any respective field in the other file.

Please note that a file can and will contain large sequences of rows where the date/time field will be the same.

When a new row is inserted with a date/time value taken from the other file, the values other than the date/time should be copied from the previous row.

Example:

File_A.csv:

20090527161405,1,2
20090527161407,2,2
20090527161410,2,2
20090527161412,2,4
20090527161413,2,2

File_B.csv:

20090527161405,3,2
20090527161408,4,5
20090527161410,5,6
20090527161412,5,4
20090527161412,9,2
20090527161413,3,4

Must be processed into:

File_A_new.csv:

20090527161405,1,2
20090527161407,2,2
20090527161408,2,2
20090527161410,2,2
20090527161412,2,4
20090527161412,2,4
20090527161413,2,2

File_B_new.csv

20090527161405,3,2
20090527161407,3,2
20090527161408,4,5
20090527161410,5,6
20090527161412,5,4
20090527161412,9,2
20090527161413,3,4

Both files now contain 7 rows, and each date/time value is mirrored in the respective row.

The language of the program doesn’t matter that much, but I prefer to be able to run it on mac without having to download new packages. Shell access and lack of GUI is fine.

A/B testing 2 or more subjects:

Immediate Requirement: Need MySQL Script in less than 1 day.

Create SQL Script to update table with multiple subjects for one email distribution on % basis in ASP.NET/MySQL.

For example: We have a list of 1000 contacts (email addresses) and want to send emails with different subjects on percentage basis.

Email body is same.

User selected # subjects, entered subject names and percentages.

Subject 1 : GPS on sale ———— (user selected – 30%)
Subject 2: GPS Free———— (user selected – 50%)
Subject 3: GPS – Upto 70% off———— (user selected – 20%)

i.e

30% (300) of the emails should go out with Subject 1
50% (500) of the emails should go out with Subject 2
20% (200) of the emails should go out with Subject 3

————————————————————————————-
Current Scenario:

1. All the above settings are stored in distributionsetup table (emailid, contactlistid, subject1,subject2,subject3, percent1,percent2,percent3,datetobesent etc….)

2. System will insert 1000 rows in distributionqueue table with subject1.
INSERT INTO distributionqueue (subject, fromname, fromemail, tofirstname,tolastname, toemail, company, datetobesent, sentstatus etc…)
SELECT ‘GPS on sale’ subject, fromname, fromemail, tofirstname,tolastname, toemail, company, ’2009-05-20 10:00:00′ FROM AddressBook where contactlistid= 1;

3. System will send email to 1000 contacts with the same subject (subject1)
————————————————————————————

Requirement :

We need to update subject column in distributionqueue table randomly with following criteria.
50% (500) rows should get updated with Subject 2
20% (200) rows should get updated with Subject 3

Hope i explained well, let me know if you have any questions.

Thank you

Dear everyone,

I’m having right now a problem with my hosting site, the problem is that my database is making overload in the server because of some code and I should delete these codes,

but the problem I don’t now what is the codes are coding for and where I can find them,

so what I want is someone tell me what these code are and help me by deleting them,

the codes:
queries that caused overload, they are as follows for Phantom_forum database:

-&amp;gt;Query summary
Time: 13% (1393 sec) Amount: 13% (109 queries) Rows Examined/Sent: 73923 / 109 Avg. Query Exec/Lock Time: 12 / 0 sec.
Used databases: [Phantom_forum]
Query example: use Phantom_forum; SELECT COUNT(*) AS posts FROM post AS post WHERE threadid = 1826 AND visible = 1 AND dateline &amp;lt;= 1229550419;
|id rows Extra
|1 393 Using where
|__________________
-&amp;gt;Query summary
Time: 12% (1210 sec) Amount: 9% (75 queries) Rows Examined/Sent: 107226 / 727 Avg. Query Exec/Lock Time: 16 / 0 sec.
Used databases: [Phantom_forum]
Query example: use Phantom_forum; SELECT post.postid FROM post AS post WHERE post.threadid = 2139 AND post.visible = 1 ORDER BY post.dateline LIMIT 360, 10;
|id rows Extra
|1 571 Using where; Using filesort
|__________________
-&amp;gt;Query summary
Time: 5% (588 sec) Amount: 6% (50 queries) Rows Examined/Sent: 670 / 670 Avg. Query Exec/Lock Time: 11 / 4 sec.
Used databases: [Phantom_forum]
Query example: use Phantom_forum; SELECT * FROM datastore WHERE title IN (”,’options’,'bitfields’,'attachmentcache’,'forumcache’,'usergroupcache’,'stylecache’,'languagecache’,'products’,'pluginlist’,'cron’,'profilefield’,'loadcache’,'noticecache’,'smiliecache’,'bbcodecache’,'banemail’,'noavatarperms’);
|id rows Extra
|1 18 Using where
|__________________
-&amp;gt;Query summary
Time: 4% (436 sec) Amount: 4% (35 queries) Rows Examined/Sent: 12228 / 3897 Avg. Query Exec/Lock Time: 12 / 5 sec.
Used databases: [Phantom_forum]
Query example: use Phantom_forum; SELECT userid, lastactivity, options, username, user.usergroupid, displaygroupid, groupa.opentag as opentaga, groupa.closetag as closetaga, groupb.opentag as opentagb, groupb.closetag as closetagb FROM user as user LEFT JOIN usergroup as groupa ON(user.usergroupid = groupa.usergroupid) LEFT JOIN usergroup as groupb ON(user.displaygroupid = groupb.usergroupid) WHERE lastactivity &amp;gt; 1242286910 ORDER BY username;
|id rows Extra
|1 214 Using where; Using filesort
|1 1
|1 1
|__________________
-&amp;gt;Query summary
Time: 3% (401 sec) Amount: 3% (30 queries) Rows Examined/Sent: 29540 / 277 Avg. Query Exec/Lock Time: 13 / 0 sec.
Used databases: [Phantom_forum]
Query example: use Phantom_forum; SELECT SQL_CALC_FOUND_ROWS visitormessage.*, user.*, visitormessage.ipaddress AS messageipaddress ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom FROM visitormessage AS visitormessage LEFT JOIN user AS user ON (visitormessage.postuserid = user.userid) LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS cust … [too long]
|id rows Extra
|1 232 Using where
|1 1
|1 1
|1 1
|__________________
-&amp;gt;Query summary
Time: 3% (353 sec) Amount: 3% (28 queries) Rows Examined/Sent: 240226 / 704 Avg. Query Exec/Lock Time: 12 / 0 sec.
Used databases: [Phantom_forum]
Query example: use Phantom_forum; SELECT user.*,usertextfield.*,userfield.*, user.userid, options, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid ,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight , IF((options &amp; 512 AND user.userid &amp;lt;&amp;gt; 0), 0, lastactivity) AS lastvisittime , user.xperience, user.xperience_level FROM user AS user LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid) LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid) LEFT JOIN av … [too long]
|id rows Extra
|1 3593 Using where; Using filesort
|1 1
|1 1
|1 1
|1 1
|__________________
-&amp;gt;Query summary
Time: 2% (294 sec) Amount: 3% (26 queries) Rows Examined/Sent: 42217 / 26 Avg. Query Exec/Lock Time: 11 / 0 sec.
Used databases: [Phantom_forum]
Query example: use Phantom_forum; SELECT COUNT(*) AS count_posts FROM post AS p INNER JOIN thread as t ON p.threadid=t.threadid WHERE p.visible=1 AND p.userid=2576;
|id rows Extra
|1 509 Using where
|1 1 Using index
|__________________
-&amp;gt;Query summary
Time: 2% (220 sec) Amount: 3% (25 queries) Rows Examined/Sent: 1638 / 210 Avg. Query Exec/Lock Time: 8 / 1 sec.
Used databases: [Phantom_forum]
Query example: use Phantom_forum; SELECT post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted, user.*, userfield.*, usertextfield.*, icon.title as icontitle, icon.iconpath, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory, postparsed.pagetext_html, postparsed.hasimages, sigparsed.signatureparsed, sigparsed.hasimages AS sighasimag … [too long]
|id rows Extra
|1 11 Using where; Using filesort
|1 1
|1 1
|1 1
|1 1
|1 1
|1 1
|1 1
|1 1
|1 1
|1 1
|__________________

I want a really fast solving for this problem,

Note: My database contain VB forum &amp; Joomla 1.

Best Regard,
Sarab

1. I just add in the load kmap file button so here is how it needs to work.
When clicking on the button must have Operator ID, Lot ID filled and FFD must load.
Clicking on the button will launch the dialog to browse for the file.
File will be filter as Left 6 numbers of lotID and *.ffm. (Example if lot ID is 635437.1 then will looking for file is 635437*.ffm)
And the default path is: C
When loaded in the mainform (txtkmapfilename) will show full name of current file loaded (No path)
After loading the file reading contents of the file and popup the dialog the have 3 Colums with 2 bnts.

Only Display on rows that in ffm file in column 6 that have value of -1.000000

Column 1 is: DUT-Pin
Column 2 is: Current resistance. (For all rows in ffm content on row 6 the have value that is -1.000000)
Column 3 is: New resistance (This should be blank until the resistance on MainForm changed and will have value base on that)

Dialog look like this but in the Form (You can select on the line of DUT-Pin)
When you select on the on the rows of Dut-Pin,Current Resistance and new Resistance will send command to mainform to find and also send Dut-Pin to mainform.

I currently have a CRE Loaded (OScom) website and I need a bulk product uploader script to be implemented in the admin area/backend.

I have created a sample/demo page of the features I need and how I want it to work and look. You can see this page at:

http://1stdownshop.com/BULK-UPLOADER/bulk_products_uploader_page.htm

The details are below:

When adding products with this bulk product uploader script,

1 – There should be 50 rows so I can upload 50 products at a time

2 – The description field/editor should be exactly as the one that is already in the backend of my CRE Loaded script. With this bulk uploader script, you only have to put the description ONCE and it will apply to ALL items in ALL 50 rows

3 – In the backend of my CRE Loaded site, there are some fields that I do NOT need to use…so they should just be set to default to the following:

– Product Status will default to “IN STOCK”

– Products Quantity will default to “0″

– Date Available will default to “0000-00-00″

4 – There are some fields that I just want to use the SAME info for them. So when info is entered into this “bulk uploader script”, the same info will fill into these fields as well. They should be as follows:

– When inputting “PRODUCTS NAME/TITLE” on the bulk uploader script, it should be copied over to “Products Name”, “Products Page Title”, and “Page Header Description” fields in the backend/database…so they will all be the exact same.

– When inputting the “PRICE” on the bulk uploader script, it should go to the “Net Price” and “Gross Price” fields in the backend/database

– When inputting the “PRODUCT MAIN IMAGE URL” in the bulk uploader script, the system should look in the “public_html/images/” folder, so the only thing that needs to be put here is the RELATIVE URL with any sub-folders (i.e. “BL/NFL/BigDaddyRecliner/BigDaddyCardinalssm.jpg”).

– ALSO, when inputting the “PRODUCT MAIN IMAGE URL”, it will be copied over to the “Small Image”, “Products Image”, and “Pop-up Image” fields in the backend/database…so they will all be the exact same.

5 – In the FIRST ROW ONLY of the bulk uploader script, there should be a “Fill Down” feature in each field (just like the feature in Excel spreadsheets) to save time. The only column that will NOT have the “Fill Down” feature will be the “PRODUCTS NAME/TITLE” column to avoid any mistakes because it must be unique.

6 – If the “PRODUCTS NAME/TITLE” field is blank, then anything else in that particular row after that will be ignored and will not be uploaded. For example, this tool can upload up to 50 items at a time…and if you use the “Fill Down” feature, it will fill all 49 rows below it. If you are uploading only 32 products, you will NOT need to manually delete anything that was filled down because it should be ignored as long as this “PRODUCTS NAME/TITLE” field is blank.

7 – On my demo page you will see some fields that have drop-down boxes. These fields should pull directly from the Catalog database…these are Categories, Sub-categories, Manufacturers, &amp; Tax Class.

8 – When selecting the “Main Category” on this bulk uploader script such as “NFL”, this should trigger the “Sub-Category” field to show ONLY sub-categories of the MAIN category that is selected…to prevent any errors while uploading products.

9 – Last but not least, it may take a little time while I am filling in the form on this script…and my session may time out…this will cause me to have to login again to the admin area and I will lose all data and do it all over again. For this reason, I need the session time to be ONE HOUR before it logs me out of the admin area. This should allow plenty of time for someone to complete the task of uploading the 50 products that this script should allow.

I play only European roulette at two casino’s they are both playtech powered casino’s the reason i play at playtech casino’s they give you the option to spin the wheel without placing a single bet so i can spin the wheel whenever i feel like it. The casino’s are.

1. Swiss casino
2. Magic box casino
I need the bot to work at these two casino’s

1. I need the bot to spin the roulette wheel automatically.
2. The bot has to keep track of rows and dozens.
3. The bot needs to count how many rows and dozens hit in a row counting for me in a little window beside the roulette wheel.
4. The bot needs to stop and let me know when the number of rows and dozens have hit in a row that i have set the bot to count. (EXAMPLE) I would set the bot to spin automatically then stop and alert me when 5 rows or dozens have hit in a row. And i would like to be able to set the bot to count from 1-20 times in a row.
5. I attached a couple pictures to show you what dozens and rows are.
6. Now the picture’s i sent you are of one of the casino’s i need the bot to run on. and both casino’s that i need the bot to run on are the same thing just look different but all buttons / numbers are the same all layed out the same way cause there both playtech powered so pretty much that what is different is the casino colors like the spin button is in the exact same place in both casino’s so on and so on

PS.

I might want to sell the bot to close friends so the application and bot needs to be registered to me
And ill need all the source codes if i have trouble and need to debug in the future.

I also want it to be set up where 1 human can play a bot “AI” if player choose’s to.

Game Info:

Roll a dice for higest roll to decide who will play red and who will play black. Whoever wins the toss chooses. The red player will make the opening move.

On the red player’s side, place one red checker on each black square in the first three rows of squares.

On the black player’s side, place one black checker on each black square in the first three rows of squares.

Make sure there are 12 staggered checkers on each side of the board with two empty rows in the middle.

The red player begins by moving one red checker forward diagonally onto an adjacent free black square.

Take turns moving one checker, one square forward diagonally, at a time.

‘Jump’ your opponent’s checker if it is in a square directly diagonal and adjacent to your own checker and there is a free square on the other side. To do this, move your checker over your opponent’s checker and place it on the opposite square. Take possession of your opponent’s jumped checker by removing it from the board.

If you jump a checker and land in a position to jump another of the other player’s checkers, jump that checker as well during the same turn.

‘King’ one of your checkers when it reaches the farthest row from your starting side (your opponent’s back row). Signify a kinged checker by having your opponent stack one of your jumped checkers on top of the kinged checker. Kinged checkers can move both forward and backward, but still can only move diagonally to adjacent black squares, one square at a time. Only a kinged checker can move backward and forward.

The first player to remove all of the opponent’s checkers from the board by jumping them – or who blocks his opponent so that he cannot move – wins the game.

I will supply the background for the program, the board and checkers are pretty self explanitory.

I need a part of a small program, which shows the resulats of a calculation

Output is one window with 4 tabs

1st tab: spline graph
2nd tab: a matrix (15 rows, 3 column (name, number in %, number in Euro)) + bar chart
3rd tab: a matrix (variable number of rows, number in %, 2 numbers in Euro)
4rd tab: a matrix (variable number of rows, number in %, 2 numbers in Euro) + additional input area (2 radiobutton, if (and only if) 2nd radiobutton is active it should be possible to enter a number)

for graphs please use www.advsofteng.com (I say you which one)
each matrix has an additional header row and it should be possible to sort matix.

——

Additional at each tab (at same position) there are 2 buttons:
One button creates a pdf (with an “Save-file-dialog”). Output is the same like that is vissible at screen + 2 additional lines as footer (from me)
2nd button should close the window.

——

Please use Microsoft Visual C++ Express

——

Name of headers and so on will be changed by myself (you can work with dummy data).

Hello,

I have a script, it displays all active banners using pagination. Once the banner is clicked it doesn’t show up again. This works fine.

The issue:

For example I’m displaying 25 banners per page, I have over 1000 active banners so there are 102 pages.

If I click on the all 25 of the banners on page one and then leave the site, the next time I come back to the site they do not show. This works correctly. But here is the problem, when I come back to the site page one is blank, I have to move on to page 2 in order to see the next round of banners. So in other words it’s not moving the banners up to page one.

I need this fixed.

Here is the code if you think you want to tackle it.

[code]
&lt;?php

session_start();

include "../header.php";

include "../config.php";

include "../style.php";
$uname=$_SESSION[uname];
if( session_is_registered("ulogin") ) {

$tbl_name="banners"; //your table name

// How many adjacent pages should be shown on each side?

$adjacents = 3;

/*

First get total number of rows in data table.

If you have a WHERE clause in your query, make sure you mirror it here.

*/

if( session_is_registered("ulogin") )

{

$query = "SELECT COUNT(*) as num FROM banners, banner_clicks WHERE banners.status=1 and banners.max&gt;banners.shown AND banner_clicks.userid&lt;&gt;'".userid."' group by banners.id";

}

else

$query = "SELECT COUNT(*) as num FROM $tbl_name WHERE status=1 and max&gt;shown";

$ttlpag=mysql_query($query) or die (mysql_error());

$total_pages = mysql_fetch_array($ttlpag);

$total_pages = $total_pages[num];
$qn="select * from sat_banclicks where userid='$uname' group by bannerid";
$ns=mysql_query($qn);
$nk=mysql_num_rows($ns);
$total_pages=$total_pages-(2*$nk);
//echo $nk;

/* Setup vars for query. */

$targetpage = "bannerlinkview.php"; //your file name (the name of this file)

$limit = 25; //how many items to show per page

$page = $_GET['page'];

if($page)

$start = ($page - 1) * $limit; //first item to display on this page

else

$start = 1; //if no page var is given, set start to 0

/* Get data. */

if( session_is_registered("ulogin") )

{

$sql = "SELECT banners.id as id, banners.name as name, banners.bannerurl as bannerurl, banners.targeturl as targeturl, banners.userid as userid, banners.shown as shown, banners.clicks as clicks, banners.max as max, banners.added as added FROM banners, banner_clicks WHERE banners.status=1 and banners.max&gt;banners.shown AND banner_clicks.userid&lt;&gt;'".userid."' group by banners.id LIMIT $start, $limit";

}

else

{

$sql = "SELECT * FROM banners WHERE status=1 and max&gt;shown LIMIT $start, $limit";

}

$result = mysql_query($sql) or die (mysql_error());

if(!mysql_num_rows($result))

{

$result = mysql_query ("SELECT * FROM banners WHERE status=1 and max&gt;shown LIMIT $start, $limit");

}

/* Setup page vars for display. */

if ($page == 0) $page = 1; //if no page var is given, default to 1.

$prev = $page - 1; //previous page is page - 1

$next = $page + 1; //next page is page + 1

$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.

$lpm1 = $lastpage - 1; //last page minus 1

/*

Now we apply our rules and draw the pagination object.

We're actually saving the code to a variable in case we want to draw it more than once.

*/

$pagination = "";

if($lastpage &gt; 1)

{

$pagination .= "&lt;div class="pagination"&gt;";

//previous button

if ($page &gt; 1)

$pagination.= "&lt;a href="$targetpage?page=$prev"&gt;