been a while.. After a few years I have another little project that I would like to handle in Livecode. Before I code away I wanted to see if anyone has done that before or maybe has some good advice.
What I need to do:
My client gets regular accounting files from a system in Sage 50 (Switzerland) format. The call it TAF or BeamNT and it's quite ugly.
To import it to my accounting system I need either a proper CSV file or an XML.
Example
Code: Select all
{Blg Date=14.06.2019 Orig=0 MType=1
{Bk AccId=6940 Type=0 CAcc=1021 ValNt=22.61 ValFW=22.54 Text="Vergütung: I_06.06.2019" }
{Bk AccId=1021 Type=1 CAcc=6940 ValNt=22.61 ValFW=22.54 Text="Vergütung: I_06.06.2019" }
}
{Blg Date=21.06.2019 Orig=0 MType=2
{Bk AccId=2001 Type=0 CAcc=Div ValNt=80858.15 ValFW=81369.10 Text="OP-Ausgleich Ultimate " Text2=" B.V.B.A." }
{Bk AccId=2001 Type=0 CAcc=2001 ValNt=19479.20 ValFW=19552.25 Text="OP-Ausgleich Ultimate " Text2=" B.V.B.A." }
{Bk AccId=2001 Type=0 CAcc=2001 ValNt=60188.22 ValFW=60446.40 Text="OP-Ausgleich Ultimate " Text2=" B.V.B.A." }
{Bk AccId=2001 Type=0 CAcc=2001 ValNt=47663.42 ValFW=47881.05 Text="OP-Ausgleich Ultimate " Text2=" B.V.B.A." }
{Bk AccId=2001 Type=0 CAcc=2001 ValNt=54286.33 ValFW=54588.85 Text="OP-Ausgleich Ultimate " Text2=" B.V.B.A." }
{Bk AccId=2001 Type=0 CAcc=2001 ValNt=42969.75 ValFW=43395.20 Text="OP-Ausgleich Ultimate " Text2=" B.V.B.A." }
{Bk AccId=1021 Type=1 CAcc=2001 ValNt=304409.38 ValFW=307232.85 Text="Bank ZKB USD (aus) Di" Text2="amonds B.V.B.A., Antwe" }
{Bk AccId=4296 Type=1 CAcc=2001 ValNt=1035.69 Text="Kursgewinn Ultimate B" Text2=".V.B.A." }
}
{Blg Date=26.06.2019 Orig=0 MType=2
{Bk AccId=1100 Type=0 CAcc=Div ValNt=119.55 Text="Rg Torres, Würenlos: / I/Best" Text2="ellung per Telefon" }
{Bk AccId=3200 Type=1 CAcc=1100 TaxId=USt77 ValBt=118.47 MkTxB=1 Text="Rg Torres, Würenlos: / I/Best" Text2="ellung per Telefon" }
{Bk AccId=3292 Type=1 CAcc=1100 TaxId=USt77 ValBt=1.08 MkTxB=1 Text="Rg Torres, Würenlos: / I/Best" Text2="ellung per Telefon" }
}
- "Spaces" used to separate information, but also within the text where spaces are a nice thing
- order of different data is different, e.g. TaxID in last sample doesn't show up in the others
- don't know yet, if all "Type" are necessary, to me it looks like lines with Type=0 are probably not need for simple bookings
- no information on what currency those ValFW (foreign currency) bookings actually are, must be deducted from the accounts currency (2001) in the software
- other stuff..
What would help me greatly is a result like this as a CSV, I can then use this csv with an existing converter to map accounts and taxCodes to my System
Code: Select all
id,date,acc,cacc,valFW,ValNt,TaxID,text1,text2,currency
1,14.6.2019,6940,1020,22.61,22.54,"Vergütung: I_06.06.2019",,"USD"
2...
Your input is very much appreciated!
Thanks Pascal