# Re: updating articles from csv \[was: Re: Everyone on gmail is receiving the messages, but no one else is.\]

**URL:** <https://forum.foodcoops.net/t/re-updating-articles-from-csv-was-re-everyone-on-gmail-is-receiving-the-messages-but-no-one-else-is/350>\
**Category:** Foodsoft Help\
**Created:** [September 29, 2014, 7:14am UTC](https://forum.foodcoops.net/t/re-updating-articles-from-csv-was-re-everyone-on-gmail-is-receiving-the-messages-but-no-one-else-is/350 "2014-09-29T07:14:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![wvengen](https://forum.foodcoops.net/user_avatar/forum.foodcoops.net/wvengen/32/4_2.png) [@wvengen](https://forum.foodcoops.net/u/wvengen)\
**Post date:** [September 29, 2014, 7:14am UTC](https://forum.foodcoops.net/t/re-updating-articles-from-csv-was-re-everyone-on-gmail-is-receiving-the-messages-but-no-one-else-is/350/1 "2014-09-29T07:14:09Z")

</div>

Hi Angelo,

Good steps!

In Germany and at FoodCoopNL we use the “external database” option,  
found on top of the supplier list (which should really become a  
preference to enable or not within Foodsoft). This works with the  
sharedlists application, which manages supplier article information. It  
also contains methods to synchronise this with supplier (there is a  
German standard using FTP, and in NL we parse email attachments).  
[https://github.com/bennibu/sharedlists](https://github.com/bennibu/sharedlists) (Germany)  
[https://github.com/foodcoop-adam/sharedlists](https://github.com/foodcoop-adam/sharedlists) (NL)  
In the NL repository, look at the lib/\*\_file.rb files for a number of  
import formats (it may take some heuristics to parse article information  
from the spreadsheets that some farmers send).

Another way would be to use the upload articles functionality in  
Foodsoft. It wouldn’t be hard to add support for different file formats  
(just like sharedlists has now). Then, after writing an import filter,  
you could upload articles directly from the csv (bonus if #113  
[https://github.com/foodcoops/foodsoft/issues/113](https://github.com/foodcoops/foodsoft/issues/113) were fixed to allow  
updating articles too). The “make articles (un)available” option would  
be useful here.

- Willem

---

<div class="post-metadata">

**Author:** ![angelo](https://forum.foodcoops.net/user_avatar/forum.foodcoops.net/angelo/32/5_2.png) [@angelo](https://forum.foodcoops.net/u/angelo)\
**Post date:** [October 6, 2014, 7:47pm UTC](https://forum.foodcoops.net/t/re-updating-articles-from-csv-was-re-everyone-on-gmail-is-receiving-the-messages-but-no-one-else-is/350/2 "2014-10-06T19:47:23Z")

</div>

> It also contains methods to synchronise this with supplier

I thought it was just a way for users to share the work they did on rearranging supplier’s databases to fit with foodsoft.

Our biggest supplier at the moment has as a huge database which is organized in the way I described in my older post about csv upload. Could sharedlists help with this?

[http://foodsoft.51229.x6.nabble.com/file/n307/foodsoft\_azure.png](http://foodsoft.51229.x6.nabble.com/file/n307/foodsoft_azure.png)

---

<div class="post-metadata">

**Author:** ![wvengen](https://forum.foodcoops.net/user_avatar/forum.foodcoops.net/wvengen/32/4_2.png) [@wvengen](https://forum.foodcoops.net/u/wvengen)\
**Post date:** [October 6, 2014, 10:50pm UTC](https://forum.foodcoops.net/t/re-updating-articles-from-csv-was-re-everyone-on-gmail-is-receiving-the-messages-but-no-one-else-is/350/3 "2014-10-06T22:50:05Z")

</div>

There are three options:
