Posts Tagged csv

Magento Product Config Onto CSV

Have products on word document with all detials of sizes and prices but they neeed to be put into csv doc for upload to Magento and just dont have time.

So you need to read word doc and put together in XL doc ready for uplaod.

Need to itemise category, type of product (simple, config) , colour, price etcetc

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

Add Magento Products

I am new to Magento, and for the past day Ive been trying to import a CSV file with over 3,000 products to my Magento store.

To cut a long story short, the file keeps coming up with errors, so I need someone experienced in importing CSV files to Magento to view the CSV file, make the necessary adjustments for it to work, and upload it.

I have images corresponding to the images numbers in the CSV file, which I can send too.

*The products are all adult products*

Im looking for this to be completed inside a day.

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

Hika Shop Product Import Using CSV

Due to pressures of work we require a skilled indivdual to help complete a basic online store using Hika Shop. We have our catalogue of products that we need imported into the shop and also would like a simple method of changing the pricing within the shop as due to a complex market our supplier changes prices on a monthly basis. The product list is small and images will need to be extracted from the pdf broucher.

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

Extraction Of Data To CSV

Hi,

I need to extract Name, Phone numbers from a GIVEN web page to a CSV list.

The list size is about 37,000 records.

The information on the webpage is already organized in a format so its a very simple job.

Name:
Phone:
Email:

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

Perl Script Add Header Line And Change Date Format On CSV

Need to create a perl script that adds a header line to a csv file and updates the date format column.

Files
Raw File called ftc_order.csv

The Perl scripts needs to add the following header line to the csv
header.csv (file attached)

Also the date format column needs to be updated from "20110327" to "27/03/2011"

The file then needs to be saved at ftc_order_(Todays date).csv

Timeline for project 48 hours.

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

Php Or Perl Or Javascript Or Any For A Small Work $15.00

i need a small perl or php or javascript

to handle below logic

step1: First remove duplicates from input/data/1.csv file ( remove based on 2nd column
"Model" – out of 152 rows you will get 5 rows without headers

Create a file in output/data/1.csv which will have 5 rows.

read 1st row in output/data/1.csv and read value in "Images1"
and go to input/images/ folder copy matching file and paste it to
output/images/ folder

Like this repeat for "Images2", "Images3" columns and copy files to output/images folder

step2: Now open the original csv file input/data/1.csv and read value in
"Images1" column and go to output/data/1.csv and get the image name and then
go to output/images/ folder and copy matching image and rename it as the name of file
image in "Images1" column in input/data/1.csv file paste it to final/images/ folder

This step is critical and you must understand clearly

here is sample test data

www.ameytech.com/tmp/tmp/projects/lcds-images/image-mapping.zip

Tags: , , , , , ,

CSV To WordPress

Hi, I need to upload a CSV file to my wordpress database. Need to properly import: Date, Section, Headline, SubHeadline (to go into SEO description), Summary, Story Text, and Author.

– Prior CMS was college publisher.

Prefer project to be done well and at low cost as opposed to quickly at high cost.

Tags: , ,

Add Products Via CSV To Magento Site.

We have about 400 products that need to be added to our Magento site via CSV. What we need is a profile that will import these products into the site cleaning with all the product attributes from the CSV file. We also want the images to be part of t his import. We will pay $200 for this to be done in a timly fassion.

* we are looking for a Magento guru.

Tags: , , , , ,

CSV To Tiki Wiki CMS Import Script

I need a plugin for Tiki WIki CMS allowing user to import data from CSV files.
The interface must allow the user to choose which data have to be extract and allow multilingual content. It is a bit like the mscvsimport plugin for MediaWiki, with some more features.

I can provide more info and help since I am myself a PHP coder (I just lack of time for this project)

Please send me a short explanation of how you would build this while applying for this job. Only bids with proved Tiki Wiki CMS and MySQL skills will be taken in consideration!

Tags: , , , , , ,

CSV Files Processing

Hello,

I need someone who is very familiar with csv files, texts processing read/write, regular expressions, C# programming and Visual Studio, to develop a simple desktop based application with 7 functions handling with csv files as defined below. The desktop application GUI has a TabPage for each function. The platform to run the application is Microsoft Windows Server 2008 but could be runnign on any Windows platform. The csv files could have 5000 rows or more, so the application should be robust enough to execute the functions properly.
All the sourcing codes of the application should be sent to me.

1) First TabPage with name "New Titles" :

