Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Failed to process GCP CSV #354

Open
Maxlotl opened this issue Jun 23, 2024 · 2 comments
Open

Failed to process GCP CSV #354

Maxlotl opened this issue Jun 23, 2024 · 2 comments

Comments

@Maxlotl
Copy link

Maxlotl commented Jun 23, 2024

Describe the bug
I'm running the following command:
focus-converter convert --provider gcp --data-path ./gcp/bq_gcp_export.csv --data-format csv --export-path ./output/

where ./gcp/bq_gcp_export.csv is a result of export of finantial report from GCP bigquery.
Unfortunately, I get an error:
StructFieldNotFoundError: zone

To Reproduce
Steps to reproduce the behavior:

  1. focus-converter version 3.0.3
  2. Run conversion command on the attached csv
    bq_gcp_export.csv

Expected behavior
Conversion works well (especially on zone field which is not a struct, but a subfield of location)

Screenshots
Screenshot 2024-06-23 at 12 41 03
Screenshot 2024-06-23 at 12 41 20
Screenshot 2024-06-23 at 12 41 37
Screenshot 2024-06-23 at 12 41 55
Screenshot 2024-06-23 at 12 42 08

Desktop (please complete the following information):

  • OS: [e.g. iOS]
    ProductName: macOS
    ProductVersion: 13.4.1
    ProductVersionExtra: (c)
    BuildVersion: 22F770820d
  • Converter version 3.0.3
  • Focus Spec Version: focus-converter installed with pip

Additional context
Add any other context about the problem here.

@mirusky
Copy link

mirusky commented Jul 3, 2024

See #346, probably you got the wrong file.

@hemanathr
Copy link

Issue Description

When running the GCP converter command, an error is encountered indicating a missing field zone. The error message and command used are provided below.

Command Used

focus-converter convert --provider gcp --data-path path/to/gcp/data/ --data-format format --export-path /tmp/output/

Error Message
image

Steps to Reproduce

  1. Use the command provided above with the appropriate data path and format.
  2. Observe the error related to the missing zone field.

Expected Behavior

The command should execute successfully without errors.

Actual Behavior

The command fails with a StructFieldNotFoundError for the zone field.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants