Archive

Posts Tagged ‘xls’

Automated – Inventory Control

January 22nd, 2012 Comments off

I have a Big Commerce store. My inventory can be exported to an xls/csv file.

My supplier provides me with feeds that are updated daily.
1 – out of stock
2 – discontinued

I would like the programmer to run some sort of macro, or any other way possible that automatically does the following:
1- downloads my current inventory from Big Commerce
2- downloads the data feeds from the supplier (direct links will be provided)
3 – compares the data, update big commerce inventory and provid…

Scraper To Create Jpgs Of Google Maps From Addresses In .xls

January 3rd, 2012 Comments off

I have an XLS spreadsheet that contains addresses for a few hundred street address locations. I need a PHP script that I can execute that will pull each street address from the document, lookup the address in Google Maps, take a JPG snapshot of the map, crop it to specific dimensions, and save the image back into the spreadsheet automatically.

The script must repeat the process each time for every address in the spreadsheet.

Convert .xls Database To Posts In WordPress Geo Places

December 14th, 2011 Comments off

Here I send you a sample of the database that I’d like to be compatible with wordpress Geo Space. I need every company to be a separate post, categorized by city. Here, take a look at the template http://templatic.com/demos/?theme=geoplaces3 I’ll give you an access to all the files and databases, so you could do the work.

Data Entry 5 Website

November 29th, 2011 Comments off

Need data entry for 5 website
from xls to entry to create the product

xls is the listing of the product
you need to create one by one and upload the image
image will be provided

please bid for all 5
each xls range from 1000 to 2000 product

Create Progress Bar In Microsoft Access -importing Xls Sheet

November 10th, 2011 Comments off

Hello,
am attaching ‘testimport.mdb’ ( microsoft access database)
and ‘ExcelSheet1.xls’-
as long as these two are in the same folder-
open database- click import button on form and browse to the ExcelSheet1.xls- it will import the data in.
question:
I also have attached ProgressMeter.mdb ( microsoft access database)
if you open it and look at form ‘frmShowProgress) enter 1000 iterations.
1. I want to have a progress bar display like this in TestImport.mdb when importing the data from ‘ExcelSheet1.xls’
( and be able to understand code)
2. is it possible to create another form? or in the form? that would let user change the values of B1 and F11- if ExcelSheet had different number of records to import??
thank you

Data Entry To Xls Or Doc

October 3rd, 2011 Comments off

The data is of wards and citizens working in our company,
Most of the data is in jpg and tif images,
we need them to be entered in Excel Document or Word Document,
which ever is convenient.
Please see the images sample given below , if you are capable of extracting

data,with 100% accuracy.

http://j.gs/184187/govt-ward-pop-pg2
http://j.gs/184187/govt-ward-pop-pg8

Other Images will be provided afterwards.

List Of Exhibitors With Contact Details Into A Xls Please

September 26th, 2011 Comments off

There is an Investor Exhibition and an Overseas Property Exhibition and we would like all the exhibitors in an XLS document, Name, tel # website, email address (essential) and a couple of lines of text ref what they do as well, attention to detail imperative

Simple Data Entry From Images To Excel Spreadsheet.

September 24th, 2011 Comments off

I have around 51 images like this one :
http://q.gs/184187/datasample1

I want to get them into xls file. If anybody can do it with 100% accuracy then I can hire him/her.

Budget around 350$.

Automated Blog Posting From Excel File (csv Or Xls)

September 21st, 2011 Comments off

Step1: create blog

Step2: auto post:
i have a file with information on different products.
i want to create a setup where it will auto post a blog post on each product based on the information in the excel file (xls or csv)

Step3:i want to be able to control the time interval of each post (1 post every minute, or every hour, etc…)

Crawl Scrape 20000 Record From Flash Into Xls

September 12th, 2011 Comments off

Hello, this project will pay $100 – $150 USD

We are looking for someone who can crawl the following:

1. Go here http://www.expocad.com/host/fx/convexx/sema11/default.html
2. Click this in red headline on right, Click here to view complete exhibitor list.
3. Very first business is 2.95 guys. IF you see it will go to a flash map of the show. I need the data for each company, about 20000 plus records in xls column format by company name, street address, city, state, zip, phone, contact name, email (if available) and web address.
4. For example, first record would read like 2.95 guys 13750 Stowe Dr.
Poway, CA, USA 92064 http://www.295guys.com 800536-5959 sales@295guys.com Lance Beesley

