8000 [ADD] base_import FAQ · asantos82/documentation-user@0ff2696 · GitHub
[go: up one dir, main page]
Skip to content

Commit 0ff2696

Browse files
csnauwaerttivisse
csnauwaert
authored and
tivisse
committed
[ADD] base_import FAQ
1 parent 27388c8 commit 0ff2696

12 files changed

+497
-1
lines changed

‎_static/example_files/External_id_3rd_party_application_product_categories.csv

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
External ID,Name,Parent Category/External ID
2+
a1,Expenses,product.product_category_all
3+
a2,Other Products,product.product_category_all
4+
a3,Sellable Products,product.product_category_all
5+
a4,Tables,a1
6+
a5,Seating furniture,a2

‎_static/example_files/External_id_3rd_party_application_products.csv

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
External ID,Name,Internal Reference,Category/External ID,Can be Expensed,Can be Purchased,Can be Sold,Sale Price,Cost,Supply Method,Product Type,Procurement Method
2+
a6,Aluminum Stool,ALS,a5,False,True,True,49.00,25.00,Buy,Stockable Product,Make to Stock
3+
a7,Chair,CHR,a5,False,True,True,89.00,40.00,Buy,Stockable Product,Make to Stock
4+
a8,Table,TBL,a4,False,True,True,169.00,100.00,Buy,Stockable Product,Make to Stock
5+
a9,Software Book Tutorial,SBT,a2,False,True,False,19.00,8.00,Buy,Consumable,Make to Stock
6+
a10,Fuel,FL,a1,True,False,False,0.30,0.25,Buy,Service,Make to Stock

‎_static/example_files/database_import_test.sql

Lines changed: 155 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,155 @@
1+
--
2+
-- PostgreSQL database dump
3+
--
4+
5+
SET statement_timeout = 0;
6+
SET client_encoding = 'UTF8';
7+
SET standard_conforming_strings = off;
8+
SET check_function_bodies = false;
9+
SET client_min_messages = warning;
10+
SET escape_string_warning = off;
11+
12+
SET search_path = public, pg_catalog;
13+
14+
SET default_tablespace = '';
15+
16+
SET default_with_oids = false;
17+
18+
--
19+
-- Name: companies; Type: TABLE; Schema: public; Owner: fp; Tablespace:
20+
--
21+
22+
CREATE TABLE companies (
23+
id integer NOT NULL,
24+
company_name character varying
25+
);
26+
27+
28+
ALTER TABLE public.companies OWNER TO fp;
29+
30+
--
31+
-- Name: companies_id_seq; Type: SEQUENCE; Schema: public; Owner: fp
32+
--
33+
34+
CREATE SEQUENCE companies_id_seq
35+
START WITH 1
36+
INCREMENT BY 1
37+
NO MAXVALUE
38+
NO MINVALUE
39+
CACHE 1;
40+
41+
42+
ALTER TABLE public.companies_id_seq OWNER TO fp;
43+
44+
--
45+
-- Name: companies_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fp
46+
--
47+
48+
ALTER SEQUENCE companies_id_seq OWNED BY companies.id;
49+
50+
51+
--
52+
-- Name: companies_id_seq; Type: SEQUENCE SET; Schema: public; Owner: fp
53+
--
54+
55+
SELECT pg_catalog.setval('companies_id_seq', 3, true);
56+
57+
58+
--
59+
-- Name: persons; Type: TABLE; Schema: public; Owner: fp; Tablespace:
60+
--
61+
62+
CREATE TABLE persons (
63+
id integer NOT NULL,
64+
company_id integer,
65+
person_name character varying
66+
);
67+
68+
69+
ALTER TABLE public.persons OWNER TO fp;
70+
71+
--
72+
-- Name: persons_id_seq; Type: SEQUENCE; Schema: public; Owner: fp
73+
--
74+
75+
CREATE SEQUENCE persons_id_seq
76+
START WITH 1
77+
INCREMENT BY 1
78+
NO MAXVALUE
79+
NO MINVALUE
80+
CACHE 1;
81+
82+
83+
ALTER TABLE public.persons_id_seq OWNER TO fp;
84+
85+
--
86+
-- Name: persons_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fp
87+
--
88+
89+
ALTER SEQUENCE persons_id_seq OWNED BY persons.id;
90+
91+
92+
--
93+
-- Name: persons_id_seq; Type: SEQUENCE SET; Schema: public; Owner: fp
94+
--
95+
96+
SELECT pg_catalog.setval('persons_id_seq', 4, true);
97+
98+
99+
--
100+
-- Name: id; Type: DEFAULT; Schema: public; Owner: fp
101+
--
102+
103+
ALTER TABLE ONLY companies ALTER COLUMN id SET DEFAULT nextval('companies_id_seq'::regclass);
104+
105+
106+
--
107+
-- Name: id; Type: DEFAULT; Schema: public; Owner: fp
108+
--
109+
110+
ALTER TABLE ONLY persons ALTER COLUMN id SET DEFAULT nextval('persons_id_seq'::regclass);
111+
112+
113+
--
114+
-- Data for Name: companies; Type: TABLE DATA; Schema: public; Owner: fp
115+
--
116+
117+
COPY companies (id, company_name) FROM stdin;
118+
1 Bigees
119+
2 Organi
120+
3 Boum
121+
\.
122+
123+
124+
--
125+
-- Data for Name: persons; Type: TABLE DATA; Schema: public; Owner: fp
126+
--
127+
128+
COPY persons (id, company_id, person_name) FROM stdin;
129+
1 1 Fabien
130+
2 1 Laurence
131+
3 2 Eric
132+
4 3 Ramsy
133+
\.
134+
135+
136+
--
137+
-- Name: companies_pkey; Type: CONSTRAINT; Schema: public; Owner: fp; Tablespace:
138+
--
139+
140+
ALTER TABLE ONLY companies
141+
ADD CONSTRAINT companies_pkey PRIMARY KEY (id);
142+
143+
144+
--
145+
-- Name: persons_company_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: fp
146+
--
147+
148+
ALTER TABLE ONLY persons
149+
ADD CONSTRAINT persons_company_id_fkey FOREIGN KEY (company_id) REFERENCES companies(id);
150+
151+
152+
--
153+
-- PostgreSQL database dump complete
154+
--
155+

