Archive

Posts Tagged ‘csv file’

Script To Import A Csv File Into Fb Notes

January 3rd, 2012 Comments off

I need a simple script that will allow me to take a CSV file of data and post it into my facebook page notes section automatically without the need to enter each note by hand. The script should allow me to import note title, content and tags from the CSV file right into facebook. Should be a very easy task for a good programmer :)

Edit A Csv File On Download Php Or Cgi 2

December 8th, 2011 Comments off

I want a script that will edit a .csv file on server before download.

I have a .csv that I want a user to be able to download with their own affiliate ID.

.csv file is on the server with wildcard **affid** contained within a number of text fields. When user enters their affiliate ID in form and clicks download button, the .csv file will open download window to be saved on their desktop with the **affid** being replaced with their number.

Please comment that this can be done with PHP …

Categories: Editing Tags: , , , , , ,

Edit A Csv File On Download Php Or Cgi

December 4th, 2011 Comments off

I want a script that will edit a .csv file on server before download.

I have a .csv that I want a user to be able to download with their own affiliate ID.

.csv file is on the server with wildcard **affid** contained within a number of text fields. When user enters their affiliate ID in form and clicks download button, the .csv file will open download window to be saved on their desktop with the **affid** being replaced with their number.

Please comment that this can be done with PHP …

Categories: Editing Tags: , , , , , ,

Xml File Conversion To Csv File 2

November 28th, 2011 Comments off

We have a file in XML format that needs to be converted to CSV format.
See attached XML file for your reference. If you still need more info, do not hesitate to ask.

Convert Xml To .csv File

November 28th, 2011 Comments off

We have a file in XML format that needs to be converted to CSV format.
See attached XML file for your reference. If you still need more info, do not hesitate to ask.

Xml File Conversion To Csv File

November 14th, 2011 Comments off

We have a file in XML format that needs to be converted to CSV format.
See attached XML file for your reference. If you still need more info, do not hesitate to ask.

Virtuemart Automatically Import Csv File From Ftp

October 12th, 2011 Comments off

I want to import a CSV file into Virtuemart from a wholesaler. I need some sort of way for this to import this file multiple times per day so it can update my site’s inventories.

Please send me a message indicating how you plan to automate the process. I want this to be 100% automated. Make sure to make this detailed.

Thanks,

Ben

Import Csv File To Site

October 5th, 2011 Comments off

Hello freelancers,

I am new here and I see you make good job.

I want someone to add to my website some csv files.

Thank you,
Nikos

Csv File

September 23rd, 2011 Comments off

I have a csv file of email addresses that I want to upload to iContact.
It has a header row with various fields. The only fields I need are firstname and email address.
My problem is that all the fields are squashed into column A.
I need someone to amend the file so the field are in separate columns!
[fname] and [email]

Categories: CSV Tags: , , , ,

Php – Mysql To Csv To Zipped

June 24th, 2011 Comments off

I have a script that makes a mysql query and puts the results into a csv file. Except I know want to have the csv file zipped.

Currently, when the visitor calls the file by link my script generates the csv file. I want to be able to add a parameter to the link like “zipfile=yes” and have the output be zipped.

Needs to be clean, simple and fast.

Please PM Questions.

Categories: CSV, MySQL, PHP Tags: , , , , , ,

Create Csv File From Gmail

May 30th, 2011 Comments off

I have about 2900 emails in my gmail account that I need exported to a csv file so I can have the user email and message in separate columns.

$7 for the job.

Export Emails From Gmail To Csv File

May 30th, 2011 Comments off

I need someone to login to my gmail account and export all the messages in a CSV file where I will be able to see the user email address and message in separate fields.

$10 for the job.

Categories: CSV, Gmail Tags: , , , , , ,

Application To Parse And Add Csv File To Database

April 30th, 2011 Comments off

I need an email to be checked daily by the code you write. In this email will be a link. The application needs to go to the link and log-in using the username/password.

A CSV file will be downloaded and needs to be imported into an existing MySQL database.

Php Coded Csv File Comparision Project

April 15th, 2011 Comments off

I have a website that i upload csv files to. The project is to compare the current csv file with an updated csv file. just to insure that the data is not doubled and that all new changes are made.

example current csv file “wheel,12345,45,120,25,100″
Updated csv file “wheel,12345,23,120,25,100″

the first 2x feilds are NEVER changed but the last 4 fields can be changed

I would like this to be in a php format so that the work is done online