Thank you and please do not bid unless you really look at what is being asked of you. We have had to scraping companies win this bid previously, and both bailed out after they realized they could not provide the data. Do not waste either of our time. Check and see if you are capable to provide this data, and accurately. Thank you

Ms Vba Auto Send Word And Excel

August 22nd, 2011 Comments off

Worksheet in MS Excel

What is already working (Outlook 2007):

Instalation Of Themes Magento In Dominios (magentos.xls)

August 3rd, 2011 Comments off

Programmer Wanted for the installation of ten templates Magento. For immediate start is required programmer for the installation of 10 ecommerce templates (magenta). Interested parties can respond to this message. The budget we have to do the job is 30USD

Vba Or Buttons In An Excel File For Auto-counting

August 2nd, 2011 Comments off

Hello all,

I’m looking for a simple solution in an excel file to add buttons wich auto increment the value of a field by +1
This is to keep scores of a soccer game.

I need to have a button for every player in my team.
When he scores a goal. I want to push the button next to the players name. and see the scores in each column.
So per user I need a button wich auto increments the value of the field by 1

I’ll send the xls file in attachment so you can see the lay-out of the xls file.

Ms Vba Auto Send Word And Excel

July 31st, 2011 Comments off

Worksheet in MS Excel

What is already working (Outlook 2007):

Crawl . Scrape And Input Data Into Xls 2

July 20th, 2011 Comments off

Hello, this project should be around $50 or less in USD, We are looking for someone who can crawl the following:
1. http://www.aapexshow.com/aapex2011/public/exhibitorlist.aspx?aeid=10&ID=2434&sortMenu=105002 all pages
2. http://www.asashop.org/ a – w in each of these you need to go down a level to extract data.
3. https://tcms.aftermarket.org/personifyebusiness/MemberDirectory/tabid/143/Default.aspx each of the 9 codes (ie AEA)

I would like the data in xls column format by company name, street address, city, state, zip, phone, contact name, email (if available) and web address.

Thank you

I Need 105 Social Bookmarkings Needed

July 20th, 2011 Comments off

Hi guys. I need 105 social bookmarkings as follows:

SB_1.xls – 30 more SBs
SB_2.xls – 25 more SBs
SB_3.xls – 50 more SBs

I am attaching you the files that need to be updated with the social bookmarkings (in the same format they are now). You just need to continue them and add the needed number of SBs. You will use your own websites, making sure they are not already in my files.

Bids with low cost & fast timeline will win. I will probably need way more SBs, so the winner has the chance to work with me again.

Ge-excel Data Copy Data Worksheet To Worksheet

July 9th, 2011 Comments off

Should be a pretty straight forward job and should not take longer than an hour.
Needs to be done by Sunday,afternoon(pst)
{Thus, I am not going to have time to ask question about pricing. Give me one low price. I will pick programmer in the morning, about 12 hours.)

Detailed information is in the pdf,
but in short–
User enter product numbers–eg. 5225-5222
Take information from one excel sheet and put in to a New excel sheet. Rename xls as: Template to Date_Amazon_Upload.xls, eg. 01_01_2011_Amazon_Upload.xls.

I prefer this to be done with C# or Excel(VB)

Below are 3 attachment–The PDF, Front End Program–Describing Project, and 2 XLS files–1st is Data, Master_Product_List.xls
2nd is Template, Amazon_Template_File.xls

Crawl . Scrape And Input Data Into Xls

July 1st, 2011 Comments off

Hello, this project should be around $50 or less in USD, We are looking for someone who can crawl the following:
1. http://www.aapexshow.com/aapex2011/public/exhibitorlist.aspx?aeid=10&ID=2434&sortMenu=105002 all pages
2. http://www.asashop.org/ a – w in each of these you need to go down a level to extract data.
3. https://tcms.aftermarket.org/personifyebusiness/MemberDirectory/tabid/143/Default.aspx each of the 9 codes (ie AEA)

I would like the data in xls column format by company name, street address, city, state, zip, phone, contact name, email (if available) and web address.

Thank you

Crawl And Input Into Xls

June 12th, 2011 Comments off

