Posts Tagged column

Excel Spreadsheet Tool / Script

I need a tool, script, setup of Excell to handle changing all numbers in Column I (PRICE). The resulting number would be a % of Column I (PRICE) plus the original number in Column I (PRICE) . For example, if the original number was 100, and I need the % (to be added to original #) was 30% the resulting calculated figure would be 130.

I need to see a proof that the tool, script etc works.

I will pay best offer on proven work.

The Spreadsheet attached is to be used and the column to be edited is attached.

Thanks, Casey Connors

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

VB Application To Edit Data From Excel File

Project Description

Bring data from Input file, edit information in fields and save back to Output file.

Have search option to call data from input file. Search value will be only use for to find from "ProductNo" column. So we will call the data using ProductNo.
Once we hit the search, system will bring all the information for that line, column headers are as field name and editable text boxes where the data from input brought. We will edit the information in text fields and then click on save and system will save the new information to next available row in "output" file in the same column header order in input file.

Why we need this?

We often change the information about products and we have to do it on this input excel file. It is very confusing and tiring to do it with scrolling up and down , right and left through rows. So we need this application where it will show all the information orginized in 1 page where we can edit the data from cells.

There are 90 column headers for each product, so for this application it will be hard for to make all column headers visible in 1 page. So lets make most important column headers data at the top side of the page.

Most common used fields / column headers data from input file;

-ProductNo
-Product
-SKU
-Oem
-Price
-Quantity
-Weight
-Brief
-Description
-Thumbnail
-Photo
-ExtText1
-ExtText2
-ExtText3
-ExtText4
-ExtText5
-ExtText6
-Active
-Mpn
-NaturalSearchKeywords
-NaturalSearchDescription
-Keywords
-Category

All the rest of column headers data less used so they can be bottom of the page.

Please remember, application will not make any changes on input file. It will only read data from input file. Adjusted data will be saved to next available row in output file.

Input file is CSV ( comma separated ) output file must be also same CSV format.

Sorry for my poor english. If you have any questions please feel free to ask.

Attachments are sample files. In real input file there are much more products but all column headers are always same.

**When you bid please explain how you want to do the application otherwise your bid will be disregarded.
**Full payment will be done only after final delivery.

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

Typing Up Of Handwritten Notes & Updating Googlemaps

This project is a combination of two of my previous projects:

Typing up of hand written notes 2 is (Project Number 975105)
Updating Googlemap locations for website (Project Number 981570)

The project will be divided into two stages as I will have to upload the typed up notes into the website. This will then make the Googlemaps available for updating.

There are approximately 50 pages (9 batch files) of notes to be updated. I have attached a sample of a batch file so you can see the handwritten notes and presentation of Googlemaps. I have also include a file showing the instructions so you can see what is involved in updating each Googlemap record.

****Typing up of hand written notes****
I need the data typed into seperate columns in Excel so that they can be uploaded into a website.

The are 4 colums required:
Column 1 = Location Name (these have been written inCAPS and small-letters, however need them in Title Case so that only first letter of each word is capitalised)
Column 2 = Location Position (will typically look like C1, A3, B12 etc and will be written in Pink)
Column 3 = Street Name (appears at top of list of locations in the centre)
Column 4 = Street Type (e.g. Street, Boulevard, Lane, Road)

****Updating of Googlemap Locations****

The aim of this exercise is to update the marker position on the Googlemap for each location.

The website is an online retail directory of locations around the city. The correct position of the marker on each Googlemap is critical as many streets and locations are not sufficiently signed or labelled in real life! Many web visitors will print these maps and take them in the car with them or search them via Blackberry/SmartPhone while in the car.

When a new location is established in the database it automatically defaults to the following:

Latitude: 6.450088719070919
Longitude:3.407949686382949

I have recently loaded a number of new locations and need someone to manually edit and update the marker on the GoogleMap

In the files that will be sent though there are 26 maps showing a total of 780 locations.

Each update should only take 1-2 minutes, once the updater is familiar with the streetmap. All the locations are in a local area covering approximately a few miles.

The instructions attached are based on the easiest method I found when updating the records. I have included a screen dump of what the website will look like after each action. Please use this to estimate how long it will take you to complete the assignment and the work involved.

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

Graphic Design For Online Brand Bags/clothing Shop

Hello
I already have several designer partners to create graphics for my online shops, but they are too busy, so, Im here again to look for some other great designers.
My requirement for quality is very high, if you can not offer high quality work, do not bother bidding because your design may be rejected at a glance.
I personally prefer small companies of 3-5 persons because bigger companies ceo are usually not available on line for discussion.
All designs are for oscommerce, and I prefer two column graphic, I dont like default column right box because we need to list more items per page.
To create high quality graphics, designers should be open to learn some basic knowledge of the brands, and all our designs should be brand niche related.

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

Lookup Emails And Websites For 1000 Contacts

Project is to obtain email addresses for a list of about 1,000 contacts.See attached.

The list already has all contact info in excel. By using the firm name you need to look up the www for the firm. Enter it in Column B by adding a new column. In column C enter the email address for the person.

Currently the first and last name of the contact are in the same column. Copy the first name and past it in a new column, leave the middle and last name last they are. You must produce a sample of 10 entries to make sure you understand the project prior to being awarded.

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

MyCardShake

m looking to create 2 seperate apps that run using the same base programming. Both apps have the same function but would use different graphics and both would be very simple and able to go through the entire app in 5-10 seconds.

Overview
The app(s) would essentially take approx 50 objects randomly displayed in columns on Screen #1, the user would select one column (7-10 objects). After the user selects a column Screen #2 would appear with those 7-10 objects specifically placed into different columns. The other 40-42 objects will again be randomly distributed into columns filling in the gaps of the specifically placed "User Selected" objects.

Key components:
1) Random (or as close to) distribution of objects into columns
2) Specific placement of the 7-10 objects the user selected in Screen #1 onto Screen #2