Categories: CSV, PHP Tags: , , , , , ,

Create A Form To Csv File

February 17th, 2010 Comments off

I need a php form where people type in their First name, Surname, Mobile Phone Number then the form adds this data to a CSV file that the form owner can download and export. The form should have a code that can be pasted in any html or php page.

Repeating Page Scaper C#

February 5th, 2010 Comments off

Application that:
1. Minimizes to icon in toolbar and can start as a service (provide instructions for install in windows 2008 or help me do it)
2. Checks 4 identical one line web pages to parse out a simple value every 10 minutes (will supply details later), repeats 3 times for failure.
3. Records attempt to retrieve page, success or failure, file timestamps, value, time of attempt, and other stuff you want to add
4. Stores given data in an mdb and csv file (one csv file per day)
5. Has error prevention to allow for failed http requests, internet downtime, database issues, csv file issues, etc.)

General Requirements
C# .net application
Loads and compiles in VS 2005
Run for 6 hrs to test and provide data stored in mdb and csv for validation
Full source provided to me as my property

Need Csv File From Site

January 27th, 2010 Comments off

I am looking for someone who can create an excel/CSV file from the lists of each state on this website:

http://www.uttermost.com/store_locator.aspx

I need the name, address, city, state, zip code, and telephone number in separate columns for excel.

There will probably be 10 other sites similar to this one that I would like done also, but please bid on just the above one for now.

Adapt Csv File

January 17th, 2010 Comments off

Hi,

The main job of this project is the adaptation of the csv file to be automatically imported to our store every x hours.

The program must perform 3 functions for this:

- Adapt a csv file that one of our supplier give us.

- Find and download some information of our products to be completed the second list that other provider give us.

- Build the final csv file with these two parts, having previously defined the selection of products and prices to be exhibited permanently in the store.

Please note: We need to contact only with professionals with proven experience in this type of work. All aditional details will be provided privately.

Thanks!

Sort Through A .csv File Excel

January 5th, 2010 Comments off

I have a list of about 50 excel files. I need someone who can sort through them and find a few specific companies. It’s just a matter of doing a ctrl find on each one, and gathering the information to create a new database. A few of the .csv files have over 100,000 records so you need the right computer program to open them. ie: they won’t all open in openoffice for example. But maybe you have some other way of doing it. Complete instructions to follow. It should only take about an hour to do.

Compare Two Csv Files

December 3rd, 2009 Comments off

I need a fast tool that will tell me the difference between 2 csv files and output a new csv file of those items.

Every hour I recieve a CSV file from my wholesalers that could contain new products within it but I have no way of knowing…

In simple terms I would like to run a .exe program that can compare the old csv file to the new one and exort a new csv file with only the new products contained in it…This is so I can build the product description for these products and add them to the website…

Thanks.

Andrew

Link Access Database/csv File

October 23rd, 2009 Comments off

Need a programmer that can associate the form fields in a simple Access database form to a linked CSV file.

Special Notes:

Amenities Checkboxes: all selections need to output to same cell with field name and semi colon separation (see entries table for example).

Categories Listbox: all selections need to output to same cell with field name and bar separation (see entries table for example).

CSV file must remain a CSV file.

Export Excel Csv File Utf-8

October 22nd, 2009 Comments off

I have a csv file being exported in JIS only from PHP
in my Zen Cart Japanese.

I need a way to export it in Excel format.

I found PHPExcel but not sure how to use it.

I have control of my own server.

Regards

Categories: MySQL, PHP Tags: , , , , , ,

Convert Csv File

September 20th, 2009 Comments off

Convert csv file
I have a csv file, for example.
Category,Company Name,Address,Country,Phone Contacts,Fax Numbers,Web Sites,Email Addresses,Contact Names and Positions,Description,Products and Servcies,Type of Business,Years in Business,Employees,Income

i need this file in this format.
Category,Company Name,Address,Country,Phone Contacts,Fax Numbers,Web Sites,Email Addresses,Zipcode,Cityname,Contact Names and Positions,Description,Products and Servcies,Type of Business,Years in Business,Employees,Income

The file has 50000 rows

Strip Info Out Of Csv File

September 9th, 2009 Comments off

We have a csv file from one of our suppliers, but in the description field it has html for a table that has extra product information.

We want the information from this table stripped out and put into a new csv file, so the new csv file will contain the model number, product name and then the seperate table information, like size, washing instructions, colour, brand

We have attached the sample of csv

Modify Csv File For Ecommerce