1.1) The format of the csv file is using standard csv files rules as per this link http://en.wikipedia.org/wiki/Comma-separated_values
The first line of the csv file has column headers. CSV is a delimited data format that has fields/columns separated by the comma character and records/rows terminated by newlines. Fields that contain a special character (comma, newline, or double quote), are enclosed in double quotes. If a line contains a single entry which is the empty string, it is enclosed in double quotes.
Fields with embedded double-quote characters must be enclosed within double-quote characters, and each of the embedded double-quote characters must be represented by a pair of double-quote characters.
These rules wil help you to parse the csv file, I think there are already many existing and available C# librairies functions you can use to read/parse csv files with these rules above.
Is is important that the saved result csv files should copy exactly the fields value of the input csv file AS-IS, except of course for the fields which are modified as per the functions defined below. It means that for example if any fields values are within double-quotes, the result csv file should have the same field value within double-quotes.
See attached the sample format of csv file for this TabPage.

The format of the added csv file of this TabPage is :
– Name,Audio,Text,Image,Text,Image,Text,Image,Text,Image,Text,Image,Text,Title,Title2,Title3,Title4,Category,Tag,Description,Username,Password,DeveloperKey,ApplicationID,AmazonCategory
or
– Name,Audio,Image,Text,Image,Text,Image,Text,Image,Text,Image,Text,Title,Title2,Title3,Title4,Category,Tag,Description,Username,Password,DeveloperKey,ApplicationID,AmazonCategory

Just notice that in the second format, just the first Text column is removed compared to the first format. The application should only consider the columns which are used and modified in this function, and should ignore all the other columns and simply copy them AS-IS to the result csv file.

1.2) GUI design :

1.2.1) The name of the TabPage is New Titles, create a datagrid in the Keyword TabPage, the datagrid has 4 columns, Select column, Filename column, Path column, Status column.
The "Add Files" button add a csv file into the datagrid, the "Clear List" button remove all the csv files of the datagrid.
The "Run" button executes the functions.
The users can add multiple csv files into the datagrid, each line of the datagrid has the 4 columns, Select column, Filename column, Path column and Status column.
The column Select is like the checkbox with the sign view when a csv file is added to the datagrid. By default the csv file is selected when added to the datagrid.
The column Filename is the filename of the added csv file.
The column Path is the full path repertory of the added csv file.
The column Status is : OPEN when the csv file is added to the datagrid, PROCESSING when the application executes the function, OK when the function is executed successfully on the csv file, and FAILED if something is wrong with the execution.

1.2.2) Concerning the column Titles of the csv file, create in the GUI a group and name it Titles (just draw a rectangular to clearly identify this group) :
– create a text Title and a field value set by default to 10, the Title is mandatory so there is no checkbox
– create a text Title2, a checkbox selected by default and a field value set to 6 which can be changed
– create a text Title3, a checkbox selected by default and a field value set to 3 which can be changed
– create a text Title4, a checkbox selected by default and a field value set to 1 which can be changed
– create a text Title5, a checkbox selected by default, a text field set by default with the word Review and the users can modify the text as wished, a field value set to 1 which can be changed
– create a text Title6, a checkbox selected by default, a text field set by default with the word Video and the users can modify the text as wished, and a field value set to 1 which can be changed
– create a text Title7, a checkbox selected by default, a text label Amazon Category, and a field value set to 1 which can be changed
– create a button Add Titles which create a text Title8, a checkbox selected by default, an empty text field and the users can type the text as wished, and a field value set to 1 which can be changed. The button Add Titles can add Title9, Title10 and so on

1.2.3) Create another group with a rectangular draw lines with the name Credentials, add in this group a checkbox selected by default, a text label CSV files and a windows browse option to locate the csv file which has a default path/filename value set to D:ProjectAmznProductionDataCredentialyt_credential_default.csv

1.2.4) Create a check box selected by default, a text label "First Text" and a text field with the default text set to :

Free Review!

Product
Title

1.2.5) Create a check box unselected by default, a text label "Category" and a windows browse to load the csv file.

1.2.6) Create a "Save Options" button which save all the default values of all the options defined above into a config file, so for each runninng process of the application, all the saved default values in the config file are loaded into the application.

1.3) The functions of the button "Run" is defined as following :

