Exportd how to handle it

Community Support
1

Hello,
maybe someone help me.
I try to exportd from one type of object without conditions but according to my own field scheme

image

Task to do is a text field
Completed is a checkbox
Flagship company and Backup company are a reference fields
Start Date and End Date are date fields

After first run i got csv i show You first two lines bellow

CSV detail

Task to do;Completed;Flagship company;Backup company;Start Date;End Date
Cleaning in Drezno;False;{‘id’: 643, ‘fields’: {‘nazwa-podwykonawcy’: ‘Company 3’, ‘url’: ‘’, ‘osoba-kontaktowa’: ‘Gil Person’, ‘telefon-kontaktowy’: ‘+49 12 213 25 25’, ‘adres-mailowy’: ‘first.person@company.de’}};{‘id’: 119, ‘fields’: {‘nazwa-podwykonawcy’: ‘Company 2’, ‘url’: ‘’, ‘osoba-kontaktowa’: ‘Test Tes’, ‘telefon-kontaktowy’: ‘+12 15 251 33 22’, ‘adres-mailowy’: ‘test.tes@oirkf.eu’}};2020-05-26 00:00:00;2020-05-27 00:00:00

and in table

Task to do Completed Flagship company Backup company Start Date End Date
Cleaning in Drezno False {‘id’: 643, ‘fields’: {‘nazwa-podwykonawcy’: ‘Company 3’, ‘url’: ‘’, ‘osoba-kontaktowa’: ‘Gil Person’, ‘telefon-kontaktowy’: ‘+49 12 213 25 25’, ‘adres-mailowy’: ‘first.person@company.de’}} {‘id’: 119, ‘fields’: {‘nazwa-podwykonawcy’: ‘Company 2’, ‘url’: ‘’, ‘osoba-kontaktowa’: ‘Test Tes’, ‘telefon-kontaktowy’: ‘+12 15 251 33 22’, ‘adres-mailowy’: ‘test.tes@oirkf.eu’}} 2020-05-26 00:00 2020-05-27 00:00

Now I mean one reference field Flagship company
which in csv i see like a

{‘id’: 643, ‘fields’: {‘nazwa-podwykonawcy’: ‘Company 3’, ‘url’: ‘’, ‘osoba-kontaktowa’: ‘Gil Person’, ‘telefon-kontaktowy’: ‘+49 12 213 25 25’, ‘adres-mailowy’: ‘first.person@company.de’}}

For me is important how can i get from this string only value:
Company 3 Gil Person - in one column

So i want to have to line like this:

Task to do;Completed;Flagship company;Backup company;Start Date;End Date
Cleaning in Drezno;False;Company 3 Gil Person;Company 2 Test Tes;2020-05-26 00:00;2020-05-27 00:00

Is it possible?

I tried different ways but so far I couldn’t do it

I currently have this field described as such
image
{{fields[“flagship-company”]}}

Someone help me how it should be for my needs?

2

Hi @marcinw,

try the following value for the variable:
{{fields[“flagship-company“][“fields“][“nazwa-podwykonawcy“]}} {{fields[“flagship-company“][“fields“][“osoba-kontaktowa“]}}

3

Hi @mbatz,
It works great,
thank You

1 Like
4

I checked the program logs today.
I do such inventories and I noticed that the exportd.log logs show warnings when exportd job with this variable is runing:

i gets warnings like this:
[WARNING ] — ‘str object’ has no attribute ‘fields’ (exporter_base.py)

and I get as many warnings as there are empty (not filled) fields in objects
so if i get csv with objects and object has not filled one field i got one Warnings
and similiar when i have 3 objectes in which even if one field is not filled i get 3 warnings
should warnings appear in these cases?

5

Hi @marcinw,

that warnings are ok, but not really nice. They appear, if a reference can not be resolved. This is not a big problem, but we should suppress them in a future release.

6

Thanks for understanding my conclusion and addressing the topic in future