September 6th, 2009 Comments off

I need two fields fixed on a csv file with all the prices “you could just use a script and modify by percent” and one with all the item numbers “currently there are words and item numbers in the same box I just want to have the numbers only. There are 1300 items

Ie Launcher And Tracker App

August 20th, 2009 Comments off

I’m in need of a simple windows program. Could be written in C or it could be .net or VB. I’m not worried as long as it works.

This program needs to read a URL or a keyword from a CSV file and navigate internet explorer to either the URL or a google search of the keyword. Then the program must record any and all popup ads that occur. These won’t be popups launched from the browser, but popups/unders launched by a third party adware product. Multiple products will be tested on various machines, so the script should just detect a new browser window opening and grab the final URL (not the refresh but the final destination URL) of the popup/under ad and record it in a CSV with the Date and Time the popup occured.

The the program grabs the next URL/keyword from the list and starts the process again.

If the URL/Keyword input starts with an http:// then it should be treated as a URL, otherwise treat it as a keyword.

This program must utilize internet explorer and record the data it collects in a CSV file. It must work with Windows XP and Vista

Additionally, this program will need to grab a screenshot of the popup that appears, save it and record the filename of that screencap in the output csv file.

The program should run continuously 24 hours a day 7 days a week for atleast a month at a time.

Data Manipulation Application

July 28th, 2009 Comments off

I need a simple data manipulation application programmed. It can be programmed in PHP and run from the web (preferred) or it can be a desktop application.

If you know how to work with text files and CSV files then you should be able to do this project. Here is a description of the project:

The application interface will have the following input fields:

A.) Master text file:________ browse button
B.) Word in master text file to replace __________
C.) CSV data file:_________ browse button
D.) Folder to save output text files______ browse button

Detailed description of input fields:

A.) The master text file will be a text file with content in it. There will be a browse button to select this file on the users desktop.
B.) This will be a simple text field where the user can enter a word. When the script is run (detailed below) the word entered here will be replaced with the word in the CSV file.
C.) The CSV will have two columns. The first column will have the word that will replace the word listed in B.). The second column will have the name of the text file that the output should be saved to.
D.) This is the folder where the output will be saved to in the form of a text file. The name of the text file that the output should be saved to is described in the second column of the CSV file.

The Process of the Script:

1.) Look at row 1 and column 1 of the CSV data file
2.) Create a text file in the folder that was browsed in D.) above with the name specified in column 2 of the CSV data file
3.) Import the master text file to the text file
4.) Replace all instances of the word specified in B.) above with the word in column 1 of the CSV data file
5.) Repeat the process going to row 2 of the CSV data file
6.) Loop through all rows of the CSV data file

NOTE: If column 2 of the CSV file has the same name as a previous row (the text file already exists) then the script should append the new text output to the file.

If you can make this simple script for me, please send me a PM and let me know if you are going to make it as a PHP script or as a desktop application.

I’m looking forward to working with the winning bidder.

Search Csv File For A String..

July 25th, 2009 Comments off

I need a small script that will search a csv file for a string. Of course, I should be able to set the string in your snippet. For this example, the variable is called string ($string) and its value is predetermined by another script, but will not affect your part in this project. You will not need to see my script/code/form/server/etc. You need to work with the information given in this project description and you can use test data that you make up on your own. If you really know how to do this, it shouldn’t be a problem.

The csv file has three columns: id, username, email
So, the file may look like this:
1 john johnATmail.com
2 bob bobATmail.com
3 jane janeATmail.com3
4 bob bobATmail.com

Your snippet will search the csv file for $string. Let’s say that $string has the value of “bob”. So, the script will search for “bob” and since there are two instances of “bob,” it will return each result, item 2 and item 4. I want the value of each column to be returned as the result. The results are not actually displayed on the screen. They are written to a database. So, the query will be a simple insert that has the date, the row id, the username, and the email address. So, for this example, two inserts should be done.

If you bid Immediate delivery, I will expect the script to be delivered within 20 minutes. Place the phrase not a bot in your bid, and in the PMB if you leave a message there. No portfolios, links to unrelated work, resumes, or statements in the PMB that you can do it. Escrow provided if requested in your bid. Don’t bid if you can’t do it in one hour. This needs to be done in PHP and needs to work on a shared server, where the user will more than likely not be able to access the php.ini file or will have to reinstall PHP to get your script to work.

Ideally, I’d like this to be done for $10, so lower bids have priority. Don’t overbid.