1.3.1) The first step is to replace the column Title with the Title, Title2, Title3, Title4, Title5, Title6, Title7
For all the added csv file altogether, the app creates a new data structure to group all the rows of all the csv files which have the same Title column values case insensitive.
You must use an appropriate datastructure to handle the process properly as the csv files could have 5000 rows or more.
For each group having the same Title value, the application overwrites the Title column value with the value of Title, Title2, Title3, Title4, Title5, Title6, Title7 with the ratio defined under the group Title as defined above.
For example the default ratio values of Title, Title2, Title3, Title4, Title5, Title6, Title7 are 10, 6, 3, 1, 1, 1, 1
So the application takes the first 10 rows of the group of duplicated Title and assign the value of the Title column (it is already correctly assigned as the Title is already correct).
The next 6 rows have the Title value set to the value of the Title2 column
The next 3 rows have the Title value set to the value of the Title3 column
The next 1 row has the Title value set to the value of the Title4 column
The next 1 row have the Title value set to the value of the Title5 column
The next 1 row have the Title value set to the value of the Title6 column
The next 1 row have the Title value set to the value of the Title7 column.
Repeat the assignement process until all duplicated items of the group are completed, and repeat the same process for all the groups of duplicated items. If there are not enough duplicated items, just use the sequence order of Title, Title2, Title3, Title4, Title5, Title6, Title7 as 10, 6, 3, 1, 1, 1, 1
The app uses only the different Titles which have a checkbox selected (except for the Title label which is mandatory).

The Title, Title1. Title2. Title3 and Title4 columns have already the values from the input csv files.
The Title5 is build as follow, take the value of the Title column, add a space and add the word Review (by default) or the text written by the users in the text field
The Title6 is build as follow, take the value of the Title column, add a space and add the word Video (by default) or the text written by the users in the text field
The Title7 is build as follow, take the value of the Title column, add a space and add the value of its associated AmazonCategory column
If there are new added Titles, take the value of the Title column, add a space and add the text written by the users in the text field

All the Titles should have maximum 100 bytes or less, if they are above the max 100 bytes truncate the last necessary word(s) of the Titles to match the size.

Obviously the datastructure must record which row belongs to which csv file, for the save to the corresponding result csv file.

1.3.2) When all the rows of all groups of duplicated items are assigned with the Title column following the specifications of point 1.3.1) above, here are the next functions :

1.3.2.1) If the checkbox of the Credential is selected, takes the credential csv file added and assign the Username,Password,DeveloperKey,ApplicationID columns of the first row of the datastructure with the first row of the Credential csv file, the second row of the datastructure with the second row of the Credential csv file, and so on, until all the total rows of the datastruture are completed. In most cases the Credential csv files have much less rows than all the rows of all csv files, so the application must loop on the credential csv file for the assignement. The format column headers of the Crendial csv file is : Username,Password,ApplicationID,DeveloperKey
So take the values of these columns and assign to the corresponding column headers Username,Password,DeveloperKey,ApplicationID of the rows (be careful order of column headers might not be the same but the colum name is identical).
If the checkbox is not selected, no change is done for the Username,Password,DeveloperKey,ApplicationID columns

1.3.2.2) For the first format csv file : if the checkbox of the text label "First Text" is selected replace the first Text column with the text of the text label "First Text" as defined above. The word Title in this text is just used to simplify the implementation, and it should be replaced as follow :
For all the rows of the datastructure which have the value of the Title column with Title2, Title3, Title4 replace the word Title with the value of the Title column
For all the other rows of the datastructure which have the value of the Title column with Title, Tile5, Title6, Title7 and so on, do nothing
For the second format csv file : either the checkbox of the text label "First Text" is selected or not, nothing is done

1.3.2.3) For the Tag column : all the rows of the datastructure which have the value of the Title column with Title2, Title3, Title4, replace the value of the Tag column as follow :
The value of the Tag column is a sequence of keywords, the first keyword is the value of the Title column, then add a comma, then add each word of the Title value with each word separated by a comma, add the value of the AmazonCategory column, add a comma, add each word of the value of the AmazonCategory column with each word separated by a comma. The value of the Tag is embedded between double-quotes (to be safe with csv rule see above).
So the Tag has the sequence of keywords like keyword1,keyword2,keyword3 and so on where each keyword can have one word or multiple words, and each keyword is separated by a comma. The Tag should comply to these following rules :

a) each keyword of the Tag should have at least 2 bytes and maximum 30 bytes (non-including the double-quotes). If a keyword is less than 2 bytes, it is removed. If the keyword is higher than 30 bytes, truncate the necessary last word(s) so the truncated keyword is less or equal to 30 bytes. The maximum size length of the Tag value should be less or equal to 500 bytes (non including the double-quotes), if it is above 500 bytes truncate the necessary last keyword(s) to match the size of 500 bytes.