This is the major function of both apps, with the only difference between the two being what the objects are being displayed. (eg. playing cards, icons, numbers ect.)

This may seem confusing but would become very clear if we started working together.

I have all designs of how I want every screen of each app to look like and am looking for somebody to turn my idea and graphic templates into a working app that meets the Apple Standards and can be sold on itunes.

Budget:
Because both apps run using the same programming and contain the same functions I do not plan on paying full price for 2 seperate apps and would like to agree on a price for both combined.

Thank you,

Cody Rose

coro ent.

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: , , , , , ,

PHp Coding To Redo Layout Of Existing Site.

I have inherited a hand coded php driven web site. The format is two columns with two (2) additional data fields in the top banner area. I would like change to three columns and have the entire page centered in the browser, rather than flush left. The third column would be an additional data column for the business card size ads. The data would then populate all three data areas, without duplication, and refresh in random order on each page load. There is currently a limit of 20 ads to be displayed and this additional column is partly to accommodate more member ads. The limit on Ads which is managed in the Master lists controls to the pHp would also need to be adjusted.

I have been able to modify individual pages of HTML but have no experience with pHp programming and cannot figure out how to change the main layout to allow the three columns as described above. The new layout would have a left col. fixed at the width of the ads, the right column fixed as the width of the ads, and the middle column could be set (hopefully) as expandable from 500 px (approx.) to 700 px. (plus or minus). The left and right should be expandable based on ad width, as exists now, in case we go for slightly larger member ads.

The second existing data area for ads, located in the banner portion, would expand to three ads horizontally. This used to be considered the premium ad area but now all ads are treated equally.

The top data area, which is used as web specific comments and links – not for ads, would expand to fill the area as far as the right column (as is now) and will continue to be populated by the current method of coding HTML pages loaded in through the database.

The footer are would be best if it could span all three columns and be set up so I can change content in Dreamweaver HTML, primarily to be able to put contact/help/facebook/ etc. links there.

One other parameter which might require adjustments is the drop down menus in the members and non-members area, allowing that they are SPRY Framework menus created using Adobe Dreamweaver. Id like to be able to continue this method.

To look at the existing site, for what needs to be changed, go to: www.ptod-ps.org. Of course all pages would need to work in the new layout.

Thanks,
Lawrence Peterson

Tags: , , , , , ,

Md5 Hash Creation And Modify Data In One Column $15

Here is the task – $15.00