Thanks, and good luck.

Csv File From Info On A Site

July 8th, 2009 Comments off

I need information from a website.

The site is a directory-type site. It is run on wordpress and the directory listings are in each post. I want to have all the entries listed and parsed out to show me the following:

name
address
website
phone number

Data Fix Csv File Grep Date

June 19th, 2009 Comments off

You will take the attached csv file and set the second column “start_date” to whatever is available in the third column “notes” WHERE is says that the listing was activated on a given date you will use that date to fill in the second colum

Scrape Info Into .csv File

June 13th, 2009 Comments off

Whe are a dealer of a priver of dvd, cd and other media, but this company at this time only has a webshop from where whe can get all availible products, but is not able to provide a complete .csv file for us to use by uploading it to our website conaining these products.
Whe are looking for someone who is able to extract all information out of this website containing images, product titles and full description and offcource prices and place these into a common .csv file witch whe can use to upload directly into our webshop database so all availible products will be loaded into our webshop containing all information as on the original website incl. prices and information.

You need to have experiance with the .csv format used by all webshops.

Joomla Component Needed To Imp

June 5th, 2009 Comments off

Hi,

I would like a Joomla component that will import Amazon orders into Virtuemart Via CSV file.

Currently we are having to put all Amazon orders on to our virtuemart system manually one by one. Amazon will provide us will all the orders in a .csv file so what we want to do is go to the joomla component on the back end press browse and select the .csv file and that will populate the joomla/virtuemart database accordingly.

We are using joomla 1.0 and virtuemart version 1.0.10

However we would also like the script to work with the most recent versions of joomla and virtuemart as well. (can be separate components)

An example of the csv file can be given on request.

Migrate Xml + Mysql To Magento

May 18th, 2009 Comments off

Hi all excellent database experts!

1. I need to transfer my existing mysql Virtuemart database/ products
from specified categories to my new Magento setup.

2. Also, I need to import an XML-file into Magento.

3. I am wondering how I can get my CSV-file imported every day into magento, the existing SKU

WordPress Niche Review Website

May 6th, 2009 Comments off

– need to modify the design of an existing word press blog to make it more user friendly with a sleek attractive design, which includes a list plugin to list entries. ‘Grunge wall theme’ is applied and should be modified/improved. Admin will update the site by uploading a csv file file of content entries. This csv file will be grown overtime and uploaded regularly via the ‘import csv plugin.’
(this plugin is installed) Readers should be able to add their own ratings, tags, comments, etc.

Design Modifications:
– need to modify the design of an existing word press blog, which includes a list plugin to list entries.

Problems that need to be fixed:
(1) Updating plugins via control panel result in erros: Warning: touch() [function.touch]: Unable to create file D:Hosting3466573html/wp-content/1241589797 because Permission denied in D:Hosting3466573htmlwp-adminincludesfile.php on line 95
(2) This should be the default home page: http://thebestkink.com/index.php/bdsm-videos/
(3) Make current default page the ‘recent updates’ page
(4) The title header should be designed to be better than just the current black font. (how about some affect that looks like ‘the best kink’ is burned into the metallic surgace?)
(5) user should be able to rate a listing with stars, add comments, and tag the listing.

* Theme / template Modifications:
***Blog Posting
(1)A REALLY NICE DEISGN should be formatted to include several elements from the CSV download file, including: the ‘post’ field, the ‘description’ field.The pricing fields, tags, etc.
(2) The format of this page should inlcude:
A) Title field – (hopefully in an H1 tag) this is the first field ion the csv file.
B) post – this will be ageneral description o fhte site or entity, website, store, or club. this should be on the top of the blog post deisgn
C) review – this pulls from the ‘description’ field int he csv file
D) link: ‘visit this website’ use this field for the link: aff_primary_link
E) Number of Comments,
F) average ranking of comments
G) Tags,
H) Posted in section
I) 3 Images inegrated into the design. each iamge is pulled from the csv file, which has 3 fields for location of the images (urls) [pic2, pic3, pic4]

** AZ Indexes (full director page should be default home page) and should be modified:
1) so that there are ony one column of list, and other fields from the CSV file should be used, including: images 93 per posting)
2) image location for a single thumbnail image of the screenshot of the website should be integrated into the lindex listing deisgn. [Pic1_index]
3) editors ranking
4) average comment ratings
5) Two links integrated into the list deisgn:
– 1 that link: ‘details’dives the user into the blog posting (whoich includes all details),
– and the 2nd link: ‘visit website’ should take the user into the new site via a new window – use this field: aff_primary_link