b) if there is any duplicated keyword in the Tag value, remove the duplicated keyword.

1.3.2.4) For the Description column : For the rows of the datastructure which have the value of the Title column with Title2, Title3, Title4 the application parses the value of the Description column, bypass the first line which have texts, bypass 2 following Break Lines, and should find the next lines which starts with text, it could have 1 or 2 lines with texts, and then 2 Break Lines. If there is one line of text before the 2 Break Lines, replace the text of this line with the value of the Title column value. If there are 2 text lines before the 2 Break Lines, replace the second text line with the value of the Title column.
The value of the Description column has a maximum length of 5000 bytes, if it is over 5000 bytes truncate the necessary last word(s) to match the size.

1.3.2.5) For the Category column : If the checkbox of the text lable Category is selected, takes the Category csv file added and assign the Category of the first row of the datastructure with the first row of the Category csv file, the second row of the datastructure with the second row of the Credential csv file, and so on, until all the total rows of the datastruture are completed. In most cases the Category csv files have much less rows than all the rows of all csv files, so the application must loop on the Category csv file for the assignement. The format of the Category csv file has one column header : Category
If the checkbox is not selected, no change is done for the Category column.

1.3.3) At the end of the whole process, for each csv file added to the datagrid, an associated result csv file is automatically generated and saved after the functions "Run" is executed and completed successfully. The columns Title2, Title3, Title4, and AmazonCategory are removed and not saved to the result csv file.
If there is something wrong during the execution there is no created result csv file. The column headers of the result csv file is :
Name,Audio,Text,Image,Text,Image,Text,Image,Text,Image,Text,Image,Text,Title,Category,Tag,Description,Username,Password,DeveloperKey,ApplicationID
or
– Name,Audio,Image,Text,Image,Text,Image,Text,Image,Text,Image,Text,Title,Category,Tag,Description,Username,Password,DeveloperKey,ApplicationIDThe result csv file is stored on the same repertory of the input csv file added, the filename is input csv file + _newtitle, for example if the input csv file is keyword.csv, the result csv file is keyword_newtitle.csv (if the result csv filename already exists in the repertory just overwrite it).
As the application records the row of its associated csv file into the datastructure, each row of the input csv file will be saved to its asscociated result csv file. It means that, the result csv file will have the same rows number as its associated input csv file.

2) Second TabPage with name "CSV Extract" :

Separate and Extract rows with the Status column equal to OK and rows with the Status column equal to FAILED.

2.1) GUI Similar to Tabpage 1, with the button "Add Files", "Clear List", a Datagrid and a button "Run". The user could add one or multiple csv files into the datagrid. For each csv file added the application separates and extracts rows with the Status column equal to OK and rows with the Status column equal to FAILED.

2.2) Save automatically to result csv file :

2.2.1) Save automatically all the rows with Status equal to OK to the result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory as the csv file added, the filename is the added csv file + _extractok, for example if the first csv file is keyword.csv, the result csv file is keyword_extractok.csv (if the result csv filename already exists in the repertory just overwrite it).

2.2.2) Save automatically all the rows with Status equal to FAILED to the result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory as the csv file added, the filename is the added csv file + _extractfailed, for example if the first csv file is keyword.csv, the result csv file is keyword_extractfailed.csv (if the result csv filename already exists in the repertory just overwrite it).

3) Third Tabpage with name "CSV Compare" :

Compare Name column or Status column of the first added csv file and the second csv file, and save to result csv file.

3.1) GUI Similar to Tabpage 1, with the button "Add Files", "Clear List", a Datagrid and a button "Run". The user adds a pair of 2 csv files into datagrid for each line of the datagrid. Multiple pairs of csv files can be added, one pair of csv file for each line of the datagrid. Some pairs of csv files have a Status column and some pairs of csv files do not have the Status column. In all cases there is always the column Name, all the columns of the first or second csv files should by copied AS-IS to the result csv file. For information, each pair of the first and second added csv files are always on the same repertory, and could not have the same column headers :

3.2) Case csv files having the Status column :

3.2.1) The application separates and selects all rows of the second added csv file which have the Status column equal to FAILED, separate and unselect all rows of the second added csv file which have the Status column equal to OK