begin
1. i have .sql file with one column has incorrect data
example
remove extra "- in title which is in the end (only end "-" needs to be removed) example
"Toshiba-Satellite-3005-Memory-256MB-133-SODIMM-PC133-Ram-For-Laptop-Pno-3005-"
2. recreate hash in the column
end

Note: zip files are 5 gb to 17gb s i expect the script you provide finish in atleast 2 -3 hours to do the replacement
and hash creating

i will escrow and send me files and take the money

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: , , , , , ,

HTML Table Column To Export To Outlook To Field

Hi,

I have a data view webpart , where i have to filter the columns using Dropdown Check box list and have a search box which filters the dataview when we type text.

1. Design Dropdown checkbox lists having data view webpart column data , when some one selects one check box from drop down it should display data associated to that text
2. Search box – starts filtering the moment we start typing the text
3. column – should be able to slect a specific column and have a button, when we click on button that column should automatically export the data to Outlook To: field. The column is email address.

Tags: , , , , , ,

Md5 Hash Creation And Modify Data In Column $15.00

Here is the task – $15.00

begin
1. extract zip files with .sql files of table products (big zip files 17gb compressed to 50mb)
2. load data to mysql
3. remove extra "- in title which is in the end (only end "-" needs to be removed) example
Toshiba-Satellite-3005-Memory-256MB-133-SODIMM-PC133-Ram-For-Laptop-Pno-3005-
4. recreate hash in the column
dump the data back to disk and zip it
end

Note: zip files are large so do this
extract .sql files and load data to mysql
issues "insert into tmp Select url_has, url_custom, pid from products"
now work on this tmp table and finish your task and dump data out

i will escrow and send me files and take the money

Tags: , , , , , ,

Md5 Hash Creation And Modify Data In A Column $15.00

Here is the task – $15.00

begin
1. extract zip files with .sql files of table products (big zip files 17gb compressed to 50mb)
2. load data to mysql
3. remove extra "- in title which is in the end (only end "-" needs to be removed) example
Toshiba-Satellite-3005-Memory-256MB-133-SODIMM-PC133-Ram-For-Laptop-Pno-3005-
4. recreate hash in the column
dump the data back to disk and zip it
end

Note: zip files are large so do this
extract .sql files and load data to mysql
issues "insert into tmp Select url_has, url_custom, pid from products"
now work on this tmp table and finish your task and dump data out

i will escrow and send me files and take the money

Tags: , , , , , ,

Marketing Database

I would like somebody to search the web (google, linked in, facebook, twitter, yahoo and all other search options) and provide to me a list of marketing people within Australia, located only in the state of New South Wales. The type of people Im after must have the following job titles (or very similar):
* Marketing Director
* Marketing Manager
* Category Manager
* Senior Brand Manager
* Brand Manager
* Product Manager
* Marketing and Communications Manager

Once these people have been sourced, I need the following information on these people provided to me in an microsoft excel spreadsheet:
* First name
* Last Name
* Job Title
* Australian Address which includes:
– Street Address (ie 5 Johnson Street)
– Suburb/City
– State (New South Wales only)
– Postcode