‎_static/example_files/m2m_customers_tags.csv

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
Name,Reference,Tags,Customer,Street,City,Country
2+
Credit & Leasing,3,Services,True,Central Avenue 814,Johannesburg,South Africa
3+
Services & Finance,5,"Consultancy Services,IT Services",True,Grove Road 5,London,United Kingdom
4+
Hydra Supplies,6,"Manufacturer,Retailer",True,Palm Street 9,Los Angeles,United States
5+
Bolts & Screws,8,"Wholesaler,Components Buyer",True,Rua Américo 1000,Campinas,Brazil
6+
National Parts & Supplies,18,"Manufacturer,Wholesaler",True,Guangdong Way 20,Shenzen,China

‎_static/example_files/o2m_customers_contacts.csv

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,9 @@
1+
Name,Is a company,Related company,Address type,Customer,Supplier,Street,ZIP,City,State,Country
2+
Aurora Shelves,1,,,1,0,25 Pacific Road,95101,San José,CA,United States
3+
Roger Martins,0,Aurora Shelves,Invoice address,1,0,27 Pacific Road,95102,San José,CA,United States
4+
House Sales Direct,1,,,1,0,104 Saint Mary Avenue,94059,Redwood,CA,United States
5+
Yvan Holiday,0,House Sales Direct,Contact,1,0,104 Saint Mary Avenue,94060,Redwood,CA,United States
6+
Jack Unsworth,0,House Sales Direct,Invoice address,1,0,227 Jackson Road,94061,Redwood,CA,United States
7+
Michael Mason,0,,,1,0,16 5th Avenue,94104,San Francisco,CA,United States
8+
International Wood,1,,,1,0,748 White House Boulevard,20004,Washington,DC,United States
9+
Sharon Pecker,0,International Wood,Invoice address,1,0,755 White House Boulevard,20005,Washington,DC,United States

‎_static/example_files/o2m_purchase_order_lines.csv

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
Order Date,Order Reference,Supplier,Destination,Pricelist,Order Lines / Product,Order Lines / Quantity
2+
2012-12-15,PO00008,ASUSTeK,Stock,Default Purchase Pricelist,ADPT,20
3+
,,,,,CARD,30
4+
,,,,,C-Case,40
5+
2012-12-15,PO00009,Axelor,Stock,Default Purchase Pricelist,CD,5
6+
,,,,,CPUa8,15
7+
2012-12-15,PO000010,China Export,Stock,Default Purchase Pricelist,HDD SH-1,10
8+
,,,,,HDD SH-2,20
9+
,,,,,LAP-CUS,35
10+
,,,,,LAP-E5,40

‎_static/example_files/purchase.order_functional_error_line_cant_adpat.csv

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
"Order Reference","Supplier","Destination","Pricelist","Order Lines / Product","Order Lines / Quantity"
2+
"PO000020","ASUSTeK","Stock","Default Purchase Pricelist","ADPT",20
3+
,,,,"CARD",30
4+
,,,,"C-Case",40
5+
"PO000021","Axelor","Stock","Default Purchase Pricelist","CD",5
6+
,,,,"CPUa8",15

‎applications.rst

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -15,5 +15,6 @@ Applications
1515
project
1616
getting_started/documentation
1717
website
18+
general
1819
.. expenses
1920
.. recruitment

‎conf.py

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -235,7 +235,7 @@
235235
#latex_show_pagerefs = False
236236

237237
# If true, show URL addresses after external links.
238-
latex_show_urls = True
238+
# latex_show_urls = True
239239

240240
# Documents to append as an appendix to all manuals.
241241
#latex_appendices = []

‎general.rst

Lines changed: 8 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,8 @@
1+
=======
2+
General
3+
=======
4+
5+
.. toctree::
6+
:titlesonly:
7+
8+
general/base_import

0 commit comments

Comments
 (0)
0