3.2.2) The application selects all rows of the first added csv file whose value of the Name column is not in the second csv file.

3.2.3) Save to result csv file :

3.2.3.1) Save automatically all the selected rows of point 2.1.1 and 2.1.2 to the result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory of the first csv file added, the filename is the first csv file + _bis, for example if the first csv file is keyword.csv, the result csv file is keyword_bis.csv (if the result csv filename already exists in the repertory just overwrite it).

3.2.3.2) Save automatically all the unselected rows of point 2.1.1 to a result csv file (actually all rows having Status column equal to OK). If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory of the second csv file added, the filename is the second csv file + _compareok, for example if the second csv file is keyword.csv, the result csv file is keyword_compareok.csv (if the result csv filename already exists in the repertory just overwrite it).

3.3) Case of csv files not having the Status column :

3.3.1) The application selects all rows of the first added csv file whose value of the Name column is not in the second csv file.

3.3.2) Save automatically all the selected rows to the result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory of the first csv file added, the filename is the first csv file + _bis, for example if the first csv file is keyword.csv, the result csv file is keyword_bis.csv (if the result csv filename already exists in the repertory just overwrite it).

4) Fourth TabPage with name "Audio&Category&Credential" :

Change the Audio, Category and Username, Password, DeveloperKey, ApplicationID columns

4.1) GUI Similar to TabPage 1, with the button "Add Files", "Clear List", a Datagrid, a checkbox unselected by default with a text label "Audio" and a windows browse to load the csv file, a checkbox unselected by default with a text label "Category" and a windows browse to load the csv file, a checkbox unselected by default with a text label "Credential" and a windows browse to load the csv file, and a button "Run".

4.2) For the Audio column : If the checkbox of the text lable Audio is selected, takes the Audio csv file added and replace the value of the Audio column of the first row of the added csv file with the value of the Audio column of the first row of the Audio csv file, the second row of the added csv file with the value of the Audio column of the second row of the Audio csv file, and so on, until all the rows of the added csv file are completed. In most cases the Audio csv files have much less rows than all the rows of the added csv file, so the application must loop on the Audio csv file for the assignement. The format of the Audio csv file has one column header : Audio
If the checkbox is not selected, no change is done for the Audio column.

4.3) For the Category column : If the checkbox of the text lable Category is selected, takes the Category csv file added and replace the value of the Category column of the first row of the added csv file with the value of the Category column of the first row of the Category csv file, the second row of the added csv file with the value of the Category column of the second row of the Category csv file, and so on, until all the rows of the added csv file are completed. In most cases the Category csv file has much less rows than all the rows of the added csv file, so the application must loop on the Category csv file for the assignement. The format of the Category csv file has one column header : Category
If the checkbox is not selected, no change is done for the Category column.

4.4) For the Username, Password, DeveloperKey, ApplicationID columns : If the checkbox of the text lable Credential is selected, takes the Credential csv file added and replace the value of the Username, Password, DeveloperKey, ApplicationID columns of the first row of the added csv file with the value of the Username, Password, DeveloperKey, ApplicationID columns of the first row of the Credential csv file, the second row of the added csv file with the value of the Username, Password, DeveloperKey, ApplicationID columns of the second row of the Credential csv file, and so on, until all the rows of the added csv file are completed. In most cases the Category csv file has much less rows than all the rows of the added csv file, so the application must loop on the Category csv file for the assignement. The format of the Credentail csv file has 4 column headers : Username,Password,ApplicationID,DeveloperKey
If the checkbox is not selected, no change is done for the Username, Password, DeveloperKey, ApplicationID columns.

4.5) Save automatically all the rows to the result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory of the added csv file added, the filename is the added csv file + _acc, for example if the first csv file is keyword.csv, the result csv file is keyword_acc.csv (if the result csv filename already exists in the repertory just overwrite it).

5) Fifth TabPage with name "CSV Merge Images&Keyword" :

Merge some columns of the first added csv file into the second csv file. For information each pair of csv files are stored on the same directory, they have the same row numbers and the values of the Name column of the first csv file are identical to the value of the Name column of the second csv file.

5.1) GUI Similar to TabPage 1, with the button "Add Files", "Clear List", a Datagrid and a button "Run". The user adds a pair of 2 csv files into datagrid for each line of the datagrid. Multiple pairs of csv files can be added, one pair of csv file for each line of the datagrid. For information, each pair of the first and second added csv files are on the same repertory, and does not have the same column headers.