* TBK Data File
– Title – Name of entity being listed/ranked
– Post – html for ful post/rating entry
– tags
– timestamp
– category
– description
– keywords
– title
– exceprt_cf
– from_BD
– primary_link – link to website
– main_cost
– all_costs
– billers
– aff_program
– affiliate_program_link
– email
– TBK_x
– order
– last_upload_date
– last_edit_date
– notes
– rating

* Plugins Installed (8)
– All in One SEO Pack – 1.4.6.15 – Out-of-the-box SEO for your WordPress blog. By Michael Torbert.
– AZIndex 0.6.2 – A highly customizable and user friendly plugin to create one or more alphabetical indexes of selected posts in your WordPress blog. By

English Mike.
– Google Analytics for WordPress – 2.7 – add Google Analytics with extra search engines and automatic clickout and download tracking to your WordPress blog. By

Joost de Valk.
– Google XML Sitemaps 3.1.2 – This plugin will generate a sitemaps.org compatible sitemap of your WordPress blog which is supported by Ask.com, Google, MSN

Search and YAHOO. Configuration Page By Arne Brachhold.
– Import CSV 1.1 – Allows to import posts from .CSV file By Speedie COnsultants Limited.
– Link Exchange Manager – 1.4 – This plugin enables you to embed a link exchange directory right in the comfort of your own blog. Use this plugin to gain new

partner sites and to improve your overall backlink count. By eBrandMarketing.
– WP Review Site – 2.02 – Allows you to build a review site with WordPress by adding star ratings, affiliate marketing tools, and sidebar widgets. Use settings

menu to configure. By Dan Grossman.
– WPRS: My Ratings Addon

Repair Script – Ad Submission

May 1st, 2009 Comments off

The project described below the ****** was completed in 2008. Errors have started to occur recently in the script and must be fixed immediately. The form that is processed by the script is http://www.newburyportmothers.com/submission.php.

Briefly, when a form containing the ad data is submitted two emails should be generated. One email is sent to the email address entered on the form with only the data from the form. This email is OK.

A second email is sent to the site owner with an attachment. This email is not being generated. This project is to debug the script to fix this problem.

This project is urgent and needs to be completed by May 3. I will provide all server login info immediately upon accepting a bid.

Below are the original project requirements:

*******************************************************
GENERAL : We are developing a website for a social group that sells ads for its newsletter. After payment is approved, the ad data is submitted via a form to a mySQL database. The ad copy is an image file that may be submitted with the form to the server. Emails to the submitter and administrator are generated after form data are successfully received. To manage the data, an administrator page allows a standard data base report to be generated for a given month/year and a second report to be generated for a range of months/years.
The development project is in two parts. The workflow below is described to give programmers a better understanding of the project requirements.
Part 1 – AD SALES
The site owner will provide a draft of the ad submission page with the sales form. The programmer will modify the form as needed, create the mySQL data base, develop the data base queries and develop the email processing on the server to implement the features that follow.
1. To submit and pay for an ad the user navigates from other site pages to a landing page that displays Terms and Conditions and the user must select an “I Agree” checkbox to proceed to the submission page. The programmer will not work on this page. The user clicks Next to go the submission form. A validation check is performed on the checkbox to allow the submission page to open. Most of the data entries on the submission form will require validation before the data can be sent.
a. The submission form contains text boxes to enter the required business information. The form also contains selectors for the ad’s size and the starting date and frequency the ad will appear. The programmer will need to ensure that only allowed sizes and frequencies are chosen and that the member discount is applied for pricing of the ad.
b. The form will have a yes/no checkbox to either submit the ad copy with the form or to submit it at a later time. This yes/no data must also be passed to the database.
c. The ad is normally submitted as an attachment to the form. Ads are image files. The form will have a file selector to browse and attach the file from the local disk. The programmer will make this file selector inactive by default so that the user has to choose the yes/no option. When the yes option is selected, the file selector is activated and the user can navigate on the local disk to select the ad file. The file extension is checked to confirm it has an EPS, JPEG or PDF extension. If validation fails, an error box pops open and the form cannot be submitted until the error is corrected.
d. The user chooses the ad size from a drop down menu or radio button list on the form.
e. Ad frequencies include standard half-year (5 months) and full-year (10 month) blocks and single months. Each block or single month plan has a standard price for each ad size. For the half and full year blocks only, both consecutive and non-consecutive, multiple month blocks are a frequency option that the programmer will have to implement. Block prices will be discounted for group members so there will have to be a selector form Members (non-members will be the default).
f. A start month/year will be selected.
f. The existing form will have selectors for all of the above options, but the programmer may have to develop logic to calculate the final price of the ad. The programmer will develop logic to display the final cost of the ad. The cost display should update dynamically when the ad size and/or frequency or member/non-member status is changed.
g. The user clicks on the Pay button and is sent to Paypal with the cost data. The form data is NOT SAVED on the mySQL server UNTIL the payment in step 2 below is completed.
2. The Paypal page is pre-populated with the correct payment amount calculated on the form. After payment is completed the user is returned to the site for further processing of the ad submission.
3. The user is returned to a thank you page on the website. When the page opens the following takes place:
a. All form data are saved to a mySQL database at the web host and the attached image file (if sent) is saved to a folder on server.
b. The programmer creates a server-side script to generate two emails after the data are saved:
– A formatted thank you email is sent to the submitter showing the ad cost, size, frequency and months that the ad will be in the newsletter.
– A formatted notification email is sent to the site owner with all form data as text (field name: data), including the image file if sent.
Part 2 – REPORT GENERATION (programmer to design web page interface and all code):
1. The site administrator securely logs in to the report page.
2. On this page are 2 report generation forms.
a. General Historical Report – the administrator selects the range of month/year dates from a starting date – ending date menu and clicks on the Generate Historical Report button. An Excel style report page is generated that shows all fields for each record. The order of the columns is the same as the submission form. The administrator clicks on the Send Report button and the report is sent as a CSV file attached to an email to the administrator.