This information is to be provided to me in a Microsoft Excel spreadsheet, with each column containing the key information (ie first column = first name, second column = second name, 3rd column = job title, 4th column = Street Address, 5th column = Suburb/City

Tags: , , , , , ,

Excel Automation Script

I need a quick Excel automation script that changes the text in one column then saves back the sheet.

The script is simple, takes an input sheet, changes one column value, saves back the sheet.

Prefer to have it done in C# using Reflection only (no dependency on what MS Office version is installed). Source code delivery. Budget is small.

Tags: , , , , , ,

Database Management Web

I need some one that can do the follow task:

I need a page with capabilities to:
1-taking a connectionstring show database in dropdownlist.
2- then show tables on that database.
3- Selecting a table, show column and column datatype.
4- Clone that table with new one name.
5- Capability to do Alias for columns.

Database is SQL Server 2008 and Visual Studio 2010.

most important i need this functionality at least for saturday. So, if you got the experiences doing something like this you may get the job.

IF you have previous project that can do this…let me now

Skills Required:
jQuery, Microsoft SQL Server, Entity Framework, LINQ to SQL

Tags: , , , , , ,

WordPress Customization – Simple PHP Project (1 Day Or Less)

I am looking for someone to alter the PHP for this WordPress theme:
http://suprmarket.net/themes/gridalicious/

The edits required are:

Tags: , , , , , ,

Typing Up Of Hand Written Notes 2

Hi

I need some assistance with data entry/typing up some handwritten notes.

Attached is a sample page of the notes. There are 29 pages in total.

I have scanned copies of pages which will send over for typing up.

I need the data typed into seperate columns in Excel so that they can be uploaded into a website.

The are 2 colums required:
Column 1 = Location Name (these have been written inCAPS and small-letters, however need them in Title Case so that only first letter of each word is capitalised)
Column 2 = Location Position (will typically look like C1, A3, B12 etc and will be written in Pink)

Based on similar project posted previously this work is worth $30 USD.

Thanks

Michael

Tags: , , , , , ,

Script Menu

Can you make the following changes to the script:

1. Now, when I click on categories (the left), cubcategory look like: http://www.scriptsfeed.com/demos/General_Classifieds/ (view: Select a Subcategory)
I want to look like this subcategories: http://www.scriptsfeed.com/demos/Auction_Software/ (click on a category on the left menu, then open the menu of subcategories)

2. Now, categories (under advanced search) are arranged in a one column. I want you make them to two column.

Web-Script is created with Open Source.

Tags: , , , , , ,

XML Gateway To Excel Project

I need someone to create an excel page that automatically cross references company names against the companies house database via their xml gateway to get the company number and then cross references the company number against the database to return whether the company is bankrupt.

The excel spreadsheet should therefore have the following column headers:

Company Name, Company Number, Status.

I will then be able to add a list of 1000 companies to the company name column and the spreadsheet will show the company number and status.

The URL for the site is [Removed by Freelancer.com Admin], go to the webcheck section. The url for the xml gateway is http://www.companieshouse.gov.uk/toolsToHelp/softwareFilingXmlFaq.shtml.

Tags: , , , , , ,

Two Simple Magento Fixes

I have a multiple website Magento installation. There are two small problems with two of the websites.

1. One website has a problem with the category links on the layered navigation. The link url is not formed correctly and has //l/ preceeding the page element. e.g. http://www.website.com//l/air_optix instead of http://www.website.com/air_optix

2. One the other website I have installed an FAQ extension manually through FTPing files:

http://www.magentocommerce.com/magento-connect/FME+Extensions/extension/3634/advance_faq_management

This component seems to have changed the page templates. Layered navigation no longer appears on the left column in the category pages (e.g. http://www.sunglasses247.co.uk/giorgio-armani). Plus the extension has added an FAQ search to the right column on these pages which needs to be removed. I can supply the installation documentation for the extension which shows which files were changed.

I believe this is a $30 project as it should take no more than one hour for a good developer to fix.

Thanks,
Phil

Tags: , , , , , ,

Order Processing Macro With Shipping Address Check

We will do order processor for my company.

We will have 2 input files,

1)

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

Crunchbase API Content

I would like a spreadsheet created and maintained automatically with funding activity from Crunchbase (who has an API): http://www.crunchbase.com/funding-rounds?page=1 . The spreadsheet would have company name, date, round, size, and investors. the investor column should have the investors placed separately in a column. So if there are 3 investors (Rob, Ryan, Rich), each would be in its own cell within that row. This would be updated weekly and available via email (Sunday night)?

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

Excel VBA Macro Tool To Draw Org Charts

I am looking for a VBA / macro expert to build a tool that can automatically draw org charts in Excel.

The data is in spreadsheet form with a number of columns showing where each team sits and how each team is related. For example, column 3 says the name of the team is called BIG; column 2 says that the next team up the ladder (on the next level) is called BIGGER, and column 1 says that the next team above that is called BIGGEST. The spreadsheet has many of these rows. Obviously, each team can have a number of teams below it. For example, team BIGGER could also have a team called SMALL sitting below it.

Ideally the tool will draw the org chart and put in each box in the chart the name of the team and the number of staff (shown in column 4 of the spreadsheet).

Only VBA / macro can be used to build the tool to work in Excel 2003.

I need the tool by next week.

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

WordPress Niche Templates Or Plugin

I would like a word press template where I can add graphics into it like a header at the top and this header will appear on the other pages automatically.

Pages like About,Contact Us, Site Map, Additional Articles, Terms Of Use Privacy Policy.

It will be one column and two column where I can add graphics at a certain size and also bullet points which be ticks showing the points of the project.

The first page would be one column and the other pages would be two column were on the right would be where they can sign up for a mini course and another area where they click on the product. This appears on all pages except the main page which is one column.

Also I have the ability to change the pages About Contact Us Site Map Additional Articles Terms Of Use Privacy Policy in an order i choose.

I have an example of a site that I like but would like to make it better and ideas are welcome. Also I could sell this in the future where i could sell this as a product, not the webpage but the product that can do this on any niche idea you have. I have the right to make additions by you or more until project is finished.

I have a limited budget and there is no time limit.

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

Sundanese Language Dictionary

I am not familiar with Sundanese, because I am a Javanese, so I prefers someone who could speak Sundanese. I want you to collect all the vocabulary words that are stored in excel format. If the Java language there such a thing (ngoko, kromo, kromo inggil), so I think Sundanese too, please for each column is separated by its type, plus one more column for an explanation. In total there are four columns.

Maybe you can collect them from the dictionary, or other ways, it is good. The important result is in excel format.

..:: I need asap ::..

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

Joomla Blog/layout

Having issues with the parameters in my blog layout.

When I change the number of articles that appear in the blog layout it affects the side column, it drops the side modules down to the bottom of the blog layout.

http://www.utslss.com/careers/opportunities

I want to adjust it so the side modules are aligned to the top of the column again.

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

Desktop Tool To Find Repeated Lines In Excel Documents

Hi,

I have 5 Excel files with some repeated data in some lines (column A). I need a desktop tool to go through the files, find the repeated lines (in column A) & erase the line … but before erasing , needs to get the information from certain columns and put in another file.

This is a very bad explanation… but if you feel you can do something of this sort… please quote (anything) and by pm i will give you full details of exactly what i am looking for…. so you can requote after having full details.

This should be quite a straigth forward project for somebody who knows what he is doing. If you have read this, please add "456" in your comments. Thanks,

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

Create New Right Column For Website

Looking for a skilled programmer for fast quality results.

We want to add a right column to all the pages of our website. A mirror image of the column on the left but just empty. The website is SickDutyEmblems.com

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

Fix And Add Additions To Website

We are looking for an experience website programmer to do the following simple tasks for us:

1. Fix the top banner so it "stretches" to fit EVERY page.
2. Fix Facebook badge on the left column so it is not cut off.
3. Add Twitter badge to a "NEW" right column.
4. Add smaller Twitter and Facebook badges on the very top of the page near the banner.
5. Install Google Analytics properly to every necessary page.

Feel free to contact for any questions.

website: SickDutyEmblems.com

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

The GadgetGUY Column

Need someone fluent with WordPress and website design. Have an established blog in the tech industry and trying out a new theme. Need someone to round out new design using existing theme, as well as setting up widgets, plugins, logo, etc. WordPress coding, theme design experience preferred. Please provide portfolio or list of other blogs youve worked on when bidding.

Look forward to working with you.

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

Microsoft Excel Data Extracting

We have Approx 20 spreadsheets of data, some with one table and others with several, that we need to extract into an easier to read columned spreadsheet. Many products we sell have several different configurations, so the vendor has put the price sheet in a table instead of listing them individually in a column. We need to get them out of the table and into a column to enter them in our system.
There is a pdf catalog online where you can see exactly how each product should look and would be ordered so taking the individual parts out of the tables and putting them into the columns would be easier.

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

Remove Duplicate Email Addresses From Database

I have some excel files that have need to be processed using a script. The spreadsheets have several columns. One column is an email address column. I need a script that will look through the email address column of one spreadsheet and remove rows contain those addresses in the second spreadsheet. There are a couple of other functions need as well. For example comparing 2 files to file duplicate records. And also when there is a duplicate deciding which record to pull based on certain criteria.

Although these files are currently excel files I would be happy to upload them to a mysql table. The script could then be processed via PHP. Please tell me in your bid wish way you wish to process the data (VBScript or PHP). I would prefer VBScript. My budget is $30.

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