5.2) For each pair of csv files added to the datagrid and all rows of the second csv file the application copy all the columns of the second csv file and find the matching value of the Name column of the first csv file, for the value of the Name column matching between both csv files, copy all the associated value of the Image columns of the first csv file respectively to the Images columns of the second csv file.

5.3) Save automatically all the rows to the result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory of the second csv file added, the filename is the second csv file + _ready, for example if the first csv file is keyword.csv, the result csv file is keyword_ready.csv (if the result csv filename already exists in the repertory just overwrite it).

6) Sixth TabPage with name "CSV Merge" :

Merge all rows of all csv files added into a result csv file. For information, all the added csv files have the same column headers and are stored on the same repertory.

6.1) Similar to TabPage 1, with the button "Add Files", "Clear List", a Datagrid and a button "Run". The user adds multiple csv files into the datagrid. The application simply merge all the rows of all the added csv file. Actually the application appends all the rows of the first csv added, and then the second csv file and so on.

6.2) Save automatically all the merged rows of point 3.1 to a result csv file. If there is something wrong during the execution there is no created result csv file. The result csv file is stored on the same repertory of the first csv file added, the filename is the first csv file + _merge, for example if the first csv file is keyword.csv, the result csv file is keyword_merge.csv (if the result csv filename already exists in the repertory just overwrite it).

7) Seventh TabPage with name "CSV Split" :

Split the added csv file into smaller result csv files.

7.1) Similar to Tabpage 1, with the button "Add Files", "Clear List", a Datagrid, a button "Run" and a text label "Rows Number" with a field where the users can type the value number. The user can adds multiple csv files into the datagrid. For each csv file added the application splits the total rows of the csv file with the value number.
For example, if an added csv files has 3800 rows, the user type the value number 500, the program generate 7 csv files of 500 rows and the last csv file has 300 rows. The first result csv file has the first 500 rows of the added csv file, the second result csv file has the next 500 rows of the added csv file, and so on.

7.2) Save automatically all the rows of point 3.1 to the result csv files. If there is something wrong during the execution there is no created result csv file.The first result csv file has the filename of the added csv file + _1, the second csv file has the added csv file + _2, and so on. The result csv file is stored on the same repertory of the added csv file added, for example if the first csv file is keyword.csv, the result csv files are keyword_1.csv, keyword_2.csv and so on (if the result csv filename already exists in the repertory just overwrite it).

Thanks

Tags: , , , , , ,

Scraper For Map Database On Web

Write a scraper to get all data in projects from http://actionplan.gc.ca/eng/map.asp and post it all as a CSV file. Instructions on accessing the data are at http://actionplan.gc.ca/eng/feature.asp?pageId=134.

The CSV should contain all the output values of their getProject function.

The code should come in a form so that a guy who knows nothing about Java (me) can retrieve the CSV file in his browser.

This is a clear no-brainer for anybody who knows Java etc.

Tags: , , , , , ,

Automatically Update Database From Csv File

I am on a share webhosting plan (actually is a reseller plan)

I have, on my share webhosting account on a server, a csv file that will be updated automatically, having the csv file updated is a task I already solved myself, hence the csv file is being updated automaticalley already.

What I need is that this csv file which will be on my shared account, also automatically do update a mysql database,
is only 12 fields, only one table!

I mean that the csv file will be updated, and so now, what I need, is to use that csv file to automatically update the mysql database too.

I am on a linux enviroment, on cpanel with phpmyadmin

I know its not too dificult, I know some php and mysql myself, actually I was writting it myself but I have no time to do it

I need that you write it (I am sure you have such script already or a similar one, as it is a very simple one), and test it, and let it working nicely along with the csv

03/18/2011 at 16:14 EDT:

It needs to be installed tested and work for some period say 3 days to be sure it does work perfectly

Tags: , , , , , ,

CSV To Tiki Wiki CMS Bulk Import Script

I need a plugin for Tiki WIki CMS allowing user to import data from CSV files.
The interface must allow the user to choose which data have to be extract and allow multilingual content. It is a bit like the mscvsimport plugin for MediaWiki, with some more features.

I can provide more info and help since I am myself a PHP coder (I just lack of time for this project)

Tags: , , , , , ,

TecDoc Database In Excel Or Csv.

Looking for TecDoc database in excel or csv. format for web parts shop, that i can import the csv on my webpage .

Tags: , , ,

ONIX XML To CSV

Project Scope
Convert ONIX xml data to CSV file.