b. Monthly Report – This is a standard report for a selected month/year that is similar to the General Report but shows all ads that should run for the selected month (example: an advertiser places a 5 month ad for Jan-May. In March, the Report is run to see what ads should be included in the April newsletter, the administrator needs to see all ads that were submitted for print for that month, regardless of when the ad was originally submitted). The browser displays the report as rows of data with column headings. The administrator clicks on the Send Report button and the report data is sent to the site administrator as a CSV file attached to an email.

– Note: This a an revision of a project that was recently posted. To avoid confusion while the requirements were changing I decided to cancel and resubmit the project –

GENERAL : We are developing a website for a social group that sells ads for its newsletter. After payment is approved, the ad data is submitted via a form to a mySQL data base. The ad copy is an image file that may be submitted with the form to the server. Emails to the submitter and administrator are generated after form data are successfully received. To manage the data, an administrator page allows a standard data base report to be generated for a given month/year and a second report to be generated for a range of months/years.

The development project is in two parts. Here is the workflow we want to implement for both parts:

SALES { NOTE- A draft of the sales page form will be provided to the developer

Categories: mSQL, PHP Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Xml To Csv And Csv To Xml

April 28th, 2009 Comments off

We have a three part project.
1. Convert a large XML file to a csv file
2. Create a script that will convert a daily csv file into an xml file
3. Create a script that will take a daily xml file with inventory qty information and update the corresponding product code qty’s on a csv file.

Basically, we are an internet store with a new supplier who will only exchange data in xml, and our internet store only uploads and exports csv files. We need to get the new supplier’s inventory data converted into our csv file format so that we can upload it into our store. Then we need to take our store’s daily orders that we download in a csv format and convert the orders to xml so that we can upload them in a daily batch to our supplier. Lastly, we need to update inventory qty’s from the daily xml file we get from the supplier with our internet store. We are very adept with manipulating csv and Excel files – we just don’t know about xml files.

Csv File Extraction Auto Scrpt

April 19th, 2009 Comments off

I would like a script that will immediately send a new user a specific number of records from csv file: For example when I have new users sign up with me, I want them to receive Free leads (potential prospects) that I have in records of .csv file. I would a script to just distribute the file to my new members.

When bidding be sure to give me a way to contact via skype or yahoo instant messaging (my id for both skype and yahoo are: dgolden464

Dwayne

Access Csv File

April 5th, 2009 Comments off

Hello
I need a macro to read an Access table (format may vary) and from this you must create a CSV file.
Must be a VBA module in Access.
You must open the table, create the CSV file, save a copy in another table of records exported and the date of exportation.
This should be developed as a module in VBA (Access), and must be open for me to read/modify it.
I use Spanish version of Access, this can create a difference in the handling of dates and things like that …. The code must be in English.
Scrow payment.
Thanks

Bear