+ Start a Discussion
anitha12anitha12 

Data Import From Server logs to salesforce

Hi I need to import data from server log files to salesforce. Plaes help me/




Thanks,
Anitha.
logontokartiklogontokartik
You can use tools like dataloader or Salesforce native import.  There are many other third party tools like dataloader.io, JItterbit DataLoader than can import anything into Salesforce.

https://developer.salesforce.com/page/Data_Loader

Hope this helps
praveen murugesanpraveen murugesan
Hi Anitha,

There is lots of tools from Salesforce and third party Apps for importing records. YOu can use dataloader which very easy to use or use import wizard. Most import thing which you need to consider is you need to map the fields.

This link will explain you abt different types and describes abt it pupose.

http://www.saaspie.com/2014/02/06/different-data-loaders-salesforce/

Mark it as solution if its helps.

Thanks.

Praveen Murugesan.
anitha12anitha12
Hi Praveen,

Actually what is my question is Server log files are in the form of Text.file. How can I convert Text file in to CSV, after convertion, using Tools we can move. pls help me.

Thanks,
Anitha.
praveen murugesanpraveen murugesan
Anitha,

you can convert txt file to csv by the following way.

1.Open Microsoft Excel
2. Click on FILE
3. Click on OPEN
4. Find the .txt file you wish to convert by locating the correct source in Look in: and by changing the Files of type: to Text Files (*.prn; *.txt;*.csv) double click on the file so that it opens to the Text Import Wizard Step 1 of 3
5. Move the dot to Delimited and click on Next.
6. Text Import Wizard Step 2 of 3. In Delimiters remove the tick in Tab and replace it in Comma, then click Next.
7. Text Import Wizard Step 3 of 3. Leave this unchanged and click on Finish.
8. You will now be back to Excel.
9. Click on Save As.
10. Select Save as type CSV (MS-DOS) (*.csv) and name the file as you require, then click on Save.
11. When a pop up box appears saying, the file contains features that are not compatible click on yes to return to your file.
12. You are done. Congratulations. You can now use the .csv file.

Refer this links 

http://www.ehow.com/how_5793937_convert-csv-_txt-file.html

http://office.microsoft.com/en-in/excel-help/import-or-export-text-txt-or-csv-files-HP010099725.aspx (http://www.ehow.com/how_5793937_convert-csv-_txt-file.html)

Hope this will help you.

Thanks.

Praveen Murugesan
anitha12anitha12
Thanks for the Reply Praveen.

I have a Question, Whether the server log files same as our debug log file are in text file or in other format.


Thanks,
Anitha
praveen murugesanpraveen murugesan
Anitha,

I dont have experience on server log files. can you send some files to this mail id ppraveenm@gmail.com I will check and let you know.

Thanks.