Input:
ONIX xml data from a book publisher

Output needed:
CSV file

Tags: , , , ,

Custom PHP Sript To Read Product Into Into Into A CSV/XLS

Seeking an experienced PHP developer who can write a custom script that will use cURL to read online product information into a local CSV/XLS file which will then be imported into an OpenCart e-commerce platform. Sample product pages can be found @ http://www.multiquip.com/multiquip/plaster-mortar-mixers.htm#

We are a retailer for MultiQuip and are looking for a way to automate the product database creation, and all the text details would need to be stored in individual columns accordingly. Developers with knowledge of OpenCart who can also format the database file for proper importing into the e-commerce platform will be preferred and compensated accordingly.

Tags: , , , , , ,

Prestashop CSV Import

I need someone to Edit a CSV import file for my sexshop. I have tried for weeks to try import it but no luck so giving an expert a chance to give it a go!

Tags: , ,

SAP-Convert IDoc To Csv And Csv To IDoc

Developers, I need to have an application to convert iDoc to csv format and csv format to iDoc. I do not have SAP installed or knowledge about iDoc but I only need to process data. You need to create code using the files I will give you

Tags: , , , , , ,

PERL: Convert Static HTML To CSV

I have a lot of static web pages with contact information I would like to convert with a tool like PERL script.

This way I can use it in the future going forward on all future files, with a little modification.

I need someone to write this script. Its basically searching through an HTML file template, and grabbing data from a few of the tables in the document.

Tags: , , , , , ,

PERL: Convert Static HTML To CSV

I have a lot of static web pages with contact information I would like to convert with a tool like PERL script.

This way I can use it in the future going forward on all future files, with a little modification.

I need someone to write this script. Its basically searching through an HTML file template, and grabbing data from a few of the tables in the document.

Tags: , , , , , ,

PERL: Convert Static HTML To CSV

I have a lot of static web pages with contact information I would like to convert with a tool like PERL script.

This way I can use it in the future going forward on all future files, with a little modification.

I need someone to write this script. Its basically searching through an HTML file template, and grabbing data from a few of the tables in the document.

Tags: , , , , , ,

IPB : Write Script To Import Users In .csv Format Into IPB

Hi,

I have a large group of members stored in a .csv file; these members have custom fields.

I would like you to write a script that

1) adds these custom fields to an existing IPB 3 forum;
2) adds the new members to this forum;
3) adds the values for each members custom fields to the forum.

Note that the IPB forum already has members in it, and some of the members in the .csv are already inside the IPB forum; youll have to test by email address.

The .csv members passwords are stored in md5.

I look forward to your proposal.

Thanks! 🙂

Tags: , , , , , ,

REAL TIME STOCK TABLE GENERATED BASED OFF CSV STOCK FILE COD

REAL TIME STOCK TABLE GENERATED BASED OFF CSV STOCK FILE CODING

We have a 3d cart store, and we want real time stock table to be generated in each item page, corresponding to the item itself, based off the csv file located in the ftp folder. Simple coding i beleive, bidding is around maximum 100$, we have thousands of products, we need real time stock based on CSV file in ftp file.

site is in ASP/ SQL , Source files are off limits, cannot touch any source file or database.
only access is ftp, and base off the real time stock from the CSV file.

Tags: , , , , , ,

Excel Sheet, Automate Reading From Csv

Hi,

I need a VERY simple macro made.

I need it to read from a csv and fill that csv in at row 2 in a spreadsheet.
I neeed to it sleep every 40 seconds — then repeat.

Tags: , , , ,

Edit Data Feed Csv So It Uploads To Affiliate Network

I have generated a csv file with the attributes needed to go into an uploadable data feed file for affiliate merchant program at c-l-i-x-g-a-l-o-r-e .com.

I need someone whos familiar with data feeds to simply put the 45-48 products in order, in the correct way so it uploads smoothly into the system. (Note – I will do the uploading. This project is to setup the file)

The instructions for uploading a data feed file the correct way are listed here:
http://www.clixgaloretutor.com/how-do-i-offer-a-datafeed.shtml