Hello, looking for someone who can crawl the following:
1. http://www.aapexshow.com/aapex2011/public/exhibitorlist.aspx?aeid=10&ID=2434&sortMenu=105002 all pages
2. http://www.aapexshow.com/aapex2011/public/exhibitorsearch.aspx?aeid=10&ID=2435&sortMenu=105001 all pages
3. http://irce.internetretailer.com/2011/speakers/
4. http://irce.internetretailer.com/2011/exhibits/ A-Z and 0-9 at bottom of page

I would like the data in xls column format by company name, street address, city, state, zip, phone, contact name web address.

Thank you

Categories: .NET, ASP, ASP.NET, Crawler Tags: , , , , , ,

Crawler Into Xls

June 11th, 2011 Comments off

Hello, looking for someone who can crawl the following:
1. http://www.aapexshow.com/aapex2011/public/exhibitorlist.aspx?aeid=10&ID=2434&sortMenu=105002 all pages
2. http://www.aapexshow.com/aapex2011/public/exhibitorsearch.aspx?aeid=10&ID=2435&sortMenu=105001 all pages
3. http://irce.internetretailer.com/2011/speakers/
4. http://irce.internetretailer.com/2011/exhibits/ A-Z and 0-9 at bottom of page

I would like the data in XLS column format by company name, street address, city, state, zip, phone, contact name web address.

Thank you

Xls To Xml Converter

June 1st, 2011 Comments off

I have the following files (also attached):

1) XLS file that holds data
2) XML file as a schema/XML Map

I need someone to develop a simple bit of software/script that will allow me to convert the XLS data into the format of the XML map. The XML map is too complicated for MS Excel to export.

Can anyone help?

Kind regards,

Tom

Compare 2 Lists And Copy Row

May 30th, 2011 Comments off

The environment as follows:

I have 2 workbooks – MasterData.xls and InData.xls

MasterData.xls has columns – Product Barcode, Product Description, Attributes1, Attributes2, Attributes3, Attributes4, Attributes5, Attributes6, Quantity

InData.xls has columns – Orderid, Product Description, Attributes1, Attributes2, Attributes3, Attributes4, Attributes5, Attributes6, Quantity, CustName, address1,address2, Postcode, country

The problem as follows

1. We get the InData.xls from customers without the Product Barcode
2. We need to match InData.xls to MasterData.xls for the Product Description, Attributes1, Attributes2, Attributes3, Attributes4, Attributes5, Attributes6, and if all columns match, copy the Product Barcode on the same row in a new workbook

i.e. MasterData.xls compare to InData.xls

If Product Description = Product Description then if Attributes1=Attributes1 then if Attributes2=Attributes2 if Attributes3=Attributes3 if Attributes4=Attributes4 then if Attributes5=Attributes5 then if Attributes6=Attributes6 then

copy Product id + Product description + Attributes1 + Attributes2+attributes3+attributes4+attributes5+attributes6 to a new workbook.

If there is no match, then an error message is written to the new workbook (same row as per InData.xls)

If there is a match up to Attributes 2 and attributes3 and attributes4 and attributes5 and attributes6, copy Product Barcode + whole row to the new workbook

The MasterData.xls is sorted by Product Description
The InData.xls is unsorted i.e. sequential orders received

I want

a) to Compare the 2 lists with multiple columns and copy rows to a 3rd List
b) Add more columns if necessary

Data Extractor From .pdf .doc .xls Files

May 10th, 2011 Comments off

I need an aplication to extract data from pdf,doc, and xls files automatically. The data to be searched are provided from a database such as: name, lastname, etc. If the data from the database of one or more criteria matched then a listing of the name of the file and the data found will be generated. Administrators backoffice and client users panels will be needed. More details by pm.

Categories: Conversion, Data, Excel, PDF Tags: , , , , , ,

Script Modification Download

May 2nd, 2011 Comments off

Dear Scriptlance,

I have a Excel document that I want people to download off my website.

However at the moment if someone downloads the file; the file name remains the same.

What I want is a form that a user will have to complete which contains

Title: [dropdown]
Name: [textbox]
Company Name: [textbox]/[optional]
Contact Email Address: [textbox]
Confirm Email Address: [textbox]

With validation on all entries.

Then when all information is entered the excel file is renamed in the following way.

ID-NAME-COMPANYNAME.xls

For example:

