Name | spedpyutils JSON |
Version |
0.0.3
JSON |
| download |
home_page | None |
Summary | Biblioteca para visualização de um arquivo sped em estrutura de tabelas hierarquicas. Compatibilidade com a biblioteca python-sped |
upload_time | 2024-08-10 19:35:03 |
maintainer | None |
docs_url | None |
author | Ismael Nascimento |
requires_python | None |
license | MIT License |
keywords |
sped
fiscal
receita
federal
|
VCS |
|
bugtrack_url |
|
requirements |
No requirements were recorded.
|
Travis-CI |
No Travis.
|
coveralls test coverage |
No coveralls.
|
# SPED para python
Biblioteca para visualização de um arquivo sped em estrutura de tabelas do Pandas.
Utiliza o relacionamento hierarquico tÃpico da estrutura do SPED FISCAL (EFD, ECD e entre outros)
A ideia seria visualizar em formato de tabela todas as informações de um registro e seus registros pais, por exemplo:
from sped.efd.icms_ipi.arquivos import ArquivoDigital
from spedpyutils.biddings.hierarquical_schema import HierarquicalSchema
from spedpyutils.arquivo_digital_handler import ArquivoDigitalHandler
arq = ArquivoDigital()
arq.readfile("efd.txt")
parser = XmlParser()
schema = parser.parse("schema-sample1.xml", HierarquicalSchema)
test = ArquivoDigitalHandler(arq, schema)
#test.to_excel("output.xlsx")
df = test.getTable("C170")
print(df)
Resultaria numa saÃda do tipo:
0000 NOME DT_INI DT_FIN CNPJ C100 COD_PART COD_MOD SER NUM_DOC VLR_DOC C170 COD_ITEM VLR_ITEM
0000 EMPRESAX 01/01/2024 31/01/2024 11.111.111/0001-91 C100 PART1 55 001 1111 1000,00 C170 PRODA 800,00
0000 EMPRESAX 01/01/2024 31/01/2024 11.111.111/0001-91 C100 PART1 55 001 1111 1000,00 C170 PRODB 200,00
0000 EMPRESAX 01/01/2024 31/01/2024 11.111.111/0001-91 C100 PART1 55 001 1112 300,00 C170 PRODC 300,00
Exemplo do arquivo schema-sample1.xml:
<hierarquical-schema name="EFD" version="v1.0">
<tables-list>
<table id="0000" description="Abertura" index="DT_INI|DT_FIN">
<column name="NOME"/>
<column name="CNPJ"/>
<column name="UF"/>
<column name="DT_INI" type="datetime" dateformat="%d/%m/%Y"/>
<column name="DT_FIN" type="datetime" dateformat="%d/%m/%Y"/>
</table>
<table id="C100" description="E_S" parent="0000" index="COD_MOD|SER|NUM_DOC">
<column name="IND_OPER"/>
<column name="IND_EMIT"/>
<column name="COD_PART"/>
<column name="COD_MOD"/>
<column name="COD_SIT"/>
<column name="SER"/>
<column name="NUM_DOC"/>
<column name="DT_DOC" type="datetime" dateformat="%d/%m/%Y"/>
<column name="VL_DOC" type="decimal" />
</table>
<table id="C170" description="Itens" parent="C100">
<column name="NUM_ITEM"/>
<column name="COD_ITEM"/>
<column name="QTD" type="decimal"/>
<column name="UNID"/>
<column name="VL_ITEM" type="decimal" />
<column name="CFOP"/>
<column name="CST_ICMS"/>
<column name="VL_BC_ICMS" type="decimal" />
<column name="ALIQ_ICMS" type="decimal" />
<column name="VL_ICMS" type="decimal" />
<column name="VL_BC_ICMS_ST" type="decimal" />
<column name="ALIQ_ST" type="decimal" />
<column name="VL_ICMS_ST" type="decimal" />
<column name="VL_IPI" type="decimal" />
</table>
</tables-list>
</hierarquical-schema>
## Requisitos
- xsdata
- spedpy
- pandas
## Como instalar
$ pip install spedpyutils
Raw data
{
"_id": null,
"home_page": null,
"name": "spedpyutils",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": "sped fiscal receita federal",
"author": "Ismael Nascimento",
"author_email": "ismaelnjr@icloud.com.br",
"download_url": "https://files.pythonhosted.org/packages/06/3d/450c0520eb8f4b241a1021d3c56fa2b3529207476867bd7ca093f609d9d1/spedpyutils-0.0.3.tar.gz",
"platform": null,
"description": "# SPED para python\r\n\r\nBiblioteca para visualiza\u00c3\u00a7\u00c3\u00a3o de um arquivo sped em estrutura de tabelas do Pandas.\r\nUtiliza o relacionamento hierarquico t\u00c3\u00adpico da estrutura do SPED FISCAL (EFD, ECD e entre outros)\r\n\r\nA ideia seria visualizar em formato de tabela todas as informa\u00c3\u00a7\u00c3\u00b5es de um registro e seus registros pais, por exemplo:\r\n\r\n from sped.efd.icms_ipi.arquivos import ArquivoDigital\r\n from spedpyutils.biddings.hierarquical_schema import HierarquicalSchema\r\n from spedpyutils.arquivo_digital_handler import ArquivoDigitalHandler\r\n \r\n arq = ArquivoDigital() \r\n arq.readfile(\"efd.txt\") \r\n\r\n parser = XmlParser()\r\n schema = parser.parse(\"schema-sample1.xml\", HierarquicalSchema)\r\n\r\n test = ArquivoDigitalHandler(arq, schema)\r\n #test.to_excel(\"output.xlsx\")\r\n df = test.getTable(\"C170\")\r\n print(df)\r\n\r\nResultaria numa sa\u00c3\u00adda do tipo:\r\n\r\n0000 NOME DT_INI DT_FIN CNPJ C100 COD_PART COD_MOD SER NUM_DOC VLR_DOC C170 COD_ITEM VLR_ITEM\r\n0000 EMPRESAX 01/01/2024 31/01/2024 11.111.111/0001-91 C100 PART1 55 001 1111 1000,00 C170 PRODA 800,00 \r\n0000 EMPRESAX 01/01/2024 31/01/2024 11.111.111/0001-91 C100 PART1 55 001 1111 1000,00 C170 PRODB 200,00 \r\n0000 EMPRESAX 01/01/2024 31/01/2024 11.111.111/0001-91 C100 PART1 55 001 1112 300,00 C170 PRODC 300,00 \r\n\r\nExemplo do arquivo schema-sample1.xml:\r\n\r\n <hierarquical-schema name=\"EFD\" version=\"v1.0\">\r\n\t<tables-list>\r\n\t\t<table id=\"0000\" description=\"Abertura\" index=\"DT_INI|DT_FIN\">\r\n\t\t\t<column name=\"NOME\"/>\r\n\t\t\t<column name=\"CNPJ\"/>\r\n\t\t\t<column name=\"UF\"/>\r\n\t\t\t<column name=\"DT_INI\" type=\"datetime\" dateformat=\"%d/%m/%Y\"/>\r\n\t\t\t<column name=\"DT_FIN\" type=\"datetime\" dateformat=\"%d/%m/%Y\"/>\r\n\t\t</table>\r\n\t\t<table id=\"C100\" description=\"E_S\" parent=\"0000\" index=\"COD_MOD|SER|NUM_DOC\">\r\n\t\t\t<column name=\"IND_OPER\"/>\r\n\t\t\t<column name=\"IND_EMIT\"/>\r\n\t\t\t<column name=\"COD_PART\"/>\r\n\t\t\t<column name=\"COD_MOD\"/>\r\n\t\t\t<column name=\"COD_SIT\"/>\r\n\t\t\t<column name=\"SER\"/>\r\n\t\t\t<column name=\"NUM_DOC\"/>\r\n\t\t\t<column name=\"DT_DOC\" type=\"datetime\" dateformat=\"%d/%m/%Y\"/>\r\n\t\t\t<column name=\"VL_DOC\" type=\"decimal\" />\r\n\t\t</table>\r\n\t\t<table id=\"C170\" description=\"Itens\" parent=\"C100\">\r\n\t\t\t<column name=\"NUM_ITEM\"/>\r\n\t\t\t<column name=\"COD_ITEM\"/>\r\n\t\t\t<column name=\"QTD\" type=\"decimal\"/>\r\n\t\t\t<column name=\"UNID\"/>\r\n\t\t\t<column name=\"VL_ITEM\" type=\"decimal\" />\r\n\t\t\t<column name=\"CFOP\"/>\r\n\t\t\t<column name=\"CST_ICMS\"/>\r\n\t\t\t<column name=\"VL_BC_ICMS\" type=\"decimal\" />\r\n\t\t\t<column name=\"ALIQ_ICMS\" type=\"decimal\" />\r\n\t\t\t<column name=\"VL_ICMS\" type=\"decimal\" />\r\n\t\t\t<column name=\"VL_BC_ICMS_ST\" type=\"decimal\" />\r\n\t\t\t<column name=\"ALIQ_ST\" type=\"decimal\" />\r\n\t\t\t<column name=\"VL_ICMS_ST\" type=\"decimal\" />\r\n\t\t\t<column name=\"VL_IPI\" type=\"decimal\" />\r\n\t\t</table>\t\t\r\n\t</tables-list>\r\n </hierarquical-schema>\r\n\r\n## Requisitos\r\n\r\n- xsdata\r\n- spedpy\r\n- pandas\r\n\r\n## Como instalar\r\n\r\n $ pip install spedpyutils\r\n",
"bugtrack_url": null,
"license": "MIT License",
"summary": "Biblioteca para visualiza\u00e7\u00e3o de um arquivo sped em estrutura de tabelas hierarquicas. Compatibilidade com a biblioteca python-sped",
"version": "0.0.3",
"project_urls": null,
"split_keywords": [
"sped",
"fiscal",
"receita",
"federal"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "063d450c0520eb8f4b241a1021d3c56fa2b3529207476867bd7ca093f609d9d1",
"md5": "b3296edf30490bef8aeabd3d49465786",
"sha256": "0e281e7fb41d9c228acb0d9ff4645de3006fe1790b936a5f2ea2d4cf16a91f02"
},
"downloads": -1,
"filename": "spedpyutils-0.0.3.tar.gz",
"has_sig": false,
"md5_digest": "b3296edf30490bef8aeabd3d49465786",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 7002,
"upload_time": "2024-08-10T19:35:03",
"upload_time_iso_8601": "2024-08-10T19:35:03.153979Z",
"url": "https://files.pythonhosted.org/packages/06/3d/450c0520eb8f4b241a1021d3c56fa2b3529207476867bd7ca093f609d9d1/spedpyutils-0.0.3.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-08-10 19:35:03",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "spedpyutils"
}