Friday, November 15, 2013

How to Import Data to a Google Sites List Page

I discovered a script written by Romain Vialard that processes exporting/importing of data from/to a Google Sites List page using a Google Docs spreadsheet. If you would like to take advantage of Sites List features and formatting and have a long table of data to import, then the script is a real time saver. You can also export data from a Sites List page into the spreadsheet that contains the script. 
  • Create a new Google spreadsheet and choose Tools > Script Editor
  • Choose Spreadsheet under Create a Script For
  • Remove the sample script from Code.gs
  • Copy the script from this forum post and paste it into Code.gs
  • Name the project (e.g. Google Sites Export Import) and choose File > Save.
  • Under Select Function you will see (OnOpen, create_list, push_items, and fetch_items). 
  • Close the spreadsheet and re-open and there will be a new List page menu with the choices to Create a list or Fetch list items
  • To create a List page within your site choose List page > Create list. You may need to authorize the app to run. If so, choose List page > Create list again.
  • Provide the URL of the parent page (e.g. http://sites.google.com/site/joefahs/demographics) under which the list page will be created. 
  • Choose a name for your list page (e.g. countries). 
  • Wait patiently for the script to execute. 
  • Go to your page address (e.g. http://sites.google.com/site/joefahs/demographics/countries) to see your automatically created list page. Note! If the script is not available in the List page menu choose Tools > Script Manager and run your scripts from there. 
  • Push items will push data from the spreadsheet into an existing List page replacing the existing data in that list.  
  • You can retrieve data from a list page and put them in the spreadsheet by choosing the script Fetch Items. It will will require the list page's URL and number of columns and will import the data but not the header. You will need to add the headers in the spreadsheet and then sort as needed. 


12 comments:

  1. I have read your blog. I like this tutorial because is very simple and easy to understand. Thanks for valuable information sharing. If you have a small business, then it is sure that you find it hard to get information on import data.

    ReplyDelete
  2. Import Data consists of appropriate shipping records to observe shipments that enter the USA. Generally, it includes name & description of an item, HS code, date and time of shipment, port origin, net weight, price, amount, contact details of importers & exporters etc. This data makes it easy to keep an eye on trading movements of your rivals in the United States of America. Plus, it will allow searching potential buyers or suppliers for your products
    https://www.seair.co.in/hdpe-granule-import-data.aspx
    Add:- B-1/E3 , 2nd Floor, Mohan Cooperative State
    New Delhi 110044
    No:-011-41325515 ,011-41325516

    ReplyDelete
  3. Generally, it includes name & description of an item, HS code, date and time of shipment, port origin, net weight, price, amount, contact details of importers & exporters etc. This data makes it easy to keep an eye on trading movements of your rivals in the United States of America. Plus, it will allow searching potential buyers or suppliers for your products so that you can sell or purchase goods at the best prices.
    https://www.seair.co.in/hdpe-regrind-import-data.aspx
    Add:- B-1/E3 , 2nd Floor, Mohan Cooperative State
    New Delhi 110044
    No:-011-41325515 ,011-41325516

    ReplyDelete
  4. . This report provides a complete idea about actual data but with some limited records. In order to access entire records, you need to invest in real import data. It lets you analyze every trade activity of your opponents (who are also importing this product). Basically, this source provides information like who is importing this product, at what amount, at what price, from SEAIR Exim Solutions provide a free access to an authentic and relevant sample report of his port and many more. You may visit Seair.co.in
    https://www.seair.co.in/heat-gun-import-data.aspx
    Add:- B-1/E3 , 2nd Floor, Mohan Cooperative State
    New Delhi 110044
    No:-011-41325515 ,011-41325516

    ReplyDelete
  5. HELIUM IMPORT Data is online available on many data sharing web portals. But not all of them are trus table so you need to do proper research before taking any decision. One company has attained a great deal of attention all around and i.e. SEAIR Exim Solutions. It has been serving the best data solutions to people for the last 9 years. Don’t waste more time, just collect the data and discover your opposition to make better strategies to grow in business.
    https://www.seair.co.in/helium-import-data.aspx

    Add:- B-1/E3 , 2nd Floor, Mohan Cooperative State
    New Delhi 110044
    No:-011-41325515 ,011-41325516

    ReplyDelete
  6. As compared to other trade data sharing sources in the market, SEAIR Exim Solutions is the best. This firm provides 100% consistent, genuine, and Human Hair Import Data. It is a set of essential shipping details like HS code, item’s name, description & type, net weight, port, shipping mode etc. Before purchasing actual data, you can check out a sample report first. That report will help to get an idea what export data is all about? If you really want to observe exportation business of Human Hair Import Data then no one is a better option than export data.
    https://www.seair.co.in/human-hair-import-data.aspx

    Add:-B-1/E3 2nd Floor Mohan Cooperative State
    New Delhi 110044
    No:-011-41325515 ,011-41325516

    ReplyDelete
  7. As compared to other trade data sharing sources in the market, SEAIR Exim Solutions is the best. This firm provides 100% consistent, genuine, and Human hair EXPORT Data. It is a set of essential shipping details like HS code, item’s name, description & type, net weight, port, shipping mode etc. Before purchasing actual data, you can check out a sample report first. That report will help to get an idea what export data is all about? If you really want to observe exportation business of Human Hair Import Data then no one is a better option than export data.
    https://www.seair.co.in/human-hair-export-data.aspx

    Add:-B-1/E3 2nd Floor Mohan Cooperative State
    New Delhi 110044
    No:-011-41325515 ,011-41325516

    ReplyDelete
  8. As compared to other trade data sharing sources in the market, SEAIR Exim Solutions is the best. This firm provides 100% consistent, genuine, and IGNOT Import Data. It is a set of essential shipping details like HS code, item’s name, description & type, net weight, port, shipping mode etc. Before purchasing actual data, you can check out a sample report first. That report will help to get an idea what export data is all about? If you really want to observe exportation business of IGNOT Import Data then no one is a better option than export data.
    https://www.seair.co.in/ignot-import-data.aspx
    Add:-B-1/E3 2nd Floor Mohan Cooperative State
    New Delhi 110044
    No:-011-41325515 ,011-41325516

    ReplyDelete
  9. jasmine flower Export Data is online available on many data sharing web portals. But not all of them are trus table so you need to do proper research before taking any decision. One company has attained a great deal of attention all around and i.e. SEAIR Exim Solutions. It has been serving the best data solutions to people for the last 9 years. Don’t waste more time, just collect the data and discover your opposition to make better strategies to grow in business. Here is available main website Seair.co.in
    https://www.seair.co.in/jasmine-flower-export-data.aspx
    Add:-B-1/E3 2nd Floor Mohan Cooperative State
    New Delhi 110044
    No:-011-41325515 ,011-41325516

    ReplyDelete
  10. As compared to other trade data sharing sources in the market, SEAIR Exim Solutions is the best. This firm provides 100% consistent, genuine, and Jeweler Export Data. It is a set of essential shipping details like HS code, item’s name, description & type, net weight, port, shipping mode etc. Before purchasing actual data, you can check out a sample report first. That report will help to get an idea what export data is all about? If you really want to observe exportation business of Jeweler Export Data then no one is a better option than export data.
    https://www.seair.co.in/jeweler-export-data.aspx

    Add:- B-1/E3 , 2nd Floor, Mohan Cooperative State
    New Delhi 110044
    No:-011-41325515 ,011-41325516

    ReplyDelete
  11. Generally, it includes name & description of an item, HS code, date and time of shipment, port origin, net weight, price, amount, contact details of importers & exporters etc. This data makes it easy to keep an eye on trading movements of your rivals in Khadi Export Data it will allow searching potential buyers or suppliers for your products so that you can sell or purchase goods at the best prices
    https://www.seair.co.in/khadi-export-data.aspx
    Add:- B-1/E3 , 2nd Floor, Mohan Cooperative State
    New Delhi 110044
    No:-011-41325515 ,011-41325516

    ReplyDelete
  12. This report provides a complete idea about actual data but with some limited records Laptop IMPORT Data In order to access entire records, you need to invest in real import data. It lets you analyze every trade activity of your opponents (who are also importing this product). Basically, this source provides information like who is importing this product, at what amount, at what price, from SEAIR Exim Solutions
    https://www.seair.co.in/laptop-import-data.aspx
    Add:- B-1/E3 , 2nd Floor, Mohan Cooperative State
    New Delhi 110044
    No:-011-41325515 ,011-41325516

    ReplyDelete

 
◄Design by Pocket Distributed by Deluxe Templates