If youre an expert with data feed files, and can configure the data file for 3 shopping comparison sites (CSE"s), that would be even better.

Please send an outline of your experience with this type of work. I would prefer to hire someone I can work with again.

Please give me a sampling of your rates for:

1. the affiliate account for 45-48 products
2. comparison shopping data feeds (80-85 products)

Upon choosing a provider, I will send you the .csv to fix.

Thanks

Tags: , , , , , ,

Very Fast And Easy PHP Task, Need It Done In Max 3 Hours

Hello,

I need a very fast and easy task to do in php

I have a webapp that generate a csv file, but at the moment the file generated have lot of duplicates inside, so what I need is:

a function that I can call like this: cleanCsv($filename)

That return me the new file "cleaned" from duplicates

If you want you can easy do it by: taking the CSV contents, save in a database, clean it from duplicates, save again the CSV "cleaned"

This is a part of another project – This will take to anyone know how to do not more than 30 minutes, so I will not pay more than $15 for this simple task and I need it done in MAX 3 hours – another small task worth about the same will be discussed after this one is done

Tags: , , , , , ,

Scrape Data Tool To Csv

Hello,

I need someone who write a script that can scrape focalprice.com for me to a live CSV file on my own webserver. This CSV file has to be refreshed every night (cron job) so new products are added automaticly to my own/future (prestashop) webshop.

Probably a php script is best for this, because the script has to run from my webserver and is triggered by a cron job every night.

I will need the app to extract data by keyword search query:

http://www.focalprice.com/search.html?keyword=naruto

The program/script will need to extract the following details and save them to CSV:

NAME
PRICE
DESCRIPTION
IMAGES URL
PRODUCT URL
REVIEWS

There are 2-6 images per product. If a user normally clicks on an image it shows up watermarked. Look at the source code of that page – the normal format of images can be found there.

Lowest bid wins.

Happy bidding!

Tags: , , , , , ,

Magento Expert Needed – Product Uploads – Data Entry

This is the situation,

I have a CSV file with just over 13000 products in.

The images for these are already on the server although they might not be in the right place because I cant get them to show on the website.

First and foremost I need the images to be matched up to the csv file.

Secondly if possible I need someone to edit the description slightly on some of the products either manually or on the csv file.

Thirdly I need the right products to be assigned to the correct categories.

If you can do this job quickly I will use you on all of my other jobs as I need someone who is reliable and that can work super fast!

Also, some products are configurable products with colour and size, so may need to be done manually.

You will also need to make sure that the product descriptions,meta title e.t.c impending the numerous keywords are in the correct areas.

If there is not an SKU I need you to make one up.

You need to be an expert in magento – If you know how to use Cpanel as well that is a bonus.

The person that can do this in the quickest time will win. If you cannot complete in the time you set there will be a 25% reduction in your fee. If you complete early or on time there will be a 15% increase.

Please send info in pm.

Tags: , , , , , ,

Get Data From Amazon API> Store In CSV

The job will be to write a script that can:

1. Read a spreadsheet to acquire ISBN and Price (our stock take data)
2. Query Amazon API against the ISBN to acquire book data and store an image file
3. Output to a .csv file for uploading to Our E-commerce Store

The final output .csv will need to be in a format that can be uploaded to a Magento E-commerce Store, we will provide a .csv file to show the exact format needed.

The initial spreadsheet to get the data from (our stocktake) consists of only 3 fields, ISBN – Our Price – Our Quantity, we would like to add the data from amazon to complete a products profile for upload to our magento site.

Tags: , , , , , ,

Web Scraping Project – Mine Records Into CSV/Excel

I need to extract all the records from the site: http://www.transparency.ca.gov/Contracts/

There are currently 127000+ records in 2500+ webpages. I need the data in a CSV or Excel format

Include the following fields:

Contract #
Department
Total Price
Supplier Name
Contract Dates
Supplier Classification Codes
Special Instructions
Acquisition Type
Acquisition Method

and also the subsection which includes Header Name, Description and Classification Codes

1) Please create a script (preferably Python or possibly something else I can run on a PC) that extracts this information.
2) Please run the script and generate the output
3) Deliverables will include the script and the output.

Tags: , , , , , ,

Data Inpuit Into EXcel .csv File From A .pdf File.

I have about 75 pdf. files with an average of about 25-75 transaction on each file, that have to be transfered to an excel file. There are 3 categories that must be filled in. The Categories are Date, Name, Amount.

The job is to pull the information from the pdf. file either manually or with a program. I dont care as long as the final product is correct.

Then input into an excel sheet with the 3 columns listing the 3 categories listed above that is it.

All pdf files can be inputed onto a single spreadsheet.

A sample can be sent once a confidentiality agreement is signed and a photo id is emailed.

Tags: , , , , , ,