Export

From Community Weaver 3 Help
Revision as of 03:39, 19 January 2017 by Eric (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Information Available

Usually you get information from Community Weaver's database by viewing web pages such as the lists of Members, Exchanges, Birthdays and Ads. Spreadsheets contain the same information, but provide additional capability to sort, search, join, and format. You can export and download these types of spreadsheets:

  1. Members--includes address, birthday, phone, dates, and a summary of offers, exchanges, and requests
  2. Exchanges--includes title, category, provider, recipient, dates, and related service ad
  3. Ads (offers and requests)--includes title, body, dates, member name, category, and ad URL

Exporting

You export the information from Community Weaver's database via the lists of Members, Exchanges, or Ads using an actions pulldown. Here's how:

  1. Open a list of Members, Exchanges, or Ads.
  2. Select some members, exchanges, or ads.
  3. Click Member Actions, Exchange Actions, or Ad Actions.
  4. Click Export.

The spreadsheet will contain only the members, exchanges, or ads you selected. Tip: Community Weaver 2 was different--all rows were exported regardless of what was selected.

File Name and Format

These are the default file names:

  • Members: members.csv
  • Exchanges: exchanges.csv
  • Ads: ads.csv

Each spreadsheet is downloaded as a .csv file, which can be imported into a spreadsheet program such as Microsoft Office Excel, OpenOffice Calc, or LibreOffice Calc. The .csv format has limited formatting capability, so if you modify the downloaded spreadsheet, do not save it as a csv file but do save it as a spreadsheet. For example, save members.csv as members.xlsx (Excel) or members.ods (Calc).