1-JOHNSMITH-COCACOLA.xls
2-ADAMDELLER-HARIBO.xls

Will need this done within 24 hours.

Please demonstrate that you understand the project in PMB and provide a fairly cheap quote for the work.

I do not want to be spammed.

Thanks,
Jamie

Excel Vba Macro To Import And Convert Xls

April 26th, 2011 Comments off

We are company that processes CDR reports from stores. We receive reports from various stores. Each of these contains a series of records detailing the amount of sales that store has made within a period. Each of the online stores sends us their reports in a different format, we call these

File List Needed To Txt Or Xls

April 15th, 2011 Comments off

I need a list of all files on a Unix website (all directories and subdirectories) in either text or xls format, it doesn’t matter.

If you’re a programmer you can probably write a script or use a tool like webglimpse dot net.

Of course I need it as soon as possible. PMB if questions.

Thanks for reading!

Categories: Programming, Script, UNIX Tags: , , , , , ,

Import Xls Data To Derby

April 10th, 2011 Comments off

I have a javadb derby database. I need to re populate the data without changing the structure of the tables. The triggers, constraints remain untouched.
i will provide xlsx files with new data, need to truncate old tables and add new data.
need to change some tables collation

a very easy job for a java programmer

Data Matching

March 2nd, 2010 Comments off

Hello,

I have 10 XLS similar to the one attached. On each XLS, Column B lists a ‘Specialty’ and Column K lists several “Specialty Expertises’. There should be about 30-40 ‘Specialties’ in total across all the 50 XLS that I have. I would like to create a complete list of unique ‘Specialty Expertises’ that goes w/ each ‘Specialty’.

Please let me know if you can help!

Best,
Phaedra

Xls Product Catalog Data Merge

February 3rd, 2010 Comments off

Greetings,

We need you to merge data between very large data sets spread across 3 Excel files into 2 files.

This will involve finding, sorting, selecting, etc. specific data (rows/columns) from each source.

We have an order of operations defined, but you may prefer to use your own data-merging script to get the job done.

2 of these files contain manufacturer catalog data and the 3rd file contains our own classification codes for each of the catalog data entries.

Please contact us with any questions.

We look forward to working with you!

Xls To Html 2

January 18th, 2010 Comments off

We have an xls file with some product data (column 1 has the product title, column 2 has product picture, column 3 product description and column 4 product price) – we need an automated way to put this products on a html page (with some styling if possible)

I seen this done with an xml of some sort, but i’m not sure.

Needs to be done fast, 3-4 days.

Categories: Java, PHP, Programming, XHTML, XML Tags: , , , ,

Xls To Html

January 7th, 2010 Comments off

We have an xls file with some product data (column 1 has the product title, column 2 has product picture, column 3 product description and column 4 product price) – we need an automated way to put this products on a html page (with some styling if possible)

I seen this done with an xml of some sort, but i’m not sure.

Needs to be done fast, 3-4 days.

Excel To Html Form 2

December 17th, 2009 Comments off

I have an xls spreadsheet that I would like turned into an html page.

It needs to have the following:
- All the functions/formulas of the xls file
- Fit within a 1024 wide screen
- Have a print button that fits on 8.5″ wide paper when printed
- It needs to be able to send to multiple email accounts
- It will be secured by SSL when done. Needs to work with SSL.
- Submit to email
- Emailed form must look just like form when printed (not xml or list)
— If you feel this should best be accomplished with a database.
I can provide db access. If so, Please note that in your bid.

I will provided ftp access with original xls file.

Here is what it will look like and how it will work.
conceptinet dot com / test / otms.html

Categories: Programming Tags: , , , , ,

WordPress Plugin Load Xls

December 9th, 2009 Comments off

I have some data in a excel file. They are imported from a mdb database. Theese data show results of local sport.

I need to easily import this table into wordpress, like a word document. So, I need a plugin that could upload xls file and display it into a post with the same property/columns of the file (like name, rank, score, etc.)

Compatible with last wordpress version (2.8.x)

Maybe I could show an example in next hours. Need a bid urgently, thanks

French Clients Database & Xls

December 3rd, 2009 Comments off

Part I:
I have around 50 one-page A5 contracts with clients from France. All is in FRENCH. I have a database system that contains these clients already, however, they must be corrected in their data such as addresses etc. Takes around 50 x 3 minutes.

