Get a Freelance Job

I need a php script made to create a list of delimited text. I’d prefer the script to be serverside. I want to access the script using a browser such as firefox.

The following variables [5] (that I will enter) are needed for the script:

1) name of 1st campaign (example – campaign_5)

2) name of last campaign (example – campaign_50)

The name of the campaign will be incremented by 1 for each line of text.

3) start date: 12/31/2011

4) start time: 1815

5) # of campaigns/15 mins: …

I have no idea how to do this so there isn’t any guidance I can provide, other than the result I want.

I need UPC numbers for 11,500 products, some of them common, most of them not. My source document is a tab delimited file that contains the manufacturer, the manufacturer’s part number, and the approximate street price of the item.

This file is in a tab delimited text format (see sample file attached).

Your finished product can be a similar tab delimited or csv file, or a mysql backup file. Something that I can parse to match the UPC number to the items in this file.

As many as 30-40% of the items on the list may not have a UPC number, but many will.

This is not a rush. Quality is more important to this project than speed.

Terms: SL escrow is required. If you don’t like to use SL escrow please do not bid. You can see from my feedback I am a reasonable buyer who pays a bonus for good work.

Please let me know if you have any questions.

I have 43 files in two different formats that have no tabs, only spaces separating data fields. They need to be converted to tab delimited text files with no spaces (except between words, of course).

It’s easy to distinguish the data fields (see attached files). They do NOT have to converted into a consistent format across all files. Just replace all the bloody spaces with tabs.

This is a good project for some who enjoys grep.

Sample files are attached.

SL escrow only please. If you don’t want to use it please do not bid. Also, check my feedback and you’ll see that I pay fast and include a bonus for good work.

Easy Populate Wishabi Addon

Easy Populate 2.76-MS2
Modify Easy Populate 2.76 MS2 to create a Wishabi datafeed (see sample excel file

Task 1 is to complete a web page where users define the layout of their data file. Data files are of type excel or text delimited. In general data files are flat tables.

Task 2 is to complete server side code for uploading and processing of the data file and layout. Processing is required to extract data and package it so it can be ingested by an extant web service.

Some existing code may be useful for task 2. Data file processing code exists. The code requires a layout file. A grammar of sorts describes layout files. At present layout files are generated by a technician upon examination of the contents of the data file. The code ingests the layout and data files, packages the data, and sends it to the web service.

Data files in general are flat files. However metadata is to be considered. E.g. the required column for WEIGHT can be qualified by metadata giving the units, e.g. kilograms; or the required column for WEIGHT can be qualified by a companion units column. (Units are defined by GnuUnits).

A number of test data files of various formats exist.

It is expected that this project will require two iterations. The first iteration has a short-term due-date. The second iteration will commence approximately 3 months later and will respond to additional user requirements and other issues.

Coding is to be done .NET C# using AJAX, JavaScript, etc.

I have a tab delimited flat file on a linux server….
the first line of the file is the column names ie (customer, address etc)
I need a script that will allow me to search (within a web browser)this file by 2 of its fields and write the results/matches to a comma delimited flat file that can be easily saved to the desktop …

On search field will be the company name and the other is going to be a date…. I would also like the date field to be searched with a span of time IE (from 11-20-2009 thru 11-29-2009)

The script should be self contained with a simple .html UI
with 2 fields to enter the sets of search terms…
I also want the option to change the 2 fields ‘searched’ from within the script as a variable.

I can provide a sample file if needed

We need help to complete a complex Perl script. Only experienced Perl coders need apply.
The script generates SQL statements in text files so a knowledge of SQL is also required.
** Payment will not be made unless the script works on our test system(s) **

The script takes pipe delimited text files & database table structure information and constructs tab delimited text files with a header row, suitable for load into external databases, reporting tools or excel.

The text files created are all exported from a proprietary database using a unix command line utility and are initially pipe delimited – without a header row – but converted by the script to have tabs and a header row. At the moment the script also dynamically creates a file describing the structure (google schema.ini files) of the tables.

The script is configured by an XML configuration file (parsed by XML::Parser). It exports the database tables listed in the XML file and places them in a directory on the server, shared by samba.

The script is well commented and around ~500 lines long and contains half a dozen subroutines.

Your task is to add routines to the script to achieve the following:
1. Generate SQL statements to create the tables in MySQL, PostgreSQL and Microsoft SQL Server 2005 and 2008 based on the database structure information.
2. Alter the tab delimited files record by record, field by field, so that the date and number formats match the format understood by the database (currently the tab files contain dates of DD-MMM-YY). Databases are VERY picky about dates, and seldom have any way of specifying the format of the incoming date during a bulk load. The conversion of the date fields must be achieved by using basic perl and not date/time libraries as the libraries available are inconsistent across operating systems.
3. Create the BULK LOAD statements to load the tab delimited text files from their textual form into the databases (Listed in point 1).
4. Its not possible to