Features needed: ability to access and update from anywhere (browser, telephone) with browser integration for autologin real time auto sync - auto save when exiting a field ability to give access to individual items or a group of items...autologin real time auto sync - auto save when exiting a field ability to give access to individual items or a group of items to certain people without giving them access to the entire system. a text field for notes - ideal would be ability to attach files **must** have ability to export to readable file that does not require proprietary software. this would be export to csv or tab delimited file preferable free or less than $10 per month for all users. In the message of your bid write" I want to work for you" with...
...some PDF files (see attached file) and some template Excel files. I need the statistics from the PDF file(s) entered into the Excel files. There are four groups of statistics per PDF, so there will be four Excel files created for each PDF file. The instructions, 4 template excel files, 4 completed excel files, and a sample PDF are included. Your job is to create 4 Excel files in CSV Comma Delimited format from each PDF file. I may award this to multiple users. I may have one worker complete only one excel file per PDF and then have 4 teams of workers, so each team only completed one set of statistics per PDF file. If you are interested, I will send you 1 additional PDF file so that you can complete it to prove that you understand the project. The accuracy is critical, so ...
Introduction --------------- I'm in need of two scripts that parse and mine raw data logs into a Microsoft SQL Server. Scenario ----------- A marketing company has a web service where their customers which are Canadian Universities access on a daily bases. The traffic generated at the web service produces raw logs in the following tabbed delimited format: Category Name (String) Entry Point (String) Traffic Date (Date) Customer ID (String) Traffic Count (Integer) Interface (String) A sample of two log records is as follows: CATEGORYA InterfaceM 2011-11-13 KEY001 4670115 [{"Name":"","Version":"1.6"},{"Name":"","Version":"1.8"}] CATEGORYA InterfaceQ 2011-11-13 KEY001 21588...
We have data in an Excel spreadsheet that needs re-organization for use in another program. Example: row contents moved to column headers, appending info into certain cells, removal of repetitive dates, user id's...that sort of thing. We need the current spreadsheet set up so that data can automatically be re structured and then we will output to comma delimited file. Can provide raw data, current spreadsheet, and sample output file. Use of VB or macros is fine as long as instructions are given so we can do it ourselves each month.
... and download the resulting csv file, the search volume data is presented as weekly. When you search on Google trends over a range of one month, it returns data in the resulting csv file as daily volume search data. I need the daily volume data, but over longer timeframes, hence the need for this script. The script will take as input several flags: -q ‘search terms'; This should allow the full functionality of the search options e.g. see -geo region (a two letter code which can be passed to the search url); “all” by default -s start date in format YYYY-MM; default value is 2004-1 -e end date in format YYYY-MM; default value is the most recent month -r the output data will be with fixed scaling by default; this ...
... and download the resulting csv file, the search volume data is presented as weekly. When you search on Google trends over a range of one month, it returns data in the resulting csv file as daily volume search data. I need the daily volume data, but over longer timeframes, hence the need for this script. The script will take as input several flags: -q ‘search terms’; This should allow the full functionality of the search options e.g. see -geo region (a two letter code which can be passed to the search url); “all” by default -s start date in format YYYY-MM; default value is 2004-1 -e end date in format YYYY-MM; default value is the most recent month -r the output data will be with fixed scaling by default; thi...
I need a simple desktop application for use on a windows xp/Vista/7 operating system.? I would like the user to click on an icon and a window opens with a simple user interface.? The user interface should have a button to input the file which will be a tab delimited file by opening a dialog box asking for the location of the file.? Another button on the user interface will be titled "Percentage" this button once clicked will allow the user to input a number from 0-100. The number input on this button will also be displayed somewhere on the user interface.? The input file will contain a list of addresses and a numerical value. ? The list may have up to 5,000 entries. The user interface should also display how many entries there are in the input file and also show how many e...
The project is to merge datasets. I have a master dataset of 50,000+ entities. This data includes business name, business address, longitude/latitude, etc. This is in text (tab delimited) format. Then, I have a file of about 10000 entries each that contain business name, address, longitude/latitude. The names and addresses will match but not always textually exactly. (For example, the address in one might say 5158 S Windsor Dr and the address in the other might say 5158 South Windsor Dr). Please specify how you would do this. By hand is one possibility, but you must have facility with US address/language conventions.
Looking for s...inventory Function inputs: product SKU, quantity to change (+1, -1, etc.) Function outputs: return status code from Amazon, quantity change in inventory Must include connect/disconnect from Amazon SCRIPT #2 ============ Retrieve Amazon buyer shipping/purchase info Function inputs: Order ID Function outputs: all product SKUs, shipping info (name, address, shipping type) in one comma-delimited string SCRIPT #3 ============ Update buyer shipping status Function inputs: Order ID, shipping type, tracking number Function outputs: return status code from Amazon, shipping status change in 'pending orders' list Milestone payments (1/3 each) provided for delivery of each script, after verified as working by us. See other similar job posting...
This project involves...the CMS will include: • Property descriptions, attributes, and amenities • Photos, virtual tours (links), videos (links) • Sales persons information This project will involve database design work, creating a data importer, and a property view. The solution should be developed using PHP/MySQL. It is preferred (but not required) that an open-sourced CMS such as Joomla, Drupal, or WordPress be used has as the foundation of the CMS. Custom form would need to be added for managing property information An importer would have to be built. The import file is a pipe delimited (|) containing property and sales person information. Field name, description, length will be provided. Photos are to be placed on web server. Properties ...
This is a fairly simple MYSQL/PHP project. It shouldn't take long at all for a good programmer. I will give you samples of the 1 tab delimited input file, 2 tab delimited output files, and the MySQL information. If you need them before you bid let me know. Chronjob at 1 min after hour, activates script which checks for new input files from previous hours in a directory If none, do nothing Script runs through file, generating a tab delimited file and uploading it to an FTP account, add the items at the end of another file in tab delimited format, and adds items to database. Delete file only after finished
This project is to copy numerous emails & names from 7 different websites that has list of emails & names. Each websites' emails & names must be organized in Excel & Comma delimited formats. List of website information is going to be provided. This project must be completed within 5 days from project start date.
The project involves writing a simple php script that can be executed on my webserver, and performs the following actions: 1. The script should be set to work using a request such as this: 2. It should then look for the term 'example123' in column 1 of a database (MySQL or tab-delimited csv - whichever is quicker / better / more reliable / safer). 3. It should get the values it found in column 2 and 3 of the database. 4. The values of column 2 and 3 should be inserted into a webform request template and the webform request should be executed. If a number of requests are made simultaneously, the script should still run quickly as usual. It should not have a long waiting time/processing time.
Hello, The project involves writing a simple php script that can be executed on my webserver, and performs the following actions: 1. The script should be set to work using a request such as this: 2. It should then look for the term 'example123' in column 1 of a database (MySQL or tab-delimited csv - whichever is quicker / better / more reliable / safer). 3. It should get the values it found in column 2 and 3 of the database. 4. The values of column 2 and 3 should be inserted into a webform request template and the webform request should be executed. If a number of requests are made simultaneously, the script should still run quickly as usual. It should not have a long waiting time/processing time. The script should be all finished and ready
...unique record yet can still know which lists/Groups each record was associated with originally. I will then use this data to upload into a new CMS I will be using for my business and I need to have accurate data and be able to associate each records with the list (Group) or lists (Groups) it was originally on. The records will be matched by a First Name and Last Name match and then I will give you a hierarchy to use indicating which list/Group will have it's data kept for the new merged Master List. All Group names will be consolidated into a single "Group" field for each record and contain all original Group names that matched by First Name and Last Name - comma delimited. You will send this list back to me in MS Excel. It is reall...
Need a program to upload tab delimited file to this table file will be uploaded daily. must check for duplicate sku and not insert if sku exists CREATE TABLE `AmazonASIN` ( `id` int(11) NOT NULL auto_increment, `sku` varchar(255) NOT NULL, `item_no` int(11) NOT NULL, `ASIN` varchar(255) NOT NULL, `price` double NOT NULL, `shipPrice` double NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
...editor. You will want to be careful that all data is separated, and that each data record is on a separate line in the text file. Reading the file and showing the data on a response page requires that you break apart or ‘explode’ each record in the file. Project You will create a Telephone Directory Application to save entries into a single text file. Your HTML form will collect the following data items: 1. Last Name 2. First Name 3. Street Address 4. City 5. State 6. Zip 7. Area code 8. Phone Number Your PHP program will take the data submitted by the form, using string functions assemble one record to be written to the file for each Telephone Directory entry that is submitted. The data will be written in a comm...
The project is to merge datasets. I have a master dataset of 5138 entities. This data includes business name, business address, longitude/latitude, etc. This is in text (tab delimited) format. Then, I have 51 files of 50-150 entries each that contain business name, address, longitude/latitude. These 51 files merged into one long file. I want the entity identifier from the master data set matched onto the entries on the second dataset. The names and addresses will match but not always textually exactly. (For example, the address in one might say 5158 S Windsor Dr and the address in the other might say 5158 South Windsor Dr). Please specify how you would do this. By hand is one possibility, but you must have facility with US address/language conventions.
We need to scrape all the degree names for each subcategory. An example would be htt... You could probably just iterate the degree variable from 11+ until you run out of subcategories which might be the easiest way to do this or you could just scrape the degree variable by creating a search on each subcategory page The output we would need for the csv would be (tab delimited like before was fine): Arts / Design / Fashion, Animation Schools, Associate of Science in Computer Animation Arts / Design / Fashion, Animation Schools, Computer Animation Arts / Design / Fashion, Animation Schools, Game Art & Design
I have 2 TAB delimited files. Both files are included as examples. I need them imported from a local folder into mySQL tables. File #1 goes into it's own table File #2 goes into it's own table, but one of the fields has pipe-delimited inventory data that needs to be stored in a 3rd table with the GTIN number from the row it was extracted from. That's 3 tables from 2 files. Will need to build an admin interface at some point later.
...Playing video will be triggered by a cron job that is triggered on a set interval, say every 5 minutes (or the use of some other means to trigger the view action) 3. Plugin will use a proxy list (rotating through the proxies) to access the video (so youtube sees the view as unique). Proxy list will be able to be entered via use of a line delimited text file. 4. Plugin can be installed on any wordpress website. 5. After activation and insertion of key data, plugin will display a cron command for the user too load onto their host. The purpose of this Plugin is to increase the # of views of a youtube video for SEO ranking purposes. It used to be that having autoplay would work, and you could steer visitors to the page (buy views) but now that will not work. For...
...that contains a file upload custom control that will allow a user to import data into database table(s) by reading data from either a delimited file or a MS-Excel spreadsheet and if the upload is unsuccessful the second custom control will replace the file upload custom control which will display the errors in the upload and allow the user to edit and correct the errors. The definition of the user controls follows. IMPORTANT: Please READ and the ENTIRE project definition including the technical constraints before posting!!! ## Deliverables I need a single web page that contains a file upload custom control that will allow a user to import data into database table(s) by reading data from either a delimited file or a MS-Excel spreadsh...
I have a list of addresses in a Word document from which I need to pull various information into an Excel spreadsheet. I have a sample of the Word document attached, as well as the template for the excel file. There are 260 pages in the Word document with an average of 7 entries per page for an estimated 1800 entries. The completed excel file should be saved as a tab delimited text file and as a csv file.
I have a list of addresses in a Word document from which I need to pull various information into an Excel spreadsheet. I have a sample of the Word document attached, as well as the template for the excel file. There are 260 pages in the Word document with an average of 7 entries per page for an estimated 1800 entries. The completed excel file should be saved as a tab delimited text file and as a csv file.
I have 2 TAB delimited files. Both files are included as examples. I need them imported from a local folder into mySQL tables. File #1 goes into it's own table File #2 goes into it's own table, but one of the fields has pipe-delimited inventory data that needs to be stored in a 3rd table with the GTIN number from the row it was extracted from. That's 3 tables from 2 files. Will need to build an admin interface at some point later.
Project second phase has several steps: 1 - Syndicate currently advertised listings to additional sites, such as Hotpads, Kijiji, Backpage, etc. 2 - Take tab delimited files from new data feed and populate them to our web site and syndicate with other listings. 3 - Prepare listings for Craigslist and automate as much as possible. This includes tracking price changes and status changes, as well as new listings. 4 - Watch for new listings and email a pre-formatted email to listing agent requesting permission to advertise their listings. Maintain list of agents that allow us to advertise and also a list of those who say no, so we do not send out to those agents again. Portions of this project are subject to change as discussions ensue.
I have a long data form created in Formidable that is being use in WordPress. We wish to take the tab-delimited output which I can move into an Excel spreadsheet, and build nice pages to print, preferably in Adobe inDesign or MS Word. It could also be done in HTML or PHP if that's what gets the job done. The key is that I want to suppress any record's field that does not contain a dynamic value. But, that's the easy part. I can do that with the built-in programming. What I also need to do is also suppress a corresponding static field name and line space, probably through some sort of conditional logic. Example: <<Record 1>> Static Text Label Dynamic field Value from DB Color: Red Size: Larg...
Using Windows Server 2008 with SQL Server 2005 and 2008. Create an SSIS package - Import comma delimited text files into SQL Server 2005 and 2008 with: 1. additional columns for file attributes: filename, last write date 2. additional columns parsing from text: work order, email 3. accommodate a text qualifier " (quote) that wraps commas in non-delimited columns, such as "lastname, firstname" The text files always have the same format. Place these tasks into a sequence to perf...
I am using a 3rd party online retailer (similiar to ) to sell. I am getting my inventory file from a supplier (in Excel, comma delimited etc. formats). I want to feed this inventory file into the online retailer's website where I have my own marketplace using XML feeds. The supplier will update the inventory file everyday. After the initial feeding of the inventory, my API should also update the changes in the inventory on the retailer's website everyday. For example, items deleted from supplier's inventory should be deleted, price changes should be updated etc. The 3rd party online retailer has given the documentation for creating the XML feeds.
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 es...
... * Extract data from a tab delimited text file with a header row. * Create different transaction types with imported data: Invoices, credit memos, payments, sales orders, won opportunities, general journal entries, purchase orders, etc. * Validate data to be imported and warn User about the encountered errors * If the transactions allready exist then there must be an options on the form to either Duplicate, Skip, or modify the transaction being imported * Must connect to the QuickBooks company file that is currently open There are several add on applications that perform this function and an example of which is <> I mainly plan on using a Tab delimited text file with a header row for the
...than 1 flat file at a time. Add some error checking and improving error checking when getting feedback about which inventory items generate fewer errors on upload. Saving the flat file may create an excel file / .csv file / or tab delimited .txt file. b) Selecting each product and flat file venue on a selection screen. Making it as simple as clicking a box for each product and a box for each flat file created (to include that product). Secondary tasks: (different budget) a). Enable creatinga new product (BASED ON AN EXISTING PRODUCT) to lessen the data entry time of getting a similar product in inventory. Creating a screen that selects existing inventory to a product mod/ product change file may be suitable. b). Continue creating new products from scratch &...
...internal use only that will assist us in creating bulk upload sheets for our SEM accounts (Google AdWords , Yahoo Search Marketing, Bing/AdCenter). Every day, our company releases new software products to our .com and international websites. These new software products have to be uploaded into our Search Engine Marketing accounts, which is done with bulk upload sheets. We will have a delimited data feed of the 100 most recently published products each day, which will have timestamps that can be used to sort by most recent. This will be a file hosted on a shared internal network drive, not an XML file or something else that needs to be fed from someone else's server. The script will read from the information in this feed (software title, pc/mac, language, etc)...
...-- pipe delimited file - this file gets created each time a new reading is taken. This file has data from the last reading taken. (Monitor name, date/time reading taken, temperature, relative humidity, dew point, alarm reached(true/false), heat index) config -- pipe delimited file - this file gets created each time a new reading is taken. This file has the configuration of the THUM software(Monitor name, temperature units, high temp alarm limit, low temp alarm limit, high RH alarm limit, low RH alarm limit) -- graph of temperature and relative humidity - this file gets created each time a new reading is taken -- THUM logo Program design requirements: 1. Display current temperature, relative humidity, and dew point 2. The data...
Hi, I am looking for an programmer to develop an desktop application program (posts extractor) which can do the followi...website. 4. The search keyword string can either be in the post thread or on the body of the post. Will supply excluded keywords for keyword search string in an text file excluded_keywords.txt. Pls see attachment.zip. 5. Websites requiring login is to be included (login captcha to be displayed so that it can be entered manually), credentials will be supplied via an text file as csv or tab delimited. 6. Output is to be written in a text file. 7. Working demo to be made available at 50% of project(to provide value additions if any), and full working program alongwith source code to be delivered at 100% or before final payment. Thank you for ...
I have a sample file attached with my expectations. It is a VSTO menu that I need some buttons hooked up to code that will perform the functionality I need. Summery: I have 4 buttons that need to be hooked up. 1. button open excel file, 2nd button open in excel tab delimited text file, 3rd button open a excel macro file, and 4th button open a file dialog window. I am looking for the code to be written in C# in Visual Studios 2010 64bit. There is a example file attached all I need is the buttons hooked up. button4: When this is clicked I need a file dialog box opened that is filtered into any directory you want that only displays *.txt and *.xlsx files. When the files are selected I need those files to open normally as if you open any file dialog box and open them. Butt...
Hi, I am in the process of promoting an upcoming live event and wish to target contacts withthin the training and education industries. I am have identified the following source that lists 2364 training companies. <> There are many categories listed and company names are included within each category. You will need to go ...aspx> There are many categories listed and company names are included within each category. You will need to go through and find contact e-mail address for each listing. There may be some duplicate company names within the categories. This project is find the contact e-mail for each company via their websites. The list should be compiled and delivered in both an XLS file and Comma delimited word document.
Two more files in the same formats as before. Please convert to tab delimited text files so I can insert with a LOAD DATA INFILE command. The model designation on these is: 44cc, and 45cc, respectively. Thanks!
We have a new set of tab delimited data files that we would like to create a .csv file for import into Magento (note: looking for a Magento importable .csv file only). The final import should be a comma separated file in the form of: "sku", "description", "price", etc.... There are 4 .tab files containing categories, item attribute definitions, item attributes, and the actual items themselves. Sample files are attached to the project. We would like to have a single .csv file that is ready to be imported to Magento via the Magento Import feature of Magento 1.5 or 1.6 (not via Dataflow). We will consider a direct API import but this is considered to be beyond what we are looking for. Any solution must be able to import a minimum of 50 items ...
I have five more of the files that are delimited by spaces (the difficult ones). :) I would like to convert those through both steps of our earlier projects, so the data is ready to insert into build_data table. Also, I have attached a file -- -- as well as a sample as it should look like after conversion: vendor_list_2_after.txt. All we want to save are the first two bits of data: the name, then the following alpha numeric code that follows it. All the rest is trash.
...lingual) virtual assistant who has a reliable and fast internet connection. The job requires you to be available for 30 hours minimum either 5 hours for six days or 6 hours for five days. Most of the job requires a physical check of our website / selling venues and provision of reports, collection of open source photos / scans and info to be determined, formatting lists of data into proscribed Excel Workbook and or CSV / tab delimited formats. Some posting of online advertising in English but also those prospective freelancers who speak either Chinese, Hindi, Brasilian (Portugese), Japanese or Korean fluently is a plus. Position also requires various types of research online including pricing research and historical research. This could be an ongoing situation as we would...
1 function. I pass in a log file, start time, and end time. Go through each available counter and write out: 1. counter name, avg value 2. counter name, max value 3. counter name, avg slope 4. counter name, if spike exists, at what time Each of this is on a different line, CSV delimited (console-based OK too) Need a dll for this.
Quick PHP project, I need some data I will define scraped from 4 different URLs. If multiple rows are returned figure out which is the current (say the warranty was extended for a particular system) ## Deliverables * Accept data from a HTTP GET ( SERIALNUM%) * Use PHP Simple HTML DOM Parser Library (Open-Source) - [][1] * Create 4 different php files (1 file per URL) * Each one will extract data we request from 1 of the 4 different URLs * %PROVIDED SERIALNUM% - I will provide serial numbers for development purposes after the project is awarded to a worker. * Echo the data back this pipe delimited format: * WARRANTYSTART|WARRANTYEND|SHIPDATE|CONTRACTYPE * We understand that not all fields are available
I need a script written that will take a datafeed and import/update all products in the list. Datafeed will have to be forma...customized are things like URL of the feed/or ftp site, whether the feed has headers or not, column definitions, assign a tax to all items, define which column has the image link and be able to get full size image and thumbnail generated from same link. I want to be able to define on this page, how the scripts handles parsing the category column. The datafeed has multiple categories in the same field delimited by commas. If this changes, i'd like to be able to just change the delimiter and everything still works. Admin page also needs to have a save button (which saves all the settings to a table you will create) and then produce a cron job string tha...
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.
Input a number of fields including a web url. Test the url for validity, if fails go to next record, if it passes, spit out entire record and repeat this on every record in list that is delimited.
...consist of sending one page, A4 size, to each contact. Sent with Fine Resolution. A page contains about 4 pictures, relatively small. Typical transmitting time is approx. 1:30. The text and layout is already ready, and will be delivered to you in any standard format (such as PDF, TIF). A sample of the page will be provided to you upon request. The list of fax numbers will sent to you in Text Delimited Format. An opt out link must be inserted at the end of the fax page and all opt out feedback must be removed from the fax list after the campaign. A separate Black list must be provided as well. Before contracting, you should be able to do a test on a small portion of the Database to check your results, Fax Broadcasting Speed and mastering in Fax Broadcasting. You...