Part II:
Control all entries online and make a print-out into a pdf file of each. Takes (after installation of pdf printer driver) around 50 x 2 minutes.

Part III:
I need a list of the 50 clients in an XLS file including their company name, address, zip, city and a date of each. Takes 50 x 5 minutes

Requirements: The person to work on this MUST speak French and be able to read fax quality papers in French.
Person must correspond with us in ENGLISH.

Deadline: After the person to work on this received everything 4 days.

Please: This time only honest people who REALLY know French and UNDERSTAND the project. Thank you!

Data Entry To Db From Xls File

November 24th, 2009 Comments off

We have an excel file of 336 members datas that need to be updated to our site.
Most of the infos have been added already.
The job will be to compare each member data on the site and in the excel file and update if necessary.
Let me know if you have any questions

French Clients Database & Xls

November 22nd, 2009 Comments off

Part I:
I have around 50 one-page A5 contracts with clients from France. All is in FRENCH. I have a database system that contains these clients already, however, they must be corrected in their data such as addresses etc. Takes around 50 x 3 minutes.

Part II:
Control all entries online and make a print-out into a pdf file of each. Takes (after installation of pdf printer driver) around 50 x 2 minutes.

Part III:
I need a list of the 50 clients in an XLS file including their company name, address, zip, city and a date of each. Takes 50 x 5 minutes

Requirements: The person to work on this MUST speak French and be able to read fax quality papers in French.
Person must correspond with us in ENGLISH.

Deadline: After the person to work on this received everything 4 days.

Xls To Php Script

November 19th, 2009 Comments off

I have an excel file that makes maybe 10 – 20 calculations and gives a few (less than 10) output points. What I am looking for is a php script that will 1. do the calculations. 2. put the calculations in on display on a webpage.

Should be easy for the right programmer. questions please through PMB. Don’t bid if you don’t have feedback please.

Excel To Html Form

November 17th, 2009 Comments off

I have an xls spreadsheet that I would like turned into an html page.

It needs to have the following:
- All the functions/formulas of the xls file
- Fit within a 1024 wide screen
- Have a print button that fits on 8.5″ wide paper when printed
- It needs to be able to send to multiple email accounts
- It will be secured by SSL when done. Needs to work with SSL.
- Submit to email
- Emailed form must look just like form when printed (not xml or list)
— If you feel this should best be accomplished with a database.
I can provide db access. If so, Please note that in your bid.

I will provided ftp access with original xls file.

Here is what it will look like and how it will work.
conceptinet dot com / test / otms.html

Scrape List To Xls/csv

November 7th, 2009 Comments off

This is a project to scrape a list of name/address/phone numbers from a national (United States) list of dentist. There are more than 200,000 dentists.

There are two ways to see the data. You can go into the 51 states (50 + District of Columbia), or you can recursively go into each ZIP code (there are 40,000+ zip codes in the U.S., and I can send you a list of them.

The data can be found at this URL:
1) Go to http://www.ada.org/public/directory/index.asp
2) If asked to sign in, sign in as a member of the PUBLIC
3) In the first drop-down pick list, choose “All types of Dentistry”
4) Pick a STATE & press the search button to see how the data looks

I need to have this data, in an Excel spreadsheet (xls or csv):
-Name (1 field, you don’t need to parse it)
-Active or Retired (or you only grab the Active ones, which is all I want)
-Type of Practice
-Street Address
-City
-State
-ZIP
-Phone
(Not all entries have data in every field)

Please only bid on this job if you have had previous experience with scraping jobs, and tell me about it in your bid.

FYI, I have a perfect 10 rating on over 50 jobs, communicate well, will put the full fee in escrow when you accept the job, and I always give my programmers a 10 rating at the end.

Scrape Small List To Xls/csv

November 6th, 2009 Comments off

There is a very small list (about 400) of hospitals at this URL:
http://www.carelookup.com/long-term-acute-care-hospital-directory/providers.aspx

I need someone to take this information & put it into a CSV or XLS file:
-Hospital Name
-Hospital Type
-Street Address
-City
-State
-Zip
-Phone
-Fax
-Contact

You will need to go one level deep to get the phone, fax and contact.

FYI, I have a 10 rating on well over 50 jobs, communicate well, will put the $ in escrow for this job, and I always give me programmers back a 10 rating.

Bear